Skip to main content
The Offer domain is owned by the Offer module. This reference lists its data model and fields. For the full module overview, see the Offer overview.

​
Offer

Table offer, id prefix offer. A store’s listing against a master product variant. Price and inventory are attached through links rather than stored on the row. Uniqueness: (seller_id, sku) is unique while deleted_at IS NULL, so a store can’t reuse a SKU across its live offers, but different stores may share SKU strings. Indexes also cover variant_id, product_id, seller_id, shipping_profile_id, ean, and upc.

​
Linked data

The offer’s price ladder, inventory, and related records aren’t columns on the offer table. They’re joined through links and only present when requested:
variant_count (and the companion offer_ids list) are computed only when offers are listed grouped by store (group_by_seller). On ungrouped reads they are absent.
See the Links reference for the full set of module links.