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.
- OMS for Grocery and Supermarkets
- Data model
The tables behind OMS for Grocery and Supermarkets
OMS for Grocery and Supermarkets ships with 14 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
- 14
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Store and people
Stores, store associates, Users and Shoppers identify the location, accountable worker and shopper.
Order and assortment
Grocery orders links the store and shopper; basket lines links each ordered item to grocery SK us.
Review and fulfillment
Order review decisions, fulfillment handoffs and pick and delivery events record decisions and handoffs against the order.
Evidence and issues
Fulfillment receipts, fulfillment exceptions, tender evidence and order documents retain operations, problems, payment context and attachments.
Every table, by feature
- Grocery orders6
- Shopper and assortment6
- Review and decisions6
- Pick and delivery6
- Exceptions and correction7
- Tender and evidence6
- Shared and settings2
- Grocery orders
Grocery and supermarket orders from capture through store pick, local delivery, substitution and returns.
Linked to Stores, Store associates, Shoppers - Basket lines
Individual grocery basket lines linking an order to a perishable or center-store SKU with substitution consent.
Linked to Grocery orders, Grocery SK us - Grocery SK us
Sellable grocery SK us including perishable items, departments, pack sizes and substitution eligibility.
Linked to Stores - Shoppers
Grocery shoppers and households, with delivery address, ordering channel and substitution preferences.
Linked to Stores - Fulfillment receipts
Recorded, verified, failed or corrected fulfillment receipts that evidence each grocery order operation.
Linked to Stores, Store associates, Grocery orders - Order documents
Documents and attachments supporting a grocery order, such as substitution notes and delivery proof.
Linked to Grocery orders, Stores
- Grocery SK us
Sellable grocery SK us including perishable items, departments, pack sizes and substitution eligibility.
Linked to Stores - Shoppers
Grocery shoppers and households, with delivery address, ordering channel and substitution preferences.
Linked to Stores - Grocery orders
Grocery and supermarket orders from capture through store pick, local delivery, substitution and returns.
Linked to Stores, Store associates, Shoppers - Basket lines
Individual grocery basket lines linking an order to a perishable or center-store SKU with substitution consent.
Linked to Grocery orders, Grocery SK us - Order documents
Documents and attachments supporting a grocery order, such as substitution notes and delivery proof.
Linked to Grocery orders, Stores - Stores
Grocery stores and supermarket locations that own orders, SK us, associates and shoppers.
- Grocery orders
Grocery and supermarket orders from capture through store pick, local delivery, substitution and returns.
Linked to Stores, Store associates, Shoppers - Basket lines
Individual grocery basket lines linking an order to a perishable or center-store SKU with substitution consent.
Linked to Grocery orders, Grocery SK us - Fulfillment exceptions
Grocery fulfillment exceptions: stock shortage, substitution issue, spoiled item, address and late delivery.
Linked to Grocery orders, Store associates - Order review decisions
Independent review decisions on grocery orders that need approval, return or escalation.
Linked to Stores, Store associates, Grocery orders - Fulfillment receipts
Recorded, verified, failed or corrected fulfillment receipts that evidence each grocery order operation.
Linked to Stores, Store associates, Grocery orders - Order documents
Documents and attachments supporting a grocery order, such as substitution notes and delivery proof.
Linked to Grocery orders, Stores
- Grocery orders
Grocery and supermarket orders from capture through store pick, local delivery, substitution and returns.
Linked to Stores, Store associates, Shoppers - Basket lines
Individual grocery basket lines linking an order to a perishable or center-store SKU with substitution consent.
Linked to Grocery orders, Grocery SK us - Pick and delivery events
Store pick, pack, out-for-delivery, delivered and returned events against a grocery order.
Linked to Grocery orders, Stores - Fulfillment handoffs
Handoff of a grocery order between fulfillment channels such as store pick, curbside and local delivery.
Linked to Grocery orders, Stores - Fulfillment receipts
Recorded, verified, failed or corrected fulfillment receipts that evidence each grocery order operation.
Linked to Stores, Store associates, Grocery orders - Fulfillment exceptions
Grocery fulfillment exceptions: stock shortage, substitution issue, spoiled item, address and late delivery.
Linked to Grocery orders, Store associates
- Fulfillment exceptions
Grocery fulfillment exceptions: stock shortage, substitution issue, spoiled item, address and late delivery.
Linked to Grocery orders, Store associates - Grocery orders
Grocery and supermarket orders from capture through store pick, local delivery, substitution and returns.
Linked to Stores, Store associates, Shoppers - Basket lines
Individual grocery basket lines linking an order to a perishable or center-store SKU with substitution consent.
Linked to Grocery orders, Grocery SK us - Order review decisions
Independent review decisions on grocery orders that need approval, return or escalation.
Linked to Stores, Store associates, Grocery orders - Fulfillment receipts
Recorded, verified, failed or corrected fulfillment receipts that evidence each grocery order operation.
Linked to Stores, Store associates, Grocery orders - Pick and delivery events
Store pick, pack, out-for-delivery, delivered and returned events against a grocery order.
Linked to Grocery orders, Stores - Order documents
Documents and attachments supporting a grocery order, such as substitution notes and delivery proof.
Linked to Grocery orders, Stores
- Tender evidence
Tender and payment evidence captured against a grocery order, including EBT SNAP and store credit.
Linked to Grocery orders - Order documents
Documents and attachments supporting a grocery order, such as substitution notes and delivery proof.
Linked to Grocery orders, Stores - Fulfillment receipts
Recorded, verified, failed or corrected fulfillment receipts that evidence each grocery order operation.
Linked to Stores, Store associates, Grocery orders - Grocery orders
Grocery and supermarket orders from capture through store pick, local delivery, substitution and returns.
Linked to Stores, Store associates, Shoppers - Order review decisions
Independent review decisions on grocery orders that need approval, return or escalation.
Linked to Stores, Store associates, Grocery orders - Pick and delivery events
Store pick, pack, out-for-delivery, delivered and returned events against a grocery order.
Linked to Grocery orders, Stores
Keys and references
Grocery orders is the central operating record. Basket lines.grocery order, order review decisions.grocery order and pick and delivery events.grocery order point back to it. Grocery orders.Store points to Stores, while grocery orders.Shopper and grocery orders.delivery recipient point to Shoppers. Store associates.User links the associate to Users. Order documents and fulfillment receipts also reference the store and order, so evidence can be traced without inferring a match from a text label.
Migration order
- Load Stores and Users, then store associates for those locations.
- Load Shoppers and grocery SK us with their store references.
- Load grocery orders with the intended owner, shopper and recipient.
- Load basket lines and the relevant prior decisions, documents, tender evidence and receipts.
- Reconcile fulfillment events, handoffs and exceptions against each order.
Set up OMS for Grocery and Supermarkets your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.