# Adnex shopline order
## 現存 bigquery order 範例
| _airbyte_ab_id | _airbyte_emitted_at | _airbyte_data |
|----|----|----|
| 69dfac5d-8077-4387-9e7a-c18117e95892 | 2022-09-15 06:55:50.919000 UTC | json 見下方 |
```jsonld
{
"delivery_address": {},
"agent": {
"phone": "0902089615",
"name": "大葉高島屋-趙湘蓉",
"email": "n089615@hotmail.com",
"status": "active"
},
"skip_fulfillment": false,
"channel": {
"created_by_channel_id": "6135cc3a94c36c003ec67b47",
"created_by_channel_name": {
"zh-hant": "大葉高島屋",
"en": "大葉高島屋"
}
},
"child_order_ids": [],
"custom_discount_items": [
{
"cost": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": "NT$0"
},
"quantity": 1,
"item_id": null,
"ref_data": null,
"is_preorder": false,
"item_type": "CustomDiscount",
"item_price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"item_variation_id": "",
"media": {},
"item_variation_key": "",
"title_translations": {
"de": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"vi": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"th": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"zh-hant": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"zh-hk": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"zh-tw": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"ms": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"ja": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"en": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"id": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"fr": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"zh-cn": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)"
},
"created_by": null,
"item_data": {
"discount_special_flag": 0,
"name": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"discount_level": 2,
"discount_type": 2,
"discount_id": "6142b80ee8e3040029fd8d69"
},
"discounted_price": null,
"total": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"object_data": {
"status": "temp"
},
"price_sale": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"order_discounted_price": null,
"price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"product_subscription_id": null,
"fields_translations": {},
"id": "63207fefb0bc4e54bed165ca",
"sku": ""
}
],
"payment_slips": [],
"order_points_to_cash": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"cart_attributes": {},
"order_delivery": {
"shipped_at": null,
"require_expired_upload": false,
"requested_fmt_at": null,
"requires_customer_address": false,
"remark": null,
"request_accepted_at": null,
"platform": "pos",
"exp_type": null,
"collected_at": null,
"storeclosed_upload_at": null,
"total": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"require_storeclosed_upload": false,
"delivery_option_id": "611a235407ec3110c1d6431d",
"updated_at": "2022-09-13T13:04:47.694+00:00",
"store_closed_at": null,
"name_translations": {
"zh-hant": "實體商店取貨",
"en": "pick up at offline store",
"zh-cn": "实体商店取货"
},
"returned_at": null,
"request_submitted_at": null,
"return_order_id": null,
"id": "63207fefa083ff001cf01548",
"delivery_status": "pending",
"arrived_at": null,
"status": "collected",
"request_authorized_at": null
},
"affiliate_data": {},
"order_discount": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"order_comments": [],
"inclusive_tax_info": {},
"cart_page_id": null,
"id": "63207fed41de9cab4ed165c8",
"total_tax_fee": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"currency_iso": "TWD",
"customer_phone": null,
"created_by": "pos",
"ga_tracked": false,
"tags": [],
"subtotal": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"customer_email": null,
"custom_data": [],
"utm_data": {},
"delivery_data": {},
"status": "completed",
"order_points": 0,
"customer_phone_country_code": null,
"order_notes": [],
"promotion_items": [],
"order_number": "20220913130447130",
"ref_customer_id": null,
"subtotal_items": [
{
"cost": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": "NT$0"
},
"quantity": 1,
"item_id": "6142b521b25013001df87433",
"ref_data": null,
"is_preorder": false,
"item_type": "Product",
"item_price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"item_variation_id": "",
"media": {
"images": {
"favicon_large": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"original": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"transparent_large": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"favicon_small": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"favicon": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"thumb": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"transparent_xlarge": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"transparent_thumb": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
},
"source": {
"width": 600,
"url": "https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989",
"height": 600
}
},
"updated_at": 0,
"_id": "614d26263f42be0026b36554"
},
"item_variation_key": "",
"title_translations": {
"de": "",
"vi": "",
"th": "",
"zh-hant": "冷凍鱸魚精 單包",
"ms": "",
"ja": "",
"en": "",
"id": "",
"fr": "",
"zh-cn": ""
},
"created_by": "admin",
"item_data": {
"order_custom_discount_items": {
"order_discounted_price": [],
"discounted_price": "63207fefb0bc4e54bed165ca"
},
"order_discounted_price": {
"currency_symbol": "",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0,
"label": ""
},
"selected_child_products": null,
"has_exclude_promotion_tag": false,
"order_promotion_items": null,
"price_set": {
"price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200,
"label": ""
},
"price_details": [],
"product_id": "6142b521b25013001df87433",
"merchant_id": "6052b2677574580048ed657b",
"id": "63207fef92de4745aad165cb"
},
"listing": {
"price_info": {
"currency_iso": "TWD",
"cents": 200
},
"product": {
"collection_id": {
"name": "搭贈/試吃",
"_id": "81619554-67a7-4cbc-9e90-b3430bb40812",
"desc": ""
},
"listing_ids": [],
"check_inventory": true,
"name": "冷凍鱸魚精 單包",
"image_urls": [
"https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989"
],
"_id": "7921b2a7-c66f-401c-9107-56975ae57a20",
"variants": [
{
"values": [],
"label": ""
}
],
"supplier_id": {
"note": "",
"address": "",
"phone": "",
"name": ""
},
"tags": []
},
"cost": 0,
"cost_info": {
"currency_iso": "TWD",
"cents": 0
},
"discount_amount": 200,
"discount_level": 2,
"discount_type": 2,
"type": "lineitem",
"credit_ratio_amount": 0,
"price": 200,
"discount_amount_info": {
"currency_iso": "TWD",
"cents": 200
},
"qty": 1,
"discount_name": "試喝商品(常溫/冷凍滴雞精、常溫/冷凍鱸魚精類)",
"name": "冷凍鱸魚精 單包",
"is_returned_item": false,
"discount_result_info": {
"currency_iso": "TWD",
"cents": 0
},
"discount_ratio_amount": 0,
"listing": {
"price_info": {
"currency_iso": "TWD",
"cents": 200
},
"cost": 0,
"cost_info": {
"currency_iso": "TWD",
"cents": 0
},
"price": 200,
"product_id": "6142b521b25013001df87433",
"name": "冷凍鱸魚精 單包",
"image_urls": [
"https://img.shoplineapp.com/media/image_clips/614d26263f42be0026b36554/original.jpg?1632445989"
],
"barcode_type": "",
"_id": "049fb4f5-ff2a-427f-91ef-3a23e510e53e",
"variants": [],
"sku": "UB60",
"barcode": "4713758487035"
},
"discount_result": 0,
"discount_id": "6142b80ee8e3040029fd8d69"
},
"discounted_price": {
"currency_symbol": "",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200,
"label": ""
}
},
"discounted_price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"total": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 200,
"dollars": 200.0,
"label": "NT$200"
},
"object_data": {
"condition": "new",
"gtin": "4713758487035",
"gender": "unisex",
"age_group": "all_ages",
"weight": 0.0,
"barcode_type": "Code 128",
"mpn": "",
"adult": "no",
"max_order_quantity": -1,
"brand": "農純鄉",
"location_id": "",
"status": "draft"
},
"price_sale": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": "NT$0"
},
"order_discounted_price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"price": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"product_subscription_id": null,
"fields_translations": {},
"id": "63207fef5b7b907869d165c9",
"sku": "UB60"
}
],
"ref_order_id": "",
"created_at": "2022-09-13T13:04:47.122+00:00",
"system_order_number": "20220913130447130",
"total": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": "NT$0"
},
"split_at": null,
"order_remarks": null,
"updated_at": "2022-09-13T13:04:47.725+00:00",
"is_guest_checkout": true,
"customer_info": {},
"parent_order_id": "",
"confirmed_at": null,
"applied_tax_info": {
"delivery": {},
"sales": {}
},
"user_credit": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"order_payment": {
"created_at": "2022-09-13T13:04:47.390+00:00",
"paid_at": "2022-09-13T13:04:47.661+00:00",
"payment_method_id": "611a235407ec3110c1d6431c",
"payment_type": "pos",
"total": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"updated_at": "2022-09-13T13:04:47.661+00:00",
"name_translations": {
"zh-hant": "實體商店付款",
"en": "offline store payment",
"zh-cn": "实体商店付款"
},
"payment_fee": {
"currency_symbol": "NT$",
"currency_iso": "TWD",
"cents": 0,
"dollars": 0.0,
"label": ""
},
"payment_data": {},
"id": "63207fefa083ff001cf01547",
"last_four_digits": "",
"ref_payment_id": null,
"status": "completed"
},
"order_source": {
"name": {
"zh-hant": "大葉高島屋",
"en": "大葉高島屋"
},
"id": "6156b05c95e6e30029ad2911",
"source_id": "6135cc3a94c36c003ec67b47",
"type": "offline_store"
},
"customer_name": null,
"invoice": {
"mailing_address": "",
"carrier_type": "",
"n_p_o_b_a_n": "",
"invoice_cancelled_at": null,
"buyer_name": "",
"invoice_type": "",
"carrier_number": "",
"invoice_number": "",
"tax_id": "",
"invoice_tax_type": "",
"invoice_status": "",
"invoice_date": null
},
"customer_id": null,
"created_from": "pos",
"merchant_order_number": null
}
```
Sign in with Wallet
Connect another wallet