Search code examples
csvwoocommercee-commerce

How to add subcategories in woo commerce product csv upload?

I am trying to upload books to my Woo Commerce site and need to have multiple subcategories per product. When I upload the CSV with categories (Parent > Subcategory 1 > Subcategory 2) they don't show up with the product. They create the 1st sub in the categories list under the parent but not on the product. And the 2nd tier of subcategories doesn't show up at all. I've also tried (parent>subcategory1>>subcatagory2) and still no luck... any suggestions?

Solution

  • If a product has multiple categories or sub-categories, they need to be seperated with '|' in the CSV, for example:

    Parent | Parent > Subcategory 1 | Parent > Subcategory 2