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.
- Meal Prep / Subscription Box
- Data model
The tables behind Meal Prep / Subscription Box
Meal Prep / Subscription Box ships with 29 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
- 29
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Selling offer:
Catalogs, product categories, Products, product variants and Collections define the customer choice.
Purchase:
Store sessions, Carts, cart items, meal orders and meal lines follow browsing into an order.
Checkout value:
Payment methods, shipping methods, tax rates, discount rules, applied discounts and payment evidence support the financial record.
Delivery:
Inventory and fulfillment events tie saleable variants to warehouse position and delivery steps.
Customer case:
Subscribers, service locations, emails sent, operation receipts, product reviews and order refunds preserve the service history.
Every table, by feature
- Catalog and products6
- Carts and traffic7
- Meal orders8
- Payments and pricing9
- Inventory and fulfillment6
- Customer care9
- Shared and settings2
- Catalogs
Defines one storefront setup—currency, locale, region—used to run separate markets or regions.
- Product categories
Represents one category used to group and organize products for browsing.
Linked to Product categories - Products
Represents one item offered for sale, used to manage the catalog and storefront listings.
Linked to Catalogs, Product categories - Product variants
Represents one buyable version of a product, like a size or flavor, used to track its own price and stock.
Linked to Products - Collections
Represents a curated group of products, used to organize storefront merchandising.
- Inventory
Tracks how much of a variant is on hand at a warehouse, used to manage availability and reorders.
Linked to Product variants
- Store sessions
Captures one visit to the storefront, tracking where it came from, used to analyze traffic and conversions.
Linked to Subscribers - Carts
Represents an in-progress shopping cart, used to hold items a customer hasn't checked out yet.
Linked to Catalogs, Store sessions, Subscribers - Cart items
Represents one product added to a shopping cart, used to see what a customer intends to buy.
Linked to Product variants, Carts - Abandoned carts
Tracks a cart left without checkout, used to follow up and recover the lost sale.
Linked to Carts, Subscribers, Meal orders - Emails sent
Logs one email sent to a subscriber, used to track opens, clicks, and marketing performance.
Linked to Abandoned carts, Subscribers, Meal orders - Subscribers
Represents a customer who shops or subscribes, holding their contact info and order history.
- Meal orders
Represents one customer order for meal boxes, used to track payment, fulfillment, and status.
Linked to Catalogs, Shipping methods, Subscribers, Carts
- Meal orders
Represents one customer order for meal boxes, used to track payment, fulfillment, and status.
Linked to Catalogs, Shipping methods, Subscribers, Carts - Meal lines
Represents one menu item within an order, including portions and price, used to fulfill and bill it.
Linked to Product variants, Meal orders - Operation receipts
Logs one event or action taken on an order, used to audit what happened and when.
Linked to Meal orders, Users - Subscribers
Represents a customer who shops or subscribes, holding their contact info and order history.
- Service locations
Represents a shipping or billing address, used to deliver orders and bill customers correctly.
Linked to Subscribers - Carts
Represents an in-progress shopping cart, used to hold items a customer hasn't checked out yet.
Linked to Catalogs, Store sessions, Subscribers - Payment evidence
Records one payment attempt or transaction detail, used to verify and audit payments on an order.
Linked to Meal orders, Payment methods - Fulfillment events
Logs a shipping step for one order—label, tracking, delivery—used to trace where a package is.
Linked to Meal orders, Shipping methods
- Payment methods
Defines one way customers can pay, like a card or provider, used to configure checkout options.
Linked to Catalogs - Shipping methods
Defines one shipping option with its carrier and price, used to offer delivery choices at checkout.
Linked to Catalogs - Tax rates
Defines a tax rate for a jurisdiction, used to calculate the correct tax on orders.
- Discount rules
Defines one discount or promo code and its conditions, used to run sales and promotions.
- Config validation runs
Checkout configuration validation runs produced by the Pricing, tax, shipping, payment workflow. One row per validated configuration set; validation never mutates the merchant configuration.
- Payment evidence
Records one payment attempt or transaction detail, used to verify and audit payments on an order.
Linked to Meal orders, Payment methods - Applied discounts
Records a discount actually applied to an order, used to track savings given to customers.
Linked to Discount rules, Meal lines, Meal orders - Order refunds
Records a refund issued against an order, used to track returns and money given back.
Linked to Meal orders, Users - Meal orders
Represents one customer order for meal boxes, used to track payment, fulfillment, and status.
Linked to Catalogs, Shipping methods, Subscribers, Carts
- Inventory
Tracks how much of a variant is on hand at a warehouse, used to manage availability and reorders.
Linked to Product variants - Product variants
Represents one buyable version of a product, like a size or flavor, used to track its own price and stock.
Linked to Products - Meal orders
Represents one customer order for meal boxes, used to track payment, fulfillment, and status.
Linked to Catalogs, Shipping methods, Subscribers, Carts - Meal lines
Represents one menu item within an order, including portions and price, used to fulfill and bill it.
Linked to Product variants, Meal orders - Fulfillment events
Logs a shipping step for one order—label, tracking, delivery—used to trace where a package is.
Linked to Meal orders, Shipping methods - Shipping methods
Defines one shipping option with its carrier and price, used to offer delivery choices at checkout.
Linked to Catalogs
- Subscribers
Represents a customer who shops or subscribes, holding their contact info and order history.
- Service locations
Represents a shipping or billing address, used to deliver orders and bill customers correctly.
Linked to Subscribers - Meal orders
Represents one customer order for meal boxes, used to track payment, fulfillment, and status.
Linked to Catalogs, Shipping methods, Subscribers, Carts - Meal lines
Represents one menu item within an order, including portions and price, used to fulfill and bill it.
Linked to Product variants, Meal orders - Operation receipts
Logs one event or action taken on an order, used to audit what happened and when.
Linked to Meal orders, Users - Emails sent
Logs one email sent to a subscriber, used to track opens, clicks, and marketing performance.
Linked to Abandoned carts, Subscribers, Meal orders - Order refunds
Records a refund issued against an order, used to track returns and money given back.
Linked to Meal orders, Users - Product reviews
Represents a customer's review and rating of a product, used to manage feedback and reputation.
Linked to Meal orders, Products, Product variants, Subscribers - Customer wishlists
Holds a product a subscriber saved to buy later, used to alert them on restock or price drops.
Linked to Subscribers, Products, Product variants
Keys and references
A product variants record belongs to Products and is referenced by cart items, meal lines and Inventory. Meal orders joins a catalog, shipping method, address and optional subscriber or cart. Meal lines, payment evidence, fulfillment events, operation receipts and order refunds point back to that order. Order refunds.approved by and product reviews.moderated by point to Users. These references make the order number a useful starting point for a customer case.
Migration order
- Load Catalogs, product categories and core checkout definitions.
- Load Products and product variants, then Inventory by warehouse and variant.
- Load Subscribers and service locations before customer orders.
- Load store sessions, Carts and cart items if past browsing history is needed.
- Load meal orders and meal lines, then related payment, discount and fulfillment history.
- Load communication, review, operation and refund history after the order references exist.
Set up Meal Prep / Subscription Box your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.