These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Dropshipping SCM
- Data model
The tables behind Dropshipping SCM
Dropshipping SCM ships with 13 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 13
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Order context:
Organizations, Customers, team members and customer orders identify the operator, buyer, owner and promise.
Order detail:
Order lines and Products show requested SKU quantities and product identity.
Supplier handoff:
Supplier routing and review decisions keep the route and independent decision linked to the order.
Operating evidence:
Fulfillment events, payment evidence and operation receipts record movement, provider events and action results.
Supporting files and identity:
Record attachments and Users support evidence visibility and staff identity.
Every table, by feature
- Customer orders6
- Supplier routing6
- Order lines5
- Payment evidence3
- Fulfillment5
- Operations review6
- Shared and settings1
- Customer orders
Drop-ship customer orders with lifecycle status and promised dates.
Linked to Organizations, Team members, Customers - Customers
Customer accounts that place drop-ship orders.
Linked to Organizations - Organizations
Operating organizations that own drop-ship order operations.
- Team members
Internal staff with organization membership, role and platform identity.
Linked to Organizations, Users - Order lines
Order line details with ordered, allocated and shipped units.
Linked to Customer orders - Operation receipts
Idempotent operation receipts keyed by operation key and expected revision.
Linked to Customer orders
- Supplier routing
Drop-ship supplier routing extensions with review and completion state.
Linked to Customer orders, Organizations - Customer orders
Drop-ship customer orders with lifecycle status and promised dates.
Linked to Organizations, Team members, Customers - Order lines
Order line details with ordered, allocated and shipped units.
Linked to Customer orders - Review decisions
Independent review decisions recorded against order revisions.
Linked to Customer orders, Team members - Operation receipts
Idempotent operation receipts keyed by operation key and expected revision.
Linked to Customer orders - Organizations
Operating organizations that own drop-ship order operations.
- Order lines
Order line details with ordered, allocated and shipped units.
Linked to Customer orders - Customer orders
Drop-ship customer orders with lifecycle status and promised dates.
Linked to Organizations, Team members, Customers - Products
Product master data with SKU, base unit and standard price.
- Fulfillment events
Allocated, picked, shipped, delivered and returned fulfillment events.
Linked to Customer orders, Products - Supplier routing
Drop-ship supplier routing extensions with review and completion state.
Linked to Customer orders, Organizations
- Payment evidence
Provider payment events with verification state and provider references.
Linked to Customer orders - Customer orders
Drop-ship customer orders with lifecycle status and promised dates.
Linked to Organizations, Team members, Customers - Operation receipts
Idempotent operation receipts keyed by operation key and expected revision.
Linked to Customer orders
- Fulfillment events
Allocated, picked, shipped, delivered and returned fulfillment events.
Linked to Customer orders, Products - Products
Product master data with SKU, base unit and standard price.
- Customer orders
Drop-ship customer orders with lifecycle status and promised dates.
Linked to Organizations, Team members, Customers - Order lines
Order line details with ordered, allocated and shipped units.
Linked to Customer orders - Supplier routing
Drop-ship supplier routing extensions with review and completion state.
Linked to Customer orders, Organizations
- Review decisions
Independent review decisions recorded against order revisions.
Linked to Customer orders, Team members - Operation receipts
Idempotent operation receipts keyed by operation key and expected revision.
Linked to Customer orders - Record attachments
Supporting files attached to customer orders with visibility scope.
Linked to Customer orders, Team members - Customer orders
Drop-ship customer orders with lifecycle status and promised dates.
Linked to Organizations, Team members, Customers - Supplier routing
Drop-ship supplier routing extensions with review and completion state.
Linked to Customer orders, Organizations - Team members
Internal staff with organization membership, role and platform identity.
Linked to Organizations, Users
Keys and references
Use stable organization and customer codes, product SK us, customer order numbers and external order IDs. Match provider events by their provider event IDs and shipment events by their external event IDs. Keep routing acknowledgement IDs separate from shipment IDs. Review decisions carry source revisions; operation receipts carry expected revisions and operation keys. Preserve these identifiers during migration so a replay can be investigated against its original record.
Migration order
- Load Organizations, Users and team members with the intended organization membership.
- Load Customers and Products with stable codes and SK us.
- Load customer orders and order lines, checking owners, customer references and promised dates.
- Load supplier routing, review decisions and record attachments linked to the appropriate order revision.
- Load payment evidence, fulfillment events and operation receipts with original external identifiers; reconcile a sample of open orders before daily use.
Set up Dropshipping SCM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.