Hub

Pricelist Standardizer

Turns any supplier price list into the SPS upload format — matched, priced, and checked.

v0.18
No files handy? Run the whole flow on a sample: a real-looking supplier price list for the supplier picked below, plus the SPS Product Information export of the Holy Stone catalog.
Download: sample price list · SPS master export

1 Files

Excel or CSV, exactly as the supplier sent it — no clean-up needed.
Product Information export from SPS.

2 Pricing

Retail
Distributor
Contractor
Designer
Price = cost ÷ (1 − margin), rounded to .25 / .50 / .75 / .95 — never .00. Cost is never rounded.

How it works

  1. Pick the supplier, then its price list and the SPS master export.
  2. Each supplier has an adapter that knows its layout, its discount and its units — box prices are converted to the unit SPS sells by.
  3. Hit Process: every row is matched to an SPS item, flagged for review, or proposed as NEW. SPS items missing from the list become inactivation candidates.
  4. Export XLSX gives the 24-column upload file plus Review, Inactives and Price Comparison tabs.

History — last 5