I have run into an issue when exporting the Sales by Product Variant Sku. I work for a Kidswear brand, and baby sizes run in size 000, 00, 0, 1 and 2. The problem with this is that when I export the Sales by Product Variant Sku, the CSV file combines the Variant Title for sizes 000, 00 and 0 all as size 0, so there is no way for me to understand how many of each I have actually sold, as it shows them all as the same thing.
| product_title (export) |
variant_title (export) |
ACTUAL SIZE |
| Seaside Shortie - Red Roses |
0 |
0 |
| Seaside Shortie - Red Roses |
0 |
00 |
| Seaside Shortie - Red Roses |
0 |
000 |
| Seaside Shortie - Red Roses |
1 |
1 |
| Seaside Shortie - Red Roses |
2 |
2 |
2 Likes
Be sure to file a bug report with shopify support https://help.shopify.com/en/support
When explaining this it could help to have a similar table but with expected values of inventory if this problem didn’t exist, and maybe a cost calculation of bad inventory info.
Do these all share the same sku as well??
Under the hood there must be something interpreting those “sizes” as a number probably from use cases where size is a quantity or a weight and extra zeros are just treated as typos .
So any amount of zeros 0000000… get turned into 0 , instead of pure unique text values; but why that would end up omitting the data for different skus is weird.
Whether shopify can fix that in the shorterm or at all is a guessing game, so you may need to either:
A) change variant options values to be unique text and not things that can be treated as non-unique numbers(i.e. xxsmall,extrasmall ,small,etc) then test again. And at least for the online-sales channel customize the theme to read those new option values but still output the old number sizes.
B) use a more robust reporting tool/app.
I’d see if an app like report toaster can do this properly out of the box without a zero padding bug. Or if you need it an automation app like mechanic can be made to generate this data in csv with this specific size option behavior in mind. Nothing premade for such a situation but there are CSV examples https://tasks.mechanic.dev/?q=csv and reporting examples https://tasks.mechanic.dev/demonstration-generate-product-sales-report-pdf-with-pie-chart .
If you want to explore the latter you can contact me.
Hey there @Sianb22 ,
If you open the CSV file with a plain text editor instead of a spreadsheet software, do you see the 000, 00, etc. there or are they also just showing a single 0?
It’s possible the spreadsheet software you’re using to open the CSV file is automatically converting/formatting the data to a number type instead of text.
One thing you can try is to explicitly tell the spreadsheet software to treat that specific column as “text” (more info here for Excel).