Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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

  • 3 weeks later...
Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...