When exporting your order data, you’ll encounter various columns in the file. Below is an explanation of each column and how it can be used.
How to Access the Sales Dashboards:
Log in to Kanpla Administration with your credentials
Navigate: Click Statistics in the left-hand panel: Access Kanpla Statistics
Explore the two dashboards
Downloade the desired file and follow this guide for further explanation.
Order Details
Order ID: When you export a file, in the column order ID, you will see a long characters mix between numbers and letters. If you copy the first 6 characters this will correspond with the order ID you see in the order overview.
Created At: The date the order was placed, useful for tracking when an order was initiated.
Order Date: The intended fulfilment date for the order, helping to manage delivery or scheduling logistics.
BIlling date: Same as “Created At,” showing when the billing process occurred.
Currency: Indicates the currency used for payment, ensuring accurate accounting across regions.
Pricing Details
Total excl. VAT: The total amount paid by the customer, excluding VAT, used for calculating tax.
Total incl. VAT: The full payment amount, including VAT, reflecting what the customer was charged.
Total VAT: The tax portion added to the price, used for tax reporting and compliance.
Product Details
Product ID: A unique identifier for each product. Customers can use this to track or verify specific products in their inventory or systems.
Product Custom ID: A custom identifier that clients might use for internal categorization or specific tracking needs.
Product Amount: The quantity of products purchased, useful for inventory and sales analysis.
User Details
User Name: The name of the account user who completed the order, enabling identification of the purchaser.
User Email: The email associated with the user’s account, often used for communication or customer support.
User Division: Also called “Selector,” indicating the group or category the user is linked to (e.g., class, department), helping in segmentation and analytics.
Payment overview:
Transaction ID: A payment-specific identifier, useful for reconciling payments or searching in payment platforms like Adyen under the field "Merchant reference"