Skip to main content

Importing item attributes

Set up attributes on your items with the Import Center, then use the flexi-import to add attribute values from a spreadsheet by item code.

Importing Attributes

This can be a two-stage process:

i) An import to set attributes on items, but this isn't required if they already exist

ii) The flexi-import imports the values

Set up attributes on items

1. To set the attributes using the import, click here. To import just the values, skip forward to step 10.

Dashboard top bar with the settings gear icon highlighted, next to notifications, above the Recently Created Jobs panel

2. Click "Import Center"

Settings menu list with Import Center highlighted between Financial Settings and Integrations

3. Click "Items"

Import Center under Settings with the Flexi panel open and the Items option in the left list highlighted for clicking

4. Click "Attributes"

Import Items screen with Items selected in the left menu and the Attributes option highlighted under Items & Kits

5. Click "Download Template"

Attributes tab of the import center with the Download Template button highlighted under Step 1 to get the Excel template

6. Populate the template with the attribute(s) names and save it

Spreadsheet import template with ItemCode and Attribute1–Attribute10 columns, Attribute1 filled with Color for two items

7. Import the spreadsheet

Attributes import tab with the "Select Files or Drag & Drop Here..." button highlighted for uploading the template file

8. Click "Upload"

Attributes import screen with Import Item Attributes Template .xlsx file selected and the Upload button highlighted

9. Click "x" to close the success panel

Import panel showing Import Complete with "0 created, 2 updated" and the X close button in the top-right corner

Import attribute values

10. To import the values, put them into a spreadsheet. The only columns required are the ItemCode and the values for the attribute.

If an item does not have an attribute set up but a value in this file, it will be ignored

Spreadsheet with ItemCode and Color columns listing two item codes with attribute values Blue and Green for import

11. Use the Flexi-Import for this. Click "Flexi"

Import Center in Settings with the Flexi tab highlighted at the top of the import type list, above Items and Variants

12. Click this file field.

Flexi Import Items step 1 of 3, with the Select Files or Drag & Drop Here button highlighted for uploading the template file

13. Set the column with the item codes to match the "Item Code" in Zigaflow

Import mapping Mandatory Fields with "item" typed in Spreadsheet Header and ItemCode option highlighted for Item Code field

14. Match the spreadsheet attribute column to the attribute in Zigaflow. Type the name of the attribute to find it

Flexi Import Items step 2 of 3, Optional Fields Zigaflow Field dropdown searched for "color" with Color (Attribute) highlighted

15. Click "Next"

Flexi Import Items step 2 of 3 with Color mapped to Color (Attribute) and the Next button highlighted

16. Check the items have been updated

Import Items screen showing Import Complete with a green check and the summary "0 Items created, 2 Items updated

Learn more: inventory in Zigaflow

Related Articles
Did this answer your question?