Supplier Quote Comparison: Excel Price & Quantity Changes
Pricing
$200.00 / 1,000 completed quote comparisons
Supplier Quote Comparison: Excel Price & Quantity Changes
Compare two versions of a supplier quote in Excel before approving a purchase order. Match by SKU, see unit price and quantity changes, added or removed items, and trace the total cost difference to worksheet rows. Supports English and Chinese XLSX files. $0.20 per completed comparison.
Pricing
$200.00 / 1,000 completed quote comparisons
Rating
0.0
(0)
Developer
d
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Security
Limited permissionsShare
Compare a supplier's original and revised Excel quote
Before you approve a purchase order, check which supplier prices changed, which quantities changed, and what the revision does to the order total. Upload the original and revised XLSX quotes. The report matches lines by SKU (or unique item name), lists added and removed items, and gives the row numbers behind each difference. English and Chinese column headers are supported.
Price: USD 0.20 for one completed comparison, including every changed row. A comparison of identical quotes also returns a report. You can inspect the worked example and full JSON output before running the Actor.
Example: the supplier cut a price. Why did the quote rise by CNY 35?
In RFQ-1042, the sensor price fell, but the vendor also changed the order quantities and replaced a line item. The original total was CNY 430.00; the revised total is CNY 465.00.
| SKU | What changed | Original → revised row | Cost impact (CNY) |
|---|---|---|---|
| A · Connector | 10 → 12 units at 20 each | 3 → 3 | +40.00 |
| B · Sensor | 50 → 45 per unit, quantity 4 | 4 → 4 | −20.00 |
| C · Bracket | Removed 2 at 15 | 5 → — | −30.00 |
| D · Sleeve | Added 3 at 15 | — → 5 | +45.00 |
Row 5 looks like one edit if you compare cells by position. Matching by SKU shows that a bracket was removed and a sleeve added. A buyer can now ask whether the extra connectors and the substitution were approved.
Download both sample quotations and the expected report. To reproduce the example on Apify, leave both uploads empty, select Use the example, then run and open Output. The same per-report price applies.
Compare your own two quotes
- In Original XLSX quote, upload the earlier file to a new private quote-only store. In Revised XLSX quote, upload the new file to the same existing store.
- Under Private quote stores (read only) select that store. If the uploads are in different stores, select both. For API input you can also supply signed Apify key-value record URLs.
- Start the run and open Output. The JSON report contains the old and new totals, net difference, and each changed item's quantities, unit prices, amounts and worksheet rows.
Use one sheet per file with a unique SKU or item name, quantity and unit price. Headers must be in the first 20 rows. Optional columns include unit and currency. Chinese headers include 物料编码、品名、数量、单价、币种、单位. Each file supports up to 4 MB and 1,000 items. Duplicate keys stop the run so you can fix the source sheet.
Use the same currency, units and tax treatment in both quotes. Each line is quantity × unit price rounded half-up to two decimals. Freight, discounts and tax affect the result only when expressed as item rows. Formulas require cached values saved by Excel. A renamed item without a stable SKU appears as one removal and one addition.
