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.
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.
Engagement phases
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
- Vendor sends pricelist to us. Could be email, FTP, shared drive, vendor portal download, or whatever your existing vendor relationships already use.
- We normalize it. Convert to canonical format, apply manufacturer name normalization, flag any new or changed items.
- 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.
- 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.
- You approve (usually takes 2 minutes). One click of approval; the changes apply to the Q360 production master through the API.
- 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
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.
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.
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.