This file sends information back to Kimelo about what goods were actually delivered to the Customers. Based on this file Kimelo will populate the Customer-facing invoice and, if it’s not adjusted (through invoices.csv file) before due date, charge the Customer. Thus, it is paramount that the information supplied to Kimelo in this file is timely and correct. Sample file:
order_items_accepted_yyyy-mm-dd-hh-mm-ss.csv
Once an order is present in this file it will be marked as delivered and the information about products delivered will be used to create an invoice. Then the information about corresponding invoice will be present in the invoices.csv file sent to the seller.
All products delivered for a given order need to be submitted in a single file. This allows for the seller to communicate to Kimelo which products were actually delivered to the Customer as part of that order. Even if the order has delivered in full this file needs to contain all items and quantities to ensure that Kimelo creates proper invoice and communication to the end Customer.
| Filename pattern | order_items_accepted[datetime].csv |
|---|---|
| ERP to Kimelo | Y |
| Kimelo to ERP | |
| System of record | ERP |
| Status | Available |
| Frequency | Daily |
When the ERP system records delivery, this file notifies the Kimelo system. This triggers moving the invoice into a fulfilled and payable state.
| Column Name | Data Type | Description |
|---|---|---|
| kimelo_order_id | integer | Kimelo-generated order number. |
| erp_product_id | string | Distributor's internal identifier of a given product. |
| pack_type | string | Defines how the product is sold (e.g., Case or Each). |
| accepted_quantity | integer (unsigned) | Number of units accepted by the customer of this item. If item is a “case” variant, 1 case = 1 accepted, regardless how many units in the case. Used for final invoicing. May be positive or zero but not negative. |
| is_catchweight | boolean | Defines whether the item is a catchweight item. |
| catchweight_value | float | The actual weight of the catchweight item in the specified unit of measure (UOM). |
| catchweight_uom | string | Unit of measure for the catchweight value. The system currently only supports pounds. |