If you need to import a large number of Purchase Orders to Veeqo you can do this in CSV format.
Import purchase orders
To import purchase orders follow the steps below:
Download this sample purchase order CSV
Complete the required fields shown in the table titled CSV headings below. The required fields are highlighted with an asterisk*.
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.
CSV headings
Below details the different headings available on import:
Header | Details | 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. | |
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 |
status* | The status ('draft' or 'active") of the purchase order when importing. We recommend that these are imported in draft status first. | draft |
expected_date | |The date that the PO is scheduled to be delivered. | 2018-04-11 22:01:00 UTC |
warehouse* | The Veeqo location where the items will be received into. You can only choose one location per purchase order | UK Warehouse |
supplier_report_format | When importing this is the type of file that will be sent to the suppliers email ('CSV' or '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 |
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.20 |
currency* | The currency used by the supplier | GBP |