Add Product | Single | Variable | Combo | Multiple Variations | Bardocde
1. Go to – Products > Add Products.
2. Provide and fillup Product Details as follow:
a. Product Name: XXXXXXXXXX
b. Product Brand: XXXXXXXXXX
c. Product Unit(s) & Sub-Unit(s): XXX XXX
d. Product Category and Sub-category: XXXXX XXXXX
h. Product Type: XXXXXXXXX
e. Product SKU Number: Add a unique SKU which will be used to identify the product & Print barcode in labels. Leave it empty to auto-generate it. You can also add a Prefix for auto-generated SKU.
f. Product Bar-Code Type: Select a barcode type, default/recommended is C128 option. We recommend changing if only if the product added already have an SKU number for it.
g. Product Alert Quantity:
h. Product NOT for Selling: If a product is marked not-for-selling then it will not be displayed in POS or sales screen. This can be useful when using manufacturing module to make the ingredients as product not-for-selling also if you want to temporary disable selling for some products.
i. Product Manage Stock Enable/Disable: Enable/Disable stock management at a product level. Product stock management is not required for services like Repairing, Hair Cutting, Web Development Printing. For items with Manage Stock Unchecked (disabled), you can sell them in unlimited quantities.
j. Product Business Location: Select the business location(s) where this product can be sold or purchased.
h. Product Adding TAX:
3. Save it.
Single Product
1. Applicable for products with no variation with them then select single
2. When selecting Single product – You will need to enter the Default product price including/excluding tax, Profit Margin % (you can set default profit margin from settings -> Business Settings; this will help to type % every time). Based on the profit margin it will auto calculate selling price excluding of Tax. You can also enter the selling price manually and it will auto adjust the profit margin for you.
Variable Product:
1. Applicable to a product having variations (like size or color or design or flavors etc) You can define variation templates from Products -> Variations. The advantage of creating variation is that it saves time to add same variations multiple time.
2. When selecting Variable product – It will display different fields to add all variations and its related Purchase price, Selling Price. You have to select the variations from the dropdown and it will auto-populate the variations for that template. You can change the variable name, Variation values.
3. To give same purchase price or selling price or profit for all variations of a product click on the double tick present in the first variation.
4. Variations can be added from Products -> Variations menu. These variations are used in variable products product. For example: a Jeans Pant can have multiple colors, so add variation called Colors and provide the value for it. As given in the image below.
Combo or Bundle Product:
1. Combo product are also called bundle products.
2. It is offering several products as one combined product.
For example a product “Computer Set” can have: 1 PC Monitor + 1 PC CPU + 1 Pc Keyboard + 1 PC mouse
So when someone buys Computer set she gets all the products in it.
3. Stock of bundled product depends on stock of individual products present in that bundle.
Example: if you have 5 PC Monitor, 4 PC CPU , 10 pc Keyboard, 50 PC mouse, the stock of Computer set will be 4 PC.
4. When the bundle product is sold, stock of all products inside them is automatically deducted.
5. Individual products present in bundle product can also be sold separately.
6. Bundle products cannot be purchased, only individual products present in it can be purchased.
7. Click on Save.
Note: You can edit a product. You can also Copy / Export to CSV, PDF or Excel file.
Adding Products with Multiple Variations
If you have products which involve multiple variations like for example a Shirt can have Color & Size variation, then we have multiple ways to work with it:
Solution 1, Create combined variation: Can a variation with a name “Color-Size” and add values like Red-Small, Red-Medium, Red-Large, etc, this can be used for while adding the Shirt.
Solution 2, Create multiple Products: Create multiple different products like Shirt-Red, Shirt-Green, Shirt-Blue with size as variations. When you create multiple products you will NOT have to enter the same details multiple times, first, add the Shirt-Red with all size variations of it and then use the Duplicate Product action to copy the data.
Apply Product Units | Sub Units | Multiple Units
Different Products have different units. Look POS allows you to add different units for products.
1. Go to Settings -> Units
2. Give the unit name, a short name, and choose if want unit to allow decimals.
Example:
Name: Meter
Shortname: Mtr.
Allow Decimal: Yes.
Allowing decimal allows you to purchase/Sell the product in decimal and vice-versa.
Adding Multiple Unit(s)
This can be useful if you purchase products in a different unit and sell it in a different unit.
For example: Purchase in dozens and sell in pieces.
Or purchase in boxes and sell in pieces.
Steps:
1. Add the lower unit from Add Unit Screen. For example pieces.
NOTE: You will not see the main Units (Dozen in this example) in the Add-Product Unit dropdown, select piece as the unit of product. All purchases/sales get saved in the lower unit (pieces in the above example). So after adding purchases/sales if you edit the conversion details, it will affect the purchases/sales quantity accordingly.
Selecting relevant Sub Units for a products
For some products not all sub-units will be required. Suppose for example you sell Oranges only in Dozens or only in pieces then it will be useful.
⬤ Enable it from Business settings ->Products -> Enable relevant sub-units
2. Check “Add as multiple of another unit”
3. Provide the conversion Details.
4. Use the unit in Add/Edit Product. While adding/editing purchase/ sale you can see the dropdown for units. Select the desired unit and it will change the unit purchase/sales price accordingly.
⬤
Now when adding products select the Unit for the products and it will give option to select multiple applicable sub-units. Selecting the sub-units will allow you to do purchases or sales on this selected sub-units.
Catagorize Products & Assign/Remove Product Location
Adding Category & Sub-Category
Categorizing products helps you to easily manage and filter them in reports.
1. Go to Product -> Categories -> Add
2. Add Category name, category code(HSN code)
3. If the category is sub-category select “Add as sub taxonomy” and select the parent category.
Assigning/Removal of Product Location
1. While adding your new product in the system, you can assign any of your business location for that product by selecting "Assign Location".
2. If you want to remove location of product, go to Edit Products and remove the given location as already mentioned.
Lot Number, BarCode, Print Labels & Duplicate Product
Lot Number
Enable Lot Numbering: To enable lot number go to, Settings -> Business Settings -> Purchases.
Click the Enable Lot number checkbox and save settings.
Add Lot Number: While adding purchased product, it will display the lot number field for entering the lot number. you can fillup it.
Add Lot While Adding Opening Stock: While adding product's opening stock, it will display the lot number field for entering the lot number. you can fillup it.
BarCodes
Question:
a. How can we use the product’s barcode instead of creating and printing new for every product?
b. How can we use the brand’s barcode of the product instead of creating and printing new for every product?
Answer:
While adding a product, in the form SKU field enter the barcode number of the product. This barcode will be used to identify the product in all screens like POS, Sales, purchases, reports, and others.
Print Labels
☍ Look POS comes with an inbuilt feature to print customised labels for products.
You can go to print label screen from multiple places:
1. From Products Sidebar menu Products -> Print Labels. 2. Go to Products -> View Products and click on Actions -> Labels. This will add the selected product to print label list. 3. Go to Purchases -> List Purchases and click on Actions -> Labels. This will add the products from the selected purchase to print label list.
Printing Steps:
1. Once you’re in print label screen, add the products for which you want to print labels by entering the name or barcode/sku id.
2. Adjust the quantity of each product’s label (No. of labels).
3. Select the information you want to display in labels by checking/unchecking the options under “Information to show in labels” heading.
4. Select the Barcode Setting according to your sticker. We have included some commonly used settings.
5. You can add new setting from Settings -> Barcode Settings menu.
6. Click on Preview to view the labels.
7. If everything looks good you can click on Print button to print it.
Note: You must set the Margins to ‘default’ in browser print window.
If some information is getting half displayed because of sticker size, then it is advised to hide them or better to use a 20 Labels Per sheet settings.
Error: Unsupported SKU id for the selected barcode type
This error means the SKU provided by you when creating the product doesn’t satisfy the encoding as per barcode type.
The solution can be edit the product and change the barcode type as “Code 128” save & try printing the label again.
Duplicate Product
Duplicate Products helps you to easily create a new product with the same data as another product, this helps you save repetitive entering of data and ultimately saves time by making the product entry process faster.
Product Cost & Price, Group Price, Location-Wise Price
Item Costing & Pricing
Any product business needs to setup new pricing by any fluctuation of raw material product prices,
taxes or expenses. Look POS provides you to change any new product pricing any time.
1- Whenever adding new purchases of product items there is option of costing it same time to setup the selling prices.
2- You can fill up item | Unit Cost | Taxes | Net Cost | Profit Margin to setup the selling price of this item.
3- Save it.
Items Group Pricing
⬤ Adding Selling Price Groups:
1. Go to products -> Selling Price Group
2. Click on “Add” button to add a new price group. For example: Retail price or WholeSale price or Bulk Purchase price or Location 1 price etc as per your wish.
3. You can view a list of selling prices in “Selling Price Group” screen.
⬤ Adding price for different groups:
1. In Add/Edit product screen in the bottom, you will find the button “Save & Add Selling-price-group price”. Click on that button. Note: this button will not be visible if there are no selling price groups.
2. In the next screen, you will see the list of the product name (if variable product then all variations), the default price & selling price groups price. Enter the prices for it.
3. Click on Save.
⬤ Exporting & Importing selling price group:
1. Go to Products -> Selling Price Group.
2. First download the excel file with the selling price group by clicking on “Export Selling Price Group Prices” button.
3. In the downloaded file change the price of products.
a. Only selling price group prices of the product will be updated, not the SKU or name.
b. Any blank price will be skiped.
⬤ Selling at a particular price group:
1. Go to POS.
2. In the top, you will see the list of selling price groups. Select the one as per your requirement.
Note: This will not be visible if there are no selling price groups or if a user is assigned only one particular price group only.
3. Select the prie group & the selling prices for the product will be as per the price group.
⬤ Assigning a user to a particular price group:
- Sometime you may want to assign a particular or few selected price group to a user. In that case, create a role with the desired permission & price group assigned.
- You must assign at least one price group for a role if that role has permission to sell.
⬤ Assigining a price group to a Business Location:
- Helps selling same product at a different price in different business location.
- Go to Add/Edit Business Location and select the Default Selling Price Group, if not selected then products default price will be used.
Product Delete | Edit (Single & Bulk) | Import (Single & Product List)
Product Deletion
Important: Deleting of a product will remove the products from the database.
NOTE: This delete will not work if the product have some transactions related to it. Transaction can be Opening Stock, Purchase, Sales or Stock transfer of the product. It will show some error like:
⬤ Product can’t be deleted because purchases related to this product exist
⬤ Some products couldn’t be deleted because it has transaction related to it.
Deleting individual product
Bulk Delete multiple products
Bulk edit helps you to edit multiple products at once and saves your time.
To edit multiple products follow the steps:
1. Go to Products -> List Products
2. Select the products you want to edit by clicking on the checkbox present in each product row.
3. Scroll down you will find the Bulk Edit option, click on it and you can edit the selected products.
4. Also, in the bulk edit screen you can add any other products to edit them.
Import Products
1. Go to Products -> Import Products
2. Download the template file.
3. Fill all the information as per the displayed columns name & instructions. Don’t remove the heading from template file.
4. Import the file
Error: UNIT not found
Solution: Make sure the unit you provided in excel file is already present in the system.
Go to Products -> Units, add the unit & import the file again.
Product Stock History, Expiry, Warranty, alert and Settings
Product Stock History
1. Go to Products > Product List
2. Click on Actions > Product stock history
Product expiry and related settings.
Enabling expiry for products
1.To enable expiry go to Settings -> Business Settings -> Product section. And check the “Enable Product Expiry” checkbox.
2. On enabling Product expiry, you can choose either “Add Item Expiry” or “Add manufacturing date & Expiry Period”
“Add Item expiry” => Choose this option if you want to directly add the expiry of the item to the purchase screen.
“Add manufacturing date & Expiry date” => Choose this option if you want to add the manufacturing date of the item and the expiry period. Based on the manufacturing date and expiry period it will auto-calculate the expiry date. And this expiry date can be edited. You will have to add expiry period for the product in the “Add or Edit Product” screen. And the manufacturing date in the “Add Purchase” screen.
3. “On Product Expiry” => With this option you can set what the system should do when a product expired.
“Keep Selling” => Choose this option if you want the application to keep selling the product even after expiry.
“Stop Selling n days before” => Choose this option to stop selling the item n days before the expiry. You will have to specify the value of n (which is the number of days before to stop selling)
4. “Stock Accounting Method” => This feature is used to set the way the product should be sold.
FIFO (First In First Out) => In this the old stock should be sold first.
LIFO (Last In First Out) => In this the most recent purchase stock should be sold.
For an Example:1. Purchase 20 pcs of product A on 20 March 2018. Expiry date 10 April 20182. Purchase 20 pcs of the same product A on 23 March 2018. Expiry date 8 April 20183. Today I sold 22 pcs.If the “Stock Accounting Method” is FIFO => Then the Product purchased on 20 March 2018 will be deduced with 20 pcs and after that product purchase on 23 March 2018 will be deduced with 2 pcs.So in stock, we will have products from 23 March 2018 with 18 pcs.If the “Stock Accounting Method” is LIFO => The opposite of the above will happen.NOTE: You must set the required accounting method before selling the item for that accounting method to be used.
Stock Expiry Report
1. Go to Reports => Stock Expiry Reports.
2. Here you can filter stock “Category”, Brands, “Stock expiry date”
3. Click on “Edit” to modify the stock left and expiry period.4. If stock left is decreased the unit purchase price is adjusted accordingly.
Stock Expiry Alert
– You can view stock expiry alert in Homepage bottom section. Here it shows a list of products expiring soon.
– You can set the number of days before which the expiry alter should be shown in the Homepage from “Settings -> Business Settings -> Dashboard Section” View Stock Expiry Alert For input field.
.