Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Uploading Photos To Work With Excel Upload


tny681

Recommended Posts

I have had great success in uploading my entire excel database of products into my webstore. My issue now is how to get the photographs of each item uploaded and attached to the correct item in bulk as well. I have the url's of each image in my spreadsheet and/or have them in a folder in my public_html folder. Does anyone know how to do this in mass? (I have 6500 items to do this one by one will be impossible!). Thanks for your help.

Link to comment
Share on other sites

I have had great success in uploading my entire excel database of products into my webstore. My issue now is how to get the photographs of each item uploaded and attached to the correct item in bulk as well. I have the url's of each image in my spreadsheet and/or have them in a folder in my public_html folder. Does anyone know how to do this in mass? (I have 6500 items to do this one by one will be impossible!). Thanks for your help.

 

 

Hi

 

 

In the excl spread sheet there should be a

products_id products_quantity products_model products_image products_price products_date_added products_last_modified products_date_available products_weight products_status products_tax_class_id manufacturers_id products_ordered

 

28 100 beach1 surf3.JPG 10 16/11/2006 13:41 NULL NULL 0.1 1 0 0 0

 

 

 

 

like this . although not correct here in the layout but where surf3.jpg is the image link,, dump all the images in th eimage folder and it should populate ...I am using phpmyadmin in csv format.....

 

hope this helps'

 

cheers

Rusty

-------------------------------------------

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...