How do I map multiple categories in a CSV file

1. Use a single "Categories" column in your CSV file.

2. Separate multiple categories with commas. For example:

   Category 1, Category 2, Category 3
   

3. For subcategories, use the "greater than" symbol (>) to indicate hierarchy. For example:

   Parent Category > Subcategory
   

4. You can combine multiple categories and subcategories in the same field. For example:

   Category 1, Category 2, Parent Category > Subcategory 1, Parent Category > Subcategory 2
   

5. If a category name contains commas, wrap the entire category name in double quotes. For example:

   "Category 1, with comma", Category 2, "Parent Category > Subcategory, with comma"
   

6. When importing, make sure to map the "Categories" column in your CSV to the corresponding field in WooCommerce's importer.

7. WooCommerce will automatically create any new categories that don't already exist in your store.

8. For existing categories, use the exact category name as it appears in your WooCommerce admin to ensure proper mapping.

Remember to use UTF-8 encoding for your CSV file and avoid using Excel if possible, as it can cause formatting issues. Instead, use a text editor or Google Sheets to prepare your CSV file.

By following these guidelines, you can successfully import products with multiple categories and maintain your desired category hierarchy in WooCommerce.