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.

Why product mapping is important

Product mappings are required for automatic inventory receipts. Without a mapping, Mathership cannot know which ingredient should be updated.

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:

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

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:

Packaging examples

Single level — 1 box = 10 kg:
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

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. 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: 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. 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. 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

Common mistakes

The ingredient unit should match how the ingredient is tracked.
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