How to specify category in CSV file

[naikm]

Hello,

I have a CSV file from which I want to import products. I want to assign these products to specific categories. I have manually created two categories. I am using phpAdmin export/import functionality to import. I am able to import products successfully. But as far as categories are concerned I am doing it manually(oen by one). Is there any way I can provide category data in CSV file itself ?

Thanks

[naikm]

In short I am not able to get column name which contains category for the products(When we import/export). Could you just let me know which field contains category ?

[naikm]

Hello,

I guess I got the answer. There is a table called

wp_wp_eStore_cat_prod_rel_tbl

which holds the relationship which can be loaded to set categories.

In case you have any other solution which requires changing only one table let me know

[admin]

Hi, You do need to populate the eStore_cat_prod_rel_tbl table to assign categories to products so you are doing it correctly.

[Author]

Posts