This article explain how to fill in the fields relating to pricing and packaging in the ingredient import Excel file. These fields follow the "General Information" and are shown in green.
If you are looking for information about how to get started with importing ingredients make sure to look here. More information about filling out Pricing and Package on apicbase.com is can be found in this article.
The Excel file contains an Information Sheet (sheets can be found at the bottom of the document) which contains some examples and also provides some short explanation about each field. This article expands a bit more on some of the more complex fields.
In the following each field is first explained and then some examples are given.
- cost: A number denoting the purchase price of the ingredient/article. This should be the number as you find it on your invoice.
- weight/volume is per piece: Can be either empty, 0 or 1 (empty=0). This field actually modifies how the weight and volume fields that follow are interpreted by the software. If the value is 0 then it means that weight and/or volume are given for the package as a whole. If the value is 1 then weight and/or volume is interpreted as per piece. It follows that only when this package contains multiple pieces (see next field) it makes sense to potentially fill out value 1 here.
- # pieces per package: If the package contains multiple pieces you can specify how many here. If it contains no pieces you can leave this empty.
- weight and weight unit: The weight of either a single piece or the package (see field "weight/volume is per piece" to disambiguate this).
- volume and volume unit: The volume of either a single piece or the pacakge (see field "weight/volume is per piece" to disambiguate this). In case you fill out both weight and volume you are telling the software how to convert this article from weight to volume (and vice versa). In case only one is filled out the software will assume 1kg=1l if a conversion would be needed.
- package type: an optional text field that can be used to clarify the type of packaging (canned, carton, ...)
- package description: An optional longer text field in which you can describe the article in more detail.
In the following we explain in more detail the examples found the "Information Sheet" of the Ingredient import Excel.
- Tomatoes, Peeled: This article costs 2,7 EUR for a package containing 3 pieces (cans) each weighing 400 grams. apicbase interprets the 400 grams as refering to 1 piece because the field "weight/volume is per piece" is set to 1. In a recipe you can now refer to this ingredient per piece or in weight. For example 100 grams Peeled Tomatoes would cost 22,5 cent.
- Irish Beef Steak: This article costs 39,78 EUR for 1 kg. Since this article does not contain any pieces we leave the fields "weight/volume is per piece" and "# pieces per package" empty.
- Mini apples, Jonagold: This article costs 1,99 EUR containing 8 apples, in total weighing 1,2 kg. The software now also knows that 1 apple weighs on average 150 grams. You can now use this article in a recipe using pieces or any weight unit.