Versions Compared

Version Old Version 14 New Version Current
Changes made by

P Sawkins (Unlicensed)

Paul Sawkins

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When a business has thousands of SKU's it becomes important to be able to do mass changes to them.

Table of Contents

Finder

The SKU screen has a finder tab

Some of the selections result in additional columns being added to the results (eg: No New Stock before = adds date column and highlights)

Image RemovedImage Added

Play Area

The play area is designed as a place to make it easier to mass change SKU's or use a SKU as a template for others.

Image RemovedImage Added

How to use the Play Area

From the Article Screen:

  1. Play Area
    1. Create / Restart List - A list of SKU's to act on is required - each person can have their own list but only one at a time
  2. Optional - upload a list of SKU's from XLS to populate the play list
  3. Finder
    1. filter for SKU's of interest
    2. Select, CNTR multi-select, or Select - hold shift - select other record - gets all in between
    3. Right click - add to play area
    4. Change filters
    5. repeat until all items to modify have been placed in play area
  4. Play Area
    1. There will be a list of SKU's - select or multi-select then right click to see options in the play area list
    2. Can remove an item from the play area using multi select and right click
    3. View Actions possible at the bottom of the screen
      1. Setting all articles to the chosen (note list is not exhaustive)
        1. Status
        2. Product Category
        3. Brand
        4. Range
        5. Shopping Cart Status
        6. Product Group
        7. Colour / Size Group
        8. Set (or clear) certificates required with imported purchase orders (Fumigation, Veterinary Health, TGA-ARTG, Refrigerant checks etc.)
        9. Select a SKU in the screen to:
          1. Make compatible children of selected SKU (for item compatibility eg this lid fits this cup)
          2. Copy reorder triggers and levels for franchisor and all franchisees from the selected sku
          3. Merge a SKU into the selected SKU (see below)
          4. Replace a current SKU with an alternative (See below)

Example of marking SKUs inactive

Create a play list

Image RemovedImage Added

If you have the SKU list in XLS - one column must be headed SKU

Image RemovedImage Added

Otherwise - use the finder then multi-select and right click to add to play list

Import from the XLS

Image RemovedImage Added

Check the import worked

Image RemovedImage Added

Can add items from the finder screen - just keep searching and adding

Image RemovedImage Added

Choose inactive status on the SKU screen

Image RemovedImage Added

Back on the play list - set items to inactive

Note

If the SKU has stock it will not go to inactive instead it will go to runout status (can be sold cannot be purchased)

Image RemovedImage Added

Merging Items from the play area

Where an SKU has inadvertently been created twice (ie duplicated) - then you can merge one into another.  All transactions will be appended to the surviving SKU

Select a SKU in the screen > right click on a sku in the play area list to merge (the sku in the play list will not survive).

Replacing a current item with alternatives

Common when a better item is found and want to phase out the old and start selling the new.

  • Set the current item to "Run Out" status - it cannot be placed on a purchase order - can still be placed on a sales order
  • Create the new SKU
  • Link it as a Replacement in the work area
  • Forecasting will now use the combined sell rate to determine purchase requirements for the replacement item.
  • Customer order history will show the old item until no stock is available - it will then show the replacement item in the re-order dropdown

Linking the replacement using the work area

Image RemovedImage Added

The Result

Note

Daily Purchase Order will:

  1. Order the replacement item when the runout item has been ordered and there is not sufficient stock and highlight PO's affected

Sales Forecasting will

  1. Consider sales history for any Active SKU to include sales history of any Runout SKU it is replacing

Image RemovedImage Added

Actions Button in Play Area - Mass updates

Note

The actions are NOT available to Franchisees

  1. Set Status, Category or Shopping Cart Status on Article tab to the value that you would like to change the articles in the Play list to.
  2. Menu actions specify the values to be changed to.
  3. All articles in the Play list that do not already have the value will be updated and a count will be displayed.
  4. The Play list grid will be refreshed but the Finder grid will not and the selected article, if any, will not.
  5. If the Status is to be changed to Inactive then it will be changed to Runout if the article has any stock (in any warehouse of any host). The message will show the count of articles changed to Inactive and changed to Runout.

Image RemovedImage Added

Pricing Tab in the Play Area

Managing pricing when not using price lists requires the ability to

...

  1. Identify slow moving stock articles from the slow moving stock report
  2. Create a play list on the stock article (see above)
  3. Filter to find articles to discount - Add to the play list - remove some that do not need to change price
  4. Enter a -10% increase to Sell Price based on Current Sell Price
    1. Flag to use retail rounding if required
    2. Resulting changes to prices will show in a report (see below)
    3. Changes will be logged in the Audit Trail

Image RemovedImage Added

Diagnostics Area

Finds SKU's that appear not to be setup correctly.

...

Double click line to open Article.Image Removed

Image Added


Runout Status Items write off remaining stock

When the playlist has only runout items in it - then an option to Write off remaining stock of runout items is shown

Add runout items to playlist

Image Added

Choose the write off option

Image Added

Yellow note will show

Image Added

Continue

Image Added

Journals will be created

Image Added