CSV examples?

by Jay - Member - 09:40PM, Aug 18, 2008

Does anyone have any screenshots of their CSV file for bulk uploads they’re willing to share? I just want to see one so I can make sure I’m doing this right.

Jump to comment form | subscribe to this topic

John (jp)

Shopify

01:46PM, Aug 20, 2008

Hi Jay,
Here’s a sample CSV file for one product, with several variations.

Handle,Title,Body,Vendor,Type,Tags,Variant Title,Variant SKU,Variant Grams,Variant Inventory Tracker,Variant Inventory Qty,Variant Inventory Policy,Variant Fulfillment Service,Variant Price,Variant Compare At Price,Image Src
tulip-dreams,Tulip Dreams,"From the Ottawa Tulip Festival",T Photography,Print,flowers horizontal tulips yellow,10x15 Matte Print,"",1000,"",0,deny,manual,50.00,,http://static2.shopify.com/s/files/1/0000/0166/products/060509_174710_1_copy.jpg
tulip-dreams,,,,,,10x15 Lustre Print,"",1000,"",0,deny,manual,50.00,,
tulip-dreams,,,,,,12x18 Matte Print,"",1000,"",0,deny,manual,75.00,,
tulip-dreams,,,,,,12x18 Lustre Print,"",1000,"",0,deny,manual,75.00,,
tulip-dreams,,,,,,20x30 Lustre Print,"",3000,"",0,deny,manual,200.00,,

Here’s another example of a product with several images and two variations:

tulip-greeting-cards-set-1,Tulip Greeting Cards Set 1,"A set of beautiful *(white)Tulip Photography* greeting cards. Each 5""x7"" card has a beautiful 4""x6"" photograph printed on true photographic paper, mounted on white card stock. Cards are blank on the inside, making them suitable for all ocassions and includes a white envelope.",T Photography,Greeting Cards,tulips,Set of 6 cards,"",200,"",1,deny,manual,20.00,,http://static2.shopify.com/s/files/1/0000/0166/products/040509_162420.jpg
tulip-greeting-cards-set-1,,,,,,Set of 12 cards (2 of each),"",400,"",0,deny,manual,35.00,,http://static2.shopify.com/s/files/1/0000/0166/products/040509_183446.jpg
tulip-greeting-cards-set-1,,,,,,,,,,,,,,,http://static1.shopify.com/s/files/1/0000/0166/products/040509_144718.jpg
tulip-greeting-cards-set-1,,,,,,,,,,,,,,,http://static1.shopify.com/s/files/1/0000/0166/products/040509_175144.jpg
tulip-greeting-cards-set-1,,,,,,,,,,,,,,,http://static0.shopify.com/s/files/1/0000/0166/products/040509_181712.jpg
tulip-greeting-cards-set-1,,,,,,,,,,,,,,,http://static3.shopify.com/s/files/1/0000/0166/products/040515_111119.jpg
tulip-greeting-cards-set-1,,,,,,,,,,,,,,,http://static2.shopify.com/s/files/1/0000/0166/products/cards_open_card.jpg
tulip-greeting-cards-set-1,,,,,,,,,,,,,,,http://static3.shopify.com/s/files/1/0000/0166/products/card_001_front_back.jpg

Note that special handling of the 4”“x6”” and 5”“x7””.

John.