{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Main","Vendor Credentials","Sheet3","order details example","order info example"],"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":"Main","index":0,"n_rows":17,"n_cols":57,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Chargeback date","Transaction Date","Case Number","ACQ Auth Code","Trans Code","Reason Code","CB Type","Credit Card","Chargeback Amount","CC Type","Merchant Code","Product Code","MID","Marked in CRM","Order ID","Original order ID","Case Number","System Result","MID Number","Last 4","14-8-Trans Date","14-9-Trans Amt","Processor Name","15-Trans ID","16-CB Rpt Status","CC Type","CC Number","17-CB Exp Date","18-CB Auth Code","21-CB Billing AVS Status","22-CB Billing CVV Status","23-CB Billing Currency","24-CB Billing First Name","25-CB Billing Last Name","26-CB Billing Address","27-CB Billing City","28-CB Billing State","29-CB Billing Zip","30-CB Billing Country","31-1-CB Ship First Name","31-2-CB Ship Last Name","31-CB Ship Add","32-CB Ship City","33-Ship State","34-Ship Zip","35-Ship Country","35-5-Phone","36-Email Add","37-Order ID","38-Order IP Add","Tracking Number","Parent ID","Orig Date","Orig Amt","CRM Trans ID","History","Existing Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Vendor Credentials","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Vendor Abbreviation","Username","Password","URL"]
["MGG","bankXXXXXXX",null,"crm-ordercenter.com/admin"]
["FOW","bpayXXXXXXX",null,"musclelight.com/admin"]
["CAD","r.jXXXXXXXXX",null,"mytrackingcenter.com/admin"]
["VEX","bankXXXXXXX",null,"vextercenter.com/admin"]
["VIT","RoXXXXXXXXX",null,"secretcrm.com/admin"]
["DMJ","roXXXXXXXXX",null,"mydermacenter.com/admin"]

{"sheet":"Sheet3","index":2,"n_rows":1,"n_cols":57,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Chargeback date","Transaction Date","Case Number","ACQ Auth Code","Trans Code","Reason Code","CB Type","Credit Card","Chargeback Amount","CC Type","Merchant Code","Product Code","MID","Marked in CRM","Order ID","Original order ID","Case Number","System Result","MID Number","Last 4","14-8-Trans Date","14-9-Trans Amt","Processor Name","15-Trans ID","16-CB Rpt Status","CC Type","CC Number","17-CB Exp Date","18-CB Auth Code","21-CB Billing AVS Status","22-CB Billing CVV Status","23-CB Billing Currency","24-CB Billing First Name","25-CB Billing Last Name","26-CB Billing Address","27-CB Billing City","28-CB Billing State","29-CB Billing Zip","30-CB Billing Country","31-1-CB Ship First Name","31-2-CB Ship Last Name","31-CB Ship Add","32-CB Ship City","33-Ship State","34-Ship Zip","35-Ship Country","35-5-Phone","36-Email Add","37-Order ID","38-Order IP Add","Tracking Number","Parent ID","Orig Date","Orig Amt","CRM Trans ID","History","Existing Notes"]

{"sheet":"order details example","index":3,"n_rows":161,"n_cols":13,"rows_kept":161,"cut":false,"hidden":false,"merged":[]}
["Welcome"]
["Help"]
["Logout"]
["Dashboard"]
["Clients & Fulfillment"]
["Orders"]
["Customers"]
["\";"]
[]
["Lime Light CRM Notification"]
["X"]
["Close "]
["Orders"]
["Search Order History","Hide  "]
["From: "]
["To: "]
["Order ID: "]
["Campaign ID: "]
["Transaction ID: "]
["Product ID: "]
["Upsell ID: "]
["Tracking #: "]
["Shipping: "]
["Shipped Status: "]
["Payment Type: "]
["Status: "]
["CC First Six: "]
["CC Last Four: "]
["Customer ID: "]
["Gateway ID: "]
["First Name: "]
["Last Name: "]
["Email: "]
["Address: "]
["Address 2: "]
["City: "]
["ZIP: "]
["Phone: "]
["State: "]
["Country: "]
["IP: "]
["Affiliate ID: "]
["Sub-Affiliate ID: "]
["Confirm Status: "]
["RMA #: "]
["Billing Cycle: "]
["Routing/Account#: "]
["Show Results Clear "]
[]
[]
[]
["Import Orders for:   "]
["Select File:"]
[]
["Force Ship "]
[]
["Orders Features:"]
["Order Details Start Recurring Stop Recurring Reset Recurring Export CSV "]
[]
[]
["Select All Orders"]
["Page of 1 pages"]
["Total 1 records found"]
["Show"]
["per page"]
["Approved"]
["Approved"]
["All"]
["All"]
["Hold"]
["Hold"]
["Cancelations"]
["Cancelations"]
["Subscriptions"]
["Subscriptions"]
["Pending"]
["Pending"]
["Declines"]
["Declines"]
["Void/Refund"]
["Void/Refund"]
["Shipped"]
["Shipped"]
["Fraud"]
["Fraud"]
["Chargeback"]
["Chargeback"]
["Return"]
["Return"]
[null,"Order ID","Date/Time Stamp","Customer Name","Customer Email","Product Name","Amount","Qty","Campaign Name (ID)","Shipping Type","Next Recurring Date","Next Recurring Product","Status"]
[null,"CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED"]
["Shipping & Billing Information"]
["Shipping First Name:"]
["Shipping Last Name:"]
["Email Address:"]
["Shipping Address:"]
["Shipping Address 2:"]
["Shipping City:"]
["Shipping Zip/Postal:"]
["Shipping Country:"]
["Shipping State:"]
["Phone:"]
["Billing First Name:"]
["Billing Last Name:"]
["Billing Address:"]
["Billing Address 2:"]
["Billing City:"]
["Billing Zip/Postal:"]
["Billing Country:"]
["Billing State:"]
["Next Recurring Date:","CENSORED"]
["Recurring:","CENSORED"]
["Rebill Discount:","CENSORED"]
["Transaction ID:","CENSORED"]
["Auth ID:","CENSORED"]
["Tracking Number:"]
["Status:","CENSORED"]
["Shipping Method:"]
["Sub Total:","CENSORED"]
["Shipping:","CENSORED"]
["Sales Tax:","CENSORED"]
[null,"CENSORED"]
["Order Total:","CENSORED"]
["Void/Refund:","CENSORED"]
["RMA:","CENSORED"]
["Returns:","CENSORED"]
["Flags:","CENSORED"]
["Order Confirmation:"]
["Gateway:","CENSORED"]
["Preserve Gateway:","CENSORED"]
["IP Address:","CENSORED"]
["Payment Type:"]
["Credit Card #:"]
["Credit Card Expiration:"]
["Credit Card CVV:","CENSORED"]
["Prepaid Match:","CENSORED"]
["Checking Account:"]
["Routing Number:"]
["AFFID:","CENSORED"]
["C1:","CENSORED"]
["Order History"]
["Add New Note:"]
["Add New Note"]
["Existing Notes:","CENSORED"]
[null,"CENSORED"]
["History:","CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
[null,"CENSORED"]
["Select All Orders"]
["Page of 1 pages"]
["Total 1 records found"]
["Show"]
["per page"]
[]
["2008-2015 True Marketing Partners LLC. All Rights Reserved."]

{"sheet":"order info example","index":4,"n_rows":103,"n_cols":13,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Welcome"]
["Help"]
["Logout"]
["Dashboard"]
["Clients & Fulfillment"]
["Orders"]
["Customers"]
["\";"]
[]
["Lime Light CRM Notification"]
["X"]
["Close "]
["Orders"]
["Search Order History","Hide  "]
["From: "]
["To: "]
["Order ID: "]
["Campaign ID: "]
["Transaction ID: "]
["Product ID: "]
["Upsell ID: "]
["Tracking #: "]
["Shipping: "]
["Shipped Status: "]
["Payment Type: "]
["Status: "]
["CC First Six: "]
["CC Last Four: "]
["Customer ID: "]
["Gateway ID: "]
["First Name: "]
["Last Name: "]
["Email: "]
["Address: "]
["Address 2: "]
["City: "]
["ZIP: "]
["Phone: "]
["State: "]
["Country: "]
["IP: "]
["Affiliate ID: "]
["Sub-Affiliate ID: "]
["Confirm Status: "]
["RMA #: "]
["Billing Cycle: "]
["Routing/Account#: "]
["Show Results Clear "]
[]
[]
[]
["Import Orders for:   "]
["Select File:"]
[]
["Force Ship "]
[]
["Orders Features:"]
["Order Details Start Recurring Stop Recurring Reset Recurring Export CSV "]
[]
[]
["Select All Orders"]
["Page of 1 pages"]
["Total 4 records found"]
["Show"]
["per page"]
["Approved"]
["Approved"]
["All"]
["All"]
["Hold"]
["Hold"]
["Cancelations"]
["Cancelations"]
["Subscriptions"]
["Subscriptions"]
["Pending"]
["Pending"]
["Declines"]
["Declines"]
["Void/Refund"]
["Void/Refund"]
["Shipped"]
["Shipped"]
["Fraud"]
["Fraud"]
["Chargeback"]
["Chargeback"]
["Return"]
["Return"]
[null,"Order ID","Date/Time Stamp","Customer Name","Customer Email","Product Name","Amount","Qty","Campaign Name (ID)","Shipping Type","Next Recurring Date","Next Recurring Product","Status"]
[null,"CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED"]
[null,"CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED"]
[null,"CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED"]
[null,null,null,null,null,null,null,null,null,"CENSORED"]
[null,"CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED","CENSORED"]
[null,null,null,null,null,null,null,null,null,"CENSORED"]
["Select All Orders"]
["Page of 1 pages"]
["Total 4 records found"]
["Show"]
["per page"]
[]
["2008-2015 True Marketing Partners LLC. All Rights Reserved."]