Offer Approval Export
What the Offer Approval export contains and the meaning of each field.
Overview
The Offer Approval export contains the offers (price lists) you have submitted to customer stores, together with their approval status. Each row represents one offer for a product, product variant or service, including the item's details, the offered price, validity dates, and up to five pricing tiers for volume or graduated billing schemes.
Typical uses include tracking which offers are still pending or have been denied, reviewing price changes across your offers, and reconciling agreed prices with your own systems.
Generating the Export
Navigate to Settings → Files → Exports and create a new export with the type Offer Approval.
Filters
| Filter | Description |
|---|---|
| Store | Restrict the export to offers submitted to a single store. |
| Status | Restrict to offers with a given approval status: pending, approved, denied or expired. |
| Starts after | Only include offers whose validity starts on or after this date. |
| Ends before | Only include offers whose validity ends on or before this date (offers with no end date are also included). |
| Billing scheme | Restrict to a single billing scheme: standard, volume, graduated, quote or external. |
| Currency | Restrict to offers in a single currency. |
| Country | Restrict to offers for a single country. |
| Archived | Export archived offers instead of active ones. |
| Updated by | Restrict to offers last updated by a specific user. |
| Catalogue | Restrict to offers belonging to a single catalogue. |
You can optionally set a row limit to cap the size of the export.
Fields
| Column | Description |
|---|---|
approval_status | Approval status of the offer; one of pending, approved, denied, expired. |
approval_reason | Reason given for the approval decision, if any. |
approval_requested_at | Date and time when the offer was submitted for approval. |
approval_updated_at | Date and time when the offer was last updated. |
supplier_name | Name of your supplier organisation. |
product_id | Unique identifier (UUID) of the product, variant or service the offer is for. |
type | Type of item the offer is for; one of product, product_variant, service. |
identifier | Your own identifier for the product, variant or service. |
product_name | Name of the product, variant or service. |
sku | Stock keeping unit of the item. |
unit_size | Size of one unit (e.g. pack quantity or volume). |
unit_label | Label describing the unit (e.g. each, box, litre). |
description | Description of the item, with any HTML formatting removed. |
billing_scheme | How the offer is priced; one of standard, volume, graduated, quote, external. |
tax_behaviour | Whether the price includes tax; one of inclusive, exclusive. |
currency | Currency code of the offer (e.g. USD). |
country | Country code the offer applies to. |
catalogue | Identifier of the catalogue the offer belongs to, if any. |
store_id | Internal identifier of the store the offer was submitted to. |
price | Offered unit price in the offer currency, to two decimal places; empty for quote and external billing schemes, which have no concrete price. |
price_change | Amount the price changed compared to the previous offer. |
price_change_percentage | Percentage the price changed compared to the previous offer. |
starts_at | Date and time when the offer becomes valid, if set. |
ends_at | Date and time when the offer expires, if set. |
public_price | The item's public list price, if provided. |
discount | Difference between the public price and the offered price, to two decimal places. |
updated_by | Name of the user who last updated the offer. |
created_at | Date and time when the offer was created. |
minimum_requisition_quantity | Minimum quantity a buyer must order, if set. |
requisition_quantity_interval | Interval the order quantity must be a multiple of, if set. |
tier_1_up_to / tier_1_flat_amount / tier_1_unit_amount … tier_5_up_to / tier_5_flat_amount / tier_5_unit_amount | Up to five pricing tiers for volume and graduated billing schemes: the upper quantity bound of the tier, its flat amount, and its per-unit amount; empty for offers without tiers. |