Skip to content

Sell-out

Sell-out records a sale observed at a selling location when identifying the final destination is not relevant or possible.

The most common example is a consumer sale at a store: planning needs the store, date, and material, but does not need to identify the individual consumer. Sell-out may also represent a distributor's sales to market when that distributor shares its data.

Compare this structure with sell-in, which preserves both origin and destination.

Path in the platform

Data > Data Operations > Transactional Data > Sales / Inventory > Historical Sales > Sales / Sell-out

Dark-theme Sell-out download operation showing endpoint, export scope, and reference window

The operation can extract a date range or the complete dataset. For a range, provide both start and end dates before choosing the file format.

Granularity and identification

  • Granularity: one transaction or aggregate by date, material, selling location, and unit.
  • Identification: documentId must distinguish every loaded row.

documentId may be the source transaction identifier or a stable combination. For a load consolidated by day, location, and material, use for example 2026-05-31|STORE-02|MAT-001. If unit, offer, channel, or another dimension separates rows, include it in the ID or consolidate before loading.

For monthly-only processes, the month's total can be loaded on either the first or last day of the month. Consolidation assigns the full value to the monthly bucket without spreading it across days. Choose one convention and preserve it across loads. See Identifiers and periodicity.

Required fields

Field Meaning
documentId Unique transaction or aggregate-row identifier
referenceDate Sale date or chosen reference date for the aggregate period
originLocationId Selling Location where demand was observed
materialId Material sold
quantity Quantity sold

Optional fields

Field Meaning Default Value When Not Provided
uomId Unit in which quantity is reported Value from Global Planning Parameters (default there: UN)
totalValue Total sales value 0
discounts Associated discounts 0
tax Associated taxes 0
cost Associated cost 0

When uomId is provided, it must exist in Units of Measure and be convertible to the plan unit.

Dependencies

Used by

Distributor-shared sell-out

In a collaborative process, a supplier may retain sell-in from its plant or distribution center to a distributor and receive that distributor's sell-out and inventory. The sell-out forecast, combined with current and projected distributor inventory, supports the future sell-in projection required to replenish the distributor.

The two series represent different points in the flow and should not be added without separating their scopes.

  • do not reuse a documentId for different rows;
  • register materials, locations, and units before loading sales;
  • define a clear rule for returns and negative quantities;
  • load only closed historical periods;
  • reconcile period totals with the source system.