Inventory · Odoo guide

Odoo for Dietary Supplement Companies: Lots, COAs, Batch Records and Recalls

Is Odoo a good fit for dietary supplement companies?

This guide is for dietary supplement brands and contract manufacturers that run Odoo with 10 to 150 users. Odoo covers lot and expiry tracking, supplier COAs, batch records, quality release, recall traces and ecommerce order sync once it is configured, and each remaining gap is usually one to five days of work.

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.

See also: What is the best Odoo partner for life sciences companies?; Who should be your Odoo GxP validation consultant?; How do I fix lot tracking that isn't working in Odoo?; How do I connect Odoo to Shopify?.

The ERP Firm · Last updated November 10, 2026

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.

RequirementOdoo app or featureTypical gapTypical fix effort
Lot on every component and finished batchLots & Serial Numbers, tracking By Lots (Community and Enterprise)Packaging and labels received without lots, or lots not required on manufacturing operation types2 to 6 hours, plus a counted adjustment for untracked stock
Expiry dates and FEFO pickingExpiration Dates (product_expiry) and the FEFO removal strategyNo Expiration Time on products, so lots arrive with no removal date, and FEFO set on some locations only2 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 receiptsCOAs kept in email or a shared drive, with no record of which COA matched which lot1 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 changed1 to 3 days
Batch production record (Subpart I)Manufacturing order (mrp.production) with consumed component lots, work orders and quality checksNo printable record in the layout your quality control personnel review, and yields kept on paper3 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 stockFinished lots can be reserved for sales orders before release1 to 2 days
Reserve samples by lotInternal transfer of sample units to a reserve sample locationSamples pulled but not recorded against the lot2 to 4 hours
Complaints and returns (Subparts N and O)Quality alerts with the lot, Helpdesk (Enterprise) and return transfers on the same lotComplaints logged outside Odoo with no lot reference1 to 2 days
Recall trace across every channelTraceability report on the lotThe trace stops at the 3PL or at Amazon FBA, where shipments carry no lot1 to 3 days to record lots on 3PL and inbound FBA shipments
DTC, Amazon and Shopify order syncAmazon Connector (Enterprise), and a Shopify connector module, iPaaS flow or private modulePublished stock includes quarantined or near-expiry lots2 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.

CheckWhere in OdooDone when
Every dietary ingredient, other component, packaging item, label and finished product is tracked by lotProduct form, Inventory tab, TrackingNo tracked product has stock on hand without a lot
Expiration Time is set on every finished product and dated componentProduct form, Inventory tabEach received or produced lot shows an expiration date and a removal date
FEFO is the removal strategy for every pick locationProduct categories, or Inventory > Configuration > LocationsA test sales order reserves the lot with the earliest removal date
Receipts pass through a quality locationWarehouse, Incoming Shipments set to 3 stepsComponents cannot reach stock before the receipt check passes
A supplier COA is attached and checked on each incoming lotQuality control point on the receipt operation typeEach component lot record holds its COA and a pass or fail result
Bills of materials are versionedPLM app, or archived bill of materials copies on CommunityEach manufacturing order links to the bill of materials version it used
Finished lots are held until releaseQuarantine location and a final quality checkSales cannot reserve a lot that quality control has not released
Reserve samples are recorded by lotInternal transfer to a reserve sample locationThe sample quantity shows on each finished lot
3PL and FBA shipments carry lots3PL feed and inbound FBA shipment transfersA mock recall reaches every sales channel
A mock recall has been run on stagingTraceability report on one finished lotThe 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

FAQ

Follow-up questions

Is Odoo a good ERP for dietary supplement companies?
Yes, for companies that need lot and expiry tracking, supplier COA checks, batch records, quality release and recall traces in the same system as sales and accounting. Most of it is configuration. The usual custom work is a batch record report and lot data from 3PL and FBA channels.
Can Odoo track lot numbers and expiration dates for supplements?
Yes. Lots & Serial Numbers and Expiration Dates are standard in Community and Enterprise on Odoo 16, 17 and 18. Each lot carries an expiration date and a removal date, and FEFO reserves the lot that expires first.
Does Odoo support 21 CFR Part 111?
No software meets Part 111 on its own. Odoo can hold the records Part 111 asks for, such as component specifications and COAs, the bill of materials as the master manufacturing record, the manufacturing order as the batch record and the release decision. Your written procedures and your quality control personnel make the system meet the rule.
How do you store supplier certificates of analysis in Odoo?
Attach the COA to the incoming lot and record the review as a quality check on the receipt step. With 3-step receipts, the component stays in the quality location until the check passes, so stock without a reviewed COA cannot be used in production.
Can Odoo sync supplement orders from Shopify and Amazon?
Yes. The Amazon Connector is part of Odoo Enterprise. Shopify needs a connector module, an iPaaS flow or a private module. Publish only released, in-date free quantity, and record lots on 3PL and FBA shipments so a recall reaches every channel.
How much does Odoo support for a supplement company cost?
US hourly partners commonly bill $175–$250/hr. The ERP Firm charges $5,000/mo up to 15 users, $8,500/mo for 16–50 and $14,000/mo for 51–150, billed quarterly, with unlimited queued requests.
Does The ERP Firm give regulatory or labeling advice?
No. The ERP Firm configures, builds and tests the Odoo side on staging. Product claims, labels and the content of your procedures stay with your quality unit and regulatory advisers. Contact hello@theerpfirm.com to scope the Odoo work.

Talk to us about your Odoo system

Bring your Odoo version, user count and the workflow that is causing problems.

Book a scoping call