Importing orders with a CSV file
We have built a CSV importer for customers that need to import a large amount of orders and it’s too much work to handle this manually. If you would like to use this function, please note that this is a free self-service feature. Our customer service cannot help you setup CSV importing for daily use, this function is meant to be used for large single time batches. If you need to import large amounts of orders on a regular basis, an integration with the Partner API is the way to go. If you need help deciding what’s the best option for you, feel free to contact our customer support.
This guide applies to you if:
How to use the importer
The importer can handle both dropshipping and combined shipments and is able to import multi-line orders. Print images should be prepared according to our guide on how to make a print image, we will not validate your images after import and no manual positioning and checking will be done. Your images will be processed automatically according to the rules in the guide linked above.
Images have to be uploaded to a publicly available source and each order line with a print item needs a link where we can download your image.
Import specification
Please read the following carefully before setting up your file as the importer is set up quite strict to prevent issues with orders.
Delimiter | , |
Enclosure | “ |
Handling orders with multiple order lines
When placing an order with multiple order lines, place each order line in a new row. Only the first row needs to contain all fields described below. From the second row, you may only include:
The custom_reference field will be used to connect all order lines belonging to the same order.
Order fields
These fields contain the order meta like order number, shipping level e.g.
custom_reference – Required
Field type: String
Max length: 20 characters
When ordering multiple items in a single order, reuse this reference on every order line of the same order. Can only be reused in the same import file. You can use this field for your own unique order number.
shipping_kind – Required
Field type: Enum
Possible values: dropship or bulk
- Dropship orders will be shipped directly to your customer. Address fields are required.
- Bulk orders will be collected during the day and shipped together with your other bulk orders to your own address. Address fields are forbidden.
shipping_minimal_level
Required when shipping_kind is dropship
Forbidden when shipping_kind is bulk
Field type: Enum
Possible values: normal or tracked or premium
The lowest desired shipping level for a dropship order. Please note an order may always be upgraded by us when the size, weight or value exceeds the limits of the shipping level. Your minimal level can only be upgraded, it will never be downgraded.
Example: You order 20 cases with shipping_minimal_level = normal in one order. We will upgrade the order to premium because the value is too high and the products too large for an untracked mail shipment.
Order line fields
These fields represent an order line. Each order line represents an X amount of items from one SKU with one print image. If you want to add multiple order lines to an order, add multiple lines to the CSV. Each CSV row represents one order line.
line_sku – Required
Field type: String
Used to determine which product is ordered. Must be an existing Invition SKU
line_quantity – Required
Field type: Integer
How many of this order line do you wish to order
line_print_image_url
Required for item_kind = print
Forbidden for other item kinds
Field type: String
URL where we can download the design to print on the product
Supported file formats: PNG and JPEG
Address fields
Required when shipping_kind is dropship
Forbidden when shipping_kind is bulk
These fields represent a customer address. Make sure you enter a valid address as we will not validate if the entered address exists. Only add these fields once. If you add multiple order lines for the same order, only populate the address fields in the first line. In all other lines, these fields must exist but must be empty.
company_name
Field type: String
Max length: 40 characters
first_name – required
Field type: String
Max length: 40 characters (combined with last_name)
last_name
Field type: String
Max length: 40 characters (combined with first_name)
street_name – required
Field type: String
Max length: 40 characters
house_number – required
Field type: Integer
house_number_addition
Field type: String
Max length: 10 characters
additional_info
Field type: String
Max length: 40 characters
Can be used for additional delivery information.
Example: PO box 1234
state
Field type: String
Max length: 40 characters
zip_code
Field type: String
Max length: 12 characters
city – required
Field type: String
Max length: 40 characters
country_code – required
Field type: String
Max length: 2 characters
ISO 2 country code
phonenumber
Field type: String
Max length: 15 characters
Can be used by couriers to contact the customer with delivery information or for customs requests
email
Field type: String
Max length: 40 characters
Can be used by couriers to contact the customer with delivery information or for customs requests