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. |
Please note that, textual.field_name can be used for image areas too if its item Type 5, in this case "textual.field_value" would be the URL of the image. This can be seen in this example import found here - Link
You can use the data strategy template from even a disabled retailer Generic Filesystem integration for manual csv import
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 ...Virtual Products | Enhanced Print On Demand Import (Artwork Only)
OVERVIEW The KX Platform offers a Print On Demand CSV Import for creating Virtual Products in bulk via a semi-automated process. This provides an effective solution for Brands, Retailers and Designers to add their artwork content to GFN Blank ...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 ...Order Manager | Returns
Introduction Returns is a part of the Kornit X Sales module, allowing for customers to request a return which can then be managed and returned to a return bin on individual orders. Once an item has been returned a Return Shipping Label will be ...KornitX Platform Imports - Simple Stock (Creation Only)
We offer this quick and easy way for fulfillers to create basic Stock Products which can be used for configurable stock items within variants or just to quickly create stock products to be sold on retailer websites. The headers for this import have ...