Skip to content
Showcase

Pricelist Management

Simplify and optimize your product catalogs, SKUs, and vendor pricing

◆ View product documentation →
Rubi PL

Looking for the software? Explore Rubi PL to see how teams clean, map, review, and prepare vendor pricelists for ERP import.

Vendor price updates

AV integrators, security installers, and systems contractors receive monthly pricelists in Excel, PDF, CSV, email attachments, and vendor portals. Each list needs to be normalized, validated against existing items, and loaded into Q360 with open quotes and product master records accounted for.

The compounding problem

Stale prices cut into margin when quotes use old costs. Outdated product records can also leave discontinued parts in project specs.

Managed service

We collect vendor lists, clean and validate the data, then publish approved changes to your Q360 product master on your schedule.

Process diagram 1
Fig 01 · Pricelist ingestion + maintenance pipeline

Engagement phases

Phase 1: Clean Up One-time reset. We audit your existing Q360 product master, fix the problems from a decade of bad imports (duplicates, inconsistent manufacturer names, wrong item types, orphaned EOL items) and hand you a clean starting point. See our Product Master Cleanup practice for the details.
Phase 2: Catch Up Intensive sync to current. We contact every vendor on your supplier list, pull the latest pricelist from each one, and load them all into Q360 within a defined window. By the end of this phase your product catalog reflects today's vendor pricing across every supplier.
Phase 3: Maintain Ongoing processing at a defined SLA. New pricelists arrive at our inbox (or a shared drop folder). We process them within the agreed turnaround (typically 48-72 hours) and publish updates to your Q360 master. Your team reviews a summary report; they never touch Excel.

Technology stack.

  • Q360 API: all product master writes go through Q360's API.
  • Q360 Live Data: we use Live Data for reads and verifications, so validation queries don't impact your operational database performance.
  • Pricelist normalization: our engine maps dozens of vendor formats to a common schema and runs the cleanup rules.

Ongoing maintenance

  1. Vendor sends pricelist to us. Could be email, FTP, shared drive, vendor portal download, or whatever your existing vendor relationships already use.
  2. We normalize it. Convert to canonical format, apply manufacturer name normalization, flag any new or changed items.
  3. We validate against Q360. Cross-check every row against your current master. New items go through typing and categorization rules; existing items are price-compared for changes.
  4. We stage the change set. You get a report summarizing "X new items, Y price changes, Z items going EOL" so nothing ever lands in production without review.
  5. You approve (usually takes 2 minutes). One click of approval; the changes apply to the Q360 production master through the API.
  6. Audit log. Every change is logged: who submitted it, when we processed it, when it hit production, what the before and after values were.

Benefits

  • 20+ hours per week of internal time reclaimed, no more dedicated "pricelist person"
  • Faster, more accurate quotes: your sales team is always quoting against current cost and current SKUs
  • Margin protection: price increases flow through within days, not weeks
  • Audit trail: every change to every price with a full history, useful for vendor disputes and customer pricing questions
  • Acquisition-friendly: if you acquire another shop, we absorb their product master into yours as part of the normal cleanup process

FAQ

What vendors do you support?

We have templates for dozens of AV, security, and low-voltage vendors. We typically add a template for a new format within a few days.

What's the pricing model?

Phases 1 and 2 are one-time fees based on product master size and vendor count. Ongoing maintenance is a monthly subscription based on vendor count and processing volume.

Do we still control our Q360 database?

Absolutely. We never touch your database directly. Every change goes through your approval before hitting Q360. You can pause, audit, or override any step at any time.

Let's put this to work for your team.

Book a 30-minute call. We'll walk through your current stack and show you exactly how we'd approach your situation.