Before performing a stocktake, click HERE for more information on the types of stocktakes that can be performed as well as the precautions that you need to take before undertaking one. 

Importing the Data File into Retailer

1. On the top menu bar of Retailer, click on Utilities → Import/Export Files → Import PDE File.
2. At the bottom of the screen, click Import CSV File.
   
3. Click on the yellow folder 📁button on the right and navigate to the stocktake file. 
   
4. Click Yes to confirm that that is the file you want to import.
   
5. Enter the settings for Barcode and Quantity, as required. Description is optional.
   NOTE: The settings below are only an example. Check the preview to make sure it is correct before proceeding.
   
   
   
6. Click Save and then click on the Import PDE button.
   
7. The Find Stock Screen may appear if an item's barcode cannot be found in the system. Try to locate the correct item or click Add to manually add the item in.
   NOTE: If your file does not contain a description, the description shown will not be relevant
8. Once the import process is complete, the Import PDE File screen will appear and show a list of imported items. You can click on the Modify or Delete buttons to modify or delete items respectively.
   
9. Click on Begin Processing.
   
10. Assuming you are at the beginning of a stocktake, click on New.
    If you already have an existing stocktake, click on Existing and select the particular stocktake for the items from the drop-down box.
11. The Overwrite Item Quantity screen may appear during the processing if the same barcode was entered multiple times on the same file. In most cases, select Add and click OK.
    
12. The figure in Counted Qty for the items on the list will be updated with those imported from the PDE.
    

If you are importing multiple times from the PDE, follow the steps above without creating a new stocktake.

After Importing the Data File

1. Once the file(s) have been imported, you can check the grid and the quantities.
   NOTE: The figures in Counted Qty can be changed, if required.
2. When you are ready to finalise the stocktake, click on Process.
   
3. Click Yes to the confirmation messages.
   

Stocktaking a large amount of stock items will create some backend-processing load. If you are stocktaking more than 1000 items at a time, please contact Tower Support during business hours after processing, to prevent Retailer from freezing up.

Reporting on the Stocktake

1. Click on the Report button in the bottom right hand corner.
   
2. This report will show you all items stocktaked and any discrepancies will show against each item.
   
3. Use this report to find items that were missed or miscounted during stocktake to reduce your discrepancy.
   
4. You can also go to Stock Maintenance → Stocktake → Stocktake Discrepancy and use the options to run the report only on items with a discrepancy.
   

1. On the top menu bar of Retailer, click on Reports → Stock Reports → Stock Listing Reports → General Stock Listing.
   
2. Select the options based on your needs.
   
3. Click Preview or Print.
   

Import PDE File is for entering counted quantities into a Stocktake. If a barcode in the file doesn't match an existing stock item, you'll be prompted item-by-item to add it as a new product. For bringing across a large number of items at once (e.g. a full department listing from another Retailer database), it's usually quicker to use Importing A Supplier Stock File (CSV) instead, which creates new items automatically without prompting for each one.