I will compare two price lists and report product and price changes
Excel and CSV cleanup, product catalog organization
About this Gig
Find out exactly what changed between your old and new supplier price lists.
I will compare two Excel or CSV files using the product ID or SKU you specify. Basic covers one worksheet per file, up to 100 rows and 10 columns in each. Both lists must use the same currency and price basis.
You receive an Excel workbook listing matched products, old and new prices, price differences, newly added items and removed items. Duplicate IDs, missing prices and ambiguous matches are flagged for review. Up to three comparison formulas are included in the workbook.
Please identify the old and new files, matching key, price columns, currency and any VAT or discount rules. Original product codes are preserved.
This service compares supplied data only. It does not include web research, currency conversion, tax advice, fuzzy matching by name, macros or updates to your store. One revision within the original scope is included.
Platform:
Excel
Development technology:
Excel
Expertise:
Formulas
FAQ
Can you match products without SKU or ID?
Basic uses an exact shared product ID or SKU. Name-only or approximate matching requires a sample check and a separately agreed scope.
