As most of you know, I sell my graphic art at Zazzle. I have three shops:

I have about 100 images (not all are used for products) on over 100 different product types. Zazzle keeps making new products available for us to add images to.

Some shop owners specialize in just postcards, or political bumper tickers, but many of put images on many different products. How do we keep track?

I have a spreadsheet, with the products down the left column, and the image names across the top. When I put an image on products, I check them off on the sheet. If I know an image won’t work on a product, I put an X in the cell. When Zazzle adds new products, I add them to the list, and can see easily what I need to make.

I lost my spreadsheet in a hard drive crash … but realized, when remaking it, that other shop owners might want to use  it too. So I made a blank template, with the products on Zazzle’s list (as of today), grouped the way I like it, and put them on my blog for others to download and use.

Product Creation Sheet: ods format for Open Office and similar

Product Creation Sheet: xls format for Excel (note this is a “file save as” from the ods version, so the formatting might be slightly off)

The spreadsheet is completely open — you can add and delete, move things around, change the font, or whatever you like.

If you find it useful, you can thank me by buying me my favorite caffeinated beverage. At this time of year, it’s an iced coffee, black, with a touch of stevia.

 

Share →

2 Responses to Zazzle Product Spreadsheet

  1. Kleckerlabor says:

    Thumbs high for the spreadsheet , Thx for Sharing :)

  2. Ploopie says:

    Cheers, this is awesome now I don’t have to make one myself! :D

Milliways Pin Button

Milliways Pin Button

For fans of The Hitchhiker's Guide to the Galaxy by Douglas Adams ... authentic souvenir merchandise from Milliways, the restaurant at the end of the universe. Visit Product Page ...
Ammonite Mug

Ammonite Mug

I found some great Victorian-era biological prints that I cleaned up and placed on different products. I wasn't sure to put them in Beasts or Steampunk. Visit Product Page ...
Charles Darwin Hoodie

Charles Darwin Hoodie

One of my more popular images, a portrait of Charles Darwin on a hoodie sweatshirt. Visit Product Page ...