In DealPOS, you can use the Adjustment menu to do the Stocktaking activity in your store. In the Adjustment menu, there are three adjustment methods that can be used to create a product's stock take. One of the most used adjustment methods is Stock take by CSV. With the Stock take by CSV, you can create a product's stock take using CSV or Excel file. You can follow the steps below to use the Stock Take by CSV method:

Notes:

When using the Stock take by CSV, make sure the product has a variant code/SKU.

You can choose the format that you want to use for importing the stock take (By CSV or by XLSX file)

Notes :

If you want to include the products without inventory (stock quantity at 0), you can click the 'More Options' button, and choose Yes for 'Product Without Inventory'. Then click on the 'Download CSV' button in the upper right corner.

Open the downloaded CSV File and edit the data, fill the counted column with the counted physical stocks in your

Go back to the Stock Take by CSV page and choose the file in the 'Counted Inventory' section. Then click the 'Upload' button.

When the CSV file has been successfully uploaded, you can see the data table of the CSV that you will upload. Click on the 'Confirm Adjustment button if the data is correct.

The 'Differences' column is the quantity of the adjustment that we will create. The Qty is taken from the Differences column from earlier. Note that the products with 0 difference (Expected = Counted) are excluded from the Adjustment Form.