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 results

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