Orders Template

The Orders template for the import/export tools describes orders in your system, including their current status, the account that placed them, their total value, where they are shipped, the products they contain, and so on.

Important: You cannot import orders using the Kibo eCommerce Import/Export tools. Importing orders is a complex process and must be done via the Kibo eCommerce API. Kibo eCommerce strongly recommends contacting your professional services representative if you want to import orders from a previous eCommerce solution to Kibo eCommerce. Refer to Import Order Using the Kibo eCommerce API for more information and examples of importing orders using the Kibo eCommerce API.

Access the Tools

With the Mozu Import-Export Application (2.0) installed and enabled, go to Main > Fulfillment > Import/Export in Kibo eCommerce Admin.

Supported File Formats

Note: Microsoft Excel limits both total file size and cell size. A single worksheet can contain a maximum of 1,048,576 rows and 16,384 columns. A single cell can contain up to 32,767 characters.

Date Filters and Time Zones

When you export orders, you can use the date filters in combination with the time zone selector to accurately target the orders you want to export.

For example, you can use the time zone selector with a created date filter to export all completed orders created from 6am CSD on April 1st to 6am CSD on May 1st:

The Order template supports the following date filters: Created Date, Submitted Date, and Modified Date.

The time zone selector automatically defaults to your local browser time, but you can select a different time zone as needed.

Template Key

For each sheet, we define each column and describe valid values for the column. Some values are not required for an import, but are required Kibo eCommerce data. For example, you do not have to specify a customer's FirstName every time you modify the customer account, but all customer accounts require a FirstName when they are created. For additional context about the process of building out Kibo eCommerce data, refer to the topics in Guides. If you have questions or concerns specific to your data, please contact your integration partner or Kibo eCommerce Support.

Information Provided for Each Sheet of the Template
Corresponding REST API Resource Every column in a sheet corresponds to a property in the Kibo eCommerce REST API. For each sheet, we provide a link to any API resources that contain properties in the sheet.
Column Name The name of the column in the sheet.
Description A description of the data a column contains.
Valid Values Lists valid values for the column.

Sheets