Skip to main content

Product Mapping

Product mapping connects vendor products to your internal ingredients. This allows Mathership to convert ordered products into ingredient stock when orders are received.

Connect products to ingredients

Tell Mathership which ingredient should be updated when a vendor product is received.

Convert quantities

Define packaging levels and conversion factors so ordered products become ingredient stock.

Improve receiving and reports

Use mappings for inventory receipts, stock value, reports, and reorder suggestions.

What is product mapping?

A product mapping tells Mathership which ingredient should be updated when a vendor product is received, and how much stock one unit of the product creates.
Vendor productIngredientConversion
1 box tomatoesTomatoes10 kg
1 crate milkMilk12 L
1 bottle oilOlive oil1 L

Why product mapping is important

Product mappings are required for automatic inventory receipts. Without a mapping, Mathership cannot know which ingredient should be updated.
Order itemMapping exists?Inventory result
2 boxes tomatoesYesTomatoes +20 kg
5 packs flourNoNo ingredient stock movement

When to use product mapping

Use product mapping when you want to:
  • Receive vendor orders into inventory
  • Convert ordered products into ingredient stock
  • Track stock quantities correctly
  • Calculate inventory value
  • Support reorder suggestions
  • Improve inventory reports

How mapping works

A mapping connects one vendor product to one internal ingredient. It includes:
FieldMeaning
Vendor productThe product from the vendor catalog or order
IngredientThe internal ingredient that should be updated
Target unitThe ingredient’s base unit — auto-filled when you select an ingredient
Packaging levelsThe packaging structure defining how the product converts to the ingredient unit
FactorThe overall conversion factor from product quantity to ingredient quantity

Where to create mappings

Product mappings are created from two places:

From an order when receiving

When you open an order to transfer it into inventory, unmapped items are flagged. Click Map product on any unmapped item to open the mapping sheet.

From the ingredient detail page

The Mapped vendor products section on an ingredient detail page shows all existing mappings. Click any row to view or edit it.

The mapping sheet

Clicking Map product opens a side panel pre-filled with the vendor product details. The panel header shows the product name. A product card in the form displays the product image, if available, article number, product name, and packaging text from the vendor catalog.

Form fields

FieldRequiredDescription
IngredientYesThe internal ingredient to map to — search existing or create new inline
Target unitAuto-filledThe ingredient’s base unit — read-only, set automatically when you select an ingredient
Packaging levelsYesThe packaging structure of the product — at least one level required
FactorYesThe overall conversion factor from product quantity to ingredient quantity

Creating a new ingredient inline

If the ingredient does not exist yet, select + Add new ingredient from the ingredient picker. This opens an inline form with:
  • Name field
  • Base unit dropdown
The ingredient is created immediately and the mapping continues without leaving the sheet.

Packaging levels

Packaging levels define the structure of the vendor product and how it converts into the ingredient’s base unit. Every mapping requires at least one packaging level. Each level has:
FieldDescription
NameThe packaging name, such as Box, Crate, Pack, or Bottle
Qty per parentHow many of this level fit into the parent level
UnitThe unit for this level — required on the last level

Packaging examples

Single level — 1 box = 10 kg:
NameQty per parentUnit
Box10kg
Click Add level to add a row. Click the X button to remove a row. The last level must have a unit selected.

Conversion factor

The factor defines how much ingredient stock one received product unit creates. received quantity × factor = ingredient quantity added
Ordered quantityFactorIngredient stock added
1 box10 kg10 kg
2 boxes10 kg20 kg
5 packs1.5 kg7.5 kg

AI Factor

Click Get AI factor in the mapping sheet to let Mathership suggest the factor and packaging levels automatically. The AI reads the product details and the selected ingredient and returns:
  • A suggested conversion factor
  • Suggested packaging levels with names, quantities, and units
Review the AI suggestion before saving. Adjust any values that do not match the actual product packaging.

Creating a mapping

1

Open an unmapped product

Open an order in the receiving flow and find an unmapped item.
2

Click Map product

Open the mapping sheet for the vendor product.
3

Select or create the ingredient

Choose an existing ingredient or create a new ingredient inline.
4

Add packaging levels

Define how the vendor product is packaged.
5

Set the factor

Enter the conversion factor manually or use Get AI factor as a starting point.
6

Save the mapping

Save the mapping so future receipts can update inventory automatically.

Editing a mapping

Click an already-mapped product to open the mapping sheet pre-filled with the current values. Update any field and click Update mapping.

Deleting a mapping

Deleting a mapping stops future automatic inventory receipts for that product. Use this when:
  • The product is no longer used
  • The product was mapped incorrectly
  • The vendor product should not affect inventory
  • A cleaner mapping should replace it
Deleting a mapping does not reverse past inventory movements. Review previous ledger entries separately if historical stock needs correction.

Automatic factor calculation

Mathership may help calculate the conversion factor from packaging information. This can use:
  • Product packaging text
  • Packaging levels configured in the mapping
  • The selected ingredient
  • The ingredient base unit
  • Unit conversions

Receiving orders with mappings

When receiving an order, Mathership checks each order item. If a product is mapped, the system creates a receipt movement in the inventory ledger.
Ordered productQuantity receivedMappingLedger entry
Tomatoes box21 box = 10 kgRECEIPT +20 kg
Milk crate31 crate = 12 LRECEIPT +36 L
Unmapped items are flagged during the receiving flow. Click Map product on any unmapped item to create the mapping before posting.

Missing mappings

A missing mapping means Mathership cannot convert the product into ingredient stock. Common reasons:
  • The vendor product is new
  • The product was renamed
  • The ingredient does not exist yet
  • The conversion factor has not been set
  • The product should not affect inventory

Product mapping and inventory ledger

When a mapped product is received, Mathership creates an inventory ledger entry. The ledger entry includes:
FieldMeaning
IngredientThe ingredient affected
Storage unitWhere stock was added
Transaction typeRECEIPT
QuantityConverted ingredient quantity
Unit costCost per ingredient base unit
ValueQuantity multiplied by unit cost
SourceThe related order item
See Ledger for details.

Product mapping and costs

Product mappings also help calculate inventory value. When receiving an order, Mathership uses the product price and conversion factor to calculate a cost per ingredient unit.
Product priceFactorUnit cost
€20.00 per box10 kg€2.00/kg
€12.00 per crate12 L€1.00/L
€5.00 per pack0.25 kg€20.00/kg
This unit cost feeds into the ingredient’s weighted average cost.

Product mapping and reorder suggestions

If Mathership knows which vendor product belongs to which ingredient, it can suggest what to order when stock is low.
Low ingredientMapped vendor productSuggested order
TomatoesTomato box 10 kgOrder tomato boxes
MilkMilk crate 12 LOrder milk crates
ButterButter pack 250 gOrder butter packs
See Reorder Suggestions for details.

Product mapping and reports

Product mappings improve inventory reports because received orders can be connected to ingredients. This helps answer questions like:
  • Which products increased stock?
  • Which ingredients were received?
  • Which vendor products are not mapped yet?
  • Which products create inventory value?
  • Which ingredients need better mapping?

Good mapping examples

Vendor productIngredientGood factor
1 box tomatoes, 10 kgTomatoes10
1 bottle olive oil, 1 LOlive oil1
1 crate beer, 24 × 0.33 LBeer7.92
1 pack butter, 250 gButter0.25

Common mistakes

ProblemResult
1 box = 10 kg but factor is 1Stock is 10× too low
1 bottle = 1 L but factor is 12Stock is 12× too high
250 g entered as 250 when base unit is kgStock is 1000× too high
Vendor productWrong mappingCorrect mapping
Tomato boxTomato soupTomatoes
Cream cartonMilkCream
The ingredient unit should match how the ingredient is tracked.
IngredientRecommended base unit
Tomatoeskg
MilkL
Butterkg
Bottled drinksbottle, L, or piece depending on your workflow
The last packaging level must have a unit.If the unit is missing, the mapping will not save.

Best practices

Check the unit before saving

Confirm the product quantity, packaging structure, and ingredient base unit before saving.

Use AI as a starting point

Use Get AI factor, but always verify the suggestion against the real product packaging.

Review high-value products

Small factor mistakes create large stock value errors for meat, fish, wine, spirits, and expensive dry goods.

Keep mappings up to date

Update mappings when vendor packaging changes, product sizes change, or ingredient units change.

Use clear ingredient names

Consistent naming makes mappings easier to find and verify.

Check the next receipt

After fixing a mapping, review the next receipt carefully to confirm the change.

Common workflows

Map a vendor product to an ingredient

  1. Open an order and find an unmapped item
  2. Click Map product
  3. Select the ingredient or create one inline
  4. Add packaging levels
  5. Set the factor or use Get AI factor
  6. Save the mapping

Receive an order into inventory

  1. Open the order
  2. Check which items are mapped
  3. Add missing mappings directly from the order if needed
  4. Select the storage unit
  5. Confirm received quantities
  6. Post the receipt to inventory

Fix a wrong mapping

  1. Open the mapped product from the order or the ingredient detail page
  2. Correct the ingredient, packaging levels, or factor
  3. Click Update mapping
  4. Review the next receipt carefully to confirm the fix

Review unmapped products

  1. Open the receiving flow for the order
  2. Items marked as unmapped cannot be transferred to inventory
  3. Click Map product on each unmapped item
  4. Create the mapping and return to the order
  5. Continue receiving

Common problems

Check that:
  • The product is mapped
  • The ingredient exists
  • A storage unit was selected
  • The received quantity is greater than zero
  • The receipt was posted
Check:
  • The conversion factor
  • The packaging levels and their quantities
  • The received quantity
  • Whether there are duplicate receipt entries
Check:
  • The product price
  • The conversion factor
  • The unit cost calculation
  • The ingredient base unit
  • The previous weighted average cost history
Check that:
  • The mapping was saved
  • The product record was not deleted or replaced
  • The order item references the same product record as the mapping

Ingredients

Manage the ingredient master list used in product mappings.

Storage Units

Manage storage locations where received stock is stored.

Receiving Orders

Receive vendor orders and post mapped products into inventory.

Inventory Ledger

Review inventory movements created from receipts, usage, waste, transfers, and counts.

Inventory Reports

Analyze stock, movements, costs, and ingredient activity.

Reorder Suggestions

Use mappings and stock levels to suggest what should be ordered.
Last modified on June 7, 2026