Import purchase orders from a spreadsheet
The short answer
Click the cog, open Import Center, and choose Purchase Orders. Download the template, fill it in with one complete row per item, then drag and drop the file and click Upload. A banner shows whether the import succeeded or failed. You can import more than one purchase order in one spreadsheet.
Steps
Click on the Cog

Click "Import Center"

Click "Purchase Orders"

Click "Download Template" for the template spreadsheet
Fill in the template

More than one PO can be imported at a time
The template consists of three areas: header, section name, and item details.

For each item in an PO, there needs to be a complete row
For each item in an PO, there needs to be a complete row. This means that the master PO details, such as the supplier name or note, need to be repeated on each line. Similarly, the section name (if given) needs to be repeated for all the items in the section.
Upload the file

Drag and drop the file here

Click "Upload"

The banner shows the success or failure of the import

The original ID/Reference from the previous system is appended to the description
Learn more: purchase orders in Zigaflow

Before you import
Before importing, the supplier and contact at the company (if set in the import) need to be in Zigaflow. Otherwise, the import will fail.
Required columns
These columns are compulsory in the import file:
- ID - this is just the reference from the previous system, such as the purchase order number
- Status (the Zigaflow status)
- Supplier
- Assigned User Email - the user the purchase order will be assigned to in Zigaflow
- Initial Assigned User Email - the initial user the purchase order will be assigned to in Zigaflow
- Required Date
- Expected Date
Download the template
Frequently asked questions
Was this helpful?