{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Settings","Tracking","Carrier Codes","Instructions"],"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":"Settings","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,3],[3,1,3,2],[4,1,4,2]]}
["WhereParcel Tracking Macro Settings"]
[]
["[ API Settings ]"]
["API Key","wp_test_public_demo_key_do_not_use_in_production",null,null,"Demo key - get yours at whereparcel.com"]
["Secret Key","sk_test_public_demo_secret_do_not_use_in_production",null,null,"Demo key - get yours at whereparcel.com"]
[]
["[ Sheet Settings ]"]
["Target Sheet","Tracking",null,null,"Sheet name containing your data"]
["Carrier Col","B",null,null,"Column letter (A, B, C...)"]
["Tracking # Col","C",null,null,"Column letter (A, B, C...)"]
["Result Start Col","D",null,null,"Results fill from this column onward"]
[]
["[ Execution Options ]"]
["Target","Track All"]
["Range","Mouse Selection"]
["Start Row",null,null,null,"For Specific Range only (blank = first row)"]
["End Row",null,null,null,"For Specific Range only (blank = last row)"]
[]
["[ Run Macros ]",null,null,null,null,null,"[ Macro Updates ]"]
["Press Alt+F8 or use the buttons below",null,null,null,null,null,"Click [Check for Updates] to see if a new version is available."]
["  TrackRegister    = Register tracking items with the API",null,null,null,null,null,"If an update exists, you can auto-update or download manually."]
["  TrackResults     = Fetch results for registered items",null,null,null,null,null,"After updating, click [Reset Setup] to refresh all sheets."]
["  ClearResults     = Clear all result columns",null,null,null,null,null,"Current version: v1.0.0"]
["  CheckVersion     = Check for macro updates"]
["  SetupAll         = Reset all sheets and buttons"]
[]
[]
[]
[]
["[ Registration History ]"]
["requestId","Count","Registered At","Status"]

{"sheet":"Tracking","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["No","Carrier Code","Tracking Number","Status","Status Text","Is Delivered","Receiver","Product","Date Delivered","Last Progress","Error"]
[1,"us.ups"]
[2,"us.usps"]
[3,"us.fedex"]
[4,"kr.cj"]
[5,"jp.yamato"]
[6,"de.dhl"]
[7,"gb.royalmail"]
[8,"intl.dhl"]

{"sheet":"Carrier Codes","index":2,"n_rows":225,"n_cols":3,"rows_kept":225,"cut":false,"hidden":false,"merged":[[194,0,194,2],[136,0,136,2],[143,0,143,2],[151,0,151,2],[159,0,159,2],[167,0,167,2],[175,0,175,2],[66,0,66,2],[73,0,73,2],[84,0,84,2],[91,0,91,2],[102,0,102,2],[114,0,114,2],[1,0,1,2],[11,0,11,2],[22,0,22,2],[24,0,24,2],[38,0,38,2],[51,0,51,2]]}
["Carrier Code","Carrier Name","Country"]
["-- Australia (AU) --"]
["au.post","Australia Post","AU"]
["au.startrack","StarTrack","AU"]
["au.toll","Toll Group","AU"]
["au.aramex","Aramex Australia","AU"]
["au.couriersplease","CouriersPlease","AU"]
["au.sendle","Sendle","AU"]
["au.tnt","TNT Australia","AU"]
["au.hunter","Hunter Express","AU"]
["au.fastway","Fastway Australia","AU"]
["-- Canada (CA) --"]
["ca.post","Canada Post","CA"]
["ca.fedex","FedEx Canada","CA"]
["ca.purolator","Purolator","CA"]
["ca.ups","UPS Canada","CA"]
["ca.canpar","Canpar Express","CA"]
["ca.intelcom","Intelcom","CA"]
["ca.loomis","Loomis Express","CA"]
["ca.ics","ICS Courier","CA"]
["ca.dicom","Dicom","CA"]
["ca.gobolt","GoBolt","CA"]
["-- China (CN) --"]
["cn.sf","SF Express","CN"]
["-- Germany (DE) --"]
["de.dhl","DHL Germany","DE"]
["de.hermes","Hermes Germany","DE"]
["de.dpd","DPD Germany *","DE"]
["de.gls","GLS Germany *","DE"]
["de.ups","UPS Germany","DE"]
["de.post","Deutsche Post","DE"]
["de.tnt","TNT Germany","DE"]
["de.fedex","FedEx Germany","DE"]
["de.amazon","Amazon Logistics Germany","DE"]
["de.transoFlex","trans-o-flex","DE"]
["de.go","GO! Express & Logistics","DE"]
["de.ilg","ILG","DE"]
["de.nightstar","Night Star Express","DE"]
["-- Spain (ES) --"]
["es.correos","Correos","ES"]
["es.seur","SEUR","ES"]
["es.mrw","MRW","ES"]
["es.nacex","Nacex","ES"]
["es.gls","GLS Spain","ES"]
["es.dhl","DHL Spain","ES"]
["es.fedex","FedEx Spain","ES"]
["es.ups","UPS Spain","ES"]
["es.celeritas","Celeritas","ES"]
["es.cttExpress","CTT Express","ES"]
["es.tipsa","Tipsa","ES"]
["es.envialia","Envialia","ES"]
["-- United Kingdom (GB) --"]
["gb.royalmail","Royal Mail","GB"]
["gb.parcelforce","Parcelforce Worldwide","GB"]
["gb.dpd","DPD UK","GB"]
["gb.hermes","Hermes UK","GB"]
["gb.evri","Evri","GB"]
["gb.yodel","Yodel","GB"]
["gb.dhl","DHL UK","GB"]
["gb.ups","UPS UK","GB"]
["gb.fedex","FedEx UK","GB"]
["gb.tnt","TNT UK","GB"]
["gb.royalmail.special","Royal Mail Special Delivery","GB"]
["gb.amazon","Amazon Logistics UK","GB"]
["gb.collectplus","CollectPlus","GB"]
["gb.myhermes","myHermes","GB"]
["-- Hong Kong (HK) --"]
["hk.post","Hongkong Post","HK"]
["hk.sf","SF Express HK","HK"]
["hk.kerry","Kerry Express HK","HK"]
["hk.dhl","DHL Hong Kong","HK"]
["hk.lalamove","Lalamove HK","HK"]
["hk.sfintl","S.F. International","HK"]
["-- India (IN) --"]
["in.post","India Post","IN"]
["in.bluedart","BlueDart","IN"]
["in.delhivery","Delhivery","IN"]
["in.dtdc","DTDC","IN"]
["in.ecom","Ecom Express","IN"]
["in.ekart","Ekart (Flipkart)","IN"]
["in.xpressbees","XpressBees","IN"]
["in.professional","Professional Couriers","IN"]
["in.gati","Gati","IN"]
["in.shadowfax","Shadowfax","IN"]
["-- Ireland (IE) --"]
["ie.anpost","An Post","IE"]
["ie.dpd","DPD Ireland","IE"]
["ie.fastway","Fastway Ireland","IE"]
["ie.gls","GLS Ireland","IE"]
["ie.dhl","DHL Ireland","IE"]
["ie.ups","UPS Ireland","IE"]
["-- Italy (IT) --"]
["it.tnt","TNT Italy","IT"]
["it.brt","BRT (Bartolini)","IT"]
["it.poste","Poste Italiane","IT"]
["it.gls","GLS Italy","IT"]
["it.dhl","DHL Italy","IT"]
["it.sda","SDA Express","IT"]
["it.fedex","FedEx Italy","IT"]
["it.ups","UPS Italy","IT"]
["it.dpd","DPD Italy","IT"]
["it.nexive","Nexive","IT"]
["-- Japan (JP) --"]
["jp.yamato","Yamato Transport","JP"]
["jp.sagawa","Sagawa Express","JP"]
["jp.post","Japan Post","JP"]
["jp.nittsu","Nippon Express","JP"]
["jp.ems","EMS Japan","JP"]
["jp.epacket","ePacket","JP"]
["jp.seino","Seino Transportation","JP"]
["jp.fukuyama","Fukuyama Transporting","JP"]
["jp.tonami","Tonami Transportation","JP"]
["jp.seino.express","Seino Super Express","JP"]
["jp.kix","KIX Airport Express","JP"]
["-- South Korea (KR) --"]
["kr.post","Korea Post","KR"]
["kr.cj","CJ Logistics","KR"]
["kr.lotte","Lotte Global Logistics","KR"]
["kr.hanjin","Hanjin Express","KR"]
["kr.logen","Logen","KR"]
["kr.kdexp","Kyungdong Express","KR"]
["kr.daesin","Daesin Express","KR"]
["kr.cvsnet","CVSnet","KR"]
["kr.epost","ePost","KR"]
["kr.hdexp","Hadong Express","KR"]
["kr.homepick","Homepick","KR"]
["kr.ilyanglogis","Ilyang Logistics","KR"]
["kr.kunyoung","Kunyoung","KR"]
["kr.slx","SLX Express","KR"]
["kr.gsmnton","GS Postbox","KR"]
["kr.swgexp","Seongwon Global Cargo","KR"]
["kr.chunil","Chunil Express","KR"]
["kr.honam","Honam Express","KR"]
["kr.kgbls","KGB Express","KR"]
["kr.gigaepost","Giga Express","KR"]
["kr.wonpower","Wonpower Logistics","KR"]
["-- New Zealand (NZ) --"]
["nz.post","NZ Post","NZ"]
["nz.courierpost","CourierPost","NZ"]
["nz.aramex","Aramex NZ","NZ"]
["nz.dhl","DHL New Zealand","NZ"]
["nz.posthaste","Post Haste","NZ"]
["nz.castle","Castle Parcels","NZ"]
["-- Philippines (PH) --"]
["ph.lbc","LBC Express","PH"]
["ph.jt","J&T Express PH","PH"]
["ph.ninjavan","Ninja Van PH","PH"]
["ph.2go","2GO Express","PH"]
["ph.post","PHLPost","PH"]
["ph.flash","Flash Express PH","PH"]
["ph.grab","Grab Express PH","PH"]
["-- Singapore (SG) --"]
["sg.post","SingPost","SG"]
["sg.ninjavan","Ninja Van SG","SG"]
["sg.jt","J&T Express SG","SG"]
["sg.qxpress","Qxpress","SG"]
["sg.taqbin","Ta-Q-Bin SG","SG"]
["sg.dhl","DHL Singapore","SG"]
["sg.janio","Janio Asia","SG"]
["-- Turkey (TR) --"]
["tr.yurtici","Yurtici Kargo","TR"]
["tr.ptt","PTT (Turkey Post)","TR"]
["tr.aras","Aras Kargo","TR"]
["tr.mng","MNG Kargo","TR"]
["tr.surat","Surat Kargo","TR"]
["tr.trendyol","Trendyol Express","TR"]
["tr.hepjet","HepsiJet","TR"]
["-- South Africa (ZA) --"]
["za.courierguy","The Courier Guy","ZA"]
["za.post","South African Post Office","ZA"]
["za.ram","RAM Hand-to-Hand","ZA"]
["za.aramex","Aramex South Africa","ZA"]
["za.dawnwing","Dawn Wing","ZA"]
["za.pargo","Pargo","ZA"]
["za.dhl","DHL South Africa","ZA"]
["-- United States (US) --"]
["us.usps","USPS","US"]
["us.fedex","FedEx","US"]
["us.ups","UPS","US"]
["us.dhl","DHL","US"]
["us.dhl.express","DHL Express","US"]
["us.dhl.ecommerce","DHL eCommerce","US"]
["us.ontrac","OnTrac","US"]
["us.ca.ontrac","OnTrac (California)","US"]
["us.lasership","LaserShip","US"]
["us.ny.lasership","LaserShip (New York)","US"]
["us.lso","Lone Star Overnight","US"]
["us.tx.lso","Lone Star Overnight (Texas)","US"]
["us.amazon","Amazon Logistics","US"]
["us.eastern","Eastern Connection","US"]
["us.gso","Golden State Overnight","US"]
["us.courier","Courier Express","US"]
["us.dynamex","Dynamex","US"]
["us.pilot","Pilot Freight Services","US"]
["-- International (INTL) --"]
["intl.dhl","DHL Express","INTL"]
["intl.fedex","FedEx","INTL"]
["intl.ups","UPS","INTL"]
["intl.cainiao","Cainiao","INTL"]
["intl.sf-express","SF Express International","INTL"]
["intl.4px","4PX Express","INTL"]
["intl.yunexpress","Yunexpress","INTL"]
["intl.gls","GLS","INTL"]
["intl.purolator","Purolator International","INTL"]
["intl.kerry","Kerry Express International","INTL"]
["intl.ems","EMS","INTL"]
["intl.usps","USPS International","INTL"]
["intl.postnl","PostNL International","INTL"]
["intl.singapore-post","Singapore Post International","INTL"]
["intl.china-post","China Post International","INTL"]
["intl.korea-post","Korea Post International","INTL"]
["intl.deutsche-post","Deutsche Post International","INTL"]
["intl.tnt","TNT Express","INTL"]
["intl.aramex","Aramex","INTL"]
["intl.chronopost","Chronopost International","INTL"]
["intl.yanwen","Yanwen","INTL"]
["intl.sagawa","Sagawa Global","INTL"]
["intl.bluedart","BlueDart","INTL"]
["intl.auspost","Australia Post International","INTL"]
["intl.royal-mail","Royal Mail International","INTL"]
["intl.canada-post","Canada Post International","INTL"]
["intl.la-poste","La Poste International","INTL"]
["intl.swiss-post","Swiss Post International","INTL"]
[]
["* = Postal code may be required for this carrier"]

{"sheet":"Instructions","index":3,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["[ WhereParcel Tracking Macro - Instructions ]"]
[]
["1. Initial Setup (Settings sheet)"]
["   - Enter your API Key and Secret Key"]
["   - Set the target sheet name, carrier column, tracking # column, result start column"]
["   - Target: Track All / Untracked Only"]
["   - Range: Mouse Selection / All / Specific Range"]
[]
["2. VBA Macro Setup"]
["   - Press Alt+F11 > File > Import File > select TrackingMacro.bas"]
["   - Save the workbook as .xlsm format"]
[]
["3. First-time Setup (run once)"]
["   - Press Alt+F8 > run SetupAll"]
["   - This creates Settings + Carrier Codes + Instructions sheets + buttons"]
[]
["4. Register Tracking (TrackRegister)"]
["   - Press Alt+F8 > TrackRegister, or click the button"]
["   - Items are batched automatically (max 100 per batch)"]
["   - requestId is saved in the Settings sheet history"]
[]
["5. Fetch Results (TrackResults)"]
["   - Wait 5-10 seconds after registration"]
["   - Press Alt+F8 > TrackResults, or click the button"]
["   - If results are not ready, wait and try again"]
[]
["6. Clear Results (ClearResults)"]
["   - Clears all result columns in the target sheet"]
[]
["7. Check for Updates (CheckVersion)"]
["   - Compares your macro version with the latest on the server"]
["   - If a new version is available, guides you through updating"]
["   - Auto-update or manual download options available"]
[]
["8. Reset Setup (SetupAll)"]
["   - Recreates all sheets (Settings, Tracking, Carrier Codes, Instructions)"]
["   - Recreates buttons on the Settings sheet"]
["   - Run this after updating the macro to apply changes"]
[]
["[ Important Notes ]"]
["- Do not add or delete data rows between registration and fetching results"]
["- Usage charges may apply - avoid unnecessary repeated registrations"]
["- Max 100 items per batch (auto-split for larger sets)"]
["- Carrier codes are listed in the 'Carrier Codes' sheet"]
[]
["[ Demo Key Warning ]"]
["- The default keys are demo keys with limited usage"]
["- Get your production keys at https://whereparcel.com"]