Data model
| Field | Description |
|---|---|
id | Prefixed with offer_ |
seller_id | The seller who owns the listing |
product_id / variant_id | The master catalog entry the offer sells |
sku | The seller’s own SKU — unique per seller |
ean / upc | Optional barcodes, searchable |
shipping_profile_id | The seller’s shipping profile used to fulfill this offer |
created_by | The member who created the offer |
metadata | Free-form JSON |
(seller_id, sku) pair is unique: a seller cannot list the same SKU twice.
Relationships
Offers sit at the center of the seller’s commercial graph. Module links connect each offer to:- Seller — the listing owner
- Product and variant — the master catalog entry
- Price — offer-scoped pricing (see below)
- Inventory item — offer-scoped stock (see below)
- Shipping profile — how the offer ships
- Cart and order line items — which offer a purchased line came from
Offer-scoped pricing
Offers share the variant’s price set, scoped by an offer rule — each offer carries its own prices without duplicating the variant. The storefront computes acalculated_price per offer, so two sellers listing the same variant can show different prices side by side.
Offer-scoped inventory
Inventory is linked to the offer, not the variant. Each seller manages stock for their own listing independently; a variant has no marketplace-wide stock figure of its own.Offers at checkout
When a customer buys, the cart line item links to the specific offer that was purchased. The link is preserved onto the order line item, so fulfillment, commission calculation, and payouts all resolve to the right seller — even when several sellers list the same variant.Discovery
The Store API exposes offers directly:Where offers appear
| Surface | Capability |
|---|---|
| Vendor Portal | Full lifecycle — create offers, edit price and stock, manage variants and inventory |
| Admin Panel | Oversight — list and inspect all offers with their store, pricing, inventory, and the associated master product |
| Store API | Browse offers per product, with per-offer calculated prices |
Next steps
Products
The shared master catalog offers are built on.
Order Groups
How multi-seller purchases split into per-seller orders.