Shipping by product title report

[TomAttack]

I'm doing my Q1 reports.

If I'm not mistaken, on the old reports I used to be able to see:

Product sales by title and total shipping associated with that. This was really helpful.

Now I believe that option has been removed and despite lots of fiddling about I still can't find out how to get this information.

Shopify I believe removed it as one order might have 2 SKUs and share shipping. But that would have been true before reports from Shopify changed or am I missing something. 

Hoping someone here can help me!

[marcuswebexp]

Hi @TomAttack,

Try opening up a new exploration in the reports tab, and pasting this at the top:

FROM sales
  SHOW net_items_sold, gross_sales, discounts, returns, net_sales, taxes,
    total_sales, total_shipping_charges
  WHERE product_title IS NOT NULL
  GROUP BY product_title, product_vendor, product_type WITH TOTALS
  SINCE startOfDay(-30d) UNTIL today
  ORDER BY total_sales DESC
  LIMIT 1000
VISUALIZE total_sales TYPE horizontal_bar

If this doesn't work, feel free to reach out to me using the email/phone number in my signature. I'm happy to take a look to see if there's a way to get that to show for you again.

If this was useful, a Like or marking it as a Solution is appreciated.

[TomAttack]

Thank you so much for the answer! Unfortunately that didn't seem to work but one of the more manual CSV related solutions in this thread seems to be able to do what I'm after. It's a shame as it used to be in the reports and now requires more manual work by the looks of it. 

[Kudosi-Carlos]

Hello @TomAttack 

Shopify’s built-in analytics no longer split shipping against individual products, so the easiest path is to export your orders and line-items and do the allocation in a spreadsheet (or use a reporting app that does it for you).

1. Quick manual method:

• In Orders → Export, grab a CSV of all orders for Q1 (with “line items” and “shipping”).
• In Excel or Google Sheets split your “Shipping” column across the products on each order. A common approach is to allocate by each line’s price or quantity (e.g. shipping × (line_price / order_subtotal)).
• Pivot the sheet by Product Title to sum “Sales” and your newly calculated “Allocated Shipping.”

2. Automated option:
If you’d rather skip the spreadsheet work, apps like Better Reports or TrueProfit can generate a “Sales by Product + Shipping” report automatically, handling the prorated shipping math for you.

Either route gets you back to seeing “Product X sold $Y in Q1, plus $Z in shipping.”

[TomAttack]

Hi there - I 'think' this works for us. It's a bit more of a longer solution than what reports used to offer but I believe it's what I need and something I can work with in the short term. In the long term, if it's too much work, I'll look at the automated option. Thank you for the input!

[BetterReports-D]

Hi @TomAttack,

Ciara here from Better Reports, @Kudosi-Carlos recommended us in their reply, so I thought I'd jump in.

If the manual solutions already suggested on this thread don't work for you, we can support reporting the shipping paid by the customer on the order allocated across product/variant/sku/product type 👍

[Report-Pundit]

If you're still looking for a solution, at Report Pundit we can create a report that shows the total shipping price associated with each product title. We do this by splitting the order’s total shipping amount proportionally based on the product price(We can calculate based on the product quantity as well) within that order. This allows us to estimate the shipping price per product using a product price-based ratio.

Find the example data for your reference

[SupportDC]

Hi TomAttack,

if you're open to using a third-party app, DataChamp allows you to create reports with the order title, total shipping cost, and many other columns — and export them to Google Drive, Dropbox, and more. You can also choose from various templates, apply filters and set a schedule.

If you have any questions or need assistance setting up your exports, feel free to reach out!

Best regards,
Melanie