Order Log Export
What the Order Log export contains and the meaning of each field.
Overview
The Order Log export contains a line-level log of the completed orders you have received through the platform. Each row represents one item line on an order, with the buyer, the item's details, unit and public prices, shipping cost, and delivery information.
Prices are shown twice: in the currency of the order, and converted into your preferred currency (shown in the converted_currency column, defaulting to USD) using the current exchange rate.
Typical uses include sales reporting, reconciling platform orders with your own order management system, and analysing what your customers are buying.
Generating the Export
Navigate to Settings → Files → Exports and create a new export with the type Order Log.
Filters
| Filter | Description |
|---|---|
| Created after | Only include orders placed on or after this date. |
| Created before | Only include orders placed before this date. |
You can optionally set a row limit to cap the size of the export.
Fields
| Column | Description |
|---|---|
cart_id | Internal identifier of the order (cart) the line belongs to; lines from the same order share this value. |
store_id | Internal identifier of the store where the order was placed. |
external_session_id | Identifier of the buyer's external punchout session, if the order was placed through one; empty otherwise. |
order_created | Date and time when the order was placed. |
user_name | Name of the user who placed the order. |
user_email | Email address of the user who placed the order. |
cart_item_type | Type of item ordered; one of product, product_variant, quotation_item, search_api_product, service, free_text_item, supplier_punchout_product. |
cart_item_name | Name of the ordered item. |
cart_item_description | Description of the ordered item. |
sku | Stock keeping unit of the ordered item, where applicable. |
mpn | Manufacturer part number of the ordered item, where applicable. |
supplier_id | Internal identifier of the supplier for the line (your organisation). |
supplier_name | Name of the supplier for the line. |
currency | Currency code the order was placed in. |
converted_currency | Your preferred currency code that converted amounts are expressed in (defaults to USD). |
unit_price | Price per unit in the order currency. |
converted_unit_price | Price per unit converted to your preferred currency. |
public_price | Public list price per unit in the order currency, if available. |
converted_public_price | Public list price per unit converted to your preferred currency. |
order_quantity | Quantity ordered on the line. |
shipping_cost | Shipping cost recorded on the line, in the order currency. |
converted_shipping_cost | Shipping cost converted to your preferred currency. |
delivery_country | Country code of the delivery destination. |
delivery_address | Delivery address as a single comma-separated line (address lines, city, province, country), if a punchout delivery address was provided. |
supplier_identifier | Supplier identifier recorded on the order line, if any. |
contract_number | Contract number recorded on the order line, if any. |
vendor_number | Vendor number recorded on the order line, if any. |