Fields Reference · Amazon Seller

Amazon Seller Fields List

133 fields · 0 dimensions · 0 metrics · 9 groups

Data Studio

Google Sheets

BigQuery

View Amazon Seller connector →

133 of 133

Field name	Label	Category	Description
`AmazonOrderId`	Amazon Order Id	Orders	An Amazon-defined order identifier, in 3-7-7 format.
`BuyerInvoicePreference`	Buyer Invoice Preference	Orders	The buyer’s invoicing preference. Available only in the TR marketplace.
`CbaDisplayableShippingLabel`	Cba Displayable Shipping Label	Orders	Custom ship label for Checkout by Amazon (CBA).
`Currency`	Currency code	Orders	The currency code.
`EarliestDeliveryDate`	Earliest Delivery Date	Orders	The start of the time period within which you have committed to fulfill the order.
`EarliestShipDate`	Earliest Ship Date	Orders	The start of the time period within which you have committed to ship the order.
`EasyShipShipmentStatus`	Easy Ship Shipment Status	Orders	The status of the Easy Ship order.
`ElectronicInvoiceStatus`	Electronic Invoice Status	Orders	The status of the electronic invoice.
`FulfillmentChannel`	Fulfillment Channel	Orders	Indicates whether the order was fulfilled by Amazon (AFN) or by the seller (MFN).
`HasRegulatedItems`	Has Regulated Items	Orders	Whether the order contains regulated items which may require additional approval steps before being fulfilled.
`IsAccessPointOrder`	Is Access Point Order	Orders	Indicates whether the order is an Amazon Hub Counter order.
`IsBusinessOrder`	Is Business Order	Orders	Indicates whether the order is a business order.
`IsEstimatedShipDateSet`	Is Estimated Ship Date Set	Orders	Indicates whether the seller has set the estimated ship date.
`IsGlobalExpressEnabled`	Is Global Express Enabled	Orders	Indicates whether the order is a Global Express order.
`IsIBA`	Is IBA	Orders	Indicates whether the order is an Individual Buyer Agreement (IBA) order.
`IsISPU`	Is ISPU	Orders	Indicates whether the order is an In-Store Pickup (ISPU) order.
`IsPremiumOrder`	Is Premium Order	Orders	When true, the order has a Premium Shipping Service Level Agreement.
`IsPrime`	Is Prime	Orders	Indicates whether the order is a seller-fulfilled Amazon Prime order.
`IsReplacementOrder`	Is Replacement Order	Orders	Indicates whether the order is a replacement order.
`IsSoldByAB`	Is Sold By AB	Orders	Indicates whether the order is sold by Amazon Business.
`LastUpdateDate`	Last Update Date	Orders	The date when the order was last updated. Note that an order update is defined as any change in order status, including the creation of a new order.
`LatestDeliveryDate`	Latest Delivery Date	Orders	The end of the time period within which you have committed to fulfill the order.
`LatestShipDate`	Latest Ship Date	Orders	The end of the time period within which you have committed to ship the order.
`MarketplaceId`	Marketplace Id	Orders	The identifier for the marketplace where the order was placed.
`NumberOfItemsShipped`	Number Of Items Shipped	Orders	The number of items shipped.
`NumberOfItemsUnshipped`	Number Of Items Unshipped	Orders	The number of items unshipped.
`OrderChannel`	Order Channel	Orders	The order channel of the first item in the order.
`OrderStatus`	Order Status	Orders	The current status of the order.
`OrderTotalAmount`	Order Total Amount	Orders	The total charge for the order.
`OrderType`	Order Type	Orders	The type of the order.
`PromiseResponseDueDate`	Promise Response Due Date	Orders	The date by which the seller must respond to the buyer with an estimated ship date.
`PurchaseDate`	Purchase Date	Orders	The date when the order was created.
`ReplacedOrderId`	Replaced Order Id	Orders	The order ID value for the order that is being replaced.
`SalesChannel`	Sales Channel	Orders	The sales channel of the first item in the order.
`SellerOrderId`	Seller Order Id	Orders	A seller-defined order identifier.
`ShipServiceLevel`	Ship Service Level	Orders	The shipment service level of the order.
`ShipmentServiceLevelCategory`	Shipment Service Level Category	Orders	The shipment service level category of the order.
`ASIN`	ASIN	Items	The Amazon Standard Identification Number (ASIN) of the item.
`CODFee`	COD Fee	Items	The COD fee.
`CODFeeDiscount`	COD Fee Discount	Items	The COD fee discount.
`ConditionId`	Condition Id	Items	The condition ID.
`ConditionNote`	Condition Note	Items	The condition note.
`ConditionSubtypeId`	Condition Subtype Id	Items	The condition subtype ID.
`DeemedResellerCategory`	Deemed Reseller Category	Items	The deemed reseller category.
`IossNumber`	Ioss Number	Items	The IOSS number.
`IsGift`	Is Gift	Items	Whether the item is a gift.
`IsTransparency`	Is Transparency	Items	Whether the item is a Transparency item.
`ItemPrice`	Item Price	Items	The price per item.
`ItemTax`	Item Tax	Items	The tax on the item price.
`MonetaryValueOfPointsGranted`	Monetary Value Of Points Granted	Items	The monetary value of the points granted.
`NumberOfItems`	Number Of Items	Items	The total number of items that are included in the ASIN.
`NumbersOfPointsGranted`	Numbers Of Points Granted	Items	The number of points granted.
`OrderItemId`	Order Item Id	Items	The Amazon-defined identifier for an item in an order.
`PriceDesignation`	Price Designation	Items	Indicates that the selling price is a special price that is available only for Amazon Business orders.
`PromotionDiscount`	Promotion Discount	Items	The promotion discount.
`PromotionDiscountTax`	Promotion Discount Tax	Items	The tax on the promotion discount.
`PromotionIds`	Promotion Ids	Items	The promotion IDs.
`QuantityOrdered`	Quantity Ordered	Items	The number of items ordered.
`QuantityShipped`	Quantity Shipped	Items	The number of items shipped.
`ScheduledDeliveryEndDate`	Scheduled Delivery End Date	Items	The scheduled delivery end date.
`ScheduledDeliveryStartDate`	Scheduled Delivery Start Date	Items	The scheduled delivery start date.
`SellerSKU`	Seller SKU	Items	The seller SKU of the item.
`SerialNumberRequired`	Serial Number Required	Items	Whether the item requires a serial number.
`SerialNumbers`	Serial Numbers	Items	The serial numbers.
`ShippingDiscount`	Shipping Discount	Items	The shipping discount.
`ShippingDiscountTax`	Shipping Discount Tax	Items	The tax on the shipping discount.
`ShippingPrice`	Shipping Price	Items	The shipping price.
`ShippingTax`	Shipping Tax	Items	The tax on the shipping price.
`StoreChainStoreId`	Store Chain Store Id	Items	The store chain store ID.
`TaxCollectionModel`	Tax Collection Model	Items	The tax collection model.
`TaxCollectionResponsibleParty`	Tax Collection Responsible Party	Items	The tax collection responsible party.
`Title`	Title	Items	The name of the item.
`InventorylastUpdatedTime`	Inventory Last Updated Time	FBA Inventory	The last updated time of the inventory.
`carrierDamagedQuantity`	Carrier Damaged Quantity	FBA Inventory	The number of units in carrier damaged disposition.
`customerDamagedQuantity`	Customer Damaged Quantity	FBA Inventory	The number of units in customer damaged disposition.
`defectiveQuantity`	Defective Quantity	FBA Inventory	The number of units in defective disposition.
`distributorDamagedQuantity`	Distributor Damaged Quantity	FBA Inventory	The number of units in distributor damaged disposition.
`expiredQuantity`	Expired Quantity	FBA Inventory	The number of units in expired disposition.
`fcProcessingQuantity`	FC Processing Quantity	FBA Inventory	The number of units in Amazon fulfillment centers that are being processed for customer orders.
`fnSku`	Fulfillment Network SKU	FBA Inventory	The Fulfillment Network SKU.
`fulfillableQuantity`	Fulfillable Quantity	FBA Inventory	The number of units in an inbound shipment or in Amazon fulfillment centers that are available for fulfillment.
`inboundReceivingQuantity`	Inbound Receiving Quantity	FBA Inventory	The number of units in an inbound shipment that are being received at Amazon fulfillment centers.
`inboundShippedQuantity`	Inbound Shipped Quantity	FBA Inventory	The number of units in an inbound shipment that have been received at Amazon fulfillment centers.
`inboundWorkingQuantity`	Inbound Working Quantity	FBA Inventory	The number of units in an inbound shipment that are being processed for placement into fulfillment centers.
`pendingCustomerOrderQuantity`	Pending Customer Order Quantity	FBA Inventory	The number of units in Amazon fulfillment centers that are reserved for customer orders.
`pendingTransshipmentQuantity`	pending Transshipment Quantity	FBA Inventory	The number of units being transferred from one fulfillment center to another.
`productName`	Product Name	FBA Inventory	The name of the product.
`productType`	Product Type	FBA Inventory	The type of the product.
`totalQuantity`	Total Quantity	FBA Inventory	The total number of units in an inbound shipment or in Amazon fulfillment centers.
`totalResearchingQuantity`	Total Researching Quantity	FBA Inventory	The total number of units in an inbound shipment or in Amazon fulfillment centers that are being researched.
`totalReservedQuantity`	Total Reserved Quantity	FBA Inventory	The total number of units in an inbound shipment or in Amazon fulfillment centers that are reserved for orders.
`totalUnfulfillableQuantity`	Total Unfulfillable Quantity	FBA Inventory	The total number of units in Amazon’s fulfillment network in unsellable condition..
`warehouseDamagedQuantity`	Warehouse Damaged Quantity	FBA Inventory	The number of units in warehouse damaged disposition.
`ShippingAddressAddressLine1`	Shipping Address Line 1	Shipping Addresses	The first line of the address.
`ShippingAddressAddressLine2`	Shipping Address Line 2	Shipping Addresses	The first line of the address.
`ShippingAddressAddressLine3`	Shipping Address Line 3	Shipping Addresses	The first line of the address.
`ShippingAddressAddressType`	Shipping Address Address Type	Shipping Addresses	The type of address.
`ShippingAddressCity`	Shipping Address City	Shipping Addresses	The city.
`ShippingAddressCountryCode`	Shipping Address Country Code	Shipping Addresses	The country code.
`ShippingAddressCountryName`	Shipping Address Country Name	Shipping Addresses	The country name.
`ShippingAddressCounty`	Shipping Address County	Shipping Addresses	The county.
`ShippingAddressDistrict`	Shipping Address District	Shipping Addresses	The district.
`ShippingAddressMunicipality`	Shipping Address Municipality	Shipping Addresses	The municipality.
`ShippingAddressName`	Shipping Address Name	Shipping Addresses	The name of the recipient.
`ShippingAddressPhone`	Shipping Address Phone	Shipping Addresses	The phone number.
`ShippingAddressPostalCode`	Shipping Address Postal Code	Shipping Addresses	The postal code.
`ShippingAddressStateOrRegion`	Shipping Address State Or Region	Shipping Addresses	The state or region.
`Date`	Date	Date	Date
`day_of_week`	Day of week (Mon – Sun)	Date	Day of week (Mon – Sun)
`hour`	Hour of day	Date	Hour of day
`month`	Month	Date	Month
`quarter`	Quarter	Date	Quarter
`week`	Week	Date	Week
`year`	Year	Date	Year
`year_month`	Month and year	Date	Month and year
`year_quarter`	Quarter and year	Date	Quarter and year
`year_week`	Week and year	Date	Week and year
`BuyerCounty`	Buyer County	Buyers	The county of the buyer.
`BuyerEmail`	Buyer Email	Buyers	The email address of the buyer.
`BuyerName`	Buyer Name	Buyers	The name of the buyer.
`BuyerPurchaseOrderNumber`	Buyer Purchase Order Number	Buyers	The purchase order (PO) number entered by the buyer at checkout. Returned only for orders where the buyer entered a PO number at checkout.
`BuyerTaxInfoCompanyLegalName`	Buyer Tax Company Legal Name	Buyers	The legal name of the company.
`BuyerTaxInfoTaxingRegion`	Buyer Taxing Region	Buyers	The taxing region.
`averageUnitPrice`	Average Unit Price	Sales	The average unit price.
`orderCount`	Order Count	Sales	The number of orders.
`orderItemCount`	Order Item Count	Sales	The number of items.
`totalSales`	Total Sales	Sales	The total sales.
`unitCount`	Unit Count	Sales	The number of units.
`listing_created_date`	Listing Created Date	Listing Items	The date when the listing was created.
`listing_item_status`	Listing Item Status	Listing Items	The status of the listing item.
`mainImage`	Main Image	Listing Items	The product listing image.
`mainImageURL`	Main Image URL	Listing Items	The URL of the main image.
`SellerDisplayName`	Seller Display Name	Sellers	The displayable name of the seller.