A case is treated as one unit
An order for one case arrives in the next system as one unit, because both systems accept the same number. The order looks fine on screen, but it does not match what your warehouse staff actually handle.
Data transformation & PIM
Make pack sizes and units mean the same thing in every system
One system means a case, another means a single unit, and the same number throws off stock or price. Staff patch counts with no clear rule. We define the units and match supported conversions to the goods your team handles.
Discuss this problemHow We Help
We review the units you buy, sell and stock for a sample of products. Pack sizes may differ from one product to the next, so we need evidence before using one multiplier for everything. We then follow each conversion through the connections between your systems, looking for steps that are missing or repeated. Prices get checked on the same unit basis as quantities. Your stock and finance owners approve the rules, and we test them with sample sales and receipts. Fixing past stock errors needs its own evidence of each movement, plus a physical review.
Signs This Is the Problem
Prices compare on different bases
One system reads a case price as a unit price. Your buying and margin comparisons then mislead you, because the price and the quantity no longer describe the same thing.
Stock moves by the wrong quantity
Receiving or selling a pack changes your stock by the wrong count. Staff correct the balance by hand, but no one finds where the conversion was skipped or applied more than once.
What We Investigate
Work out what each quantity means
We establish what each quantity means in your purchase, sales and stock records. A sample of products, including unusual packs, shows where one general unit label hides different physical amounts.
Find where each conversion happens
We follow each conversion through the connected systems to see where it takes place. Two connections can apply the same multiplication, while another path may pass the original count along unchanged.
Compare prices with quantities
Next we compare the unit behind each price with the matching quantity. This shows whether a corrected stock conversion would still leave buying or selling prices based on a different measure.
What We Repair
Set conversions product by product
We set up the unit rules you approve for each product, with any exceptions spelled out. Pack contents and variable measures stay where they belong, not hidden inside one unexplained multiplier for the whole catalog.
Convert at one agreed point
Each conversion moves to one agreed point in the flow, and we correct any mappings that compete with it. The new path keeps the original meaning. It does not skip the conversion or repeat it in a later system.
Make the unit easy to see
We make the unit and quantity basis clear in the fields or reports you review. Your staff can read a transaction before approving it. Changes to past stock still depend on stock evidence and your owners' decisions.
How We Verify the Fix
- A purchase of one sample case produces the agreed number of stock units.
- A sale in the approved selling unit reduces stock by the correct converted quantity.
- The converted price matches the approved unit basis for the same sample product.
- A product with an unusual pack definition follows the conversion rule we reviewed for it.
Questions About This Work
Can one conversion cover the entire catalog?
Only where the products share the same physical relationship. Pack contents and variable measures can differ from product to product. We test sample exceptions and keep the rules at the product level you need, so those differences stay easy to explain.
Is this also a pricing issue?
It can be, because this problem can affect prices as well as stock. We establish whether each amount describes a single unit, a case or some other measure, then compare it with the quantity conversion. Fixing stock alone should not leave staff buying or selling from a conflicting price basis.
Can historical stock be repaired?
Only with transaction evidence and a physical stock review. We find the affected movements and the conversion error, then your stock owner approves any adjustments. Balances may include unrelated manual corrections, so today's difference is not automatically the quantity to put back.
Tell Us What Is Happening
Tell us which platforms you use for buying, selling and stock. Share one product example with private details removed, showing its pack contents, transaction quantity and the unexpected stock movement or price, so we can compare what the units mean.
Explore Product Information Management More problems in Data transformation & PIM
Ready to Get Started?
Tell us about your project and we'll get back to you within 24 hours.