Step 2 - Matching Fields
In this step you match the fields in the import file with the available category fields. The first three categories in your import file will be displayed, so you can choose the appropriate fields for the values in the file.
If you have specified an automatch line in the import file, the matching will be done automatically and you don’t have to select the matching fields manually.
You can also specify the language of the imported categories,if you have multiple storefront languages.
Please note: As a bare minimum, you need to specify and select at least the “Key Name” and “Name” fields.
The assign fields section:
a) Available Fields and Automatching Fields
The bulk uploader will try to automatch the fields in the CSV file with all of the available field options in the bulk loader, if the first line used in the CSV file has any values like the values listed below in it.
When creating automatch CSV files, please use the automatch values for the first line in the CSV file. Any blank or mistyped values will be skipped. You can still manually associate the fields in the CSV file with the corresponding bulk uploader fields, even if an automatch line is present in your import file.
Available category fields and their automatch values:
| Automatch Value | Description |
|---|---|
| skip | Skip this field |
| key_name | Category key The category KEY (NOT the numerical category ID or the category name) |
| name | Category name |
| meta_title | Meta title |
| meta | Meta keywords |
| parent | The key_name of the parent category Use the category KEY (NOT the numerical category ID or the category name), leave blank if the category is a root category or if the preset in the menu should be used |
| priority | Sorting priority (1 to 10) |
| is_visible | Is the category visible at the storefront Set to “Yes”, if the category is visible, set to “No”, if the category is not visible. |
| list_subcats | List subcategories when viewing the category at the storefront Set to “Yes”, if subcategories are shown, set to “No”, if subcategories are not shown. |
| show_navhelp | Show the navigation help when viewing the category at the storefront Set to “global”, if global settings are used, set to “Yes”, if the navigation help is available, set to “No”, if the navigation help is not available. |
| show_subcat_images | Show subcategory images when viewing the category at the storefront Set to “global”, if global settings are used, set to “Yes”, if the subcategory images should be shown, set to “No”, the subcategory images should not be shown. |
| description | Category description at the top of the category page. |
| description_bottom | Category description at the bottom of the category page. |
| catalog_group_id | The catalog group id, if a group is assigned for that category |
| is_facebook | The category is available for the Facebook App (Canvas App) Set to “Yes”, if the category is available for the mall’s Facebook app , set to “No”, if the category is not available for it. |
| is_visible_no_products | Is the category visible, if no products are added to that category or not. Set to “Yes”, if the category should be visible, even if no products are added to the category, set to “No”, if the category is only shown, when products were added to it. |
| password_protect | Protect the category with a password Set to “Yes”, if the category is password protected, set to “No”, if the category is not password protected. |
| access_password | The access password for the category, if password_protect was set to “Yes” |
Please note: Depending on the version of the shop software, some fields may not be available on your installation. The dropdown boxes at step 2, where you select the matching fields for your data, always display all fields,available in your version of the software.
After you match the fields in the import file with the available category fields, press the “update database” button, to finally import the categories in your file and add them to the database.