web123 Posted January 4, 2005 Posted January 4, 2005 I have spent the last few days here learning and here is my first post and if this covered already, I am sorry but endless search results brought up nothing, which surprised me! My client has their own Excel database of the products, parts and accessories. I use this application becuase I am a front end person and although I have so far customised many pages, I have nno idea about importing a database. I can only assume I do not have to manually add each product. I am hoping for a userfriendly way as my client will do this once I have set up the cart. thanks :-" Can you do with an extra $3,000 a year? Click here to join.... I did and I love the commissions each month!
ScaleCreep Posted January 4, 2005 Posted January 4, 2005 EasyPopulate, a free script in the "Contributions" section will let you do this. I myself am a non-techie and have managed to get it working in just an hour or two. What I have to do now is rearrange my Excel list. Basically, you have to rearrange the data to fit the column headings for this script. I'm sure there's a better way than what I'm going to do - basically cut and paste. But with just 100 items so far, it should be very easy to do. Good luck.
peterr Posted January 4, 2005 Posted January 4, 2005 Hi, If EasyPopulate is not adeqaute for some reason, you can always simply save the Excel file to CSV format, then use fgetcsv to load the data into osCommerce. For products, you only have 2 tables to load, products and products_description. Peter
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.