Zazzle Product Spreadsheet

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

• Cartesian Bear, my general shop
• Cartesian Bear’s Steampunk Emporium, steampunk inspired designs
• Knit Suite, items with a knitting theme

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.