Products, Categories and Prices
- Introduction
- The Products Tab
- How Products Are Organised
- Adding a Product
- Item Types
- Categories and Sub-categories
- Units of Measure
- Changing Prices
- Importing Products from Excel
- Deleting a Product
- Raw Materials
Introduction
Everything you sell at the till is a product. This chapter explains how to add products, group them into categories, set prices and choose the right item type. Products belong to a department, so check the department in the top bar first. See Signing In and Finding Your Way.
The Products Tab
Open POS in the sidebar, then the Products tab. The tab needs the See the Products tab permission. It lists every item in the department you are working in.
- Category, Subcategory and Search (by name or size) narrow the list. Pick a category before the subcategory list fills.
- The columns are Name (product name and variant, for example "Soda 500ml"), Quantity (stock on hand), Price (selling price) and Unit. The list shows 10 at a time.
- Add Product and Import need Add products.
- Update Prices needs Edit products and import price sheets.
- ⋯ > Edit needs Edit products and import price sheets. ⋯ > Delete needs Delete products.
Raw materials are not listed here. They live under Suppliers > Raw Materials. See Raw Materials.
How Products Are Organised
- A category is a big group, for example Beer or Meals.
- A sub-category is a smaller group inside it, for example Bottled inside Beer. Every product needs both.
- A product is the thing you sell, for example Guinness.
- A variant is one size or packaging of the product, for example 500ml and 330ml. Price, stock and unit belong to the variant, not the product. A product has at least one variant.
Adding a Product
- Open POS > Products and press Add Product. (The page is titled Add New Products.)
- Fill in the product details and the first variant.
- Press Add Variant for each extra size.
- Press Add Product. You see "Product added successfully", and the form clears for the next product.
The Product Details
| Field | What to enter |
|---|---|
| Categories | Choose a category. The + button next to it adds a new one. |
| Subcategories | Choose a sub-category of that category. The + button adds a new one. |
| Vatable | Whether the item is vatable: Yes or No. |
| Product Name | The name. It must not be used by another product in the same department. |
The Variant Details
Each variant is a card ("Variant 1", "Variant 2"). A card that was added by mistake can be removed with the bin icon at its top, while it has no stock history.
| Field | What to enter |
|---|---|
| Variant Name | The size or pack, such as "500ml", "Plate" or "Tot". |
| Unit of measure | Pieces, Kgs, Cups and so on. The + button adds a new unit. |
| Product Type | See Item Types. |
| Order Level | The stock level at which you want to be warned. The item counts as Low Stock on the Dashboard when stock is at or below it. |
| Allow partial qty | Yes lets you sell it in decimals, for example by weight. |
| Quantity | The opening stock. |
| Buying price | What one unit costs you. Used for profit figures. |
| Selling Price | What the customer pays. It must be at least 1, except for combinations, which may be 0. |
| Secondary Price (Optional) | A second price used in the period set under Admin > Settings > Secondary Price Period. |
Every variant needs a Variant Name, Unit of measure, Quantity, Buying price and Selling Price. If one is missing, the screen shows what to fix next to the field.
Note
After stock has been received in batches, Quantity and Buying price on the edit page are greyed out. Change stock from the Stock tab instead. See Stock.
Item Types
Each variant has a Product Type. It tells Hotel360 how the item is stocked and sold.
| Type | Use it when | Example |
|---|---|---|
| Stock Item | You buy it ready to sell and keep stock of it. | A 500ml soda: you buy crates and sell bottles. |
| Produced Item | You make it yourself. Link it to a Recipe so ingredients are used up when you record production. Needs the Production module (Premium). | Bread baked in-house. |
| Combination of Items | A fixed bundle of items you already sell. Selling one reduces the stock of each part. | "Chicken & Chips" = 1 chicken portion + 1 chips + 1 soda. |
| Combination with Options | Like a combination, but the customer also picks one item from a list at the till. | "Lunch Special" = rice + the customer's choice of beef, chicken or fish stew. |
Raw Material is also an item type, but you do not pick it here. See Raw Materials.
When you choose Produced Item, a Recipe drop-down appears. Its first choice is No recipe (batch only). Recipes are made under Production. See Recipes and Recording Production.
On the Basic plan, Produced Item is not offered, and saving one is refused: "Produced Items need the Production module (Premium). Use a Stock Item or a Combination."
Building a Combination
- Set Product Type to Combination of Items. A + button ("Build the fixed items") appears next to it.
- Press it. The window Build Combination Item opens.
- Start typing in Component Name and pick an item. Type the Required Qty and press Add.
- Repeat for every part. Press the red x to remove a part.
- Press Save Combination to close. The card shows how many "fixed items" it has.
Only plain stock or produced items can be a part. A raw material or another combination cannot.
Combination with Options
- Set Product Type to Combination with Options. Build the fixed base with the + button as above.
- Press the list button ("Set customer options"). The window Customer Options opens: "Add the items to choose from. The customer picks one of these at the till."
- Pick an Item, a Qty and press Add. Do this for each choice. With no choices yet it says "No choices yet. Add the items the customer can pick from."
- Press Save Options to close the window. The card shows how many "choices" it has.
At the till the cashier must choose exactly one of the choices before the item goes on the bill.
Selling Tots from a Bottle
A tot is not stocked on its own. Keep one stock item per bottle and add the tot as another variant of the same brand:
- Add the tot variant (for example "RED TOT") as a Produced Item.
- Create a recipe under Production > Recipes with the bottle variant as the only ingredient. The quantity is the tot size divided by the bottle size: a 30 ml tot from a 750 ml bottle is 0.04, from a 1 litre bottle it is 0.03.
- Select that recipe on the tot variant. You do not need to record production.
Every tot sold then takes its fraction off the bottle straight away.
Categories and Sub-categories
Both are added from the Add Product page, so you never leave the product you are working on.
Add a category
- Press the + next to Categories. The window Add Categories opens.
- Type the Category Name and press Add Category. You see "Category added successfully".
The same window lists existing categories. Use ⋯ on a row to edit or delete.
Add a sub-category
- Press the + next to Subcategories. The window Add Subcategories opens.
- Choose the category it belongs to, and type the sub-category name.
- If your department has order stations, choose Print orders at (see below).
- Press Add Subcategory. You see "Subcategory added successfully".
Names must be unique inside their category and department.
Warning
Deleting a category warns "Deleting this category will delete all subcategory and products associated to it". Deleting a sub-category deletes all its products. The products, their variants and stock records are removed for good. Only delete a group you are sure you no longer need.
Print Orders At
When a department has an order printer with a station name (for example Counter), the Add Subcategories window shows a drop-down Print orders at. Choose Print orders at: Kitchen to keep the sub-category's items on the kitchen ticket, or choose a station to send the sub-category's items to that station's printer on their own ticket. Sub-categories that have a station show an amber badge with its name in the list.
Nothing about stations is set on categories or on products. It is set per sub-category. See Order Stations for how to create the station and what prints where.
Units of Measure
On the product page press the + next to Unit of measure. The Add Units window opens. Type a Unit Name (for example "Bottle") and a Unit Short Name (up to 10 characters) and press Add Unit. Existing units can be edited or deleted from the same window. Unit names must be different from each other.
Changing Prices
A new price applies to bills from then on. Bills already raised keep the price they were raised at.
One Item
- Open POS > Products, find the item and press ⋯ > Edit.
- Change Selling Price on the variant.
- Press Update Product. You see "Product updated successfully" and return to the page you came from.
Many Items from Excel
Use this when a supplier or the owner sends a new price list. It needs Edit products and import price sheets.
- On the Products tab press Update Prices. The window Update selling prices from Excel opens.
- Choose your Excel file (.xlsx or .xls). It should have columns for the item name, BP (buying price) and SP (selling price). Only SP is used.
- Hotel360 matches each row to a product by name and shows a preview. A badge above the list counts rows by result:
- price changes: matched, and the price is different.
- unchanged: matched, same price.
- to review: not sure about the match. Pick the right product from the list on that row.
- no match: not found. These are left alone.
- Tick the rows to apply. Rows marked change are ticked for you. The count shows "N selected".
- Press Apply N change(s) and confirm "Apply N price change(s)?". You see "Updated N selling price(s)." Press Start over to begin again.
Note
Nothing changes until you press apply. Only ticked rows are written, and buying prices are never touched. If the sheet has no priced rows you see "No priced rows found in that sheet."
Secondary Price
Type a Secondary Price (Optional) on the variants that should use it, then switch the period on in Admin > Settings > Secondary Price Period. Between the start and end date and time, those variants sell at the secondary price. Other variants keep their normal price. See Users, Roles and Settings.
Importing Products from Excel
To add many products at once, press Import on the Products tab. The window Import From Excel has a Download Sample file link. Use its columns: Name, Size, Unit, Order_level, Category, Subcategory, Vatable, Type, Price, Quantity and Buying_price.
- Products are added to the department you are working in. Categories, sub-categories and units that do not exist yet are created.
- Vatable is yes, 1 or true for vatable items. Anything else means not vatable.
- Type is STOCKITEM, PRODUCEDITEM, COMBINATION or RAWMATERIAL. Anything else becomes a stock item.
- An existing product with the same name in the department is updated, not duplicated.
You see "Products imported successfully", or the rows that failed.
Deleting a Product
Press ⋯ > Delete on the product's row and confirm "Delete product?". Hotel360 does one of two things:
- If the product was never used anywhere, it is removed for good: "Product permanently deleted."
- If it has been sold, stocked, used in a recipe or a combination, or appears in a purchase, it is kept in the records but removed from your lists: "Product deleted successfully."
Raw Materials
A raw material is an ingredient or supply that is used up or issued, but never sold at the till. Flour, cooking oil and detergent are raw materials. They are not created on the product page. Add them under Suppliers > Raw Materials (Premium). The form has Name, Unit, Reorder level (optional), Opening quantity (optional) and Buying cost (optional), and a Consumable supply switch. Switch it on for items issued to a point of use, such as bed sheets, sauces and detergents, rather than used in production. A consumable supply is kept out of recipe ingredients. See Inventory and Raw Materials.