Adding Products Directly to 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]

you can pull the info required out of easypopulate. it is your server what is starting to slow, not easypopulate.

you will need to make sure you get it right, cuz if you dont your database is toasted.

[wmcius]

you can pull the info required out of easypopulate.? it is your server what is starting to slow, not easypopulate.

you will need to make sure you get it right, cuz if you dont your database is toasted.

<{POST_SNAPBACK}>

 

Can you please explain what you mean by 'you can pull the info required out of easypopulate'? Where would I look to get that info out of easy populate?

Also, what tables are affected for the parameters I am using?

If I were to export sql from the database, which tables would I export in order to add new products?

 

Am I looking at it the right way?

Edited April 25, 2005 by wmcius

[Guest]

all the tables affected are listed in the code for easypopulate, you can follow the inserts, they show which tables are necessary to be done at the same time.