Import Prices

16
Help
Sign Out
Switch
Import Prices
DemoSample company and data, reset every night. Demo: messages are simulated, nothing is actually sent.Exit demo

At A Glance

Your vendors and products, when a Base Cost last changed, and prices that are blank or have not changed in 12 months.MoreLess
What It Does
Last Price Update is the newest Base Cost change in the Change Log. No Price counts products with a blank or $0 Base Cost. Old Prices counts products whose Base Cost has not changed in 12 months (counted from when the product was added if it never changed).
What It Changes
Nothing. It only counts.
How to Use
  1. Open Import Prices.
  2. Read the numbers.
  3. Upload a price list to update old or missing prices.
Help Article
Vendors4to buy from
Products33on Products
Last Price UpdateNone Yetno Base Cost change logged
No Price0Base Cost blank or $0
Old Prices0not changed in 12 months

Update Base Costs From a Price List

Update product costs from your vendor's price list or order history; nothing changes until you check the matches.MoreLess
What It Does
SiteOne works as downloaded from SiteOne Online: Item Number, Description, UOM and Price columns are found by their names, title rows at the top are skipped, and an order history keeps the newest price for each item.
What It Changes
Ticked lines change that product's Base Cost. Lines with no match can start a new product (Add as New, or Look Up First for the EPA label info); a new product is only saved when you press Save on its form.
How to Use
  1. Download your price list or order history (CSV or Excel) from SiteOne Online or your vendor.
  2. Upload it here; it needs a product column and a price column.
  3. Check the Matches and click Apply Ticked Prices.
Help Article

Products from this vendor match first.

Quick Calc

Type a rate, mix or unit question, or tap an example.