BimpBlog

Batch Tracking for Cosmetics: How to Find the Batch of a Cream From a Customer Complaint

A fictional cosmetics maker answers a complaint by batch number in 15 minutes. Steps in Bimp: batch mask, raw materials, assembly, Stock Movement report.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • Batch tracking for cosmetics lets you take a batch number and find the production date, the raw materials and the sales by channel. For a fictional cream maker this is 15 minutes instead of half a day.
  • In Bimp a batch of finished cream gets a number from a mask during assembly, and raw materials arrive with supplier batches. The "Stock Movement" report is filtered by batch number.
  • In the example a batch of 480 jars went out like this: 200 through the own web shop, 150 through marketplaces and 130 to two distributors for €585.

The company is fictional. Every action in Bimp is a real product feature. The figures in the example are invented, and the arithmetic can be checked on a calculator.

Batch tracking for cosmetics makes it possible to answer a customer complaint by batch number: when the cream was cooked, from which raw materials, and how many jars went into each channel. In the fictional company Green Meadow Cosmetics such an answer used to take half a day, and with batches in Bimp it takes 15 minutes.

A customer wrote that the lavender cream had turned runny. She named the batch number from the jar, and from there the work goes by documents, with no questioning on the shop floor.

Why does a complaint about one cream turn into half a day of searching?

Green Meadow Cosmetics (a fictional company) makes natural cosmetics and employs 18 people. The range is a hand cream in five scents and two sizes, 50 and 100 ml. It sells through its own web shop, marketplaces and two distributors.

Five scents in two sizes make 10 items. A year brings 30 batches, so each item accounts for 3 batches: 10 × 3 = 30. When the system holds a single product “Hand cream” with no breakdown by scent and batch, a complaint raises several questions at once. Which cream is it, from which raw materials, when was it cooked and who else got jars from the same cook.

The shop remembers that the shea butter was changed in November. But without documents nobody can say which batch of butter went into which batch of cream. That is why half a day goes into searching purchasing, shift and shipment tables.

How do you set up batch tracking for cosmetics in Bimp?

The path from raw material to sale takes six steps. A help article sits next to each.

Step 1. Product cards. Each scent and size of the cream has its own product card: “Hand cream, lavender, 50 ml” and so on. Modifications do not fit here, because a product with modifications cannot have a specification. They suit products that are not assembled by a specification: the scent becomes a variant of one card with its own balance and price (Modifications).

Step 2. Batches and the number mask. In the company accounting settings you turn on batch accounting, and in the product card, in the “Accounting” section, the “Use batches” switch. The switch “Set the same batch number (Production)” gives one batch number to all units of output in a document. The number is named by a mask, and the same mask can rename it with the “Overwrite batch names” button. A sample number in the help is 2/26.01.2026/1. The rules are described in Serial number tracking and Production overview, and the new masks appeared in update 123 (Update 123).

Step 3. The cream specification. In the specification “Hand cream, lavender, 50 ml” you list the materials: shea butter, base oil, emulsifier, lavender essential oil. Each has a loss percentage, and the system calculates the total quantity to take. Details in the help: Specifications.

Step 4. Receipt of raw materials with batches. Raw materials arrive with the “Goods receipt” document, and the Create batches button creates batches by the mask. The supplier’s batch number is written into the document and becomes visible in the raw material balances (Goods receipt with serial numbers).

Step 5. Assembly. In the “Assembly” document, on the “Products” tab, you click Create batches, and the finished cream is posted with a number from the mask. On the “Materials” tab the Fill by batches button selects the raw material batches automatically or lets you choose them by hand. This records which batch of butter went into this batch of cream (Assembly).

Step 6. Sale with a batch and the report. In the “Sales of goods and services” document the manager attaches the shipped jar to a batch (Shipment). The “Stock Movement” report shows, for each warehouse and batch, the opening balance, receipts, sales, write-offs and the closing balance (Stock Movement report).

Challenge

A customer complains about the consistency of the lavender cream. A year brings 30 batches, and finding the raw materials and sales channels of one of them is hard.

Solution with Bimp

Batches by mask in assembly, supplier batches in the receipt of raw materials, batch attachment in sales and a batch number filter in the “Stock Movement” report.

Result in numbers

Answering the complaint with a batch number takes 15 minutes instead of 3 hours. A batch of 480 jars is distributed: 200 + 150 + 130 = 480. Distributors took 130 jars for €585.

How do you find a cream batch by the number in a complaint?

The customer named the batch number. The technologist opens the card “Hand cream, lavender, 50 ml”, the “Batches” tab, and finds the number. Then the technologist opens the assembly document of that batch and sees the production date and the materials with their supplier batches.

The fictional batch was made on 4 November and holds 480 jars of 50 ml. The net output needed is 24 kg of cream, which is 480 × 0.05 = 24 kg. Losses by the specification are 4%, so the total quantity of materials is 24 / (1 − 0.04) = 25 kg. The difference of 1 kg matches the losses that the specification builds in ahead of time.

Then the technologist opens the “Stock Movement” report with a filter on the number of this batch. It shows how many jars arrived, how many were sold and where a balance remains. For the fictional batch the split is as follows.

ChannelJars, pcs
Own web shop200
Marketplaces150
Distributor 180
Distributor 250
Total480

Check: 80 + 50 = 130 to distributors, 200 + 150 + 130 = 480. The wholesale price is €4.50 per jar, so distributor shipments came to 130 × 4.50 = €585. Distributors get a message asking them to check their jars, and the buyers of the own web shop are found in the sales documents of this batch.

To see whether the complaint stands alone, the technologist compares batches. The shea butter arrived in November in two deliveries. Opening the assembly of this batch, the technologist sees that the second delivery was used, while in the neighboring lavender batch from the same delivery there were no complaints. Then the cause is not necessarily the butter, and the cook is checked against the process card. Such an answer appears in 15 minutes, whereas without batches all the documents of November would have to be pulled up by hand.

What changes in the daily work of the shop?

After batch tracking starts, the changes show in three areas. In the raw material store an employee receives butter and oils by document and creates batches at once. This takes a few minutes per delivery, but half a year later nobody wonders which sack something was poured from.

In the shop the technologist performs the assembly right after the cook. If the actual use of butter differed from the norm, the technologist corrects the quantity in the document itself, and the system remembers the batch of raw material that was written off. For each of the 30 batches a year this is one assembly, so there are no extra documents.

In sales the manager chooses the batch of jars the same way as choosing a product, and the Fill by batches button selects batches automatically. At the end of the month the owner opens the “Stock Movement” report and sees balances by batch. A batch that has lain in the warehouse for months stands out at once, and a separate decision about a discount or a promotion can be made for it.

What does this give the company?

The owner answers a complaint with facts. The owner knows whether it is a single claim about one jar or whether the whole batch should be held back. The technologist sees which batch of raw material stood in that cream and compares it with other cooks that had no complaints. The sales head knows how many jars of this batch are already with distributors and whom to write to first.

After a few such reviews the company understands where the process depends most on discipline. If raw materials are received without a supplier batch, the link to the raw material breaks already at the entrance. Bimp is a Ukrainian cloud ERP for manufacturers, and the chain from the receipt of raw materials to the sale of a jar works in one system.

It is worth counting separately what order in batches gives to planning. Thirty batches a year of 480 jars of 50 ml make a notional 14,400 jars if all were that size: 30 × 480 = 14,400. When the owner sees how many of them each channel sold, the owner decides which channel gets the next lavender cook. The “Stock Movement” report gives the opening balance, receipts, sales and the closing balance for each batch, and no separate spreadsheet is needed for it.

Scenario limits

The scenario shows output by a specification in one assembly and a search by batch number. The “Stock Movement” report gives the quantity sold per batch, and which customers of the own web shop are affected is found in the sales documents. Jars sold through marketplaces are tracked only to the level of the channel shipment. The data is as accurate as the batches are entered carefully at receipt and shipment. Some of the help articles behind the steps carry a verification status, so check the button names and the mask settings against your version.

How to set up batch tracking on your products is described on the page Bimp for cosmetics manufacturers.

FAQ

Why does a cosmetics maker need batch tracking?

A customer complaint usually concerns one batch. The batch number lets you find the production date, the raw materials and the quantity sold without going through the records of the whole year.

Can Bimp set one batch number for the whole output?

Yes. The company accounting settings have the switch "Set the same batch number (Production)". It forms a single number for all series of one product in a document, and the look of the number is set by a mask.

Can the scents of a cream be kept as modifications of one card?

Modifications combine variants of a product with a separate balance and price. But a product with modifications cannot have specifications, so for a product assembled by a specification each scent is kept in its own card.

How do you see the movement of a certain batch across warehouses?

In the "Stock Movement" report you use the "Batch number" filter or the breakdown by batch numbers. The report shows the opening balance, receipts, sales, write-offs, transfers and the closing balance.

Check a batch on your own data

In a Bimp ERP demo a specialist shows how to find the raw materials, the production date and the sales of your product by its batch number.

Book a demo
DODmytro ObukhovCo-Founder & CEO