Versions Compared

Key

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

...

  • Flag all products where sell price will vary by more than 100% to not update cost or sell prices or units from Office Brands
  • Post a first price book run to line up your data with Office Brands
  • Run some reports showing you the changes to your sell prices
  • Turn on automatic price updates
  • Print your first batch of product labels if required for any retail stock. The timing of automatic updates and retail label printing is critical if your business has a retail area. You have to know which nights are going to post automatic price updates. So that you can generate labels for any price changes quickly the next morning and get them onto the shelves before customers start buying stock. Otherwise you risk having out of date retail pricing on your shelves that do not agree to the actual sell price in the system. It is not acceptable to have price labels on your shelves that show a different sell price to the price changed to customers.

We recommend that you set your system to automatically update sell prices from your price book:

  • Daily if your business does not have a retail area
  • Once a week if you do have a retail area

Automatic price updates update products that are not covered by catalogue loads. For example endlless isle sell prices are never updated by manual catalogue loads. To keep those product up to date, you have to go to automatic price price updates.

We do not recommend automating loading of flyers. There are too many variables on fliers. It is best to stick with loading them manually.

Procedure

  1. Run a price book run for all products (see Creating a price book run)
  2. Add quantity on hand to the price book run log
  3. Filter the price book run log to only show products where the list price has changed
  4. Look at the "Difference Percentage" column on the price book run lines. (This column uses a formula newvalue/oldvalue*100 to calculate the percentage change for relevant fields)
  5. Sort the price book run lines list view by the  "Difference Percentage" column
  6. Review the large positive and large negative changes on the spreadsheet
  7. For product where you do not want the data to change to match the price book:
    1. Go to the product
    2. Go to Settings > Catalogue Update tab
    3. Set ignore changes to sell prices and ignore changes to cost prices to be true

...