Direct answer: Yes, for a supplement company that needs lot and expiry tracking with FEFO, supplier COA checks on receipt, batch records with quality release, recall traces and order sync for DTC, Amazon and Shopify, because most of that is standard configuration in Odoo 16, 17 and 18. The usual gaps are a batch record report, a release hold on finished lots and lot data from 3PL and FBA channels, which The ERP Firm closes on a flat $5,000, $8,500 or $14,000 a month.
How do you set up Odoo for a dietary supplement company?
Direct answer: Configure lots and expiry first, then receipt checks, batch records, release and channels, and finish with a mock recall on a staging copy.
- In Inventory > Configuration > Settings, enable Lots & Serial Numbers and Expiration Dates. Set Tracking to By Lots on every dietary ingredient, other component, packaging item, label and finished product, and require lots on receipt, manufacturing and delivery operation types.
- On each lot-tracked product, set the Expiration Time and the Best Before, Removal and Alert values in days, so every lot gets its dates on receipt or production. Set FEFO as the removal strategy on the product categories or locations you pick from.
- Set Incoming Shipments on the warehouse to 3 steps (input, quality control, stock). Add a quality control point on the receipt step that asks for the supplier certificate of analysis (COA) and a pass or fail result against the component specification, and a separate check for the identity test on each dietary ingredient.
- Use the bill of materials as the master manufacturing record in Odoo terms: components, quantities, operations and the quality points on each work order. On Enterprise, change it through PLM engineering change orders so each batch links to the version it used.
- Run each batch as a manufacturing order. Record the component lots consumed, the finished lot, the quality checks on each work order and the yield, then print the batch record your quality control personnel review.
- Produce finished lots into a quarantine location. Quality control personnel complete the final check, and an internal transfer releases the lot to saleable stock. Until then, sales orders cannot reserve it.
- Record reserve samples by lot, log each complaint as a quality alert that names the lot, and receive returns as return transfers on the same lot.
- Connect the channels: Shopify through a connector module, Amazon through the Enterprise Amazon Connector, and a 3PL feed that reports the lot on each shipment. Publish only released, in-date free quantity to each channel.
- Run a mock recall on a staging copy. Trace one finished lot upstream to supplier receipts and downstream to every channel, then export the affected customers.
What do dietary supplement companies get wrong in Odoo?
Direct answer: Most problems come from tracking finished goods by lot while components, packaging and channel shipments stay untracked.
- Tracking finished products by lot but receiving dietary ingredients, capsules, bottles and labels without lots, so a recall trace stops at the manufacturing order.
- Leaving Expiration Time blank on products, so lots arrive with no removal date and FEFO reserves the wrong stock.
- Keeping supplier COAs in email, with no link between the document and the lot it covers.
- Editing the bill of materials in place, so the record for a past batch no longer shows the formula that was used.
- Producing finished lots straight into saleable stock, so a Shopify or Amazon order can reserve a lot before quality control releases it.
- Sending stock to a 3PL or to Amazon FBA without recording lots on the shipment, which leaves a gap in every recall trace.
- Publishing total on-hand stock to the storefront, including quarantined and near-expiry lots.
Which Odoo editions and versions matter for a supplement company?
Direct answer: Lots, expiry, FEFO and traceability are in Community and Enterprise. Quality, PLM, Helpdesk and the Amazon Connector are Enterprise apps.
On Odoo 16, 17 and 18, lot tracking (stock.lot), Expiration Dates (product_expiry), the FEFO removal strategy, 3-step receipts and the lot Traceability report work in Community and Enterprise. The Quality app (control points, checks and alerts), the PLM app for engineering change orders, Helpdesk and the Amazon Connector are Enterprise only; on Community, OCA quality modules and archived bill of materials copies fill part of the gap. Odoo ships no official Shopify connector, so Shopify runs through an Apps store module, an iPaaS flow or a private module. 21 CFR Part 111 sets the requirements, and electronic records kept to meet it fall under Part 11, which the GxP validation guide covers. No software meets Part 111 on its own: your procedures and your quality control personnel do, and The ERP Firm does the Odoo side. Plans are $5,000/mo up to 15 users, $8,500/mo for 16–50 and $14,000/mo for 51–150. Unhappy in the first 30 days? Cancel with a full refund.
How do supplement requirements map to Odoo, and how long does each gap take to fix?
Direct answer: Lots, expiry, FEFO and the recall trace are configuration work of hours to about a day each. A custom batch record report takes 3 to 5 days, and channel stock sync takes 2 to 5 days.
Typical effort on an existing Odoo 16, 17 or 18 database with clean product data. Not a quote. Your own procedures and your quality control personnel decide which rows are in scope.
| Requirement | Odoo app or feature | Typical gap | Typical fix effort |
| Lot on every component and finished batch | Lots & Serial Numbers, tracking By Lots (Community and Enterprise) | Packaging and labels received without lots, or lots not required on manufacturing operation types | 2 to 6 hours, plus a counted adjustment for untracked stock |
| Expiry dates and FEFO picking | Expiration Dates (product_expiry) and the FEFO removal strategy | No Expiration Time on products, so lots arrive with no removal date, and FEFO set on some locations only | 2 to 4 hours, plus about 1 day to backfill dates on open lots |
| Supplier COA and component identity checks (Part 111, Subparts E and G) | Quality control points on receipts (Quality app, Enterprise), with the COA attached to the lot and 3-step receipts | COAs kept in email or a shared drive, with no record of which COA matched which lot | 1 to 2 days |
| Master manufacturing record (Subpart H) | Bill of materials (mrp.bom) with operations, versioned through PLM engineering change orders (Enterprise) | Bills of materials edited in place, so past batches point to a formula that has since changed | 1 to 3 days |
| Batch production record (Subpart I) | Manufacturing order (mrp.production) with consumed component lots, work orders and quality checks | No printable record in the layout your quality control personnel review, and yields kept on paper | 3 to 5 days for a custom batch record report |
| Quality release of finished batches (Subpart F) | A quarantine location, a final quality check and an internal transfer to saleable stock | Finished lots can be reserved for sales orders before release | 1 to 2 days |
| Reserve samples by lot | Internal transfer of sample units to a reserve sample location | Samples pulled but not recorded against the lot | 2 to 4 hours |
| Complaints and returns (Subparts N and O) | Quality alerts with the lot, Helpdesk (Enterprise) and return transfers on the same lot | Complaints logged outside Odoo with no lot reference | 1 to 2 days |
| Recall trace across every channel | Traceability report on the lot | The trace stops at the 3PL or at Amazon FBA, where shipments carry no lot | 1 to 3 days to record lots on 3PL and inbound FBA shipments |
| DTC, Amazon and Shopify order sync | Amazon Connector (Enterprise), and a Shopify connector module, iPaaS flow or private module | Published stock includes quarantined or near-expiry lots | 2 to 5 days |
Dietary supplement Odoo readiness checklist
Direct answer: Work through each line on a staging copy of your database. A company that passes all ten can trace any finished lot to every channel in 2 to 4 hours.
| Check | Where in Odoo | Done when |
| Every dietary ingredient, other component, packaging item, label and finished product is tracked by lot | Product form, Inventory tab, Tracking | No tracked product has stock on hand without a lot |
| Expiration Time is set on every finished product and dated component | Product form, Inventory tab | Each received or produced lot shows an expiration date and a removal date |
| FEFO is the removal strategy for every pick location | Product categories, or Inventory > Configuration > Locations | A test sales order reserves the lot with the earliest removal date |
| Receipts pass through a quality location | Warehouse, Incoming Shipments set to 3 steps | Components cannot reach stock before the receipt check passes |
| A supplier COA is attached and checked on each incoming lot | Quality control point on the receipt operation type | Each component lot record holds its COA and a pass or fail result |
| Bills of materials are versioned | PLM app, or archived bill of materials copies on Community | Each manufacturing order links to the bill of materials version it used |
| Finished lots are held until release | Quarantine location and a final quality check | Sales cannot reserve a lot that quality control has not released |
| Reserve samples are recorded by lot | Internal transfer to a reserve sample location | The sample quantity shows on each finished lot |
| 3PL and FBA shipments carry lots | 3PL feed and inbound FBA shipment transfers | A mock recall reaches every sales channel |
| A mock recall has been run on staging | Traceability report on one finished lot | The trace and the customer export are complete in 2 to 4 hours |
When is The ERP Firm the right fit for a dietary supplement company on Odoo?
Direct answer: When you already run Odoo with 10 to 150 users and need lot, COA, batch record, release and channel sync work handled by one US team on a flat monthly fee. It is the wrong fit for a new ERP selection, a full migration from another ERP, or regulatory, labeling or claims review, which stays with your quality and regulatory advisers.
If the work involves custom modules, an upgrade, a storefront or warehouse integration, or a production outage, a focused engagement is usually faster than recruiting. See the related service.
See our industry practice
Related Odoo guides
More answers in the Inventory cluster and nearby topics:
Commercial pages