{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Template","Collections","DO NOT EDIT OR SAVE TO CSV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":2,"n_cols":33,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["What type of product is it? (pick from drop down)","Leave Blank for now","Pick a product category from the drop-down list provided.","Do you have marketing collections? If so enter them here. Please do not use \"generic\" collections like \"wedding\" or similar. Make them specific to your brand or distinctive.","Leave Blank for now","The 'headline' for your product. Keep it concise and focused. \"Sell\" your product in a line or two.","A longer description of your product. This is where to provide details and 'romance' your item.","Add physical characteristics of the item like diamond clarity, etc.","A list of images that will be combined to create a rotating 3-d image of your item. If you are not familiar with how to do this, please contact us.","General image or media files relating to the item. This is the place to add videos about your collection, etc. but not item-specific images or video","In the unlikely event an item variant is a different type than your basic item, enter that here.","What is your internal SKU for the item.","A list of images (URL or file name) for the item, along with related videos (again URL or file name) for the item. Separate each one with a comma. At least one image is REQUIRED or the item will be loaded as \"inactive\".","What type of metal is used in the product? (pick from drop-down)","For pendants or neckwear, what is the length? ","For pendants or neckwear, what is the chain type?","Weight rounded to the nearest 2 decimal points","Use Drop Down","Use Drop Down","For pearl product only, what color is the pearl? Pick from drop-down","For pearl product only, what type of pearl? Pick from drop-down.","Enter the primary gemstone color for this item.","Enter the primary gemstone in this item","Enter the size for this ring variation, each new size will need a new variation. If you allow custom sized orders, please indicate so from the dropdown","What is your MSRP for the product? The product will not be sold for less than this without your permission.","What is your wholesale price for the item - the amount you will receive when it's sold. Include any standard shipping costs.","Open-text field for you to type whatever else you want to say about the product.","Is the product visible on the site or not? \"0\" for no, \"1\" for yes.","What other SKUs you stock should be displayed as related items? Type exact SKU.","How many do you have on hand right now?","Do you want to take custom orders if inventory is zero? Type 0 for \"no\" and 1 for \"yes\"","When inventory is zero, what should we tell customers? (does not display if column AB is \"No\")","only for NAMED varation types"]
["Product Type","Store ID","Product Categories","Collections","Brand ID","Title","Description","General Characteristics","360 Degree Images","Extra Media","Product Variation Type","SKU","Media","Metal","Chain/Strand Length","Chain/Strand Type","Diamond Carat Weight","Diamond Color","Diamond Clarity","Pearl Color","Pearl Type","Gem Color","Gem Type","Ring Size","Retail Price","Wholesale Price","Other Attributes","Disabled","Related SKUs","Stock Count","Allow No-stock Sale","No-stock Ship-time Message","Variation Name"]

{"sheet":"Collections","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Collections"]

{"sheet":"DO NOT EDIT OR SAVE TO CSV","index":2,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Product Types","Product Variation Types","Chain/Strand Length","Chain/Strand Type","Gem Color","Gem Type","Metal","Pearl Color","Pearl Type","Jewelry Category","Ring Size","Diamond Color","Diamond Clarity"]
["gemstone_earrings","gemstone_earrings","N/A","N/A","N/A","N/A","N/A","N/A","N/A","Neckwear","N/A","N/A","N/A"]
["gemstone_stud","gemstone_stud","6 inches","Byzantine","Gold","Amethyst","Sterling Silver/18k Yellow Gold","Black","Akoya","  Pendants","Custom","D","IF"]
["gemstone_pendant","gemstone_pendant","6.5 inches","Rolo","Purple","Citrine","Sterling Silver/14k Yellow Gold","Golden","Freshwater","  Necklaces","4","E","VVS1"]
["gemstone_necklace","gemstone_necklace","7 inches","Leather","Black","Topaz","Sterling Silver","Peach","South Sea","  Pearl Strands","4.5","F","VVS2"]
["gemstone_bracelet","gemstone_bracelet","7.5 inches","Wheat","Medium Blue","Agate","10K Gold over Silver","White","Tahitian","Earrings","5","G","VS1"]
["gemstone_ring","gemstone_ring","8 inches","Box","Light Blue","Amber","18K Gold over Silver","Pink","Other","  Studs","5.5","GH","VS2"]
["pearl_earrings","pearl_earrings","8.5 inches","Omega","Dark Blue","Aquamarine","24K Gold over Silver","Other",null,"  Buttons","6","H","SI1"]
["pearl_stud","pearl_stud","9 inches","Bead","Aqua","Aventurine","10K Yellow Gold",null,null,"  Chandeliers","6.5","I","SI1-SI2"]
["pearl_pendant","pearl_pendant","16 inches","Rope","Brown","Carnelian","10k Pink Gold",null,null,"  Dangles","7","J","SI2"]
["pearl_necklace","pearl_necklace","17 inches","Cable","Champagne","Chalcedony","10K White Gold",null,null,"  Drops","7.5","JK","SI3"]
["pearl_strand","pearl_strand","17.5 inches","Serpentine","Clear","Coral","10K Rose Gold",null,null,"  Huggies","8","K","I1"]
["pearl_strand_bracelet","pearl_strand_bracelet","18 inches","Herringbone","Gray","Crystal","10K Other Gold",null,null,"  Hoops","8.5","L","I1I2"]
["pearl_bracelet","pearl_bracelet","20 inches","Popcorn","Green","Czarite","10k Two Tone",null,null,"Bracelets","9","Champagne","I2"]
["pearl_ring","pearl_ring","22 inches","Tulang Naga","Medium Green","Diamond","14K Yellow Gold",null,null,"  Tennis Bracelets","9.5","Fancy Yellow","I3 or lower"]
["ring_no_gem","ring_no_gem","24 inches","Other","Light Green","Emerald","14k Pink Gold",null,null,"  Pearl Bracelets","10","Fancy Brown"]
["diamond_earrings","diamond_earrings","26 inches",null,"Dark Green","Garnet","14K White Gold",null,null,"  Cuffs","10.5","Blue"]
["diamond_pendant","diamond_pendant","28 inches",null,"Yellow Green","Rhodolite-garnet","14K Rose Gold",null,null,"  Bangles","11","Other"]
["diamond_stud","diamond_stud","30 inches",null,"Maroon","Hematite","14K Other Gold",null,null,"  Stackable Bracelets","11.5"]
["diamond_necklace","diamond_necklace","32 inches",null,"Orange","Jade","14k Two Tone",null,null,"Rings","12"]
["diamond_bracelet","diamond_bracelet","34 inches",null,"Pink","Jasper","18K Yellow Gold",null,null,"  Engagement Rings","12.5"]
["diamond_ring","diamond_ring","36 inches",null,"Rainbow","Labradorite","18 Pink Gold",null,null,"  Cocktail Rings","13"]
["bracelet_no_gem","bracelet_no_gem","Other",null,"Red","Lapis","18K White Gold",null,null,"  Right-Hand Rings","13.5"]
["earring_no_gem","earring_no_gem",null,null,"Rose","Malachite","18K Rose Gold",null,null,"  Wedding Bands","14"]
["necklace_no_gem","necklace_no_gem",null,null,"White","Marcasite","18K Other Gold",null,null,"  Cigar Band"]
["pendant_no_gem","pendant_no_gem",null,null,"Yellow","Moonstone","18k Two Tone",null,null,"  Promise Rings"]
["other_not_listed","other_not_listed",null,null,"Multicolor","Morganite","22K Yellow Gold",null,null,"  Anniversary Rings"]
["other_named_variations",null,null,null,"Other","Mother of Pearl","22K White Gold",null,null,"  Stacking Rings"]
[null,null,null,null,null,"MULTIGEM","22K Rose Gold",null,null,"Body Jewelry"]
[null,null,null,null,null,"Onyx","22K Other Gold",null,null,"Brooches / Pins"]
[null,null,null,null,null,"Opal","Platinum",null,null,"Tiaras / Hairpieces"]
[null,null,null,null,null,"Pearl","Platinum-enhanced sterling",null,null,"Anklets"]
[null,null,null,null,null,"Paua","Platinum-enhanced Sterling / 18k Yellow Gold",null,null,"Toe Rings"]
[null,null,null,null,null,"Peridot","Platinum-enhanced Sterling / 18k Pink Gold",null,null,"Men's"]
[null,null,null,null,null,"Quartz","Palladium",null,null,"Unisex"]
[null,null,null,null,null,"Ruby","Titanium",null,null,"Kids"]
[null,null,null,null,null,"Sapphire","Stainless Steel",null,null,"Accessories"]
[null,null,null,null,null,"Spinel","Steel",null,null,"  Purses"]
[null,null,null,null,null,"Tanzanite","Aluminum",null,null,"  Phone Accessories"]
[null,null,null,null,null,"Tiger Eye","Other",null,null,"  Tote Bags"]
[null,null,null,null,null,"Tourmaline",null,null,null,"  Microfiber Cloths"]
[null,null,null,null,null,"Tsavorite"]
[null,null,null,null,null,"Turquoise"]
[null,null,null,null,null,"Zircon"]
[null,null,null,null,null,"Zoisite"]
[null,null,null,null,null,"Other"]