All Collections
Purchasing
Purchase Orders
Import/Export Purchase Orders by CSV
Import/Export Purchase Orders by CSV

Bulk import large number of purchase orders by CSV

Updated over a week ago

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:

  1. Complete the required fields shown in the table titled CSV headings below. The required fields are highlighted with an asterisk*.

  2. Go to Purchasing

  3. Click Purchase Orders

  4. 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:

  1. Go to Purchasing

  2. Click Purchase Orders

  3. select the PO's you want to export

  4. 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").

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

Did this answer your question?