What is the Compare tool for item records?
The Compare function, also called Run Comparison, allows users to view and analyze item datasheet values from up to five suppliers at once. Comparisons are available for two types of datasheets:
Nutrition & Composition
Allergens & Sensitivities
This tool helps you understand differences in supplier data and make informed decisions during formulation.
Why compare item datasheets?
In Formula Management, combining ingredients and reviewing their interactions across iterations is crucial. The Items tab gives you a granular view of individual item data.
Comparing datasheet values across multiple suppliers ensures:
Better formulation decisions
Accurate nutritional and allergen reporting
Awareness of potential risks in ingredient sourcing
How to Compare Item Datasheets
Step 1: Navigate to the Items tab and locate the item with multiple suppliers to compare.
Step 2: Click the edit icon of the desired item to open the item’s TraceStation.
Step 3: Click Data Sheet from the left-side pane
Step 4: Click Compare/Import.
Step 5: Choose and select the type of comparison:
- Nutrition & Composition
- Allergens & Sensitivities
Step 6: Select one to five suppliers to compare against the current value.
Step 7: Click Run Values on the bottom of the page.
Reading the Comparison Results
Color Code
The key attached to the report indicates what each cell color represents. Make sure you scroll to view the entire report.
Nutrition & Composition: Min, Max, and Average
When reviewing nutritional values:
Beneficial nutrients: Use the lowest value (Min) to stay conservative.
Less desirable elements: Use the highest value (Max) for caution.
This aligns with nutrition labeling regulations, which guide rounding and reporting practices.
Allergens & Sensitivities: Worst Case Scenario
If a supplier reports allergens in the product, production line, or facility, these values are treated as present. This worst-case approach ensures that allergen reporting is cautious and accurate, helping you assess potential risks effectively.
Make Changes to the Item Record
You can update item records directly from the comparison results:
Select an entire column or individual cells that differ from the current value.
Click Apply Selected Values to update the item record.anges.