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:

  1. Paste Earnings CSV Data Here

  2. Input your forecast here - Actuals

  3. Forecast Dashboard

  4. Monthly Dashboard

  5. Yearly Dashboard

 

Workaround options:

  1. Enter one line of data in the "Paste Earnings CSV Data Here" and understand that the impacted tabs will not display data.

  2. 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.

  1. Click "Clear CSV Data" in the Instructions Tab

  2. Paste Royalty and Referral history CSV data into corresponding tabs as usual

  3. Copy the Date data from Royalty CSV tab

  4. Paste Values into the Date column "Paste Earnings CSV Data Here" tab

  5. Copy the Store data from Royalty CSV tab

  6. Paste Values into the Store column "Paste Earnings CSV Data Here" tab

  7. Manually type in Royalty on Product in the Description column

  8. Copy and paste "Royalty on Product" into every line that you've pasted from the Royalty CSV

  9. Copy the Status data from Royalty CSV tab

  10. Paste Values into the Status column "Paste Earnings CSV Data Here" tab

  11. Copy the Royalty data from Royalty CSV tab

  12. Paste Values into the Credits column "Paste Earnings CSV Data Here" tab

  13. Select Column R THROUGH Z (not just R&Z) in the "Paste Royalty CSV Data Here"

  14. 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!

  • Danielle Fernandez Designs Zazzle
  • Google Places - Black Circle
  • Yelp - Black Circle
  • thumbtack

©2018 BY DANIELLE FERNANDEZ DESIGNS | LA GRANGE, IL

PROUDLY CREATED ON WIX

PRIVACY POLICY | DISCLAIMER