Before You Start

Make sure you have a CSV store
Make sure the product/s in the orders already exists in Veeqo.

If you need to import products first, either add the product on one of your stores and let it sync into Veeqo or manually Create A Product or Import Products By CSV.

Required fields

The following key fields must be filled in when trying to import an order:

Header	Description	Example
number	The order number	12345
shipping_address_first_name	The first name of the customer	Frank
shipping_address_last_name	The last name of the customer	Spencer
shipping_address_address1	The first line of the shipping address	10 Wind St
shipping_address_city	The city of the shipping address	Swansea
shipping_address_country	The country of the shipping address	UK
shipping_address_state	The state or county of the shipping address	West Glamorgan
shipping_address_zip	The zip or postal code of the shipping address	SA3 4ZZ
sku	The SKU of the product	CK553537D

If your order has more than one product then create a new line for each product in the CSV file.

For a full list of available CSV headers check out the table further down in this article.

Here is a sample CSV file for you to use as a template, the column headings must match this exactly for it to work.

How to Import Orders via CSV

Go to Orders and click on Import:

2. Select the CSV Store you want to associate the orders to:

3. Drag and drop your CSV file into the space provided or click to browse your files to add your CSV file for upload.

Note: Total Discount will not be imported from your CSV. Instead we will calculate the value from the sum of the following columns: additional_order_level_taxless_discount + shipping_discount + taxless_discount_per_unit (multiplied by the number of units).

4. Once you have selected the CSV file to import click on Import Orders

Important:

If your import was successful you will see the following message “Your orders have successfully uploaded to Veeqo. We’ll send you an email once they’ve been processed”
If your import was unsuccessful you will see the following message “An error occurred when uploading your orders - please try again or contact support”. If you see this message you should check hat your CSV file was filled in correctly and try again.

Exporting Orders Via CSV

To export your orders from our new orders page follow these steps:

From the Orders page select any Filters you would like to apply. (Only orders selected by the applied filters will be downloaded.) Alternatively, you can tick the checkbox to the left of an order to export only those selected orders.
Click Actions > Export
Select the checkbox if you would like to include orders containing kits/ bundles and click Export Orders.
Once the file has generated, your export will appear in the notification bell, ready to download.

Available Order CSV Headers

The table below lists the available order CSV headers as well as a brief description and example of each data field. These headers can be used to add information during order imports by CSV, and are what will download when exporting orders to CSV.

Order Details	Header	Description	Examples
	number	The order number from the Webstore/Market Place or entered in during manual order creation	434-1221-8889
	order_remote_id	The online store's unique number for the order to distinguish between other customers orders	207
	receipt_printed	If a document has been printed e.g. Invoice or Packing Slip	TRUE or FALSE
	status	The current order lifecycle stage of the order. Note: only statuses that are supported in Veeqo can be used.	awaiting_fulfilment, awaiting_payment, cancelled, shipped
	created_at	The date and time the order was placed on the Webstore/Market Place Note: The date/time is in UTC and not your companies local time.	2015-08-07 08:30:02 UTC
	number_of _lines	Each product has its own line in the order. The total number of lines equals the total number of different products ordered	3
	customer_note	If the customer has entered additional information on the order	Please send ASAP
	channel type	The store type where the order was placed	woocommerce, ebay, shopify. magento, direct, phone, pos
	channel id	The unique channel number that is used in Veeqo to distinguish between each store.	2045
	notes	If any information has been entered in the orders Employee Notes field this will be shown here	"Quality check completed."
	due date	When the order has to arrive with your customer. Format should be DD/MM/YYYY	DD/MM/YYYY
	tags	Any tags currently applied to the order. Note: These must already be created in Veeqo from the orders page	URGENT
	tracking_number	If the order has been shipped and a tracking number associated it will be shown here	3203343535355BA6F40
Product Details
	sku	The unique stock keeping unit that has been set for the product	CK553537D
	quantity	Total amount of items purchased for a product	5
	product_title	The title of the product in Veeqo	Blue Sequin Dress
	variant_title	The name of the specific product variant in Veeqo	small
	additional_options	The line item notes/additional options.	IMEI: 12333213
	variant_weight	The weight of an individual item. The unit used can be found in Settings>General To calculate the total weight of an order line you need to multiply the quantity by the variant_weight	370
Payment Details
	subtotal_price	The orders subtotal price displayed in the currency set in Settings>General>Company Currency	420
	total_tax	The amount of tax added onto the order based on the tax preferences of the webstore/market place. Displayed in the currency set in Settings>General>Company Currency	84
	delivery_cost	The amount charged to the customer for delivery. This information is pulled direct from the online store. Displayed in the currency set in Settings>General>Company Currency	3.5
	total_discounts	If any discounts have been applied to the order by coupons the total amount discounted is shown here. Displayed in the currency settings in Settings>General>Company Currency	14
	payment_type	The method of payment used to complete the order	cheque, card, cash
	payment_created_at	The date/time that the order was marked as paid	2018-01-26 11:01:27 UTC
	price_per_unit	The individual sales price of a single product without tax.	25
	line_item_tax_rate	The rate of tax applied to this line item for this order only. Note: This would expect a value 0 - 1, so 0.2 is calculated as 20%	0.2
Delivery Details
	delivery_method	The name of the delivery method selected by the customer at checkout	European Delivery
	cancelled at	The date/time the order was cancelled	2015-08-14 13:30:02 UTC
	cancel reason	When an order is cancelled in Veeqo the user has the option to provide a reason	It doesn't fit the customer.
Customer Information
	customer_email	The email address of the customer who placed the order.	helpme@support.veeqo.com
	customer_phone	The phone number of the customer who placed the order.	4419328424281
	customer_mobile	The mobile number of the customer.	4472328281
	customer_remote_id	The online store's unique number assigned to the customer	3329857
Billing address
	billing_address_first_name	The first name of the person to be billed	Frank
	billing_address_last_name	The last name of the person to be billed	Spencer
	billing_address_company	Company name to be billed if available	Veeqo
	billing_address_address1	The first line of the address to be billed	Flat 101
	billing_address_address2	The second line of the address to billed	101 Wind Street
	billing_ address_city	The city of the billing address.	Swansea
	billing_address_country	The country for the billing address	UK
	billing_address_state	The state (US) or county (UK) of the billing address	Massachusetts/Swansea
	billing_address_zip	The Zip (Postcode) of the billing address	SA3 4ZZ
	billing_address_phone	Phone number of the billing address	443934342233
Shipping Address
	shipping_address_first_name	The first name of the person who will receive the order	Frank
	shipping_address_last_name	The last name or the person who will receive the order	Spencer
	shipping_address_company	Company name who will receive the order	Veeqo
	shipping_address_address1	The first line of the address where the order will be shipped to	Flat 101
	shipping_address_address2	The second line of the address where the order will be shipped to	101 Wind Street
	shipping_address_city	The city of the shipping address	Swansea
	shipping_address_country	The country for the shipping address	UK
	shipping_address_state	The state (US) or Country (UK) of the shipping address	Massachusetts/Swansea
	shipping_address_zip	The Zip (Postcode) of the shipping address	SA3 4ZZ
	shipping_address_phone	Phone number of the shipping address	443934342233

Troubleshooting Common Errors

Below are some common errors you may experience when importing orders via CSV. If you are having an issue not listed below, or the fix you try doesn’t work, please contact Support!

**** is not a valid country
The country is not a valid country name or alpha2 code so it could not be recognized. You can find a list of valid names and alpha2 codes here [put link to site with name and country code, or else add them in a table].

Couldn't find variant or kit with sku_code ****
The SKU code you've specified in the file does not exist in your Veeqo account. Make sure the product exists under that exact SKU code (case sensitive).

Illegal quoting on line ****
You've added some invalid quotes on line 2 of the file. A quote is usually applied by the CSV software, so you should either remove these quotes, use apostrophes or apply two around a length of text.

Edit an Order

Purchase Order Overview

Import/Export Purchase Orders by CSV

Importing Customers via CSV

Importing and Exporting Products by CSV