Querri for eCommerce brands
Shopify, Amazon, your retailers and your ERP each report their own slice of the business, and none of them agree on margin. Querri joins every channel with your ad spend and your ERP or books, learns what you mean by net sales and contribution, and checks every number before you see it.
Querri only reads data from the systems you connect and never changes an order, a listing or a record. SOC 2 Type II, HIPAA and ISO 27001:2022 certified, and your data is never used to train a model.
Connect the whole business
A multichannel brand runs on a dozen systems. Querri copies each one into a single Library on a schedule you choose, so a question about margin can read the store, the marketplace, the ad platforms and the ledger at once. Pick from the catalog or ask the Connector Agent, and browse every connector.
Sell-through and on-hand reports, retailer POs, EDI and portal exports, chargeback and deduction statements: most of it arrives as spreadsheets in a different layout from each account. Upload Excel or CSV files, or point Querri at a Google Drive folder. Data cleansing finds buried header rows and sideways tables, and next week's file gets the same treatment.
Why multichannel reporting breaks
Selling through your own store, Amazon, distributors and retail is how brands grow. It also splits the truth across systems that were never meant to agree, and the work of putting it back together lands on whoever owns the spreadsheet.
The store knows its orders, Amazon knows its fees, the ad platforms know their spend and the ERP knows cost. Each has its own dashboard and its own assistant, and none can answer a question that needs two of them.
The store shows one revenue figure, the books another, and the ad platforms together claim more sales than either. Someone checks the numbers by hand before every board meeting, and the meeting still opens with whose number is right.
Margin after marketplace fees, shipping, returns and ad spend gets rebuilt by hand each month from a stack of exports. It takes days, one person knows how the formulas work, and the number is a month old by the time anyone reads it.
Distributor and retailer reports come in their own layouts, with headers halfway down the sheet, units in cases on one and eaches on the next, and product codes that don't match yours. Sell-through by account means cleaning every file first.
Tools that can join channels expect someone who writes queries or models data, and fixed reports only let you filter what someone else built. Many also price on revenue or order volume, so the bill climbs every time the business grows.
Questions by role
Everyone at a growing brand has a question that crosses systems. These are the ones that come up most, in the words people use.
What you can finally answer
Each one needs more than one system, and today each one costs an afternoon of exports. Here is why it's hard and how Querri answers it.
Why it's hard
The selling price is in Shopify, marketplace fees in Amazon's reports, unit cost in NetSuite or QuickBooks and ad spend in two ad platforms. The answer only exists once a month, in a spreadsheet.
With Querri
Querri joins orders, fees, unit cost and spend by SKU and channel and applies your margin ladder, saved once in Facts & rules. Keep CM1, CM2 and CM3 as KPIs so chat, dashboards and reports quote the same number.
Why it's hard
Amazon pays in settlements that net sales against fees, refunds and adjustments, so a deposit never lines up with the orders behind it. Amazon profit stays an estimate.
With Querri
Connect Amazon and its orders, fees, refunds and settlements sit beside your other channels. Ask Querri to tie each settlement to the orders and refunds it covers, and it lists the lines that don't match instead of forcing a total.
Why it's hard
Each ad platform reports its own return on spend, and added together they claim more sales than the store recorded. Nobody sees total spend against total contribution.
With Querri
Querri puts Meta Ads and Google Ads spend, as the platforms report it, beside revenue and contribution from every channel, and tracks MER and blended CAC week by week. It reports spend and results side by side; it doesn't attribute sales to ads.
Why it's hard
Stock sits in Shopify locations, the ERP, a 3PL's export and Amazon's warehouses, each counted its own way. A stockout shows up in the monthly review after it has cost sales.
Why it's hard
Every retailer and distributor sends a weekly report in its own layout, some in cases and some in eaches, with their item codes instead of yours. Comparing accounts means cleaning each file first.
With Querri
Drop the reports in or connect a Google Drive folder. Data cleansing straightens each layout, a rule converts cases to units, and sell-through by account and SKU is one question away.
Why it's hard
Shopify Payments deposits a payout net of fees, refunds and adjustments, days after the orders. The bookkeeper sees one deposit; the store sees hundreds of orders.
With Querri
Querri lines up Shopify payouts and their fees with deposits in QuickBooks or NetSuite and shows the gap payout by payout, down to the orders and refunds inside each one. The Shopify + QuickBooks page walks through it.
Why it's hard
Repeat rate by first product needs every customer's order history grouped by first-order month, and the store's built-in reports stop at the cohorts they were built to show.
Why it's hard
Discount codes live in Shopify, retailer promo allowances and deductions in the ERP, and shipping cost in the shipping tool. Each team defends its own channel with its own number.
With Querri
Querri compares DTC orders net of discounts and ShipStation shipping cost with wholesale invoices net of deductions, on one definition of margin. The Shopify + NetSuite page goes deeper.
One product, every channel
The same mug is a SKU in your store, an ASIN on Amazon, a UPC on a retailer's report and an item in NetSuite. Upload your mapping file or tell Querri how they line up, and it's saved as a Fact & rule. From then on, margin by SKU and sell-through by product count every channel, and you can ask which SKUs still have no match.
Combinations brands ask about
See it in the product
These are real Querri screens from Curio Supply, our demo brand, which sells online, on marketplaces and in its own stores. The data is made up; the product isn't.
Answers you can stand behind
Merchandising means price minus product cost. Finance means what's left after Amazon's fees, fulfillment and the ads that drove the sale. Both are fair readings, and on a marketplace the gap between them is wide. Querri answers with the definition you saved, names it, and puts the other beside it. See how answers work.
Wake up to what moved
Ask Querri to keep an eye on sell-through, stock cover or margin by channel, retailer or SKU. Each time the data refreshes, a monitor checks every slice against its own history, using arithmetic, and each night Querri looks for what nobody has asked yet. What moved waits in your Inbox in the morning, and nothing changes without your OK.
For brands that make what they sell
If you make your own product, the same Library answers production questions that live in ERP exports and Excel today. Querri reads work orders, BOMs, batch costs, yield and scrap as they're recorded in your ERP or production exports, and joins them to channel sales. More on the manufacturing page.
Put the cost each batch actually came in at, from your ERP records, against what each channel sold it for, instead of a standard cost set last year.
Compare what a run used against the recipe or bill of materials, by product line and month, and see which inputs drive the gap.
Forecast demand by SKU from sales across every channel and set it beside what you plan to make, with a range, so short runs show up early.
Track yield and scrap from production records and exports, and let a monitor flag a line drifting from its usual rate.
Dashboards and reports
Build a dashboard by asking for it, then change it the same way. Every chart reads from the Library, so the founder, the controller and the channel leads see the same contribution margin, each with only the rows their access allows.
Reports that run themselves
Net sales, fees, ad spend and contribution for the store, Amazon and wholesale, emailed every Monday.
Reports & automationEvery SKU by channel, with CM1, CM2 and CM3 on the definitions you saved.
KPIsWeeks of cover per SKU and location, with the SKUs to reorder first.
NetSuiteOne workbook per retailer or distributor, built from their own reports and sent to each account manager.
Excel toolsEach settlement tied to its orders, fees and refunds, with the lines that don't reconcile listed.
AmazonPayouts, fees, refunds and deposits by channel, as a formatted Excel workbook with working formulas.
Shopify + QuickBooksFor agencies and fractional CFOs
Agencies, fractional CFOs and retail-analytics firms that report for many brands can run Querri as their own. White label puts your domain, logo and colors on it, each client brand gets its own workspace and data, and one report built once goes to every client as its own copy. Put dashboards inside your own portal with embedded analytics.
eCommerce FAQ
Ecommerce analytics software brings sales, marketing, inventory and finance data together so a brand can see what it sold, what it cost and what it kept. Querri does that across every channel: your store, Amazon, wholesale and retail reports, ad spend and your ERP or books, answered in plain language.
Shopify's reports and assistant are good at questions about your Shopify store. Querri answers the questions that need more than one system, such as margin after Amazon fees, ad spend and product cost from NetSuite, and checks each number against the data before you see it. Keep using Shopify's reports for store-only questions.
Shopify, Amazon Seller Central, Meta Ads, Google Ads, Google Analytics, NetSuite, QuickBooks Online, ShipStation, Square, Stripe, WooCommerce and more, out of 125+ connectors, plus Excel and CSV files and Google Drive for retailer and distributor reports. See all connectors.
Yes. The Amazon connector reads orders, order items, fees, settlements, refunds and returns, and inventory from Seller Central, refreshed in full on a schedule. Querri joins them with your other channels, so Amazon margin after fees sits beside your store and wholesale.
No. Querri reads campaigns, ad sets, ads and daily spend and results as Meta Ads and Google Ads report them, and puts them beside revenue and margin from every channel. That gives you MER, blended CAC and spend against contribution. It doesn't track pixels or attribute individual sales to ads.
Upload the Excel or CSV files, or connect the Google Drive folder they land in, and replace them as each new week arrives. Querri's data cleansing finds buried headers and sideways tables, a rule you state once converts cases to units, and sell-through by account and SKU joins your other channels.
Yes. Querri connects to NetSuite and QuickBooks Online and reads invoices, payments, items and the ledger beside your store and marketplace data. That's how wholesale revenue, item cost and deposits reach the same answer as your online orders.
Connect your channels, ad platforms and ERP or books, then tell Querri your margin ladder once: for example, CM1 after product cost, CM2 after fees and shipping, CM3 after ad spend. It saves the definition, applies it to every channel and SKU, and shows which costs it subtracted.
Yes, from wherever you keep them: unit cost on Shopify inventory items, item cost in NetSuite or QuickBooks, or a landed-cost spreadsheet with freight and duty you upload. Tell Querri which source is right for which SKUs and it uses that in every margin answer.
Yes. Querri reads stock levels by location from Shopify and your ERP, inventory from Amazon, and your 3PL's on-hand exports, then works out weeks of cover per SKU from recent sales. A monitor flags a SKU whose cover falls well below its usual level.
No. Querri only reads data from the systems you connect. It never creates, edits or deletes an order, a listing, a product, an invoice or any other record, and it doesn't reprice or reorder. Questions run on the copy inside Querri, so your systems stay exactly as they were.
Most systems connect in one sitting: ask the Connector Agent or pick from the catalog, sign in on the vendor's own page (NetSuite takes token credentials from your admin instead), and approve the first load. You don't need a data team, a warehouse or anyone who writes SQL to start asking questions.
Querri is priced on usage, in monthly credits for the work it does, such as answering a question. It isn't priced on your revenue or order count, dashboard viewers are unlimited on every plan, and you're alerted before you reach your limit. See pricing.
Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified, and your data is never used to train a model. Inside Querri, sharing and row-level access decide who sees which rows, in chat, dashboards and the API. Details are on the security page.
Yes. Connect Claude or ChatGPT to Querri once and they answer from your Library, using the margin definitions and SKU mappings your team saved. Each person only gets the rows their Querri access allows.
Yes. Give each client brand its own workspace with its own data and dashboards, run Querri under your own brand with white label, and send every client its own monthly report from one report you built once. Each client sees only its own rows.
Yes. Connect each Shopify store as its own connection and Querri joins them in one Library. Orders keep the store currency and the currency the shopper paid in, an answer that adds up different currencies says so, and you can ask for one currency when you need a single total.
Keep exploring
Connect your store, Amazon, your ad platforms and your ERP or books in one conversation. Querri only reads your data; every order, listing and record stays as it was.
