Stock Take By Csv File

Customer Support DEALPOS
[Updated]

You can use this function when you want to stock opname with import csv file.

Step 1. Go to 'Adjustment' menu, and click on 'Stock Take by CSV' tab menu

Screenshot_29.png

Step 2. Choose the outlet that the stock you want to update

mceclip0.png

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

Step 3. Open up the downloaded CSV and fill Counted column and Then save the CSV file when you're done

mceclip1.png

Name

Name of your product (variant).

Code

Code of your variant.

Expected

Stock in the DealPOS system.

Counted

Counted Stock /  Stock in Hand / Stock in your outlet

 Step 4. Back to the Stock Take by CSV page, now you can choose file for 'Counted Inventory' section. Then click on the 'Upload' button

Step 5. When the CSV file succcessfully uploaded, you will see the table of the data from CSV file you just uploaded. Then click on the 'Confirm Adjustment' button

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

Was this article helpful?
4 out of 5 found this helpful

Articles in this Section

Comments

0 comments