Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Excel to store front end


turpialito

Recommended Posts

Hi, all. I have a very simple Excel spreadsheet consisting of 4000+ rows and two columns: a product ID number on column "A", followed by product name in column "B". I have successfully uploaded it to a MySQL database, but now I need to make it show up on my store's categories/products page. What's next?

Link to comment
Share on other sites

Before you upload the excel file you need to specify the category of each product.

 

Remember you will use 3 table: tblcategories, tblcategories_products and tblproducts.

 

You can specify the name of your category on your excel file or the category id.

 

Hope it;s help

Erwin D. Padilla

Web Developer and Linux Admin

Link to comment
Share on other sites

ty, will try!

 

 

Before you upload the excel file you need to specify the category of each product.

 

Remember you will use 3 table: tblcategories, tblcategories_products and tblproducts.

 

You can specify the name of your category on your excel file or the category id.

 

Hope it;s help

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...