Hi Community!
Does anyone have a workaround for getting a report on custom sales from Shopify POS? I used to be able to do something through reports but can’t seem to get it to work anymore. Maybe through the changes that have happened with reporting it no longer works. I have reached out to Shopify and they are unable to help me get a report on custom sales. Seems ridiculous that I can add a custom sale but cannot get any reporting on them! I also reached out to a reporting app that they had recommended, but they are also unable to report on this. I’m not looking for any paid apps at this point. Hoping someone has figured something out that I can use. We are on POS Pro so cannot use the custom reports feature. Thanks!
5 Likes
You won;'t be able to do this without workarounds or an app. Lots of reporting apps that can do it - some are free fro certain Shopify levels.
I also need help with this. I’d really like to not download an app but if there is a free one that works I’ll take it at this point. Im so confused why this feature was taken away. It is an integral part of the day to day shop part of owning a business.
2 Likes
I used to be able to type in and search for them but cannot anymore…what gives Shopify?
3 Likes
This was an available feature before the reporting update. You could simply sort your products by vendor then click on N/A and view the products sold. Currently, I can see that I have 47 products with the vendor listed as “None.” Most of these products are from consignment vendors with products sold off the floor before they could get on the website. If I can no longer view these products, I am not able to pay them for Q4. Shopify, please, please, please either make the old version of the Sales by Product or Sales by Vendor report available or update the report to be able to view the names of the products and their sales price.
2 Likes
Same. So so very lame…and not the first time.
Sometimes I think of Shopify has really lost touch (if they ever had it). Creating a great platform, charging you for it, then taking away useability so you have to buy an app…that they surely must get a cut from. and no way to call them.
just feels smarmy…and greedy
Thanks for your reply! I recently noticed (in the last few weeks) that I was able to modify reports and create new ones. I’m not sure where that came from or if everyone has that same capability. I was able to use one of Shopify’s existing sales reports and modify it with criteria that would pull custom sales. For our store, selecting “product type” as “null” worked. I hope you are able to use that also!
1 Like
I was recently able to use the Shopify report “total sales by order” and modify it to capture custom sales - see my other reply also on this thread.
Hi, Twoplusone. Were you able to see the actual names of the products entered as custom sales? I can see the total sales of custom items, but I cannot see the item names like I was able to before.
Yes! First I ran a different report and only got the total dollar amount of custom sales for the selected time period.
Go to the report under “Finances” called “Total sales by order”. This will give you more detailed data at the individual order level. Modify the report by selecting the filter option in the top right. You’ll need to filter based on something that makes the custom sales unique for your store. In our case, all our products have a product type but custom sales do not. You can probably use vendor as your filter also. In either case you can select the filter as “None”. Once you get it working you can save it to run whenever needed. I hope that makes sense. Sometimes hard to describe!
1 Like
Yes!!! Thank you soooo much!!! That is exactly what I needed!!!
1 Like
super helpful, thanks. not as good as before, but happy to be able to find it again.
huzzah!
1 Like
Latest solution to this issue as of April 2025:
Go to Analytics, Reports, and then select the “New exploration” button.
In the ShopifyQL section remove the existing “FROM” on Line 1 and paste the following:
FROM sales
SHOW gross_sales, discounts, returns, net_sales, shipping_charges, return_fees, taxes, total_sales
WHERE product_vendor IS NULL AND product_title_at_time_of_sale IS NOT NULL
GROUP BY day, sale_id, order_name, product_title_at_time_of_sale
TIMESERIES day
WITH TOTALS
SINCE startOfDay(-90d)
UNTIL endOfDay(-1d)
ORDER BY day DESC, order_name ASC, sale_id ASC
LIMIT 1000
VISUALIZE total_sales TYPE table
From there, use the “Run” button in the upper right - you should see a list of recent orders where the order items were entered by had via the “Custom sale” option on POS.
Now use the “Save” button at the very top of the screen to save the report with a familiar name - “Quick Sales”, “Custom Sales”, etc
All done, easy to pull up report on mobile or desktop.