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:

  • You have an account for automatic ordering

  • You need to import a large amount of orders once

  • You have experience with CSV imports

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:

  • partner_reference

  • line_sku

  • line_quantity

  • line_print_image_url

The partner_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.

partner_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_namerequired
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_namerequired
Field type: String
Max length: 40 characters

house_numberrequired
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

cityrequired
Field type: String
Max length: 40 characters

country_coderequired
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

Download the example file

You can compare your file to our import example to see if you created the file according to the import specification.

Download the CSV example