We recently did a bulk update to ensure all of our products had a 'product type' attribute assigned.
We are looking at we export online sales data from Shopify to bulk import it into our physical POS system.
However, the product report (Analytics > Reports > Sales By Product) still has N/A in the product type column for products that do now have a type assigned.
Do Shopify reports not retroactively add attributes to past sales?
Thanks for your help!
We came across the same issue today. We updated the product type field for a number of products.
However, the "Sales by product" report still shows the old product type value.
The order itself (when you go to any order and append .json to the URL, you will see it) has its own product type value, which is not updated when the actual product type in the product changes.
We think that this is the cause of the issue.
It is really confusing for merchants and is hopefully a known bug.
Keanna here from the Better Reports support team.
I believe our app Better Reports can help! In our reports, the 'product type' always shows the current product type associated with the product. Not the product type at the time of the sale. This will ensure that the batch updates are captured within our Sales by product type reports. We can help you to set up a custom report capturing all the data you need to import to your POS system.
In addition to building custom reports to meet your specific needs, you'll have access to 60+ built-in reports that cover many common use cases for merchants and our reports can be scheduled to send to your email or Google Drive at set frequencies - like after the close of every day.
I encourage you to install Better Reports and start your free 14-day trial, and I'll be happy to set this up for you.
Let me know how you go and feel free to reach out if you have any further questions.
Hello @El-Mona ,
I am John from Report Pundit, a reporting and analytics app with more than 500 five-star reviews.
If you are still looking for a solution then Report Pundit can fetch data for the changes that are made to the vendor and product name, tags, type, etc in the sales level reports.
Our team has experience in creating custom reports for more than 10k customers. Contact us at firstname.lastname@example.org or our live chat support team for help.
My name is Denis and I'm one of the developers of the Advanced Reports app.
With our app you can get Sales by Actual Product type that products have right now:
Please feel free to contact me via email@example.com if you have additional questions.