In this article, you’ll learn how to understand and work with your Data Export files.
We’ll walk you through which columns to select when creating an export — and how to interpret the data in each column once you’ve downloaded your file.
Kanpla’s Default Columns Dictionary
Below you’ll find an overview of the most common columns included in a Sales Data Export and what each one means.
Order ID
The ID belonging to a certain order
Billing Date
The date on which an order was last changed.
Created Date
The date on which an order was created
Order Date
The date for which an order was placed – on which the order was delivered to the customer
Order or Refund
The value "Order" means this row represents an order that has been placed.
The value "Refund" means that this row represents a refunded order.
Line Type
The value "product" shows this row represents an ordered product.
The value "discount" shows this row represents the billable discount. This row will not have a product amount or a product name, but shows the amount to be billed to the company in a Hybrid Billing setup.
To create the:
Product category
This is the category that the product is placed in in the product settings in admin.kanpla. For example: Spaghetti Bolognese is in product category "Dish of the Day."
Billable discount
This column shows the
Text inputs - all
Text inputs are the custom fields that might have been added to a (hospitality) module, "Reference numbers" or "Comments" for example. When selecting Text inputs - all, all custom fields will be shown in separate columns.