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.

BusinessStock ownerWhy
Online store is the only sales channelThe storeIt sees every sale first
Store plus marketplacesAn inventory system or the store with a multichannel toolOne pool of stock, several places selling it
Store plus shop counter or wholesaleInventory or accounting systemMost stock moves happen outside the store
Manufacturer with an ERPThe ERPProduction, 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?

DataDirectionWhen
Orders, as invoices or a daily summaryStore to accountingAs placed, or once a day
Payouts from the gateway, with feesGateway or store to accountingPer settlement
Refunds and returns, as credit notesStore to accountingAs processed
Stock levelsFrom the stock owner to everything elseEvery few minutes, or on change
New products and SKUsFrom wherever products are createdWhen created
Customer recordsStore to accounting, for B2B onlyWith 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?

Questions

Frequently asked.

Can Shopify connect to Tally directly?

Not with a built-in feature. TallyPrime is desktop software, so a connection needs either a connector product that runs alongside Tally, or a custom integration that talks to Tally's XML interface on a machine where Tally is running. Some businesses export orders daily and import them into Tally instead, which is simpler and often good enough.

How often should stock sync?

As close to real time as your systems allow when you sell the same stock in more than one place, such as a store and a marketplace. Every few minutes is enough for most stores. A once-a-day sync works only when the store is the single place stock is sold and the accounting system just needs totals.

Should orders go into accounting one by one or as a daily summary?

For B2C stores with many small orders, a daily summary invoice per payment method keeps the books readable, with the order detail kept in the store. For B2B orders, each order usually needs its own invoice with the buyer's GST details. Agree the approach with your accountant before building anything.

Sohail Hussain

Founder, MSH Technologies

Sohail has designed and built websites, web apps and AI products for over 12 years, for clients from Singapore-based industrial groups to early-stage SaaS startups. He writes about what actually worked.

Keep reading

Related guides.

All posts

Your next move

Like what you see? Tell us about it.

A process that takes too long, a website that undersells you, or an idea ready to take shape. Tell us where you are and we will suggest a useful next step.

India · Working with clients worldwide

Sohail, Founder, replies within 1 working day (Mon–Sat, IST). Free and no obligation.