Next | Order & Stock Management | Integration Guide - CSV

 

 

Next Integration Guide

CSV File Data Exchange Over SFTP

 

 

 

 

 

 

Welcome to the Kornit X Platform 

Kornit X is happy to welcome you to the platform. We work closely with Next to enable integrations for the passing and end to end management of orders for fulfilment by third party suppliers. 

This document describes the integration specification for a supplier to integrate to the Kornit X Platform for the Direct Dispatch or Personalised Model.

Details are supplied for order and stock management using CSV file data exchange over SFTP.

Managing Orders via CSV 

Kornit X have created a standard CSV format that we can generate and push over SFTP to an accessible location for suppliers to then connect and read the files, importing the orders into their own production systems. The same SFTP can then be used to pass back acknowledgement of the order and dispatch confirmation, again in a standard CSV format. 

Set Up

SFTP Hosting

To enable us to generate and pass these files we would need the following SFTP Credentials: 

- Host

- Username

- Password

- Port

If you do not have access to an SFTP server yourself, we can set up a location for these files through our Architects team and provide you with the above credentials.

We can also authenticate through a key pair which if needed we can generate and provide you with.

Integration Configuration

Your Kornit X Representative will configure the integration and confirm once this is done and ready for testing.

In the event of any errors with the integration/file format, you will receive an email notification.

Please confirm the email address that these errors should be sent to. 

Receiving Orders via CSV

Kornit X will periodically create a CSV file in the /orders directory of the SFTP account for any new orders. If the /orders directory does not exist then it will be automatically created by Kornit X. 

The integration will run every 10 minutes (approx).

You will receive one CSV file per order - This file contains all details required to complete the order.

Example File Format

An Example CSV file can be seen on this link under the /orders tab - Click Here

Personalisation

It is possible for us to send text based personalisation in the CSV where there is no requirement for the supplier to receive print ready artwork from the platform. 

This is a setting on the integration which your Kornit X contact can enable for you. 

These fields are added to the 'item_attribute.value' header.

Order Consolidation 

As standard, orders will be passed as individual order lines and the supplier can consolidate at the packing stage if desired.   

For example, if a customer orders 2 products from Next in 1 transaction, two individual orders with unique order references will be passed to the supplier. 

 

 

 

 However, there are systemic solutions available - these should be discussed and agreed with the Next team directly. 

Branded Dispatch Notes

A branded A4 Dispatch Note must be included within each order. It contains information which is vital for the Customer Returns process.    

An example Dispatch Note can be viewed here. 

The Dispatch Note is available to download and print from the platform. 

If you are integrating directly with the platform, a URL will be included with the data where you will be able to access and print the Dispatch Note. 

Dispatch / Delivery Date 

Please note that the <required_dispatch_date> is the date that the customer is expecting the product to be delivered to them, therefore you should be dispatching before this date with enough time to include your delivery. 

Acknowledging Orders via CSV

The supplier is required to upload a CSV acknowledgement file to the /acknowledgements directory of the SFTP account which Kornit X will then take as confirmation that the supplier is ready and happy to process the order -  - there is no specific file naming convention.

Acknowledgements are expected within 1 hour of order receipt.

The acknowledgement must correlate to an order that the supplier has received via the orders XML file. The supplier may not send an acknowledgement for an order that it was never sent to begin with. 

Once the file has been processed by Kornit X, it will be deleted. 

CSV File Headers 

order.id

Example File Format

An Example CSV acknowledgements file can be seen on this link under the /acknowledgements tab - Click Here

Plain Text Example: 

The acknowledgement CSV file can contain multiple orders and is structured as follows: 

order.id 

12345 

23456 

 

Table Format Example: 

order.id

12345

23456

 

Shipping Orders via CSV

Once the order has been completed and dispatched to the customer, the supplier should upload a shipment file to the /shipments directory in the following format - there is no specific file naming convention.

Once processed by Kornit X the shipments CSV files will be deleted. 

Please note, a Shipment file will only be accepted by the integration once an order has been successfully acknowledged.

 

CSV File Headers 

shipment.correlation =  order.id 

shipment.tracking = tracking number provided by a carrier 

shipment_item.order_item_id = item.id 

shipment_item.quantity = the quantity of this item being shipped 

Example File Format

An Example CSV shipments file can be seen on this link under the /shipments tab - Click Here

Plain Text Example: 

shipment.correlation,shipment.tracking,shipment_item.order_item_id,shipment_item.quantity 

A,ABC,100,1 

B,DEF,200,1 

B,DEF,202,2 

 

Table Format Example:

shipment.correlation	shipment.tracking	shipment_item.order_item_id	shipment_item.quantity
A	ABC	100	1
B	DEF	200	1
B	DEF	202	2

 

Cancelling Orders via CSV 

If a supplier is unable to fulfill an order, the order can be cancelled via the CSV. To do so, CSV should be placed in the /cancellations directory on your SFTP - there is no specific file naming convention.

Once processed by Kornit X the shipments CSV files will be deleted. 

 

CSV File Headers 

cancellation.correlation =  order.id 

cancellation_item.order_item_id = item.id 

cancellation_item.quantity = The quantity of this item being cancelled 

 

Example File Format

An Example CSV cancellation file can be seen on this link under the /cancellations tab - Click Here

Plain Text Example: 

cancellation.correlation,cancellation_item.order_item_id,cancellation_item.quantity 

A,100,1 

B,202,2 

B,200,1 

 

Table Format Example:

cancellation.correlation	cancellation_item.order_item_id	cancellation_item.quantity
A	100	1
B	202	2
B	200	1

  

Managing Inventory via CSV

Stock values can be provided based on either a ring-fenced or shared stock pool. Where the stock is ring-fenced, the frequency with which the data is provided is less critical.  However, if stock is part of a shared stock pool, stock updates are required frequently, based on stock position changes, in order to mitigate issues with fulfilment.

On the SFTP these CSV files should be placed in a directory called /inventory in the root - there is no specific file naming convention.

Once the file has been processed by Kornit X, it will be deleted. 

The main stock file (full feed) is to be received by Kornit X daily, at a designated time.

There is an option to submit further delta files containing absolute values received at designated intervals, following the processing of the Next order files.

A stock quantity of 0 should be sent if the Brand would like to remove an item from the Next website. A stock update of zero will update the item to show “Currently unavailable” on the Next website, then after 20 minutes the item will be automatically removed from the search feed, unavailable for customers to purchase.

CSV File Headers 

sku - the SKU or EAN value of the product to be updated 

      NOTE - with this inventory file, 'sku' can be replaced with 'ean'.

quantity_available - the stock quantity of the product available 

Example File Format

An Example CSV inventory file can be seen on this link - Click Here

Plain Text Example: 

sku,quantity_available 

ABC,1 

 

Table Format Example:

sku	quantity_available
ABC	1

File Paths

CSV files should be placed in the following SFTP folder structure:

Orders will be placed in the /transfer/orders directory by Kornit X.

Acknowledgements should be sent to the /transfer/acknowledgements directory.

Inventory files should be posted to the /transfer/inventory directory.

Order Status (Dispatched) should be sent to the /transfer/shipments directory.

Order Status (Cancelled) should be sent to the /transfer/cancellations directory.

Archive: Once orders are processed, they should be moved to the /transfer/archive directory.

• Related Articles

• Next | Order & Stock Management | Integration Guide - API

  Next Integration Guide Data Exchange Over REST API Welcome to the Platform Kornit X is happy to welcome you to the platform. We work closely with Next to enable integrations for the passing and end to end management of orders for fulfilment by third ...

• Next | Order & Stock Management | Integration Guide - XML

  Next Integration Guide XML File Data Exchange Over SFTP Welcome to the Kornit X Platform Kornit X is happy to welcome you to the platform. We work closely with Next to enable integrations for the passing and end to end management of orders for ...

• Next | Order & Stock Management | KornitX Platform For Label Plus

  Label Plus+ Suppliers Using the Kornit X Platform Please note we are now known exclusively as Kornit X, a division of Kornit Digital – Custom Gateway was our name before our takeover. To access the platform please refer to the following link – CLICK ...

• Next | Order & Stock Management | KornitX Platform For Direct Dispatch

  Direct Dispatch Suppliers Using the Kornit X Platform Please note we are now known exclusively as Kornit X, a division of Kornit Digital – Custom Gateway was our name before our takeover. To access the platform please refer to the following link – ...

• Next | Order & Stock Management | KornitX Platform For Personalised

  Personalised Suppliers Using The Kornit X Platform Please note we are now known exclusively as Kornit X, a division of Kornit Digital – Custom Gateway was our name before our takeover. To access the platform please refer to the following link – CLICK ...