Export Stock Data from Retailer

Export Stock Data from Retailer

A CSV file of Stock can be extracted from Retailer using Stock Manager. This file can be used for updating Stock Items in Bulk or may be requested by External Stocktakers.
For updating stock items in bulk, we recommend performing the change in Stock Manager if possible. This removes the need for importing the data later.
  1. From the Main Screen of Retailer, click Stock Maintenance -> Stock Manager
  2. If the Stock Manager grid contains stock items, click on Remove  ->  Remove All
  3. Click on Search.
  4. In the Advanced Stock Search screen, enter your search criteria. See How to Use Advanced Stock Search
    Type an asterisk * in the Keywords box to list all stock items

  5. The Stock Manager grid will now display all stock items that match your search
  6. Click the Orange Asterisk * in the top left corner. Tick the columns you wish to show in the exported file.
  7. Click Send List To -> CSV File
  8. Navigate to a location to save the file in.
  9. Click Save.
Only selected Stock Items will be exported from Stock Manager. See Filtering in Stock Manager for more information on filtering data in Stock Manager
If you wish to import the file back into Retailer to update stock items, make sure the Barcode, Description, Sell and Supplier columns are selected

    • Related Articles

    • Export Customer List from Database (Retailer)

      You can export a list of customers to an Excel file (spreadsheet) through the export data utility. Click the Utilities menu from the top of the main screen of Retailer, then Import/Export Files and then Export Data. Options You can limit the ...
    • Creating a Stock Item

      Creating a Stock Item If the stock wizard does not appear when you click the Add button, click HERE. The stock wizard can be accessed through several areas such as: Click the Add button in the Stock Screen. Click the Add button in the Find Stock ...
    • Price Changes Report

      The Price Changes Report shows details of price changes to stock items within the selected criteria. Generating the Report On the top menu bar of Retailer, click on Reports -> Stock Reports -> Price Changes Report. In Report date range: Select the ...
    • Updating and converting from Retailer 2 to Retailer 3

      If you are using Retailer version 2, and updating to the new Retailer 3, you will need to update in stages. Retailer 3 has not been tested on Windows XP or Windows 7, and you should upgrade if you have them. You can check which version you have using ...
    • Viewing the Reserved Stock List for a Stock Item

      Reserving Stock in only available in Retailer versions 3.3 or later. View List of Reserved Stock You can view a list of reserved stock from the General Stock Listing or Supplier Stock Listing Reports. Open the stock listing report, by clicking on ...