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.
- E-commerce ERP
- Data model and import order
The tables behind E-commerce ERP
E-commerce ERP ships with 36 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
- 36
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Channels and product mapping:
Channels, Stores, channel products, channel listings, channel orders, channel order lines and Products connect an external purchase to stocked identity.
Customer orders:
Accounts, contact persons, sales orders and sales order lines carry accepted local demand and customer context.
Purchasing and receiving:
Suppliers, purchase orders, purchase order lines, goods receipts and goods receipt lines preserve the supplier commitment and physical arrival.
Inventory and transfers:
Inventory positions, inventory reservations, stock movements, Warehouses and Locations distinguish stock, claims and posted changes.
Fulfillment and delivery:
Pick tasks, Fulfillments and fulfillment lines show assigned picks and actual shipped quantities.
Returns and inspection:
Returns and return lines carry reason, quantity and disposition.
Receivables and payments:
Invoices, invoice lines, payment accounts, payment transactions, processor settlements and processor settlement lines connect the receivable to processor money.
Every table, by feature
- Channels and product mapping7
- Customer orders6
- Purchasing and receiving6
- Inventory and transfers7
- Fulfillment and delivery6
- Returns and inspection7
- Receivables and payments7
- Shared and settings3
- Channel products
Channel SKU to canonical product mapping.
Linked to Channels, Products - Channel listings
Catalogue listing state per channel and product.
Linked to Channels, Products - Channels
Sales channels with fee and settlement characteristics.
Linked to Stores - Stores
Storefronts that publish catalogue and receive orders.
Linked to Entities, Currencies - Products
Canonical stocked SKU for each physical product or produced kit.
Linked to Units of measure - Channel orders
Imported channel purchases pending mapping and local acceptance.
Linked to Entities, Channels, Stores, Accounts - Channel order lines
Channel purchase lines with SKU mapping status.
Linked to Channel orders, Products
- Accounts
Entity-scoped customer accounting identity.
Linked to Users, Entities - Contact persons
Known business and customer contacts for an account.
Linked to Accounts - Channel orders
Imported channel purchases pending mapping and local acceptance.
Linked to Entities, Channels, Stores, Accounts - Channel order lines
Channel purchase lines with SKU mapping status.
Linked to Channel orders, Products - Sales orders
Accepted customer orders with stage, owner and totals.
Linked to Users, Entities, Accounts, Currencies - Sales order lines
Ordered products, quantities, prices and fulfilment progress.
Linked to Sales orders, Products
- Suppliers
Entity purchasing counterparties.
Linked to Entities - Purchase orders
Approved supplier commitments with promised arrival.
Linked to Users, Entities, Suppliers, Warehouses - Purchase order lines
Ordered supply quantities and received progress.
Linked to Purchase orders, Products - Goods receipts
Arrival and acceptance evidence for purchased supply.
Linked to Entities, Purchase orders, Suppliers, Warehouses - Goods receipt lines
Received, accepted and rejected quantities per receipt.
Linked to Goods receipts, Products - Warehouses
Physical sites hosting entity-owned stock positions.
Linked to Users
- Products
Canonical stocked SKU for each physical product or produced kit.
Linked to Units of measure - Inventory positions
Current on-hand, reserved and available quantity by product, warehouse and owner.
Linked to Entities, Products, Warehouses, Locations - Inventory reservations
Active claims against available stock from orders and channel demand.
Linked to Products, Warehouses, Sales order lines - Stock movements
Posted stock movement evidence per product, warehouse and movement kind.
Linked to Entities, Products, Warehouses - Warehouses
Physical sites hosting entity-owned stock positions.
Linked to Users - Locations
Warehouse bins, staging and transit custody locations.
Linked to Warehouses - Units of measure
Dimension and precision for stock quantities.
- Sales orders
Accepted customer orders with stage, owner and totals.
Linked to Users, Entities, Accounts, Currencies - Sales order lines
Ordered products, quantities, prices and fulfilment progress.
Linked to Sales orders, Products - Fulfillments
Pick, pack and ship execution for customer orders.
Linked to Users, Entities, Sales orders, Warehouses - Fulfillment lines
Shipped quantities per order line.
Linked to Fulfillments, Sales order lines, Products - Pick tasks
Warehouse pick work for a fulfilment.
Linked to Users, Fulfillments, Warehouses, Locations - Inventory reservations
Active claims against available stock from orders and channel demand.
Linked to Products, Warehouses, Sales order lines
- Returns
Customer return requests, inspection and refund state.
Linked to Entities, Accounts, Sales orders, Channels - Return lines
Returned products, values and disposition decisions.
Linked to Returns, Products - Sales orders
Accepted customer orders with stage, owner and totals.
Linked to Users, Entities, Accounts, Currencies - Accounts
Entity-scoped customer accounting identity.
Linked to Users, Entities - Products
Canonical stocked SKU for each physical product or produced kit.
Linked to Units of measure - Stock movements
Posted stock movement evidence per product, warehouse and movement kind.
Linked to Entities, Products, Warehouses - Payment transactions
Captured charges, refunds and chargebacks per processor.
Linked to Payment accounts, Channel orders, Sales orders
- Invoices
Customer invoices, due dates and outstanding balances.
Linked to Entities, Accounts, Sales orders, Currencies - Invoice lines
Billed lines supporting each invoice total.
Linked to Invoices, Products - Payment accounts
Processor accounts used to collect and settle payments.
Linked to Entities, Currencies - Payment transactions
Captured charges, refunds and chargebacks per processor.
Linked to Payment accounts, Channel orders, Sales orders - Processor settlements
Processor settlement periods closed only after reconciliation.
Linked to Payment accounts, Entities - Processor settlement lines
Settlement lines matched against processor transactions.
Linked to Processor settlements, Payment transactions - Accounts
Entity-scoped customer accounting identity.
Linked to Users, Entities
Keys and references
Retain external order key and external revision on channel orders when importing updates. Channel products links an external SKU to Products within a Channel; channel order lines keep that SKU and their mapping status. Preserve transaction key on payment transactions and the linked settlement line. Keep Entity, Warehouse, Currency and Product references intact through the order, stock and finance cycle. Never use a display title as the only import key.
Migration order
- Load Currencies, Entities, Users, units of measure, Warehouses and Locations.
- Load Stores, Channels, Products, channel products, channel listings, Accounts, contact persons and Suppliers.
- Load inventory positions and opening stock movements, then reconcile available quantity by entity and warehouse.
- Load open channel orders and channel order lines, sales orders and sales order lines, purchase orders and purchase order lines.
- Load goods receipts, reservations, picks, fulfillments, returns, invoices and processor transactions with their original links.
- Reconcile line quantities, outstanding invoice amounts and settlement variances before expanding the operating scope.
Set up E-commerce ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.