MAJOR ISSUE w/ Data in Google Sheets NOT MATCHING what was supplied in DATA EXPORT scheduled report

Shopify Apps
1

I am having a heck of a time trying to figure out why scheduled exports from the DATA EXPORT app will be about 85% correct in daily export of our Product Barcodes. In some cases, this seems to be linked to the fact that DE will add leading Zeros to a barcode to ensure it is 8-digits. But in other cases, the Barcode that ends up in the Google Sheet is simply completely different.

I have contacted DE Support endlessly over the last year or so reporting this issue and they seem to be as confused as I am, and/or insist there is no issue.

Has anyone else experienced this with Data Export or with any other Shopify apps?

I will upload the CSV, however that does not maintain the formatting where I’ve highlighted the data errors.

However a quick script comparing columns C & H should make the issue painfully clear.

It may be worth noting that when making a script to compare the variances, it had to convert the data to a string. I suspect part of the issue may be linked to the formatting, but I can’t explain why that would completely change the value in the cell.

Pleading for any help or ideas.

2

Hi @Justin3 :waving_hand: :rescue_worker_s_helmet: Non answer answer, just try a different app to rule out the variable of the current app.

This is the type of thing that takes a heavy time investment, it’s work , way beyond the scope of the forums.

If you have a suitable budget and need exploratory work then contact me for services.
Contact info in forum signature below :down_arrow: :down_arrow: :down_arrow:.
ALWAYS please provide context, examples: store url, theme name, post url(s) , or any further detail in ALL correspondence.