Compare and merge supplier CSV files.
Compare CSV, TSV and Excel files by SKU. Inspect source differences, choose your update rules and review the prepared import. Files stay in your browser.
Your files stay in this tab while you visit our guides or switch tools. Clear all files to remove them from the workspace. Refreshing or closing the tab ends the session; keep your originals and downloads.
Help with this step
Start with a small example. Imagine your current file has a tote bag with SKU 0001, price 12.00 and stock 8. Your supplier sends a new price of 13.20 and stock 0. You can update just the price, just the stock, or both.
- Check one file
- Use this to look for file problems or tidy values without comparing suppliers. For example, remove unwanted spaces from names. If you add several files in this mode, they are checked separately.
- Compare an update
- Add your current file first, then a supplier update. Map & match has a source-difference view for all added, missing and changed values. The later review shows only the changes your update rules propose.
- Merge supplier files
- Add your current file first, followed by the supplier files. If two suppliers send different values for the same product, you choose which supplier to trust. If they use the same code for different products, include the supplier name when matching them.
- Choose files / drag and drop
- Add CSV, TSV or XLSX files from your device. CSV separates cells with commas or another mark; TSV uses tabs; XLSX is an Excel workbook. A file list shows which is the baseline and which are updates. Adding a file does not send it to RowParcel’s server.
- Move earlier / Remove
- The arrow changes an update file’s order. The bin removes that file from this workspace, not from your device. Where you choose supplier priority, the first supplier has the highest priority. The baseline remains the first file.
- Try a realistic sample / Load sample files
- Choose a scenario and load its practice files. Loading a sample replaces the current file selection and settings. Sample names, addresses and products are fictional.
- Paste tabular data / Use pasted data
- Paste a small table with its heading row, then choose Use pasted data. It becomes another source file in the workspace.
- Inspect format / Clear all / Cancel
- Inspect format moves to the file preview. Clear all clears this workspace and its current files, not the original files on your device. Cancel stops an operation that is running. Check the resulting file list before continuing.
From a supplier list to a reviewed update
- Add your current file, followed by any supplier updates.
- Check that the columns and text look right.
- Match products by SKU or a combination of fields.
- Choose the fields you want to update.
- Review the result and resolve any unclear matches.
- Download the prepared file and test a small import.
What happens to empty cells?
Empty update cells keep your current values by default. A value of 0 is different from an empty cell. If you want to clear a value, choose that rule and review it before exporting.
Which files can I use?
Use CSV, TSV or Excel XLSX files. You can choose the text encoding, separator and worksheet. Older XLS files and macro-enabled XLSM files are not supported. Excel formulas are not recalculated.
What can I download?
Download a general CSV, TSV or XLSX file, or use the Shopify or WooCommerce product CSV profile. Each profile has its own checks. Your shop may have additional import requirements.
Before you update your shop
Keep a backup, check excluded products and test a small import. RowParcel prepares a file; it does not connect to your shop or change live products.