Tally-to-Shopify SKU Mapper
The ERPPlugs SKU Mapper matches every Shopify variant to a TallyPrime stock item: first by exact SKU against the Tally part no, alias or item name, then by barcode, then by name with a confidence score. It flags duplicate SKUs, variants with no Tally item and Tally items missing from Shopify, and exports the mapping to Excel or CSV without uploading your files.
Use the free tool
Your files stay on your device. Everything is processed in your browser. Nothing is uploaded to ERPPlugs or anyone else, and no account is needed.
TallyPrime stock item list
Export your stock items from TallyPrime to Excel or CSV with name, part no and alias columns.
Shopify product export
The products CSV from Shopify admin (Products, then Export). One row per variant.
Load both files, or click Use sample data on each, to see the mapping.
How the Tally-to-Shopify SKU Mapper Works
- 1
Load your two files
Export your stock items from TallyPrime to Excel or CSV, and export the products CSV from Shopify admin. Drop both in, or try the sample data. Columns are detected automatically and you can correct them.
- 2
Review the matches
Each Shopify variant is matched on SKU first, then barcode, then name. Close names are flagged for review with the top candidates, and duplicates, unmatched variants and Tally-only items are listed separately.
- 3
Fix and download
Change the Tally item for any variant from its dropdown, or mark it as no match. The counts update as you go, and the Excel and CSV downloads include your choices.
Getting a Clean SKU Map Between Tally and Shopify
Before you export
Exact SKU matches are the most reliable, so check where your team keeps the Shopify SKU in TallyPrime. If it is in the part no or alias field, include that column in the export. If Tally item names already contain the SKU, the tool will find those too.
Export every variant from Shopify, not a filtered view, so that items missing from Shopify are reported correctly.
Reading the results
Exact SKU matches show 100% confidence. Name matches show the score the tool calculated, from 0 to 100. Anything marked Needs review has a suggested Tally item already selected: confirm it, pick another candidate, or mark it as no match.
- Exact SKU match: the SKU or barcode equals a Tally part no, alias, item name or barcode.
- Name match (high confidence): name score of 80% or more and at least 5 points ahead of the next candidate.
- Needs review: name score from 55% to 79%, or two candidates within 5 points.
- No match in Tally: no unused Tally item scored 55% or more.
- Duplicate SKU: a SKU shared by several variants or several Tally items, or one Tally item chosen for several variants.
- Tally item not on Shopify: no Shopify variant is mapped to it.
After mapping
Use the downloaded sheet to copy the Shopify SKU into the matching Tally part no or alias, or the other way round, so both systems share one code per variant. Fix duplicate SKUs before switching on any automatic sync, then run the mapper again to confirm everything shows as an exact match.
Frequently Asked Questions
A list of your stock items exported from TallyPrime to Excel (.xlsx) or CSV. Only the item name is required. Part no, alias, stock group, units, HSN/SAC, barcode, rate and closing quantity are used when present. If you keep your Shopify SKU in the Tally part no or alias field, most items will match exactly. Old .xls files need to be saved as .xlsx or CSV first.
The standard products CSV exported from Shopify admin. It has one row per variant with Handle, Title, Option1 to Option3 values, Variant SKU and Variant Barcode. Shopify leaves the Title blank on every variant row after the first, so the tool carries the title forward by Handle and builds names such as "Cotton Kurta / Indigo / M". Rows that only hold an extra product image are skipped.
In three passes. First, the Shopify SKU is compared with the Tally part no, alias and item name, ignoring case, spaces, dashes and leading zeros. Second, the Shopify barcode is compared with a Tally barcode column or a numeric part no or alias. Third, the remaining variants are matched on name: the score blends character similarity with word overlap, and clashing sizes, colours or numbers (M against L, set of 2 against set of 4) pull it down sharply. Each Tally item is used once, best score first. A score of 80% or more with a clear lead over the next candidate is a name match; 55% to 79%, or two close candidates, is marked Needs review.
Three cases: one SKU on more than one Shopify variant, one part no or alias shared by more than one Tally item, or one Tally item mapped to several variants (including by your own dropdown choices). Any sync that works on SKUs cannot tell which item an order or stock update belongs to in these cases, so they are worth fixing first.
No. The mapper is free, has no product limit and needs no sign-up. It is built to handle catalogues of a few thousand variants in a normal browser. Larger files take a little longer because all the matching runs on your own device.
No. Both files are read and matched inside your browser. Nothing is sent to ERPPlugs or anyone else, and closing the tab clears the data. Only the files you choose to download are saved, to your own computer.
Ready to eliminate manual data entry?
- Free consultation
- No commitment
- Tailored to your team
All product names, logos, and brands mentioned on this site are the property of their respective owners. ERPPlugs is not affiliated with, endorsed by, or sponsored by any of the third-party companies referenced. Use of these names is for identification purposes only and does not imply any association or endorsement.