How to Easily Analyze Zazzle Sales with Excel

So you've started to make some sales on Zazzle: Congrats! But what do you do now? How can you tell what you are actually selling?

In this tutorial I will give you a free Excel template to automatically create cool informational charts about your sales data. Use them to easily see what's working and what isn't!

First you will need to download your sales information on the CSV that Zazzle provides.

Do so by going to Earnings > Royalty History >  Export to CSV (Found at the bottom of the table)

Next, download the Zazzle Sales Analysis Template.


Great! You are ready to begin analyzing your sales!

1. In your Zazzle CSV, select columns A-P by clicking and dragging the top row of labels. 
2. Copy the selection.
3. In the Zazzle Sales Analysis Template, select box A1 (Says "Date) and press paste. The yellow cells should be replaced with your information. (If a date error message pops up, simply press "convert")
4. Switch to the "Data Tables" sheet at the bottom.
5. Right-click one of the green tables. Press "Refresh Data." Your information should fill in the tables. Now for the fun part!
6. Switch to the "Charts" sheet at the bottom of the window.

Viola! 6 custom charts to help you visually analyze your Zazzle sales!

The 6 charts show:

• Number of each product type sold
• Number of each design sold
• Number of designs that were customized
• Which stores sold products
• How the products were referred
• The Status of the orders

Feel free to change the chart type (in the "Charts" tab) to whichever type suits you best!

If you liked this tutorial, we'll keep em' coming! Subscribe in the sidebar so you don't miss out. Enjoy!

Notes:

 

If you have more than:

• 20 Designs
• 3 Stores

You will have to increase the data selections of the charts to fit them all. This is easy to do: Right-click the chart and click "Select Data." Then, click the button next to "Chart Data Range." This should allow you to click and drag over the table to select all of your data.

The template automatically sets these sections to 20 & 3 because these numbers vary so much for every user! As of now, I have not found a way to automatically update the data input. (If anyone has any ideas feel free to share!) Sorry for any inconvenience!