Bulk Category Editor

⌘K
  2. Home
  4. Docs
  6. Bulk Category Editor
  8. Usage
  10. Import and Export

Import and Export

Import and export tab in Bulk Category Editor for WooCommerce

Import

If you like to import product categories to WooCommerce start by first exporting (use the Export .csv button), when you have done this you have a .csv file that can be opened in e.g. MS Excel or Apple Numbers or other spreadsheet editor.

Example of an .CSV file exported
  1. Decide if you want to update the categories or want to add new
    • New categories
      • Remove term_id values
      • Remove the rows (not header and every column needs to be present)
      • Remove: parent, parent slug and term_taxonomy_id values
      • If you have many categories and subcategories we suggest you import a set of your main categories (parent categories) first, this way you will create id’s to use for your subcategories. (then export again)
      • When importing subcategories, set parent id values based on the term_id of the parent category, remember to not have any term_id values (first column) for your new subcategories
    • Update categories
      • Do your changes in your spreadsheet editor (do not edit the term_id’s)
  2. Next you need to export the file as .CSV with these parameters:
    • Delimeter ;
    • Encoding: UTF-8
  3. In Bulk Category Editor, go to the tab Import & Export, select the file and click the import button

Export

The export will include all your categories and subcategories. Just use the export button and you get a .CSV file.

How can we help?