Upload Products Directly into Database

[wmcius]

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,

[Guest]

please, no double posting . .

[Jeremy at oddly enough]

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