Get set up

How to import spreadsheet data with specific columns

In Zigaflow

The short answer

Use a flexi import. Click the cog icon, then Import Center, Flexi, and Items. Upload your item file, choose the column that represents the item code, map the other columns to the correct fields, and click Next. You can save the mapping to reuse with the same file format.

Steps

  1. Click the cog icon

    Zigaflow dashboard with the settings cog icon highlighted in the top-right toolbar, next to the notifications bell
  2. Click "Import Center"

    Settings menu sidebar with the Import Center option highlighted between Financial Settings and Integrations
  3. Click "Flexi"

    Import Center in Settings with the Flexi tab highlighted at the top of the import type list, showing Flexi Import Step 1 of 3
  4. Click "Items"

    Upload and map your file

    Import Center with Flexi selected and Items tab highlighted, opening Flexi Import Items Step 1 of 3 file upload
  5. Click here or drag & drop your item file

    Flexi Import Items Step 1 of 3 with the Select Files or Drag & Drop Here button highlighted for uploading an .xls or .xlsx file
  6. Click here to choose which column represents the item code

    Mapping import screen with Spreadsheet Header dropdown open under Mandatory Fields, ItemCode option highlighted
  7. Map the other columns in your spreadsheet to the correct fields

    Import mapping Optional Fields section with
  8. Click "Next"

    Import mapping screen with Optional Fields matching spreadsheet headers to Zigaflow fields, Next button highlighted
  9. You will then see this screen

    Save the mapping for reuse

    Flexi Import Items step 3 of 3 showing Import Complete with 0 items created, 1 updated, and a Save Mapping field
  10. If you are likely to use this import mapping again, simply

    1. Give the map a name
    2. Click "Save Mapping"

    Use a saved mapping

    Flexi Import Items step 3 of 3 showing Import Complete, with mapping name entered and the Save Mapping button highlighted
  11. Next time you import this file format, simply choose the relevant mapping

    Import mapping screen with the Select previous mapping dropdown open and a saved mapping option highlighted
  12. And the fields will be automatically mapped

    Import mapping screen with ItemCode auto-mapped to Item Code and Description auto-mapped to Description, both highlighted

Open the flexi import

Frequently asked questions

Next step

Import inventory/stock from a spreadsheetTo import stock from a spreadsheet in Zigaflow, click the Cog, open Import Center, and choose Stock or Inventory. Download the template, add your items and quantities, then drag the file in and click Upload. Use it for first-time setup or to update quantities. Items must already be in the system.

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