johnb Posted May 27, 2004 Share Posted May 27, 2004 I'm an Oracle DBA getting a lot of MySQL experience here! :D We ran the oscommerce.sql script to build the database --that was easy. But how to get the product data (item descriptions, pictures, prices, etc.) into the database? I have nice Entity-Relationship (ER) diagram of the osCommerce database but need more specific information on how to load our product data. Our product data's in digital format and I would naturally like to automate the loading process. Searching for terms "load" and "loading" turned up info on page-loading times, not data loading. Any good sources of information for this? There's no O'Reilly book on osCommerce. I must say that the table and column names are reasonably self-explanatory. Good job on that. I just don't see any "binary" type field to hold photos. How is it done? Is there a script to load product data from a standard format flat file? Or? :unsure: Link to comment Share on other sites More sharing options...
vasttech Posted May 27, 2004 Share Posted May 27, 2004 You can either enter each product manually using the admin tool. If you have a bunch of products you can use the EasyPopulate contribution. Or last but not least if you are daring and pretty good with ODBC you can link to your db and load it that way. As for images they are not stored in the db. Only the path to the image is stored there. See Wiki - Documentation osCommerce Knowledge Base osCommerce Documentation Contributions Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.