• Requires setting up desired quantities for stock items but reduces a lot of guess-work when reordering.
  • Once set up, is very automated and requires little input from the user.
  • Can be run for specific suppliers and/or departments/categories.
  • Takes existing orders into consideration and can adjust quantities based on this.


Info
For a comparison between re-ordering methods, click HERE

Set Up Desired Quantities for Stock Items

For the purposes of re-ordering, Retailer uses the following options to determine quantities to order:

  • Desired Quantity - The maximum quantity at which stock should be on-hand when re-ordered.
  • Stock Reorder Quantity - The quantity at which stock will be taken into account and included to be re-ordered. 

For example:

Current Quantity-on-HandDesired QuantityStock Reorder QuantityOrder Created?Quantity Added to Order
5203No
(Because current QOH is higher than Stock Reorder Quantity)
N/A
2203Yes18
(Because current QOH is 2 and Desired Quantity is 20)

 

These Desired Quantity and Stock Reorder Quantity can be change in either the Stock Screen or the Stock Manager.

Through the Stock Screen (Individual Items)

  1. From the main screen of Retailer, click on Stock -> Stock Screen
  2. Click on the magnifying glass icon to access the Find Stock Screen. Search for a particular stock item and click OK.
  3. Click on the Reorder tab.
    • In Desired Quantity to Have on Hand, enter the desired quantity for the stock item.
    • In Reorder This Item When It's Stock Level Gets Down To, enter the quantity at which the stock item will be re-ordered.
    • (Optional) In Warn POS Users About This Item When The Stock Level Is, enter the quantity at which Retailer will display a warning in the POS screen when the item is scanned.
    • In Reorder Method to Use When Recalculating Order Quantity, leave this on Unit. However, if you want to order an item by it's pack, select Pack from the drop-down box.
      For more information about using packs in Retailer, click HERE.
  4. Click Save.
    Repeat for other stock items as required.

Through the Stock Manager (Multiple Items)

  1. On the top menu bar of Retailer, click on Stock Maintenance -> Stock Manager.
  2. Make sure the list is empty. To do so, click on Remove -> Remove All.
  3. Click on Search to access the Advanced Stock Search screen.
    • Enter the criteria of stock to change quantities for.
    • Click Search.
      For more information about using the Advanced Stock Search utility, click HERE.
  4. Click on Edit Selected.
  5. Change the quantities in Desired Qty and Stock Reorder Level, as required.
    The field will turn red to indicate that there is a change to be made.
  6. Click Save.
  7. Repeat steps 2-6 for other groups of items as required.

Import a Supplier Stock File

The Desired Qty and Stock Reorder Levels can be updated by Importing a Supplier Stock File
The Stock File needs Barcode, Description, Supplier, and a Price (Updating Existing Price is optional but the column is required)

Running the Reorder Report

Info
We have a video guide on how to use Maximum and Minimum Quantities to reorder stock in Retailer Stock Reordering - Ordering by Maximum and Minimum Quantities
  1. On the top menu bar of Retailer, click on Reports -> Stock Reports -> Stock Reorder Report.
  2. On the left hand side, you can choose which Supplier(s) to run the report for:
    1. Choose between Select All and Selected
    2. Changing between Select All and Selected will tick and untick all Suppliers
    3. Tick the Selected column to include the Supplier
    4. To search for a Supplier, click into the Supplier column then type the Supplier Name. The matching Supplier will be highlighted. Tick Selected to include this Supplier
    5. An easy way to exclude a certain Supplier is to click 'Select All' then untick the Supplier(s) to exclude
  3. On the right hand side, you can choose which Departments and Categories to run the report for:
    1. Choose between Select All and Selected
    2. Changing between Select All and Selected will tick and untick all Departments and Categories
    3. Click the arrow > to the left of each Department to expand the Categories under that Department
    4. Tick the Selected column to include the Department or Category
    5. Ticking a Department will automatically tick Categories for that Department
    6. Tick 'Include Stock not in a Category' to include Stock Items that have a Department set but no Category.
    7. An easy way to exclude a certain Department or Category is to click 'Select All' then untick the Supplier(s) to exclude
  4. Use the Tag box to filter the Report to only include Stock Items with any of the selected Tags
    1. To add a Tag, type the Tag Name into the box next to 'Tag', then press Enter or click the plus + button
    2. To select multiple Tags, click the 3 dots button. You can then select any Tag from the 'All Tags' box
  5. In the Report Viewing / Printing Options section, tick the options as required:
    1. Display Full Stock Description - Tick to show the full description of the item. If unticked, it will show the item's short description.
    2. Show Cost Price - Tick to show the cost price of each item. If unticked, the cost price will be hidden.
    3. Show Retail Price - Tick to show the retail price of each item. If unticked, the retail price will be hidden.
    4. Use Band Colours - Tick to highlight each alternating line, which may make reading the report easier. If unticked, the report will use an entirely white background.
    5. Show Quantity on Hand - Tick to show the current quantity-on-hand number of each stock item. If unticked, the current quantity-on-hand will be hidden.
    6. Show Stock Locale - Tick to show the Stock Locale of each item. If unticked, the Stock Locale will be hidden.
      Click HERE for more information about stock locales.
    7. Exclude Inactive Stock - Tick to hide items that have been marked as inactive. If unticked, inactive stock will be included in the reorder report.
    8. Print New Page For Every Supplier - Tick to separate each supplier on a new page. If unticked, multiple supplier may appear on the same page.
  6. In the Reordering Details section, choose between the following ways to reorder stock:
    1. Reorder Qty based only on the current Qty On Hand of each stock item
      1. Quantities to order are generated entirely based on the Current QOH, Desired Quantity and Stock Reorder Level.
    2. Reorder Qty (based on current QOH) minus Pending Order Qty
      1. Quantities to order are generated as above but minus any quantities that are already in Pending Orders.
    3. Reorder Qty (based on current QOH) minus Sent Order Qty
      1. Quantities to order are generated as above but minus any quantities that are already in Sent Orders.
    4. Reorder Qty (based on current QOH) minus Pending and Sent Order Qtys
      1. Quantities to order are generated as above but minus any quantities that are already in Pending or Sent Orders.
  7. Click Preview to view the report, from which you can print/save the report and then close the preview.
    Alternatively, click on Print to print out the report.
  8. You will then be prompted to create a Pending Order.
    Click Yes to create one or click No to cancel the process.
  9. If you clicked Yes, the order is created and can be viewed in the Orders Maintenance screen.
Info
The generated Reorder Report is not automatically saved, as the user can choose whether to proceed with creating orders based on it. The Print Order button in Orders Maintenance lets you view all orders created using the various filtering options available.