Download and open the Excel file you can find in the attachment of this article. This will look like this:
In this example file you will find three "bundles", gradually increasing in options. These "bundles" consist of a number of "products" that can have several options. These options are divided in an "Option Group". The red shaded fields in the sample file are not meant to be filled in, only the data in the remaining fields will be read on import. The hierarchy looks like this:
- OPTION GROUP
The excel file will be processed from top to bottom during import. When a line starts with the word "Bundle", we will create a new bundle.
Example 1 - Bundle
We will start with a simple bundle, consisting of two products.
The first line defines the "Bundle". In the column "Label" the name of the bundle will appear: "Basic Menu", and under "Price" the price "EUR9.95". The field in the column "CategoryPath" defines the folder or the sub folder where the bundle is stored. In the example it says "PIZZA"
You can create subfolders with the separating character \ for example:
The other fields do not have to be filled in, except last optional one with the SKU code. If desired, you can add a product code to your bundle which can be useful for your administration.
In Cubigo the bundle now looks like this:
Example 2 - Product
The next line in the Excel file describes the first product. In the column "Label" this is described as "Main Dish". It has no price, or folder, because that information is taken from the bundle this product belongs to.
In the column "Description" we will place the description: "Pizza Margeherita" and under "Ingredients" the ingredients, separated by commas: "Mozzarella Cheese, Tomato Sauce". We can add as many products as required to the bundle, each product will get its own page within this bundle. With the buttons "Next" and "Previous" the user can navigate between the different products within a bundle. It looks like this:
Example 3 - Options
Options are a part of a product, and are inherently plural. Therefore, after "PRODUCT" we will start a line with the term "OPTION GROUP" to indicate a number of options will follow. This line contains the name of the option, e.g. "Format" (of the product "Pizza").
In the column "IsSingleChoice" there should be a value "TRUE" or "FALSE".
- "IsSingleChoice"="TRUE" means you can only choose one option
- "IsSingleChoice"="FALSE" allows the selection of multiple options
For example under "Format" the value of "IsSingleChoice"="TRUE", because a Pizza is either big or small, but never both at the same time.
The value of "IsSingleChoice"="FALSE" is applied for additional ingredients: Extra Olives AND Achovis AND Bacon AND etc.
Finally: each option has a value "TRUE" or "FALSE" in the column "IsDefault". This is to indicate what the standard option is that is selected first. Look at the example above, where only for the option "Size" = "Medium" is the standard value.
Example 6 - definie Availability
In column "K" we define the "Availabilty" of a "Bundle":
The syntax is as follows:
The timestamp is optional. The term inf can be used to indicate an infinite timerange.
The beginning and end of a availability period is indicated by this sign:
Multiple availability ranges are separated by the following sign:
And example of a compound statement is as follows:
In the example file, "Custom menu" you can find a number of options that further illustrate how this works.
If the Excel file is ready, check here to see how it can be imported https://cubigo.zendesk.com/hc/nl/articles/206161599