CSV Stock Comparator
Help
Everything you need to run your first comparison — from uploading files to understanding results.
How to use CSV Stock Comparator
In the first drop zone, drag or click to select a CSV file exported from your ERP system (Odoo, NetSuite, QuickBooks, SAP, or any other). The file must be in .CSV format. Delimiter, encoding (UTF-8, Windows-1250, UTF-16), and number format (e.g. European notation 1.234,56) are detected automatically.
If the file has title rows or metadata before the column header (common in SAP and Crystal Reports exports), a row picker will appear — click the row that is the actual header and continue as normal.
In the second drop zone, load the CSV from your e-commerce platform (WooCommerce, Shopify, Magento, or a custom export). The same automatic format handling applies to this file.
After loading, the tool auto-detects the SKU and quantity columns by name (e.g. sku, quantity, stock, qty). If detection is incorrect, click Choose manually and select the correct columns from the dropdown. Optionally, enable Show product name and select the name column.
Click Advanced options to configure SKU normalization (convert to lowercase or uppercase) and whitespace trimming. Default: lowercase + trim spaces — we recommend leaving these unless you have a specific reason to change them.
Click Run comparison →. Results appear immediately — for files with several thousand rows, processing takes under 2 seconds.
Use the filter buttons at the top of the table to show only the status you need. Pro users can export the complete report to CSV by clicking Export CSV. The free plan shows the first 500 rows.
Understanding result statuses
SKU exists in both files and quantities agree.
SKU exists in both files but quantities differ. The Delta column shows the difference (ERP − Shop).
SKU exists in ERP but not in the Shop export.
SKU exists in the Shop export but not in ERP.
The same SKU appears more than once in one file. Quantities are aggregated by summing, and a warning is shown in the diagnostics section.
Frequently asked questions
Works with any CSV exported from an ERP or e-commerce platform. We auto-detect the delimiter (comma, semicolon, tab, pipe), encoding (UTF-8, UTF-8 BOM, UTF-16, Windows-1250), and number format — including European notation with a thousands dot and decimal comma (e.g. 1.234,56).
Some ERP systems (SAP, Crystal Reports, Odoo reports) prepend title rows or metadata before the actual column header. When the tool detects such rows, it shows a file preview and asks you to click the row that is the real header. For standard files where the header is in the first row, the picker never appears.
Detection works on common header names like sku, product_code,quantity, stock. If your file uses non-standard headers (e.g.Item No., On Hand), use Choose manually to select the correct columns.
Delta = ERP quantity − Shop quantity. A negative value means the shop reports more stock than ERP (e.g. −5 means the shop records 5 more units). A positive value means ERP records more.
No. CSV files are processed entirely in memory during comparison and are never written to disk. Comparison results are stored in your account (Pro plan only) solely for history and export purposes.
The free plan displays the first 500 rows per comparison. The full results are not lost — upgrade to Pro to see all rows, access history, and export to CSV.
Free accounts get 3 comparisons per day. Anonymous users (no account) get 1 comparison per day. The limit resets at midnight UTC. The Pro plan has no limits.
Customer support
If you encounter a bug, unexpected behaviour, or have a question not covered in this guide — write to us. We respond within 24 hours on business days.
✉ support@csvstockcomparator.com