Target Profit %
Operating profit target for this job type. Applied silently to all quotes.
Add New Item
| Name | Wolseley Code | City Code | Category | Qty | Markup Β£ | Actions |
|---|---|---|---|---|---|---|
| Loading⦠| ||||||
Search priority order
1
Wolseley Transaction History
Products you've bought β your actual prices. Searched first.
Has price
2
City Plumbing Price List
Your contracted CP prices. Monthly update recommended.
Has price
3
Wolseley Master Catalogue
Full product directory. No price β for name/description search only.
No price
How to update your data
Step 1 β Get the file
Download the latest file from your supplier portal or email. See each card below for details on where to find it.
Step 2 β Upload here
Drag the file onto the card or click to browse. For City Plumbing, pick which month the prices are for.
Step 3 β Automatic
The system archives the old file, records prices in the Price Tracker, and rebuilds the search index. Nothing else to do.
Wolseley Transaction History
Not loaded
24 months purchase history Β· XLSX
β
Products
β
File size
Your Wolseley account order history. Contains product codes, descriptions, and the prices you paid. This is the primary source for Wolseley pricing.
Where to get this: Log in to your Wolseley online account → Order History → Export last 24 months as XLSX.
Expected columns:
Wolseley Code
Manufacturer Product Code
Product Desc
Selling price per unit
Supplier Name
Product Super Category
Product Sub Category
Drop XLSX here or click to browse
On upload: Replaces the existing history file and rebuilds the search index. Products from this file appear first in search results.
City Plumbing Price List
Monthly
Contracted account prices Β· XLSX
β
Products
β
File size
Your City Plumbing account price list. Updated monthly β replace with the latest file each time you receive it. Note: copper tube/fittings are not included in the monthly file; use manual price entry on quote lines.
Where to get this: City Plumbing send this via email each month (subject usually contains "Price file"). Save the attached XLSX and upload it here.
Expected columns:
product_id
description
Manufacturer code
Price
cps_retail_price
UOM
Category Level 1
Category Level 2
Drop XLSX here or click to browse
On upload: The previous file is archived automatically. Prices are recorded in the Price Tracker under the month you select above, and the search index is rebuilt.
Wolseley Master Catalogue
Not loaded
Full product directory Β· CSV Β· ~76 MB
β
Products
β
File size
The complete Wolseley product catalogue. Large file (~76 MB) β only needs uploading occasionally when Wolseley send an update. Contains no prices; used purely to extend search coverage.
Where to get this: Wolseley provide this as a CSV export. Ask your Wolseley account manager for the latest master catalogue if you don't have one.
Expected columns:
ParentCategoryCode
CategoryName
Partnumber
ProductName
Buyable
DisplayToCustomer
ProductUrl
Drop CSV here or click to browse
On upload: Replaces the existing catalogue and rebuilds the search index. This is a large file β expect 30β90 seconds depending on connection speed.
Activity log
Waiting for importsβ¦
Upload product photos for quotes. Match to products by SKU or keyword rules.
πΈ Upload Image
Name it after the SKU for automatic matching, or use a descriptive name for range mapping.
πΌ Uploaded Images
No images uploaded yet.
π Keyword Mapping
Map an image to products by keywords. If ALL keywords match the product name, the image appears on the quote.
Saved securely to database. Sensitive values are encrypted.
β Email (SMTP)
Comma-separated. Receives an email when a new quote is submitted from the app.
Not tested yet
β Quote Page Hosting
Quotes are served securely via quotations.beesonplumbing.co.uk with unique token-based links.
Each quote expires after 30 days. No FTP required β pages are served directly from the hub.
β© Hub Callback URL
When a customer approves or declines a quote, their browser sends a request back to this hub.
If the hub is on a local machine (Raspberry Pi etc.) it needs to be reachable from the internet β
use a Cloudflare Tunnel
or similar. If on a VPS with a domain, just enter that.
No trailing slash. e.g. https://hub.beesonplumbing.co.uk or https://your-vps-ip:8080
π Wolseley iHub API
When credentials are configured, searching in quote baskets will fire live price calls to
Wolseley's iHub API, returning your real-time account price rather than the historical price from the import file.
The token is cached server-side for 1 hour and refreshed automatically.
Used as OAuth scope and in price request. Shown in Wolseley portal.
Change to production URL when ready to go live.
Not tested yet
π§ Business Details
Currently hardcoded at Β£22.10/hr β changing this requires a server restart.
Pre-fills the billed rate field on new quote baskets.