Shipping profile
Every offer points at a store’s own shipping profile through itsshipping_profile_id field, joined via the read-only offer ↔ shipping_profile
link. The profile is what ties the offer’s items to the store’s shipping options
at checkout, so each store fulfills its slice of a multi-seller cart with its own
rates.
Master products carry no profile
Master products live in the shared catalog and have no shipping profile of their own. To keep multi-seller carts from losing their shipping methods on refresh,createOffersWorkflow links the offer’s master product to the offer’s
shipping profile. The product↔profile link is one-to-one, so the first offer’s
profile wins for a given master product. Later offers (including other stores’
offers on the same product) skip the link if a profile is already attached.
The one-to-one product↔profile link is a checkout-refresh accommodation, not
the source of truth for how a store ships. Each offer still carries its own
shipping_profile_id, which is what drives that store’s fulfillment.