Steven P Posted May 31, 2007 Share Posted May 31, 2007 Hello team, I have an online shopping cart. I have around 500 new products coming in. I have an excel spreadsheet with columns, containing data such as: PRODUCT NAME - PRODUCT NUMBER - IMAGE etc The attributes would be like: AUSTIN POWERS DVD - 002239 - austen.jpg How can I upload my 500 files with ease, and how can I add different columns (ie Description, etc). Please help me - life saving! Link to comment Share on other sites More sharing options...
dittones Posted May 31, 2007 Share Posted May 31, 2007 Steve, Their is a contribution called easypopulate...which allows you to upload cvs files tab seperated...You can create this type of file using your spread sheet software...Easypopulate requires the data in the file to be in a certain format and header spelling...The way you should aproach it is locate the contribution current one for your oscommerce release... Backup your software...and follow the instructions for the install...When you installed download your file using easypopulate...open the file that you have saved on your drive with the spreadsheet software...This will give you a template of how the data should be... The module number will be treated as a unique field used for updating and adding new products...Remember to backup your database before you upload your new easypopulate file... I hope this helps and gets you started Roman dittone.com Link to comment Share on other sites More sharing options...
Steven P Posted June 1, 2007 Author Share Posted June 1, 2007 Thanks, I gave it a crack with no luck: 1146 - Table 'steve_onlineshop.TABLE_PRODUCTS_STOCK' doesn't exist select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '29' and products_stock_attributes = '3-5' [TEP STOP] :S What have I missed out on? Is it because I run STS? Steve Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted June 1, 2007 Share Posted June 1, 2007 you have the wrong version, you installed a version that is made to work with another contribution. Find v2.72 which is more basic and doesn't rely on other contributions being installed. KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt Link to comment Share on other sites More sharing options...
susitha7000 Posted September 11, 2010 Share Posted September 11, 2010 you have the wrong version, you installed a version that is made to work with another contribution. Find v2.72 which is more basic and doesn't rely on other contributions being installed. Hi I am geting the same problem. I would like to install QTPro but i am so confused what to install... since most of the down loads are not the compleet package :( can you pls tell me which one i shouls install... I got osCommerce Online Merchant v2.2 RC2a. Link to comment Share on other sites More sharing options...
Guest Posted September 11, 2010 Share Posted September 11, 2010 Ashin, USUALLY complete packages are labeled COMPLETE PACKAGE. Look for the latest complete package and read the information submitted by the contributor to see what it is they have changed. If they information provided isn't sufficient, check the change logs in the contribution for more information. Chris 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.