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
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
- Two levels
- Three levels
Single level — 1 box = 10 kg:
Conversion factor
The factor defines how much ingredient stock one received product unit creates. received quantity × factor = ingredient quantity addedAI 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
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
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
Wrong factor
Wrong factor
Wrong ingredient
Wrong ingredient
Wrong unit
Wrong unit
The ingredient unit should match how the ingredient is tracked.
Missing or wrong packaging level unit
Missing or wrong packaging level unit
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
- Open an order and find an unmapped item
- Click Map product
- Select the ingredient or create one inline
- Add packaging levels
- Set the factor or use Get AI factor
- Save the mapping
Receive an order into inventory
- Open the order
- Check which items are mapped
- Add missing mappings directly from the order if needed
- Select the storage unit
- Confirm received quantities
- Post the receipt to inventory
Fix a wrong mapping
- Open the mapped product from the order or the ingredient detail page
- Correct the ingredient, packaging levels, or factor
- Click Update mapping
- Review the next receipt carefully to confirm the fix
Review unmapped products
- Open the receiving flow for the order
- Items marked as unmapped cannot be transferred to inventory
- Click Map product on each unmapped item
- Create the mapping and return to the order
- Continue receiving
Common problems
Product does not increase stock
Product does not increase stock
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
Stock quantity is wrong after receiving
Stock quantity is wrong after receiving
Check:
- The conversion factor
- The packaging levels and their quantities
- The received quantity
- Whether there are duplicate receipt entries
Cost looks wrong
Cost looks wrong
Check:
- The product price
- The conversion factor
- The unit cost calculation
- The ingredient base unit
- The previous weighted average cost history
Product appears as unmapped
Product appears as unmapped
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
Related pages
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.