It will be much easier to work with this data if you first Export your Categories. See https://support.zoey.com/docs/export-categories for more information
Access the Categories CSV tool from the Import & Export Menu (see below)
All columns must be in the CSV for the import to work.
|category_id||Leave blank if you are creating new categories.|
If you are modifying categories, this must be filled in correctly or a new category will be created.
|Required for modifying categories, must be blank for creating new categories.|
|category_name||Avoid HTML or special characters|
Name is also used for SEO meta_title automatically
|parent_category_id||LEAVE BLANK TO MAKE IT A TOP-LEVEL CATEGORY|
If you want a new category to be a child of another category (like >Mens>Shirts) you must put the category_id of the Mens category into the parent_category_id field of the Shirts category. This can be done when creating the category when modifying it.
Category IDs can be found by going to Advanced > Import/Export > Categories and exporting your categories.
|Required for creating & modifying, otherwise it will move the category.|
|description||This is the Category Description that can be added to your Category Template using the drag & drop design editor.||Required as a column header even if no row data is put in.|
|meta_keywords||What Search Engines will read as the Keywords to use|
|meta_title||What Search Engines will read as the Title to use for this Category|
|meta_description||For SEO purposes (limit to 255 characters)|
|design_template||The values for this column is the Label for the category template in Edit My Design. i.e. |
*note - case sensitive
|include_in_navigation||Include this category in the Header Navigation (as long as categories are enabled for the header navigation in your theme)||Required|
|is_anchor||"Is Anchor" is code for: Show products from all child categories.||Required|
|url_key||The URL String of the Category (for example mens would be domain.com/mens)|
|default_sort_by||This is the default sort order of the category products:|
Or custom attribute code for any attribute that is used for sorting.
|available_sort_by||Leave blank for All, or specify with comma separated values. i.e.:|
|image||Images must first be uploaded to your File Manager (Advanced > File Manager). Then use the full URL from the file manager for this column.|
|thumbnail||Images must first be uploaded to your File Manager (Advanced > File Manager). Then use the full URL from the file manager for this column.|
See example import file here:
Start by exporting your categories and use the CSV file as a template.
You are going to want to import in multiple steps.
Import your Top Level Categories - this will allow you to export a list of the top-level category IDs
Create an Import CSV file for "Sub-Categories" or child categories. It's the same format, but you will fill in the parent_category_id fields from step 1 into the rows of the categories you are going to create in this step.
Repeat step 2 if you have 3 or more sub-levels of categories (like Mens > Shirts > Polos)
Updated over 2 years ago