{"columns":[{"name":"id","type":"string"},{"name":"tenant_id","type":"string"},{"name":"bc_order_id","type":"int64"},{"name":"order_status","type":"string"},{"name":"order_payment_status","type":"string"},{"name":"order_number","type":"string"},{"name":"is_non_taxable","type":"string"},{"name":"date_completed","type":"timestamp[ns]"},{"name":"subtotal_ex_tax","type":"decimal128(28, 6)"},{"name":"subtotal_inc_tax","type":"decimal128(28, 6)"},{"name":"shipping_total_ex_tax","type":"decimal128(28, 6)"},{"name":"shipping_total_inc_tax","type":"decimal128(28, 6)"},{"name":"handling_cost_ex_tax","type":"decimal128(28, 6)"},{"name":"handling_cost_inc_tax","type":"decimal128(28, 6)"},{"name":"total_ex_tax","type":"decimal128(28, 6)"},{"name":"total_inc_tax","type":"decimal128(28, 6)"},{"name":"future_ship_date","type":"timestamp[ns]"},{"name":"currency","type":"string"},{"name":"bypass_fulfillment","type":"string"},{"name":"created_at","type":"timestamp[ns]"},{"name":"updated_at","type":"timestamp[ns]"},{"name":"staff_notes","type":"string"},{"name":"deleted_at","type":"timestamp[ns]"},{"name":"original_order_date","type":"timestamp[ns]"},{"name":"club_id","type":"string"},{"name":"release_id","type":"string"},{"name":"membership_id","type":"string"},{"name":"is_draft","type":"string"},{"name":"undraft_process_in_progress","type":"string"},{"name":"bc_cart_id","type":"string"},{"name":"bc_channel_id","type":"int64"},{"name":"fulfillment_status","type":"string"},{"name":"wdc_website_id","type":"string"},{"name":"wdc_order_id","type":"string"},{"name":"wdc_member_id","type":"string"},{"name":"discount_amount","type":"decimal128(28, 6)"},{"name":"advanced_compliance_status","type":"string"},{"name":"delivery_method","type":"string"},{"name":"bc_pickup_method_id","type":"int64"},{"name":"club_option_id","type":"string"},{"name":"anwd_channel_name","type":"string"},{"name":"anwd_channel_type","type":"string"},{"name":"anwd_channel_id","type":"string"},{"name":"anwd_order_type","type":"string"},{"name":"processing_status","type":"string"},{"name":"customer_notes","type":"string"},{"name":"commit_status","type":"string"},{"name":"sales_associate_id","type":"string"},{"name":"department_id","type":"string"},{"name":"anwd_payment_status","type":"string"},{"name":"stored_card_id","type":"string"},{"name":"bc_consignment_pickup_id","type":"int32"},{"name":"comments","type":"string"},{"name":"sale_type","type":"string"},{"name":"shipment_status","type":"string"},{"name":"payments","type":"list<element: struct<id: string, tenant_id: string, order_level: string, bc_transaction_id: int64, payment_status: string, payment_timestamp: timestamp[ns], is_successful: string, amount: decimal128(28, 6), currency: string, gateway: string, gateway_transaction_id: string, fraud_review: string, payment_type: string, credit_card_type: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], gateway_response: string>>"},{"name":"billing_infos","type":"list<element: struct<id: string, tenant_id: string, order_level: string, first_name: string, last_name: string, company: string, street_1: string, street_2: string, city: string, zip: string, subdivision: string, country: string, phone: string, email: string, amount: decimal128(28, 6), created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, payment_id: string, deleted_at: timestamp[ns], purchaser_date_of_birth: timestamp[ns]>>"},{"name":"discounts","type":"list<element: struct<id: string, tenant_id: string, order_level: string, discount_type: string, discount_amount: decimal128(28, 6), discount_unit: string, discount_value: decimal128(28, 6), currency: string, discount_name: string, discount_code: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns]>>"},{"name":"order_items","type":"list<element: struct<id: string, tenant_id: string, bc_order_product_id: int64, bc_product_variant_id: int64, variant_id: string, external_sku: string, quantity: int32, product_id: string, bc_product_id: int64, is_digital_product: string, weight: decimal128(28, 6), weight_unit: string, is_non_taxable: string, is_price_override: string, original_price: decimal128(28, 6), total_price_ex_tax: decimal128(28, 6), total_price_inc_tax: decimal128(28, 6), deposit: decimal128(28, 6), currency: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, deleted_at: timestamp[ns], bc_parent_order_product_id: int64, is_bundled_product: string, product_name: string, product_type_name: string, product_sku: string, price_ex_tax: decimal128(28, 6), price_inc_tax: decimal128(28, 6)>>"},{"name":"order_item_groups","type":"list<element: struct<id: string, tenant_id: string, is_bundle: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, deleted_at: timestamp[ns]>>"},{"name":"order_options","type":"list<element: struct<id: string, tenant_id: string, order_level: string, option_type: string, option_value: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], bc_option_id: int64, bc_option_value: string>>"},{"name":"refunds","type":"list<element: struct<id: string, tenant_id: string, order_level: string, refund_amount: decimal128(28, 6), currency: string, refund_type: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, payment_id: string, order_payment_id: string, bc_order_payment_id: int64, deleted_at: timestamp[ns]>>"},{"name":"shipping_infos","type":"list<element: struct<id: string, tenant_id: string, order_level: string, bc_shipping_id: int64, total_items_count: int32, first_name: string, last_name: string, company: string, street_1: string, street_2: string, city: string, zip: string, subdivision: string, country: string, phone: string, email: string, shipping_cost_ex_tax: decimal128(28, 6), shipping_cost_inc_tax: decimal128(28, 6), handling_cost_ex_tax: decimal128(28, 6), handling_cost_inc_tax: decimal128(28, 6), is_shipping_price_override: string, original_price: decimal128(28, 6), shipping_total_wo_discount: decimal128(28, 6), shipping_total_with_discount: decimal128(28, 6), currency: string, shipping_instructions: string, future_ship_date: timestamp[ns], created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], shipping_method: string, recipient_date_of_birth: timestamp[ns], bc_shipping_zone_id: int64>>"},{"name":"taxes","type":"list<element: struct<id: string, tenant_id: string, order_level: string, tax_type: string, tax_rate: decimal128(28, 6), tax_amount: decimal128(28, 6), currency: string, included_in_price: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], name: string>>"},{"name":"order_bc_customers","type":"list<element: struct<id: string, tenant_id: string, order_id: string, bc_customer_id: int64, created_at: timestamp[ns], updated_at: timestamp[ns], deleted_at: timestamp[ns]>>"}],"n_rows":18,"rows_kept":18,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-mr version 1.12.2 (build ${buildNumber})","schema":{"fields":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_order_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"order_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_payment_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"is_non_taxable","type":"string","nullable":true,"metadata":null,"children":null},{"name":"date_completed","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"subtotal_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"subtotal_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"shipping_total_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"shipping_total_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"handling_cost_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"handling_cost_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"total_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"total_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"future_ship_date","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bypass_fulfillment","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"staff_notes","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"original_order_date","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"club_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"release_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"membership_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"is_draft","type":"string","nullable":true,"metadata":null,"children":null},{"name":"undraft_process_in_progress","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_cart_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_channel_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"fulfillment_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"wdc_website_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"wdc_order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"wdc_member_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"discount_amount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"advanced_compliance_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"delivery_method","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_pickup_method_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"club_option_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"anwd_channel_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"anwd_channel_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"anwd_channel_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"anwd_order_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"processing_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"customer_notes","type":"string","nullable":true,"metadata":null,"children":null},{"name":"commit_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sales_associate_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"department_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"anwd_payment_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"stored_card_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_consignment_pickup_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"comments","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sale_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"shipment_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payments","type":"list<element: struct<id: string, tenant_id: string, order_level: string, bc_transaction_id: int64, payment_status: string, payment_timestamp: timestamp[ns], is_successful: string, amount: decimal128(28, 6), currency: string, gateway: string, gateway_transaction_id: string, fraud_review: string, payment_type: string, credit_card_type: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], gateway_response: string>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, bc_transaction_id: int64, payment_status: string, payment_timestamp: timestamp[ns], is_successful: string, amount: decimal128(28, 6), currency: string, gateway: string, gateway_transaction_id: string, fraud_review: string, payment_type: string, credit_card_type: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], gateway_response: string>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_transaction_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"payment_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payment_timestamp","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"is_successful","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gateway","type":"string","nullable":true,"metadata":null,"children":null},{"name":"gateway_transaction_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"fraud_review","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payment_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"credit_card_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"gateway_response","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"billing_infos","type":"list<element: struct<id: string, tenant_id: string, order_level: string, first_name: string, last_name: string, company: string, street_1: string, street_2: string, city: string, zip: string, subdivision: string, country: string, phone: string, email: string, amount: decimal128(28, 6), created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, payment_id: string, deleted_at: timestamp[ns], purchaser_date_of_birth: timestamp[ns]>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, first_name: string, last_name: string, company: string, street_1: string, street_2: string, city: string, zip: string, subdivision: string, country: string, phone: string, email: string, amount: decimal128(28, 6), created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, payment_id: string, deleted_at: timestamp[ns], purchaser_date_of_birth: timestamp[ns]>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"company","type":"string","nullable":true,"metadata":null,"children":null},{"name":"street_1","type":"string","nullable":true,"metadata":null,"children":null},{"name":"street_2","type":"string","nullable":true,"metadata":null,"children":null},{"name":"city","type":"string","nullable":true,"metadata":null,"children":null},{"name":"zip","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subdivision","type":"string","nullable":true,"metadata":null,"children":null},{"name":"country","type":"string","nullable":true,"metadata":null,"children":null},{"name":"phone","type":"string","nullable":true,"metadata":null,"children":null},{"name":"email","type":"string","nullable":true,"metadata":null,"children":null},{"name":"amount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payment_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"purchaser_date_of_birth","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null}]}]},{"name":"discounts","type":"list<element: struct<id: string, tenant_id: string, order_level: string, discount_type: string, discount_amount: decimal128(28, 6), discount_unit: string, discount_value: decimal128(28, 6), currency: string, discount_name: string, discount_code: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns]>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, discount_type: string, discount_amount: decimal128(28, 6), discount_unit: string, discount_value: decimal128(28, 6), currency: string, discount_name: string, discount_code: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns]>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"discount_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"discount_amount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"discount_unit","type":"string","nullable":true,"metadata":null,"children":null},{"name":"discount_value","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"discount_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"discount_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null}]}]},{"name":"order_items","type":"list<element: struct<id: string, tenant_id: string, bc_order_product_id: int64, bc_product_variant_id: int64, variant_id: string, external_sku: string, quantity: int32, product_id: string, bc_product_id: int64, is_digital_product: string, weight: decimal128(28, 6), weight_unit: string, is_non_taxable: string, is_price_override: string, original_price: decimal128(28, 6), total_price_ex_tax: decimal128(28, 6), total_price_inc_tax: decimal128(28, 6), deposit: decimal128(28, 6), currency: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, deleted_at: timestamp[ns], bc_parent_order_product_id: int64, is_bundled_product: string, product_name: string, product_type_name: string, product_sku: string, price_ex_tax: decimal128(28, 6), price_inc_tax: decimal128(28, 6)>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, bc_order_product_id: int64, bc_product_variant_id: int64, variant_id: string, external_sku: string, quantity: int32, product_id: string, bc_product_id: int64, is_digital_product: string, weight: decimal128(28, 6), weight_unit: string, is_non_taxable: string, is_price_override: string, original_price: decimal128(28, 6), total_price_ex_tax: decimal128(28, 6), total_price_inc_tax: decimal128(28, 6), deposit: decimal128(28, 6), currency: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, deleted_at: timestamp[ns], bc_parent_order_product_id: int64, is_bundled_product: string, product_name: string, product_type_name: string, product_sku: string, price_ex_tax: decimal128(28, 6), price_inc_tax: decimal128(28, 6)>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_order_product_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"bc_product_variant_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"variant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"external_sku","type":"string","nullable":true,"metadata":null,"children":null},{"name":"quantity","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"product_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_product_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"is_digital_product","type":"string","nullable":true,"metadata":null,"children":null},{"name":"weight","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"weight_unit","type":"string","nullable":true,"metadata":null,"children":null},{"name":"is_non_taxable","type":"string","nullable":true,"metadata":null,"children":null},{"name":"is_price_override","type":"string","nullable":true,"metadata":null,"children":null},{"name":"original_price","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"total_price_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"total_price_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"deposit","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"bc_parent_order_product_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"is_bundled_product","type":"string","nullable":true,"metadata":null,"children":null},{"name":"product_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"product_type_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"product_sku","type":"string","nullable":true,"metadata":null,"children":null},{"name":"price_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"price_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null}]}]},{"name":"order_item_groups","type":"list<element: struct<id: string, tenant_id: string, is_bundle: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, deleted_at: timestamp[ns]>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, is_bundle: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, deleted_at: timestamp[ns]>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"is_bundle","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null}]}]},{"name":"order_options","type":"list<element: struct<id: string, tenant_id: string, order_level: string, option_type: string, option_value: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], bc_option_id: int64, bc_option_value: string>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, option_type: string, option_value: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], bc_option_id: int64, bc_option_value: string>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"option_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"option_value","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"bc_option_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"bc_option_value","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"refunds","type":"list<element: struct<id: string, tenant_id: string, order_level: string, refund_amount: decimal128(28, 6), currency: string, refund_type: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, payment_id: string, order_payment_id: string, bc_order_payment_id: int64, deleted_at: timestamp[ns]>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, refund_amount: decimal128(28, 6), currency: string, refund_type: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, payment_id: string, order_payment_id: string, bc_order_payment_id: int64, deleted_at: timestamp[ns]>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"refund_amount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"refund_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payment_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_payment_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_order_payment_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null}]}]},{"name":"shipping_infos","type":"list<element: struct<id: string, tenant_id: string, order_level: string, bc_shipping_id: int64, total_items_count: int32, first_name: string, last_name: string, company: string, street_1: string, street_2: string, city: string, zip: string, subdivision: string, country: string, phone: string, email: string, shipping_cost_ex_tax: decimal128(28, 6), shipping_cost_inc_tax: decimal128(28, 6), handling_cost_ex_tax: decimal128(28, 6), handling_cost_inc_tax: decimal128(28, 6), is_shipping_price_override: string, original_price: decimal128(28, 6), shipping_total_wo_discount: decimal128(28, 6), shipping_total_with_discount: decimal128(28, 6), currency: string, shipping_instructions: string, future_ship_date: timestamp[ns], created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], shipping_method: string, recipient_date_of_birth: timestamp[ns], bc_shipping_zone_id: int64>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, bc_shipping_id: int64, total_items_count: int32, first_name: string, last_name: string, company: string, street_1: string, street_2: string, city: string, zip: string, subdivision: string, country: string, phone: string, email: string, shipping_cost_ex_tax: decimal128(28, 6), shipping_cost_inc_tax: decimal128(28, 6), handling_cost_ex_tax: decimal128(28, 6), handling_cost_inc_tax: decimal128(28, 6), is_shipping_price_override: string, original_price: decimal128(28, 6), shipping_total_wo_discount: decimal128(28, 6), shipping_total_with_discount: decimal128(28, 6), currency: string, shipping_instructions: string, future_ship_date: timestamp[ns], created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], shipping_method: string, recipient_date_of_birth: timestamp[ns], bc_shipping_zone_id: int64>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_shipping_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"total_items_count","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"company","type":"string","nullable":true,"metadata":null,"children":null},{"name":"street_1","type":"string","nullable":true,"metadata":null,"children":null},{"name":"street_2","type":"string","nullable":true,"metadata":null,"children":null},{"name":"city","type":"string","nullable":true,"metadata":null,"children":null},{"name":"zip","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subdivision","type":"string","nullable":true,"metadata":null,"children":null},{"name":"country","type":"string","nullable":true,"metadata":null,"children":null},{"name":"phone","type":"string","nullable":true,"metadata":null,"children":null},{"name":"email","type":"string","nullable":true,"metadata":null,"children":null},{"name":"shipping_cost_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"shipping_cost_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"handling_cost_ex_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"handling_cost_inc_tax","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"is_shipping_price_override","type":"string","nullable":true,"metadata":null,"children":null},{"name":"original_price","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"shipping_total_wo_discount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"shipping_total_with_discount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"shipping_instructions","type":"string","nullable":true,"metadata":null,"children":null},{"name":"future_ship_date","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"shipping_method","type":"string","nullable":true,"metadata":null,"children":null},{"name":"recipient_date_of_birth","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"bc_shipping_zone_id","type":"int64","nullable":true,"metadata":null,"children":null}]}]},{"name":"taxes","type":"list<element: struct<id: string, tenant_id: string, order_level: string, tax_type: string, tax_rate: decimal128(28, 6), tax_amount: decimal128(28, 6), currency: string, included_in_price: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], name: string>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_level: string, tax_type: string, tax_rate: decimal128(28, 6), tax_amount: decimal128(28, 6), currency: string, included_in_price: string, created_at: timestamp[ns], updated_at: timestamp[ns], order_id: string, order_item_group_id: string, order_item_id: string, deleted_at: timestamp[ns], name: string>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_level","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tax_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tax_rate","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"tax_amount","type":"decimal128(28, 6)","nullable":true,"metadata":null,"children":null},{"name":"currency","type":"string","nullable":true,"metadata":null,"children":null},{"name":"included_in_price","type":"string","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_group_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_item_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"name","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"order_bc_customers","type":"list<element: struct<id: string, tenant_id: string, order_id: string, bc_customer_id: int64, created_at: timestamp[ns], updated_at: timestamp[ns], deleted_at: timestamp[ns]>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<id: string, tenant_id: string, order_id: string, bc_customer_id: int64, created_at: timestamp[ns], updated_at: timestamp[ns], deleted_at: timestamp[ns]>","nullable":true,"metadata":null,"children":[{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tenant_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"order_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bc_customer_id","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"created_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"updated_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"deleted_at","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null}]}]}],"parquet":"required group field_id=-1 spark_schema {\n  optional binary field_id=-1 id (String);\n  optional binary field_id=-1 tenant_id (String);\n  optional int64 field_id=-1 bc_order_id;\n  optional binary field_id=-1 order_status (String);\n  optional binary field_id=-1 order_payment_status (String);\n  optional binary field_id=-1 order_number (String);\n  optional binary field_id=-1 is_non_taxable (String);\n  optional int96 field_id=-1 date_completed;\n  optional fixed_len_byte_array(12) field_id=-1 subtotal_ex_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 subtotal_inc_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 shipping_total_ex_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 shipping_total_inc_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 handling_cost_ex_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 handling_cost_inc_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 total_ex_tax (Decimal(precision=28, scale=6));\n  optional fixed_len_byte_array(12) field_id=-1 total_inc_tax (Decimal(precision=28, scale=6));\n  optional int96 field_id=-1 future_ship_date;\n  optional binary field_id=-1 currency (String);\n  optional binary field_id=-1 bypass_fulfillment (String);\n  optional int96 field_id=-1 created_at;\n  optional int96 field_id=-1 updated_at;\n  optional binary field_id=-1 staff_notes (String);\n  optional int96 field_id=-1 deleted_at;\n  optional int96 field_id=-1 original_order_date;\n  optional binary field_id=-1 club_id (String);\n  optional binary field_id=-1 release_id (String);\n  optional binary field_id=-1 membership_id (String);\n  optional binary field_id=-1 is_draft (String);\n  optional binary field_id=-1 undraft_process_in_progress (String);\n  optional binary field_id=-1 bc_cart_id (String);\n  optional int64 field_id=-1 bc_channel_id;\n  optional binary field_id=-1 fulfillment_status (String);\n  optional binary field_id=-1 wdc_website_id (String);\n  optional binary field_id=-1 wdc_order_id (String);\n  optional binary field_id=-1 wdc_member_id (String);\n  optional fixed_len_byte_array(12) field_id=-1 discount_amount (Decimal(precision=28, scale=6));\n  optional binary field_id=-1 advanced_compliance_status (String);\n  optional binary field_id=-1 delivery_method (String);\n  optional int64 field_id=-1 bc_pickup_method_id;\n  optional binary field_id=-1 club_option_id (String);\n  optional binary field_id=-1 anwd_channel_name (String);\n  optional binary field_id=-1 anwd_channel_type (String);\n  optional binary field_id=-1 anwd_channel_id (String);\n  optional binary field_id=-1 anwd_order_type (String);\n  optional binary field_id=-1 processing_status (String);\n  optional binary field_id=-1 customer_notes (String);\n  optional binary field_id=-1 commit_status (String);\n  optional binary field_id=-1 sales_associate_id (String);\n  optional binary field_id=-1 department_id (String);\n  optional binary field_id=-1 anwd_payment_status (String);\n  optional binary field_id=-1 stored_card_id (String);\n  optional int32 field_id=-1 bc_consignment_pickup_id;\n  optional binary field_id=-1 comments (String);\n  optional binary field_id=-1 sale_type (String);\n  optional binary field_id=-1 shipment_status (String);\n  optional group field_id=-1 payments (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional int64 field_id=-1 bc_transaction_id;\n        optional binary field_id=-1 payment_status (String);\n        optional int96 field_id=-1 payment_timestamp;\n        optional binary field_id=-1 is_successful (String);\n        optional fixed_len_byte_array(12) field_id=-1 amount (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 currency (String);\n        optional binary field_id=-1 gateway (String);\n        optional binary field_id=-1 gateway_transaction_id (String);\n        optional binary field_id=-1 fraud_review (String);\n        optional binary field_id=-1 payment_type (String);\n        optional binary field_id=-1 credit_card_type (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional int96 field_id=-1 deleted_at;\n        optional binary field_id=-1 gateway_response (String);\n      }\n    }\n  }\n  optional group field_id=-1 billing_infos (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional binary field_id=-1 first_name (String);\n        optional binary field_id=-1 last_name (String);\n        optional binary field_id=-1 company (String);\n        optional binary field_id=-1 street_1 (String);\n        optional binary field_id=-1 street_2 (String);\n        optional binary field_id=-1 city (String);\n        optional binary field_id=-1 zip (String);\n        optional binary field_id=-1 subdivision (String);\n        optional binary field_id=-1 country (String);\n        optional binary field_id=-1 phone (String);\n        optional binary field_id=-1 email (String);\n        optional fixed_len_byte_array(12) field_id=-1 amount (Decimal(precision=28, scale=6));\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional binary field_id=-1 payment_id (String);\n        optional int96 field_id=-1 deleted_at;\n        optional int96 field_id=-1 purchaser_date_of_birth;\n      }\n    }\n  }\n  optional group field_id=-1 discounts (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional binary field_id=-1 discount_type (String);\n        optional fixed_len_byte_array(12) field_id=-1 discount_amount (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 discount_unit (String);\n        optional fixed_len_byte_array(12) field_id=-1 discount_value (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 currency (String);\n        optional binary field_id=-1 discount_name (String);\n        optional binary field_id=-1 discount_code (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional int96 field_id=-1 deleted_at;\n      }\n    }\n  }\n  optional group field_id=-1 order_items (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional int64 field_id=-1 bc_order_product_id;\n        optional int64 field_id=-1 bc_product_variant_id;\n        optional binary field_id=-1 variant_id (String);\n        optional binary field_id=-1 external_sku (String);\n        optional int32 field_id=-1 quantity;\n        optional binary field_id=-1 product_id (String);\n        optional int64 field_id=-1 bc_product_id;\n        optional binary field_id=-1 is_digital_product (String);\n        optional fixed_len_byte_array(12) field_id=-1 weight (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 weight_unit (String);\n        optional binary field_id=-1 is_non_taxable (String);\n        optional binary field_id=-1 is_price_override (String);\n        optional fixed_len_byte_array(12) field_id=-1 original_price (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 total_price_ex_tax (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 total_price_inc_tax (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 deposit (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 currency (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional int96 field_id=-1 deleted_at;\n        optional int64 field_id=-1 bc_parent_order_product_id;\n        optional binary field_id=-1 is_bundled_product (String);\n        optional binary field_id=-1 product_name (String);\n        optional binary field_id=-1 product_type_name (String);\n        optional binary field_id=-1 product_sku (String);\n        optional fixed_len_byte_array(12) field_id=-1 price_ex_tax (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 price_inc_tax (Decimal(precision=28, scale=6));\n      }\n    }\n  }\n  optional group field_id=-1 order_item_groups (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 is_bundle (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional int96 field_id=-1 deleted_at;\n      }\n    }\n  }\n  optional group field_id=-1 order_options (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional binary field_id=-1 option_type (String);\n        optional binary field_id=-1 option_value (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional int96 field_id=-1 deleted_at;\n        optional int64 field_id=-1 bc_option_id;\n        optional binary field_id=-1 bc_option_value (String);\n      }\n    }\n  }\n  optional group field_id=-1 refunds (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional fixed_len_byte_array(12) field_id=-1 refund_amount (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 currency (String);\n        optional binary field_id=-1 refund_type (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional binary field_id=-1 payment_id (String);\n        optional binary field_id=-1 order_payment_id (String);\n        optional int64 field_id=-1 bc_order_payment_id;\n        optional int96 field_id=-1 deleted_at;\n      }\n    }\n  }\n  optional group field_id=-1 shipping_infos (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional int64 field_id=-1 bc_shipping_id;\n        optional int32 field_id=-1 total_items_count;\n        optional binary field_id=-1 first_name (String);\n        optional binary field_id=-1 last_name (String);\n        optional binary field_id=-1 company (String);\n        optional binary field_id=-1 street_1 (String);\n        optional binary field_id=-1 street_2 (String);\n        optional binary field_id=-1 city (String);\n        optional binary field_id=-1 zip (String);\n        optional binary field_id=-1 subdivision (String);\n        optional binary field_id=-1 country (String);\n        optional binary field_id=-1 phone (String);\n        optional binary field_id=-1 email (String);\n        optional fixed_len_byte_array(12) field_id=-1 shipping_cost_ex_tax (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 shipping_cost_inc_tax (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 handling_cost_ex_tax (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 handling_cost_inc_tax (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 is_shipping_price_override (String);\n        optional fixed_len_byte_array(12) field_id=-1 original_price (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 shipping_total_wo_discount (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 shipping_total_with_discount (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 currency (String);\n        optional binary field_id=-1 shipping_instructions (String);\n        optional int96 field_id=-1 future_ship_date;\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional int96 field_id=-1 deleted_at;\n        optional binary field_id=-1 shipping_method (String);\n        optional int96 field_id=-1 recipient_date_of_birth;\n        optional int64 field_id=-1 bc_shipping_zone_id;\n      }\n    }\n  }\n  optional group field_id=-1 taxes (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_level (String);\n        optional binary field_id=-1 tax_type (String);\n        optional fixed_len_byte_array(12) field_id=-1 tax_rate (Decimal(precision=28, scale=6));\n        optional fixed_len_byte_array(12) field_id=-1 tax_amount (Decimal(precision=28, scale=6));\n        optional binary field_id=-1 currency (String);\n        optional binary field_id=-1 included_in_price (String);\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional binary field_id=-1 order_id (String);\n        optional binary field_id=-1 order_item_group_id (String);\n        optional binary field_id=-1 order_item_id (String);\n        optional int96 field_id=-1 deleted_at;\n        optional binary field_id=-1 name (String);\n      }\n    }\n  }\n  optional group field_id=-1 order_bc_customers (List) {\n    repeated group field_id=-1 list {\n      optional group field_id=-1 element {\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 tenant_id (String);\n        optional binary field_id=-1 order_id (String);\n        optional int64 field_id=-1 bc_customer_id;\n        optional int96 field_id=-1 created_at;\n        optional int96 field_id=-1 updated_at;\n        optional int96 field_id=-1 deleted_at;\n      }\n    }\n  }\n}\n"},"kv_metadata":[["org.apache.spark.sql.parquet.row.metadata","{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_order_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_payment_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_number\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_non_taxable\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"date_completed\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"subtotal_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"subtotal_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_total_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_total_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"handling_cost_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"handling_cost_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"total_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"total_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"future_ship_date\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bypass_fulfillment\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"staff_notes\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"original_order_date\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"club_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"release_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"membership_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_draft\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"undraft_process_in_progress\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_cart_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_channel_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"fulfillment_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"wdc_website_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"wdc_order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"wdc_member_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_amount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"advanced_compliance_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"delivery_method\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_pickup_method_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"club_option_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"anwd_channel_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"anwd_channel_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"anwd_channel_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"anwd_order_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"processing_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"customer_notes\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"commit_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"sales_associate_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"department_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"anwd_payment_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"stored_card_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_consignment_pickup_id\",\"type\":\"integer\",\"nullable\":true,\"metadata\":{}},{\"name\":\"comments\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"sale_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipment_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"payments\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_transaction_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"payment_status\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"payment_timestamp\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_successful\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"amount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"gateway\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"gateway_transaction_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"fraud_review\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"payment_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"credit_card_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"gateway_response\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"billing_infos\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"first_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"last_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"company\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"street_1\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"street_2\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"city\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"zip\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"subdivision\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"country\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"phone\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"email\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"amount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"payment_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"purchaser_date_of_birth\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"discounts\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_amount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_unit\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_value\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"discount_code\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"order_items\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_order_product_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_product_variant_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"variant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"external_sku\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"quantity\",\"type\":\"integer\",\"nullable\":true,\"metadata\":{}},{\"name\":\"product_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_product_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_digital_product\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"weight\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"weight_unit\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_non_taxable\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_price_override\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"original_price\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"total_price_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"total_price_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deposit\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_parent_order_product_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_bundled_product\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"product_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"product_type_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"product_sku\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"price_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"price_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_groups\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_bundle\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"order_options\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"option_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"option_value\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_option_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_option_value\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"refunds\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"refund_amount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"refund_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"payment_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_payment_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_order_payment_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_infos\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_shipping_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"total_items_count\",\"type\":\"integer\",\"nullable\":true,\"metadata\":{}},{\"name\":\"first_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"last_name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"company\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"street_1\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"street_2\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"city\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"zip\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"subdivision\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"country\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"phone\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"email\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_cost_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_cost_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"handling_cost_ex_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"handling_cost_inc_tax\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"is_shipping_price_override\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"original_price\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_total_wo_discount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_total_with_discount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_instructions\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"future_ship_date\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"shipping_method\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"recipient_date_of_birth\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_shipping_zone_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"taxes\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_level\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tax_type\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tax_rate\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tax_amount\",\"type\":\"decimal(28,6)\",\"nullable\":true,\"metadata\":{}},{\"name\":\"currency\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"included_in_price\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_group_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_item_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"name\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}},{\"name\":\"order_bc_customers\",\"type\":{\"type\":\"array\",\"elementType\":{\"type\":\"struct\",\"fields\":[{\"name\":\"id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"tenant_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"order_id\",\"type\":\"string\",\"nullable\":true,\"metadata\":{}},{\"name\":\"bc_customer_id\",\"type\":\"long\",\"nullable\":true,\"metadata\":{}},{\"name\":\"created_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"updated_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}},{\"name\":\"deleted_at\",\"type\":\"timestamp\",\"nullable\":true,\"metadata\":{}}]},\"containsNull\":true},\"nullable\":true,\"metadata\":{}}]}"],["org.apache.spark.version","3.3.0"]]}
["c6db9073-459c-42e5-83ad-338c302f88f0","a8f1240c-b3fa-47e4-acf4-23060acd0983",291,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-08T23:37:10.654464000","2023-09-08T23:37:10.654464000","",null,"2023-09-08T23:37:03.000000000",null,null,null,"false","false","c0da4989-a355-458b-afc8-65ac6a3e7ced",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"6a00d39a-221b-45f3-8d75-2997ec17c8ae","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-08T23:37:10.695366000","updated_at":"2023-09-08T23:37:10.695366000","order_id":"c6db9073-459c-42e5-83ad-338c302f88f0","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"bb816ddd-d642-48dc-adee-2bb0fdc9454a","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":192,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-08T23:37:10.672314000","updated_at":"2023-09-08T23:37:10.672314000","order_id":"c6db9073-459c-42e5-83ad-338c302f88f0","order_item_group_id":"e1e07e91-6c02-4956-81a9-327b5de9f8a9","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"e1e07e91-6c02-4956-81a9-327b5de9f8a9","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-08T23:37:10.666784000","updated_at":"2023-09-08T23:37:10.666784000","order_id":"c6db9073-459c-42e5-83ad-338c302f88f0","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"b5248a3b-277d-4f3a-a77b-c1a99ca12da8","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":192,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-08T23:37:10.683635000","updated_at":"2023-09-08T23:37:10.683635000","order_id":"c6db9073-459c-42e5-83ad-338c302f88f0","order_item_group_id":"e1e07e91-6c02-4956-81a9-327b5de9f8a9","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"3a6543f4-fe06-49f1-8f7f-f91fcc6855b6","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"c6db9073-459c-42e5-83ad-338c302f88f0","bc_customer_id":1,"created_at":"2023-09-08T23:37:10.689112000","updated_at":"2023-09-08T23:37:10.689112000","deleted_at":null}]]
["652097f9-8007-43d5-9e67-bda443398f54","a8f1240c-b3fa-47e4-acf4-23060acd0983",290,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-08T23:31:48.366322000","2023-09-08T23:31:48.366322000","",null,"2023-09-08T23:31:41.000000000",null,null,null,"false","false","9e9bc143-00a9-4908-88a5-b9d2e15ece2e",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"079bcddd-0578-4b30-9019-59a6b282857b","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-08T23:31:48.400757000","updated_at":"2023-09-08T23:31:48.400757000","order_id":"652097f9-8007-43d5-9e67-bda443398f54","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"5256b9dc-4f5c-4441-9c56-8af3f42eb576","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":191,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-08T23:31:48.378031000","updated_at":"2023-09-08T23:31:48.378031000","order_id":"652097f9-8007-43d5-9e67-bda443398f54","order_item_group_id":"f5a1d31e-e69f-4d4c-8eb4-3fb38f4e088b","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"f5a1d31e-e69f-4d4c-8eb4-3fb38f4e088b","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-08T23:31:48.373279000","updated_at":"2023-09-08T23:31:48.373279000","order_id":"652097f9-8007-43d5-9e67-bda443398f54","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"6984f518-64f0-4a1b-92a9-392060ee9a90","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":191,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-08T23:31:48.386682000","updated_at":"2023-09-08T23:31:48.386682000","order_id":"652097f9-8007-43d5-9e67-bda443398f54","order_item_group_id":"f5a1d31e-e69f-4d4c-8eb4-3fb38f4e088b","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"2576b48e-1553-43e6-bbd8-6a79ca19c0f8","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"652097f9-8007-43d5-9e67-bda443398f54","bc_customer_id":1,"created_at":"2023-09-08T23:31:48.392954000","updated_at":"2023-09-08T23:31:48.392954000","deleted_at":null}]]
["0159d0ee-ba25-42c1-b2e1-f91921cf5e73","a8f1240c-b3fa-47e4-acf4-23060acd0983",289,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-08T23:26:52.268320000","2023-09-08T23:26:52.268320000","",null,"2023-09-08T23:26:45.000000000",null,null,null,"false","false","36b3eb3d-03eb-4d48-813a-658585a286e1",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"c1d2b8a7-1f68-4a45-b873-726e2fe07172","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-08T23:26:52.304295000","updated_at":"2023-09-08T23:26:52.304295000","order_id":"0159d0ee-ba25-42c1-b2e1-f91921cf5e73","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"16ba5253-4d1c-409d-bb53-785dc73b04cd","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":190,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-08T23:26:52.281380000","updated_at":"2023-09-08T23:26:52.281380000","order_id":"0159d0ee-ba25-42c1-b2e1-f91921cf5e73","order_item_group_id":"e498e8eb-b9a1-42d2-b425-841a50e023f0","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"e498e8eb-b9a1-42d2-b425-841a50e023f0","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-08T23:26:52.275879000","updated_at":"2023-09-08T23:26:52.275879000","order_id":"0159d0ee-ba25-42c1-b2e1-f91921cf5e73","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"1e33a2e6-1e3e-40bd-861f-5b24796e3bb7","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":190,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-08T23:26:52.288716000","updated_at":"2023-09-08T23:26:52.288716000","order_id":"0159d0ee-ba25-42c1-b2e1-f91921cf5e73","order_item_group_id":"e498e8eb-b9a1-42d2-b425-841a50e023f0","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"f1b2899f-12fb-4cec-b2f2-90075c4458ec","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"0159d0ee-ba25-42c1-b2e1-f91921cf5e73","bc_customer_id":1,"created_at":"2023-09-08T23:26:52.297206000","updated_at":"2023-09-08T23:26:52.297206000","deleted_at":null}]]
["e283f025-bc91-4da5-aad0-e2e6113a32f9","a8f1240c-b3fa-47e4-acf4-23060acd0983",288,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-08T23:22:39.871805000","2023-09-08T23:22:39.871805000","",null,"2023-09-08T23:22:32.000000000",null,null,null,"false","false","77dfd52e-d0a7-4635-aa93-acb2ad5985fc",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"4202cbe0-c5b0-41ab-bc30-b19b2cb0a076","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-08T23:22:39.901650000","updated_at":"2023-09-08T23:22:39.901650000","order_id":"e283f025-bc91-4da5-aad0-e2e6113a32f9","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"f71984fe-afbb-4d35-81b1-9d374d43ee17","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":189,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-08T23:22:39.881200000","updated_at":"2023-09-08T23:22:39.881200000","order_id":"e283f025-bc91-4da5-aad0-e2e6113a32f9","order_item_group_id":"25c39d37-d4a0-4c8e-950e-d56128eb7e96","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"25c39d37-d4a0-4c8e-950e-d56128eb7e96","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-08T23:22:39.877288000","updated_at":"2023-09-08T23:22:39.877288000","order_id":"e283f025-bc91-4da5-aad0-e2e6113a32f9","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"0d51401a-e57c-402d-b7ea-19929de7a61b","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":189,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-08T23:22:39.887525000","updated_at":"2023-09-08T23:22:39.887525000","order_id":"e283f025-bc91-4da5-aad0-e2e6113a32f9","order_item_group_id":"25c39d37-d4a0-4c8e-950e-d56128eb7e96","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"08ab8874-3266-4bfe-874e-a1cc6dcb1912","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"e283f025-bc91-4da5-aad0-e2e6113a32f9","bc_customer_id":1,"created_at":"2023-09-08T23:22:39.895398000","updated_at":"2023-09-08T23:22:39.895398000","deleted_at":null}]]
["866e4957-ebb2-4cc1-baf5-e4c75909ff37","a8f1240c-b3fa-47e4-acf4-23060acd0983",298,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-19T16:31:47.817630000","2023-09-19T16:31:47.817630000","",null,"2023-09-19T16:31:40.000000000",null,null,null,"false","false","d9482cec-f0d8-4ebf-ab2e-2fa502b9effa",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"62d5a379-8cc9-43de-919d-54ccc09e2b09","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-19T16:31:47.848818000","updated_at":"2023-09-19T16:31:47.848818000","order_id":"866e4957-ebb2-4cc1-baf5-e4c75909ff37","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"f9276950-952e-45f1-b7b2-001f2a700977","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":199,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-19T16:31:47.830895000","updated_at":"2023-09-19T16:31:47.830895000","order_id":"866e4957-ebb2-4cc1-baf5-e4c75909ff37","order_item_group_id":"6ba60f9f-2588-4dc8-9704-8d7b3e7f1b6d","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"6ba60f9f-2588-4dc8-9704-8d7b3e7f1b6d","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-19T16:31:47.826566000","updated_at":"2023-09-19T16:31:47.826566000","order_id":"866e4957-ebb2-4cc1-baf5-e4c75909ff37","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"e6eefb93-908a-4399-bcfa-5e487440bf9a","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":199,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-19T16:31:47.836614000","updated_at":"2023-09-19T16:31:47.836614000","order_id":"866e4957-ebb2-4cc1-baf5-e4c75909ff37","order_item_group_id":"6ba60f9f-2588-4dc8-9704-8d7b3e7f1b6d","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"34151806-38cd-41a5-872d-08fbb8b488bc","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"866e4957-ebb2-4cc1-baf5-e4c75909ff37","bc_customer_id":1,"created_at":"2023-09-19T16:31:47.845240000","updated_at":"2023-09-19T16:31:47.845240000","deleted_at":null}]]
["09f9ff9d-d1a1-4fd3-b912-ecdebe8ce621","a8f1240c-b3fa-47e4-acf4-23060acd0983",299,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-19T19:45:30.524659000","2023-09-19T19:45:30.524659000","",null,"2023-09-19T19:45:21.000000000",null,null,null,"false","false","465b3d08-3d4c-4367-ade0-8bae0dae67af",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"3835a41d-006b-4b43-931b-0e9a785a8fd0","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-19T19:45:30.539349000","updated_at":"2023-09-19T19:45:30.539349000","order_id":"09f9ff9d-d1a1-4fd3-b912-ecdebe8ce621","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"7f048dbe-598a-4587-bd2b-a3ad5e17be97","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":200,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-19T19:45:30.529605000","updated_at":"2023-09-19T19:45:30.529605000","order_id":"09f9ff9d-d1a1-4fd3-b912-ecdebe8ce621","order_item_group_id":"771c085f-318d-4b08-8d55-9f23dd915cc6","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"771c085f-318d-4b08-8d55-9f23dd915cc6","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-19T19:45:30.528026000","updated_at":"2023-09-19T19:45:30.528026000","order_id":"09f9ff9d-d1a1-4fd3-b912-ecdebe8ce621","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"9366a408-6c96-401f-a0b7-7a5bb2cfb4f1","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":200,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-19T19:45:30.534975000","updated_at":"2023-09-19T19:45:30.534975000","order_id":"09f9ff9d-d1a1-4fd3-b912-ecdebe8ce621","order_item_group_id":"771c085f-318d-4b08-8d55-9f23dd915cc6","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"00bc5bf4-1af6-4867-b1da-d59a501e2470","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"09f9ff9d-d1a1-4fd3-b912-ecdebe8ce621","bc_customer_id":1,"created_at":"2023-09-19T19:45:30.537097000","updated_at":"2023-09-19T19:45:30.537097000","deleted_at":null}]]
["18b0534d-adc1-4681-823b-cc6c2b458760","a8f1240c-b3fa-47e4-acf4-23060acd0983",297,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-19T16:28:24.128224000","2023-09-19T16:28:24.128224000","",null,"2023-09-19T16:28:11.000000000",null,null,null,"false","false","165b9912-b0fe-44bd-8730-2e9640a78af5",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"ff50b381-bd09-41f0-aba1-5df988a9d630","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-19T16:28:24.175804000","updated_at":"2023-09-19T16:28:24.175804000","order_id":"18b0534d-adc1-4681-823b-cc6c2b458760","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"cfc8e251-9a1a-4f76-9a97-2abcfaca8365","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":198,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-19T16:28:24.145161000","updated_at":"2023-09-19T16:28:24.145161000","order_id":"18b0534d-adc1-4681-823b-cc6c2b458760","order_item_group_id":"4e1c20a9-3b85-445d-a975-8942b0a7e5e2","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"4e1c20a9-3b85-445d-a975-8942b0a7e5e2","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-19T16:28:24.140657000","updated_at":"2023-09-19T16:28:24.140657000","order_id":"18b0534d-adc1-4681-823b-cc6c2b458760","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"6794f0b2-8901-431a-85e6-51a8095f75de","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":198,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-19T16:28:24.154046000","updated_at":"2023-09-19T16:28:24.154046000","order_id":"18b0534d-adc1-4681-823b-cc6c2b458760","order_item_group_id":"4e1c20a9-3b85-445d-a975-8942b0a7e5e2","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"40b2b2f9-fcd1-499b-a805-c095679585e0","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"18b0534d-adc1-4681-823b-cc6c2b458760","bc_customer_id":1,"created_at":"2023-09-19T16:28:24.171955000","updated_at":"2023-09-19T16:28:24.171955000","deleted_at":null}]]
["8b4929e9-a611-41ba-a4d1-739c020ecf1a","a8f1240c-b3fa-47e4-acf4-23060acd0983",294,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-15T02:03:45.027348000","2023-09-15T02:03:45.027348000","",null,"2023-09-15T02:03:37.000000000",null,null,null,"false","false","255585c4-66d6-488a-adac-58b8d10663e1",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"f6d230e7-df28-4ef4-893e-403c67345e95","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-15T02:03:45.101142000","updated_at":"2023-09-15T02:03:45.101142000","order_id":"8b4929e9-a611-41ba-a4d1-739c020ecf1a","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"b9d44cd2-d50c-4c10-9600-c3cb42450c88","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":195,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-15T02:03:45.056036000","updated_at":"2023-09-15T02:03:45.056036000","order_id":"8b4929e9-a611-41ba-a4d1-739c020ecf1a","order_item_group_id":"7a674a5a-cd80-4ddb-867c-5b7b931ad790","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"7a674a5a-cd80-4ddb-867c-5b7b931ad790","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-15T02:03:45.042909000","updated_at":"2023-09-15T02:03:45.042909000","order_id":"8b4929e9-a611-41ba-a4d1-739c020ecf1a","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"b855409e-4c59-4bb7-a789-fa46035cc445","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":195,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-15T02:03:45.066209000","updated_at":"2023-09-15T02:03:45.066209000","order_id":"8b4929e9-a611-41ba-a4d1-739c020ecf1a","order_item_group_id":"7a674a5a-cd80-4ddb-867c-5b7b931ad790","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"13dceb12-8798-4f9e-b61f-17dec7bc9985","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"8b4929e9-a611-41ba-a4d1-739c020ecf1a","bc_customer_id":1,"created_at":"2023-09-15T02:03:45.091824000","updated_at":"2023-09-15T02:03:45.091824000","deleted_at":null}]]
["f90a218e-82cd-4286-a752-5d14d1b146be","a8f1240c-b3fa-47e4-acf4-23060acd0983",295,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-15T17:36:36.046031000","2023-09-15T17:36:36.046031000","",null,"2023-09-15T17:36:28.000000000",null,null,null,"false","false","213563ba-312b-4bc5-918e-9602f6899a87",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"1606c3f8-a23a-437d-9764-4809751edadb","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-15T17:36:36.091950000","updated_at":"2023-09-15T17:36:36.091950000","order_id":"f90a218e-82cd-4286-a752-5d14d1b146be","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"5ffbc304-88eb-43cb-8d16-889df96dae97","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":196,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-15T17:36:36.061391000","updated_at":"2023-09-15T17:36:36.061391000","order_id":"f90a218e-82cd-4286-a752-5d14d1b146be","order_item_group_id":"0619e8f6-401d-4803-a208-9a444f526211","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"0619e8f6-401d-4803-a208-9a444f526211","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-15T17:36:36.056565000","updated_at":"2023-09-15T17:36:36.056565000","order_id":"f90a218e-82cd-4286-a752-5d14d1b146be","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"0022791e-423b-4ea1-b095-e2a11b3aaed8","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":196,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-15T17:36:36.066956000","updated_at":"2023-09-15T17:36:36.066956000","order_id":"f90a218e-82cd-4286-a752-5d14d1b146be","order_item_group_id":"0619e8f6-401d-4803-a208-9a444f526211","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"0f9c134d-febe-4c5b-a44a-8ecb007b2072","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"f90a218e-82cd-4286-a752-5d14d1b146be","bc_customer_id":1,"created_at":"2023-09-15T17:36:36.085797000","updated_at":"2023-09-15T17:36:36.085797000","deleted_at":null}]]
["3ed02913-8dca-40ba-bc70-eae6594daca0","a8f1240c-b3fa-47e4-acf4-23060acd0983",301,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-21T16:42:34.803119000","2023-09-21T16:42:34.803119000","",null,"2023-09-21T16:42:27.000000000",null,null,null,"false","false","1514e5b0-a321-4399-8e08-760af4394cd9",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"7ec8e345-c062-4e46-b7d3-deb8b32c3603","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-21T16:42:34.849127000","updated_at":"2023-09-21T16:42:34.849127000","order_id":"3ed02913-8dca-40ba-bc70-eae6594daca0","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"9868d8a0-36f7-44fe-b1de-90ea3f4f9dd8","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":202,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-21T16:42:34.812765000","updated_at":"2023-09-21T16:42:34.812765000","order_id":"3ed02913-8dca-40ba-bc70-eae6594daca0","order_item_group_id":"1689e2de-b316-4c34-94eb-502b4284257e","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"1689e2de-b316-4c34-94eb-502b4284257e","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-21T16:42:34.807982000","updated_at":"2023-09-21T16:42:34.807982000","order_id":"3ed02913-8dca-40ba-bc70-eae6594daca0","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"9bc55a12-6868-4c3f-b680-c44e1d510bb4","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":202,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-21T16:42:34.825212000","updated_at":"2023-09-21T16:42:34.825212000","order_id":"3ed02913-8dca-40ba-bc70-eae6594daca0","order_item_group_id":"1689e2de-b316-4c34-94eb-502b4284257e","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"32941e12-8117-446d-bb4d-a8ef64fef2a9","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"3ed02913-8dca-40ba-bc70-eae6594daca0","bc_customer_id":1,"created_at":"2023-09-21T16:42:34.844118000","updated_at":"2023-09-21T16:42:34.844118000","deleted_at":null}]]
["c7804683-b02f-4267-a6ec-5a9866c022f4","a8f1240c-b3fa-47e4-acf4-23060acd0983",300,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-21T08:34:07.490374000","2023-09-21T08:34:07.490374000","",null,"2023-09-21T08:33:59.000000000",null,null,null,"false","false","6cee3ec2-bfc2-4623-9bd4-5b2140cc6648",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"022cd057-307a-4a5b-bbb2-4480946547ca","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-21T08:34:07.516409000","updated_at":"2023-09-21T08:34:07.516409000","order_id":"c7804683-b02f-4267-a6ec-5a9866c022f4","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"af382708-0eb5-4d51-a375-0a324b0399dc","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":201,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-21T08:34:07.498932000","updated_at":"2023-09-21T08:34:07.498932000","order_id":"c7804683-b02f-4267-a6ec-5a9866c022f4","order_item_group_id":"4ea3ce0e-37f5-454b-9f64-a114039a90c7","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"4ea3ce0e-37f5-454b-9f64-a114039a90c7","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-21T08:34:07.495522000","updated_at":"2023-09-21T08:34:07.495522000","order_id":"c7804683-b02f-4267-a6ec-5a9866c022f4","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"9cfe5225-ee61-44b8-93a6-814294031925","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":201,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-21T08:34:07.503412000","updated_at":"2023-09-21T08:34:07.503412000","order_id":"c7804683-b02f-4267-a6ec-5a9866c022f4","order_item_group_id":"4ea3ce0e-37f5-454b-9f64-a114039a90c7","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"821b9591-1028-4a7b-958b-5743368f41dd","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"c7804683-b02f-4267-a6ec-5a9866c022f4","bc_customer_id":1,"created_at":"2023-09-21T08:34:07.510140000","updated_at":"2023-09-21T08:34:07.510140000","deleted_at":null}]]
["a4758be1-cf18-4593-9ecf-cd0e2f57b4d3","a8f1240c-b3fa-47e4-acf4-23060acd0983",287,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-01T22:18:15.933050000","2023-09-01T22:18:15.933050000","",null,"2023-09-01T22:18:02.000000000",null,null,null,"false","false","0c524a6a-0761-4b20-a7ed-9050803b8a49",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"780243fa-0204-4616-b96a-db2cf1f75616","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-01T22:18:15.968801000","updated_at":"2023-09-01T22:18:15.968801000","order_id":"a4758be1-cf18-4593-9ecf-cd0e2f57b4d3","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"0b505b99-5fad-42f0-b767-ba5b113d6fde","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":188,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-01T22:18:15.943999000","updated_at":"2023-09-01T22:18:15.943999000","order_id":"a4758be1-cf18-4593-9ecf-cd0e2f57b4d3","order_item_group_id":"cb654aa3-600f-4973-8873-33f0a845a7c6","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"cb654aa3-600f-4973-8873-33f0a845a7c6","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-01T22:18:15.938955000","updated_at":"2023-09-01T22:18:15.938955000","order_id":"a4758be1-cf18-4593-9ecf-cd0e2f57b4d3","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"abbbc806-7003-4a8e-a713-6fba44521bf1","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":188,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-01T22:18:15.948557000","updated_at":"2023-09-01T22:18:15.948557000","order_id":"a4758be1-cf18-4593-9ecf-cd0e2f57b4d3","order_item_group_id":"cb654aa3-600f-4973-8873-33f0a845a7c6","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"6f2e4a42-1811-4021-9754-1d93b175b510","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"a4758be1-cf18-4593-9ecf-cd0e2f57b4d3","bc_customer_id":1,"created_at":"2023-09-01T22:18:15.965274000","updated_at":"2023-09-01T22:18:15.965274000","deleted_at":null}]]
["c3904d47-6b71-4e1b-a7f7-df3938c2a93f","a8f1240c-b3fa-47e4-acf4-23060acd0983",302,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-26T18:52:15.907535000","2023-09-26T18:52:15.907535000","",null,"2023-09-26T18:52:08.000000000",null,null,null,"false","false","84749e58-3505-4fde-9809-5b5f64dd77a7",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"7578f659-9691-4fc7-9595-570616acc099","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-26T18:52:15.947737000","updated_at":"2023-09-26T18:52:15.947737000","order_id":"c3904d47-6b71-4e1b-a7f7-df3938c2a93f","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"03d8d309-a4a3-42a3-a898-25769db8bcbc","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":203,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-26T18:52:15.920122000","updated_at":"2023-09-26T18:52:15.920122000","order_id":"c3904d47-6b71-4e1b-a7f7-df3938c2a93f","order_item_group_id":"3ec992d5-90c4-452a-ad2b-9fcd9d8e038a","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"3ec992d5-90c4-452a-ad2b-9fcd9d8e038a","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-26T18:52:15.913830000","updated_at":"2023-09-26T18:52:15.913830000","order_id":"c3904d47-6b71-4e1b-a7f7-df3938c2a93f","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"9e4dde50-6d34-4599-86c1-610d4367afba","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":203,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-26T18:52:15.927362000","updated_at":"2023-09-26T18:52:15.927362000","order_id":"c3904d47-6b71-4e1b-a7f7-df3938c2a93f","order_item_group_id":"3ec992d5-90c4-452a-ad2b-9fcd9d8e038a","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"feaee0b0-e3b0-4260-9de7-3f92f0de5930","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"c3904d47-6b71-4e1b-a7f7-df3938c2a93f","bc_customer_id":1,"created_at":"2023-09-26T18:52:15.942478000","updated_at":"2023-09-26T18:52:15.942478000","deleted_at":null}]]
["4e82d2c1-ac38-4cf0-bc78-d25c0f8254e0","a8f1240c-b3fa-47e4-acf4-23060acd0983",304,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-30T04:04:06.118624000","2023-09-30T04:04:06.118624000","",null,"2023-09-30T04:03:58.000000000",null,null,null,"false","false","36f76114-ff9a-41b0-b67e-376be5745ac1",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"5f5bfede-a22b-40f9-8fb7-22122dde98d6","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-30T04:04:06.169561000","updated_at":"2023-09-30T04:04:06.169561000","order_id":"4e82d2c1-ac38-4cf0-bc78-d25c0f8254e0","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"ba87d15b-fdc0-407a-86ae-de652f47c852","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":205,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-30T04:04:06.131837000","updated_at":"2023-09-30T04:04:06.131837000","order_id":"4e82d2c1-ac38-4cf0-bc78-d25c0f8254e0","order_item_group_id":"05792368-7b9f-4370-aeb6-748b0e02e6c8","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"05792368-7b9f-4370-aeb6-748b0e02e6c8","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-30T04:04:06.126318000","updated_at":"2023-09-30T04:04:06.126318000","order_id":"4e82d2c1-ac38-4cf0-bc78-d25c0f8254e0","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"203c5cf5-f514-41cc-bded-45b0d5695a3d","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":205,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-30T04:04:06.140009000","updated_at":"2023-09-30T04:04:06.140009000","order_id":"4e82d2c1-ac38-4cf0-bc78-d25c0f8254e0","order_item_group_id":"05792368-7b9f-4370-aeb6-748b0e02e6c8","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"d04fce63-ba59-4ff5-9c19-4ebec71cd64a","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"4e82d2c1-ac38-4cf0-bc78-d25c0f8254e0","bc_customer_id":1,"created_at":"2023-09-30T04:04:06.159706000","updated_at":"2023-09-30T04:04:06.159706000","deleted_at":null}]]
["63feeb52-881f-4b34-94f3-1167b4866533","a8f1240c-b3fa-47e4-acf4-23060acd0983",293,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-12T00:39:08.388447000","2023-09-12T00:39:08.388447000","",null,"2023-09-12T00:39:01.000000000",null,null,null,"false","false","fdfdab8a-4e97-4148-9e29-f96c626f8483",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"a8678553-1741-4129-a625-9281ec91a581","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-12T00:39:08.421441000","updated_at":"2023-09-12T00:39:08.421441000","order_id":"63feeb52-881f-4b34-94f3-1167b4866533","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"aad422d0-9292-4ed2-a302-2e442fa87b55","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":194,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-12T00:39:08.397487000","updated_at":"2023-09-12T00:39:08.397487000","order_id":"63feeb52-881f-4b34-94f3-1167b4866533","order_item_group_id":"20df45df-8d15-4741-9f15-4b5c17d5b27e","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"20df45df-8d15-4741-9f15-4b5c17d5b27e","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-12T00:39:08.394357000","updated_at":"2023-09-12T00:39:08.394357000","order_id":"63feeb52-881f-4b34-94f3-1167b4866533","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"46752f9f-fd99-464b-aaf9-7c7e5b650a4b","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":194,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-12T00:39:08.401642000","updated_at":"2023-09-12T00:39:08.401642000","order_id":"63feeb52-881f-4b34-94f3-1167b4866533","order_item_group_id":"20df45df-8d15-4741-9f15-4b5c17d5b27e","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"004ad850-415b-42ed-a8f5-195f070a06c8","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"63feeb52-881f-4b34-94f3-1167b4866533","bc_customer_id":1,"created_at":"2023-09-12T00:39:08.417433000","updated_at":"2023-09-12T00:39:08.417433000","deleted_at":null}]]
["59002d18-0b73-493d-9bc0-156239a68395","a8f1240c-b3fa-47e4-acf4-23060acd0983",292,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-11T15:56:37.908653000","2023-09-11T15:56:37.908653000","",null,"2023-09-11T15:56:28.000000000",null,null,null,"false","false","cbaa3634-0c1e-46f3-9c5c-c3eca2443787",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"ce16febd-6993-4272-8b81-8b0e2fb141b1","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-11T15:56:37.953084000","updated_at":"2023-09-11T15:56:37.953084000","order_id":"59002d18-0b73-493d-9bc0-156239a68395","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"5eccf491-ce9e-454d-bdab-9f783512ac96","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":193,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-11T15:56:37.924264000","updated_at":"2023-09-11T15:56:37.924264000","order_id":"59002d18-0b73-493d-9bc0-156239a68395","order_item_group_id":"082cd1d1-3324-4ac4-8bba-06b5c5f2e410","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"082cd1d1-3324-4ac4-8bba-06b5c5f2e410","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-11T15:56:37.917808000","updated_at":"2023-09-11T15:56:37.917808000","order_id":"59002d18-0b73-493d-9bc0-156239a68395","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"7a892e83-f296-4f10-a80a-329d54cd67d1","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":193,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-11T15:56:37.931562000","updated_at":"2023-09-11T15:56:37.931562000","order_id":"59002d18-0b73-493d-9bc0-156239a68395","order_item_group_id":"082cd1d1-3324-4ac4-8bba-06b5c5f2e410","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"677760e8-6f8b-4a49-bc90-c022bb7265ba","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"59002d18-0b73-493d-9bc0-156239a68395","bc_customer_id":1,"created_at":"2023-09-11T15:56:37.945348000","updated_at":"2023-09-11T15:56:37.945348000","deleted_at":null}]]
["f0f5b958-0038-416f-881d-32881522c382","a8f1240c-b3fa-47e4-acf4-23060acd0983",303,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-27T21:38:19.456267000","2023-09-27T21:38:19.456267000","",null,"2023-09-27T21:38:11.000000000",null,null,null,"false","false","171b96bd-d0bc-45eb-812d-93d8363d2158",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"229473dd-2c1b-4b4f-bae7-04e09e88a378","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-27T21:38:19.506689000","updated_at":"2023-09-27T21:38:19.506689000","order_id":"f0f5b958-0038-416f-881d-32881522c382","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"763f7fbd-50ce-494d-b38d-45ffcf6984c3","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":204,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-27T21:38:19.476139000","updated_at":"2023-09-27T21:38:19.476139000","order_id":"f0f5b958-0038-416f-881d-32881522c382","order_item_group_id":"f1f42cf7-ed3d-4398-8eb6-7e7d70c0798b","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"f1f42cf7-ed3d-4398-8eb6-7e7d70c0798b","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-27T21:38:19.464504000","updated_at":"2023-09-27T21:38:19.464504000","order_id":"f0f5b958-0038-416f-881d-32881522c382","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"fc4ad6de-290e-40c5-902a-eddb80d05384","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":204,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-27T21:38:19.484865000","updated_at":"2023-09-27T21:38:19.484865000","order_id":"f0f5b958-0038-416f-881d-32881522c382","order_item_group_id":"f1f42cf7-ed3d-4398-8eb6-7e7d70c0798b","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"a4edf261-8745-4c0d-baed-7efa560360e9","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"f0f5b958-0038-416f-881d-32881522c382","bc_customer_id":1,"created_at":"2023-09-27T21:38:19.494885000","updated_at":"2023-09-27T21:38:19.494885000","deleted_at":null}]]
["19cd694e-61b0-488c-aae7-f9187465888b","a8f1240c-b3fa-47e4-acf4-23060acd0983",296,"incomplete","",null,"false",null,"25.000000","25.000000","10.000000","10.000000","0.000000","0.000000","35.000000","35.000000",null,"CAD","false","2023-09-18T23:52:04.468455000","2023-09-18T23:52:04.468455000","",null,"2023-09-18T23:51:48.000000000",null,null,null,"false","false","dd4443ab-d0b4-4fb5-a09c-fcf660242b14",1,null,null,null,null,"0.000000","pending","shipping",null,null,"Automation Cypress Store","storefront","8662c694-eb89-4fff-b97d-5e78a7bbd991","Website","idle","","pending",null,null,"pending",null,null,null,"offsite",null,[{"id":null,"tenant_id":null,"order_level":null,"bc_transaction_id":null,"payment_status":null,"payment_timestamp":null,"is_successful":null,"amount":null,"currency":null,"gateway":null,"gateway_transaction_id":null,"fraud_review":null,"payment_type":null,"credit_card_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"gateway_response":null}],[{"id":"82293d2d-7190-4fbc-9307-a95f6f8eb0b7","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":null,"first_name":"Jane","last_name":"Doe","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"1234567890","email":"test.customer@wd.com","amount":"35.000000","created_at":"2023-09-18T23:52:04.521486000","updated_at":"2023-09-18T23:52:04.521486000","order_id":"19cd694e-61b0-488c-aae7-f9187465888b","order_item_group_id":null,"order_item_id":null,"payment_id":null,"deleted_at":null,"purchaser_date_of_birth":null}],[{"id":null,"tenant_id":null,"order_level":null,"discount_type":null,"discount_amount":null,"discount_unit":null,"discount_value":null,"currency":null,"discount_name":null,"discount_code":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null}],[{"id":"d171a507-9b39-4261-bd01-2e8614c3d229","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","bc_order_product_id":197,"bc_product_variant_id":74,"variant_id":null,"external_sku":null,"quantity":1,"product_id":null,"bc_product_id":111,"is_digital_product":"false","weight":null,"weight_unit":null,"is_non_taxable":null,"is_price_override":null,"original_price":null,"total_price_ex_tax":"25.000000","total_price_inc_tax":"25.000000","deposit":null,"currency":"CAD","created_at":"2023-09-18T23:52:04.488386000","updated_at":"2023-09-18T23:52:04.488386000","order_id":"19cd694e-61b0-488c-aae7-f9187465888b","order_item_group_id":"8bb3b539-735e-4a47-b693-1b47d04b2ecb","deleted_at":null,"bc_parent_order_product_id":null,"is_bundled_product":"false","product_name":"[Sample] Smith Journal 13","product_type_name":null,"product_sku":"SM13","price_ex_tax":"25.000000","price_inc_tax":"25.000000"}],[{"id":"8bb3b539-735e-4a47-b693-1b47d04b2ecb","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","is_bundle":"false","created_at":"2023-09-18T23:52:04.475982000","updated_at":"2023-09-18T23:52:04.475982000","order_id":"19cd694e-61b0-488c-aae7-f9187465888b","deleted_at":null}],[{"id":null,"tenant_id":null,"order_level":null,"option_type":null,"option_value":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"bc_option_id":null,"bc_option_value":null}],[{"id":null,"tenant_id":null,"order_level":null,"refund_amount":null,"currency":null,"refund_type":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"payment_id":null,"order_payment_id":null,"bc_order_payment_id":null,"deleted_at":null}],[{"id":"fc993b94-ed18-4848-a988-e4cac178fb31","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_level":"order_item_group_level","bc_shipping_id":197,"total_items_count":1,"first_name":"BigCommerce","last_name":"Cart Checkout","company":"","street_1":"123 Main Street","street_2":"","city":"Austin","zip":"78751","subdivision":"US-TX","country":"US","phone":"688546","email":"jane2@example.com","shipping_cost_ex_tax":"10.000000","shipping_cost_inc_tax":"10.000000","handling_cost_ex_tax":"0.000000","handling_cost_inc_tax":"0.000000","is_shipping_price_override":null,"original_price":"10.000000","shipping_total_wo_discount":"10.000000","shipping_total_with_discount":"10.000000","currency":"CAD","shipping_instructions":null,"future_ship_date":null,"created_at":"2023-09-18T23:52:04.494158000","updated_at":"2023-09-18T23:52:04.494158000","order_id":"19cd694e-61b0-488c-aae7-f9187465888b","order_item_group_id":"8bb3b539-735e-4a47-b693-1b47d04b2ecb","order_item_id":null,"deleted_at":null,"shipping_method":"Flat Rate","recipient_date_of_birth":null,"bc_shipping_zone_id":null}],[{"id":null,"tenant_id":null,"order_level":null,"tax_type":null,"tax_rate":null,"tax_amount":null,"currency":null,"included_in_price":null,"created_at":null,"updated_at":null,"order_id":null,"order_item_group_id":null,"order_item_id":null,"deleted_at":null,"name":null}],[{"id":"f006c00c-1944-4e58-977f-a5e40dc6ee89","tenant_id":"a8f1240c-b3fa-47e4-acf4-23060acd0983","order_id":"19cd694e-61b0-488c-aae7-f9187465888b","bc_customer_id":1,"created_at":"2023-09-18T23:52:04.517172000","updated_at":"2023-09-18T23:52:04.517172000","deleted_at":null}]]