To make Data Export more clear and user-friendly, we’ve updated several column names in your export files.
The new names are easier to understand and better reflect the terms you see in Kanpla Administration.
This update only affects the column names - not the data itself.
You’ll still find the exact same information as before, just under new and more descriptive names.
Overview of changes
Old Name | New Name |
order_id | Order ID |
order_or_refund | Order or Refund |
created_at | Created Date |
date | Order Date |
billing_date | Billing Date |
currency | Currency |
total_for_partner_excl_vat | Total Sales excl. VAT |
total_for_partner_incl_vat | Total Sales incl. VAT |
total_for_partner_vat | Total VAT |
product_id | Product ID |
product_custom_id | Product Custom ID |
product_amount | Product Amount |
product_name | Product Name |
product_category | Product Category |
product_tax_rate_id | Tax Rate ID |
product_tax_rate_name | Tax Rate Name |
discount_id | Discount ID |
discount_name | Discount Name |
discount_is_billable | Billable Discount |
module_display_name_or_name | Module Display Name |
school_id | Location ID |
school_name | Location Name |
school_internal_canteen_id | Location Internal ID |
child_id | User ID |
child_name | User Name |
user_email | User Email |
group_name | User Group |
payment_gateway_id | Payment Gateway ID |
payment_method | Payment Method |
till_id | Till ID |
till_name | Till Name |
order_delivery_time | Order Delivery Time |
invoice_reference | Order Invoice Reference |
child_default_invoice_reference | User Invoice Reference |
code_applied | Code Applied |
text_inputs_string | text_inputs_string |
order_name | Order Name |
product_cogs_category | Product COGS |
product_vat_category | Product VAT Category |
product_cost_price | Product Cost Price |
product_sku | Product SKU |
product_upc | Product UPC |
product_ean | Product EAN |
product_product_group | Product Group |
product_custom_field_1_key | Prodcut Custom Field 1 -Key |
product_custom_field_1_value | Prodcut Custom Field 1- Value |
product_custom_field_2_key | Prodcut Custom Field 2 - Key |
product_custom_field_2_value | Prodcut Custom Field 2 - Value |
product_custom_field_3_key | Prodcut Custom Field 3 - Key |
product_custom_field_3_value | Prodcut Custom Field 3 - Value |
total_for_user_excl_vat | total_for_user_excl_vat |
What this means for you:
When you download or schedule a Data Export, these new column names will now appear in your exported files.
This means:
The new names clearly describe what each column contains
No data has been removed or changed - only renamed
If you use existing Excel sheets or automated dashboards, you may need to update them with the new column names
Want to understand what each column means?
If you’d like to learn more about what the different columns represent in your export file, you can read our detailed guide here:
Questions?
If you need help finding the new column names in your export or guidance on how to update your existing reports, we’re here to help.
Contact us anytime at [email protected]