How to upload product adjustment details in bulk?

To upload product adjustment details in bulk:

1. Login to MioSalon.

2. Go to Settings from the main menu.

3. Within  Settings, navigate to Module Settings and click on Product.

4. In Product Module, click the Import Product button.

5. Click the Download Template button and open the downloaded Excel Sheet.

6. Enter the following mandatory and other fields in the Excel sheet:

   1. Product Category - The name of the product category

   2. Product Name (Mandatory)  - The name of the product.

   3. Stock on Hand - Enter the stock quantity.

   4. Cost Price  - The price at which the product was purchased.

   5. Selling Price  - Enter the selling price of the product without any discounts, offers, or promotions.  The selling price must be greater than cost price.

   6. Special Price - Enter the discounted or promotional price for the product. For retail products, this will serve as the selling price.

   7. Adjustment Value - Enter the product quantity for adjustment.

   8. Adjustment Type - For adding products, use these adjustment types: New stock, Return, Transfer In, Adjustment, Other. For removing products, use: Internal Use, Damaged, Out of Date, Adjustment, Other.

   9. Reason - Reason for adjustment that could be transferred, 

   10. Product Used - Mention whether it’s used to internal product consumption or retail product.

   11. Save the filled-out Excel Sheet Template.

7. Now, in the MioSalon account, on the Product Module, click the Import Adjusted Product button and upload the Excel sheet.

8. Check the imported or uploaded product adjustment details in the Product Module.