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

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)

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.

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

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

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

Import from the XLS

Check the import worked

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

Choose inactive status on the SKU screen

Back on the play list - set items to inactive

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

The Result

Actions Button in Play Area - Mass updates

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.

Pricing Tab in the Play Area

Managing pricing when not using price lists requires the ability to

1. Create a list of items that needs pricicng manipulation
2. View the current pricing
3. Mass update the list with changes

The options available are:

1. % Mass change to 
   1. RRP
   2. Sell Price
2. Base on
   1. RRP
   2. Sell Price
   3. Buy Price
   4. Average Cost

Examples - time to get rid of some slow moving stock.

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

Diagnostics Area

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

Refresh to display exceptions.

• 'Assembly without components'.
• 'Components but not assembly'.
• 'Default buy price but no supplier'.
• 'Quantity buy price but no supplier'.

Double click line to open Article.

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

Choose the write off option

Yellow note will show

Continue

Journals will be created