OrderItems

OrderItems is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information

Select

The add-in uses the AdobeCommerce API to filter the results by ItemId while the rest of the filter is executed client side within the add-in.

The following examples demonstrate the types of queries processed on the server.

Retrieve information about all order items:
```
SELECT * FROM OrderItems
```
Filter by ItemId to get detailed information about an order item:
```
SELECT * FROM OrderItems WHERE ItemId = '3'
```

Columns


Name	Type	Description
AdditionalData	String	Additional data.
Id	String	id
AmountRefunded	Double	Amount refunded.
AppliedRuleIds	String	Applied rule IDs.
BaseAmountRefunded	Double	Base amount refunded.
BaseCost	Double	Base cost.
BaseDiscountAmount	Double	Base discount amount.
BaseDiscountInvoiced	Double	Base discount invoiced.
BaseDiscountRefunded	Double	Base discount refunded.
BaseDiscountTaxCompensationAmount	Double	Base discount tax compensation amount.
BaseDiscountTaxCompensationInvoiced	Double	Base discount tax compensation invoiced.
BaseDiscountTaxCompensationRefunded	Double	Base discount tax compensation refunded.
BaseOriginalPrice	Double	Base original price.
BasePrice	Double	Base price.
BasePriceInclTax	Double	Base price including tax.
BaseRowInvoiced	Double	Base row invoiced.
BaseRowTotal	Double	Base row total.
BaseRowTotalInclTax	Double	Base row total including tax.
BaseTaxAmount	Double	Base tax amount.
BaseTaxBeforeDiscount	Double	Base tax before discount.
BaseTaxInvoiced	Double	Base tax invoiced.
BaseTaxRefunded	Double	Base tax refunded.
BaseWeeeTaxAppliedAmount	Double	Base WEEE tax applied amount.
BaseWeeeTaxAppliedRowAmnt	Double	Base WEEE tax applied row amount.
BaseWeeeTaxDisposition	Double	Base WEEE tax disposition.
BaseWeeeTaxRowDisposition	Double	Base WEEE tax row disposition.
CreatedAt	Datetime	Created-at timestamp.
Description	String	Description.
DiscountAmount	Double	Discount amount.
DiscountInvoiced	Double	Discount invoiced.
DiscountPercent	Double	Discount percent.
DiscountRefunded	Double	Discount refunded.
DiscountTaxCompensationAmount	Double	Discount tax compensation amount.
DiscountTaxCompensationCanceled	Double	Discount tax compensation canceled.
DiscountTaxCompensationInvoiced	Double	Discount tax compensation invoiced.
DiscountTaxCompensationRefunded	Double	Discount tax compensation refunded.
ExtensionAttributes	String	This is an auto-generated column
ExtOrderItemId	String	External order item ID.
FreeShipping	Int	Free-shipping flag value.
IsQtyDecimal	Int	Is-quantity-decimal flag value.
IsVirtual	Int	Is-virtual flag value.
ItemId [KEY]	Int	Item ID.
LockedDoInvoice	Int	Locked DO invoice flag value.
LockedDoShip	Int	Locked DO ship flag value.
Name	String	Name.
NoDiscount	Int	No-discount flag value.
OrderId	Int	Order ID.
OriginalPrice	Double	Original price.
ParentItem	String	This is an auto-generated column
ParentItemId	Int	Parent item ID.
Price	Double	Price.
PriceInclTax	Double	Price including tax.
ProductId	Int	Product ID.
ProductOption	String	This is an auto-generated column
ProductType	String	Product type.
QtyBackordered	Double	Quantity backordered.
QtyCanceled	Double	Quantity canceled.
QtyInvoiced	Double	Quantity invoiced.
QtyOrdered	Double	Quantity ordered.
QtyRefunded	Double	Quantity refunded.
QtyShipped	Double	Quantity shipped.
QuoteItemId	Int	Quote item ID.
RowInvoiced	Double	Row invoiced.
RowTotal	Double	Row total.
RowTotalInclTax	Double	Row total including tax.
RowWeight	Double	Row weight.
SearchCriteria	String	This is an auto-generated column
Sku	String	SKU.
StoreId	Int	Store ID.
TaxAmount	Double	Tax amount.
TaxBeforeDiscount	Double	Tax before discount.
TaxCanceled	Double	Tax canceled.
TaxInvoiced	Double	Tax invoiced.
TaxPercent	Double	Tax percent.
TaxRefunded	Double	Tax refunded.
TotalCount	Int	Total count.
UpdatedAt	Datetime	Updated-at timestamp.
WeeeTaxApplied	String	WEEE tax applied.
WeeeTaxAppliedAmount	Double	WEEE tax applied amount.
WeeeTaxAppliedRowAmount	Double	WEEE tax applied row amount.
WeeeTaxDisposition	Double	WEEE tax disposition.
WeeeTaxRowDisposition	Double	WEEE tax row disposition.
Weight	Double	Weight.

Excel Add-In for Adobe Commerce

OrderItems

Table Specific Information

Select

Columns