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:
|
|
|
number | The order number | 12345 |
shipping_address_first_name | The first name of the customer |
|
shipping_address_last_name | The last name of the customer |
|
shipping_address_address1 | The first line of the shipping address | 10 Wind St |
shipping_address_city | The city of the shipping address |
|
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 |
|
sku | The SKU of the product |
|
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 |
|
|
|
|
| The order number from the Webstore/Market Place or entered in during manual order creation |
|
|
| The online store's unique number for the order to distinguish between other customers orders | 207 |
|
| If a document has been printed e.g. Invoice or Packing Slip |
|
|
| The current order lifecycle stage of the order. Note: only statuses that are supported in Veeqo can be used. |
|
|
| The date and time the order was placed on the Webstore/Market |
|
|
| Each product has its own line in the order. The total number of lines equals the total number of different products ordered | 3 |
|
| If the customer has entered additional information on the order |
|
|
| The store type where the order was placed |
|
|
| The unique channel number that is used in Veeqo to distinguish between each store. | 2045 |
|
| If any information has been entered in the orders Employee |
|
|
| When the order has to arrive with your customer. | 2025-04-21 08:39:56 UTC |
|
| Any tags currently applied to the order. Note: These must already be created in Veeqo from the orders page |
|
|
| If the order has been shipped and a tracking number associated it will be shown here |
|
Product Details |
|
|
|
|
| The unique stock keeping unit that has been set for the product |
|
|
| Total amount of items purchased for a product | 5 |
|
| The title of the product in Veeqo |
|
|
| The name of the specific product variant in Veeqo |
|
|
| The line item notes/additional options. |
|
|
| The weight of an individual item. | 370 |
Payment Details |
|
|
|
|
| The orders subtotal price displayed in the currency set in Settings>General>Company Currency | 420 |
|
| 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 |
|
| The amount charged to the customer for delivery. This information is pulled direct from the online store. Displayed in the currency set in | 3.5 |
|
| If any discounts have been applied to the order by coupons the total amount discounted is shown here. Displayed in thecurrency settings in Settings>General> Company Currency | 14 |
|
| The method of payment used to complete the order |
|
|
| The date/time that the order was marked as paid |
|
|
| The individual sales price of a single product without tax. | 25 |
|
| The rate of tax applied to this line item for this order only. | 0.2 |
Delivery Details |
|
|
|
|
| The name of the delivery method selected by the customer at checkout |
|
|
| The date/time the order was cancelled |
|
|
| When an order is cancelled in Veeqo the user has the option to provide a reason |
|
Customer Information |
|
|
|
|
| The email address of the customer who placed the order. | |
|
| The phone number of the customer who placed the order. | 4419328424281 |
|
| The mobile number of the customer. | 4472328281 |
|
| The online store's unique number assigned to the customer | 3329857 |
Billing address |
|
|
|
|
| The first name of the person to be billed |
|
|
| The last name of the person to be billed |
|
|
| Company name to be billed if available |
|
|
| The first line of the address to be billed |
|
|
| The second line of the address to billed |
|
|
| The city of the billing address. |
|
|
| The country for the billing address |
|
|
| The state (US) or county (UK) of the billing address |
|
|
| The Zip (Postcode) of the billing address |
|
|
| Phone number of the billing address | 443934342233 |
Shipping Address |
|
|
|
|
| The first name of the person who will receive the order |
|
|
| The last name or the person who will receive the order |
|
|
| Company name who will receive the order |
|
|
| The first line of the address where the order will be shipped to |
|
|
| The second line of the address where the order will be shipped to |
|
|
| The city of the shipping address |
|
|
| The country for the shipping address |
|
|
| The state (US) or Country (UK) of the shipping address |
|
|
| The Zip (Postcode) of the shipping address |
|
|
| Phone number of the shipping address | 443934342233 |
Export Only |
|
|
|
| alerts | Warnings that may affect shipping | Incomplete address |
| ship_from_ location | The address the order is allocated to | My Location |
| package_type | The name of the package type in Veeqo (if preset used) | FedEx Envelope |
| package_ dimensions | The order's shipping dimensions. NOTE: the same units used in the order page will be used here | 9.5x12.5x9.5 |
| confirmation_ sent | Shows if a shipping confirmation email was sent to the buyer | Yes/No |
| ship_by_date | The latest date that the order can be shipped | 2025-04-21 08:39:56 UTC |
| bin_location | The location of the SKU within your warehouse location | C12R3 |
| order_picked | Shows if this order has been picked | Yes/No |
| invoice_printed | Shows if an invoice has been printed for this order | Yes/No |
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.