Inventory sync between your store and Tally, Zoho or QuickBooks
Decide which system owns stock, give every variant one SKU, sync orders and payouts in one direction. How to connect Shopify or WooCommerce to your books.
By Sohail Hussain21 November 20265 min read
To keep your online store and your accounts in step, decide which system owns the stock count, give every variant one SKU that is identical in both systems, and sync each kind of data in one direction only: orders and payouts from the store into accounting, stock either from the store or from your inventory system, never both ways at once. Zoho Books, QuickBooks and Xero have ready-made connectors for Shopify and WooCommerce. Tally needs a connector that runs alongside it, a custom integration through its XML interface, or a disciplined daily import.
Most broken syncs we are asked to fix are not technical failures. They are two systems both believing they own the same number.
Which system should own stock and prices?
One system is the source of truth for each figure. The others read from it.
| Business | Stock owner | Why |
|---|---|---|
| Online store is the only sales channel | The store | It sees every sale first |
| Store plus marketplaces | An inventory system or the store with a multichannel tool | One pool of stock, several places selling it |
| Store plus shop counter or wholesale | Inventory or accounting system | Most stock moves happen outside the store |
| Manufacturer with an ERP | The ERP | Production, purchasing and sales all change stock |
Prices follow the same rule. If your accounting or ERP system holds price lists, the store reads them. If staff change prices in the store, the store owns them, and accounting just records what was charged.
If you sell on Amazon or Flipkart as well as your own site, this decision matters most; marketplace vs own store covers running both. Store integrations like these are part of our e-commerce development work, and larger system connections sit under APIs and integrations.
What should flow between the store and the accounts?
| Data | Direction | When |
|---|---|---|
| Orders, as invoices or a daily summary | Store to accounting | As placed, or once a day |
| Payouts from the gateway, with fees | Gateway or store to accounting | Per settlement |
| Refunds and returns, as credit notes | Store to accounting | As processed |
| Stock levels | From the stock owner to everything else | Every few minutes, or on change |
| New products and SKUs | From wherever products are created | When created |
| Customer records | Store to accounting, for B2B only | With the first order |
Payouts are where the books most often go wrong. Your gateway settles each batch net of its fee and the GST on that fee. On Razorpay's standard plan, a ₹2,000 order settles at ₹1,952.80, with ₹40 fee and ₹7.20 GST deducted, as of October 2026. The books need the ₹2,000 sale, the ₹40 expense and the ₹7.20 GST recorded separately, not one deposit of ₹1,952.80. The Razorpay fee calculator shows the split for any amount, and the GST calculator helps check the tax lines on invoices.
How do the main accounting tools connect?
Zoho Books and Zoho Inventory offer their own Shopify and WooCommerce integrations, which bring orders across and keep stock in step. They suit small and medium stores well, if their mapping matches how your accountant wants sales recorded.
QuickBooks and Xero have connector apps on both platforms, from the accounting providers and from third parties. Most can post either individual orders or daily summaries, and handle payout reconciliation.
Tally is the most common request we get in India, and the hardest. TallyPrime is desktop software, so there is no cloud API to call. The options are a connector product that runs on the same machine or network as Tally, a custom integration that sends vouchers to Tally's XML interface while Tally is running, or a daily export from the store imported into Tally by a person. For a store with a few dozen orders a day and stock owned by the store, the daily import is often the sensible choice. Tally and Zoho Books integration goes into the options in more detail.
On the store side, both platforms expose what an integration needs: Shopify through its Admin API, WooCommerce through its REST API, and both through webhooks that fire when orders are created or changed.
How do you set up the sync, step by step?
Step 1: Decide which system owns stock and prices
Use the table above. Write the decision down and tell the team, so nobody edits stock in the wrong place.
Step 2: Give every variant one SKU in both systems
Each size and colour of each product needs a unique SKU, spelled identically in the store and the accounts. This is the step that takes longest on an existing business, and the one that makes everything after it work.
Step 3: Decide what syncs, in which direction and how often
Use the second table as a starting point. Anything that syncs both ways needs a clear rule for conflicts, so avoid it where you can.
Step 4: Map taxes, ledgers and payment methods
Map each GST rate and HSN code, the sales ledgers, each payment method and gateway, shipping charges, discounts and fees. Interstate and intrastate sales need the right tax split. If you issue B2B invoices, e-invoicing may apply above a turnover threshold. Do this step with your accountant.
Step 5: Choose a connector or a custom integration
An existing connector is cheaper and maintained by someone else. Choose custom only when your mapping, your ERP or your volume does not fit what connectors offer.
Step 6: Test with real orders on a test company
Run a week of real orders, including refunds, partial shipments, discounts and a failed payment, through a copy of the accounts. Check every figure.
Step 7: Go live with monitoring and a daily check
Turn on alerts for failed syncs. For the first few weeks, compare daily sales and stock totals between the store and the books. Why integrations break covers retries, logging and alerts.
What usually goes wrong?
- Two-way stock sync that loops or overwrites a correct number with a stale one.
- Bundles and kits, where one store product uses several stock items. Most connectors need these mapped by hand.
- Manual edits in the system that does not own the stock.
- Returns that are refunded in the store but never restocked in the inventory system.
- Rounding, where tax calculated per line in the store differs by a paisa from tax calculated per invoice in accounting. Agree which rounding rule wins.
When is a custom integration worth it?
When the stock owner is an ERP or Tally with complex rules, when you sell across several channels with one stock pool, or when a connector's mapping forces your accountant into manual corrections every month. If the connector works and the corrections take ten minutes a week, keep the connector. If you are also choosing a platform around these needs, how to choose an e-commerce platform covers when an ERP-driven store becomes a custom build.
Was this guide useful?