OrderItems
Returns order items based on the Amazon Order Id that you specify.
Select
The connector 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 connector. 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. |