Retailer Utilities

Retailer Utilities

Below is a list of Retailer Utilities and a brief explanation of their function. Many should only be run under the advice of Tower Support.
If you are unsure, contactTower Support before clicking a Utility


Import / Export Files
  1. Import Supplier Stock File
  2. Import PDE File
  3. Import Catalogue Files
  4. Import Customer File
  5. Import Customer Orders (Newsagency Only)
  6. Export OfficeSmart Stock (Newsagency Only)
  7. Export Data
  8. Import Shopify Tags File
  9. Import Shopify Weights File

Supplier Communication (Newsagency Only)
  1. Generate Stops / Starts File
  2. Import Stops/Starts/Subscriptions
  3. Import Publisher Customer Codes
  4. Import Subagent Orders
  5. Export Subagent Orders
  6. Import Route Delivery List







Department Utilities
  1. Find Stock with No Department
  2. Group Department Change
  3. Change A Stock Item's Department or Category

Stock Reorder Utility
  1. Used to Setup Reorder Method and Desired Levels for Stock By Department and/or Supplier. Can also use Stock Manager for this

Update Stock File with The Preferred Supplier
  1. Checks Supplier and Supplier Stock Code (SSC) match the Preferred Supplier set per stock item

Update Prices per Department

Update Sales File with Cost Prices

Update Stock File with Last Arrived Date
  1. Updates Last Arrived Date per stock item. Date can be seen in Find Stock Screen or Stock Manager

Check Parent Stock Items
  1. Finds Stock Items that are setup as Child Items where the Supplier is not ticked to track stock items by issue



Data Checking Utilities


Import Department Categories



Check Multi-Store Files (Multi-Store Only)

  1. Change Tax Rate for stock items by Tax Group

Check Subagent Standing Orders (Newsagency Only)


News Corp Subscription Pay Code Update (Newsagency Only)

  1. Change default Stock Description prefix for Pack items. Default is "Pack of..."

Multi-Buy Customers
  1. Adjust Multi Buy Accruals for Customers

Check Email Addresses
  1. Checks Customer and Supplier Email Addresses are valid. Need to Print or PDF report to view

Sale Balance Credit Fix
  1. Updates Customer Accounts Balances for Invoice Credits for Retailer V2 to V3 conversion

Add Custom Web Site
  1. Add Website URLs that can be added as shortcut buttons on Retailer Main or POS Screen

Disable Customer Email/SMS Receipts
  1. Ticks Disable Receipt Emailing and Disable Receipt SMS Sending in Customer Screen for all customers

Reset Retailer Screens
  1. Resets Previous Sale and Find screens in Retailer to default size and alignment


    • Related Articles

    • Update Prices using Markup rules

      Setup Stock Markup A markup percentage can be defined at a Department and/or Category level for Retail/Sell, Web and Trade Prices. See Adding / Editing Departments or Adding / Editing Categories See Differences Between Markup and Margin When is ...
    • Tax Update Utility

      Warning: Using this utility will affect pricing of every item in the selection you make. Please be sure you want to do this before clicking anything other than the close button. This utility is used to update the tax rates on the different tax groups ...
    • Importing a Customer File

      The Import Customer File utility can be used to import new customers. Existing Customers cannot be updated by this utility From the Main Screen of Retailer, click Utilities -> Import / Export Files -> Import Customer File In Customer File Type, enter ...
    • 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 ...
    • Opening and Close Shifts in Retailer Roam

      Opening a Shift In Retailer Roam To open a new shift in Retailer Roam: Open the Point of Sale screen. (Tap the menu icon, then Point of Sale) Tap Open Terminal on the right hand side. Enter your cash float amount and press Set Opening Float. If you ...