CSV Order Import Breakdown

CSV Order Import Breakdown

The following article has been split out from the existing Generic FIlesystem article to show users how to use a CSV format to import textual orders into Order Manager found within the Sales module of the Kornit X Platform.
For information on setting up a Generic Filesystem Sales Channel Integration please refer to this article - CLICK HERE 
Any CSV files uploaded to a generic filesystem integration will be fetched for processing by Order Manager once every 30 minutes, both on the hour and half past the hour.
Successfully processed CSV files get renamed with a timestamp and .complete suffix whilst unsuccessfully processed files gain a .error suffix.

Required CSV Format Details
The following table describes which columns can be included within an Order CSV. An example CSV file can be downloaded from the Attachments section of this article
Column Header
Description
order.external_ref
The order reference needed. 
order.sales_datetime
The date and time that the order was placed. The correct date format must be be in the form YYYY-MM-DD HH:MM:SS. An example of this is "2022-02-22 14:56:23".
order.shipping_company
The Company name if used.
order.shipping_address_1
Shipping address line 1.
order.shipping_address_2
Shipping address line 2, if required.
order.shipping_address_3
Shipping address line 3, if required.
order.shipping_address_4
Shipping address line 4, if required.
order.shipping_address_5
Shipping address line 5, if required.
order.shipping_postcode
Shipping postcode.
order.shipping_country
Shipping country.
order.shipping_country_code
Shipping country code the ISO alpha-2 examples should be used. Examples of these can be found here
order.shipping_method
Shipping method used, for example "Next Day".
order.shipping_carrier
Shipping carrier used, for example "Royal Mail"
order.billing_address_1
Billing address line 1, if required. 
order.billing_address_2
Billing address line 2, if required.
order.billing_address_3
Billing address line 3, if required.
order.billing_address_4
Billing address line 4, if required.
order.billing_address_5
Billing address line 5, if required. 
order.billing_postcode
Billing address postcode, if required.
order.billing_country
Billing address country, if required. 
order.customer_name
The customer name.
order.customer_email
The customer email. 
item.sku
The item SKU taken from a Sales Channel.
item.description
A brief item description from the product, usually associated to the ecommerce description.
item.colour
The item colour text field. 
item.size
The item size (arbitrary type).
item.quantity
Quantity of the item required.
item.type
The item type which can be set between the following 3 options.
1 - Set to use item.external_url to define an orders artwork. 
3 - Set to use print on demand references from Product Manager.
5 - Set for textual items. This is to be used for items with no artwork and only textual customisation fields such as "textual.field_name1".
item.print_on_demand_ref
The print on demand reference for item orders obtained from product manager - only for item type 3.
item.external_url
URL to the product artwork. Only for item type 1. 
item.external_thumnail_url
URL to the product thumbnail linked to the product. Only for item type 1. 
textual.field_name1
1st personalisation text area name. Only for item type 5. 
textual.field_value1
1st personalisation text area field. Only for item type 5.
textual.field_name2
2nd personalisation text area name. Only for item type 5.
textual.field_value2
2nd personalisation text area value. Only for item type 5. 
textual.field_name3
3rd personalisation text area name. Only for item type 5. 
textual.field_value3
3rd personalisation text area value. Only for item type 5. 

Updated CSV Order Import Features
At Kornit X we have continued to develop updates for the CSV Order and this is due to the fact we pride ourselves on constant evolution and the release of new features and enhancements every week. We have detailed each new enhancement below. If you are interested in knowing what features arrive, they will be continually updated within the "Core Platform Feature Updates" Article - CLICK HERE

Auto-Detection Of Products With Variants
This was added on 15-02-2022
A recent update has been made to Platform, that affects Textual orders and csv order importing. This fixes issues relating to thumbnail generation and batching errors for variant products.

To enable this users must go to "Advanced Settings" on the Sales Channel company, head to "Incoming Orders/Textual Items", and toggle the "Auto Detect Variant when Converting to Print Job" setting. This field has been shown in the screenshot below. 

This feature will be enabled by default for all Sales Channel companies created going forwards.
    • Related Articles

    • Companies Import

      At Kornit X we offer this quick solution to create multiple companies at once. How Do I Use This Imports? To be able to access this import, simply head to the "Companies" section which is found in the top corner cog wheel of the system. This has been ...
    • Personalise-IT Export CSV from ACP

      The Personalise-IT CSV is a quick and easy tool for exporting products from your product database on our admin panel to importing them to your database with the back end of your website. The Personalise-IT export CSV function can be found in any ...
    • Virtual Products | Enhanced Print On Demand Import (Artwork Only)

      Overview The Platform now offers an enhanced CSV import solution for creating Print On Demand Virtual Products in bulk. This import works similarly to the other Artwork Only routines, but has a few key differences to offer a more efficient and ...
    • Formatting google drive image URLs to work with the csv POD import routine

      Introduction A csv file can be imported into CPP for the bulk creation of Print on Demand products By default the format of a shared google drive image will not work with the import routine. This article will detail the steps to take to use such an ...
    • Order Manager | Customer Services: Finding Order Information and FAQ's

      Overview This document will outline how the system can be used to address common order and customer service based queries experienced by Retailers (and Fulfillers). The Platform is designed to offer a self service Order Management System. Retailers ...