Get set up

Import custom fields from a spreadsheet

In Zigaflow

The short answer

Use the Flexi-import in Zigaflow. Prepare a spreadsheet with the item code in the first column and the custom field data in another, then go to Import Center, Flexi, Items. Upload the file, match the item column to the item code field, map the custom field, and click Next. The custom field must exist first.

Steps

  1. Prepare the import file

    Prepare the import file. It does not have to map to an import file. All that is needed is the item code in the first column and, in this case, the custom field in another. If there are other columns, they can be ignored during the import process.

    Open the Flexi-import

    Spreadsheet with ItemCode in column A and Supplier Code in column B, listing four item codes with matching supplier codes
  2. To start the import, click here

    Zigaflow dashboard with the settings gear icon highlighted in the top toolbar, next to the notifications bell
  3. Click "Import Center"

    Settings menu list with Import Center highlighted between Financial Settings and Integrations
  4. Click "Flexi"

    Import Center in Settings with the Flexi tab highlighted in the left menu, showing Flexi Import Items Step 1 of 3
  5. Click "Items"

    Upload and map the file

    Import Center with Flexi selected and the Items tab highlighted, opening Flexi Import Items Step 1 of 3 file upload
  6. Upload the file

    Flexi Import Items step 1 of 3 with the Select Files or Drag & Drop Here button highlighted to upload the .xls or .xlsx file
  7. Match the spreadsheet item column to the Zigaflow item code field

    Mapping import screen, Mandatory Fields: Spreadsheet Header dropdown with ItemCode highlighted to match Zigaflow Item Code field
  8. Map the custom field

    Import mapping screen with the Zigaflow Field box highlighted next to Supplier Code under Optional Fields
  9. Search for the name and select the field

    Zigaflow Field dropdown with
  10. Click "Next"

    Flexi Import Items step 2 of 3 mapping ItemCode and Supplier Code to Zigaflow fields, with the Next button highlighted
  11. Check the import was successful

    Import Complete screen with green check mark and summary bar, highlighting the

The quickest way to import the data for custom fields is using a spreadsheet and the Flexi-import. The custom field must exist before importing.

Prepare the import file

Frequently asked questions

Next step

Creating a custom field during importTo create a custom field during an import, click the Cog, open Import Center, and choose a Flexi import. Add your file, pick the matching master field, click the plus button, and select the custom type and its label. Then click Next to complete the import. It works for items, customers, contacts and leads.

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