Rubi PL turns inconsistent XLSX, XLS, and CSV vendor files into clean, reviewed ERP loadsheets. It detects the usable product data, guides your field mapping and pricing adjustments, and shows the proposed delivery before anyone approves it.
Q360 is the first supported destination. Rubi PL compares proposed rows with current Q360 product data so your team can review matched products, new products, changed values, warnings, and fields that should be preserved.
Common File Formats
Upload XLSX, XLS, or CSV vendor pricelists.
Clean Source Preview
Review selected sheets, headers, columns, and product rows before mapping.
Guided Mapping
Map columns, set values, combine text, and apply common pricing calculations.
Q360 Comparison
Compare proposed output with refreshed, read-only Q360 product data.
Review Before Delivery
Resolve warnings and approve the delivery only when it is ready.
Reusable Work
Save mappings, reuse them for later files, and keep every revision.
Cleans Up Messy Sources
Rubi PL detects workbook structure and common spreadsheet noise, then presents the usable sheets, columns, and rows as a consistent source preview. Your team reviews the result before any mapping begins.
Maps Source Columns to ERP Fields
Copy one or more source columns, set fixed values, clean and combine text, or calculate pricing. The workbench previews the mapped result so adjustments can be checked as they are applied.
Shows the Exact Proposed Output
Before delivery, Rubi PL builds the proposed Q360 output and surfaces validation warnings. Operators can review what will be included without opening and reconciling several intermediate spreadsheets.
Compares Against Q360
A read-only Q360 connection supplies the latest available master data for comparison. Rubi PL separates matched and new rows, highlights changed values, and lets the operator preserve selected Q360 fields.
Prepares Approved Deliveries
Once the review is complete, an operator explicitly approves and downloads the Q360 loadsheet files. Each approved delivery keeps the source file, mapping decisions, output, and history together.
Reuses Mappings and Tracks Revisions
Approved mappings can be saved, reused, archived, and audited. When a vendor sends a replacement file, Rubi PL creates a revision, preserves the original delivery, and surfaces mapping changes that need review.
Upload
Add the vendor XLSX, XLS, or CSV file and keep the original source with the work.
Source
Review the detected structure, selected sheets, cleaned columns, and usable product rows.
Map
Connect source columns to destination fields and apply the needed values, adjustments, and calculations.
Deliver
Compare with Q360, resolve warnings, preserve selected fields, approve, and download the loadsheets.
Workspace and users
Set up the customer workspace and the people who will prepare and approve pricelists.
Q360 reference connection
Configure the read-only connection used to refresh product data for comparison.
Starting mapping
Use a real vendor file to establish the first source and destination mapping.
Delivery review
Walk through warnings, comparison results, preserved fields, approval, and loadsheet download.
A real vendor pricelist
An XLSX, XLS, or CSV file that represents the work your team handles.
Your Q360 field requirements
The product and pricing fields your import process relies on.
Q360 connection details
Read-only access for refreshing master reference data.
Review owners
The people responsible for checking mappings and approving deliveries.
Connected-System Actions
Reviewed updates and cleanup in connected systems, beginning with Q360.
Reviewed PDF Intake
Support for product and pricing data supplied as PDF pricelists.
100+ AV Vendor Mappings
More than 100 independently validated standardized mappings for leading AV vendors.
Master Catalog
Discover and pull approved product records without beginning from a pricelist.
Buy and Sell Marketplace
An opt-in marketplace for tenants to publish selected overstock for other tenants.
More ERP Destinations
Output support for NetSuite, QuickBooks, Odoo, D-Tools, and Improoved.
Scope notice: The current Rubi PL workflow produces reviewed Q360 loadsheets for operator approval and download. Roadmap items describe planned directions, not delivery commitments or current capabilities. Separately scoped hands-on pricelist assistance is also available from Rubi Works.