Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Upload Products Directly into Database


wmcius

Recommended Posts

Hi, This question regards uploading products directly into the database using PHPMyadmin.

 

I have used Easy Populate, but I have around 50,000 products and Easy Populate becomes TOO slow after loading around 10 - 20,000 products. It is my understanding that products can be loaded directly into the database by importing a text file via PHPMyadmin, however, what I would like to know is what should be the format of that file. What tables are affected and in which tables one has to enter the data for every new product.

 

I am using the following fields when uploading products (via Easy Populate):

 

v_products_model

v_products_name_1

v_date_avail

v_date_added

v_products_quantity

v_manufacturers_name

v_categories_name_1

v_status

EOREOR

 

I would appreciate if any senior folks or experts can guide me on this.

Thanks,

Link to comment
Share on other sites

You need to modify the following tables: products , products_description, products_to_categories, categories, categories_description, manufacturers, and manufacturers_info.

 

You could write a script of SQL UPDATE commands if you have an existing osc db, and save it as a text file, then run it using the browse function in the SQL tab for your database. If you don't have an existing table, you can use the .sql file from the download to create one the same way.

 

Jeremy

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...