Units of measurement for Import Price Data
Import Price Data is a tool that helps you to import large amounts of price data quickly.
It uses a fixed list of standard units during the import process. These are the same standard units as in the Fillet apps.
This article consists of the following sections:
- Standard units in Fillet
- Prices and units of measurement
- Importing prices
Standard units in Fillet
All Fillet apps use the same standard units of measurement.
There are two categories of standard units: mass units and volume units. Fillet apps only use metric and US customary units for mass and volume.
Since these are all standard units, the measurement values never change.
| Mass unit | Full name | Value |
|---|---|---|
| kg | Kilogram | 1 000,00 g |
| lb | Pound (US) | 453,592 g |
| oz | Ounce (US) | 28,3495 g |
| g | Gram | 1,00 g |
| mg | Milligram | 0,001 g |
| mcg | Microgram | 0,000001 g |
| Volume unit | Full name | Value |
|---|---|---|
| gal | Gallon (US) | 3 785,4117 mL |
| L | Liter | 1 000,00 mL |
| qt | Quart (US) | 946,352946 mL |
| pt | Pint (US) | 473,176473 mL |
| cup | Cup (US) | 240,00 mL |
| dL | Decaliter | 100,00 mL |
| fl oz | Fluid Ounce (US) | 29,57353 mL |
| tbsp | Tablespoon (US) | 14,786765 mL |
| tsp | Teaspoon (US) | 4,928922 mL |
| mL | Milliliter | 1,00 mL |
Prices and units
Each price must have a unit of measurement, which can be a standard unit or an abstract unit.
Each ingredient in your Fillet data has a unique list of abstract units. These abstract units apply to that ingredient only and cannot be used by other ingredients. This is the opposite of standard units, which can be used by any ingredient, recipe or menu item.
Units when importing prices
The Import Price Data tool uses a fixed list of standard units, which are the same as in the Fillet apps.
Each price in your price data must have a unit of measurement, and you can use a standard unit or an abstract unit.
If you want to use a standard unit, use the unit ("kg") not the full name ("kilogram").
Examples and resultsRules for an exact match
A unit of measurement can be an “exact match” to:
- A standard unit, or
- One of that ingredient’s abstract units.
To be an exact match, the text and spelling must be the same.
Note:Spelling is not case-sensitive, so capitalization (uppercase or lowercase) is ignored.
No exact match to a standard unit
The file that you upload for import may contain a units of measure that is not an exact match to one of the standard units. Or it may not match any units in your Fillet data.
The Import Price Data tool will handle this situation differently depending on your existing Fillet data:
-
The unit of measure does not match any standard units. However it is an exact match to one of that ingredient’s abstract units. In this situation, Fillet will recognize the abstract unit and update the Amount and Price.
-
The unit of measure does not match any standard units.Also, it does not match any of that ingredient’s abstract units. In this situation, Fillet will automatically create a new abstract unit for that ingredient, and insert the Amount and Price.
Examples and results
In this example, the ingredient to be imported is "Apples", and it only has one abstract unit, "box".
| Data | Result | More information |
|---|---|---|
| Apples,"1,00",box,"10,00" | Import used the existing abstract unit: box | There was an exact match for the unit used and an existing abstract unit for that ingredient: box |
| Apples,"1,00",kg,"5,00" | Import used the standard unit: kg | There was an exact match for the unit used and the standard unit: kg |
| Apples,"1,00",kilogram,"5,00" | Data import created a new abstract unit: kilogram |
A new abstract unit was created because there was no match to a standard unit or an existing abstract unit. To use the standard unit for kilogram, the unit should have been spelled exactly as "kg". |
| Apples,"1,00",kilograms,"5,00" | Data import created a new abstract unit: kilograms |
A new abstract unit was created because there was no match to a standard unit or an existing abstract unit. To use the standard unit for kilogram, the unit should have been spelled exactly as "kg". |
| Apples,"1,00",bag,"7,00" | Data import created a new abstract unit: bag, | A new abstract unit was created because there was no match to a standard unit or an existing abstract unit. |
