How do you manage your outbound consigned stocks?

Product Development & Sourcing

Topic summary

Managing outbound consigned stock alongside Shopify inventory. The poster wants a way to track items placed on consignment with offline local vendors together with on-hand Shopify stock.

Current setup: Shopify holds both regular inventory and items sent on consignment. Consigned vendors are offline; stock movement there isn’t captured automatically.

Need: An app or workable process to manage consignment quantities within or alongside Shopify. Goal is a unified view of master stock plus consigned balances.

Constraint: Consigned stock counts are updated manually after periodic, offline stock checks with vendors, so data won’t be real-time.

Alternative considered: Track consigned items in Airtable (a spreadsheet-database) synced with Shopify via AirPower (an integration), using extra columns/tables for consignment fields.

Context: In consignment, goods remain the seller’s property and risk until sold; vendors reimburse after sale, making accurate parallel tracking necessary.

Status: Inquiry only; no solution or decision yet. Discussion remains open.

Summarized with AI on February 4. AI used: gpt-5.
1

I use Shopify as my all-in-one platform which contains not just my own stocks (available for sale on website) but also my “consigned” stocks meaning stocks I consigned to other local vendors (offline channels).

Wondering if there’s any app or workaround that someone here used to manage similar situation?

Alternatively, I am thinking I probably need to take this and manage it separately via Airtable (using AirPower sync + additional columns/ tables).

My objectives is to track my consigned stocks alongside current Shopify stock level (my consigned stock levels will only be updated manually every now and then through offline stock check with (outbound) consigned vendors.

NOTE: When I talk about “consignment”, these are basically stocks that still belong to me and I bear the risk if they aren’t sold. Consigned vendors reimburse me after selling them. Which is why I need to track them alongside my master stock level.