|
|
|
|
| |
| |
|
|
|
TOOL OF THE WEEK
|
|
|
|
Re-import your Shopify CSV without losing a thing
|
|
Read the guide →
|
|
|
|
Hey Fastlane Insiders! 👋
|
|
For the next few weeks, your Shopify dashboard is going to be the most-watched screen in your business. Orders roll in, the number keeps climbing, and for a few days it feels like the best month you’ve ever had.
|
|
Then the deposits land.
|
|
Back when I was at Shopify, some of the hardest conversations I had with founders weren’t about a slow month. They were about a great one that didn’t show up in the bank the way they expected. Fees, refunds, and Amazon holds all tangled together, and nobody could quite explain where the rest went. At seven figures across two or three channels, that’s not a rounding error. It’s the difference between knowing your margin and hoping for it.
|
|
That’s why I asked Stefan Dobrev of Link My Books to walk us through exactly where the money goes between the sale and the bank. It’s not the flashiest conversation I’ll have this month, but it might be the one you’re most grateful for in January. (He also brought you an extended 30-day free trial and a free onboarding call, if you want to kick the tires.)
|
|
Give this one ten minutes before the rush hits. Future you, the one doing the books in January, will be glad you did. ;)
🎧 This Week's Podcasts: Why $100K in Amazon sales can still leave you owing Amazon money, with Stefan Dobrev of Link My Books, and the good orders your fraud tool declines before BFCM, with Trevor Miller of ClearSale
💡 Knowledge Drops: Why AI knows your brand but won't recommend it, and what Shopify gives you free before you buy a personalization app
🔥 Tool of the Week: Toriut, the Shopify CSV rules that quietly delete data
📡 Industry Pulse: TikTok Shop Plus, Google's new review filter, Shopify's pay-per-sale ads, and why ad clicks convert worse
|
|
Let's dive in. 👇
|
|
|
|
|
|
| |
|
| |
| |
|
|
$5,800 in Sales. $4,200 in the Bank.
|
|
Here's a quick test. Pull your last three Shopify payouts and write down four numbers for each: gross sales, fees, refunds, and what actually hit the bank. If that takes longer than ten minutes, your books are probably guessing.
|
|
Link My Books turns every payout from Shopify, Amazon, eBay, Etsy, Walmart, TikTok Shop, and more into one clean, bank-matched entry in Xero or QuickBooks. Sales, refunds, fees, shipping and tax each land where they belong, so $5,800 in sales gets booked as $5,800 in sales, not as the $4,200 that landed in your account.
|
|
It earns its keep fastest if you sell on more than one channel or handle UK or EU VAT, where one small mapping slip can quietly cost thousands. Sellers and accountants rate it 5 out of 5 on both the Xero and QuickBooks app stores.
|
|
|
|
|
|
|
|
| |
|
| |
| |
🎧 New Podcast Episodes 🎧
|
|
|
$100K in Amazon Sales and Still Owing Amazon Money
|
|
You sold the product. The order shows up in Shopify. Then the payout lands a few days later, smaller than you expected, and nobody on the team can explain the difference. With Black Friday 15 days out, that gap is about to get a lot wider.
|
|
This week, I sat down with Stefan Dobrev, Sales and Onboarding Lead at Link My Books, the ecommerce accounting platform Visma acquired in January 2025. Stefan has spent close to nine years in finance tech, from Receipt Bank and Dext to QuickBooks, and he spends his days helping multichannel sellers figure out where their money actually went.
|
|
Here's what we unpacked:
|
-
Sales and payouts are two different reports. Orders are recorded when they're placed, but payouts arrive two to five business days later, batched by capture date, with fees, refunds, chargebacks and reserves already taken out.
-
Amazon holds your money longer than you think. Funds sit until seven days after delivery, and Stefan explains why those deferred transactions are one of the biggest headaches in ecommerce accounting.
-
The seller who owed Amazon money. One client brought in $50K to $100K every two weeks and still owed Amazon $2,500 to $4,000 per payout. Stefan shares where the leak was hiding.
-
One small tax mapping error, compounded. A seller overpaid roughly 40,000 to 50,000 in VAT by mapping Amazon fees to the wrong Amazon entity, and the mistake grew with every single order.
-
Refunds are product intelligence. Break refunds out by channel and product, and a faulty SKU shows up before it eats your margin and your reviews.
-
Why accounting AI can't be 95% right. Stefan on where AI fits in the books and where it absolutely can't guess.
|
|
If you're doing 1,000+ orders a month across more than one channel, this is the episode to hear before your biggest payout weeks of the year arrive. And Stefan brought something for Fastlane listeners: an extended 30-day free trial of Link My Books (normally 14 days) plus a free onboarding call. You'll find it on the episode page.
|
|
|
|
|
|
|
Your Fraud Tool Might Be Declining More Good Orders Than Bad Ones
|
|
Every fraud tool shows you the chargebacks it stopped. Almost none of them show you the good customers they turned away. With order volume about to spike, that second number is the one quietly costing you money.
|
|
If you missed this one last month, it's worth a replay before Black Friday. I sat down with Trevor Miller, Senior Account Executive at ClearSale, the fraud-prevention company now part of Experian. ClearSale has been at this for more than 20 years, pairing machine learning with a human reviewer for the orders that sit in the gray zone.
|
|
Here's what we unpacked:
|
-
One point of approvals is real money. At $20M in sales, one extra percentage point of legitimate approvals can mean up to $200,000 in order value.
-
A high-risk flag is a question, not a verdict. Trevor explains why auto-canceling every flagged order optimizes around fear instead of accuracy.
-
Shopify Protect covers less than most merchants assume. If you're in Canada, anywhere outside the US, or on a third-party gateway, listen to this part twice.
-
The brand that left, then came back. Tactical Sports Gear switched to Shopify's native tools, started selling $1,000+ items, and learned an expensive lesson. Trevor shares where they landed.
-
Don't stack fraud tools. What happens when two systems give the same order opposite verdicts.
|
|
|
|
|
|
|
|
| |
|
| |
| |
💡 Knowledge Drops of the Week 💡
|
|
|
AI Knows Your Brand. It Just Won't Recommend It.
|
|
StoreHero pulled 12,496 AI answers across 135 brands in late October. Every brand was recognized when someone asked about it by name. But on unbranded buying questions, the kind a new customer actually types, the median brand showed up in just 15% of answers.
|
|
As of this week, you can finally see some of this for yourself. On November 10, OpenAI opened Business Hub, a free way to claim your business in ChatGPT and see 28 days of mentions and website clicks. Shopify merchants can verify straight from the admin. OpenAI is clear that claiming won't move you up in recommendations, which is exactly why the unbranded part is the one worth testing.
|
|
Here's what's working:
|
-
Ask the questions a stranger would type. Ten unbranded buying questions, no brand or product names, run in a private window in ChatGPT, Perplexity, and Google. The article shows how to word them and what to log.
-
Run your most important questions three times. Answers shift from run to run, so one screenshot is a moment, not a result.
-
Fix what the AI can actually read. Product titles that say what the product is, plus the outside sites that keep getting cited in your category. In StoreHero's data, shops and marketplaces made up 45% of cited sources, and brands' own sites just 5%.
|
|
Under $500K, run the check once, fix your titles, claim your Business Hub profile, and stop there. Between $500K and $2M, rerun the same questions every month and watch which sources get cited. You likely don't need a paid tracker until you're past $2M. One honest caveat: StoreHero sells an AI visibility tracker, and this is one week of data, so treat the category gaps as directional.
|
|
|
|
|
|
|
Before You Buy a Personalization App, Open the One You Already Have
|
|
Most Shopify stores already own a personalization setup and have never really opened it. Shopify's free Search & Discovery app handles product recommendations, semantic search, and search boosts that pin up to 10 products to any search term. Shopify says the Fall '26 Edition search updates lifted add-to-carts from search by 8%.
|
|
The catch is that native tools are only as good as your product data. Two weeks out from Black Friday is no time to bolt a new app onto your storefront, but it's a great time to spend an afternoon finding out what your current setup is getting wrong.
|
|
Here's what's working:
|
-
Read the three reports you already have. Searches with no results, searches with no clicks, and recommendations with low engagement, all sitting in Search & Discovery for the last 30 days. The article shows what to fix first in each.
-
Hand-pick for your top 20 best sellers. Up to 10 complementary and 10 related products per item, before you decide the algorithm failed you.
-
Do the math before the demo. I ran an illustrative model: a $60K a month store where search drives 20% of sales gets about $1,200 a month from a 10% lift. A $39 plan clears that easily. A $500 plan barely does, and only if a real test confirms the lift.
|
|
Under $10K a month, put the time into navigation and product pages instead. Between $10K and $100K, set up the native tools first and buy only for a gap that survives your data fixes. Past $100K a month, one tool per measured gap, never two that overlap. And catalog size can beat revenue: a store with thousands of SKUs may need better search before a bigger store with 40 products.
|
|
|
|
|
|
|
|
| |
|
| |
| |
🔥 Tool of the Week 🔥
|
|
|
Before you re-import that Shopify CSV, know these rules
|
|
Shopify's CSV import has rules that quietly delete data when you overwrite. Three worth knowing:
|
-
A column that's in your file but empty replaces the existing value with a blank. Leave untouched columns out entirely.
-
Updating a variant column such as SKU without Option1 name and Option1 value creates a new default variant and deletes the existing ones.
-
Stores with more than one location need a separate inventory file for stock.
|
|
We wrote up the full breakdown, with a pre-import checklist and what to do if an import already broke your store.
|
|
P.S.: We're Toriut, a Shopify PIM, and this is the kind of mess we help prevent.
|
|
|
|
|
|
|
|
| |
|
| |
| |
⚡ This Week's Industry Pulse ⚡
|
|
Every week, I come across strategies and insights that are just too good not to share. Here's what caught my attention this week.
|
|
Your paid clicks might not be the problem. Before you raise budgets for Black Friday, grab your phone and open the landing pages for your top five ads by spend. Does the first screen repeat the ad's hook, product, and offer, with one clear next step? This ClickMint guide walks through four first-screen fixes, and why revenue per paid session beats conversion rate as the number to judge them by.
|
|
TikTok Shop now has its own Prime. TikTok Shop Plus costs $9.99 a month after a 30-day free trial and went out last weekend to more than 1 million of its most loyal US shoppers: free shipping on Plus-badged items, an extra 10% off select products, three coupons a month, and store-credit refunds before the return is even dropped off. Shoppers are being trained to expect member perks everywhere, so if you run a loyalty program, make what it offers impossible to miss on your site before Black Friday.
|
|
Google added a "Non-incentivized only" filter to product reviews across Search, Shopping and AI Mode. Most shoppers will never touch it, but the careful ones can now hide every review you rewarded with points, discounts, or free product. Google has required merchants to tag incentivized reviews for about a year, so ask your review app how it adds that tag to your Merchant Center feed, then check your best sellers with the filter on.
|
|
Shopify wants to run your ads and only get paid when they sell. Campaign Autopilot now runs pay-per-sale campaigns across Meta, Microsoft Advertising, Snapchat, email, and the Shop app, with X on the way and SEO recently added. You set the most you'll pay per sale and can cap spend or switch off a channel. The performance claims are Shopify's own, so test a few products against your current campaigns, not your Black Friday hero offer.
|
|
|
|
|
|
| |
|
| |
| |
Ten Minutes Before the Rush
|
|
In two weeks, most of you will be living inside your dashboards, watching orders roll in. It's the most exciting stretch of the year, and also the easiest time to trust the number on the screen without asking where it came from.
|
|
So here's my one ask before then. Pull your last three payouts and see if you can explain every dollar between the sale and the deposit. It takes about ten minutes, and you'll walk into Black Friday knowing your real margin instead of hoping for it.
|
|
Then hit reply and tell me how close you got. Did everything line up, or did something show up you couldn't explain? I'd genuinely love to hear what you find.
|
|
Know your numbers before BFCM weekend tests them.
|
|
Until next Thursday,
Steve
|
|
Side note: Stefan's episode is the perfect listen while you pull those payouts. He'll show you where the missing money usually hides.
|
|
|
|
|
|
|
|
| |
|
|
