Primary Category Bulk Import

Unfortunately, it is not possible to import the primary category of your products. It needs to be set manually.

@marius_codeinwp It’s really a downer as I’ll have to manually edit 1000’s of products just to set primary category
I do have WooCommerce Bulk Import Tool, maybe there’s something I’m missing? The primary category doesn’t have a meta key?

@marius_codeinwp I just looked up the database and found this meta key “_yoast_wpseo_primary_product_cat” that holds the Category ID
I now created a new column in my CSV with the header _yoast_wpseo_primary_product_cat
Can this meta key also hold the actual name of the category? (instead of the ID)

• This reply was modified 6 years, 9 months ago by dan11.

If the _yoast_wpseo_primary_product_cat column is only holding the category ID on your database, we recommend you to only include category ID in your CSV file. We also recommend you to test this on a staging site before performing this on a production site.

I’m having the same issue, I imported 600 products into a Woocommerce site and had to manually set the primary category on each individual product page. This process took hours to complete and agree with dan11 that it would be totally impractical if I had thousands of products. I only have one category set per product so maybe need a script to transfer the Category ID to the _yoast_wpseo_primary_product_cat (I’m not a developer by the way so unfortunately cannot help with this ?? )