Manufacturing ERP · Working demo

Custom ERP for Batch Manufacturing

MarqueFactory built a working ERP demo for Al Tabook Food Flavours. It shows how a food manufacturer can scan product barcodes to receive goods offline, use QR labels to trace production batches during dispatch and returns, and calculate material costs from actual batch usage.

The challenge: connecting stock, batches, and orders

The manufacturer needed one system for purchasing, inventory, production, sales, returns, and finance. Staff needed to record deliveries and prepare batches through short internet outages. Managers needed to know what each batch cost, which lots went into each order, and how returns changed stock and gross profit.

What MarqueFactory built

The ERP is an installable web app for office desktops. It uses Node.js and PostgreSQL on the server and IndexedDB to keep pending work in the browser.

  • Purchasing and inventory: Create purchase orders, record partial deliveries, and track raw materials, packaging, and finished goods.
  • Production and batch costing: Save each formula revision separately. Divide the cost of the ingredients actually used by the quantity of sellable output to find the material cost per unit. Pending batches keep their formula version and can be flagged for review if the formula changes or stock is insufficient.
  • Sales and fulfillment: Dispatch from available lots and print a production sheet for any shortage. Calculate gross profit using the recorded costs of the lots actually shipped.
  • Returns and finance: Trace returns to the original invoice and batch. Put approved resale stock back into inventory at its original cost, and track credit notes, refunds, partial payments, and cash and bank balances.

Barcode scanning for offline receiving

Receiving staff scan a product barcode to look up the item, confirm the quantity, and save the goods receipt. Lookup works offline using the product catalog stored on the device.

The saved receipt survives a page reload and syncs automatically when the app is open and the connection returns. Every retry uses the same receipt ID to prevent duplicate stock entries.

QR labels for batch traceability

Once a production batch is posted, staff can print a label with the product name, batch number, and a QR code. Reprinting the label preserves the same QR code.

For dispatch, staff select the sales order. For a return, they select the original invoice. They then scan the batch label to find the matching batch eligible for that transaction.

Example workflow: a 100 kg order

Fulfillment stepQuantity
Allocate from regular stock25 kg
Allocate from approved resale stock15 kg
Generate a production sheet for the shortage60 kg

When the order ships, the ERP uses the recorded cost of each lot dispatched to calculate gross profit.

What the demo verified

Documented Chrome testing verified four behaviors:

  • The app reloads without an internet connection.
  • A goods receipt saved offline stays available after reloading.
  • The receipt syncs automatically when connectivity returns and the app is open.
  • Staff can look up a product by barcode while offline.

Discuss a custom ERP for your operations

Tell us how your team buys materials, runs batches, and fulfills orders. We can help you scope a custom ERP around the work your team needs to do every day.

Explore our custom web application development services for internal operations.

Discuss your ERP project