If you need to import a large amount of Purchase Orders to Veeqo you can do this in CSV format.
To import purchase orders follow the steps below:
1. Download the Sample CSV File Here.
2. Complete the required fields shown in the table below
3. Go to Products>Purchase Orders and hit Import
Important: 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 export follow the steps below:
1. From Products>Purchase Orders select the PO's you want to export
2. Hit Export. Your file will be generated and downloadable from the notification area.
Below details the different headings available on import:
|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 firstname.lastname@example.org|
|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 warehouse where the items will be received into. You can only choose one warehouse 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|
|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|