bigcommerce_order_products.json

[
        {
            "id": 329441,
            "order_id": 239344,
            "product_id": 1180,
            "variant_id": 10703,
            "order_address_id": 237073,
            "name": "Abena Boost Booster Pads",
            "sku": "4035-BG20", // "BG" == McKesson UOM
            "upc": "796433843368",
            "type": "physical",
            "base_price": "8.9900",
            "price_ex_tax": "8.9900",
            "price_inc_tax": "8.9900",
            "price_tax": "0.0000",
            "base_total": "17.9800",
            "total_ex_tax": "17.9800",
            "total_inc_tax": "17.9800",
            "total_tax": "0.0000",
            "weight": "0.0000",
            "width": "0.0000",
            "height": "0.0000",
            "depth": "0.0000",
            "quantity": 2,
            "base_cost_price": "6.7300",
            "cost_price_inc_tax": "6.7300",
            "cost_price_ex_tax": "6.7300",
            "cost_price_tax": "0.0000",
            "is_refunded": false,
            "quantity_refunded": 0,
            "refund_amount": "0.0000",
            "return_id": 0,
            "wrapping_name": "",
            "base_wrapping_cost": "0.0000",
            "wrapping_cost_ex_tax": "0.0000",
            "wrapping_cost_inc_tax": "0.0000",
            "wrapping_cost_tax": "0.0000",
            "wrapping_message": "",
            "quantity_shipped": 0,
            "event_name": null,
            "event_date": "",
            "fixed_shipping_cost": "0.0000",
            "ebay_item_id": "",
            "ebay_transaction_id": "",
            "option_set_id": 1848,
            "parent_order_product_id": null,
            "is_bundled_product": false,
            "bin_picking_number": "35043100", // bin_picking_number == McKesson Item ID
            "external_id": null,
            "fulfillment_source": "",
            "applied_discounts": [],
            "product_options": [
                {
                    "id": 358433,
                    "option_id": 1741,
                    "order_product_id": 329441,
                    "product_option_id": 2242,
                    "display_name": "Options",
                    "display_value": "Maxi - Pack of 20",
                    "value": "9155",
                    "type": "Multiple choice",
                    "name": "Options (Abena Abri-Let Maxi Pads)",
                    "display_style": "Radio Buttons"
                }
            ],
            "configurable_fields": []
        },
        {
            "id": 329442,
            "order_id": 239344,
            "product_id": 2994,
            "variant_id": 18555,
            "order_address_id": 237073,
            "name": "Dignity Incontinence Liner",
            "sku": "26955-PK25", // "PK" == McKesson UOM
            "upc": "612553019431 ",
            "type": "physical",
            "base_price": "12.9900",
            "price_ex_tax": "12.9900",
            "price_inc_tax": "12.9900",
            "price_tax": "0.0000",
            "base_total": "12.9900",
            "total_ex_tax": "12.9900",
            "total_inc_tax": "12.9900",
            "total_tax": "0.0000",
            "weight": "0.0000",
            "width": "0.0000",
            "height": "0.0000",
            "depth": "0.0000",
            "quantity": 1,
            "base_cost_price": "8.2000",
            "cost_price_inc_tax": "8.2000",
            "cost_price_ex_tax": "8.2000",
            "cost_price_tax": "0.0000",
            "is_refunded": false,
            "quantity_refunded": 0,
            "refund_amount": "0.0000",
            "return_id": 0,
            "wrapping_name": "",
            "base_wrapping_cost": "0.0000",
            "wrapping_cost_ex_tax": "0.0000",
            "wrapping_cost_inc_tax": "0.0000",
            "wrapping_cost_tax": "0.0000",
            "wrapping_message": "",
            "quantity_shipped": 0,
            "event_name": null,
            "event_date": "",
            "fixed_shipping_cost": "0.0000",
            "ebay_item_id": "",
            "ebay_transaction_id": "",
            "option_set_id": 3330,
            "parent_order_product_id": null,
            "is_bundled_product": false,
            "bin_picking_number": "69553108", // bin_picking_number == McKesson Item ID
            "external_id": null,
            "fulfillment_source": "",
            "applied_discounts": [],
            "product_options": [
                {
                    "id": 358434,
                    "option_id": 3239,
                    "order_product_id": 329442,
                    "product_option_id": 4582,
                    "display_name": "Options",
                    "display_value": "Pack of 25",
                    "value": "13603",
                    "type": "Multiple choice",
                    "name": "Options1589465365-2994",
                    "display_style": "Radio Buttons"
                }
            ],
            "configurable_fields": []
        }
    ]