shellbeachsilver Posted October 30, 2006 Posted October 30, 2006 Hello Everyone, I installed the contribution to load products through excel : Excel Import 1.51 Ive tried to upload my excel file and im recieving this error: File uploaded. Temporary filename: /tmp/phpLEOLPH User filename: catalog.txt Size: 610043 1054 - Unknown column 'products_subimage1' in 'field list' insert into products (products_quantity,products_model, products_image, products_subimage1, products_subimage2, products_subimage3, products_subimage4, products_subimage5, products_subimage6, products_price,products_date_added, products_last_modified,products_date_available,products_weight,products_status,p roducts_tax_class_id,manufacturers_id)values(100,'BR-2712','store/PIS/BR-2712_250w.jpg','store/PIS/86.1','store/PIS/0','store/PIS/SS SIMPLE BYPASS BANGLE BRACELET','','','','','2006-10-30','2006-10-30','2006-10-30','','1',0,10) Whats going on? Help! If anyone has a template in excel I would love to try to use it. Thank you. Shelby Quote
Op999 Posted November 14, 2006 Posted November 14, 2006 I'm having the same problem, too. Any updates on what it could be? On the surface, I have named all the fields in the Excel file accordingly, and the categories and manufacturers are loading correctly. But nothing else besides that. Hello Everyone, I installed the contribution to load products through excel : Excel Import 1.51 Ive tried to upload my excel file and im recieving this error: File uploaded. Temporary filename: /tmp/phpLEOLPH User filename: catalog.txt Size: 610043 1054 - Unknown column 'products_subimage1' in 'field list' insert into products (products_quantity,products_model, products_image, products_subimage1, products_subimage2, products_subimage3, products_subimage4, products_subimage5, products_subimage6, products_price,products_date_added, products_last_modified,products_date_available,products_weight,products_status,p roducts_tax_class_id,manufacturers_id)values(100,'BR-2712','store/PIS/BR-2712_250w.jpg','store/PIS/86.1','store/PIS/0','store/PIS/SS SIMPLE BYPASS BANGLE BRACELET','','','','','2006-10-30','2006-10-30','2006-10-30','','1',0,10) Whats going on? Help! If anyone has a template in excel I would love to try to use it. Thank you. Shelby Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.