Yesterday, 01:39 PM
Hello DarkForums Community,
Today I am selling Avalara (partial) database, thanks for reading and enjoy!
Today I am selling Avalara (partial) database, thanks for reading and enjoy!
![[Image: avalara.svg]](https://cdn.worldvectorlogo.com/logos/avalara.svg)
Revenue: $0.78 Billion
In September 2025, Avalara suffered a data breach that affected both the company itself and its customers containing 8 155 700 rows.
Breached by @ghidra
Compromised Data:
API Tokens, API Endpoints, FirstName, LastName, Phone, Email Addresses, Order Metadata, Shipping Information, Tracking Information, IP Addresses, Request Parameters, Request Timestamps, Internal System Identifiers, Internal API Structures and more.
Among the customers, you will find employees:
Amazon
Affinitycu
Microsoft
Morgan Stanley
UKG
and more !
Samples:
Code:
{"_id":90723469,"site_id":4061,"organization_id":512,"site_name":"Kelley Kronenberg Store","organization_name":"SCG & Associates, Inc. ","transaction_type":"ApiV1Point1Minor6Orders: show","transaction_id":"63d0100cf7","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:32:09\n\nURL: https://kelleykronenbergstore.mybrightsites.com/api/v1.1.7/orders/126?token=*****************Cbz\nMethod: GET\nParams: {\"token\":\"*****************Cbz\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor6/orders\",\"action\":\"show\",\"id\":\"126\"}\nResponse: {\"order_id\":126,\"custom_data_collections\":[],\"customer_email\":\"vspencer@kelleykronenberg.com\",\"customer_id\":2197363,\"username\":\"VSpencer\",\"item_total\":\"0.0\",\"grand_total\":\"0.0\",\"required_adjustments\":[{\"amount\":\"0.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"}],\"balance_adjustments\":[],\"payment\":{\"id\":2942478,\"authorization\":null,\"created_at\":\"2020-09-25T11:59:40.000-06:00\",\"amount\":\"0.0\",\"state\":\"completed\",\"details\":{\"method\":\"No Payment Required\",\"amount\":\"$0.00\"}},\"status\":\"moas_pending\",\"date\":\"2020-09-25T11:59:47.000-06:00\",\"site_id\":4061,\"site_name\":\"Kelley Kronenberg Store\",\"site_url\":\"https://kelleykronenbergstore.mybrightsites.com\",\"organization_name\":\"SCG \\u0026 Associates, Inc. \",\"organization_id\":512,\"custom_store_id\":null,\"shipping_contact\":{\"first_name\":\"Veda\",\"last_name\":\"Spencer\",\"email\":\"vspencer@kelleykronenberg.com\",\"phone\":\"7864362414\"},\"shipping_address\":{\"company\":\"Kelley Kronenberg\",\"first_address\":\"80 Northeast 164 Street\",\"second_address\":\"\",\"city\":\"North Miami Beach\",\"state\":\"Florida\",\"country\":\"United States\",\"zip\":\"33162\"},\"billing_contact\":{\"first_name\":\"Veda\",\"last_name\":\"Spencer\",\"email\":\"vspencer@kelleykronenberg.com\",\"phone\":\"7864362414\"},\"billing_address\":{\"company\":\"Kelley Kronenberg\",\"first_address\":\"80 Northeast 164 Street\",\"second_address\":\"\",\"city\":\"North Miami Beach\",\"state\":\"Florida\",\"country\":\"United States\",\"zip\":\"33162\"},\"shipment\":{\"tracking_number\":null,\"created_at\":\"2020-09-25T11:59:04.000-06:00\",\"ship_date\":null,\"in_hands_date\":null,\"shipping_method\":\"Office Shipping\",\"cost\":\"0.0\"},\"payments\":[{\"id\":2942478,\"authorization\":null,\"created_at\":\"2020-09-25T11:59:40.000-06:00\",\"amount\":\"0.0\",\"state\":\"completed\",\"details\":{\"method\":\"No Payment Required\",\"amount\":\"$0.00\"}}],\"line_items\":[{\"id\":10387337,\"name\":\"Apollo 24oz Tritan Sport Bottle\",\"final_sku\":\"0105-24887\",\"quantity\":1,\"product_price\":\"0.0\",\"options_price\":\"0.0\",\"total_price\":\"0.0\",\"tax_price\":null,\"unit_price\":\"0.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":560679,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Red\",\"option_type\":\"color\",\"option_id\":6294217,\"sub_option_id\":12916696}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]},{\"id\":10387363,\"name\":\"Face Mask with Valve\",\"final_sku\":\"099-24881\",\"quantity\":1,\"product_price\":\"0.0\",\"options_price\":\"0.0\",\"total_price\":\"0.0\",\"tax_price\":null,\"unit_price\":\"0.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":556927,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"color\",\"option_id\":6212797,\"sub_option_id\":12796337}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]},{\"id\":10387399,\"name\":\"Mouse Pad\",\"final_sku\":\"094-24881\",\"quantity\":1,\"product_price\":\"0.0\",\"options_price\":\"0.0\",\"total_price\":\"0.0\",\"tax_price\":null,\"unit_price\":\"0.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":556799,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"color\",\"option_id\":6219743,\"sub_option_id\":12807738}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]},{\"id\":10387528,\"name\":\"1oz Silicone Hand Sanitizer\",\"final_sku\":\"0107-24881\",\"quantity\":1,\"product_price\":\"0.0\",\"options_price\":\"0.0\",\"total_price\":\"0.0\",\"tax_price\":null,\"unit_price\":\"0.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":561032,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"color\",\"option_id\":6306247,\"sub_option_id\":12932162}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]},{\"id\":10387609,\"name\":\"1oz Silicone Hand Sanitizer\",\"final_sku\":\"0107-24887\",\"quantity\":1,\"product_price\":\"0.0\",\"options_price\":\"0.0\",\"total_price\":\"0.0\",\"tax_price\":null,\"unit_price\":\"0.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":561032,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Red\",\"option_type\":\"color\",\"option_id\":6306247,\"sub_option_id\":12932163}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[],\"shipments\":[]}\n\n==================================================\n\n","created_at":"2020-10-08T21:32:09Z","updated_at":"2020-10-08T21:32:09Z"}}
{"_id":"90723576","_score":1,"_source":{"id":90723576,"site_id":329,"organization_id":190,"site_name":"Banfield Practice Store","organization_name":"Kore Group - Kaye Smith","transaction_type":"ApiV1Orders: show","transaction_id":"920a9dff71","ip_address":"34.197.18.122","success":true,"attachment":"\n2020-10-08 15:33:12\n\nURL: https://banfield.mybrightsites.com/api/v1/orders/32901?token=*****************Q9c\nMethod: GET\nParams: {\"token\":\"*****************Q9c\",\"format\":\"json\",\"controller\":\"website/api/v1/orders\",\"action\":\"show\",\"id\":\"32901\"}\nResponse: {\"order_id\":32901,\"custom_data_collections\":[{\"title\":\"Type of delivery\",\"attributes\":[{\"key\":\"I'm shipping to a\",\"value\":[\"Residence\"]}],\"price_modifier\":{\"modifier_type\":\"$\",\"amount\":\"0.0\"}}],\"customer_email\":\"julian.lopez@banfield.com\",\"customer_id\":2388724,\"username\":\"Juli123\",\"item_total\":\"10.0\",\"grand_total\":\"10.0\",\"required_adjustments\":[{\"amount\":\"0.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"}],\"balance_adjustments\":[],\"payment\":{\"id\":2994404,\"authorization\":null,\"created_at\":\"2020-10-08T15:31:47.000-06:00\",\"amount\":\"10.0\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"Juli123\",\"amount\":\"$10.00\"}},\"status\":\"new\",\"date\":\"2020-10-08T15:31:59.000-06:00\",\"shipping_contact\":{\"first_name\":\"Marisel\",\"last_name\":\"Fernandez\",\"email\":\"134@gmail.com\",\"phone\":\"3058779908\"},\"shipping_address\":{\"company\":\"\",\"first_address\":\"11411 nw 7th st,\",\"second_address\":\"APT 102\",\"city\":\"Miami\",\"state\":\"Florida\",\"country\":\"United States\",\"zip\":\"33172\"},\"billing_contact\":{\"first_name\":\"Marisel\",\"last_name\":\"Fernandez\",\"email\":\"123@GMAIL.COM\",\"phone\":\"3058779908\"},\"billing_address\":{\"company\":\"\",\"first_address\":\"11411 nw 7th st,\",\"second_address\":\"APT 102\",\"city\":\"Miami\",\"state\":\"Florida\",\"country\":\"United States\",\"zip\":\"33172\"},\"shipment\":{\"tracking_number\":null,\"created_at\":\"2020-10-08T15:30:14.000-06:00\",\"ship_date\":null,\"in_hands_date\":null,\"shipping_method\":\"FREE Ground Shipping\",\"cost\":\"0.0\"},\"payments\":[{\"id\":2994404,\"authorization\":null,\"created_at\":\"2020-10-08T15:31:47.000-06:00\",\"amount\":\"10.0\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"Juli123\",\"amount\":\"$10.00\"}}],\"line_items\":[{\"id\":10546368,\"name\":\"Erasable Gel Pen\",\"final_sku\":\"7019-BLK\",\"quantity\":2,\"product_price\":\"3.0\",\"options_price\":\"0.0\",\"total_price\":\"6.0\",\"tax_price\":null,\"unit_price\":\"3.0\",\"product_id\":568265,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"general\",\"option_id\":6482485,\"sub_option_id\":13186215}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null},{\"id\":10546381,\"name\":\"Jotter Gel Pen\",\"final_sku\":\"7002-BLK\",\"quantity\":1,\"product_price\":\"2.0\",\"options_price\":\"0.0\",\"total_price\":\"2.0\",\"tax_price\":null,\"unit_price\":\"2.0\",\"product_id\":473958,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"general\",\"option_id\":5060714,\"sub_option_id\":10756023}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null},{\"id\":10546391,\"name\":\"Jotter Gel Pen\",\"final_sku\":\"7002-GRY\",\"quantity\":1,\"product_price\":\"2.0\",\"options_price\":\"0.0\",\"total_price\":\"2.0\",\"tax_price\":null,\"unit_price\":\"2.0\",\"product_id\":473958,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Grey\",\"option_type\":\"general\",\"option_id\":5060714,\"sub_option_id\":10756024}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[]}\n\n==================================================\n\n","created_at":"2020-10-08T21:33:12Z","updated_at":"2020-10-08T21:33:12Z"}}
{"_id":90723682,"site_id":1798,"organization_id":356,"site_name":"The Corporate Store","organization_name":"Facilis","transaction_type":"ApiV1Point1Minor6Orders: show","transaction_id":"1e09f03485","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:33:56\n\nURL: https://thecorporatestore.mybrightsites.com/api/v1.1.7/orders/1129?token=*****************tBa\nMethod: GET\nParams: {\"token\":\"*****************tBa\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor6/orders\",\"action\":\"show\",\"id\":\"1129\"}\nResponse: {\"order_id\":1129,\"custom_data_collections\":[{\"title\":\"Test\",\"attributes\":[{\"key\":\"First Name\",\"value\":\"Hannah\"}],\"price_modifier\":{\"modifier_type\":\"$\",\"amount\":\"0.0\"}},{\"title\":\"Test\",\"attributes\":[{\"key\":\"LABEL\",\"value\":\"TEST LABEL\"}],\"price_modifier\":{\"modifier_type\":\"$\",\"amount\":\"0.0\"}}],\"customer_email\":\"aaubry@facilisgroup.com\",\"customer_id\":679349,\"username\":\"testi48\",\"item_total\":\"768.0\",\"grand_total\":\"865.81\",\"required_adjustments\":[{\"amount\":\"50.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"},{\"amount\":\"47.81\",\"modifier_type\":\"$\",\"note\":\"sales tax\"}],\"balance_adjustments\":[],\"payment\":{\"id\":1165863,\"authorization\":null,\"created_at\":\"2018-10-16T11:33:30.000-06:00\",\"amount\":\"865.81\",\"state\":\"completed\",\"details\":{\"method\":\"Custom payment\",\"custom method name\":\"Purchase Order\",\"details\":\"St. Louis\",\"amount\":\"$865.81\"}},\"status\":\"moas_pending\",\"date\":\"2018-10-16T11:33:34.000-06:00\",\"site_id\":1798,\"site_name\":\"The Corporate Store\",\"site_url\":\"https://thecorporatestore.mybrightsites.com\",\"organization_name\":\"Facilis\",\"organization_id\":356,\"custom_store_id\":\"\",\"shipping_contact\":{\"first_name\":\"Western\",\"last_name\":\"Cardinal 12880\",\"email\":\"aaubry@facilisgroup.com\",\"phone\":\"7177777777\"},\"shipping_address\":{\"company\":\"\",\"first_address\":\"712 S Adams\",\"second_address\":\"\",\"city\":\"Raymore\",\"state\":\"Missouri\",\"country\":\"United States\",\"zip\":\"64083\"},\"billing_contact\":{\"first_name\":\"Western\",\"last_name\":\"Cardinal 12880\",\"email\":\"aaubry@facilisgroup.com\",\"phone\":\"7177777777\"},\"billing_address\":{\"company\":\"\",\"first_address\":\"712 S Adams\",\"second_address\":\"\",\"city\":\"Raymore\",\"state\":\"Missouri\",\"country\":\"United States\",\"zip\":\"64083\"},\"shipment\":{\"tracking_number\":null,\"created_at\":\"2018-10-16T11:33:08.000-06:00\",\"ship_date\":null,\"in_hands_date\":null,\"shipping_method\":\"Ground\",\"cost\":\"50.0\"},\"payments\":[{\"id\":1165863,\"authorization\":null,\"created_at\":\"2018-10-16T11:33:30.000-06:00\",\"amount\":\"865.81\",\"state\":\"completed\",\"details\":{\"method\":\"Custom payment\",\"custom method name\":\"Purchase Order\",\"details\":\"St. Louis\",\"amount\":\"$865.81\"}}],\"line_items\":[{\"id\":4286184,\"name\":\"Corona Deluxe Drawstring Sportspack\",\"final_sku\":\"2075-02\",\"quantity\":96,\"product_price\":\"12.07\",\"options_price\":\"0.0\",\"total_price\":\"768.0\",\"tax_price\":null,\"unit_price\":\"8.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":170729,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[],\"logos\":[{\"name\":\"HB Logo\",\"charge\":null,\"image_url\":\"https://assets.mybrightsites.com/uploads/website/line_item_logo/image/10-16-2018/92403/HB_Logo.png\",\"supplier_id\":null,\"location\":null,\"decoration\":null}],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[],\"shipments\":[]}\n\n==================================================\n\n","created_at":"2020-10-08T21:33:56Z","updated_at":"2020-10-08T21:33:56Z"}}
{"_id":90723669,"site_id":3790,"organization_id":356,"site_name":"Hannah's Test Site","organization_name":"Facilis","transaction_type":"ApiV1Point1Minor6Orders: show","transaction_id":"74ddcfbb9d","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:33:51\n\nURL: https://hannahtest.mybrightsites.com/api/v1.1.7/orders/1?token=*****************NHB\nMethod: GET\nParams: {\"token\":\"*****************NHB\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor6/orders\",\"action\":\"show\",\"id\":\"1\"}\nResponse: {\"order_id\":1,\"custom_data_collections\":[],\"customer_email\":\"hschell@facilisgroup.com\",\"customer_id\":1399399,\"username\":\"hmschell1s\",\"item_total\":\"40.48\",\"grand_total\":\"50.21\",\"required_adjustments\":[{\"amount\":\"5.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"},{\"amount\":\"4.73\",\"modifier_type\":\"$\",\"note\":\"sales tax\"}],\"balance_adjustments\":[],\"payment\":{\"id\":1594302,\"authorization\":null,\"created_at\":\"2019-04-16T14:54:04.000-06:00\",\"amount\":\"50.21\",\"state\":\"completed\",\"details\":{\"method\":\"Custom payment\",\"custom method name\":\"Purchase Order\",\"details\":\"stl\",\"amount\":\"$50.21\"}},\"status\":\"moas_pending\",\"date\":\"2019-04-16T14:54:07.000-06:00\",\"site_id\":3790,\"site_name\":\"Hannah's Test Site\",\"site_url\":\"https://hannahtest.mybrightsites.com\",\"organization_name\":\"Facilis\",\"organization_id\":356,\"custom_store_id\":null,\"shipping_contact\":{\"first_name\":\"Hannah\",\"last_name\":\"Schell\",\"email\":\"hschell@facilisgroup.com\",\"phone\":\"6362328171\"},\"shipping_address\":{\"company\":\"Hannah's Test Company\",\"first_address\":\"1013 Parc Central \",\"second_address\":\"\",\"city\":\"Festus\",\"state\":\"Missouri\",\"country\":\"United States\",\"zip\":\"63028\"},\"billing_contact\":{\"first_name\":\"Hannah\",\"last_name\":\"Schell\",\"email\":\"hschell@facilisgroup.com\",\"phone\":\"6362328171\"},\"billing_address\":{\"company\":\"Hannah's Test Company\",\"first_address\":\"1013 Parc Central \",\"second_address\":\"\",\"city\":\"Festus\",\"state\":\"Missouri\",\"country\":\"United States\",\"zip\":\"63028\"},\"shipment\":{\"tracking_number\":null,\"created_at\":\"2019-04-16T14:53:40.000-06:00\",\"ship_date\":null,\"in_hands_date\":null,\"shipping_method\":\"Ground\",\"cost\":\"5.0\"},\"payments\":[{\"id\":1594302,\"authorization\":null,\"created_at\":\"2019-04-16T14:54:04.000-06:00\",\"amount\":\"50.21\",\"state\":\"completed\",\"details\":{\"method\":\"Custom payment\",\"custom method name\":\"Purchase Order\",\"details\":\"stl\",\"amount\":\"$50.21\"}}],\"line_items\":[{\"id\":5703057,\"name\":\"Game Day Lounge Chair\",\"final_sku\":\"HS114-17718\",\"quantity\":1,\"product_price\":\"38.98\",\"options_price\":\"0.0\",\"total_price\":\"40.48\",\"tax_price\":null,\"unit_price\":\"40.48\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":366172,\"final_internal_id\":null,\"tax_code\":\"\",\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"color\",\"option_id\":3634677,\"sub_option_id\":7412316}],\"logos\":[{\"name\":\"Generic Logo 2\",\"charge\":\"1.5\",\"image_url\":\"https://assets.mybrightsites.com/uploads/website/line_item_logo/image/04-16-2019/120135/HB_Logo.png\",\"supplier_id\":\"\",\"location\":null,\"decoration\":null}],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null,\"vendors\":[]}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[],\"shipments\":[]}\n\n==================================================\n\n","created_at":"2020-10-08T21:33:51Z","updated_at":"2020-10-08T21:33:51Z"}}
{"_id":90723923,"site_id":3176,"organization_id":801,"site_name":"Affinity","organization_name":"Impact Marketing","transaction_type":"ApiV1Point1Minor2Orders: update","transaction_id":"4b54da5ab3","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:36:09\n\nURL: https://shopaffinity.mybrightsites.com/api/v1.1.7/orders/2345?token=*****************DJr\nMethod: PUT\nParams: {\"order\":{\"status\":\"completed\",\"tracking_number\":\"PUROLATOR PIN: 332479742428\",\"ship_date\":\"2020-09-15\"},\"token\":\"*****************DJr\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor2/orders\",\"action\":\"update\",\"id\":\"2345\"}\nResponse: {\"order_id\":2345,\"custom_data_collections\":[],\"customer_email\":\"lorraine.worobec@affinitycu.ca\",\"customer_id\":844974,\"username\":\"Lorraine.Worobec@affinitycu.ca\",\"item_total\":\"90.0\",\"grand_total\":\"99.9\",\"required_adjustments\":[{\"amount\":\"0.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"},{\"amount\":\"9.9\",\"modifier_type\":\"$\",\"note\":\"sales tax\"}],\"balance_adjustments\":[],\"payment\":{\"id\":2853270,\"authorization\":null,\"created_at\":\"2020-08-27T11:28:02.000-06:00\",\"amount\":\"99.9\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"Lorraine.Worobec@affinitycu.ca\",\"amount\":\"$99.90\"}},\"status\":\"completed\",\"date\":\"2020-08-27T11:28:16.000-06:00\",\"shipping_contact\":{\"first_name\":\"Lorraine\",\"last_name\":\"Worobec\",\"email\":\"lorraine.worobec@affinitycu.ca\",\"phone\":\"306-946-4207\"},\"shipping_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"210 Main St\",\"second_address\":\"Box 790\",\"city\":\"Watrous\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"S0K 4T0\"},\"billing_contact\":{\"first_name\":\"Lorraine\",\"last_name\":\"Worobec\",\"email\":\"lorraine.worobec@affinitycu.ca\",\"phone\":\"306-946-4207\"},\"billing_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"Enter Billing Address\",\"second_address\":\"\",\"city\":\"Enter Billing City\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"Postal Code\"},\"shipment\":{\"tracking_number\":\"PUROLATOR PIN: 332479742428\",\"created_at\":\"2020-08-27T11:27:07.000-06:00\",\"ship_date\":\"2020-09-15\",\"in_hands_date\":null,\"shipping_method\":\"No Shipping Method\",\"cost\":\"0.0\"},\"payments\":[{\"id\":2853270,\"authorization\":null,\"created_at\":\"2020-08-27T11:28:02.000-06:00\",\"amount\":\"99.9\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"Lorraine.Worobec@affinitycu.ca\",\"amount\":\"$99.90\"}}],\"line_items\":[{\"id\":10078605,\"name\":\"Women's Equinox Knit Blazer\",\"final_sku\":\"98613-2742-1403\",\"quantity\":1,\"product_price\":\"90.0\",\"options_price\":\"0.0\",\"total_price\":\"90.0\",\"tax_price\":\"9.9\",\"unit_price\":\"90.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":518061,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Heather Grey\",\"option_type\":\"color\",\"option_id\":5788119,\"sub_option_id\":12035562},{\"option_name\":\"Size\",\"sub_option_name\":\"XL\",\"option_type\":\"general\",\"option_id\":5788120,\"sub_option_id\":12035567}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[{\"username\":\"API\",\"created_at\":\"2020-09-15T08:52:24.000-06:00\",\"note\":\"@ease order # 52917-1\"}]}\n\n==================================================\n\n","created_at":"2020-10-08T21:36:09Z","updated_at":"2020-10-08T21:36:10Z"}}
{"_id":90723920,"site_id":3176,"organization_id":801,"site_name":"Affinity","organization_name":"Impact Marketing","transaction_type":"ApiV1Point1Minor2Orders: update","transaction_id":"7a8e71cd08","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:36:09\n\nURL: https://shopaffinity.mybrightsites.com/api/v1.1.7/orders/2339?token=*****************DJr\nMethod: PUT\nParams: {\"order\":{\"status\":\"completed\",\"tracking_number\":\"PUROLATOR PIN: 332479719913\",\"ship_date\":\"2020-09-15\"},\"token\":\"*****************DJr\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor2/orders\",\"action\":\"update\",\"id\":\"2339\"}\nResponse: {\"order_id\":2339,\"custom_data_collections\":[],\"customer_email\":\"tami.halvorson@affinitycu.ca\",\"customer_id\":844473,\"username\":\"tami.halvorson@affinitycu.ca\",\"item_total\":\"209.0\",\"grand_total\":\"231.99\",\"required_adjustments\":[{\"amount\":\"0.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"},{\"amount\":\"22.99\",\"modifier_type\":\"$\",\"note\":\"sales tax\"}],\"balance_adjustments\":[],\"payment\":{\"id\":2844129,\"authorization\":null,\"created_at\":\"2020-08-25T09:16:59.000-06:00\",\"amount\":\"231.99\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"tami.halvorson@affinitycu.ca\",\"amount\":\"$231.99\"}},\"status\":\"completed\",\"date\":\"2020-08-25T09:17:28.000-06:00\",\"shipping_contact\":{\"first_name\":\"Tami\",\"last_name\":\"Halvorson\",\"email\":\"tami.halvorson@affinitycu.ca\",\"phone\":\"306-523-7105\"},\"shipping_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"4035 Albert St\",\"second_address\":\"\",\"city\":\"Regina\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"S4S 3R6\"},\"billing_contact\":{\"first_name\":\"Tami\",\"last_name\":\"Halvorson\",\"email\":\"tami.halvorson@affinitycu.ca\",\"phone\":\"306-523-7105\"},\"billing_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"4035 Albert St\",\"second_address\":\"\",\"city\":\"Regina\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"S4S 3R6\"},\"shipment\":{\"tracking_number\":\"PUROLATOR PIN: 332479719913\",\"created_at\":\"2020-08-25T09:15:47.000-06:00\",\"ship_date\":\"2020-09-15\",\"in_hands_date\":null,\"shipping_method\":\"No Shipping Method\",\"cost\":\"0.0\"},\"payments\":[{\"id\":2844129,\"authorization\":null,\"created_at\":\"2020-08-25T09:16:59.000-06:00\",\"amount\":\"231.99\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"tami.halvorson@affinitycu.ca\",\"amount\":\"$231.99\"}}],\"line_items\":[{\"id\":10050235,\"name\":\"Women's Chelsea Open Cardigan \",\"final_sku\":\"KNB-2W-2016-1403\",\"quantity\":1,\"product_price\":\"69.0\",\"options_price\":\"0.0\",\"total_price\":\"69.0\",\"tax_price\":\"7.59\",\"unit_price\":\"69.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":518101,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"color\",\"option_id\":5788757,\"sub_option_id\":12036640},{\"option_name\":\"Size\",\"sub_option_name\":\"XL\",\"option_type\":\"general\",\"option_id\":5788758,\"sub_option_id\":12036646}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null},{\"id\":10050312,\"name\":\"Women's Ashland Knit Cardi\",\"final_sku\":\"98213-2028-1402\",\"quantity\":1,\"product_price\":\"57.0\",\"options_price\":\"0.0\",\"total_price\":\"57.0\",\"tax_price\":\"6.27\",\"unit_price\":\"57.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":520671,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Heather Dark Charcoal\",\"option_type\":\"color\",\"option_id\":5824286,\"sub_option_id\":12093951},{\"option_name\":\"Size\",\"sub_option_name\":\"Large\",\"option_type\":\"general\",\"option_id\":5824287,\"sub_option_id\":12093957}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null},{\"id\":10050367,\"name\":\"Women's Belcarra Softshell\",\"final_sku\":\"KSL-1W-2514-1403\",\"quantity\":1,\"product_price\":\"83.0\",\"options_price\":\"0.0\",\"total_price\":\"83.0\",\"tax_price\":\"9.13\",\"unit_price\":\"83.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":518127,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Dolphin Grey\",\"option_type\":\"color\",\"option_id\":5789108,\"sub_option_id\":12037320},{\"option_name\":\"Size\",\"sub_option_name\":\"XL\",\"option_type\":\"general\",\"option_id\":5789109,\"sub_option_id\":12037325}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[{\"username\":\"API\",\"created_at\":\"2020-09-15T08:41:03.000-06:00\",\"note\":\"@ease order # 52913-1\"}]}\n\n==================================================\n\n","created_at":"2020-10-08T21:36:09Z","updated_at":"2020-10-08T21:36:09Z"}}
{"_id":90723916,"site_id":3176,"organization_id":801,"site_name":"Affinity","organization_name":"Impact Marketing","transaction_type":"ApiV1Point1Minor2Orders: update","transaction_id":"3ba208d89e","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:36:08\n\nURL: https://shopaffinity.mybrightsites.com/api/v1.1.7/orders/2343?token=*****************DJr\nMethod: PUT\nParams: {\"order\":{\"status\":\"completed\",\"tracking_number\":\"PUROLATOR PIN: 332479778075\",\"ship_date\":\"2020-09-15\"},\"token\":\"*****************DJr\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor2/orders\",\"action\":\"update\",\"id\":\"2343\"}\nResponse: {\"order_id\":2343,\"custom_data_collections\":[],\"customer_email\":\"chera.guderyan@affinitycu.ca\",\"customer_id\":844460,\"username\":\"chera.guderyan@affinitycu.ca\",\"item_total\":\"83.0\",\"grand_total\":\"92.13\",\"required_adjustments\":[{\"amount\":\"0.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"},{\"amount\":\"9.13\",\"modifier_type\":\"$\",\"note\":\"sales tax\"}],\"balance_adjustments\":[],\"payment\":{\"id\":2849276,\"authorization\":null,\"created_at\":\"2020-08-26T10:53:50.000-06:00\",\"amount\":\"75.0\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"chera.guderyan@affinitycu.ca\",\"amount\":\"$75.00\"}},\"status\":\"completed\",\"date\":\"2020-08-26T10:54:05.000-06:00\",\"shipping_contact\":{\"first_name\":\"Chera\",\"last_name\":\"Guderyan\",\"email\":\"chera.guderyan@affinitycu.ca\",\"phone\":\"3068654610\"},\"shipping_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"208 Churchill St\",\"second_address\":\"Box 538\",\"city\":\"Hudson Bay\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"S0E 0Y0\"},\"billing_contact\":{\"first_name\":\"Chera\",\"last_name\":\"Guderyan\",\"email\":\"chera.guderyan@affinitycu.ca\",\"phone\":\"3068654610\"},\"billing_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"Enter Billing Address\",\"second_address\":\"\",\"city\":\"Enter Billing City\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"Postal Code\"},\"shipment\":{\"tracking_number\":\"PUROLATOR PIN: 332479778075\",\"created_at\":\"2020-08-26T10:52:39.000-06:00\",\"ship_date\":\"2020-09-15\",\"in_hands_date\":null,\"shipping_method\":\"No Shipping Method\",\"cost\":\"0.0\"},\"payments\":[{\"id\":2849276,\"authorization\":null,\"created_at\":\"2020-08-26T10:53:50.000-06:00\",\"amount\":\"75.0\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"chera.guderyan@affinitycu.ca\",\"amount\":\"$75.00\"}},{\"id\":2849277,\"authorization\":\"eOxUQPIahFkllYxSwiRFpC9IJd\",\"created_at\":\"2020-08-26T10:53:50.000-06:00\",\"amount\":\"17.13\",\"state\":\"completed\",\"details\":{\"method\":\"credit card\",\"card type\":\"Master\",\"card\":\"**** **** **** 0383\",\"amount\":\"$17.13\"}}],\"line_items\":[{\"id\":10065305,\"name\":\"Women's Belcarra Softshell\",\"final_sku\":\"KSL-1W-2016-1401\",\"quantity\":1,\"product_price\":\"83.0\",\"options_price\":\"0.0\",\"total_price\":\"83.0\",\"tax_price\":\"9.13\",\"unit_price\":\"83.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":518127,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Black\",\"option_type\":\"color\",\"option_id\":5789108,\"sub_option_id\":12037319},{\"option_name\":\"Size\",\"sub_option_name\":\"Medium\",\"option_type\":\"general\",\"option_id\":5789109,\"sub_option_id\":12037323}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[{\"username\":\"API\",\"created_at\":\"2020-09-15T09:03:56.000-06:00\",\"note\":\"@ease order # 52916-1\"}]}\n\n==================================================\n\n","created_at":"2020-10-08T21:36:08Z","updated_at":"2020-10-08T21:36:08Z"}}
{"_id":90723926,"site_id":3176,"organization_id":801,"site_name":"Affinity","organization_name":"Impact Marketing","transaction_type":"ApiV1Point1Minor2Orders: update","transaction_id":"381b968ea9","ip_address":"192.211.124.28","success":true,"attachment":"\n2020-10-08 15:36:10\n\nURL: https://shopaffinity.mybrightsites.com/api/v1.1.7/orders/2346?token=*****************DJr\nMethod: PUT\nParams: {\"order\":{\"status\":\"completed\",\"tracking_number\":\"PUROLATOR PIN: 332479963511\",\"ship_date\":\"2020-09-15\"},\"token\":\"*****************DJr\",\"format\":\"json\",\"controller\":\"website/api/v1_point1_minor2/orders\",\"action\":\"update\",\"id\":\"2346\"}\nResponse: {\"order_id\":2346,\"custom_data_collections\":[],\"customer_email\":\"dstadnick@hotmail.com\",\"customer_id\":844893,\"username\":\"dstadnick@hotmail.com\",\"item_total\":\"84.0\",\"grand_total\":\"93.24\",\"required_adjustments\":[{\"amount\":\"0.0\",\"modifier_type\":\"$\",\"note\":\"shipment\"},{\"amount\":\"9.24\",\"modifier_type\":\"$\",\"note\":\"sales tax\"}],\"balance_adjustments\":[],\"payment\":{\"id\":2853274,\"authorization\":null,\"created_at\":\"2020-08-27T11:28:30.000-06:00\",\"amount\":\"75.0\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"dstadnick@hotmail.com\",\"amount\":\"$75.00\"}},\"status\":\"completed\",\"date\":\"2020-08-27T11:29:03.000-06:00\",\"shipping_contact\":{\"first_name\":\"Dyon\",\"last_name\":\"Stadnick\",\"email\":\"dstadnick@hotmail.com\",\"phone\":\"306-482-8008\"},\"shipping_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"119 Broadway St\",\"second_address\":\"Box 368\",\"city\":\"Carnduff\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"S0C 0S0\"},\"billing_contact\":{\"first_name\":\"Dyon\",\"last_name\":\"Stadnick\",\"email\":\"dstadnick@hotmail.com\",\"phone\":\"306-482-8008\"},\"billing_address\":{\"company\":\"Affinity Credit Union\",\"first_address\":\"Box 396\",\"second_address\":\"\",\"city\":\"Carnduff\",\"state\":\"Saskatchewan\",\"country\":\"Canada\",\"zip\":\"S0C 0S0\"},\"shipment\":{\"tracking_number\":\"PUROLATOR PIN: 332479963511\",\"created_at\":\"2020-08-27T11:25:15.000-06:00\",\"ship_date\":\"2020-09-15\",\"in_hands_date\":null,\"shipping_method\":\"No Shipping Method\",\"cost\":\"0.0\"},\"payments\":[{\"id\":2853274,\"authorization\":null,\"created_at\":\"2020-08-27T11:28:30.000-06:00\",\"amount\":\"75.0\",\"state\":\"completed\",\"details\":{\"method\":\"Balance payment\",\"user\":\"dstadnick@hotmail.com\",\"amount\":\"$75.00\"}},{\"id\":2853275,\"authorization\":\"7PcLTvDExf5SiBTwoEST5DMCcsp\",\"created_at\":\"2020-08-27T11:28:30.000-06:00\",\"amount\":\"18.24\",\"state\":\"completed\",\"details\":{\"method\":\"credit card\",\"card type\":\"Master\",\"card\":\"**** **** **** 5774\",\"amount\":\"$18.24\"}}],\"line_items\":[{\"id\":10078516,\"name\":\"Men's Kaiser Knit Lightweight Full Zip\",\"final_sku\":\"18212-2200-1403\",\"quantity\":1,\"product_price\":\"84.0\",\"options_price\":\"0.0\",\"total_price\":\"84.0\",\"tax_price\":\"9.24\",\"unit_price\":\"84.0\",\"pdf_status\":\"not_available\",\"pdf_file_url\":null,\"product_id\":354629,\"final_internal_id\":null,\"product_options\":[{\"option_name\":\"Color\",\"sub_option_name\":\"Olympic Blue Heather\",\"option_type\":\"color\",\"option_id\":3423366,\"sub_option_id\":6904672},{\"option_name\":\"Size\",\"sub_option_name\":\"XL\",\"option_type\":\"size\",\"option_id\":3423942,\"sub_option_id\":6904709}],\"logos\":[],\"product_personalizations\":[],\"split_items\":[],\"decoration_method\":null,\"gift_certificate\":null}],\"coupons_adjustments\":[],\"custom_adjustments\":[],\"notes\":[{\"username\":\"API\",\"created_at\":\"2020-09-15T09:50:08.000-06:00\",\"note\":\"@ease order # 52918-1\"}]}\n\n==================================================\n\n","created_at":"2020-10-08T21:36:10Z","updated_at":"2020-10-08T21:36:10Z"}}One Time Sale.
Session ID: 0576fbef53694331a52e5d4bf65aa9827320eeaf808cc8e15d20388fa9c720fd66
qTox: E39454B3027ADEAECD7EFE69EE106689394E2F38D0854F0AB056257B4399DC33CB204782DFA1