Zazzle Earnings History CSV Export Issue

It has come to my attention that the Zazzle Earnings history CSV data export file is not exporting correctly. Currently, it spits out a CSV file with headers only and no data. I have reached out to tech support and they have directed me to the support thread below. In the meantime, there are two workarounds listed below that will make your Zazzle Designer Earnings Analytics file continue to function properly.
​
Tech support Thread - Zazzle is aware of the issue and has closed the thread until the issue is resolved. They will post updates.
https://forum.zazzle.com/technical/csv_file_not_downloading_properly
​
I encourage you to submit a help ticket to escalate the issue:
https://help.zazzle.com/hc/en-us
​
​
Impacted tabs:
-
Paste Earnings CSV Data Here
-
Input your forecast here - Actuals
-
Forecast Dashboard
-
Monthly Dashboard
-
Yearly Dashboard
Workaround options:
-
Enter one line of data in the "Paste Earnings CSV Data Here" and understand that the impacted tabs will not display data.
-
Copy and paste VALUES from the Royalty history and Referral history CSV exports into the "Paste Earnings CSV Data Here" tab
​
​
​
​
​
Option 2 detailed instructions: This looks like a lot of steps, but it's just copying and pasting data from existing tabs into the Paste Earnings CSV Data Here tab. See the screenshot above for a quick/simple mapping (but don't miss steps 13-16 and 30-32).
​
If you select this option, I suggest that you follow the normal instructions to paste in the Royalty and Referral data into the Analytics file before proceeding with these steps.
​
If you are an international user and have non-U.S. date and currency default settings on your computer, you will need to update them prior to using the tool using the following links. This was found effective for U.K. users.
How to Change Default Currency
How to Convert Dates to U.S. Format
​
If you participate in certain courses offered by Elke you may have access to a Zoom video call with Elke and myself that displays how to complete the workaround and explains the tool. Please contact me for additional details.
​
Disclaimer: This page contains affiliate links. Meaning, I earn a small amount as a referral fee if you make a purchase using my link. The price you pay is not affected by the fee I earn.
​
​
-
Click "Clear CSV Data" in the Instructions Tab
-
Paste Royalty and Referral history CSV data into corresponding tabs as usual
-
Copy the Date data from Royalty CSV tab
-
Paste Values into the Date column "Paste Earnings CSV Data Here" tab
-
Copy the Store data from Royalty CSV tab
-
Paste Values into the Store column "Paste Earnings CSV Data Here" tab
-
Manually type in Royalty on Product in the Description column
-
Copy and paste "Royalty on Product" into every line that you've pasted from the Royalty CSV
-
Copy the Status data from Royalty CSV tab
-
Paste Values into the Status column "Paste Earnings CSV Data Here" tab
-
Copy the Royalty data from Royalty CSV tab
-
Paste Values into the Credits column "Paste Earnings CSV Data Here" tab
-
Select Column R THROUGH Z (not just R&Z) in the "Paste Royalty CSV Data Here"
-
Right-click > Unhide


15.Copy the Royalty (USD) Clean (column T) data from Royalty CSV tab
16. Paste Values into the Converted Amt. (USD) column "Paste Earnings CSV Data Here" tab
17. Copy the Date data from Referral CSV tab
18. Paste Values into the Date column "Paste Earnings CSV Data Here" tab under the Royalty data (stacking)
19. Copy the Store data from Referral CSV tab
20. Paste Values into the Store column "Paste Earnings CSV Data Here" tab
21. Manually type in Referral on Product in the Description column
22. Copy and paste "Referral on Product" into every line that you've pasted from the Referral CSV
23. Copy the Status data from Referral CSV tab
24. Paste Values into the Status column "Paste Earnings CSV Data Here" tab
25. Copy the Referral Amount data from Referral CSV tab
26. Paste Values into the Credits column "Paste Earnings CSV Data Here" tab
27. Copy the Converted Referral data from Referral CSV tab
28. Paste Values into the Converted Amt. (USD) column "Paste Earnings CSV Data Here" tab
29. Highlight all Date data in the "Paste Earnings CSV Data Here" tab
30. Click Edit > Find > Replace
31. Enter a space and an asterisk into the find field, leave the replace field blank
32. Click Replace all
​

After all three green "paste CSV here" tabs have been completed please refer back to step 27 of the instructions tab in the Analytics file.
​
I apologize for the inconvenience & hope Zazzle will resolve this issue soon.
​
Thank you for being a Zazzle Designer Earnings Analytics customer!
​