Docs

Data Importer Explained

Bring tickets, customers and products in from a CSV or Excel file, map your columns to Zippykind's, and save the mapping as a template.

Published

The Data Importer brings existing data into Zippykind from a spreadsheet. Find it at Data Importer → Import Data in the left menu of the dispatch software (/app/import). It is the replacement for the older Uploader, which is still in the menu as Uploader (legacy) while it is being retired.

You do not have to reformat your file first. The importer reads your column headings, matches them to Zippykind's fields, and shows you exactly what will be created before anything is saved. Files exported from other delivery platforms, from a POS, or from an ecommerce site all work this way.

What you can import

Pick the closest match in What is in this file? The options cover deliveries, customer accounts and products. Tickets with order information also brings in line items, fees, tax and totals, so use it when your file has more than one row per delivery.

Accepted files and limits

  • File types: .csv and .xlsx.
  • There is a maximum number of rows per import and a maximum file size, both shown on the page for your account.
  • Some accounts start limited to 10 rows per import. If yours is, the page says so and links you straight into a support case to have the limit raised.

The four steps

  1. Upload File — choose the type, pick the file, and tell Zippykind whether the first row is a header row (it is ticked by default, because it usually is). Press Continue.
  2. Data Mapping — match each column in your file to a Zippykind field. Columns whose headings are recognisable are matched for you; anything unmatched you set by hand, and anything you do not need you can leave unmapped.
  3. Data Mapped — a preview of every row exactly as it will be created, with a select or unselect all control. This is where you find the rows with a bad address or a missing phone number, before they are in your account. Untick anything you do not want imported.
  4. Save & Import — optionally save the column mapping as a re-usable template, then run the import.

Saved Templates

If the same file shape arrives every week, tick Save this column mapping as a template I can re-use on step 4. Saved templates are on the Saved Templates tab at the top of the page, and re-using one turns a weekly import into upload, check, go.

A word of advice before a big import

Run ten rows first. An import creates real delivery tickets and real customer accounts, and the preview in step 3 is the only chance to catch a column mapped to the wrong field. Once ten rows land correctly, run the rest with confidence.

The legacy Uploader

The old Uploader still works and is still in the left menu, but it is being retired. Anything you can do there you can do here. If the importer cannot do something the Uploader could, open a support case and say so before the Uploader goes.