Importing Categories
You can import categories into your Zoey Store using a CSV file.
Export First
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)
Columns And Headers
All columns must be in the CSV for the import to work.
Column | Description | Values Required |
---|---|---|
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 | Required |
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. |
is_active | 1 = yes, 0 = no | Required |
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. Category or Category - New Template *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)1 = yes, 0 = no | Required |
is_anchor | "Is Anchor" is code for: Show products from all child categories.1 = yes, 0 = no | 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:position price_high_to_low price_low_to_high newest_to_oldest name 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.:name,position | |
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. |
Example Import File
See example import file here:
How To Import Categories
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 3 months ago