Import products

Hi @muneebkian,

When importing products into existing product categories in WooCommerce you would use the category name like in this example CSV file.

https://github.com/woocommerce/woocommerce/blob/master/sample-data/sample_products.csv

Image Link: https://cloudup.com/cOs2tT-5Jbz

Below is the documentation for the default Wooommerce product importer which offers some sample CSV files.

https://docs.woocommerce.com/document/product-csv-importer-exporter/

I have assigned all product correct term id in the following table
wp_term_relationships..

Though i can see the correct category has been assigned to each product. But under the product categories (section) the count is incorrect.

do i need to update some other table too?

• This reply was modified 4 years, 5 months ago by muneebkiani.

Hey @muneebkiani,

Performing an import with and edited test CSV file for WooCommerce I’m not seeing any discrepancies within the WooCommerce product categories which were imported.

Looking at the official WooCommerce Product Import CSV scheme I’m also not seeing any references to term_id or wp_term_relationships.

https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

Thanks for your reply, with the help of reset counter under woocommerce -> status -> tools
and
https://www.wpbeginner.com/wp-tutorials/how-to-fix-category-and-comment-count-after-wordpress-import/

Hey @muneebkiani,

That’s great to hear you’ve found a solution and have the category counts for you imports resolved.