{"id":448,"date":"2012-06-29T13:06:07","date_gmt":"2012-06-29T17:06:07","guid":{"rendered":"http:\/\/polymathsolution.com\/blog\/?p=448"},"modified":"2012-06-29T13:06:08","modified_gmt":"2012-06-29T17:06:08","slug":"zazzle-product-spreadsheet","status":"publish","type":"post","link":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/","title":{"rendered":"Zazzle Product Spreadsheet"},"content":{"rendered":"<p><a href=\"http:\/\/polymathsolution.com\/blog\/2011\/12\/16\/printfection-or-zazzle\/zazzle-button-home_9\/\" rel=\"attachment wp-att-259\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-259\" title=\"Zazzle Button home_9\" src=\"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif\" alt=\"\" width=\"141\" height=\"57\" \/><\/a>As most of you know, I sell my graphic art at Zazzle. I have three shops:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.zazzle.com\/cartesianbear?rf=238831668488066559\" target=\"_blank\">Cartesian Bear<\/a>, my general shop<\/li>\n<li><a href=\"http:\/\/www.zazzle.com\/cbi_steampunk?rf=238831668488066559\" target=\"_blank\">Cartesian Bear&#8217;s Steampunk Emporium<\/a>, steampunk inspired designs<\/li>\n<li><a href=\"http:\/\/www.zazzle.com\/knitsuite?rf=238831668488066559\" target=\"_blank\">Knit Suite<\/a>, items with a knitting theme<\/li>\n<\/ul>\n<p>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.<\/p>\n<p>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?<\/p>\n<p>I have a spreadsheet, with the products down the left column, and the\u00a0image names across the top. When I put an image on products, I check them off on the sheet. If I know an image won&#8217;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.<\/p>\n<p>I lost my spreadsheet in a hard drive crash &#8230; but realized, when remaking it, that other shop owners might want to use \u00a0it too. So I made a blank template, with the products on Zazzle&#8217;s list (as of today), grouped the way I like it, and put them on my blog for others to download and use.<\/p>\n<p><a href=\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/product-creation-sheet\/\" rel=\"attachment wp-att-450\">Product Creation Sheet: ods format<\/a>\u00a0for Open Office and similar<\/p>\n<p><a href=\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/product-creation-sheet-2\/\" rel=\"attachment wp-att-451\">Product Creation Sheet: xls format<\/a>\u00a0for Excel (note this is a &#8220;file save as&#8221; from the ods version, so the formatting might be slightly off)<\/p>\n<p>The spreadsheet is completely open \u2014 you can add and delete, move things around, change the font, or whatever you like.<\/p>\n<p>If you find it useful, you can thank me by buying me my favorite caffeinated beverage. At this time of year, it&#8217;s an iced coffee, black, with a touch of stevia.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As most of you know, I sell my graphic art at Zazzle. I have three shops: Cartesian Bear, my general shop Cartesian Bear&#8217;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 [&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,27],"tags":[],"class_list":["post-448","post","type-post","status-publish","format-standard","hentry","category-business","category-custom-merchandise"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Zazzle Product Spreadsheet - Polymath Solution<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/\"},\"author\":{\"name\":\"Liz\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/8aadd911e62a97bd7a148b88033d0225\"},\"headline\":\"Zazzle Product Spreadsheet\",\"datePublished\":\"2012-06-29T17:06:07+00:00\",\"dateModified\":\"2012-06-29T17:06:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/\"},\"wordCount\":303,\"commentCount\":2,\"image\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif\",\"articleSection\":[\"Business\",\"Custom Merchandise\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/\",\"url\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/\",\"name\":\"Zazzle Product Spreadsheet - Polymath Solution\",\"isPartOf\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif\",\"datePublished\":\"2012-06-29T17:06:07+00:00\",\"dateModified\":\"2012-06-29T17:06:08+00:00\",\"author\":{\"@id\":\"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/8aadd911e62a97bd7a148b88033d0225\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage\",\"url\":\"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif\",\"contentUrl\":\"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif\",\"width\":\"141\",\"height\":\"57\"},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/#website\",\"url\":\"http:\/\/polymathsolution.com\/blog\/\",\"name\":\"Polymath Solution\",\"description\":\"Interesting things, stuff and items\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/polymathsolution.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/8aadd911e62a97bd7a148b88033d0225\",\"name\":\"Liz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cd57a0579485d7d6e60f0db24ad3ee4bcadcb98c442e23f93311423ffd52d67a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cd57a0579485d7d6e60f0db24ad3ee4bcadcb98c442e23f93311423ffd52d67a?s=96&d=identicon&r=g\",\"caption\":\"Liz\"},\"description\":\"Professional polymath, currently earning a living in web and graphic design and development. Also available to teach knitting or chain mail, fix furniture, help design your house, give a lecture on gifted or special education in public schools, or help you with a science fiction con. \\\"Specialization is for insects\\\" and \\\"We also walk dogs\\\", two quotes from Robert Heinlein.\",\"sameAs\":[\"http:\/\/polymathsolution.com\"],\"url\":\"http:\/\/polymathsolution.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Zazzle Product Spreadsheet - Polymath Solution","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/","twitter_misc":{"Written by":"Liz","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#article","isPartOf":{"@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/"},"author":{"name":"Liz","@id":"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/8aadd911e62a97bd7a148b88033d0225"},"headline":"Zazzle Product Spreadsheet","datePublished":"2012-06-29T17:06:07+00:00","dateModified":"2012-06-29T17:06:08+00:00","mainEntityOfPage":{"@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/"},"wordCount":303,"commentCount":2,"image":{"@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage"},"thumbnailUrl":"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif","articleSection":["Business","Custom Merchandise"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/","url":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/","name":"Zazzle Product Spreadsheet - Polymath Solution","isPartOf":{"@id":"http:\/\/polymathsolution.com\/blog\/#website"},"primaryImageOfPage":{"@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage"},"image":{"@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage"},"thumbnailUrl":"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif","datePublished":"2012-06-29T17:06:07+00:00","dateModified":"2012-06-29T17:06:08+00:00","author":{"@id":"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/8aadd911e62a97bd7a148b88033d0225"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/polymathsolution.com\/blog\/2012\/06\/29\/zazzle-product-spreadsheet\/#primaryimage","url":"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif","contentUrl":"http:\/\/polymathsolution.com\/blog\/wp-content\/uploads\/2011\/12\/Zazzle-Button-home_9.gif","width":"141","height":"57"},{"@type":"WebSite","@id":"http:\/\/polymathsolution.com\/blog\/#website","url":"http:\/\/polymathsolution.com\/blog\/","name":"Polymath Solution","description":"Interesting things, stuff and items","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/polymathsolution.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/8aadd911e62a97bd7a148b88033d0225","name":"Liz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/polymathsolution.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cd57a0579485d7d6e60f0db24ad3ee4bcadcb98c442e23f93311423ffd52d67a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cd57a0579485d7d6e60f0db24ad3ee4bcadcb98c442e23f93311423ffd52d67a?s=96&d=identicon&r=g","caption":"Liz"},"description":"Professional polymath, currently earning a living in web and graphic design and development. Also available to teach knitting or chain mail, fix furniture, help design your house, give a lecture on gifted or special education in public schools, or help you with a science fiction con. \"Specialization is for insects\" and \"We also walk dogs\", two quotes from Robert Heinlein.","sameAs":["http:\/\/polymathsolution.com"],"url":"http:\/\/polymathsolution.com\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/posts\/448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/comments?post=448"}],"version-history":[{"count":8,"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/posts\/448\/revisions"}],"predecessor-version":[{"id":458,"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/posts\/448\/revisions\/458"}],"wp:attachment":[{"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/media?parent=448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/categories?post=448"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/polymathsolution.com\/blog\/wp-json\/wp\/v2\/tags?post=448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}