Find the orders that lost money in your export

The orders that cost you more than they brought in, after fees, shipping and product cost, grouped by what caused the loss.

  • No connector needed

I've attached my eBay orders for last month and a list of my product costs. Count the marketplace's fees as 13% of each sale and include what I paid for shipping. Which orders lost money, and why?

Needs

An orders export and your product costs

Before sending
Download the orders as a CSV file from your store's admin and attach it with your costs: a spreadsheet, or a list pasted in (product, cost). If the export has no shipping costs, add them to the list.

What you get back

Example answerSample data, to show what comes back

I've attached my eBay orders for last month and a list of my product costs. Count the marketplace's fees as 13% of each sale and include what I paid for shipping. Which orders lost money, and why? orders_october.csv · costs.xlsx

4 orders lost money last month

Three of the four are heavy cast iron sent with free shipping. Together they lost $30.77.

Orders checked
186
Lost money
4
Total loss
$30.77
OrderProductProfitWhy
#2063Enamel Dutch oven−$16.2415% discount on top of free shipping
#2057Enamel Dutch oven−$8.41Shipping takes 41% of the price
#2041Cast iron skillet, 12 in−$5.36Free shipping on a heavy pan
#2078Bamboo cutting board set−$0.76Price too close to cost and shipping

Charge shipping on the Dutch oven, or add it to the price: it is behind two of the four.

What the assistant does

  1. 1

    Matches every order to the cost of its product.

  2. 2

    Subtracts fees, shipping and cost from what the buyer paid.

  3. 3

    Keeps the orders that end below zero.

  4. 4

    Groups them by cause: free shipping, a discount, or a price too close to cost.

With SellerClaw connected

Skip the copy and paste

Claude reads the fees each marketplace actually charged on every order and matches each item to its cost, so there is no file to prepare.

More prompts

All prompts
Listings
  • No connector needed

Write a listing from a product photo

Here's a photo of a product I want to sell on eBay. Tell me what it is, then write the title, the item specifics and a description. Ask me about anything the photo can't show, like size or flaws.

A photo of the product

First five minutes
  • No connector needed

Turn an orders export into a sales review

I've attached my Shopify orders export for the last 90 days. Which products bring in most of the money, which are slowing down, and what should I stop restocking? Give me a short table and three things to do this month.

An orders export from your store (CSV)

Listings
  • No connector needed

Find what stops buyers on your listing

Read my Amazon listing below as a shopper comparing it with two others. What would make you buy somewhere else? Then rewrite the title and the first lines a buyer reads to fix it.

Your listing, pasted in or as a screenshot