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 ...

• Manual Stocktake List report

  The Manual Stocktake List report is a checklist of items printed off with tickboxes to help with manually counting stock. This report can be run to produce a full checklist of items in the store for stocktaking, or it can also be run only for items ...

• 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 ...