OrderItems
Returns order items based on the Amazon Order Id that you specify.
Select
The add-in will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field.
- AmazonOrderId supports the '=' comparison.
SELECT * FROM OrderItems WHERE AmazonOrderId = '503-9993250-1405404'
Columns
| Name | Type | References | Description |
| OrderItemId [KEY] | String | An Amazon-defined order item identifier. | |
| AmazonOrderId | String |
Orders.AmazonOrderId | The Amazon ID of the order. |
| ASIN | String | The Amazon Standard Identification Number (ASIN) of the item. | |
| SellerSKU | String | The seller stock keeping unit (SKU) of the item. | |
| BuyerCustomizedInfoCustomizedURL | String | The Buyer CustomizedURL. | |
| Title | String | The name of the item. | |
| QuantityOrdered | Integer | The quantity of items ordered. | |
| QuantityShipped | Integer | The quantity of items shipped. | |
| GrantedPointsNumber | Integer | The Granted Points Number. | |
| GrantedPointsMonetaryValueAmount | Decimal | The Granted Points Amount. | |
| GrantedPointsMonetaryValueCurrencyCode | String | The Granted Points CurrencyCode. | |
| NumberOfItems | Integer | The total number of items that are included in the ASIN. | |
| ItemPriceAmount | Decimal | The Item Price Amount. | |
| ItemPriceCurrencyCode | String | The Item Price Currency Code. | |
| ShippingPriceAmount | Decimal | The Shipping Price Amount. | |
| ShippingPriceCurrencyCode | String | The Shipping Price Currency Code. | |
| ItemTaxAmount | Decimal | The Item Tax Amount. | |
| ItemTaxCurrencyCode | String | The Item Tax Currency Code. | |
| ShippingTaxAmount | String | The Shipping Tax Amount. | |
| ShippingTaxCurrencyCode | String | The ShippingTax Currency Code. | |
| ShippingDiscountAmount | String | The Shipping Discount Amount. | |
| ShippingDiscountCurrencyCode | String | The Shipping Discount Currency Code. | |
| ShippingDiscountTaxAmount | String | The Shipping Discount Tax Amount. | |
| ShippingDiscountTaxCurrencyCode | String | The Shipping Discount Tax Currency Code. | |
| PromotionDiscountAmount | Decimal | The Promotion Discount Amount. | |
| PromotionDiscountCurrencyCode | String | The Promotion Discount Currency Code. | |
| PromotionDiscountTaxAmount | Decimal | The Promotion Discount Tax Amount. | |
| PromotionDiscountTaxCurrencyCode | String | The Promotion Discount Tax Currency Code. | |
| PromotionIds | String | The IDs of Promotions. | |
| CODFeeAmount | Decimal | The COD FeeAmount. | |
| CODFeeCurrencyCode | String | The COD FeeCurrency Code. | |
| CODFeeDiscountAmount | String | The COD FeeDiscount Amount. | |
| CODFeeDiscountCurrencyCode | String | The COD FeeDiscount Currency Code. | |
| IsGift | Boolean | Boolean specifying if the item is gift. | |
| ConditionNote | String | The Condition Note. | |
| ConditionId | String | The Condition Id. | |
| ConditionSubtypeId | String | The Condition Subtype Id. | |
| ScheduledDeliveryStartDate | Datetime | The Scheduled Delivery StartDate. | |
| ScheduledDeliveryEndDate | Datetime | The Scheduled Delivery EndDate. | |
| PriceDesignation | String | The Price Designation. | |
| TaxCollectionModel | String | The tax collection model applied to the item. | |
| TaxCollectionResponsibleParty | String | The party responsible for withholding the taxes and remitting them to the taxing authority. | |
| SerialNumberRequired | Boolean | When true, the product type for this item has a serial number. Returned only for Amazon Easy Ship orders. | |
| IsTransparency | Boolean | When true, transparency codes are required. | |
| IossNumber | String | The IOSS number for the marketplace. | |
| StoreChainStoreId | String | The store chain store identifier. Linked to a specific store in a store chain. | |
| DeemedResellerCategory | String | Applies to selling partners that are not based in the EU and is used to help them meet the VAT Deemed Reseller tax laws in the EU and UK. | |
| IsBuyerRequestedCancel | Boolean | When true, the buyer has requested cancellation. | |
| BuyerCancelReason | String | The reason that the buyer requested cancellation. | |
| BuyerCustomizedInfoURL | String | The location of a zip file containing Amazon Custom data. | |
| GiftWrapPriceAmount | String | The Gift Wrap Price Amount. | |
| GiftWrapPriceCurrencyCode | String | The Gift Wrap Price Currency Code. | |
| GiftWrapTaxAmount | String | The Gift Wrap Tax Amount. | |
| GiftWrapTaxCurrencyCode | String | The Gift Wrap Tax Currency Code. | |
| GiftMessageText | String | A gift message provided by the buyer. | |
| GiftWrapLevel | String | The gift wrap level specified by the buyer. | |
| AssociatedItems | String | A list of associated items that a customer has purchased with a product. For example, a tire installation service purchased with tires. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| LastUpdateDate | Datetime | The last time the order is updated. |