Skip to content

Which SKUs lost margin last month, and in which channel?

Join Shopify, Amazon and NetSuite in one project. Find the SKUs whose margin after channel fees fell against their own six months, and see whether price, cost, fees or returns moved.

Open Querri

What you'll need

Querri (Free trial) to join the three systems and rank every SKU

Shopify, Amazon Seller Central and NetSuite: Step 1 says what each adds

Your margin rules: so every channel is measured the same way

Free resources

Start your free trial here →

Sample data sets

Synthetic data for Curio Supply, a made-up home goods brand. Not real customer, retailer or marketplace data.

Need help?

If you have any questions, you can request a demo or email our team.

Before we begin

The monthly package shows gross margin by channel, and most months it barely moves. A SKU can lose six points on Amazon while the channel line holds, because the fee that changed sits below gross margin. Sales, fees and cost live in three systems, so following one SKU across them is a spreadsheet job the close rarely has time for.

This playbook compares every SKU's margin in every channel with its own prior six months, and takes apart the ones that fell.

How it works:

  • • Connect Shopify, Amazon Seller Central and NetSuite
  • • Build net revenue and gross margin by channel
  • • Rank SKUs by margin change in each channel
  • • See what moved: price, cost, fees or returns
  • • Build the monthly margin view for leadership

Follow the steps

Open Querri →
1 Step 1:

Connect Shopify, Amazon Seller Central and NetSuite

Three sources, one project:

  • •

    Shopify: store order lines, discounts and refunds.

  • •

    Amazon Seller Central: sales, referral and FBA fees, and refunds.

  • •

    NetSuite: wholesale invoices, trade credit memos and landed cost by month.

All three connect directly and sync on a schedule. Querri matches Amazon seller SKUs to NetSuite items through the SKU map in the item cost table.

Tip: Pull six months before the month you're closing, so every SKU is compared with its own history.

  • Shopify sales
  • Amazon transactions
  • NetSuite sales and item cost
Querri One project
2 Step 2:

Build net revenue and gross margin by channel

Start with the channel lines leadership already sees:

Prompt

"Build net revenue and gross margin by channel for October 2026, against each channel's own April to September."

Gross margin across all channels was 59.8%, against 60.5% for April to September. Amazon's held at 67.6%, yet after channel fees Amazon fell to 43.3% from 45.0%.

Build net revenue and gross margin by channel
ChannelOctoberApril to September
Store65.7%65.2%
Amazon67.6%67.7%
Retail36.2%35.6%
Distributor32.0%32.2%
All channels59.8%60.5%

Gross margin rate by channel, October 2026 against April to September 2026.

3 Step 3:

Rank SKUs by margin change in each channel

Now compare every SKU with its own history, channel by channel:

Prompt

"For every SKU and channel with $10,000 or more of October net revenue, compare margin after channel fees with its own prior six months. Flag drops of 4 points or more."

4 of 89 SKU and channel pairs fell 4 points or more after channel fees. Three are on Amazon.

Rank SKUs by margin change in each channel
SKU and channelOctober (prior)Change
Curio Linen Duvet Set, Queen (Amazon)41.0% (47.1%)-6.2 points
Marlow Comforter, Queen (Amazon)37.1% (45.3%)-8.2 points
Harlow Stoneware Mug Set (Amazon)34.2% (38.9%)-4.6 points
Fenwick Linen Duvet Cover, Queen (Retail)30.3% (37.1%)-6.8 points

Flagged pairs: margin after channel fees, October 2026 (April to September 2026).

4 Step 4:

See what moved: price, cost, fees or returns

For each flagged SKU, take the margin apart per unit:

Prompt

"For each flagged SKU, show price, product cost, referral fee, FBA fee and refunds per unit, October against the prior six months. When did anything change?"

Price and landed cost held. The FBA fee per unit stepped up on 2026-09-15, and at October's volume the change cost $17,955.

See what moved: price, cost, fees or returns
SKUFBA fee per unitOctober cost
Curio Linen Duvet Set, Queen$11.50 to $25.50$10,794
Marlow Comforter, Queen$11.37 to $27.40$5,386
Harlow Stoneware Mug Set$8.84 to $12.05$1,775
Total$17,955

FBA fee per Amazon-fulfilled unit, August against October 2026, and the October cost of the change.

5 Step 5:

Build the monthly margin view for leadership

Four numbers for the package, and what moved.

The narrative Querri writes:

Gross margin by channel barely moved in October, but three Amazon SKUs lost margin to a higher FBA fee and one retail SKU to a lower invoice price.

What you can create or export:

Build the monthly margin view for leadership
SKU and channelWhat movedNext step
Curio Linen Duvet Set, Queen (Amazon)FBA feeReview the fee
Marlow Comforter, Queen (Amazon)FBA feeReview the fee
Harlow Stoneware Mug Set (Amazon)FBA feeReview the fee
Fenwick Linen Duvet Cover, Queen (Retail)Invoice priceCheck the promo terms

Flagged SKU and channel pairs, October 2026.

Bring three SKUs and what moved them to the meeting.

Try it on your own data
Querri for ecommerce finance See how Querri helps finance teams at multichannel brands close on one set of numbers across Shopify, Amazon, retail and the books. See Querri for finance

See Querri for the whole brand

Tips for a margin package people trust

Compare each SKU with itself

A SKU's own six months is a fairer test than the channel average. A big seller can't hide a small one's drop, and seasonal items stay comparable.

Read margin after fees, not only gross margin

Marketplace fees sit below gross margin. A fee change can take points off a SKU while gross margin and the channel line stay flat.

Teach Querri your rules once. Every answer after that follows them.

What counts as a channel fee, how trade credit memos are spread, which SKUs are big enough to flag: say each rule once and Querri applies it to every question on that data.

Show me how

Say it in chat

Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.

Prompt

"Margin after channel fees for Amazon is net revenue less landed cost, referral fees and FBA fees. Save that as a rule for the Amazon transactions table."

Or bring the document that already says it

Upload your margin reporting policy or close checklist like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:

  • Channels: Store, Amazon, Retail and Distributor, split by NetSuite class
  • Amazon net revenue: product sales plus promotional rebates
  • Channel fees: referral and FBA fees, less any refunded
  • Trade: credit memos with no quantity, spread by net revenue
  • Checked: $10,000 or more of the month's net revenue in a channel
  • Flagged: 4 points or more below its own prior six months
Prompt

"Read our margin reporting policy and propose the rules it states about channel fees and trade spend. I'll review them in the Inbox."

Where the rules reach

A rule is attached to the data, not to one person's chat, so it follows the data everywhere:

  • • Every question asked in chat, by anyone on the finance team
  • • Every view the Librarian builds on that data
  • • Every step of a project, including the code it writes
  • • Dashboards and scheduled runs, each time they refresh
  • • Claude and ChatGPT, when they ask Querri

You stay in control

Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.

The payoff at month end

The package shows the channel lines and the few SKUs that moved under them, with what changed. Moving the flag threshold is a sentence.

Frequently asked questions

What is margin after channel fees?
Net revenue less landed cost and the fees the channel charges: Amazon's referral and FBA fees here. Gross margin stops before the fees, which is why Amazon's held at 67.6% while three of its SKUs fell.
Why compare with the prior six months?
Each SKU and channel pair is measured against its own April to September, pooled as total dollars over total net revenue. A seasonal item isn't judged against the channel average.
Which SKUs are checked?
A SKU and channel pair needs $10,000 or more of the month's net revenue. In October 89 pairs qualified. A pair is flagged when margin after fees is 4 points or more below its own six months.
What happened to the retail SKU?
The Fenwick Linen Duvet Cover, Queen, fell 6.8 points at retail. Brindlemark Home's invoice price went from $76.45 to $61.16 a unit in October. The page reports the price change, not that it explains the whole drop.
How are Amazon SKUs matched to NetSuite items?
Through the SKU map in the item cost table: each item lists its Amazon FBA and merchant-fulfilled SKUs. Three old Amazon SKUs match nothing; they are 0.18% of Amazon product sales and are listed, not dropped silently.
How is trade spend handled?
Retail and distributor credit memos with no quantity are trade: promotions, co-op and slotting. Querri pools them by class and month and spreads them across that class's items by net revenue, Curio's rule.
Does Querri change anything in NetSuite?
No. It reads a copy of the data and never writes back to your ledger.
How often should this run?
Monthly, once the month's Amazon transactions and NetSuite invoices are in. A fee change shows up in the first full month it applies.