{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Manager","Filters","products","products_images","Sample_Shopify_import"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Manager","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Stanley / Stella API VBA Implementation Sample"]
[]
[null,"This Document contains two macros"]
[null,"- one for calling the API"]
[null,"- one to download the packshots"]
[]
[null,"You can use it for testing purposes"]
[null,"You can find the two macros in the VisualBasic Window"]
[]
[null,"1. SET your username and password"]
[]
[null,null,"Username","test@stanleystella.com",null,null,null,null,null,null,null,"Please type here your login"]
[null,null,"Password","Test0220",null,null,null,null,null,null,null,"Please type here your password"]
[]
[null,"2. SELECT your environnement"]
[]
[null,null,"Set Env","Production",{"$f":"IF(D18=\"Production\",\"https://api.stanleystella.com/webrequest\",\"http://apitest.stanleystella.com/webrequest\")","v":"https://api.stanleystella.com/webrequest"},null,null,null,null,null,null,"Note: this demo only works on production environnement"]
[]
[null,"3. SELECT What you want to get"]
[]
[null,null,"Get","Pictures",{"$f":"IF(D22=\"Catalog\",\"products\",\"products_images\")","v":"products_images"},null,null,null,null,null,null,"Select the sheet you want to update"]
[]
[null,"4. Add additionnal Filters"]
[]
[null,null,"Style","STSU807",1,null,null,null,null,null,null,"Select some filters depending on the call you do"]
[null,null,"Color","C582",1,null,null,null,null,null,null,"Note : additionnal filters are available, as described on https://api.stanleystella.com/page/api-userguide"]
[null,null,"Size","S",{"$f":"IF(D22=\"Pictures\",0,1)","v":0}]
[null,null,"Language",null,{"$f":"IF(D22=\"Pictures\",0,1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Click the button to run de call and get the result."]
[null,null,null,null,null,null,null,null,null,null,null,"Note that the call refreshes one sheet at a time."]
[null,"5. Results"]
[]
[null,null,"Product Items",{"$f":"COUNTA(products!A:A)-1","v":6},null,null,null,null,null,null,null,"This is the number of item lines retrieved according to your query"]
[null,null,"Pictures found",{"$f":"COUNTA(products_images!A:A)-1","v":3},null,null,null,null,null,null,null,"This is the number of pictures retrieved according to your query"]
[]
[null,null,"Save To","C:\\Download\\",null,null,null,null,null,null,null,"Select a folder to save the pictures to"]
[null,null,"Subfolders","Per Style And Color",null,null,null,null,null,null,null,"No : pictures will be placed in the \"Save To\" folder. Per Style : a separate subfolder will be created. Per Style and Color : same with 2 levels"]
[null,null,"Friendly Names","Yes",null,null,null,null,null,null,null,"No : pictures will have their technical names : PFM0_STSU807_C582.jpg, Yes: Pictures will be named [Front(0)] Base (Heather Eucalyptus).jpg"]

{"sheet":"Filters","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Call Endpoint",{"$f":"IF(Manager!D18=\"Production\",\"https://api.stanleystella.com/webrequest/\",\"https://apitest.stanleystella.com/webrequest/\")","v":"https://api.stanleystella.com/webrequest/"},"Login","test@stanleystella.com","Password","Test0220"]
["Call to perform",{"$f":"IF(Manager!D22=\"Catalog\",\"products\",\"products_images\")","v":"products_images"},"Save To","C:\\Download\\","Generated String"]
["StyleCode",{"$f":"IF(ISBLANK(Manager!D26),\"\",Manager!D26)","v":"STSU807"},"Create Sub",{"$f":"IF(Manager!D39=\"No\",\"No\",IF(Manager!D39=\"Per Style\",\"Style\",\"Style/Color\"))","v":"Style/Color"},"\"StyleCode\" : \"STSU807\"","\"StyleCode\" : \"STSU807\",\"ColorCode\" : \"\""]
["ColorCode",{"$f":"IF(ISBLANK(Manager!D27),\"\",Manager!D27)","v":"C582"},"Friendly Names",{"$f":"Manager!D40","v":"Yes"},"\"ColorCode\" : \"\""]
["SizeCode",{"$f":"IF(ISBLANK(Manager!D28),\"\",Manager!D28)","v":"S"},null,null,"\"SizeCode\" : \"\""]
["LanguageCode",{"$f":"IF(ISBLANK(Manager!D29),\"\",Manager!D29)","v":""},null,null,"\"LanguageCode\" : \"fr_FR\""]

{"sheet":"products","index":2,"n_rows":7,"n_cols":78,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["LanguageCode","B2BSKUREF","StyleCode","ColorCode","SizeCodeNavision","SizeCode","StyleName","Color","ColorGroup","Type","Category","Gender","Stock","Fit","Neckline","Sleeve","ShortDescription","LongDescription","ShortNote","LongNote","Bleaching","Washing","Cleaning","Drying","Ironing","CompositionList","ConstructionList","FinishList",null,"SundryList","Gauge","Weight","GOTS","OCS100","OCSBlended","Ecotex","Fairwear","CarbonNeutral","FSC","REACH","WeigthPerUnit","PiecesPerBox","HalfChest","BodyLength","SleeveLength","Width","Length","StrapLength","Waist","Tight","TotalLegLength","HSCode","K3EUR","K15EUR","K30EUR","K50EUR","K100EUR","Price<10 EUR","Price>10 EUR","Price>50 EUR","Price>100 EUR","Price>250 EUR","Price>500 EUR","Price>1000 EUR","K3GBP","K15GBP","K30GBP","K50GBP","K100GBP","Price<10 GBP","Price>10 GBP","Price>50 GBP","Price>100 GBP","Price>250 GBP","Price>500 GBP","Price>1000 GBP","SKU_Start_Date","Published"]
["fr_FR","STSU807C5821S","STSU807","C582","1S","S","Base","Heather Eucalyptus","Special Heathers","Sweatshirts","Haut","Unisexe",678,"Coupe medium","Col rond à capuche","Manches longues","Sweat à capuche à manches raglan avec poche passepoilée","manches raglan capuche avec doublure en jersey simple Boucles cordons déco sur la capuche ourlet bas de manches et ourlet inférieur en côte 1 x 1  poches passepoilées à l'avant surpiqûre flatlock sur toutes les coutures","non","non","Non","30°","Non","Pas de séchoir","110°","100% Coton Bio","Sweat-shirt enduit","Fabric washedSuédé léger",null,null,0,280,1,0,0,1,1,0,0,0,0.498,20,50.5,67.5,75,0,0,0,0,0,0,61102091,null,null,null,null,null,40.5,25.65,24.3,22.95,21.6,20.25,18.899999999999999,null,null,null,null,null,34.5,21.85,20.7,19.55,18.399999999999999,17.25,16.100000000000001,"2017-01-01",true]
["it_IT","STSU807C5821S","STSU807","C582","1S","S","Base","Heather Eucalyptus","Special Heathers","Felpe","Top","Unisex",678,"Vestibilità media","Collo rotondo con cappuccio","Long Sleeve","Felpa con cappuccio maniche raglan con tasca a filetto","manica raglan cappuccio foderato con single jersey cordoncini del cappuccio decorativi  orlo manica e orlo inferiore a coste 1x1 tasche a filetto davanti  impuntura flatlock  su tutte le cuciture","no","no","No","30°","No","Asciugatura in tamburo norm","110°","100% Cotone biologico","Felpa spazzolata","Fabric washedScamosciato leggero",null,null,0,280,1,0,0,1,1,0,0,0,0.498,20,50.5,67.5,75,0,0,0,0,0,0,61102091,null,null,null,null,null,40.5,25.65,24.3,22.95,21.6,20.25,18.899999999999999,null,null,null,null,null,34.5,21.85,20.7,19.55,18.399999999999999,17.25,16.100000000000001,"2017-01-01",true]
["nl_BE","STSU807C5821S","STSU807","C582","1S","S","Base","Heather Eucalyptus","Special Heathers","Sweatshirts","Boven","Unisex",678,"Medium pasvorm","Ronde hals met kap","Long Sleeve","Hoodie met raglanmouw en  paspelzak","raglanmouw capuchon met single jersey voering  decoratieve aantrekkoordjes bij capuchon  mouw- en onderzoom van 1x1 ribstof paspelzakken aan voorzijde  flatlockstiksels op alle naden","niet","niet","Nee","30°","Nee","Droogkast Neen","110°","100% Biologisch katoen","Geborstelde sweatshirt","Fabric washedWeinig suède",null,null,0,280,1,0,0,1,1,0,0,0,0.498,20,50.5,67.5,75,0,0,0,0,0,0,61102091,null,null,null,null,null,40.5,25.65,24.3,22.95,21.6,20.25,18.899999999999999,null,null,null,null,null,34.5,21.85,20.7,19.55,18.399999999999999,17.25,16.100000000000001,"2017-01-01",true]
["en_US","STSU807C5821S","STSU807","C582","1S","S","Base","Heather Eucalyptus","Special Heathers","Sweatshirts","Top","Unisex",678,"Medium Fit","Round neck with Hood","Long Sleeve","Raglan sleeve welt pocket hoodie","raglan sleeve hood with single jersey linin   deco drawcord loops at hood   sleeve hem and bottom hem in 1x1 rib  welt pockets at front   flatlock  topstitch on all seams","non","non","No","30°","No","Tumble Dry No","110°","100% Organic Cotton","Brushed sweatshirt","Fabric washedLight sueded",null,null,0,280,1,0,0,1,1,0,0,0,0.498,20,50.5,67.5,75,0,0,0,0,0,0,61102091,null,null,null,null,null,40.5,25.65,24.3,22.95,21.6,20.25,18.899999999999999,null,null,null,null,null,34.5,21.85,20.7,19.55,18.399999999999999,17.25,16.100000000000001,"2017-01-01",true]
["de_DE","STSU807C5821S","STSU807","C582","1S","S","Base","Heather Eucalyptus","Special Heathers","Sweatshirts","Oberteil","Unisex",678,"Reguläre Passform","Rundhalsausschnitt mit Kapuze","Long Sleeve","Hoodie mit Raglanärmeln und Leistentaschen","Raglanärmel Kapuze mit Futter aus Single Jersey  Dekorative Zugkordel-Schlaufen an der Kapuze  Ärmelsaum und unterer Saum aus 1x1 Rippstrick Leistentaschen vorne  Flatlocknaht-Absteppung auf allen Nähten","Keine","Keine","Nein","30°","Nein","Nicht im Trommeltrockner trocknen","110°","100% Bio-Baumwolle","Aufgerautes Sweatshirt","Fabric washedLight Suede Wildlederimitat",null,null,0,280,1,0,0,1,1,0,0,0,0.498,20,50.5,67.5,75,0,0,0,0,0,0,61102091,null,null,null,null,null,40.5,25.65,24.3,22.95,21.6,20.25,18.899999999999999,null,null,null,null,null,34.5,21.85,20.7,19.55,18.399999999999999,17.25,16.100000000000001,"2017-01-01",true]
["es_ES","STSU807C5821S","STSU807","C582","1S","S","Base","Heather Eucalyptus","Special Heathers","Sudaderas","Parte de arriba","Unisex",678,"Ajuste medio","Cuello redondo con capucha","Long Sleeve","Sudadera de manga ranglan con capucha y bolsillo con vivo","manga ranglan capucha con forro de punto jersey sencillo ojales para cordones de ajuste decorativos en la capucha borde de canalé 1x1 en las mangas y el bajo bolsillos con vivo en la parte delantera pespunte flatlock en todas las costuras","no","no","No","30°","No","No secar en secadora","110°","100% Algod\\\\u00f3n org\\\\u00e1nico","Sudadera cepillada","Fabric washedAnte suave",null,null,0,280,1,0,0,1,1,0,0,0,0.498,20,50.5,67.5,75,0,0,0,0,0,0,61102091,null,null,null,null,null,40.5,25.65,24.3,22.95,21.6,20.25,18.899999999999999,null,null,null,null,null,34.5,21.85,20.7,19.55,18.399999999999999,17.25,16.100000000000001,"2017-01-01",true]

{"sheet":"products_images","index":3,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Type","Category","Gender","StyleCode","ColorCode","PhotoTypeCode","PhotoShootCode","PhotoSequenceCode","StyleName","FName","Color","FTPFilePath","FTPZipPath","HTMLPath"]
["Sweatshirts","Top","Unisex","STSU807","C582","Packshot","Side",0,"Base","PSM0_STSU807_C582.jpg","Heather Eucalyptus",null,null,"http://api.stanleystella.com:8080/Pictures/PSM0_STSU807_C582.jpg"]
["Sweatshirts","Top","Unisex","STSU807","C582","Packshot","Front",0,"Base","PFM0_STSU807_C582.jpg","Heather Eucalyptus",null,null,"http://api.stanleystella.com:8080/Pictures/PFM0_STSU807_C582.jpg"]
["Sweatshirts","Top","Unisex","STSU807","C582","Packshot","Back",0,"Base","PBM0_STSU807_C582.jpg","Heather Eucalyptus",null,null,"http://api.stanleystella.com:8080/Pictures/PBM0_STSU807_C582.jpg"]

{"sheet":"Sample_Shopify_import","index":4,"n_rows":2,"n_cols":44,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Handle","Title","Body (HTML)","Vendor","Type","Tags","Published","Option1 Name","Option1 Value","Option2 Name","Option2 Value","Option3 Name","Option3 Value","Variant SKU","Variant Grams","Variant Inventory Tracker","Variant Inventory Qty","Variant Inventory Policy","Variant Fulfillment Service","Variant Price","Variant Compare At Price","Variant Requires Shipping","Variant Taxable","Variant Barcode","Image Src","Image Alt Text","Gift Card","Google Shopping / MPN","Google Shopping / Age Group","Google Shopping / Gender","Google Shopping / Google Product Category","SEO Title","SEO Description","Google Shopping / AdWords Grouping","Google Shopping / AdWords Labels","Google Shopping / Condition","Google Shopping / Custom Product","Google Shopping / Custom Label 0","Google Shopping / Custom Label 1","Google Shopping / Custom Label 2","Google Shopping / Custom Label 3","Google Shopping / Custom Label 4","Variant Image","Variant Weight Unit"]
[{"$f":"products!C2","v":"STSU807"},{"$f":"products!G2","v":"Base"},null,"Stanley & Stella",{"$f":"products!J2","v":"Sweatshirts"},null,true,"Title",{"$f":"products!Q2","v":"Sweat à capuche à manches raglan avec poche passepoilée"},"Color",{"$f":"products!H2","v":"Heather Eucalyptus"},"Size",{"$f":"products!F2","v":"S"},{"$f":"products!B2","v":"STSU807C5821S"},{"$f":"products!AN2","v":0},null,{"$f":"products!M2","v":678},"continue","manual",null,null,false,false,null,null,null,false,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]