If you need to import a large number of Purchase Orders to Veeqo you can do this in CSV format.

Before You Start

Download this sample purchase order CSV
Complete the required fields shown in the table titled CSV headings below

Required Fields

Below are the fields that must be included when uploading a purchase order to Veeqo, as well as a brief description and an example of the supported format.

Header	Description	Example
supplier_id	The Veeqo ID for the supplier. To find out this number check out this guide.	12944
supplier_name	The name of the supplier in Veeqo.	Highland Spring
supplier_email	The email address of the sales contact for the supplier.	marc@hsprings.com
status	The status ('draft' or 'active") of the purchase order when importing. We recommend that these are imported in draft status first.	draft
warehouse	The Veeqo location where the items will be received into. You can only choose one location per purchase order	UK Warehouse
product_sku	The product SKU. This needs to match an existing Veeqo product.	V-V2018
product_order_qty	The amount to be ordered for the above product.	5
product_supplier_cost_price	The amount the supplier charges excluding VAT for this product.	1.45
product_tax	The tax rate for the product e.g. 0.20 = 20%	0.2
currency	The currency used by the supplier	GBP

Available Fields

Below are the additional available fields that can be used to import data for a purchase order. All of these fields (if the data is in Veeqo) will be shown on an exported purchase order CSV.

Header	Description	Example
reference_number	An additional field for adding either an internal reference for the purchase order or a specific po number for the suppliers reference.	DUA-1121
expected_date	\|The date that the PO is scheduled to be delivered.	2018-04-11 22:01:00 UTC
supplier_report_format	When importing this is the type of file that will be sent to the suppliers email ('CSV' or 'PDF").	pdf
note	A field available for internal or external notes.	Please dispatch at earlier date possible
shipping_and_handling_price	If the supplier bills shipping and handling separately this is entered here excluding vat.	0.44
shipping_address_line_1	Address that the supplier should ship to. This can be left blank if you want to use the default address for the selected warehouse.	3500 Deer Creek Road
shipping_address_line_2	Address that the supplier should ship to. This can be left blank if you want to use the default address for the selected warehouse	Unit 5
shipping_address_town	Address that the supplier should ship to. This can be left blank if you want to use the default address for the selected warehouse.	Palo Alto
shipping_address_state	Address that the supplier should ship to. This can be left blank if you want to use the default address for the selected warehouse.	CA
shipping_address_postcode	Address that the supplier should ship to. This can be left blank if you want to use the default address for the selected warehouse.	94304
shipping_address_country	Address that the supplier should ship to. This can be left blank if you want to use the default address for the selected warehouse.	United States

Import purchase orders

To import purchase orders follow the steps below:

Go to Purchasing
Click Purchase Orders
Hit Import

Note:

When your PO imports Veeqo will automatically generate a purchase order number. However, you can use the reference_number field if you would like to add your own ID as well.
To find your supplier ID see this guide

6. Click + ADD CSV FILE

7. Select the CSV file from your device

8. Click IMPORT PURCHASE ORDERS to confirm your selection and begin the import

Note: We recommend 100 line items or fewer to be added to each Purchase Order. If you want to purchase more than 100 different line items we recommend that you split your purchase into multiple orders.

Export purchase orders

To export follow the steps below:

Go to Purchasing
Click Purchase Orders
select the PO's you want to export
Click Export. Your file will be generated and downloadable from the notification area.

Purchase Order Overview

Add and Manage Suppliers

Importing and Exporting Products by CSV

Import Wholesale orders

Importing and Exporting Orders by CSV