Field Notes | Studio Eucalipto

THE FILTER IS ON. IS THE DOOR STILL OPEN? Smiling Leafy holds a ShieldLeaf shield beside an open online-shop doorway and a white checklist labelled Choose, Preview, Test and Review.

Shopify Traffic Protection: A Checklist

Use this ShieldLeaf checklist to set a country rule, preview blocked visits, test customer access and review unwanted Shopify traffic after launch.

Read field note

NO MARKET. NO ENTRY? Smiling Leafy compares a crossed-out checkout cart under Markets with a ShieldLeaf shield at an online-shop doorway, showing that purchasing eligibility and visitor access need separate controls.

Traffic & Country Access

Shopify Markets and Country Blocking: Different Roles

Shopify Markets manages selling and localisation. See how ShieldLeaf adds a separate country rule for visitors you wish to block or redirect.

Read field note

THE BLOCK WORKS. CAN CUSTOMERS STILL SHOP? Smiling Leafy checks a white rounded card with separate Blocked and Allowed routes, a stopped globe, an open online shop and a ShieldLeaf shield.

Traffic & Country Access

How to Test Country Blocking on Shopify Before Launch

Preview ShieldLeaf’s blocked page or redirect privately, then test blocked and permitted connections before extending your Shopify country rules.

Read field note

Blocked. What happens next? Smiling Leafy points to a white rounded message card reading Access unavailable and Need help?, with a crossed-out globe, envelope, ShieldLeaf shield and map stickers.

Traffic & Country Access

What Should Visitors Blocked by Country See?

Give Shopify visitors blocked by country a clear explanation, a support contact or a useful redirect. Set up and preview the experience with ShieldLeaf.

Read field note

Conversion halved. Did sales? A white rounded panel compares 3% with 1.5% while orders remain at 30; smiling Leafy points between a LedgerLeaf receipt and a ShieldLeaf map and shield.

Traffic & Country Access

Why Has My Shopify Conversion Rate Suddenly Fallen?

Investigate a sudden fall in Shopify conversion rate using LedgerLeaf sales records, then manage unwanted country traffic with a tested ShieldLeaf rule.

Read field note

10× the visits. Where are the shoppers? Sessions rise from 500 to 5,000 while orders stay at 15; smiling Leafy investigates a map beside a ShieldLeaf shield.

Traffic & Country Access

Investigating a Sudden Shopify Traffic Spike

Find the cause of a sudden Shopify traffic spike, identify the country behind it and turn unwanted regional visits into a tested ShieldLeaf rule.

Read field note

More visits. No real orders. Is it fraud? Smiling Leafy compares a spike in bot sessions, a US$0 receipt and a card marked with a question beside ShieldLeaf branding.

Traffic & Country Access

Bot Sessions, Fake Orders and Fraud: How to Tell Them Apart

Distinguish Shopify bot sessions, fake orders and payment risk, then use ShieldLeaf to manage recurring unwanted traffic from a country.

Read field note

1 COUNTRY. 0 ORDERS. KEEP LETTING IT IN? Leafy blocks a dotted route from a purple map pin beside a sessions-up, orders-zero card to a Shopify online shop.

Traffic & Country Access

How to Reduce Unwanted Regional Traffic to a Shopify Shop

Diagnose unwanted regional Shopify traffic, cut avoidable visits and use ShieldLeaf to keep selected countries outside your online shop.

Read field note

BLOCKED COUNTRY. WHY DID THE CLICK STILL COUNT? Leafy stands behind a ShieldLeaf barrier that stops a dotted visitor path after an ad click and first analytics signal but before a Shopify storefront journey.

Traffic & Country Access

How Country Blocking Interacts With Ads, Pixels, and Shopify Analytics

Learn how country blocking stops unwanted traffic from generating deeper pixel events, polluting ad audiences, and distorting Shopify analytics.

Read field note

BLOCK A COUNTRY. BLOCK YOUR RANKINGS? Leafy holds a ShieldLeaf shield and magnifying glass between a stopped country route and a search-result path that continues to a storefront.

Traffic & Country Access

Does Geo-Blocking Affect Shopify SEO?

Learn when country blocking can affect Shopify crawling and regional visibility—and how to keep a ShieldLeaf rule narrow, useful, and testable.

Read field note

WRONG STOREFRONT. WHERE SHOULD THEY GO? Leafy holds a direction sign as a dashed route sends an international visitor from the wrong storefront towards a suitable regional store under a ShieldLeaf shield.

Traffic & Country Access

Redirecting International Visitors on Shopify

Redirect Shopify visitors by country: use Markets for localised selling, and ShieldLeaf when selected countries need a useful route away from this online shop.

Read field note

YOU DON'T SHIP THERE. SHOULD THEY STILL GET IN? Leafy weighs a stopped parcel route against an open storefront protected by a ShieldLeaf shield, showing that not shipping and blocking access are separate decisions.

Traffic & Country Access

Should You Block Countries You Do Not Ship To?

Decide when Shopify Markets is enough—and when an unserved country should get a clear ShieldLeaf block or redirect at your storefront.

Read field note

YOUR BOOKKEEPING SHEET HAS SALES. CAN IT CLOSE THE MONTH? Leafy reviews five labelled workbook tabs for control, LedgerLeaf sales, payouts, monthly summary, and evidence.

Templates & Checklists

Shopify Bookkeeping Spreadsheet Template: A Five-Tab Workbook

Build a five-tab Shopify bookkeeping spreadsheet, then use LedgerLeaf to refresh its sales, payout, tax, and inventory evidence each month.

Read field note

YOUR PAYOUT MATCHED. CAN YOUR SPREADSHEET PROVE WHY? Leafy compares a LedgerLeaf payout source tab with a bank-match row showing a zero difference and a green Matched status.

Templates & Checklists

Shopify Payout Reconciliation Spreadsheet Template

Build a Shopify payout reconciliation spreadsheet that matches every deposit, then use LedgerLeaf Pro to keep the source evidence repeatable.

Read field note

DAILY, WEEKLY, OR MONTHLY? YOU’RE ASKING THE WRONG QUESTION. Leafy points from payout, exception, and full-close cards to one repeatable reconciliation calendar.

Bookkeeping & Reports

How Often Should You Reconcile a Shopify Shop?

Use a practical Shopify reconciliation schedule: match payouts as they arrive, review exceptions weekly and complete a full LedgerLeaf close each month.

Read field note

AUTOMATE THE REPEATABLE. WHO CHECKS THE EXCEPTION? Leafy guides Shopify report files through a LedgerLeaf workflow towards a human review checklist.

Bookkeeping & Reports

Manual vs Automated Shopify Bookkeeping

Compare manual and automated Shopify bookkeeping, then use LedgerLeaf to repeat the data work while keeping judgement and exceptions under review.

Read field note

Bookkeeping & Reports

How to Build a Custom Shopify Sales Spreadsheet

Build a useful Shopify sales spreadsheet, then save its source columns as a repeatable LedgerLeaf export profile instead of rebuilding it monthly.

Read field note

CSV DROPS FORMULAS, TABS & FORMATTING. WHICH FILE SHOULD YOU SEND? Leafy compares a simple CSV table with a polished spreadsheet workbook.

Bookkeeping & Reports

CSV vs Excel for Shopify Reports

Choose CSV or Excel for each Shopify report, avoid common format traps, and export the same saved LedgerLeaf profile in either file type.

Read field note

YOUR SELL-THROUGH REPORT CAN BE TWO DAYS BEHIND. WOULD YOU REORDER FROM IT? Leafy uses a magnifying glass beside a two-day calendar, inventory boxes, and a sell-through report on a green LedgerLeaf background.

Inventory & SKUs

Shopify Stock Reports: Which One Should You Use?

Choose the right Shopify stock report for shortages, movement, value or discrepancies—and keep the stock behind it aligned with LedgerLeaf.

Read field note

SHOPIFY ONLY SHOWS 180 DAYS OF INVENTORY HISTORY. WHAT HAPPENS ON DAY 181? Leafy examines a torn calendar while a trail of inventory boxes fades beyond it, illustrating Shopify's 180-day product and variant adjustment-history window.

Inventory & SKUs

Shopify Inventory Adjustments Explained: Set To, Adjust By, and Reasons

Choose the right Shopify inventory adjustment, read its history, and use LedgerLeaf rules to keep linked stock aligned after the change.

Read field note

TWO ON-HAND COLUMNS. WHICH ONE SAFELY UPDATES SHOPIFY? Leafy points to a count spreadsheet where On hand (current) 48 has a lock, On hand (new) 46 has a pencil, and a LedgerLeaf stock-pool rule connects two SKU tags.

Templates & Checklists

Shopify Stock Count Spreadsheet for Shared Stock

Build a Shopify stock count spreadsheet that catches stale numbers, then use LedgerLeaf SKU rules and snapshots to keep shared stock accurate.

Read field note

SHOPIFY SAYS 31. YOUR SHELF SAYS 27. WHICH NUMBER DO YOU FIX? Leafy compares a 31-unit Shopify on-hand card with 27 physical mug boxes, then points to a checked LedgerLeaf SKU rule keeping linked listings aligned.

Inventory & SKUs

How to Reconcile Physical Stock With Shopify Inventory

Reconcile a physical count with Shopify by location and SKU, then use LedgerLeaf rules to keep linked products and bundles aligned.

Read field note

SHOPIFY LETS ONE VARIANT HAVE 20 BARCODES. WHY KEEP A SKU TOO? Leafy compares a readable MUG-OLV-12 SKU card with a scannable barcode label and points to a checked LedgerLeaf SKU rule.

Inventory & SKUs

SKU vs Barcode in Shopify: What Should You Use?

Learn when Shopify needs a SKU, a barcode, or both—and why clear SKUs give LedgerLeaf better building blocks for linked stock and bundle rules.

Read field note

YOUR SKU SYSTEM FITS 100 PRODUCTS. WILL IT SURVIVE 1,000? Leafy points to TEE-CREW-OLV-M as 100 product boxes grow into an orderly 1,000-product shelf.

Inventory & SKUs

How to Create a Scalable SKU Naming Convention

Build a Shopify SKU convention that can grow from 100 to 1,000 products and gives LedgerLeaf clean patterns for linked stock and bundles.

Read field note

YOUR OSS RETURN IS FILED. COULD YOU PROVE EVERY ROW 10 YEARS LATER? Leafy archives a LedgerLeaf evidence pack with country, rate, payment, and return records.

VAT & OSS

What Records Should You Keep for an OSS Return?

Build a 10-year OSS evidence pack around LedgerLeaf exports, Shopify order records, adjustments, filing, and payment proof.

Read field note

WHAT STOPS THE BOTS THAT GET THROUGH? A Cloudflare filter catches several purple bots while one reaches ShieldLeaf, where caped Leafy and the country-blocking shield protect a Shopify storefront and its tracking signals.

Traffic & Country Access

A Practical Way to Protect Shopify from Bots and Scrapers

See how ShieldLeaf stops unwanted traffic from selected countries from interfering with Shopify pixels, analytics, audiences and advertising data.

Read field note

OSS DUE ON A WEEKEND? THE DEADLINE STAYS. Leafy points to three checked LedgerLeaf review steps beside a calendar marked 31 and Weekend.

Templates & Checklists

Quarterly OSS Checklist for Shopify Merchants

Close your Shopify OSS quarter with LedgerLeaf: review country and rate totals, resolve refunds, freeze the evidence pack, and track filing and payment.

Read field note

€120 INCLUDES 20% VAT. IS VAT €20 OR €24? Leafy points to a LedgerLeaf-style review panel that splits gross €120 into VAT €20 and net €100.

VAT & OSS

Tax-Inclusive Pricing on Shopify: What Your Reports Show

See how Shopify splits a tax-inclusive price into net and tax, then verify each country-and-rate result with LedgerLeaf.

Read field note

€20 OFF. €48 REFUNDED. WHY DID VAT MOVE TWICE? Leafy traces an order-day discount and later refund to separate taxable amount and VAT rows in a green LedgerLeaf review panel.

VAT & OSS

How Refunds and Discounts Affect Shopify VAT Reports

Trace Shopify discounts and refunds to the right VAT period, country, rate, and transaction with a repeatable LedgerLeaf review.

Read field note

ONE COUNTRY. TWO VAT RATES. WHICH ORDER EXPLAINS IT? Leafy uses a magnifying glass to compare France 20% and 5.5% rows above a green LedgerLeaf panel labelled COUNTRY, RATE, and TRANSACTION.

VAT & OSS

How to Review Shopify VAT by Country and Rate

Find the country-and-rate rows that need attention, trace them to Shopify orders, and turn the result into a repeatable LedgerLeaf VAT review.

Read field note

ONE €10,000 LIMIT. NOT 27. Leafy points from FR, DE, and ES chips into one combined threshold meter above a LedgerLeaf VAT review panel labelled COUNTRY, RATE, and PERIOD.

VAT & OSS

EU Distance-Selling Threshold for Shopify: One €10,000 Limit

The EU distance-selling threshold is €10,000 in total, not per country. See what counts and turn the result into a LedgerLeaf VAT review.

Read field note

SAME EU CUSTOMER. WHICH VAT LANE? Leafy routes an EU-stock parcel towards quarterly OSS and a non-EU parcel under €150 towards monthly IOSS, beside a green LedgerLeaf VAT review panel labelled COUNTRY, RATE, and EXPORT.

VAT & OSS

VAT OSS vs IOSS for Ecommerce: Which Scheme Fits?

Learn the shipment-origin test for OSS vs IOSS, then use LedgerLeaf to keep Shopify VAT evidence separated by country, rate, period, and scheme.

Read field note

BOTH ADD TAX. WHY CAN'T YOU REPORT THEM THE SAME WAY? Leafy separates a final-sale SALES TAX receipt from a staged VAT trail, then points to a green LedgerLeaf VAT review folder labelled COUNTRY, RATE, and OSS.

VAT & OSS

Shopify Sales Tax vs VAT: What Merchants Need to Distinguish

Separate Shopify sales tax from VAT, then use LedgerLeaf to review EU VAT by country, rate, period, and OSS scope without mixing the evidence.

Read field note

SHOPIFY TOOK THE FEE. WHICH RECORD PROVES IT? Leafy sorts a Shopify bill and LedgerLeaf Pro payout evidence into a green bookkeeping folder, with subscription and processing fees kept separate.

Bookkeeping & Reports

Are Shopify Fees a Business Expense? Records to Keep

See when Shopify fees are generally business expenses, which records support each fee, and how LedgerLeaf keeps processing-fee evidence ready.

Read field note

€10,000 GROSS. €7,600 NET. WHAT CHANGED? Leafy considers a white gross-to-net panel showing €1,500 in discounts and €900 in sales reversals on a green LedgerLeaf background.

Bookkeeping & Reports

Gross Sales vs Net Sales in Shopify: What Changed?

See how Shopify calculates gross and net sales, explain the gap, and save the supporting sales data in a repeatable LedgerLeaf export.

Read field note

SALE IN JUNE. PAYOUT IN JULY. WHICH MONTH COUNTS? Leafy stands between June sale and July payout calendar stickers beneath a white LedgerLeaf-style question panel.

Bookkeeping & Reports

Cash vs Accrual Accounting for Ecommerce: Which Date Counts?

Compare cash and accrual accounting for ecommerce, then build the Shopify evidence your chosen method needs with a repeatable LedgerLeaf workflow.

Read field note

ONE SALE. FOUR RECORDS. WHICH ONE DID YOU MISS? Leafy traces one sale into sales, payout, expenses, and stock records, with the purple expense receipt outside the LedgerLeaf workspace.

Bookkeeping & Reports

Ecommerce Bookkeeping for Beginners: Start With Four Records

Set up ecommerce bookkeeping around sales, payouts, expenses, and stock, then use LedgerLeaf to keep the Shopify-side records ready to repeat.

Read field note

CAN A VPN CROSS THE SHIELD? Leafy points from a blocked-country map pin through a purple tunnel to a VPN exit in an allowed country beside a storefront and ShieldLeaf shield.

Traffic & Country Access

Can VPN or Proxy Visitors Bypass Country Blocking?

Learn how VPN and proxy exit locations can bypass Shopify country rules, what country blocking still stops, and how ShieldLeaf sets a clear boundary.

Read field note

BLOCK A COUNTRY OR EVERY IP? Leafy compares a map with one highlighted country and ShieldLeaf shield imagery with three purple example IP address cards.

Traffic & Country Access

Country Blocking vs IP Blocking for Shopify

Unwanted Shopify traffic keeps changing IP addresses? See how one ShieldLeaf country rule replaces the chase, with simple setup and a free starting plan.

Read field note

BLOCKED VISITOR. STILL COUNTED? Leafy points from one purple visitor map pin stopped by a ShieldLeaf shield at the storefront to a separate session report that still shows one session.

Traffic & Country Access

Why Blocked Visitors Can Still Appear in Shopify Analytics

Still seeing blocked visitors in Shopify Analytics? Use ShieldLeaf to verify the live country rule, check the visitor experience, and avoid needless changes.

Read field note

BOT TRAFFIC. BLOCK IT ALL? Leafy points to two paths beside a Shopify storefront: a green search crawler is allowed in, while a purple bot from an unserved country is redirected away by a ShieldLeaf shield.

Traffic & Country Access

Good Bots vs Bad Bots on Shopify

Keep useful Shopify bots working and handle recurring unwanted country traffic with a tested ShieldLeaf rule. See the setup and free-plan value.

Read field note

SAME SALES. LOWER CONVERSION? Leafy points from a 250-session, 10-order card showing 4% to a 1,000-session, 10-order card showing 1%, as purple bot map pins inflate the second session count.

Traffic & Country Access

Can Fake Traffic Lower Your Shopify Conversion Rate?

Same orders, lower Shopify conversion rate? Understand the numbers and use ShieldLeaf to block recurring unwanted country traffic without coding.

Read field note

FILTERED = BLOCKED? Leafy points to a shield between a white analytics filter card and a storefront as three purple bot map pins approach.

Traffic & Country Access

How Shopify Bot Filtering Changes Analytics Reports

Understand Shopify bot filtering, avoid misleading conversion comparisons, and use ShieldLeaf to block recurring unwanted country traffic without code.

Read field note

ONE MUG SOLD. STILL FIVE BUNDLES? Leafy points from a five-mug stock card through a one-sold step and a LedgerLeaf bundle rule to the corrected four-bundle quantity.

Inventory & SKUs

How to Prevent Overselling Bundles on Shopify

Stop promising bundles you cannot fulfil. Use a LedgerLeaf Pro SKU rule to make bundle availability follow component stock, then check the zero-stock result.

Read field note

ONE SALE. WHAT LEFT THE SHELF? Leafy follows one order towards either a ready-made gift box or the candle and soap inside it, with LedgerLeaf turning the chosen stock model into a clear SKU rule.

Inventory & SKUs

Shopify Kits vs Bundles for Inventory and Reporting

Selling ready-made kits or picking bundles to order? Use LedgerLeaf to connect the right Shopify stock and keep sales records easier to interpret.

Read field note

11 CANDLES. WHY CAN SHOPIFY SELL ONLY 5 BUNDLES? Leafy points to component cards: 11 candles divided by 2 equals 5.5, rounded down to 5; 18 soaps divided by 3 equals 6; 7 boxes divided by 1 equals 7. The lowest capacity gives 5 available bundles.

Inventory & SKUs

How Shopify Calculates Available Bundle Inventory

Understand Shopify’s bundle calculation and use LedgerLeaf Pro to keep one-of-each bundle stock aligned without repeated manual updates.

Read field note

ONE ENGRAVING SELLS. WHY DO ALL FOUR VARIANTS DROP TO 19? Leafy points from one 20-unit blank plaque stock pool through LedgerLeaf exact sync to four engraving variants showing 19.

Inventory & SKUs

How Shared Inventory Works for Shopify Variants and SKUs

Stop four Shopify variants promising the same stock twice. Follow a 20-plaque example using LedgerLeaf Pro to keep shared quantities aligned.

Read field note

THREE LISTINGS SAY 48 IN STOCK. DO YOU HAVE 144 MUGS? Leafy points as one 48-unit mug stock pool branches through LedgerLeaf exact sync to three listing cards showing 48.

Inventory & SKUs

How to Sync Inventory Across Multiple Shopify Products

Sync inventory across Shopify products with LedgerLeaf Pro. Follow a 48-mug example through sales, returns, and restocks without updating each listing by hand.

Read field note

YOU PAID $4,800 FOR STOCK. WHERE DID $1,800 GO? A LedgerLeaf diagram branches 400 units bought for $4,800 into 250 sold with $3,000 cost and 150 unsold remaining as $1,800 inventory, while Leafy points to the unsold stock.

Bookkeeping & Reports

Shopify Cost of Goods Sold and the Errors That Distort Profit

Check Shopify COGS with LedgerLeaf sales exports and inventory snapshots. Explain unsold stock, missing costs, and supplier price changes before closing.

Read field note

10 UNITS ON THE SHELF. WHY DOES THE SNAPSHOT SAY 6? Leafy points to a June 2026 Available-basis snapshot of 6, calculated from 10 on-hand units minus 4 committed units. Six incoming units are separate and not yet received.

Inventory & SKUs

What Shopify Month-End Inventory Snapshots Mean

Understand Shopify’s October 2026 inventory report change and use LedgerLeaf Pro to explain stock differences at month-end without rebuilding spreadsheets.

Read field note

USD, EUR, GBP. WHICH PAYOUT MATCHES WHICH BANK? Leafy guides three currency-labelled payout cards through separate dashed paths to matching bank accounts and a LedgerLeaf payout trail.

Bookkeeping & Reports

How to Reconcile Multi-Currency Shopify Payouts

Reconcile multi-currency Shopify payouts with LedgerLeaf Pro. Follow a USD bank match, explain fees, and keep later EUR conversions separate.

Read field note

FULL REFUND. WHY IS THE CARD FEE STILL THERE? Leafy points from separate return, refund, and chargeback cards to LedgerLeaf sales export and payout report evidence.

Bookkeeping & Reports

How to Account for Shopify Refunds, Returns, and Chargebacks

Trace Shopify refunds, returns, and chargebacks with LedgerLeaf. Explain retained card fees and connect each order to the payout that changed.

Read field note

ONE SALES EXPORT. WHAT WILL YOUR ACCOUNTANT STILL ASK? Leafy points from period, currency, tax, and payment cards towards a LedgerLeaf accountant handoff folder.

Bookkeeping & Reports

How to Prepare Shopify Sales Data for Your Accountant

Prepare Shopify sales data for your accountant with LedgerLeaf. Save export columns, explain refunds and fees, and send records that match the task.

Read field note

€2,200 OR €2,180? WHAT CHANGED? Smiling Leafy points to LedgerLeaf Pro country, rate, and export evidence beside an earlier €2,200 worksheet, a €20 VAT refund, and a reviewed €2,180 total, with a note to count the refund once.

Bookkeeping & Reports

Shopify Tax Reports Explained

Understand Shopify tax reports and use LedgerLeaf Pro to explain country totals, check refund differences, and export clear tax records.

Read field note

SHOPIFY HAS THE NUMBERS. DO YOUR ACCOUNTS KNOW WHERE THEY GO? Smiling Leafy guides LedgerLeaf export cards for sales, tax, payouts, fees, and inventory into your own account map with labelled destinations.

Bookkeeping & Reports

A Chart of Accounts for Shopify Bookkeeping

Use a worked Shopify chart of accounts example to separate revenue, tax, fees, and bank deposits with repeatable LedgerLeaf exports.

Read field note

BLOCK THEM—OR SEND THEM SOMEWHERE BETTER? Leafy stands at a fork between a ShieldLeaf blocked-access page and a redirect to a regional storefront.

Traffic & Country Access

Block or Redirect? Choosing a Country Rule for Shopify

Choose a blocked page or redirect in ShieldLeaf so visitors get a clear answer or reach the right regional seller, without editing Shopify theme code.

Read field note

SAME SKU. SAME STOCK? A cap and T-shirt with duplicate codes need unique SKUs; two listings for the same physical caps connect through a LedgerLeaf Pro linked-SKU rule, guided by smiling Leafy.

Inventory & SKUs

Duplicate SKUs in Shopify and How to Fix Them

Find accidental duplicate Shopify SKUs, fix catalogue collisions, and use LedgerLeaf linked-SKU rules when listings intentionally share stock.

Read field note

SALES: €12,000. PAYOUT: €10,842. WHERE DID €1,158 GO? Leafy maps timing, other payment methods, refunds, fees, and holds between a sales card and a LedgerLeaf Pro payout card.

Bookkeeping & Reports

Why Shopify Sales and Payouts Do Not Match

See why Shopify sales and payouts differ, then use LedgerLeaf sales exports and payout reports to explain the gap without guessing.

Read field note

REMOVED FROM MARKETS. WHY CAN THEY STILL BROWSE? Leafy points between a Shopify Markets no-checkout panel and a ShieldLeaf no-storefront-access panel.

Traffic & Country Access

Can Shopify Natively Block a Country? Options and Limitations

Shopify Markets restricts purchases but leaves browsing open. See how ShieldLeaf blocks unwanted country visits with a free rule and a preview.

Read field note

Bookkeeping & Reports

Shopify Order CSV Columns Explained

Understand Shopify order CSV columns, avoid double-counting multi-item orders, and use LedgerLeaf to save a cleaner export profile for each job.

Read field note

THE BANK GOT €97. DID YOU SELL €97? Leafy points from a €100 customer charge through a €3 processing fee to a €97 bank deposit beside a LedgerLeaf-style payout panel.

Bookkeeping & Reports

How to Record Shopify Payments Fees in Your Books

Use LedgerLeaf to prepare Shopify Payments fee entries, explain a €97 deposit from a €100 payment, and send your accountant the supporting records.

Read field note

READY FOR OSS OR JUST A TOTAL? Smiling Leafy holds a quarterly OSS checklist beside Germany and France VAT cards by rate and a separate €19 refund note for an earlier quarter.

VAT & OSS

Shopify OSS VAT Reporting for Your Quarterly Return

Prepare Shopify OSS reports with LedgerLeaf. Review country and rate totals, trace refunds to the right quarter, and export a clear accountant handoff.

Read field note

WHICH SALES NUMBER? Leafy compares gross, net, and total sales cards beside a clean LedgerLeaf-style report panel on a green background.

Bookkeeping & Reports

Shopify Sales Reports and the Numbers That Matter

Understand Shopify gross, net, and total sales with a worked example, then use LedgerLeaf to turn the supporting records into a reusable accountant export.

Read field note

WHY THERE? Leafy traces an unexpected map pin to a traffic chart beside bot, link, and VPN clues in a green ShieldLeaf-style illustration.

Traffic & Country Access

Why Is My Shopify Store Getting Traffic From Unexpected Countries?

Unexpected country traffic can hide healthy Shopify sales. Learn how to trace the cause and use ShieldLeaf to handle unwanted storefront visits.

Read field note

12 TEAS. 5 MUGS. HOW MANY GIFT SETS CAN YOU SELL? Leafy points to two component cards connected to a LedgerLeaf BUNDLE RULE panel.

Inventory & SKUs

How to Keep Shopify Bundle Inventory in Sync

Keep Shopify gift-set stock aligned with tea and mug inventory. Set a LedgerLeaf bundle rule and check sales, restocks, and the limiting component.

Read field note

YOUR SKUS LOOK ORGANISED. WILL YOUR BUNDLE STOCK STAY IN SYNC? Leafy points from a bundle SKU and two component SKU cards to a checked BUNDLE RULE panel.

Inventory & SKUs

Shopify SKU Guide for Clear Codes and Synced Stock

Give each Shopify variant a clear SKU, avoid duplicate codes, and use LedgerLeaf to keep bundle stock aligned with the items you can actually ship.

Read field note

THE VAT TOTAL MATCHED. CAN YOU EXPLAIN EVERY RATE? Leafy uses a magnifying glass to trace a VAT total into country, rate, and refund review cards.

VAT & OSS

Shopify VAT Reports: What to Export and Check

Use LedgerLeaf to check Shopify VAT by country and rate, trace a refund difference, and send your accountant a clear summary with transaction detail.

Read field note

IS THAT TRAFFIC HUMAN? Leafy examines a sharp sessions spike beside source and country clues in a green ShieldLeaf-style analytics illustration.

Traffic & Country Access

How to Identify Bot Traffic in Shopify

Identify Shopify bot traffic without mistaking it for lost sales. Follow a worked example to turn unwanted country traffic into a ShieldLeaf access rule.

Read field note

THE REPORTS ARE DOWNLOADED. IS THE MONTH CLOSED? Leafy reviews a seven-step checklist for period, sales, payments, payouts, tax, inventory, and handoff.

Templates & Checklists

Shopify Month-End Close Checklist for Merchants

Use this Shopify month-end close checklist to prepare sales, payouts, VAT, and stock records with LedgerLeaf and resolve gaps before accountant handoff.

Read field note

STOP PAYING $150/MONTH FOR ZOHO BOOKS JUST TO CONNECT SHOPIFY. Leafy compares a towering stack of business modules with one clean Shopify workbook.

Bookkeeping & Reports

LedgerLeaf vs Zoho Books: Is Zoho Books Overkill for a Small Shopify Store?

Compare LedgerLeaf and Zoho Books for Shopify integration, exports, inventory, accounting features, and the regular price of direct store connection.

Read field note

STOP PAYING $276/YEAR FOR FRESHBOOKS FEATURES YOUR STORE DOESN'T NEED. Leafy separates Shopify product-sales data from a service-business toolkit.

Bookkeeping & Reports

LedgerLeaf vs FreshBooks: Is FreshBooks Overkill for a Small Shopify Store?

Compare LedgerLeaf and FreshBooks for Shopify data, invoicing, reports, integrations, and regular pricing before adding a general accounting platform.

Read field note

STOP PAYING $300/YEAR FOR XERO JUST TO EXPORT TO EXCEL. Leafy points from a large accounting dashboard to a clean Shopify spreadsheet.

Bookkeeping & Reports

LedgerLeaf vs Xero: Is Xero Overkill for a Small Shopify Store?

Compare LedgerLeaf and Xero for Shopify exports, payouts, reports, complexity, and regular pricing—and decide whether a full ledger is necessary.

Read field note

STOP PAYING $456/YEAR FOR QUICKBOOKS JUST TO EXPORT A SPREADSHEET. Leafy balances a complicated accounting suite against a clean Shopify workbook.

Bookkeeping & Reports

LedgerLeaf vs QuickBooks: Is QuickBooks Overkill for a Small Shopify Store?

Compare LedgerLeaf and QuickBooks for Shopify data, reports, spreadsheets, complexity, and regular pricing before paying for a full accounting suite.

Read field note

THE PAYOUT MATCHED. WHAT’S STILL MISSING? Leafy traces charges, refunds, disputes, fees, and adjustments through a €2,881 payout to the matching bank deposit.

Bookkeeping & Reports

How to Reconcile Shopify Payments Payouts

Reconcile Shopify Payments payouts with LedgerLeaf Pro. Follow a €2,881 example, spot missing fees, and prepare clear records for your accountant.

Read field note

Why can they still visit if they can’t check out? Smiling Leafy holds a ShieldLeaf shield between a crossed-out checkout cart and an open storefront, showing that purchase restrictions do not block storefront access.

Traffic & Country Access

How to Block Countries on a Shopify Store

Block unwanted country traffic on Shopify with ShieldLeaf. Follow a practical setup, choose a blocked page or redirect, and preview before going live.

Read field note

Why did 1 Shopify order become 3 spreadsheet rows? Leafy compares one Shopify order with three exported line-item rows.

Bookkeeping & Reports

How to Export Shopify Orders to Excel or CSV

Use LedgerLeaf to export Shopify orders to Excel or CSV. Choose your accountant’s columns, understand extra rows, and save the selection for next month.

Read field note

Why doesn’t your Shopify payout match your sales? Sales of €10,000 compared with a payout of €8,742 while Leafy investigates the difference.

Bookkeeping & Reports

A Practical Guide to Shopify Bookkeeping

LedgerLeaf makes Shopify bookkeeping easier with reusable sales exports, payout reports, VAT/OSS views, and inventory records.

Read field note

Practical Shopify notes from the studio.

Shopify Traffic Protection: A Checklist

More from the studio.

Shopify Traffic Protection: A Checklist

Shopify Markets and Country Blocking: Different Roles

How to Test Country Blocking on Shopify Before Launch

What Should Visitors Blocked by Country See?

Why Has My Shopify Conversion Rate Suddenly Fallen?

Investigating a Sudden Shopify Traffic Spike

Bot Sessions, Fake Orders and Fraud: How to Tell Them Apart

How to Reduce Unwanted Regional Traffic to a Shopify Shop

How Country Blocking Interacts With Ads, Pixels, and Shopify Analytics

Does Geo-Blocking Affect Shopify SEO?

Redirecting International Visitors on Shopify

Should You Block Countries You Do Not Ship To?

Shopify Bookkeeping Spreadsheet Template: A Five-Tab Workbook

Shopify Payout Reconciliation Spreadsheet Template

How Often Should You Reconcile a Shopify Shop?

Manual vs Automated Shopify Bookkeeping

How to Build a Custom Shopify Sales Spreadsheet

CSV vs Excel for Shopify Reports

Shopify Stock Reports: Which One Should You Use?

Shopify Inventory Adjustments Explained: Set To, Adjust By, and Reasons

Shopify Stock Count Spreadsheet for Shared Stock

How to Reconcile Physical Stock With Shopify Inventory

SKU vs Barcode in Shopify: What Should You Use?

How to Create a Scalable SKU Naming Convention

What Records Should You Keep for an OSS Return?

A Practical Way to Protect Shopify from Bots and Scrapers

Quarterly OSS Checklist for Shopify Merchants

Tax-Inclusive Pricing on Shopify: What Your Reports Show

How Refunds and Discounts Affect Shopify VAT Reports

How to Review Shopify VAT by Country and Rate

EU Distance-Selling Threshold for Shopify: One €10,000 Limit

VAT OSS vs IOSS for Ecommerce: Which Scheme Fits?

Shopify Sales Tax vs VAT: What Merchants Need to Distinguish

Are Shopify Fees a Business Expense? Records to Keep

Gross Sales vs Net Sales in Shopify: What Changed?

Cash vs Accrual Accounting for Ecommerce: Which Date Counts?

Ecommerce Bookkeeping for Beginners: Start With Four Records

Can VPN or Proxy Visitors Bypass Country Blocking?

Country Blocking vs IP Blocking for Shopify

Why Blocked Visitors Can Still Appear in Shopify Analytics

Good Bots vs Bad Bots on Shopify

Can Fake Traffic Lower Your Shopify Conversion Rate?

How Shopify Bot Filtering Changes Analytics Reports

How to Prevent Overselling Bundles on Shopify

Shopify Kits vs Bundles for Inventory and Reporting

How Shopify Calculates Available Bundle Inventory

How Shared Inventory Works for Shopify Variants and SKUs

How to Sync Inventory Across Multiple Shopify Products

Shopify Cost of Goods Sold and the Errors That Distort Profit

What Shopify Month-End Inventory Snapshots Mean

How to Reconcile Multi-Currency Shopify Payouts

How to Account for Shopify Refunds, Returns, and Chargebacks

How to Prepare Shopify Sales Data for Your Accountant

Shopify Tax Reports Explained

A Chart of Accounts for Shopify Bookkeeping

Block or Redirect? Choosing a Country Rule for Shopify

Duplicate SKUs in Shopify and How to Fix Them

Why Shopify Sales and Payouts Do Not Match

Can Shopify Natively Block a Country? Options and Limitations

Shopify Order CSV Columns Explained

How to Record Shopify Payments Fees in Your Books

Shopify OSS VAT Reporting for Your Quarterly Return

Shopify Sales Reports and the Numbers That Matter

Why Is My Shopify Store Getting Traffic From Unexpected Countries?

How to Keep Shopify Bundle Inventory in Sync

Shopify SKU Guide for Clear Codes and Synced Stock

Shopify VAT Reports: What to Export and Check

How to Identify Bot Traffic in Shopify

Shopify Month-End Close Checklist for Merchants

LedgerLeaf vs Zoho Books: Is Zoho Books Overkill for a Small Shopify Store?

LedgerLeaf vs FreshBooks: Is FreshBooks Overkill for a Small Shopify Store?

LedgerLeaf vs Xero: Is Xero Overkill for a Small Shopify Store?

LedgerLeaf vs QuickBooks: Is QuickBooks Overkill for a Small Shopify Store?

How to Reconcile Shopify Payments Payouts

How to Block Countries on a Shopify Store

How to Export Shopify Orders to Excel or CSV

A Practical Guide to Shopify Bookkeeping