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

    • Supplier Stock Listing

      The Supplier Stock Listing Report lists selected stock items by department, category and supplier as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing ...

    • General Stock Listing

      The General Stock Listing Report lists selected stock items by department/category as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing stock with a ...

    • Export Customer List from Database (Retailer)

      You can export a list of customers to an Excel file (spreadsheet) through the export data utility. This information can include the names, addresses, phone numbers and emails of customers. Click the Utilities menu from the top of the main screen of ...

    • Stock Screen - Changing Details on Stock Items

      All aspects of a stock item - its name, prices, barcode, quantity on hand, stock code etc. - can be changed at any time. This is done through the Stock Screen, which is one of the most important screens in Retailer and one you will see a lot. The ...

    • Creating a Stock Item

      We have a video guide on adding a stock item into Retailer - ? Adding Stock items Creating a Stock Item If the stock wizard does not appear when you click the Add button, click HERE to enable it. The stock wizard can be accessed through several ...