Sending your product prices to the web

Owned by Sharon Harden (Unlicensed)
Last updated: Mar 30, 2023
7 min read

Overview

The website will show the catalogue prices for products unless you specifically override the price. The "Display on Website" checkbox on products can be used to send your sell prices to the web instead of the default sell prices.


If you are overriding pricing on catalogue products on the web:

  • Any current valid flyer pricing will not be seen/applied on your website for those products that are flagged as display on website in your product file.
  • Once you have flagged Display On Website on a product you are now assuming full control over all pricing on this product both in Readysell and your website as the pricing in Readysell will now flow up to the web becoming store pricing.
  • If you turn off Display On Website on the product, the product pricing will go back to the standard Office Brands pricing and you no longer will update that pricing on that product on the web, it will be controlled by Office Brands.

Overriding catalogue pricing on the web

  1. Open Readysell
  2. Click on Inventory
  3. Click on Products
  4. Search for product and select it
  5. On tab Pricing, the store needs to add/change pricing (this includes overriding List, bulk and Govt pricing levels with your own pricing)
  6. On tab Settings
    1. Display On Website does NOT have to be turned on.  The Readysell program is smart enough to know that if the pricing levels are set correctly for your site for web integration, then if the pricing you have on a catalogue product is different, then send that different price to the web.
    2. If you do not want your sell pricing overridden by the next pricing update, then make sure you turn on flag Ignore Sell Unit/Price - this means the onus is now on you to update your pricing on that product.
  7. Click on button Save

The task listed below will run within 15 minutes and update the pricing on the web for that product.

What task runs the product and pricing updates?

  1. Open Readysell
  2. Click on Administration then click onAdvanced> Tasks
  3. Select Office Brands Product Sync
    This task runs every 15 minutes and picks up changes to pricing in a product within 15 minutes
  4. The Office Brands End of Day the task runs nightly and picks up any new products and images.

Did this pricing send up to the web?

In Readysell

  1. Open Readysell
  2. Click on Inventory
  3. Click on Products
  4. Search for product and select it
  5. Click on button Related (top panel of screen)
  6. Click on Show Office Brands Messages
  7. This will show you the headers and details of products and pricing going up to the web.

In Web Admin

  1. From Internet Explorer ("e" icon on your computer's taskbar or start menu or desktop)
  2. Copy and paste this in to log into the store's web admin https://www.officenational.net.au:8000/webapp/wcs/tools/servlet/ToolsLogon?XMLFile=common.mcLogon
  3. Enter in your username and password
  4. Click on button Log On
  5. Click on Products
  6. Click on Find Catalog Entries
  7. In the Code field, key in the product code
  8. Select from the drop-down field next to it Matches containing
  9. Click on button Find
    The product should appear to the screen if it has made it up to the web.
  10. Click on the check box to the left of the product to tick it
  11. Click on Prices (the word Prices just above tab Category)
  12. Click on Pricing Summary
  13. You are now shown what pricing was uploaded from Readysell and will be loaded to the web.

My pricing is wrong on my website and wrong in Readysell

This could be because you haven't updated your pricing on your products from a catalogue load or a price book run and the Display On Website flag is on.

First, check to see if the Display On Website flag is on.

  1. Open Readysell
  2. Click on Inventory
  3. Click on Products
  4. Search for product and select it
  5. On tab Pricing, the store needs to add/change pricing
  6. On tab Settings
  7. Make sure flag is turned on for Display On Website
    (this will ensure your pricing is displayed on the customer's website)

Where did the pricing come from on the product in Readysell

  1. From the Navigation panel
  2. Click on Inventory
  3. Click on Products
  4. Search for and select the product
  5. Click on tab Tools
  6. Click on button Audit Trail
  7. Look for any changes in pricing
  8. If you cannot see any changes in pricing, then look for anything that says Price Book Run or Catalogue Load
  9. It will say which Price Book Run number of Catalogue Load
  10. The user on it will be blank
  11. But if you go to that module in the Navigation panel, select that loaded catalogue or price book run, click on tools, click on Audit Trail, you will see the user that load/run.
  12. Alternately you may need to look at the Product Import Audit and filter for that product to see if the changes came from your head office.

Forcing sell prices for one product to flow to the Web

If your pricing seems to differ on the web from Readysell or if your customers are getting a message of 'price pending' for a product.
Try forcing one product up to the web and see if that product now works

Procedure: 

Log onto Readysell>Products
Search for the product in question and highlight it

Right-click on a header and select customise layout
Drag the field of ' office brands data last updated' onto the product list view.
Mentally note down the date shown in the "Office Brands Data Last Updated" field. Changing the sell price below needs to cause this date to change. If it changes, the new sell prices will be sent to the web.

​Make a change to one of the product's sell prices of one cent. Save the product. Then change the sell price back again. This will force the "Office Brands Data Last Updated" field to refresh. Which flags the product to have its sell prices sent to the web.
Click on Save
Check that the date in the field should change to the current Greenwich meantime (sets the time to be the time in England)
Now just move on to other work and wait for the "Office Brands Data Last Updated" date on the product to change to "01/01/01". This may take some time.
Then when the date has changed. Log onto the Web yourself and check to see if the price is now correct.
The process above proves if the problem is due to an update not making it to the web or if there is some issue that is preventing updates for this example product changing the sell price on the web.
Note.
The Task "Office Brands Product Sync" will run, if you are working during business hours, and send it up to the web.
The task is as per the screenshot below

The task runs every 15 minutes.

Price Pending message for extended range products

If a customer tries to buy an extended range product and if that product does not exist on your Readysell product file. Then the customer can see a "price pending" error on the website. What happens is your website creates an entry for every product and waits for the sell price update from Readysell. But Readysell does not create extended range products on the product file. Readysell does save those products into the price book, but by default not onto your product file. So the sell price for the extended range products never flows to the website. Causing those products to show on the website as having "Price Pending". The solution is to create the product on the readysell product file. There is no perfect solution to this problem. But there are two approaches you can take to resolve it, as shown below.

The cause of this issue is that Readysell normally copies all extended range products to the product file. But we do not normally load extended range products to the product file. There is an option to load them, but we leave it off by default. As adding every possible extended range product to the product file can create a lot of clutter on your product file. It does not affect search speed or other matters. But does cause a lot of products to be visible your Readysell product file that you'll never sell.

You can get this problem if the "Extended Range" import is disabled or if you do not have a copy of that import that is enabled and which has the "New Products" checkbox turned on.

 Click here to expand...


Once off correction

This happens, you can create the product on your product file by clicking the new button on products, entering the product code then letting the product details add from the price book.

While fixing this problem one product at a time takes some effort and can annoy customers. If the problem only happens once or twice. Then there can be an advantage in keeping your product file simpler and lot loading every extended range product to the product file.

This one at a time approach lets you just fix the occasional issue when it arises and keep your product list smaller.

Permanent fix

If you want to stop this from happening for all products. You need to change your product import rule for "Extended Range" to create new products. To do this you go to product import rules. Set the "Extended Range" rule to be inactive. Copy the "Extended Range" Rule to "My Extended Range", activate the new copy of the rule and then tick checkbox the "New Products" tickbox on the new copy. Then go to tasks, find "Office Brands Product Import" task, go to Parameters and set the "LastRunDate" parameter to blank. Save the task then click the "Run button (or leave the task to update overnight.



If your pricing is not correct and you want it to match the pricing on the Office Brands catalogue

Update your system with the latest catalogue loads or run a price book run.

  • If Display On Website is still flagged on the product, that updated pricing will then flow through to the web.
  • If you turn off Display On Website on the product, the product pricing will go back to the standard Office Brands pricing and you no longer will update that pricing on that product on the web, it will be controlled by Office Brands.

Should you require any assistance with this, please contact Readysell with a support email (send to support@readysell.com.au) or ticket through your Readysell program.