This help article was translated using AI and may contain inaccuracies. If you are unsure about any information, please refer to the original version in French for accuracy.
Prerequisites:
To simplify the implementation of Yokitup as much as possible, we offer you to fill out an Excel file containing all the articles/products. This process can only be used for the creation of new products/articles.
You will find the file template to fill out here:
The reading of the file stops at the first empty line. Fields marked with an asterisk * are mandatory.
Here is the list of columns to fill out:
[*Supplier] name of the supplier, be careful to respect the case (lowercase/uppercase). New suppliers will be automatically associated with all your sites.
[*Product/Article Name] name of the product/article on Yokitup.
[Supplier's Article Name] name of the article on purchase orders and credits that will be sent to the supplier.
[Article Code] reference of the article at the supplier.
[*Price Excl. Tax] purchase price excluding tax of the article at the supplier. Should not contain the € symbol.
[*VAT Rate] VAT rate of the article at the supplier. Should not contain a percentage.
[*Billing Packaging Value]
[*Billing Packaging Reference]
[Billing Packaging Name]
[*Order Packaging Value]
[*Order Packaging Reference]
[Order Packaging Name]
[Round Quantities for Orders] Indicates that the quantities entered in the order must be whole numbers. To activate this option, put "yes" in the field.
[Round Quantities for Receptions] Indicates that the quantities entered at reception must be whole numbers. To activate this option, put "yes" in the field.
[Order Conversion Packaging Value]
[Order Conversion Packaging Reference]
[Order Conversion Packaging Name]
[*Main Packaging Value]
[*Main Packaging Reference]
[Main Packaging Name]
[Storage Conversion Packaging Value]
[Storage Conversion Packaging Reference]
[Storage Conversion Packaging Name]
For packaging, the "value" field corresponds to the number representing the quantity and the reference field corresponds to the packaging reference (unit, cL, L, g, kg, the complete list is available on this page).
The packaging name is not mandatory, it should provide additional information, for example "Pack of 24 x 33cl" is a good name because it is clearer than "7.92 L".
Unit packaging is to be avoided as much as possible and should only be used for items that have no weight or volume equivalent, for example: cutlery, packaging, equipment. If you use unit packaging, it will not be possible to use the item in any unit other than the piece, unless you define a conversion packaging.
Conversion packaging allows you to have two different units for the same product; the conversion packaging must be equivalent to the main packaging but in another unit. For example, your supplier sells a sauce in grams but in your recipes, you use it in milliliters.
To better understand the difference between billing, ordering, and main packaging, let's take the example of burger buns.
These burger buns are ordered/delivered by a bag of 7 buns, they are billed by a box containing 5 bags each (so a box contains 35 buns) and you do your inventory by counting the buns individually.
You will need to enter for the packaging:
- billing: "35 unit", for 35 pieces because a box contains 5 bags that contain 7 buns, so 5 x 7 = 35 buns
- ordering: "7 unit", a bag contains 7 buns.
- main: "1 unit", you do your inventory by counting the buns individually.