---
# System prepended metadata

title: Adnex shopline order

---

# 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
}
```