Multi-Channel Inventory Audit
The ERPPlugs Multi-Channel Inventory Audit compares your TallyPrime closing stock with inventory files from Shopify, Amazon India, Flipkart or any other channel, joined by SKU. It flags listings above Tally stock, live listings with no stock, channel SKUs missing from Tally, unlisted stock, negative stock and quantity drift, and exports the results to Excel 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 closing stock
Your stock summary or stock item list from TallyPrime, exported item by item with closing quantity. Add the part no / SKU column if you keep one.
2Channel inventory files
Add up to 4 channels. Leave a channel empty to skip it, or remove it.
Shopify inventory
Shopify inventory export (CSV). Uses the SKU and Available columns; rows for several locations are added up.
Amazon India inventory
An Amazon Seller Central inventory or listings report. Uses seller-sku and quantity (or afn-fulfillable-quantity for FBA).
Flipkart inventory
A Flipkart Seller Hub listings file. Uses Seller SKU Id and your stock count.
Load the Tally file and at least one channel file, or click Use sample data on each, to run the audit.
How the Multi-Channel Inventory Audit Works
- 1
Load Tally stock
Export closing stock item by item from TallyPrime to Excel or CSV, with the part no or SKU column if you keep one. Or start with the sample files.
- 2
Add your channels
Add up to four channel files: a Shopify inventory export, an Amazon India inventory or listings report, a Flipkart listings file, or any file with SKU and quantity. Choose whether the channels share one stock pool.
- 3
Fix what is flagged
Every SKU is checked for oversell risk, negative stock, SKUs missing from Tally, unlisted stock and drift. Filter by issue and download Summary, All SKUs and Issues sheets.
How to Run a Useful Multi-Channel Stock Audit
Export everything at the same moment
Stock moves all day, so export Tally and every channel file as close together as you can, ideally before dispatch starts or after it ends. Orders that are in a channel but not yet billed in Tally will otherwise show up as differences.
Export Tally stock item by item rather than by stock group. Group totals have no SKU and would be compared as if they were items.
What to fix first
Rows are sorted with the most serious issues on top.
- Critical: negative Tally stock, live listings with no Tally stock, and channels listing more than Tally holds. These can lead to orders you cannot ship.
- Warning: channels that together exceed a shared pool, SKUs that exist on a channel but not in Tally, and quantity drift.
- Info: stock in Tally that is not listed on any channel you loaded.
Inactive listings
If a channel file has a status column, listings marked inactive, blocked, suppressed, closed, draft or archived are shown but not counted as live, so they never raise oversell flags. Without a status column, every listing is treated as live.
Frequently Asked Questions
From TallyPrime: closing stock exported item by item to Excel or CSV, with item name and closing quantity (quantities such as "120 Nos" or "(-)5 Nos" are read correctly) plus the part no or SKU if you keep one. From each channel: any inventory or listings export with a SKU column and a quantity column, such as the Shopify inventory export (SKU and Available), an Amazon India report (seller-sku with quantity or afn-fulfillable-quantity) or a Flipkart listings file (Seller SKU Id and stock count). Excel (.xlsx) and CSV both work.
By SKU, after ignoring case, spaces, dashes and leading zeros. Rows for the same SKU in one file, such as one row per Shopify location, are added together. For Tally items with no SKU, the tool tries the channel SKU against the Tally item name, then the channel product name against the Tally item name, and shows which key was used. A channel SKU that matches nothing is reported as not in Tally.
Listed above Tally stock: one channel shows more units than Tally holds. Live with no Tally stock: Tally is at zero or below but a live listing still has quantity. Channels together exceed stock: with a shared pool, live listings add up to more than Tally holds. Not in Tally: a channel SKU with no Tally item. Unlisted stock: a Tally item with stock that is in none of the channel files. Negative stock: Tally closing quantity below zero. Quantity drift: with the shared pool off, a channel differs from Tally by more than your tolerance.
Turn it on (the default) when every channel sells from the same Tally stock and you split units between channels: the audit then checks that live listings add up to no more than Tally stock. Turn it off when each channel is meant to show your full Tally quantity: the audit then flags any channel whose quantity differs from Tally by more than the tolerance you set, in units.
No. The audit compares quantities only and does not read sales history, so it cannot tell how fast an item sells. The closest signal is unlisted stock: items with units in Tally that are not listed on any channel you loaded.
No. All files are read and compared inside your browser. Nothing is sent to ERPPlugs or anyone else, there is no sign-up, and closing the tab clears the data.
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.