...
If your system can do automatic product file price updates (e.g. if you are an Office Brands dealer), this is the procedure you need to follow to make best use of automatic price updates.
Dealers normally do not have the time to setup their automatic price updates. We suggest you invest in a few support hours and get Readysell to set this up for you. This will result in some sell prices changing in ways you don't expect and will require some followup. But our experience is the task is too large for most dealers to handle themselves. If you decide to get Readysell to help you with thise process we will:
- 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
Procedure
- Run a price book run for all products (see Creating a price book run)
- Add quantity on hand to the price book run log
- Filter the price book run log to only show products where the list price has changed
- 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)
- Sort the price book run lines list view by the "Difference Percentage" column
- Review the large positive and large negative changes on the spreadsheet
- For product where you do not want the data to change to match the price book:
- Go to the product
- Go to Settings > Catalogue Update tab
- Set ignore changes to sell prices and ignore changes to cost prices to be true
...