Table of Contents
Key Benefits
Merchants can now easily update all their stock in QashierPOS via QashierHQ using a simple Excel file provided by Qashier.
Assist merchants in saving time by utilising the batch update function instead of manually update individual stock count.
How to Bulk update Stock Count
Note: This function allows you to add or reduce stock quantities
Step 1: To begin, log in to QashierHQ. Then, navigate to the left side menu and choose "Inventory Management" from the "Product Management" dropdown.
Step 2: Choose the appropriate store and then, on the right side under "Bulk Update", click on the option to "Update Stock Change with Excel".
Step 3: Click on "download" from the pop-up to access the stock update template. The update template will be automatically downloaded to the designated download folder.
Note: It is advisable for merchant to checked "Export Existing SKU" before downloading the update template. The import template will be provided in CSV format. Users are advised to always download the template from the system to ensure that they have the latest version.
Step 4: Once users have completed filling in the update template according to the provided instructions, they should proceed to step 2 to initiate the pop-up. In the pop-up, they can select the "+" button to attach the import template. Lastly, they can click on "Update" to begin the import process.
Completing the update template
Note:
If the user has a chain store, the downloaded update template will include all the stock from all stores under the user.
If there is a change in the price, the user should simply update it accordingly in the cost price column.
If there is any need to make changes to the individual product SKU, it is important to note that it can only be done manually via QashierHQ.
If there is a decimal in the “Stock in Quantity” and "Stock out Quantity" the User needs to key in the correct decimal point.
Step 1: Please enter the total quantity of incoming stock in the 'Stock In Quantity' field, and the quantity to be reduced in the 'Stock Out Quantity' field.
Step 2: Users are to input all relevant fields properly, once completed, save the document, and upload.
Upon completion of the stock update, the system will display the total number of rows that have been successfully updated. For instance, it will showcase 6 out of 10 product IDs updated, where 6 represents the number of products that have been successfully updated, while 10 signifies the total number of rows processed.
Common Errors
Error Message | Issues |
No file selected | No file is added |
Invalid file format. Please upload a file in either .csv or .xlsx only | File added is not csv or xlsx |
Invalid file format. Please download the template above before uploading your new products | File added does not have the correct column headers |
Unknown product SKU found on row X, where X is the row number | Does not match any Product SKU |
Invalid stock in quantity found on row X, where X is the row number | Does not fit stock in requirement |
Invalid cost found on row X, where X is the row number | Does not fit cost requirements |
X rows with empty or 0 stock in quantity found, where X is the number of rows | There are products with 0 or empty stock in quantity show |