Lists 50 order products on an order using order_id. By default, items are sorted from lowest to highest according to a newly created ID, separate from the order_id and the product_id.
ID of the pickup fulfillment method for this item. Default value is 0 when the item is not fulfilled by pickup method.
order_address_idinteger
Numeric ID of the associated order address. Value is 0 for items that are not fulfilled by a pickup method.
Example: 20
namestring
Alias for name_customer - The product name that is shown to customer in storefront.
>= 1 characters
Example: Fog Linen Chambray Towel - Beige Stripe
skustring
User-defined product code/stock keeping unit (SKU).
Example: S-GREE
typestring
Type of product.
Allowed: physical | digital | giftcertificate
Example: physical
base_pricestring
The product’s base price. (Float, Float-As-String, Integer)
Example: 54.0000
price_ex_taxstring
The product’s price excluding tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
price_inc_taxstring
The product’s price including tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
price_taxstring
Amount of tax applied to a single product.
Price tax is calculated as:
price_tax = price_inc_tax - price_ex_tax
(Float, Float-As-String, Integer)
Example: 0.0000
base_totalstring
Total base price. (Float, Float-As-String, Integer)
Note: The base_total is affected by the tax options set up in the control panel and is altered on tax-free orders. See more details on how base_total is affected by visiting the Responsive Tax Display Settings overview. If the base_total is $0, it's due to the store's tax settings. To learn more about tax settings in the control panel, check out this Tax Settings support article.
Example: 54.0000
total_ex_taxstring
Total base price excluding tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
total_inc_taxstring
Total base price including tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
total_taxstring
Total tax applied to products.
For example, if quantity if 2, base price is 5 and tax rate is 10%. price_tax will be $.50 and total_tax will be $1.00.
If there is a manual discount applied total_tax is calculated as the following:
(price_ex_tax - discount)*tax_rate=total_tax.
(Float, Float-As-String, Integer)
Example: 0.5200
quantityinteger
Quantity of the product ordered.
Example: 1
base_cost_pricestring
The product’s cost price. This can be set using the Catalog API. (Float, Float-As-String, Integer)
Example: 50.0000
cost_price_inc_taxstring
The product’s cost price including tax. (Float, Float-As-String, Integer)
The cost of your products to you; this is never shown to customers, but can be used for accounting purposes. The value can't be negative.
Example: 50.0000
cost_price_ex_taxstring
The product cost price excluding tax. (Float, Float-As-String, Integer)
The cost of your products to you; this is never shown to customers, but can be used for accounting purposes. The value can't be negative.
Example: 50.0000
weight
Weight of the product. The value can't be negative. (Float, Float-As-String, Integer)
One of:string
Type: number
Example: 1
widthstring
Product width. The value can't be negative.
Example: 1.0000
heightstring
Product height. The value can't be negative.
Example: 1.0000
depthstring
Product depth. The value can't be negative.
Example: 1.0000
cost_price_taxstring
Tax applied to the product’s cost price. (Float, Float-As-String, Integer)
The cost of your products to you; this is never shown to customers, but can be used for accounting purposes. Read Only
Example: 54.0000
is_refundedboolean
Whether the product has been refunded.
quantity_refundednumber
The total quantity of product refunded from this transaction.
refund_amountstring
deprecated
The amount refunded from this transaction; always returns 0. (Float, Float-As-String, Integer)
Example: 0.0000
return_idnumber
Numeric ID for the refund.
wrapping_idinteger
ID of the gift wrapping option.
wrapping_namestring or null
Name of gift-wrapping option.
base_wrapping_cost
The value of the base wrapping cost. The value can't be negative. (Float, Float-As-String, Integer)
One of:stringnumber
Type: string
Example: 0.0000
wrapping_cost_ex_taxstring
The value of the wrapping cost, excluding tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 0.0000
wrapping_cost_inc_taxstring
The value of the wrapping cost, including tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 0.0000
wrapping_cost_taxstring
Tax applied to gift-wrapping option. (Float, Float-As-String, Integer)
Example: 0.0000
wrapping_messagestring
Message to accompany gift-wrapping option.
quantity_shippednumber
Quantity of this item shipped.
event_namestring or null
Name of promotional event/delivery date.
event_datestring or null
Date of the promotional event/scheduled delivery.
fixed_shipping_coststring
Fixed shipping cost for this product. (Float, Float-As-String, Integer)
Example: 0.0000
ebay_item_idstring
Item ID for this product on eBay.
ebay_transaction_idstring
Transaction ID for this product on eBay.
option_set_idinteger or null
Numeric ID of the option set applied to the product.
Example: 5
parent_order_product_idinteger or null
ID of a parent product.
is_bundled_productboolean
Whether this product is bundled with other products.
bin_picking_numberstring
Bin picking number for the physical product.
external_idstring or null
read-only
(Read-only) ID of the order in another system. For example, the Amazon order ID if this is an Amazon order.
brandstring
The productʼs brand.
applied_discountsarray[object]
Array of objects containing discounts applied to the product.
Universal Product Code. Can be written to for custom products and catalog products.
<= 255 characters
variant_idinteger
Products variant_id. PUT or POST. This field is not available for custom products.
name_customerstring
The product name that is shown to customer in storefront.
Example: Fog Linen Chambray Towel - Beige Stripe
name_merchantstring
The product name that is shown to merchant in Control Panel.
Example: Towel Type 1
gift_certificate_idinteger or null
ID of the associated gift certificate.
Example: 52
discounted_total_inc_taxstring
Represent the correct total amount of the line item after deducting all the discounts and including the tax. This number can be used for accounting purpose.
This makes it easier to have the "shopper paid" value for a line item and api user doesn't have to do any calculation to deduct discount on the client side.
This field includes all types of discounts (automatic, coupon, manual) and therefore if you use this value, you don't need to deduct any more discounts at line item level or order level.
ID of the pickup fulfillment method for this item. Default value is 0 when the item is not fulfilled by pickup method.
order_address_idinteger
Numeric ID of the associated order address. Value is 0 for items that are not fulfilled by a pickup method.
Example: 20
namestring
Alias for name_customer - The product name that is shown to customer in storefront.
>= 1 characters
Example: Fog Linen Chambray Towel - Beige Stripe
skustring
User-defined product code/stock keeping unit (SKU).
Example: S-GREE
typestring
Type of product.
Allowed: physical | digital | giftcertificate
Example: physical
base_pricestring
The product’s base price. (Float, Float-As-String, Integer)
Example: 54.0000
price_ex_taxstring
The product’s price excluding tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
price_inc_taxstring
The product’s price including tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
price_taxstring
Amount of tax applied to a single product.
Price tax is calculated as:
price_tax = price_inc_tax - price_ex_tax
(Float, Float-As-String, Integer)
Example: 0.0000
base_totalstring
Total base price. (Float, Float-As-String, Integer)
Note: The base_total is affected by the tax options set up in the control panel and is altered on tax-free orders. See more details on how base_total is affected by visiting the Responsive Tax Display Settings overview. If the base_total is $0, it's due to the store's tax settings. To learn more about tax settings in the control panel, check out this Tax Settings support article.
Example: 54.0000
total_ex_taxstring
Total base price excluding tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
total_inc_taxstring
Total base price including tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 54.0000
total_taxstring
Total tax applied to products.
For example, if quantity if 2, base price is 5 and tax rate is 10%. price_tax will be $.50 and total_tax will be $1.00.
If there is a manual discount applied total_tax is calculated as the following:
(price_ex_tax - discount)*tax_rate=total_tax.
(Float, Float-As-String, Integer)
Example: 0.5200
quantityinteger
Quantity of the product ordered.
Example: 1
base_cost_pricestring
The product’s cost price. This can be set using the Catalog API. (Float, Float-As-String, Integer)
Example: 50.0000
cost_price_inc_taxstring
The product’s cost price including tax. (Float, Float-As-String, Integer)
The cost of your products to you; this is never shown to customers, but can be used for accounting purposes. The value can't be negative.
Example: 50.0000
cost_price_ex_taxstring
The product cost price excluding tax. (Float, Float-As-String, Integer)
The cost of your products to you; this is never shown to customers, but can be used for accounting purposes. The value can't be negative.
Example: 50.0000
weight
Weight of the product. The value can't be negative. (Float, Float-As-String, Integer)
One of:numberstring
Type: number
Example: 1
widthstring
Product width. The value can't be negative.
Example: 1.0000
heightstring
Product height. The value can't be negative.
Example: 1.0000
depthstring
Product depth. The value can't be negative.
Example: 1.0000
cost_price_taxstring
Tax applied to the product’s cost price. (Float, Float-As-String, Integer)
The cost of your products to you; this is never shown to customers, but can be used for accounting purposes. Read Only
Example: 54.0000
is_refundedboolean
Whether the product has been refunded.
quantity_refundednumber
The total quantity of product refunded from this transaction.
refund_amountstring
deprecated
The amount refunded from this transaction; always returns 0. (Float, Float-As-String, Integer)
Example: 0.0000
return_idnumber
Numeric ID for the refund.
wrapping_idinteger
ID of the gift wrapping option.
wrapping_namestring or null
Name of gift-wrapping option.
base_wrapping_cost
The value of the base wrapping cost. The value can't be negative. (Float, Float-As-String, Integer)
One of:stringnumber
Type: string
Example: 0.0000
wrapping_cost_ex_taxstring
The value of the wrapping cost, excluding tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 0.0000
wrapping_cost_inc_taxstring
The value of the wrapping cost, including tax. The value can't be negative. (Float, Float-As-String, Integer)
Example: 0.0000
wrapping_cost_taxstring
Tax applied to gift-wrapping option. (Float, Float-As-String, Integer)
Example: 0.0000
wrapping_messagestring
Message to accompany gift-wrapping option.
quantity_shippednumber
Quantity of this item shipped.
event_namestring or null
Name of promotional event/delivery date.
event_datestring or null
Date of the promotional event/scheduled delivery.
fixed_shipping_coststring
Fixed shipping cost for this product. (Float, Float-As-String, Integer)
Example: 0.0000
ebay_item_idstring
Item ID for this product on eBay.
ebay_transaction_idstring
Transaction ID for this product on eBay.
option_set_idinteger or null
Numeric ID of the option set applied to the product.
Example: 5
parent_order_product_idinteger or null
ID of a parent product.
is_bundled_productboolean
Whether this product is bundled with other products.
bin_picking_numberstring
Bin picking number for the physical product.
external_idstring or null
read-only
(Read-only) ID of the order in another system. For example, the Amazon order ID if this is an Amazon order.
brandstring
The productʼs brand.
applied_discountsarray[object]
Array of objects containing discounts applied to the product.
Universal Product Code. Can be written to for custom products and catalog products.
<= 255 characters
variant_idinteger
Products variant_id. PUT or POST. This field is not available for custom products.
name_customerstring
The product name that is shown to customer in storefront.
Example: Fog Linen Chambray Towel - Beige Stripe
name_merchantstring
The product name that is shown to merchant in Control Panel.
Example: Towel Type 1
gift_certificate_idinteger or null
ID of the associated gift certificate.
Example: 52
discounted_total_inc_taxstring
Represent the correct total amount of the line item after deducting all the discounts and including the tax. This number can be used for accounting purpose.
This makes it easier to have the "shopper paid" value for a line item and api user doesn't have to do any calculation to deduct discount on the client side.
This field includes all types of discounts (automatic, coupon, manual) and therefore if you use this value, you don't need to deduct any more discounts at line item level or order level.