E-commerce operations
Your shopfront never sleeps. Can your books keep up?
Shopify is the platform many small sellers build on. This guide covers how its orders, payouts and customers stay connected to accounting, CRM and marketing without tangled records.
Start here
Why commerce becomes the hub
For modern small retail, the shop holds the facts everyone else needs: what sold, at what price, with what tax, paid out when. Accounting needs those totals, CRM needs the customer, marketing needs segments. Shopify sits in the middle because orders start there.
Treat it as the hub and connect outward with vendor-supported app integrations. One hub with clean settings beats three partial records. The app store is the difference between a shop and a business that reconciles; pick integrations that your accountant can name and your staff can follow without a walkthrough.
The rule that keeps the hub honest: if a fact lives in two places and they disagree, the shop is the source. Everything else reads from it, syncs to it, or reconciles against it.
Products
Catalog, variants, and inventory reality
Write titles customers search for, keep variants tight, and set weights and barcodes before you scale.
Shopify product + variant model with connected inventory app
Cycle count top sellers weekly
One owner assigned to stock sync between counter and web
Sage 50 style accounting with stock depth
Weights set before shipping, barcodes set before scaling
Catalog errors surface at payout and tax time
Titles written in the words customers actually search
Variant sprawl costs you reports, not options
Money
Taxes, payouts, and fees without surprises
Configure tax zones for the states where you have presence, confirm payout schedules, and track fees separately from revenue. Reconcile payouts to bank deposits weekly while volume is low.
Keep refunds, discounts, and shipping as distinct lines so your reports stay readable from month to month. Ask your bookkeeper how they want Shopify data mapped in Xero or Sage 50 before you sync a single order. Monthly catch-ups hide the mistakes that weekly checks catch in minutes.
Weekly tie-out
- Sales Shop report
- Fees Separate line
- Refunds Own account
- Payouts Bank match
Books
Connecting shop to accounting
Sync orders or daily summaries, map tax and fee accounts once, and lock the mapping.
A one-page field map, kept in Notion
- Orders
- Shop order records sync to Xero as daily summaries or line-level transactions, whichever your bookkeeper already reconciles.
- Tax accounts
- Sales tax collected maps to one liability account per jurisdiction, and the mapping is documented before the first sync.
- Fees
- Processing fees land in a dedicated expense account so gross revenue stays gross and margin stays visible.
- Refunds
- Refunds post as a separate reversal line, not a discount, so your returns rate stays reportable.
- Payouts
- Each payout batches into a single deposit that ties to the bank statement at the end of the week, not the end of the quarter.
- Locked mapping
- Once the mapping is set, no one changes it mid-quarter. Consistent posting beats clever posting every time.
Customers
Turning buyers into repeat customers
Pass order emails with consent into your CRM and tag first-time versus repeat buyers. Use customer lifecycle notes to record issues, returns, and preferences. Follow up on abandoned carts and post-delivery checks with a light touch and clear opt-outs. Keep support replies in a shared place so anyone can continue the thread. Repeat revenue grows from remembered detail, not from sending more mail.
What the CRM keeps
- Order history with consent status on the contact
- Returns, issues, and resolution notes on the customer record
- First-time versus repeat tag, kept current
- Segments passed to the marketing list, never the other way around
Follow-up that stays welcome
Abandoned-cart and post-delivery sends carry a plain opt-out on every message. If a customer replies, the thread lives where the team works — not in a support inbox nobody else watches.
Where it pays
Repeat revenue grows from remembered detail. The second purchase is easier to earn than the first.
Automation
Workflow automation that stays safe
Automate low-risk steps — new-order alerts to Slack, fulfillment tasks to Asana, review requests after delivery windows. Keep money movement and refunds under human approval. Document each automation with trigger, action, and owner.
Test with real orders in low season. Turn off anything that fires without a clear next action.
-
01
New-order alert
Order placed posts to the fulfillment channel with paid status and shipping method. Owner: fulfillment lead.
-
02
Fulfillment task
Pick, pack, and ship tasks created in Asana against the order number. Owner: packing lead.
-
03
Review request
Sent after the delivery window closes, once per order, with an opt-out. Owner: marketing lead.
-
04
Refund approval
Manual step, not automated. Held for a human approval before the reversal posts.
Common traps
Beginner mistakes to avoid
Fix with a settings audit, variant cleanup, and weekly payout tie-outs. Freeze new apps until the money chain is clean.
Tax and payouts
Unmapped tax zones and unreconciled payouts top the list. Both surface late and cost the most to untangle.
Catalog
Variant sprawl and untracked manual discounts compound. Simple catalogs sell and reconcile faster.
Mixing accounts
Mixed personal orders on the business account blur the record. Separate payment and shipping details before scaling.
App pile-up
Adding five marketing apps before the books reconcile slows every fix that follows. Freeze installs until the chain is clean.
Judging quality
How experienced sellers judge the fit
They check order search speed, variant handling, discount and gift-card flows, refund posting, report exports, and integration behavior with accounting and CRM. They test a return end to end and confirm the ledger impact lands where the mapping says it will. They confirm permission roles for staff and seasonal help. Trial those exact paths with your own products, not with demo goods.
Solo maker
Under 50 SKUs
Tidy basics and weekly reconciliations. Do not add inventory modules you will not read.
Growing shop
Hundreds of SKUs
Variant discipline and cycle counts. Revisit the stack each season rather than each week.
Two-channel seller
Counter + web
Clear inventory ownership and daily stock sync checks. One owner, one source of truth.
Getting started in two weeks
Week one
Clean the catalog, set taxes and shipping, connect payouts, and link accounting. Nothing else moves until those four are stable.
Week two
Connect CRM lists, build fulfillment tasks, set Slack alerts, and run ten test orders including a refund. Write the returns page in plain language. Train staff on picking, packing, and refund steps before you advertise.
Answers
Questions sellers ask first
Two answers cover most of what a shop owner wants to know before connecting anything.
How does Shopify connect to accounting and CRM?
Through vendor-supported app integrations that pass orders, payouts, and customer facts outward. Map tax, fee, refund, and revenue accounts once, then reconcile weekly. Keep customer history in CRM with consent handling. A one-page field map keeps all three aligned and gives your bookkeeper a document to point at.
Do we need extra inventory software?
Depends on SKU count and locations. Simple catalogs can run with shop-level quantities plus regular counts. Variant-heavy or multi-spot stock often needs deeper inventory management and reporting. Count SKUs, spots, and reorder rules before adding modules — an inventory app that nobody counts is a report you will not use.
What should we set up before we advertise the shop?
The four that keep the money chain clean: taxes and shipping configured, payouts connected, accounting linked, and one round of ten test orders including a refund. Train the people picking, packing, and processing refunds before you push traffic at the store.
How often should we reconcile payouts?
Weekly while volume is still low, and at least monthly once order counts climb. Weekly tie-outs surface a missed fee, a refund coded wrong, or a payout that never reached the bank while the details are still fresh. Monthly catch-ups hide the same mistakes under a larger stack of records.
End of the bench
Your shopfront is a business. Treat the books that way.
Shopify is the platform most small sellers pick, and it earns that spot by holding the orders everyone else reads from. The work of keeping it connected is quieter than the storefront: a settings audit, a locked mapping, one weekly tie-out. Do those and the shop stays a hub rather than a backlog.
Talk to Deskberry Digital