Get set up

Importing item attributes

In Zigaflow

The short answer

Importing item attributes can take two stages. First, use the Import Center, under Items and then Attributes, to set the attribute names on your items from a template, unless they already exist. Then use the Flexi-Import to bring in the attribute values from a spreadsheet, matched by item code.

Steps

  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
  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 attribute values

    Import panel showing Import Complete with
  10. To import the values, put them into a spreadsheet

    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
  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
  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

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

Frequently asked questions

Next step

Setting up item attributesSet up an item attribute in Zigaflow under Custom Fields, then Item Attribute Fields, then New Attribute Field. Choose a type such as Dropdown, name it, enter the values, and add it to the items that need it. You can then edit it on quotes and show it on PDF templates.

Was this helpful?

See Zigaflow on your own workflow

Book a demo and we will walk through quoting, jobs and purchasing the way your team runs them.

Or see how Zigaflow would fit your business, free