Project

General

Profile

Product Variant Mapping

The following flowchart illustrates the process of creating and managing Item Variants

follow the steps below to create an Product Variant Mapping and use in transactions:

1. Click on Product Variant Mapping from the Item Variant Info.

2. Click on Add Product Variant button

3. In the Product Name field, enter and select the product from the popup product list, for example: SWEATSHIRT.

4. From the Product Variant section, click on Size, press Enter, and choose or tick the variant. You can also select All to map all variants for that product.

5. Click on the Color field and tick or select the required variant color. You can also choose Select All to apply all colors to that product.

6. Click on the Save button to save the variant for that product.

7. A Saved Successfully message will be displayed on your screen. Click OK to continue.

8. Click on the Edit button to edit the product variant details.

9. You can edit the product name and variant selection (Size, Color) as per your requirement, then click on the Save button to update the changes.

10. Click on the Delete button to remove the product variant. A popup will appear asking, ‘Are you sure you want to delete this variant?’ Click OK to confirm or Cancel to abort the deletion.

11. Click on the Back button to return to the main dashboard.

12. Click on the Transactions menu to enter variant-wise transactions.

13. Click on Purchase Invoice in the Transactions menu

14. Enter the Purchase Invoice Number for example "PI-998"

15. Select Payment Terms For Example Cash

16. In the Supplier Selection field, press Enter and select the supplier from the popup list, for example: ABC SUPPLIERS PVT. LTD.

17. In the Particular field, press Enter.

18. In the popup, uncheck Supplier Wise Items if it is selected. Then, select the product you want to purchase from the popup list, for example: SWEATSHIRTS

v19. When you select the product, a variant selection popup will appear on the screen showing the products attributes. Choose purchased size and color as previously generated in the Variant Master—for example, Size: LARGE and Color: White.

20. Enter the quantity for that variant product. For example "11"

21. You can load the old Purchase rate by ticking the “Load Old Rate” option. You can also set a new Purchase Rate (PRATE) and Sales Rate, including SRATE (W/V) with VAT and SRATE (Without VAT). Additionally, you can enter the product variant barcode manually in this section. After entering the required details, click the “Apply” button to add the price and quantity for the item.

22. Click on the Discount field to give a discount for that item.”

23. You can add multiple products using the same process. Click on the Save button to save items with the applied variant.

24. From the Sales Transactions menu, select Sales Tax Invoice to make a sales transaction using item variants.

25. Enter the sales invoice number, for example: SI-8754.

26. In the Customer field, press Enter and select the customer you want to sell to from the customer popup. for example: SURYA RAJ GHIMIRE

27. In the Particular field, press Enter and select the item from the popup product list. For example SWEATSHIRTS

28. The Sales item variant selection popup will appear on the screen. Select the required variant, then press Enter to continue.

29. Enter the sales quantity for the product, for example: 2

30. You can enter the sales price and apply a discount as required. Press the Enter key or click the + icon to add another item and Repeat the same process, then click the Save button to save the sales transaction

31. From the Inventory Movement menu, select Opening Stock.from the dropdown menu option

32. In the Particular field, press Enter. From the product popup list, select the desired product. For Example: SWEATSHIRTS

33. When you select the product, a popup will appear on the screen showing the variants. Choose the size and color as previously defined in the Variant Master—for example, Size: small and Color: White. Then, enter the quantity as per your need. For example 20

34. You can load the previous product rate by ticking the ‘Load Old Rate’ option. You can also enter a new Purchase Rate (PRATE), Sales Rate without VAT (SRATE W/V), and Sales Rate with VAT (SRATE). Additionally, you can manually enter the product variant barcode. click the Apply button to add the price for the item.

35. You can add multiple items by pressing the + icon or the Enter key and repeating the process for each item. Then, click the Save button to save the opening stock entry

36. A Successfully Saved message will appear on your screen.

37. To upload the product variant via Excel, first go to the Utilities → Migration Module and choose Product Variant. Download the sample file, fill in the required data in Excel, and save the file. Then upload the completed file.
If any error occurs, check the Upload Status, correct the errors in the Excel file, and upload it again. Repeat the process until the Successful message appears.

38. To load the variant-wise report in the Purchase, Sales, and Inventory report module, tick the “Load Variant Wise Report” option or choose the variant category options as per your requirement.