API Connectors

users-love-us medal soc2
Send your Amazon Seller Central (Amazon SP) data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Amazon Seller Central (Amazon SP) Connector Reference

208 metrics299 dimensions
Fields Actions
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,order_channel,order_status
The Amazon Seller Central / Amazon SP connector lets you pull Amazon Seller Central data for different reports. If you specify the fields date_from and date_to it will filter for a date range in which the products were purchased.
Note: Due to the Amazon SP API limitations, the last present day does not return any data. Hence, if you pull data for the last three days, you will get data for only two days. Similarly, if you preset the date filter to last 7 days, you will receive the last 6 days. For example, if today is 2023-01-04 and you preset the date filter to last 3 days, you will receive data for 2023-01-01, 2023-01-02, but not for 2023-01-03.

The Amazon Seller Central (Amazon SP) connector exposes 507 fields (208 metrics, 299 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Available actions


Update Listing Update editable attributes of an existing Amazon product listing (product card), identified by seller SKU. Provide only the fields to change; at least one is required. title sets the product title (item_name). description sets the product description. bullet_points replaces the ENTIRE list of bullet points (About this item) — pass every bullet you want to keep, not just new ones; it cannot be empty (clearing all bullets is not supported). price sets the standard offer price in the marketplace currency. Updates are submitted as a partial patch and processed asynchronously by Amazon: a successful response means the submission was ACCEPTED for processing, not that it is live yet. Requires the Product Listing role on the SP-API application.

Update editable attributes of an existing Amazon product listing (product card), identified by seller SKU. Provide only the fields to change; at least one is required. title sets the product title (item_name). description sets the product description. bullet_points replaces the ENTIRE list of bullet points (About this item) — pass every bullet you want to keep, not just new ones; it cannot be empty (clearing all bullets is not supported). price sets the standard offer price in the marketplace currency. Updates are submitted as a partial patch and processed asynchronously by Amazon: a successful response means the submission was ACCEPTED for processing, not that it is live yet. Requires the Product Listing role on the SP-API application.

Parameters
skustringRequiredtitlestringdescriptionstringbullet_pointsstringpricestringlanguage_tagstring

Amazon Seller Central (Amazon SP) Fields

Amazon Seller Central (Amazon SP) get_afn_inventory_data_by_country fields

The get_afn_inventory_data_by_country report of the Amazon Seller Central (Amazon SP) connector includes 6 fields.

IDTypeNameDescription
afn_inventory_data_by_country__asinTEXTasin (get_afn_inventory_data_by_country)asin (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__condition_typeTEXTcondition-type (get_afn_inventory_data_by_country)condition-type (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__countryCOUNTRYcountry (get_afn_inventory_data_by_country)country (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__fulfillment_channel_skuTEXTfulfillment-channel-sku (get_afn_inventory_data_by_country)fulfillment-channel-sku (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__quantity_for_local_fulfillmentNUMERICquantity-for-local-fulfillment (get_afn_inventory_data_by_country)quantity-for-local-fulfillment (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__seller_skuTEXTseller-sku (get_afn_inventory_data_by_country)seller-sku (get_afn_inventory_data_by_country)

Amazon Seller Central (Amazon SP) get_amazon_fulfilled_shipments_data_general fields

The get_amazon_fulfilled_shipments_data_general report of the Amazon Seller Central (Amazon SP) connector includes 48 fields.

Amazon Seller Central (Amazon SP) get_amazon_fulfilled_shipments_data_general fields (amazon_fulfilled_shipments_data_general__amazon_order_id to amazon_fulfilled_shipments_data_general__ship_service_level)

IDTypeNameDescription
amazon_fulfilled_shipments_data_general__amazon_order_idTEXTamazon-order-id (get_amazon_fulfilled_shipments_data_general)amazon-order-id (get_amazon_fulfilled_shipments_data_general) Amazon'sunique, displayable identifier for an order.
amazon_fulfilled_shipments_data_general__amazon_order_item_idTEXTamazon-order-item-id (get_amazon_fulfilled_shipments_data_general)amazon-order-item-id (get_amazon_fulfilled_shipments_data_general)Amazon's unique, displayable identifier for an item within the order.
amazon_fulfilled_shipments_data_general__bill_address_1TEXTbill-address-1 (get_amazon_fulfilled_shipments_data_general)bill-address-1 (get_amazon_fulfilled_shipments_data_general) The firstline of a standard address.
amazon_fulfilled_shipments_data_general__bill_address_2TEXTbill-address-2 (get_amazon_fulfilled_shipments_data_general)bill-address-2 (get_amazon_fulfilled_shipments_data_general) Thesecond line of a standard address.
amazon_fulfilled_shipments_data_general__bill_address_3TEXTbill-address-3 (get_amazon_fulfilled_shipments_data_general)bill-address-3 (get_amazon_fulfilled_shipments_data_general) The thirdline of a standard address.
amazon_fulfilled_shipments_data_general__bill_cityCITYbill-city (get_amazon_fulfilled_shipments_data_general)bill-city (get_amazon_fulfilled_shipments_data_general) The city of astandard address.
amazon_fulfilled_shipments_data_general__bill_countryCOUNTRYbill-country (get_amazon_fulfilled_shipments_data_general)bill-country (get_amazon_fulfilled_shipments_data_general) ISO 3166standard two-letter country code.
amazon_fulfilled_shipments_data_general__bill_postal_codeTEXTbill-postal-code (get_amazon_fulfilled_shipments_data_general)bill-postal-code (get_amazon_fulfilled_shipments_data_general) Thepostal (zip) code of a standard address.
amazon_fulfilled_shipments_data_general__bill_stateTEXTbill-state (get_amazon_fulfilled_shipments_data_general)bill-state (get_amazon_fulfilled_shipments_data_general) The state orregion of a standard address.
amazon_fulfilled_shipments_data_general__buyer_emailTEXTbuyer-email (get_amazon_fulfilled_shipments_data_general)buyer-email (get_amazon_fulfilled_shipments_data_general) Theencrypted email address of the buyer.
amazon_fulfilled_shipments_data_general__buyer_nameTEXTbuyer-name (get_amazon_fulfilled_shipments_data_general)buyer-name (get_amazon_fulfilled_shipments_data_general) The full nameof the buyer.
amazon_fulfilled_shipments_data_general__buyer_phone_numberTEXTbuyer-phone-number (get_amazon_fulfilled_shipments_data_general)buyer-phone-number (get_amazon_fulfilled_shipments_data_general) Thephone number of the buyer.
amazon_fulfilled_shipments_data_general__carrierTEXTcarrier (get_amazon_fulfilled_shipments_data_general)carrier (get_amazon_fulfilled_shipments_data_general) The name of thecarrier the package was shipped with.
amazon_fulfilled_shipments_data_general__currencyTEXTcurrency (get_amazon_fulfilled_shipments_data_general)currency (get_amazon_fulfilled_shipments_data_general) The currencyused for the purchase. Supported currencies include USD, CAD, GBP,EUR, and JPY.
amazon_fulfilled_shipments_data_general__estimated_arrival_dateDATEestimated-arrival-date (get_amazon_fulfilled_shipments_data_general)estimated-arrival-date (get_amazon_fulfilled_shipments_data_general)The estimated date of delivery to the customer.
amazon_fulfilled_shipments_data_general__fulfillment_center_idTEXTfulfillment-center-id (get_amazon_fulfilled_shipments_data_general)fulfillment-center-id (get_amazon_fulfilled_shipments_data_general)The unique identifier from which fulfillment center the order wasshipped.
amazon_fulfilled_shipments_data_general__fulfillment_channelTEXTfulfillment-channel (get_amazon_fulfilled_shipments_data_general)fulfillment-channel (get_amazon_fulfilled_shipments_data_general)Indicates how the order was fulfilled, via Amazon (AFN) or Merchant(MFN)
amazon_fulfilled_shipments_data_general__gift_wrap_priceNUMERICgift-wrap-price (get_amazon_fulfilled_shipments_data_general)gift-wrap-price (get_amazon_fulfilled_shipments_data_general) Theamount that the buyer paid for gift wrap. Amount is aggregate of thequantity, not unit price.
amazon_fulfilled_shipments_data_general__gift_wrap_taxNUMERICgift-wrap-tax (get_amazon_fulfilled_shipments_data_general)gift-wrap-tax (get_amazon_fulfilled_shipments_data_general) The amountthat the buyer paid for gift wrap tax. Amount is aggregate of thequantity, not unit price.
amazon_fulfilled_shipments_data_general__item_priceNUMERICitem-price (get_amazon_fulfilled_shipments_data_general)item-price (get_amazon_fulfilled_shipments_data_general) The amountthat the buyer paid for the item. Amount is aggregate of the quantity,not unit price.
amazon_fulfilled_shipments_data_general__item_promotion_discountNUMERICitem-promotion-discount (get_amazon_fulfilled_shipments_data_general)item-promotion-discount (get_amazon_fulfilled_shipments_data_general)Promotion discount applied to the order item.
amazon_fulfilled_shipments_data_general__item_taxNUMERICitem-tax (get_amazon_fulfilled_shipments_data_general)item-tax (get_amazon_fulfilled_shipments_data_general) The amount thatthe buyer paid for item tax. Amount is aggregate of the quantity, notunit price.
amazon_fulfilled_shipments_data_general__merchant_order_idTEXTmerchant-order-id (get_amazon_fulfilled_shipments_data_general)merchant-order-id (get_amazon_fulfilled_shipments_data_general) Aunique identifier optionally supplied for the order by the Merchant.
amazon_fulfilled_shipments_data_general__merchant_order_item_idTEXTmerchant-order-item-id (get_amazon_fulfilled_shipments_data_general)merchant-order-item-id (get_amazon_fulfilled_shipments_data_general) Aunique identifier for an item within the order.
amazon_fulfilled_shipments_data_general__payments_dateDATEpayments-date (get_amazon_fulfilled_shipments_data_general)payments-date (get_amazon_fulfilled_shipments_data_general) The datethe buyer's credit card was charged and order processing wascompleted.
amazon_fulfilled_shipments_data_general__product_nameTEXTproduct-name (get_amazon_fulfilled_shipments_data_general)product-name (get_amazon_fulfilled_shipments_data_general) The shorttitle for the product, displayed in bold on the detail web page and inthe title bar of the browser window.
amazon_fulfilled_shipments_data_general__purchase_dateDATEpurchase-date (get_amazon_fulfilled_shipments_data_general)purchase-date (get_amazon_fulfilled_shipments_data_general) The datethe order was placed.
amazon_fulfilled_shipments_data_general__quantity_shippedNUMERICquantity-shipped (get_amazon_fulfilled_shipments_data_general)quantity-shipped (get_amazon_fulfilled_shipments_data_general) Thenumber of this item that were shipped.
amazon_fulfilled_shipments_data_general__recipient_nameTEXTrecipient-name (get_amazon_fulfilled_shipments_data_general)recipient-name (get_amazon_fulfilled_shipments_data_general) Namefield of a standard address.
amazon_fulfilled_shipments_data_general__reporting_dateDATEreporting-date (get_amazon_fulfilled_shipments_data_general)reporting-date (get_amazon_fulfilled_shipments_data_general) The datethe data for this report became available in the FBA data store.
amazon_fulfilled_shipments_data_general__sales_channelTEXTsales-channel (get_amazon_fulfilled_shipments_data_general)sales-channel (get_amazon_fulfilled_shipments_data_general) The sourceof the order.
amazon_fulfilled_shipments_data_general__ship_address_1TEXTship-address-1 (get_amazon_fulfilled_shipments_data_general)ship-address-1 (get_amazon_fulfilled_shipments_data_general) The firstline of a standard address.
amazon_fulfilled_shipments_data_general__ship_address_2TEXTship-address-2 (get_amazon_fulfilled_shipments_data_general)ship-address-2 (get_amazon_fulfilled_shipments_data_general) Thesecond line of a standard address.
amazon_fulfilled_shipments_data_general__ship_address_3TEXTship-address-3 (get_amazon_fulfilled_shipments_data_general)ship-address-3 (get_amazon_fulfilled_shipments_data_general) The thirdline of a standard address.
amazon_fulfilled_shipments_data_general__ship_cityCITYship-city (get_amazon_fulfilled_shipments_data_general)ship-city (get_amazon_fulfilled_shipments_data_general) The city of astandard address.
amazon_fulfilled_shipments_data_general__ship_countryCOUNTRYship-country (get_amazon_fulfilled_shipments_data_general)ship-country (get_amazon_fulfilled_shipments_data_general) ISO 3166standard two-letter country code.
amazon_fulfilled_shipments_data_general__ship_phone_numberTEXTship-phone-number (get_amazon_fulfilled_shipments_data_general)ship-phone-number (get_amazon_fulfilled_shipments_data_general) Thephone number associated with the ship-to address.
amazon_fulfilled_shipments_data_general__ship_postal_codeTEXTship-postal-code (get_amazon_fulfilled_shipments_data_general)ship-postal-code (get_amazon_fulfilled_shipments_data_general) Thepostal (ZIP) code of a standard address.
amazon_fulfilled_shipments_data_general__ship_promotion_discountNUMERICship-promotion-discount (get_amazon_fulfilled_shipments_data_general)ship-promotion-discount (get_amazon_fulfilled_shipments_data_general)Promotion discount applied to shipping.
amazon_fulfilled_shipments_data_general__ship_service_levelTEXTship-service-level (get_amazon_fulfilled_shipments_data_general)ship-service-level (get_amazon_fulfilled_shipments_data_general) Anenumerated value that determines the type of fulfillment service thatthe buyer expects the merchant to use (e.g., Standard v. Expedited)

Amazon Seller Central (Amazon SP) get_amazon_fulfilled_shipments_data_general fields (amazon_fulfilled_shipments_data_general__ship_state to amazon_fulfilled_shipments_data_general__tracking_number)

IDTypeNameDescription
amazon_fulfilled_shipments_data_general__ship_stateTEXTship-state (get_amazon_fulfilled_shipments_data_general)ship-state (get_amazon_fulfilled_shipments_data_general) The state orregion of a standard address.
amazon_fulfilled_shipments_data_general__shipment_dateDATEshipment-date (get_amazon_fulfilled_shipments_data_general)shipment-date (get_amazon_fulfilled_shipments_data_general) The datethe shipment was completed (shipped) by the fulfillment center
amazon_fulfilled_shipments_data_general__shipment_idTEXTshipment-id (get_amazon_fulfilled_shipments_data_general)shipment-id (get_amazon_fulfilled_shipments_data_general) EncryptedAmazon shipment id
amazon_fulfilled_shipments_data_general__shipment_item_idTEXTshipment-item-id (get_amazon_fulfilled_shipments_data_general)shipment-item-id (get_amazon_fulfilled_shipments_data_general)Encrypted Amazon shipment item id
amazon_fulfilled_shipments_data_general__shipping_priceNUMERICshipping-price (get_amazon_fulfilled_shipments_data_general)shipping-price (get_amazon_fulfilled_shipments_data_general) Theamount that the buyer paid for shipping. Amount is aggregate of thequantity, not unit price.
amazon_fulfilled_shipments_data_general__shipping_taxNUMERICshipping-tax (get_amazon_fulfilled_shipments_data_general)shipping-tax (get_amazon_fulfilled_shipments_data_general) The amountthat the buyer paid for shipping tax. Amount is aggregate of thequantity, not unit price.
amazon_fulfilled_shipments_data_general__skuTEXTsku (get_amazon_fulfilled_shipments_data_general)sku (get_amazon_fulfilled_shipments_data_general) A merchant-definedunique identifier for a product.
amazon_fulfilled_shipments_data_general__tracking_numberTEXTtracking-number (get_amazon_fulfilled_shipments_data_general)tracking-number (get_amazon_fulfilled_shipments_data_general) Thecarrier's tracking number for the package.

Amazon Seller Central (Amazon SP) get_brand_analytics_market_basket_report fields

The get_brand_analytics_market_basket_report report of the Amazon Seller Central (Amazon SP) connector includes 6 fields.

IDTypeNameDescription
brand_analytics_market_basket_report__asinTEXTasin (get_brand_analytics_market_basket_report)asin (get_brand_analytics_market_basket_report) An ASIN in the brand's catalog that customers purchased.
brand_analytics_market_basket_report__combinationpctNUMERICcombinationPct (get_brand_analytics_market_basket_report)combinationPct (get_brand_analytics_market_basket_report) Share of the primary ASIN's orders that also contained the purchased-with ASIN.
brand_analytics_market_basket_report__enddateDATEendDate (get_brand_analytics_market_basket_report)endDate (get_brand_analytics_market_basket_report) Last day of the reporting period the market basket data covers.
brand_analytics_market_basket_report__purchasedwithasinTEXTpurchasedWithAsin (get_brand_analytics_market_basket_report)purchasedWithAsin (get_brand_analytics_market_basket_report) An ASIN frequently purchased in the same order as the primary ASIN. It might not belong to the brand's catalog.
brand_analytics_market_basket_report__purchasedwithrankNUMERICpurchasedWithRank (get_brand_analytics_market_basket_report)purchasedWithRank (get_brand_analytics_market_basket_report) Rank of the purchased-with ASIN for the primary ASIN (1 is the most frequently co-purchased).
brand_analytics_market_basket_report__startdateDATEstartDate (get_brand_analytics_market_basket_report)startDate (get_brand_analytics_market_basket_report) First day of the reporting period the market basket data covers.

Amazon Seller Central (Amazon SP) get_brand_analytics_search_query_performance_report fields

The get_brand_analytics_search_query_performance_report report of the Amazon Seller Central (Amazon SP) connector includes 42 fields.

Amazon Seller Central (Amazon SP) get_brand_analytics_search_query_performance_report fields (brand_analytics_search_query_performance_report__asin to brand_analytics_search_query_performance_report__searchquerydata_searchqueryscore)

IDTypeNameDescription
brand_analytics_search_query_performance_report__asinTEXTasin (get_brand_analytics_search_query_performance_report)asin (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_asincartaddcountNUMERICcartAddData-asinCartAddCount (get_brand_analytics_search_query_performance_report)cartAddData-asinCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_asincartaddshareNUMERICcartAddData-asinCartAddShare (get_brand_analytics_search_query_performance_report)cartAddData-asinCartAddShare (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_asinmediancartaddprice_amountNUMERICcartAddData-asinMedianCartAddPrice-amount (get_brand_analytics_search_query_performance_report)cartAddData-asinMedianCartAddPrice-amount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_asinmediancartaddprice_currencycodeTEXTcartAddData-asinMedianCartAddPrice-currencyCode (get_brand_analytics_search_query_performance_report)cartAddData-asinMedianCartAddPrice-currencyCode (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalcartaddcountNUMERICcartAddData-totalCartAddCount (get_brand_analytics_search_query_performance_report)cartAddData-totalCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalcartaddrateNUMERICcartAddData-totalCartAddRate (get_brand_analytics_search_query_performance_report)cartAddData-totalCartAddRate (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalmediancartaddprice_amountNUMERICcartAddData-totalMedianCartAddPrice-amount (get_brand_analytics_search_query_performance_report)cartAddData-totalMedianCartAddPrice-amount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalmediancartaddprice_currencycodeTEXTcartAddData-totalMedianCartAddPrice-currencyCode (get_brand_analytics_search_query_performance_report)cartAddData-totalMedianCartAddPrice-currencyCode (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalonedayshippingcartaddcountNUMERICcartAddData-totalOneDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)cartAddData-totalOneDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalsamedayshippingcartaddcountNUMERICcartAddData-totalSameDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)cartAddData-totalSameDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totaltwodayshippingcartaddcountNUMERICcartAddData-totalTwoDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)cartAddData-totalTwoDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_asinclickcountNUMERICclickData-asinClickCount (get_brand_analytics_search_query_performance_report)clickData-asinClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_asinclickshareNUMERICclickData-asinClickShare (get_brand_analytics_search_query_performance_report)clickData-asinClickShare (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_asinmedianclickprice_amountNUMERICclickData-asinMedianClickPrice-amount (get_brand_analytics_search_query_performance_report)clickData-asinMedianClickPrice-amount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_asinmedianclickprice_currencycodeTEXTclickData-asinMedianClickPrice-currencyCode (get_brand_analytics_search_query_performance_report)clickData-asinMedianClickPrice-currencyCode (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalclickcountNUMERICclickData-totalClickCount (get_brand_analytics_search_query_performance_report)clickData-totalClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalclickrateNUMERICclickData-totalClickRate (get_brand_analytics_search_query_performance_report)clickData-totalClickRate (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalmedianclickprice_amountNUMERICclickData-totalMedianClickPrice-amount (get_brand_analytics_search_query_performance_report)clickData-totalMedianClickPrice-amount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalmedianclickprice_currencycodeTEXTclickData-totalMedianClickPrice-currencyCode (get_brand_analytics_search_query_performance_report)clickData-totalMedianClickPrice-currencyCode (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalonedayshippingclickcountNUMERICclickData-totalOneDayShippingClickCount (get_brand_analytics_search_query_performance_report)clickData-totalOneDayShippingClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalsamedayshippingclickcountNUMERICclickData-totalSameDayShippingClickCount (get_brand_analytics_search_query_performance_report)clickData-totalSameDayShippingClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totaltwodayshippingclickcountNUMERICclickData-totalTwoDayShippingClickCount (get_brand_analytics_search_query_performance_report)clickData-totalTwoDayShippingClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__enddateDATEendDate (get_brand_analytics_search_query_performance_report)endDate (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__impressiondata_asinimpressioncountNUMERICimpressionData-asinImpressionCount (get_brand_analytics_search_query_performance_report)impressionData-asinImpressionCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__impressiondata_asinimpressionshareNUMERICimpressionData-asinImpressionShare (get_brand_analytics_search_query_performance_report)impressionData-asinImpressionShare (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__impressiondata_totalqueryimpressioncountNUMERICimpressionData-totalQueryImpressionCount (get_brand_analytics_search_query_performance_report)impressionData-totalQueryImpressionCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_asinmedianpurchaseprice_amountNUMERICpurchaseData-asinMedianPurchasePrice-amount (get_brand_analytics_search_query_performance_report)purchaseData-asinMedianPurchasePrice-amount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_asinmedianpurchaseprice_currencycodeTEXTpurchaseData-asinMedianPurchasePrice-currencyCode (get_brand_analytics_search_query_performance_report)purchaseData-asinMedianPurchasePrice-currencyCode (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_asinpurchasecountNUMERICpurchaseData-asinPurchaseCount (get_brand_analytics_search_query_performance_report)purchaseData-asinPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_asinpurchaseshareNUMERICpurchaseData-asinPurchaseShare (get_brand_analytics_search_query_performance_report)purchaseData-asinPurchaseShare (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalmedianpurchaseprice_amountNUMERICpurchaseData-totalMedianPurchasePrice-amount (get_brand_analytics_search_query_performance_report)purchaseData-totalMedianPurchasePrice-amount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalmedianpurchaseprice_currencycodeTEXTpurchaseData-totalMedianPurchasePrice-currencyCode (get_brand_analytics_search_query_performance_report)purchaseData-totalMedianPurchasePrice-currencyCode (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalonedayshippingpurchasecountNUMERICpurchaseData-totalOneDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)purchaseData-totalOneDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalpurchasecountNUMERICpurchaseData-totalPurchaseCount (get_brand_analytics_search_query_performance_report)purchaseData-totalPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalpurchaserateNUMERICpurchaseData-totalPurchaseRate (get_brand_analytics_search_query_performance_report)purchaseData-totalPurchaseRate (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalsamedayshippingpurchasecountNUMERICpurchaseData-totalSameDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)purchaseData-totalSameDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totaltwodayshippingpurchasecountNUMERICpurchaseData-totalTwoDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)purchaseData-totalTwoDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__searchquerydata_searchqueryTEXTsearchQueryData-searchQuery (get_brand_analytics_search_query_performance_report)searchQueryData-searchQuery (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__searchquerydata_searchqueryscoreNUMERICsearchQueryData-searchQueryScore (get_brand_analytics_search_query_performance_report)searchQueryData-searchQueryScore (get_brand_analytics_search_query_performance_report)

Amazon Seller Central (Amazon SP) get_brand_analytics_search_query_performance_report fields (brand_analytics_search_query_performance_report__searchquerydata_searchqueryvolume to brand_analytics_search_query_performance_report__startdate)

IDTypeNameDescription
brand_analytics_search_query_performance_report__searchquerydata_searchqueryvolumeNUMERICsearchQueryData-searchQueryVolume (get_brand_analytics_search_query_performance_report)searchQueryData-searchQueryVolume (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__startdateDATEstartDate (get_brand_analytics_search_query_performance_report)startDate (get_brand_analytics_search_query_performance_report)

Amazon Seller Central (Amazon SP) get_fba_estimated_fba_fees_txt_data fields

The get_fba_estimated_fba_fees_txt_data report of the Amazon Seller Central (Amazon SP) connector includes 25 fields.

IDTypeNameDescription
fba_estimated_fba_fees_txt_data__asinTEXTasin (get_fba_estimated_fba_fees_txt_data)asin (get_fba_estimated_fba_fees_txt_data) Amazon StandardIdentification Numbers (ASINs) are unique blocks of 10 letters ornumbers that identify products. ASINs are assigned by Amazon. You canfind the ASIN on the product detail page.
fba_estimated_fba_fees_txt_data__brandTEXTbrand (get_fba_estimated_fba_fees_txt_data)brand (get_fba_estimated_fba_fees_txt_data) The brand of your product
fba_estimated_fba_fees_txt_data__currencyTEXTcurrency (get_fba_estimated_fba_fees_txt_data)currency (get_fba_estimated_fba_fees_txt_data) The currency in whichthe fee is calculated
fba_estimated_fba_fees_txt_data__estimated_fee_totalNUMERICestimated-fee-total (get_fba_estimated_fba_fees_txt_data)estimated-fee-total (get_fba_estimated_fba_fees_txt_data) Theestimated fulfillment and selling on Amazon fee
fba_estimated_fba_fees_txt_data__estimated_order_handling_fee_per_orderNUMERICestimated-order-handling-fee-per-order (get_fba_estimated_fba_fees_txt_data)estimated-order-handling-fee-per-order(get_fba_estimated_fba_fees_txt_data) The estimated order handling feeper order
fba_estimated_fba_fees_txt_data__estimated_pick_pack_fee_per_unitTEXTestimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data)estimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data)
fba_estimated_fba_fees_txt_data__estimated_referral_fee_per_unitNUMERICestimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data)estimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data)The estimated selling on Amazon referral fee
fba_estimated_fba_fees_txt_data__estimated_variable_closing_feeNUMERICestimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data)estimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data)The estimated variable closing fee for your product
fba_estimated_fba_fees_txt_data__estimated_weight_handling_fee_per_unitNUMERICestimated-weight-handling-fee-per-unit (get_fba_estimated_fba_fees_txt_data)estimated-weight-handling-fee-per-unit(get_fba_estimated_fba_fees_txt_data) The estimated weight handlingfee for your product based on the outbound shipping weight
fba_estimated_fba_fees_txt_data__expected_fulfillment_fee_per_unitNUMERICexpected-fulfillment-fee-per-unit (get_fba_estimated_fba_fees_txt_data)expected-fulfillment-fee-per-unit(get_fba_estimated_fba_fees_txt_data)
fba_estimated_fba_fees_txt_data__fnskuTEXTfnsku (get_fba_estimated_fba_fees_txt_data)fnsku (get_fba_estimated_fba_fees_txt_data) Unique identifier assignedby Amazon to products stored in and fulfilled from an Amazonfulfillment center
fba_estimated_fba_fees_txt_data__fulfilled_byTEXTfulfilled-by (get_fba_estimated_fba_fees_txt_data)fulfilled-by (get_fba_estimated_fba_fees_txt_data) The entity thatfulfilled the item
fba_estimated_fba_fees_txt_data__item_package_weightNUMERICitem-package-weight (get_fba_estimated_fba_fees_txt_data)item-package-weight (get_fba_estimated_fba_fees_txt_data)
fba_estimated_fba_fees_txt_data__length_and_girthNUMERIClength-and-girth (get_fba_estimated_fba_fees_txt_data)length-and-girth (get_fba_estimated_fba_fees_txt_data) The longestside of your product, including its packaging, plus the girth, a unitmeasure, equivalent to 2 x (median side + shortest side)
fba_estimated_fba_fees_txt_data__longest_sideNUMERIClongest-side (get_fba_estimated_fba_fees_txt_data)longest-side (get_fba_estimated_fba_fees_txt_data) Measurement of thelongest side of your product including its packaging
fba_estimated_fba_fees_txt_data__median_sideNUMERICmedian-side (get_fba_estimated_fba_fees_txt_data)median-side (get_fba_estimated_fba_fees_txt_data) Measurement of theside that is neither the longest nor the shortest side of your productincluding its packaging
fba_estimated_fba_fees_txt_data__product_groupTEXTproduct-group (get_fba_estimated_fba_fees_txt_data)product-group (get_fba_estimated_fba_fees_txt_data) The Amazondepartment or category
fba_estimated_fba_fees_txt_data__product_nameTEXTproduct-name (get_fba_estimated_fba_fees_txt_data)product-name (get_fba_estimated_fba_fees_txt_data) The title of yourproduct
fba_estimated_fba_fees_txt_data__product_size_tierTEXTproduct-size-tier (get_fba_estimated_fba_fees_txt_data)product-size-tier (get_fba_estimated_fba_fees_txt_data) The size tierassigned to your product by FBA based on its dimensions and weight
fba_estimated_fba_fees_txt_data__sales_priceNUMERICsales-price (get_fba_estimated_fba_fees_txt_data)sales-price (get_fba_estimated_fba_fees_txt_data) Your currentpromotional price
fba_estimated_fba_fees_txt_data__shortest_sideNUMERICshortest-side (get_fba_estimated_fba_fees_txt_data)shortest-side (get_fba_estimated_fba_fees_txt_data) Measurement of theshortest side of your product including its packaging
fba_estimated_fba_fees_txt_data__skuTEXTsku (get_fba_estimated_fba_fees_txt_data)sku (get_fba_estimated_fba_fees_txt_data) Stock Keeping Units (SKUs)are unique blocks of letters or numbers that identify your products.SKUs are assigned by you as the seller.
fba_estimated_fba_fees_txt_data__unit_of_dimensionTEXTunit-of-dimension (get_fba_estimated_fba_fees_txt_data)unit-of-dimension (get_fba_estimated_fba_fees_txt_data)
fba_estimated_fba_fees_txt_data__unit_of_weightTEXTunit-of-weight (get_fba_estimated_fba_fees_txt_data)unit-of-weight (get_fba_estimated_fba_fees_txt_data) The unit ofweight used in weight measurement
fba_estimated_fba_fees_txt_data__your_priceNUMERICyour-price (get_fba_estimated_fba_fees_txt_data)your-price (get_fba_estimated_fba_fees_txt_data) Your current sellingprice

Amazon Seller Central (Amazon SP) get_fba_fulfillment_customer_returns_data fields

The get_fba_fulfillment_customer_returns_data report of the Amazon Seller Central (Amazon SP) connector includes 13 fields.

IDTypeNameDescription
fba_fulfillment_customer_returns_data__asinTEXTasin (get_fba_fulfillment_customer_returns_data)asin (get_fba_fulfillment_customer_returns_data) Amazon standard itemnumber
fba_fulfillment_customer_returns_data__customer_commentsTEXTcustomer-comments (get_fba_fulfillment_customer_returns_data)customer-comments (get_fba_fulfillment_customer_returns_data) Whenavailable, comments submitted by customers regarding the reason forthe return are provided.
fba_fulfillment_customer_returns_data__detailed_dispositionTEXTdetailed-disposition (get_fba_fulfillment_customer_returns_data)detailed-disposition (get_fba_fulfillment_customer_returns_data)Condition of the returned item: see Condition Codes below forexplanation
fba_fulfillment_customer_returns_data__fnskuTEXTfnsku (get_fba_fulfillment_customer_returns_data)fnsku (get_fba_fulfillment_customer_returns_data) Fulfillment networkSKU
fba_fulfillment_customer_returns_data__fulfillment_center_idTEXTfulfillment-center-id (get_fba_fulfillment_customer_returns_data)fulfillment-center-id (get_fba_fulfillment_customer_returns_data)Fulfillment center where the returned merchandise was processed
fba_fulfillment_customer_returns_data__license_plate_numberTEXTlicense-plate-number (get_fba_fulfillment_customer_returns_data)license-plate-number (get_fba_fulfillment_customer_returns_data)
fba_fulfillment_customer_returns_data__order_idTEXTorder-id (get_fba_fulfillment_customer_returns_data)order-id (get_fba_fulfillment_customer_returns_data)
fba_fulfillment_customer_returns_data__product_nameTEXTproduct-name (get_fba_fulfillment_customer_returns_data)product-name (get_fba_fulfillment_customer_returns_data) The name ofthe product as it appears on Amazon
fba_fulfillment_customer_returns_data__quantityNUMERICquantity (get_fba_fulfillment_customer_returns_data)quantity (get_fba_fulfillment_customer_returns_data) Number of unitsof this item returned
fba_fulfillment_customer_returns_data__reasonTEXTreason (get_fba_fulfillment_customer_returns_data)reason (get_fba_fulfillment_customer_returns_data) A short descriptionof reason for return as indicated by the customer.See Customer Reason below for explanation
fba_fulfillment_customer_returns_data__return_dateDATEreturn-date (get_fba_fulfillment_customer_returns_data)return-date (get_fba_fulfillment_customer_returns_data) Date returnedmerchandise was processed at the fulfillment center.DD-MM-YYYY.
fba_fulfillment_customer_returns_data__skuTEXTsku (get_fba_fulfillment_customer_returns_data)sku (get_fba_fulfillment_customer_returns_data) Seller's itemidentifier
fba_fulfillment_customer_returns_data__statusTEXTstatus (get_fba_fulfillment_customer_returns_data)status (get_fba_fulfillment_customer_returns_data) A short descriptionof the status of the customer return. Please seeReturn Status below for explanation.

Amazon Seller Central (Amazon SP) get_fba_inventory_planning_data fields

The get_fba_inventory_planning_data report of the Amazon Seller Central (Amazon SP) connector includes 98 fields.

Amazon Seller Central (Amazon SP) get_fba_inventory_planning_data fields (fba_fulfillment_inventory_health_data__asin to fba_fulfillment_inventory_health_data__units_shipped_last_90_days)

IDTypeNameDescription
fba_fulfillment_inventory_health_data__asinTEXTasin (get_fba_inventory_planning_data)asin (get_fba_inventory_planning_data) Unique blocks of 10 letters ornumbers that Amazon assigns to the products that are sold throughAmazon
fba_fulfillment_inventory_health_data__asin_limitNUMERICasin-limit (get_fba_inventory_planning_data)asin-limit (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__conditionTEXTcondition (get_fba_inventory_planning_data)condition (get_fba_inventory_planning_data) The condition of the unit(for example, new or used)
fba_fulfillment_inventory_health_data__currencyTEXTcurrency (get_fba_inventory_planning_data)currency (get_fba_inventory_planning_data) The currency for theestimated long-term storage fee charge
fba_fulfillment_inventory_health_data__fnskuTEXTfnsku (get_fba_inventory_planning_data)fnsku (get_fba_inventory_planning_data) Unique blocks of letters andnumbers that Amazon assigns to products that are stored in andfulfilled from an Amazon fulfillment center
fba_fulfillment_inventory_health_data__in_bound_quantityNUMERICin-bound-quantity (get_fba_inventory_planning_data)in-bound-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inbound_recommend_quantityNUMERICinbound-recommend-quantity (get_fba_inventory_planning_data)inbound-recommend-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inv_age_0_to_90_daysNUMERICinv-age-0-to-90-days (get_fba_inventory_planning_data)inv-age-0-to-90-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inv_age_181_to_270_daysNUMERICinv-age-181-to-270-days (get_fba_inventory_planning_data)inv-age-181-to-270-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inv_age_271_to_365_daysNUMERICinv-age-271-to-365-days (get_fba_inventory_planning_data)inv-age-271-to-365-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inv_age_365_plus_daysNUMERICinv-age-365-plus-days (get_fba_inventory_planning_data)inv-age-365-plus-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inv_age_91_to_180_daysNUMERICinv-age-91-to-180-days (get_fba_inventory_planning_data)inv-age-91-to-180-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__is_hazmatTEXTis-hazmat (get_fba_inventory_planning_data)is-hazmat (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__lowest_afn_new_priceNUMERIClowest-afn-new-price (get_fba_inventory_planning_data)lowest-afn-new-price (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__lowest_afn_used_priceNUMERIClowest-afn-used-price (get_fba_inventory_planning_data)lowest-afn-used-price (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__lowest_mfn_new_priceNUMERIClowest-mfn-new-price (get_fba_inventory_planning_data)lowest-mfn-new-price (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__lowest_mfn_used_priceNUMERIClowest-mfn-used-price (get_fba_inventory_planning_data)lowest-mfn-used-price (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__num_afn_new_sellersNUMERICnum-afn-new-sellers (get_fba_inventory_planning_data)num-afn-new-sellers (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__num_afn_used_sellersNUMERICnum-afn-used-sellers (get_fba_inventory_planning_data)num-afn-used-sellers (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__per_unit_volumeNUMERICper-unit-volume (get_fba_inventory_planning_data)per-unit-volume (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__product_groupTEXTproduct-group (get_fba_inventory_planning_data)product-group (get_fba_inventory_planning_data) Distinct productgrouping distinguishing products like books, from watches or videogames
fba_fulfillment_inventory_health_data__product_nameTEXTproduct-name (get_fba_inventory_planning_data)product-name (get_fba_inventory_planning_data) The name of yourproduct
fba_fulfillment_inventory_health_data__projected_ltsf_12_moNUMERIC(Deprecated) projected-ltsf-12-mo (get_fba_inventory_planning_data)projected-ltsf-12-mo (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__projected_ltsf_6_moNUMERIC(Deprecated) projected-ltsf-6-mo (get_fba_inventory_planning_data)projected-ltsf-6-mo (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__qty_in_long_term_storage_programNUMERICqty-in-long-term-storage-program (get_fba_inventory_planning_data)qty-in-long-term-storage-program (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__qty_to_be_charged_ltsf_12_moNUMERIC(Deprecated) qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data)qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__qty_to_be_charged_ltsf_6_moNUMERIC(Deprecated) qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data)qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__qty_with_removals_in_progressTEXTqty-with-removals-in-progress (get_fba_inventory_planning_data)qty-with-removals-in-progress (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__sales_priceNUMERICsales-price (get_fba_inventory_planning_data)sales-price (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__sales_rankNUMERICsales-rank (get_fba_inventory_planning_data)sales-rank (get_fba_inventory_planning_data) The current rank for yourproduct. The change in sales rank value is the plus or minus change inthe past 7 days.
fba_fulfillment_inventory_health_data__sellable_quantityNUMERICsellable-quantity (get_fba_inventory_planning_data)sellable-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__skuTEXTsku (get_fba_inventory_planning_data)sku (get_fba_inventory_planning_data) Unique blocks of letters andnumbers that you assign to the products that you are selling
fba_fulfillment_inventory_health_data__snapshot_dateDATEsnapshot-date (get_fba_inventory_planning_data)snapshot-date (get_fba_inventory_planning_data) The date the reportwas generated
fba_fulfillment_inventory_health_data__total_quantityNUMERICtotal-quantity (get_fba_inventory_planning_data)total-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_180_daysNUMERICunits-shipped-last-180-days (get_fba_inventory_planning_data)units-shipped-last-180-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_24_hrsNUMERICunits-shipped-last-24-hrs (get_fba_inventory_planning_data)units-shipped-last-24-hrs (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_30_daysNUMERICunits-shipped-last-30-days (get_fba_inventory_planning_data)units-shipped-last-30-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_365_daysNUMERICunits-shipped-last-365-days (get_fba_inventory_planning_data)units-shipped-last-365-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_7_daysNUMERICunits-shipped-last-7-days (get_fba_inventory_planning_data)units-shipped-last-7-days (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_90_daysNUMERICunits-shipped-last-90-days (get_fba_inventory_planning_data)units-shipped-last-90-days (get_fba_inventory_planning_data)

Amazon Seller Central (Amazon SP) get_fba_inventory_planning_data fields (fba_fulfillment_inventory_health_data__unsellable_quantity to fba_inventory_planning_data__pending_removal_quantity)

IDTypeNameDescription
fba_fulfillment_inventory_health_data__unsellable_quantityNUMERICunsellable-quantity (get_fba_inventory_planning_data)unsellable-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__weeks_of_cover_t180TEXTweeks-of-cover-t180 (get_fba_inventory_planning_data)weeks-of-cover-t180 (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__weeks_of_cover_t30TEXTweeks-of-cover-t30 (get_fba_inventory_planning_data)weeks-of-cover-t30 (get_fba_inventory_planning_data) Your historicaltrailing 30-day on-hand inventory average divided by your units soldover the same time period divided by 4 weeks. If you sold 400 units ofa given item in the last 30 days (4 weeks) and had 100 sellable unitsin fulfillment centers, your weeks of cover last 30 days would be 1.
fba_fulfillment_inventory_health_data__weeks_of_cover_t365TEXTweeks-of-cover-t365 (get_fba_inventory_planning_data)weeks-of-cover-t365 (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__weeks_of_cover_t7TEXTweeks-of-cover-t7 (get_fba_inventory_planning_data)weeks-of-cover-t7 (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__weeks_of_cover_t90TEXTweeks-of-cover-t90 (get_fba_inventory_planning_data)weeks-of-cover-t90 (get_fba_inventory_planning_data) Your historicaltrailing 90-day on-hand inventory average divided by your units soldover the same time period divided by 12 weeks. If you sold 400 unitsof a given item in the last 90 days (12 weeks) and had an average of10 sellable units in fulfillment centers, your weeks of cover last 90days would be 3.33.
fba_fulfillment_inventory_health_data__your_priceNUMERICyour-price (get_fba_inventory_planning_data)your-price (get_fba_inventory_planning_data) Your listed price
fba_inventory_planning_data__alertTEXTalert (get_fba_inventory_planning_data)alert (get_fba_inventory_planning_data) This is displayed when an itemhas a low-traffic or low-conversion alert. Low traffic indicatesthat a low number of potential buyers have seen the listing. Lowconversion indicates that potential buyers are viewing the listing butaren’t following through to buy the product.
fba_inventory_planning_data__availableNUMERICavailable (get_fba_inventory_planning_data)available (get_fba_inventory_planning_data) Available (sellableinventory) quantity
fba_inventory_planning_data__days_of_supplyNUMERICdays-of-supply (get_fba_inventory_planning_data)days-of-supply (get_fba_inventory_planning_data) The estimated numberof days that your current inventory supply will last based on theprojected demand for your product
fba_inventory_planning_data__estimated_ais_181_210_daysNUMERICestimated-ais-181-210-days (get_fba_inventory_planning_data)estimated-ais-181-210-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_211_240_daysNUMERICestimated-ais-211-240-days (get_fba_inventory_planning_data)estimated-ais-211-240-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_241_270_daysNUMERICestimated-ais-241-270-days (get_fba_inventory_planning_data)estimated-ais-241-270-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_271_300_daysNUMERICestimated-ais-271-300-days (get_fba_inventory_planning_data)estimated-ais-271-300-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_301_330_daysNUMERICestimated-ais-301-330-days (get_fba_inventory_planning_data)estimated-ais-301-330-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_331_365_daysNUMERICestimated-ais-331-365-days (get_fba_inventory_planning_data)estimated-ais-331-365-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_365_plus_daysNUMERICestimated-ais-365-plus-days (get_fba_inventory_planning_data)estimated-ais-365-plus-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_366_455_daysNUMERICestimated-ais-366-455-days (get_fba_inventory_planning_data)estimated-ais-366-455-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_ais_456_plus_daysNUMERICestimated-ais-456-plus-days (get_fba_inventory_planning_data)estimated-ais-456-plus-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_cost_savings_of_recommended_actionsNUMERICestimated-cost-savings-of-recommended-actions (get_fba_inventory_planning_data)estimated-cost-savings-of-recommended-actions(get_fba_inventory_planning_data) Estimated cost savings betweentaking the recommended action versus the storage fees you would incuron that inventory by taking no action
fba_inventory_planning_data__estimated_excess_quantityNUMERICestimated-excess-quantity (get_fba_inventory_planning_data)estimated-excess-quantity (get_fba_inventory_planning_data) Estimatedexcess units are overstocked units based on your current salesvelocity and customer demand forecast. It’s costing you more to keepthese units on hand and pay storage fees than to reduce the number ofunits through a price reduction or removal.
fba_inventory_planning_data__estimated_ltsf_next_chargeTEXT(Deprecated) estimated-ltsf-next-charge (get_fba_inventory_planning_data)estimated-ltsf-next-charge (get_fba_inventory_planning_data)
fba_inventory_planning_data__estimated_storage_cost_next_monthNUMERICestimated-storage-cost-next-month (get_fba_inventory_planning_data)estimated-storage-cost-next-month (get_fba_inventory_planning_data)Estimated storage fees (monthly storage + long-term storage) that youwould incur 30 days from today, based on your current sales rate.Note: Inventory costs are based on quantities in the latest dailysnapshot and may differ from your actual inventory quantities.
fba_inventory_planning_data__featuredoffer_priceNUMERICfeaturedoffer-price (get_fba_inventory_planning_data)featuredoffer-price (get_fba_inventory_planning_data) Offer displayedon a product detail page with an Add to Cart button
fba_inventory_planning_data__healthy_inventory_levelNUMERIChealthy-inventory-level (get_fba_inventory_planning_data)healthy-inventory-level (get_fba_inventory_planning_data) Quantity ofinventory that is not considered excess based on product demand andyour costs. Our recommendations are based on helping you reach thislevel of inventory.
fba_inventory_planning_data__inbound_quantityNUMERICinbound-quantity (get_fba_inventory_planning_data)inbound-quantity (get_fba_inventory_planning_data) Inbound quantity =inbound-working + inbound-shipped + inbound receiving
fba_inventory_planning_data__inbound_receivedNUMERICinbound-received (get_fba_inventory_planning_data)inbound-received (get_fba_inventory_planning_data) Shipments inreceiving status
fba_inventory_planning_data__inbound_shippedNUMERICinbound-shipped (get_fba_inventory_planning_data)inbound-shipped (get_fba_inventory_planning_data) Shipments in shippedstatus
fba_inventory_planning_data__inbound_workingNUMERICinbound-working (get_fba_inventory_planning_data)inbound-working (get_fba_inventory_planning_data) Shipments in workingstatus
fba_inventory_planning_data__inv_age_0_to_30_daysTEXTinv-age-0-to-30-days (get_fba_inventory_planning_data)inv-age-0-to-30-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__inv_age_181_to_330_daysTEXTinv-age-181-to-330-days (get_fba_inventory_planning_data)inv-age-181-to-330-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__inv_age_31_to_60_daysTEXTinv-age-31-to-60-days (get_fba_inventory_planning_data)inv-age-31-to-60-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__inv_age_331_to_365_daysTEXTinv-age-331-to-365-days (get_fba_inventory_planning_data)inv-age-331-to-365-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__inv_age_61_to_90_daysTEXTinv-age-61-to-90-days (get_fba_inventory_planning_data)inv-age-61-to-90-days (get_fba_inventory_planning_data)
fba_inventory_planning_data__item_volumeNUMERICitem-volume (get_fba_inventory_planning_data)item-volume (get_fba_inventory_planning_data) The volume of the item,which is calculated by multiplying the longest side, median side, andshortest side together. These measurements generally correspond to thelength, width, and height of the item.
fba_inventory_planning_data__lowest_price_new_plus_shippingTEXTlowest-price-new-plus-shipping (get_fba_inventory_planning_data)lowest-price-new-plus-shipping (get_fba_inventory_planning_data)
fba_inventory_planning_data__lowest_price_usedTEXTlowest-price-used (get_fba_inventory_planning_data)lowest-price-used (get_fba_inventory_planning_data)
fba_inventory_planning_data__marketplaceTEXTmarketplace (get_fba_inventory_planning_data)marketplace (get_fba_inventory_planning_data) The Amazon store wherethe product is located
fba_inventory_planning_data__no_sale_last_6_monthsNUMERICno-sale-last-6-months (get_fba_inventory_planning_data)no-sale-last-6-months (get_fba_inventory_planning_data) Inventory thathas not sold in six or more consecutive months and that have been infulfillment centers for more than 180 days. These units will beautomatically removed during the next removal cycle if you are optedin to automated fulfillable inventory removals.
fba_inventory_planning_data__pending_removal_quantityNUMERICpending-removal-quantity (get_fba_inventory_planning_data)pending-removal-quantity (get_fba_inventory_planning_data) The numberof units that you have asked to be returned to you or disposed of

Amazon Seller Central (Amazon SP) get_fba_inventory_planning_data fields (fba_inventory_planning_data__projected_ltsf_9_mo to fba_inventory_planning_data__volume_unit_measurement)

IDTypeNameDescription
fba_inventory_planning_data__projected_ltsf_9_moTEXT(Deprecated) projected-ltsf-9-mo (get_fba_inventory_planning_data)projected-ltsf-9-mo (get_fba_inventory_planning_data)
fba_inventory_planning_data__qty_to_be_charged_ltsf_9_moTEXT(Deprecated) qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data)qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data)
fba_inventory_planning_data__recommended_actionTEXTrecommended-action (get_fba_inventory_planning_data)recommended-action (get_fba_inventory_planning_data) The actionrecommended for your inventory. Recommendations are based on yourcurrent customer demand and on whether it would cost you less to takean action than to do nothing.
fba_inventory_planning_data__recommended_removal_quantityNUMERICrecommended-removal-quantity (get_fba_inventory_planning_data)recommended-removal-quantity (get_fba_inventory_planning_data)Estimated number of units that would likely benefit from removalinstead of being charged storage fees
fba_inventory_planning_data__recommended_sale_duration_daysNUMERICrecommended-sale-duration-days (get_fba_inventory_planning_data)recommended-sale-duration-days (get_fba_inventory_planning_data) If asale is recommended, this is the estimated sale duration in days thatwould likely help you sell through your excess inventory.
fba_inventory_planning_data__recommended_sales_priceNUMERICrecommended-sales-price (get_fba_inventory_planning_data)recommended-sales-price (get_fba_inventory_planning_data) Sales pricerecommended to help you sell through your inventory based on yourcurrent inventory settings. This value may be different from thelowest price or Featured Offer price. We recommend that you keep yourproduct at this price until you have sold through your excessinventory.
fba_inventory_planning_data__sales_shipped_last_30_daysNUMERICsales-shipped-last-30-days (get_fba_inventory_planning_data)sales-shipped-last-30-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 30 days
fba_inventory_planning_data__sales_shipped_last_60_daysNUMERICsales-shipped-last-60-days (get_fba_inventory_planning_data)sales-shipped-last-60-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 60 days
fba_inventory_planning_data__sales_shipped_last_7_daysNUMERICsales-shipped-last-7-days (get_fba_inventory_planning_data)sales-shipped-last-7-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 7 days
fba_inventory_planning_data__sales_shipped_last_90_daysNUMERICsales-shipped-last-90-days (get_fba_inventory_planning_data)sales-shipped-last-90-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 90 days
fba_inventory_planning_data__sell_throughNUMERICsell-through (get_fba_inventory_planning_data)sell-through (get_fba_inventory_planning_data) The rate at which yourunits sold and shipped over the past 90 days divided by the averageinventory available at fulfillment centers during that time. Trackingyour sell-through rate can help you determine whether you need to takeaction to improve traffic or conversion for your products.
fba_inventory_planning_data__storage_typeTEXTstorage-type (get_fba_inventory_planning_data)storage-type (get_fba_inventory_planning_data) Storage-type categoryof the product for which storage limits are set. Note: Standard sizeincludes small and standard types.
fba_inventory_planning_data__storage_volumeNUMERICstorage-volume (get_fba_inventory_planning_data)storage-volume (get_fba_inventory_planning_data) Storage volume is thetotal usage for this product in our fulfillment centers minusinventory that is pending removal
fba_inventory_planning_data__units_shipped_t30NUMERICunits-shipped-t30 (get_fba_inventory_planning_data)units-shipped-t30 (get_fba_inventory_planning_data) Units shipped inthe last 30 days
fba_inventory_planning_data__units_shipped_t60NUMERICunits-shipped-t60 (get_fba_inventory_planning_data)units-shipped-t60 (get_fba_inventory_planning_data) Units shipped inthe last 60 days
fba_inventory_planning_data__units_shipped_t7NUMERICunits-shipped-t7 (get_fba_inventory_planning_data)units-shipped-t7 (get_fba_inventory_planning_data) Units shipped inthe last 7 days
fba_inventory_planning_data__units_shipped_t90NUMERICunits-shipped-t90 (get_fba_inventory_planning_data)units-shipped-t90 (get_fba_inventory_planning_data) Units shipped inthe last 90 days
fba_inventory_planning_data__volume_unit_measurementTEXTvolume-unit-measurement (get_fba_inventory_planning_data)volume-unit-measurement (get_fba_inventory_planning_data) Unit ofmeasurement for the volume of the item

Amazon Seller Central (Amazon SP) get_fba_myi_unsuppressed_inventory_data fields

The get_fba_myi_unsuppressed_inventory_data report of the Amazon Seller Central (Amazon SP) connector includes 21 fields.

IDTypeNameDescription
fba_myi_unsuppressed_inventory_data__afn_fulfillable_quantityNUMERICafn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data)afn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for a SKU in Amazon fulfillment centersthat can be picked, packed, and shipped.
fba_myi_unsuppressed_inventory_data__afn_future_supply_buyableNUMERICafn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data)afn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data)The number of units available for customers to find and buy whileinventory is on its way to an Amazon fulfillment center through In-Stock Head Start.
fba_myi_unsuppressed_inventory_data__afn_inbound_receiving_quantityNUMERICafn-inbound-receiving-quantity (get_fba_myi_unsuppressed_inventory_data)afn-inbound-receiving-quantity(get_fba_myi_unsuppressed_inventory_data) The number of units you havefor a SKU that have not yet been received atan Amazon fulfillment center for processing, but are part of aninbound shipment with some units that havealready been received and processed.
fba_myi_unsuppressed_inventory_data__afn_inbound_shipped_quantityNUMERICafn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data)afn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data)The number of units you have for a SKU in an inbound shipment that youhave notified Amazon about and provided a tracking number.
fba_myi_unsuppressed_inventory_data__afn_inbound_working_quantityNUMERICafn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data)afn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data)The number of units you have for a SKU in an inbound shipment that youhave notified Amazon about.
fba_myi_unsuppressed_inventory_data__afn_listing_existsTEXTafn-listing-exists (get_fba_myi_unsuppressed_inventory_data)afn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"indicates that the item is listed for Fulfillment byAmazon.
fba_myi_unsuppressed_inventory_data__afn_researching_quantityNUMERICafn-researching-quantity (get_fba_myi_unsuppressed_inventory_data)afn-researching-quantity (get_fba_myi_unsuppressed_inventory_data)
fba_myi_unsuppressed_inventory_data__afn_reserved_future_supplyNUMERICafn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data)afn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data)The number of units that customers have purchased while inventory ison its way to an Amazon fulfillment centerthrough In-Stock Head Start.
fba_myi_unsuppressed_inventory_data__afn_reserved_quantityNUMERICafn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data)afn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for a SKU in Amazon fulfillment centersthat are currently being picked, packed, and shipped or are sidelinedfor measurement, sampling, or other internalprocesses.
fba_myi_unsuppressed_inventory_data__afn_total_quantityNUMERICafn-total-quantity (get_fba_myi_unsuppressed_inventory_data)afn-total-quantity (get_fba_myi_unsuppressed_inventory_data) The totalnumber of units you have for a SKU in an inbound shipment orin Amazon fulfillment centers: (afn-total-quantity) =(afn-warehouse-quantity) + (afn-inbound-working-quantity) +(afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity)
fba_myi_unsuppressed_inventory_data__afn_unsellable_quantityNUMERICafn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data)afn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for a SKU in Amazon fulfillment centers inunsellable condition.
fba_myi_unsuppressed_inventory_data__afn_warehouse_quantityNUMERICafn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data)afn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for an SKU in Amazon fulfillment centersthat have been processed: (afn-warehouse-quantity) =(afn-fulfillable-quantity) + (afn-unsellable-quantity) +(afn-reserved-quantity).
fba_myi_unsuppressed_inventory_data__asinTEXTasin (get_fba_myi_unsuppressed_inventory_data)asin (get_fba_myi_unsuppressed_inventory_data) Amazon StandardIdentification Numbers (ASINs) are unique blocks of 10letters or numbers that identify items. ASINs are assigned by Amazon.You can find the ASIN on the product detailpage.
fba_myi_unsuppressed_inventory_data__conditionTEXTcondition (get_fba_myi_unsuppressed_inventory_data)condition (get_fba_myi_unsuppressed_inventory_data) The condition ofyour product.
fba_myi_unsuppressed_inventory_data__fnskuTEXTfnsku (get_fba_myi_unsuppressed_inventory_data)fnsku (get_fba_myi_unsuppressed_inventory_data) Fulfillment NetworkStock Keeping Units (FNSKUs) are unique identifiersassigned by Amazon to products stored in and fulfilled from Amazonfulfillment centers.
fba_myi_unsuppressed_inventory_data__mfn_fulfillable_quantityTEXTmfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data)mfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) Thequantity in your fulfillment network that can be picked, packed, andshipped.
fba_myi_unsuppressed_inventory_data__mfn_listing_existsTEXTmfn-listing-exists (get_fba_myi_unsuppressed_inventory_data)mfn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"indicates that the product is listed for fulfillment by you as theseller.
fba_myi_unsuppressed_inventory_data__per_unit_volumeNUMERICper-unit-volume (get_fba_myi_unsuppressed_inventory_data)per-unit-volume (get_fba_myi_unsuppressed_inventory_data) The volumein cubic feet of one unit (to the nearest1/100 of an inch).
fba_myi_unsuppressed_inventory_data__product_nameTEXTproduct-name (get_fba_myi_unsuppressed_inventory_data)product-name (get_fba_myi_unsuppressed_inventory_data) The title ofyour product.
fba_myi_unsuppressed_inventory_data__skuTEXTsku (get_fba_myi_unsuppressed_inventory_data)sku (get_fba_myi_unsuppressed_inventory_data) Stock Keeping Units(SKUs) are unique blocks of letters or numbers thatidentify your products.
fba_myi_unsuppressed_inventory_data__your_priceNUMERICyour-price (get_fba_myi_unsuppressed_inventory_data)your-price (get_fba_myi_unsuppressed_inventory_data) Your currentselling price.

Amazon Seller Central (Amazon SP) get_fba_reimbursements_data fields

The get_fba_reimbursements_data report of the Amazon Seller Central (Amazon SP) connector includes 18 fields.

IDTypeNameDescription
fba_reimbursements_data__amazon_order_idTEXTamazon-order-id (get_fba_reimbursements_data)amazon-order-id (get_fba_reimbursements_data) The unique identifierassigned to the customer order. This field isempty if the reimbursement is not associated with an order.
fba_reimbursements_data__amount_per_unitNUMERICamount-per-unit (get_fba_reimbursements_data)amount-per-unit (get_fba_reimbursements_data) The per-unitreimbursement amount for this line item.
fba_reimbursements_data__amount_totalNUMERICamount-total (get_fba_reimbursements_data)amount-total (get_fba_reimbursements_data) The total amount of thecash reimbursement for this line item.
fba_reimbursements_data__approval_dateDATEapproval-date (get_fba_reimbursements_data)approval-date (get_fba_reimbursements_data) The date the reimbursementwas approved.
fba_reimbursements_data__asinTEXTasin (get_fba_reimbursements_data)asin (get_fba_reimbursements_data) An ASIN (Amazon StandardIdentification Numbers) is a unique identifierassigned by Amazon to products in the Amazon product catalog. The ASINcan be found on the product detail page.
fba_reimbursements_data__case_idTEXTcase-id (get_fba_reimbursements_data)case-id (get_fba_reimbursements_data) The unique identifier assignedto the case when you request a reimbursement.
fba_reimbursements_data__conditionTEXTcondition (get_fba_reimbursements_data)condition (get_fba_reimbursements_data) The condition of your item(for example, New).
fba_reimbursements_data__currency_unitTEXTcurrency-unit (get_fba_reimbursements_data)currency-unit (get_fba_reimbursements_data) The currency for theapplicable marketplace.
fba_reimbursements_data__fnskuTEXTfnsku (get_fba_reimbursements_data)fnsku (get_fba_reimbursements_data) The fulfillment network SKU (stockkeeping unit) is the unique identifierFulfillment by Amazon assigned to your product.
fba_reimbursements_data__original_reimbursement_idTEXToriginal-reimbursement-id (get_fba_reimbursements_data)original-reimbursement-id (get_fba_reimbursements_data)
fba_reimbursements_data__original_reimbursement_typeTEXToriginal-reimbursement-type (get_fba_reimbursements_data)original-reimbursement-type (get_fba_reimbursements_data)
fba_reimbursements_data__product_nameTEXTproduct-name (get_fba_reimbursements_data)product-name (get_fba_reimbursements_data) The name of your product.
fba_reimbursements_data__quantity_reimbursed_cashNUMERICquantity-reimbursed-cash (get_fba_reimbursements_data)quantity-reimbursed-cash (get_fba_reimbursements_data) The totalnumber of units reimbursed with cash.
fba_reimbursements_data__quantity_reimbursed_inventoryNUMERICquantity-reimbursed-inventory (get_fba_reimbursements_data)quantity-reimbursed-inventory (get_fba_reimbursements_data) The numberof units reimbursed with inventory.
fba_reimbursements_data__quantity_reimbursed_totalNUMERICquantity-reimbursed-total (get_fba_reimbursements_data)quantity-reimbursed-total (get_fba_reimbursements_data) The totalnumber of units reimbursed with either cash or inventory(Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]).
fba_reimbursements_data__reasonTEXTreason (get_fba_reimbursements_data)reason (get_fba_reimbursements_data) The reason for the reimbursement(for example, Damaged: Warehouse).
fba_reimbursements_data__reimbursement_idTEXTreimbursement-id (get_fba_reimbursements_data)reimbursement-id (get_fba_reimbursements_data) The unique identifierfor this reimbursement. Each reimbursement mayinclude multiple line items.
fba_reimbursements_data__skuTEXTsku (get_fba_reimbursements_data)sku (get_fba_reimbursements_data)

Amazon Seller Central (Amazon SP) get_fba_uno_inventory_data fields

The get_fba_uno_inventory_data report of the Amazon Seller Central (Amazon SP) connector includes 4 fields.

IDTypeNameDescription
fba_uno_inventory_data__asinTEXT(Deprecated) asin (get_fba_uno_inventory_data)asin (get_fba_uno_inventory_data)
fba_uno_inventory_data__priceNUMERIC(Deprecated) price (get_fba_uno_inventory_data)price (get_fba_uno_inventory_data)
fba_uno_inventory_data__quantityNUMERIC(Deprecated) quantity (get_fba_uno_inventory_data)quantity (get_fba_uno_inventory_data)
fba_uno_inventory_data__skuTEXT(Deprecated) sku (get_fba_uno_inventory_data)sku (get_fba_uno_inventory_data)

Amazon Seller Central (Amazon SP) get_flat_file_all_orders_data_by_last_update_general fields

The get_flat_file_all_orders_data_by_last_update_general report of the Amazon Seller Central (Amazon SP) connector includes 31 fields.

IDTypeNameDescription
flat_file_all_orders_data_by_last_update_general__amazon_order_idTEXTamazon-order-id (get_flat_file_all_orders_data_by_last_update_general)amazon-order-id (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__asinTEXTasin (get_flat_file_all_orders_data_by_last_update_general)asin (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__currencyTEXTcurrency (get_flat_file_all_orders_data_by_last_update_general)currency (get_flat_file_all_orders_data_by_last_update_general)Currency type Example: USD
flat_file_all_orders_data_by_last_update_general__fulfillment_channelTEXTfulfillment-channel (get_flat_file_all_orders_data_by_last_update_general)fulfillment-channel(get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__gift_wrap_priceNUMERICgift-wrap-price (get_flat_file_all_orders_data_by_last_update_general)gift-wrap-price (get_flat_file_all_orders_data_by_last_update_general)The price of the gift wrap selected by the buyer.
flat_file_all_orders_data_by_last_update_general__gift_wrap_taxNUMERICgift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general)gift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general)The amount of tax paid on the gift wrap.
flat_file_all_orders_data_by_last_update_general__is_business_orderTEXTis-business-order (get_flat_file_all_orders_data_by_last_update_general)is-business-order(get_flat_file_all_orders_data_by_last_update_general) Indicates ifthe order is from an Amazon Business customer.Example: true, false
flat_file_all_orders_data_by_last_update_general__item_priceNUMERICitem-price (get_flat_file_all_orders_data_by_last_update_general)item-price (get_flat_file_all_orders_data_by_last_update_general)Price a buyer paid for the item(s). All amounts are aggregates of thequantity, not unit prices.Example: Item Price = $10 Quantity = 2 Itemprice displayed = $20
flat_file_all_orders_data_by_last_update_general__item_promotion_discountTEXTitem-promotion-discount (get_flat_file_all_orders_data_by_last_update_general)item-promotion-discount(get_flat_file_all_orders_data_by_last_update_general) Amountdiscounted from orders that qualify for either a money-off or apercent-off promotion.
flat_file_all_orders_data_by_last_update_general__item_statusTEXTitem-status (get_flat_file_all_orders_data_by_last_update_general)item-status (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__item_taxNUMERICitem-tax (get_flat_file_all_orders_data_by_last_update_general)item-tax (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__last_updated_dateDATElast-updated-date (get_flat_file_all_orders_data_by_last_update_general)last-updated-date(get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__merchant_order_idTEXTmerchant-order-id (get_flat_file_all_orders_data_by_last_update_general)merchant-order-id(get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__order_channelTEXTorder-channel (get_flat_file_all_orders_data_by_last_update_general)order-channel (get_flat_file_all_orders_data_by_last_update_general)Information about how an order was placed.
flat_file_all_orders_data_by_last_update_general__order_statusTEXTorder-status (get_flat_file_all_orders_data_by_last_update_general)order-status (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__price_designationTEXTprice-designation (get_flat_file_all_orders_data_by_last_update_general)price-designation(get_flat_file_all_orders_data_by_last_update_general) Indicates thetype of business price that the buyer used. Learn more about businessprices. (Amazon Business Seller Program only.)
flat_file_all_orders_data_by_last_update_general__product_nameTEXTproduct-name (get_flat_file_all_orders_data_by_last_update_general)product-name (get_flat_file_all_orders_data_by_last_update_general)Short title for the product, displayed on the product detail page andin the browser title bar.Example: Snowboard
flat_file_all_orders_data_by_last_update_general__promotion_idsTEXTpromotion-ids (get_flat_file_all_orders_data_by_last_update_general)promotion-ids (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__purchase_dateDATEpurchase-date (get_flat_file_all_orders_data_by_last_update_general)purchase-date (get_flat_file_all_orders_data_by_last_update_general)Date the order was placed, in yyyy-mm-dd format. Note: Unless youspecify a different shipping lead time, you have agreed to ship theorder within two business days of this date.
flat_file_all_orders_data_by_last_update_general__purchase_order_numberTEXTpurchase-order-number (get_flat_file_all_orders_data_by_last_update_general)purchase-order-number(get_flat_file_all_orders_data_by_last_update_general) The buyer'spurchase order number (for orders from Amazon Business customers).This must be included on the customer package packing slip or on thepackage shipping label. For more information on packing slips andpurchase order numbers, click here.
flat_file_all_orders_data_by_last_update_general__quantityTEXTquantity (get_flat_file_all_orders_data_by_last_update_general)quantity (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__sales_channelTEXTsales-channel (get_flat_file_all_orders_data_by_last_update_general)sales-channel (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__ship_cityCITYship-city (get_flat_file_all_orders_data_by_last_update_general)ship-city (get_flat_file_all_orders_data_by_last_update_general) Cityof "Ship To" address.
flat_file_all_orders_data_by_last_update_general__ship_countryCOUNTRYship-country (get_flat_file_all_orders_data_by_last_update_general)ship-country (get_flat_file_all_orders_data_by_last_update_general)International Standards Organization two-letter country code (ISO3166-2 compliant).Example: US
flat_file_all_orders_data_by_last_update_general__ship_postal_codeTEXTship-postal-code (get_flat_file_all_orders_data_by_last_update_general)ship-postal-code(get_flat_file_all_orders_data_by_last_update_general) ZIP code orpostal code of "Ship To" address. Value format depends on destinationcountry.
flat_file_all_orders_data_by_last_update_general__ship_promotion_discountTEXTship-promotion-discount (get_flat_file_all_orders_data_by_last_update_general)ship-promotion-discount(get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__ship_service_levelTEXTship-service-level (get_flat_file_all_orders_data_by_last_update_general)ship-service-level(get_flat_file_all_orders_data_by_last_update_general) Type ofshipping selected by the buyer when ordering the item; for example,standard, expedited.
flat_file_all_orders_data_by_last_update_general__ship_stateTEXTship-state (get_flat_file_all_orders_data_by_last_update_general)ship-state (get_flat_file_all_orders_data_by_last_update_general)State, province, or region of "Ship To" address. Varies with countryof origin. Note: Abbreviations can vary depending on how it wasentered by the buyer.
flat_file_all_orders_data_by_last_update_general__shipping_priceNUMERICshipping-price (get_flat_file_all_orders_data_by_last_update_general)shipping-price (get_flat_file_all_orders_data_by_last_update_general)Price a buyer paid for shipping. All amounts are aggregates of thequantity, not unit prices.
flat_file_all_orders_data_by_last_update_general__shipping_taxTEXTshipping-tax (get_flat_file_all_orders_data_by_last_update_general)shipping-tax (get_flat_file_all_orders_data_by_last_update_general)
flat_file_all_orders_data_by_last_update_general__skuTEXTsku (get_flat_file_all_orders_data_by_last_update_general)sku (get_flat_file_all_orders_data_by_last_update_general) StockKeeping Unit. The seller-defined unique identifier for a product.Example: AA786936215595

Amazon Seller Central (Amazon SP) get_flat_file_all_orders_data_by_order_date_general fields

The get_flat_file_all_orders_data_by_order_date_general report of the Amazon Seller Central (Amazon SP) connector includes 31 fields.

IDTypeNameDescription
flat_file_all_orders_data_by_order_date_general__amazon_order_idTEXTamazon-order-id (get_flat_file_all_orders_data_by_order_date_general)amazon-order-id (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__asinTEXTasin (get_flat_file_all_orders_data_by_order_date_general)asin (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__currencyTEXTcurrency (get_flat_file_all_orders_data_by_order_date_general)currency (get_flat_file_all_orders_data_by_order_date_general)Currency type Example: USD
flat_file_all_orders_data_by_order_date_general__fulfillment_channelTEXTfulfillment-channel (get_flat_file_all_orders_data_by_order_date_general)fulfillment-channel(get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__gift_wrap_priceNUMERICgift-wrap-price (get_flat_file_all_orders_data_by_order_date_general)gift-wrap-price (get_flat_file_all_orders_data_by_order_date_general)The price of the gift wrap selected by the buyer.
flat_file_all_orders_data_by_order_date_general__gift_wrap_taxNUMERICgift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general)gift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general)The amount of tax paid on the gift wrap.
flat_file_all_orders_data_by_order_date_general__is_business_orderTEXTis-business-order (get_flat_file_all_orders_data_by_order_date_general)is-business-order(get_flat_file_all_orders_data_by_order_date_general) Indicates if theorder is from an Amazon Business customer.Example: true, false
flat_file_all_orders_data_by_order_date_general__item_priceNUMERICitem-price (get_flat_file_all_orders_data_by_order_date_general)item-price (get_flat_file_all_orders_data_by_order_date_general) Pricea buyer paid for the item(s). All amounts are aggregates of thequantity, not unit prices.Example: Item Price = $10 Quantity = 2 Itemprice displayed = $20
flat_file_all_orders_data_by_order_date_general__item_promotion_discountTEXTitem-promotion-discount (get_flat_file_all_orders_data_by_order_date_general)item-promotion-discount(get_flat_file_all_orders_data_by_order_date_general) Amountdiscounted from orders that qualify for either a money-off or apercent-off promotion.
flat_file_all_orders_data_by_order_date_general__item_statusTEXTitem-status (get_flat_file_all_orders_data_by_order_date_general)item-status (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__item_taxNUMERICitem-tax (get_flat_file_all_orders_data_by_order_date_general)item-tax (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__last_updated_dateDATElast-updated-date (get_flat_file_all_orders_data_by_order_date_general)last-updated-date(get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__merchant_order_idTEXTmerchant-order-id (get_flat_file_all_orders_data_by_order_date_general)merchant-order-id(get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__order_channelTEXTorder-channel (get_flat_file_all_orders_data_by_order_date_general)order-channel (get_flat_file_all_orders_data_by_order_date_general)Information about how an order was placed.
flat_file_all_orders_data_by_order_date_general__order_statusTEXTorder-status (get_flat_file_all_orders_data_by_order_date_general)order-status (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__price_designationTEXTprice-designation (get_flat_file_all_orders_data_by_order_date_general)price-designation(get_flat_file_all_orders_data_by_order_date_general) Indicates thetype of business price that the buyer used. Learn more about businessprices. (Amazon Business Seller Program only.)
flat_file_all_orders_data_by_order_date_general__product_nameTEXTproduct-name (get_flat_file_all_orders_data_by_order_date_general)product-name (get_flat_file_all_orders_data_by_order_date_general)Short title for the product, displayed on the product detail page andin the browser title bar.Example: Snowboard
flat_file_all_orders_data_by_order_date_general__promotion_idsTEXTpromotion-ids (get_flat_file_all_orders_data_by_order_date_general)promotion-ids (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__purchase_dateTIMESTAMPpurchase-date (get_flat_file_all_orders_data_by_order_date_general)purchase-date (get_flat_file_all_orders_data_by_order_date_general)Date the order was placed, in yyyy-mm-dd format. Note: Unless youspecify a different shipping lead time, you have agreed to ship theorder within two business days of this date.
flat_file_all_orders_data_by_order_date_general__purchase_order_numberTEXTpurchase-order-number (get_flat_file_all_orders_data_by_order_date_general)purchase-order-number(get_flat_file_all_orders_data_by_order_date_general) The buyer'spurchase order number (for orders from Amazon Business customers).This must be included on the customer package packing slip or on thepackage shipping label. For more information on packing slips andpurchase order numbers, click here.
flat_file_all_orders_data_by_order_date_general__quantityTEXTquantity (get_flat_file_all_orders_data_by_order_date_general)quantity (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__sales_channelTEXTsales-channel (get_flat_file_all_orders_data_by_order_date_general)sales-channel (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__ship_cityCITYship-city (get_flat_file_all_orders_data_by_order_date_general)ship-city (get_flat_file_all_orders_data_by_order_date_general) Cityof "Ship To" address.
flat_file_all_orders_data_by_order_date_general__ship_countryCOUNTRYship-country (get_flat_file_all_orders_data_by_order_date_general)ship-country (get_flat_file_all_orders_data_by_order_date_general)International Standards Organization two-letter country code (ISO3166-2 compliant).Example: US
flat_file_all_orders_data_by_order_date_general__ship_postal_codeTEXTship-postal-code (get_flat_file_all_orders_data_by_order_date_general)ship-postal-code (get_flat_file_all_orders_data_by_order_date_general)ZIP code or postal code of "Ship To" address. Value format depends ondestination country.
flat_file_all_orders_data_by_order_date_general__ship_promotion_discountTEXTship-promotion-discount (get_flat_file_all_orders_data_by_order_date_general)ship-promotion-discount(get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__ship_service_levelTEXTship-service-level (get_flat_file_all_orders_data_by_order_date_general)ship-service-level(get_flat_file_all_orders_data_by_order_date_general) Type of shippingselected by the buyer when ordering the item; for example, standard,expedited.
flat_file_all_orders_data_by_order_date_general__ship_stateTEXTship-state (get_flat_file_all_orders_data_by_order_date_general)ship-state (get_flat_file_all_orders_data_by_order_date_general)State, province, or region of "Ship To" address. Varies with countryof origin. Note: Abbreviations can vary depending on how it wasentered by the buyer.
flat_file_all_orders_data_by_order_date_general__shipping_priceNUMERICshipping-price (get_flat_file_all_orders_data_by_order_date_general)shipping-price (get_flat_file_all_orders_data_by_order_date_general)Price a buyer paid for shipping. All amounts are aggregates of thequantity, not unit prices.
flat_file_all_orders_data_by_order_date_general__shipping_taxTEXTshipping-tax (get_flat_file_all_orders_data_by_order_date_general)shipping-tax (get_flat_file_all_orders_data_by_order_date_general)
flat_file_all_orders_data_by_order_date_general__skuTEXTsku (get_flat_file_all_orders_data_by_order_date_general)sku (get_flat_file_all_orders_data_by_order_date_general) StockKeeping Unit. The seller-defined unique identifier for a product.Example: AA786936215595

Amazon Seller Central (Amazon SP) get_flat_file_open_listings_data fields

The get_flat_file_open_listings_data report of the Amazon Seller Central (Amazon SP) connector includes 23 fields.

IDTypeNameDescription
flat_file_open_listings_data__asinTEXTasin (get_flat_file_open_listings_data)asin (get_flat_file_open_listings_data)
flat_file_open_listings_data__business_priceTEXTBusiness Price (get_flat_file_open_listings_data)Business Price (get_flat_file_open_listings_data)
flat_file_open_listings_data__priceNUMERICprice (get_flat_file_open_listings_data)price (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_lower_bound_1TEXTProgressive Lower Bound 1 (get_flat_file_open_listings_data)Progressive Lower Bound 1 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_lower_bound_2TEXTProgressive Lower Bound 2 (get_flat_file_open_listings_data)Progressive Lower Bound 2 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_lower_bound_3TEXTProgressive Lower Bound 3 (get_flat_file_open_listings_data)Progressive Lower Bound 3 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_1TEXTProgressive Price 1 (get_flat_file_open_listings_data)Progressive Price 1 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_2TEXTProgressive Price 2 (get_flat_file_open_listings_data)Progressive Price 2 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_3TEXTProgressive Price 3 (get_flat_file_open_listings_data)Progressive Price 3 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_typeTEXTProgressive Price Type (get_flat_file_open_listings_data)Progressive Price Type (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantityNUMERICquantity (get_flat_file_open_listings_data)quantity (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_lower_bound_1TEXTQuantity Lower Bound 1 (get_flat_file_open_listings_data)Quantity Lower Bound 1 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_lower_bound_2TEXTQuantity Lower Bound 2 (get_flat_file_open_listings_data)Quantity Lower Bound 2 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_lower_bound_3TEXTQuantity Lower Bound 3 (get_flat_file_open_listings_data)Quantity Lower Bound 3 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_lower_bound_4TEXTQuantity Lower Bound 4 (get_flat_file_open_listings_data)Quantity Lower Bound 4 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_lower_bound_5TEXTQuantity Lower Bound 5 (get_flat_file_open_listings_data)Quantity Lower Bound 5 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_1TEXTQuantity Price 1 (get_flat_file_open_listings_data)Quantity Price 1 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_2TEXTQuantity Price 2 (get_flat_file_open_listings_data)Quantity Price 2 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_3TEXTQuantity Price 3 (get_flat_file_open_listings_data)Quantity Price 3 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_4TEXTQuantity Price 4 (get_flat_file_open_listings_data)Quantity Price 4 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_5TEXTQuantity Price 5 (get_flat_file_open_listings_data)Quantity Price 5 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_typeTEXTQuantity Price Type (get_flat_file_open_listings_data)Quantity Price Type (get_flat_file_open_listings_data)
flat_file_open_listings_data__skuTEXTsku (get_flat_file_open_listings_data)sku (get_flat_file_open_listings_data)

Amazon Seller Central (Amazon SP) get_flat_file_returns_data_by_return_date fields

The get_flat_file_returns_data_by_return_date report of the Amazon Seller Central (Amazon SP) connector includes 32 fields.

IDTypeNameDescription
flat_file_returns_data_by_return_date__a_to_z_claimTEXTA-to-Z Claim (get_flat_file_returns_data_by_return_date)A-to-Z Claim (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__amazon_rma_idTEXTAmazon RMA ID (get_flat_file_returns_data_by_return_date)Amazon RMA ID (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__asinTEXTASIN (get_flat_file_returns_data_by_return_date)ASIN (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__currency_codeTEXTCurrency code (get_flat_file_returns_data_by_return_date)Currency code (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__in_policyTEXTIn policy (get_flat_file_returns_data_by_return_date)In policy (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__invoice_numberTEXTInvoice number (get_flat_file_returns_data_by_return_date)Invoice number (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__is_primeTEXTIs prime (get_flat_file_returns_data_by_return_date)Is prime (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__item_nameTEXTItem Name (get_flat_file_returns_data_by_return_date)Item Name (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__label_costNUMERICLabel cost (get_flat_file_returns_data_by_return_date)Label cost (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__label_to_be_paid_byTEXTLabel to be paid by (get_flat_file_returns_data_by_return_date)Label to be paid by (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__label_typeTEXTLabel type (get_flat_file_returns_data_by_return_date)Label type (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__merchant_rma_idTEXTMerchant RMA ID (get_flat_file_returns_data_by_return_date)Merchant RMA ID (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__merchant_skuTEXTMerchant SKU (get_flat_file_returns_data_by_return_date)Merchant SKU (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__order_amountNUMERICOrder Amount (get_flat_file_returns_data_by_return_date)Order Amount (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__order_dateDATEOrder date (get_flat_file_returns_data_by_return_date)Order date (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__order_idTEXTOrder ID (get_flat_file_returns_data_by_return_date)Order ID (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__order_quantityNUMERICOrder quantity (get_flat_file_returns_data_by_return_date)Order quantity (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__refunded_amountNUMERICRefunded Amount (get_flat_file_returns_data_by_return_date)Refunded Amount (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__resolutionTEXTResolution (get_flat_file_returns_data_by_return_date)Resolution (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_carrierTEXTReturn carrier (get_flat_file_returns_data_by_return_date)Return carrier (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_delivery_dateDATEReturn delivery date (get_flat_file_returns_data_by_return_date)Return delivery date (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_quantityNUMERICReturn quantity (get_flat_file_returns_data_by_return_date)Return quantity (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_reasonTEXTReturn Reason (get_flat_file_returns_data_by_return_date)Return Reason (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_request_dateDATEReturn request date (get_flat_file_returns_data_by_return_date)Return request date (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_request_statusTEXTReturn request status (get_flat_file_returns_data_by_return_date)Return request status (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__return_typeTEXTReturn type (get_flat_file_returns_data_by_return_date)Return type (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__safet_action_reasonTEXTSafeT Action reason (get_flat_file_returns_data_by_return_date)SafeT Action reason (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__safet_claim_creation_timeTIMESTAMPSafeT claim creation time (get_flat_file_returns_data_by_return_date)SafeT claim creation time (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__safet_claim_idTEXTSafeT claim id (get_flat_file_returns_data_by_return_date)SafeT claim id (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__safet_claim_reimbursement_amountNUMERICSafeT claim reimbursement amount (get_flat_file_returns_data_by_return_date)SafeT claim reimbursement amount (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__safet_claim_stateTEXTSafeT claim state (get_flat_file_returns_data_by_return_date)SafeT claim state (get_flat_file_returns_data_by_return_date)
flat_file_returns_data_by_return_date__tracking_idTEXTTracking ID (get_flat_file_returns_data_by_return_date)Tracking ID (get_flat_file_returns_data_by_return_date)

Amazon Seller Central (Amazon SP) get_ledger_detail_view_data fields

The get_ledger_detail_view_data report of the Amazon Seller Central (Amazon SP) connector includes 14 fields.

IDTypeNameDescription
ledger_detail_view_data__asinTEXTASIN (get_ledger_detail_view_data)ASIN (get_ledger_detail_view_data)
ledger_detail_view_data__countryCOUNTRYCountry (get_ledger_detail_view_data)Country (get_ledger_detail_view_data)
ledger_detail_view_data__dateDATEDate (get_ledger_detail_view_data)Date (get_ledger_detail_view_data)
ledger_detail_view_data__dispositionTEXTDisposition (get_ledger_detail_view_data)Disposition (get_ledger_detail_view_data)
ledger_detail_view_data__event_typeTEXTEvent Type (get_ledger_detail_view_data)Event Type (get_ledger_detail_view_data)
ledger_detail_view_data__fnskuTEXTFNSKU (get_ledger_detail_view_data)FNSKU (get_ledger_detail_view_data)
ledger_detail_view_data__fulfillment_centerTEXTFulfillment Center (get_ledger_detail_view_data)Fulfillment Center (get_ledger_detail_view_data)
ledger_detail_view_data__mskuTEXTMSKU (get_ledger_detail_view_data)MSKU (get_ledger_detail_view_data)
ledger_detail_view_data__quantityNUMERICQuantity (get_ledger_detail_view_data)Quantity (get_ledger_detail_view_data)
ledger_detail_view_data__reasonTEXTReason (get_ledger_detail_view_data)Reason (get_ledger_detail_view_data)
ledger_detail_view_data__reconciled_quantityNUMERICReconciled Quantity (get_ledger_detail_view_data)Reconciled Quantity (get_ledger_detail_view_data)
ledger_detail_view_data__reference_idTEXTReference ID (get_ledger_detail_view_data)Reference ID (get_ledger_detail_view_data)
ledger_detail_view_data__titleTEXTTitle (get_ledger_detail_view_data)Title (get_ledger_detail_view_data)
ledger_detail_view_data__unreconciled_quantityNUMERICUnreconciled Quantity (get_ledger_detail_view_data)Unreconciled Quantity (get_ledger_detail_view_data)

Amazon Seller Central (Amazon SP) get_ledger_summary_view_data fields

The get_ledger_summary_view_data report of the Amazon Seller Central (Amazon SP) connector includes 21 fields.

IDTypeNameDescription
ledger_summary_view_data__asinTEXTASIN (get_ledger_summary_view_data)ASIN (get_ledger_summary_view_data)
ledger_summary_view_data__customer_returnsNUMERICCustomer Returns (get_ledger_summary_view_data)Customer Returns (get_ledger_summary_view_data)
ledger_summary_view_data__customer_shipmentsNUMERICCustomer Shipments (get_ledger_summary_view_data)Customer Shipments (get_ledger_summary_view_data)
ledger_summary_view_data__damagedNUMERICDamaged (get_ledger_summary_view_data)Damaged (get_ledger_summary_view_data)
ledger_summary_view_data__dateDATEDate (get_ledger_summary_view_data)Date (get_ledger_summary_view_data)
ledger_summary_view_data__disposedNUMERICDisposed (get_ledger_summary_view_data)Disposed (get_ledger_summary_view_data)
ledger_summary_view_data__dispositionTEXTDisposition (get_ledger_summary_view_data)Disposition (get_ledger_summary_view_data)
ledger_summary_view_data__ending_warehouse_balanceNUMERICEnding Warehouse Balance (get_ledger_summary_view_data)Ending Warehouse Balance (get_ledger_summary_view_data)
ledger_summary_view_data__fnskuTEXTFNSKU (get_ledger_summary_view_data)FNSKU (get_ledger_summary_view_data)
ledger_summary_view_data__foundNUMERICFound (get_ledger_summary_view_data)Found (get_ledger_summary_view_data)
ledger_summary_view_data__in_transit_between_warehousesNUMERICIn Transit Between Warehouses (get_ledger_summary_view_data)In Transit Between Warehouses (get_ledger_summary_view_data)
ledger_summary_view_data__locationTEXTLocation (get_ledger_summary_view_data)Location (get_ledger_summary_view_data)
ledger_summary_view_data__lostNUMERICLost (get_ledger_summary_view_data)Lost (get_ledger_summary_view_data)
ledger_summary_view_data__mskuTEXTMSKU (get_ledger_summary_view_data)MSKU (get_ledger_summary_view_data)
ledger_summary_view_data__other_eventsNUMERICOther Events (get_ledger_summary_view_data)Other Events (get_ledger_summary_view_data)
ledger_summary_view_data__receiptsNUMERICReceipts (get_ledger_summary_view_data)Receipts (get_ledger_summary_view_data)
ledger_summary_view_data__starting_warehouse_balanceNUMERICStarting Warehouse Balance (get_ledger_summary_view_data)Starting Warehouse Balance (get_ledger_summary_view_data)
ledger_summary_view_data__titleTEXTTitle (get_ledger_summary_view_data)Title (get_ledger_summary_view_data)
ledger_summary_view_data__unknown_eventsNUMERICUnknown Events (get_ledger_summary_view_data)Unknown Events (get_ledger_summary_view_data)
ledger_summary_view_data__vendor_returnsNUMERICVendor Returns (get_ledger_summary_view_data)Vendor Returns (get_ledger_summary_view_data)
ledger_summary_view_data__warehouse_transfer_in_outNUMERICWarehouse Transfer In/Out (get_ledger_summary_view_data)Warehouse Transfer In/Out (get_ledger_summary_view_data)

Amazon Seller Central (Amazon SP) get_merchant_listings_all_data fields

The get_merchant_listings_all_data report of the Amazon Seller Central (Amazon SP) connector includes 29 fields.

IDTypeNameDescription
merchant_listings_all_data__add_deleteTEXTadd-delete (get_merchant_listings_all_data)add-delete (get_merchant_listings_all_data) This field will be emptyin the report; it enables you to use an open listings report to updateonline inventory.
merchant_listings_all_data__asin1TEXTasin1 (get_merchant_listings_all_data)asin1 (get_merchant_listings_all_data) This is not used. The field ispopulated with the product-id.
merchant_listings_all_data__asin2TEXTasin2 (get_merchant_listings_all_data)asin2 (get_merchant_listings_all_data) This is used for backwardscompatibility only.
merchant_listings_all_data__asin3TEXTasin3 (get_merchant_listings_all_data)asin3 (get_merchant_listings_all_data) This is used for backwardscompatibility only.
merchant_listings_all_data__bid_for_featured_placementTEXTbid-for-featured-placement (get_merchant_listings_all_data)bid-for-featured-placement (get_merchant_listings_all_data) This isused for backwards compatibility only.
merchant_listings_all_data__expedited_shippingTEXTexpedited-shipping (get_merchant_listings_all_data)expedited-shipping (get_merchant_listings_all_data) Second = listingsthat are available for second day shipping to U.S. domestic addressesNext = listings that are available for next day shipping to U.S.domestic addresses Same = listings that are available for same dayshipping to U.S. domestic addresses n = not offered
merchant_listings_all_data__fulfillment_channelTEXTfulfillment-channel (get_merchant_listings_all_data)fulfillment-channel (get_merchant_listings_all_data) This willindicate for FBA sellers if the listing is set for seller fulfilmentor fulfilment by Amazon.
merchant_listings_all_data__image_urlIMAGE_URLimage-url (get_merchant_listings_all_data)image-url (get_merchant_listings_all_data)
merchant_listings_all_data__item_conditionNUMERICitem-condition (get_merchant_listings_all_data)item-condition (get_merchant_listings_all_data) This is your conditioncode for the listing.1 = Used; Like New 2 = Used; Very Good 3 = Used;Good 4 = Used; Acceptable 5 = Collectible; Like New 6 = Collectible;Very Good 7 = Collectible; Good 8 = Collectible; Acceptable 10 =Refurbished 11 = New
merchant_listings_all_data__item_descriptionTEXTitem-description (get_merchant_listings_all_data)item-description (get_merchant_listings_all_data) This is used forbackwards compatibility only.
merchant_listings_all_data__item_is_marketplaceTEXTitem-is-marketplace (get_merchant_listings_all_data)item-is-marketplace (get_merchant_listings_all_data) This will alwaysbe y.
merchant_listings_all_data__item_nameTEXTitem-name (get_merchant_listings_all_data)item-name (get_merchant_listings_all_data) The title of the itemlisted. This will be populated with Amazon catalog data.
merchant_listings_all_data__item_noteTEXTitem-note (get_merchant_listings_all_data)item-note (get_merchant_listings_all_data) Your description of thelisting.
merchant_listings_all_data__listing_idTEXTlisting-id (get_merchant_listings_all_data)listing-id (get_merchant_listings_all_data) An identifier created byAmazon when you create a listing. Consists of 4 digits, a capitalletter, and 6 more digits.
merchant_listings_all_data__merchant_shipping_groupTEXTmerchant-shipping-group (get_merchant_listings_all_data)merchant-shipping-group (get_merchant_listings_all_data)
merchant_listings_all_data__open_dateDATEopen-date (get_merchant_listings_all_data)open-date (get_merchant_listings_all_data) The date the listing wascreated.
merchant_listings_all_data__pending_quantityTEXTpending-quantity (get_merchant_listings_all_data)pending-quantity (get_merchant_listings_all_data) This is the quantityof the item that is pending purchase at the time of the report.
merchant_listings_all_data__priceNUMERICprice (get_merchant_listings_all_data)price (get_merchant_listings_all_data) The price you are asking forthe product.
merchant_listings_all_data__product_idTEXTproduct-id (get_merchant_listings_all_data)product-id (get_merchant_listings_all_data) ASIN, ISBN, UPC, or EANfor the item
merchant_listings_all_data__product_id_typeNUMERICproduct-id-type (get_merchant_listings_all_data)product-id-type (get_merchant_listings_all_data) A numeric entry thatindicates if the product-id is an ASIN, ISBN, UPC, or EAN code/number.When uploading files in Standard Book format, this field value willdefault to 2 (ISBN) unless otherwise specified.1 = ASIN 2 = ISBN 3 =UPC 4 = EAN
merchant_listings_all_data__quantityTEXTquantity (get_merchant_listings_all_data)quantity (get_merchant_listings_all_data) The quantity of the productavailable for purchase.
merchant_listings_all_data__seller_skuTEXTseller-sku (get_merchant_listings_all_data)seller-sku (get_merchant_listings_all_data) Stock Keeping Units (SKUs)are unique blocks of letters and/or numbers that identify yourproducts. SKUs are assigned by you as the seller.
merchant_listings_all_data__statusTEXTstatus (get_merchant_listings_all_data)status (get_merchant_listings_all_data)
merchant_listings_all_data__will_ship_internationallyTEXTwill-ship-internationally (get_merchant_listings_all_data)will-ship-internationally (get_merchant_listings_all_data) 2 =listings that are available to customers outside the U.S.1 = listingsthat are available only to customers in the U.S.
merchant_listings_all_data__zshop_boldfaceTEXTzshop-boldface (get_merchant_listings_all_data)zshop-boldface (get_merchant_listings_all_data) This is used forbackwards compatibility only.
merchant_listings_all_data__zshop_browse_pathTEXTzshop-browse-path (get_merchant_listings_all_data)zshop-browse-path (get_merchant_listings_all_data) This is used forbackwards compatibility only.
merchant_listings_all_data__zshop_category1TEXTzshop-category1 (get_merchant_listings_all_data)zshop-category1 (get_merchant_listings_all_data) This is used forbackwards compatibility only.
merchant_listings_all_data__zshop_shipping_feeTEXTzshop-shipping-fee (get_merchant_listings_all_data)zshop-shipping-fee (get_merchant_listings_all_data) This is used forbackwards compatibility only.
merchant_listings_all_data__zshop_storefront_featureTEXTzshop-storefront-feature (get_merchant_listings_all_data)zshop-storefront-feature (get_merchant_listings_all_data) This is usedfor backwards compatibility only.

Amazon Seller Central (Amazon SP) get_merchant_listings_all_data_custom fields

The get_merchant_listings_all_data_custom report of the Amazon Seller Central (Amazon SP) connector includes 5 fields.

IDTypeNameDescription
merchant_listings_all_data_custom__asin1TEXTasin1 (get_merchant_listings_all_data_custom)asin1 (get_merchant_listings_all_data_custom) The ASIN the listing is matched to.
merchant_listings_all_data_custom__item_nameTEXTitem-name (get_merchant_listings_all_data_custom)item-name (get_merchant_listings_all_data_custom) The title of the item listed. This will be populated with Amazon catalog data.
merchant_listings_all_data_custom__maximum_seller_allowed_priceNUMERICmaximum-seller-allowed-price (get_merchant_listings_all_data_custom)maximum-seller-allowed-price (get_merchant_listings_all_data_custom) The maximum price at which automated pricing rules may set the listing's price.
merchant_listings_all_data_custom__minimum_seller_allowed_priceNUMERICminimum-seller-allowed-price (get_merchant_listings_all_data_custom)minimum-seller-allowed-price (get_merchant_listings_all_data_custom) The minimum price at which automated pricing rules may set the listing's price.
merchant_listings_all_data_custom__seller_skuTEXTseller-sku (get_merchant_listings_all_data_custom)seller-sku (get_merchant_listings_all_data_custom) Stock Keeping Units (SKUs) are unique blocks of letters and/or numbers that identify your products. SKUs are assigned by you as the seller.

Amazon Seller Central (Amazon SP) get_restock_inventory_recommendations_report fields

The get_restock_inventory_recommendations_report report of the Amazon Seller Central (Amazon SP) connector includes 29 fields.

IDTypeNameDescription
restock_inventory_recommendations_report__alertTEXTAlert (get_restock_inventory_recommendations_report)Alert (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__asinTEXTASIN (get_restock_inventory_recommendations_report)ASIN (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__availableNUMERICAvailable (get_restock_inventory_recommendations_report)Available (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__conditionTEXTCondition (get_restock_inventory_recommendations_report)Condition (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__countryCOUNTRYCountry (get_restock_inventory_recommendations_report)Country (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__currency_codeTEXTCurrency code (get_restock_inventory_recommendations_report)Currency code (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__customer_orderNUMERICCustomer Order (get_restock_inventory_recommendations_report)Customer Order (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__days_of_supply_at_amazon_fulfillment_networkTEXTDays of Supply at Amazon Fulfillment Network (get_restock_inventory_recommendations_report)Days of Supply at Amazon Fulfillment Network(get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fc_processingNUMERICFC Processing (get_restock_inventory_recommendations_report)FC Processing (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fc_transferNUMERICFC transfer (get_restock_inventory_recommendations_report)FC transfer (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fnskuTEXTFNSKU (get_restock_inventory_recommendations_report)FNSKU (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fulfilled_byTEXTFulfilled by (get_restock_inventory_recommendations_report)Fulfilled by (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__inboundNUMERICInbound (get_restock_inventory_recommendations_report)Inbound (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__merchant_skuTEXTMerchant SKU (get_restock_inventory_recommendations_report)Merchant SKU (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__priceNUMERICPrice (get_restock_inventory_recommendations_report)Price (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__product_nameTEXTProduct Name (get_restock_inventory_recommendations_report)Product Name (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__receivingNUMERICReceiving (get_restock_inventory_recommendations_report)Receiving (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__recommended_actionTEXTRecommended action (get_restock_inventory_recommendations_report)Recommended action (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__recommended_replenishment_qtyNUMERICRecommended replenishment qty (get_restock_inventory_recommendations_report)Recommended replenishment qty(get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__recommended_ship_dateDATERecommended ship date (get_restock_inventory_recommendations_report)Recommended ship date (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__sales_last_30_daysNUMERICSales last 30 days (get_restock_inventory_recommendations_report)Sales last 30 days (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__shippedNUMERICShipped (get_restock_inventory_recommendations_report)Shipped (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__supplierTEXTSupplier (get_restock_inventory_recommendations_report)Supplier (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__supplier_part_no.TEXTSupplier part no. (get_restock_inventory_recommendations_report)Supplier part no. (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__total_days_of_supply_(including_units_from_open_shipments)TEXTTotal Days of Supply (including units from open shipments) (get_restock_inventory_recommendations_report)Total Days of Supply (including units from open shipments)(get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__total_unitsNUMERICTotal Units (get_restock_inventory_recommendations_report)Total Units (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__unfulfillableNUMERICUnfulfillable (get_restock_inventory_recommendations_report)Unfulfillable (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__units_sold_last_30_daysNUMERICUnits Sold Last 30 Days (get_restock_inventory_recommendations_report)Units Sold Last 30 Days (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__workingNUMERICWorking (get_restock_inventory_recommendations_report)Working (get_restock_inventory_recommendations_report)

Amazon Seller Central (Amazon SP) get_sales_and_traffic_report_by_asin fields

The get_sales_and_traffic_report_by_asin report of the Amazon Seller Central (Amazon SP) connector includes 64 fields.

Amazon Seller Central (Amazon SP) get_sales_and_traffic_report_by_asin fields (sales_and_traffic_report_by_date__childasin to sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentage)

IDTypeNameDescription
sales_and_traffic_report_by_date__childasinTEXTchildAsin (get_sales_and_traffic_report)childAsin (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__parentasinTEXTparentAsin (get_sales_and_traffic_report)parentAsin (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitem_amountNUMERICsalesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitem_currencycodeTEXT(Deprecated) salesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)salesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitemb2b_amountNUMERIC(Deprecated) salesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)salesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitemb2b_currencycodeTEXT(Deprecated) salesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)salesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesellingprice_amountNUMERICsalesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report)salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesellingprice_currencycodeTEXT(Deprecated) salesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report)salesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesellingpriceb2b_amountNUMERIC(Deprecated) salesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report)salesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesellingpriceb2b_currencycodeTEXT(Deprecated) salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averageunitsperorderitemNUMERIC(Deprecated) salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report)salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averageunitsperorderitemb2bNUMERIC(Deprecated) salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_claimsamount_amountTEXT(Deprecated) salesByAsin-claimsAmount-amount (get_sales_and_traffic_report)salesByAsin-claimsAmount-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_claimsamount_currencycodeTEXT(Deprecated) salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report)salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_claimsgrantedTEXT(Deprecated) salesByAsin-claimsGranted (get_sales_and_traffic_report)salesByAsin-claimsGranted (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsales_amountNUMERICsalesByAsin-orderedProductSales-amount (get_sales_and_traffic_report)salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsales_currencycodeTEXTsalesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report)salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsalesb2b_amountNUMERICsalesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report)salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsalesb2b_currencycodeTEXTsalesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_ordersshippedNUMERIC(Deprecated) salesByAsin-ordersShipped (get_sales_and_traffic_report)salesByAsin-ordersShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_refundrateNUMERICsalesByAsin-refundRate (get_sales_and_traffic_report)salesByAsin-refundRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_shippedproductsales_amountNUMERICsalesByAsin-shippedProductSales-amount (get_sales_and_traffic_report)salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_shippedproductsales_currencycodeTEXT(Deprecated) salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report)salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_totalorderitemsNUMERICsalesByAsin-totalOrderItems (get_sales_and_traffic_report)salesByAsin-totalOrderItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_totalorderitemsb2bNUMERICsalesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report)salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsorderedNUMERICsalesByAsin-unitsOrdered (get_sales_and_traffic_report)salesByAsin-unitsOrdered (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsorderedb2bNUMERICsalesByAsin-unitsOrderedB2B (get_sales_and_traffic_report)salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsrefundedNUMERIC(Deprecated) salesByAsin-unitsRefunded (get_sales_and_traffic_report)salesByAsin-unitsRefunded (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsshippedNUMERICsalesByAsin-unitsShipped (get_sales_and_traffic_report)salesByAsin-unitsShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_averageoffercountNUMERIC(Deprecated) trafficByAsin-averageOfferCount (get_sales_and_traffic_report)trafficByAsin-averageOfferCount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_averageparentitemsNUMERICtrafficByAsin-averageParentItems (get_sales_and_traffic_report)trafficByAsin-averageParentItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewsNUMERICtrafficByAsin-browserPageViews (get_sales_and_traffic_report)trafficByAsin-browserPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewsb2bNUMERICtrafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report)trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewspercentageNUMERICtrafficByAsin-browserPageViewsPercentage (get_sales_and_traffic_report)trafficByAsin-browserPageViewsPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewspercentageb2bNUMERICtrafficByAsin-browserPageViewsPercentageB2B (get_sales_and_traffic_report)trafficByAsin-browserPageViewsPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionpercentageNUMERICtrafficByAsin-browserSessionPercentage (get_sales_and_traffic_report)trafficByAsin-browserSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionpercentageb2bNUMERICtrafficByAsin-browserSessionPercentageB2B (get_sales_and_traffic_report)trafficByAsin-browserSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionsNUMERICtrafficByAsin-browserSessions (get_sales_and_traffic_report)trafficByAsin-browserSessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionsb2bNUMERICtrafficByAsin-browserSessionsB2B (get_sales_and_traffic_report)trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentageNUMERICtrafficByAsin-buyBoxPercentage (get_sales_and_traffic_report)trafficByAsin-buyBoxPercentage (get_sales_and_traffic_report)

Amazon Seller Central (Amazon SP) get_sales_and_traffic_report_by_asin fields (sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentageb2b to sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentageb2b)

IDTypeNameDescription
sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentageb2bNUMERICtrafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report)trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_feedbackreceivedTEXT(Deprecated) trafficByAsin-feedbackReceived (get_sales_and_traffic_report)trafficByAsin-feedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewsNUMERICtrafficByAsin-mobileAppPageViews (get_sales_and_traffic_report)trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewsb2bNUMERICtrafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report)trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewspercentageNUMERICtrafficByAsin-mobileAppPageViewsPercentage (get_sales_and_traffic_report)trafficByAsin-mobileAppPageViewsPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewspercentageb2bNUMERICtrafficByAsin-mobileAppPageViewsPercentageB2B (get_sales_and_traffic_report)trafficByAsin-mobileAppPageViewsPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionpercentageNUMERICtrafficByAsin-mobileAppSessionPercentage (get_sales_and_traffic_report)trafficByAsin-mobileAppSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionpercentageb2bNUMERICtrafficByAsin-mobileAppSessionPercentageB2B (get_sales_and_traffic_report)trafficByAsin-mobileAppSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionsNUMERICtrafficByAsin-mobileAppSessions (get_sales_and_traffic_report)trafficByAsin-mobileAppSessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionsb2bNUMERICtrafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report)trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_negativefeedbackreceivedTEXT(Deprecated) trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report)trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_orderitemsessionpercentageNUMERICtrafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report)trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_orderitemsessionpercentageb2bNUMERIC(Deprecated) trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report)trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewsNUMERICtrafficByAsin-pageViews (get_sales_and_traffic_report)trafficByAsin-pageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewsb2bNUMERICtrafficByAsin-pageViewsB2B (get_sales_and_traffic_report)trafficByAsin-pageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewspercentageNUMERICtrafficByAsin-pageViewsPercentage (get_sales_and_traffic_report)trafficByAsin-pageViewsPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewspercentageb2bNUMERICtrafficByAsin-pageViewsPercentageB2B (get_sales_and_traffic_report)trafficByAsin-pageViewsPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_receivednegativefeedbackrateTEXTtrafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report)trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionpercentageNUMERICtrafficByAsin-sessionPercentage (get_sales_and_traffic_report)trafficByAsin-sessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionpercentageb2bNUMERICtrafficByAsin-sessionPercentageB2B (get_sales_and_traffic_report)trafficByAsin-sessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionsNUMERICtrafficByAsin-sessions (get_sales_and_traffic_report)trafficByAsin-sessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionsb2bNUMERICtrafficByAsin-sessionsB2B (get_sales_and_traffic_report)trafficByAsin-sessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentageNUMERICtrafficByAsin-unitSessionPercentage (get_sales_and_traffic_report)trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentageb2bNUMERICtrafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report)trafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report)

Amazon Seller Central (Amazon SP) get_sales_and_traffic_report_by_date fields

The get_sales_and_traffic_report_by_date report of the Amazon Seller Central (Amazon SP) connector includes 51 fields.

Amazon Seller Central (Amazon SP) get_sales_and_traffic_report_by_date fields (sales_and_traffic_report_by_date__date to sales_and_traffic_report_by_date__trafficbydate_mobileappsessions)

IDTypeNameDescription
sales_and_traffic_report_by_date__dateDATEdate (get_sales_and_traffic_report)date (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_amountNUMERICsalesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_currencycodeTEXTsalesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_amountNUMERICsalesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_currencycodeTEXTsalesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingprice_amountNUMERICsalesByDate-averageSellingPrice-amount (get_sales_and_traffic_report)salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingprice_currencycodeTEXTsalesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report)salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_amountNUMERICsalesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report)salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_currencycodeTEXTsalesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitemNUMERICsalesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report)salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitemb2bNUMERICsalesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_claimsamount_amountTEXTsalesByDate-claimsAmount-amount (get_sales_and_traffic_report)salesByDate-claimsAmount-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_claimsamount_currencycodeTEXTsalesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report)salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_claimsgrantedTEXTsalesByDate-claimsGranted (get_sales_and_traffic_report)salesByDate-claimsGranted (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsales_amountNUMERICsalesByDate-orderedProductSales-amount (get_sales_and_traffic_report)salesByDate-orderedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsales_currencycodeTEXTsalesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report)salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_amountNUMERICsalesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report)salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_currencycodeTEXTsalesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_ordersshippedNUMERICsalesByDate-ordersShipped (get_sales_and_traffic_report)salesByDate-ordersShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_refundrateNUMERICsalesByDate-refundRate (get_sales_and_traffic_report)salesByDate-refundRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_shippedproductsales_amountNUMERICsalesByDate-shippedProductSales-amount (get_sales_and_traffic_report)salesByDate-shippedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_shippedproductsales_currencycodeTEXTsalesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report)salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_totalorderitemsNUMERICsalesByDate-totalOrderItems (get_sales_and_traffic_report)salesByDate-totalOrderItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_totalorderitemsb2bNUMERICsalesByDate-totalOrderItemsB2B (get_sales_and_traffic_report)salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsorderedNUMERICsalesByDate-unitsOrdered (get_sales_and_traffic_report)salesByDate-unitsOrdered (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsorderedb2bNUMERICsalesByDate-unitsOrderedB2B (get_sales_and_traffic_report)salesByDate-unitsOrderedB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsrefundedNUMERICsalesByDate-unitsRefunded (get_sales_and_traffic_report)salesByDate-unitsRefunded (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsshippedNUMERICsalesByDate-unitsShipped (get_sales_and_traffic_report)salesByDate-unitsShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_averageoffercountNUMERICtrafficByDate-averageOfferCount (get_sales_and_traffic_report)trafficByDate-averageOfferCount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_averageparentitemsNUMERICtrafficByDate-averageParentItems (get_sales_and_traffic_report)trafficByDate-averageParentItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browserpageviewsNUMERICtrafficByDate-browserPageViews (get_sales_and_traffic_report)trafficByDate-browserPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browserpageviewsb2bNUMERICtrafficByDate-browserPageViewsB2B (get_sales_and_traffic_report)trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browsersessionsNUMERICtrafficByDate-browserSessions (get_sales_and_traffic_report)trafficByDate-browserSessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browsersessionsb2bNUMERICtrafficByDate-browserSessionsB2B (get_sales_and_traffic_report)trafficByDate-browserSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_buyboxpercentageNUMERICtrafficByDate-buyBoxPercentage (get_sales_and_traffic_report)trafficByDate-buyBoxPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_buyboxpercentageb2bNUMERICtrafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report)trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_feedbackreceivedTEXTtrafficByDate-feedbackReceived (get_sales_and_traffic_report)trafficByDate-feedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_mobileapppageviewsNUMERICtrafficByDate-mobileAppPageViews (get_sales_and_traffic_report)trafficByDate-mobileAppPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_mobileapppageviewsb2bNUMERICtrafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report)trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_mobileappsessionsNUMERICtrafficByDate-mobileAppSessions (get_sales_and_traffic_report)trafficByDate-mobileAppSessions (get_sales_and_traffic_report)

Amazon Seller Central (Amazon SP) get_sales_and_traffic_report_by_date fields (sales_and_traffic_report_by_date__trafficbydate_mobileappsessionsb2b to sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentageb2b)

IDTypeNameDescription
sales_and_traffic_report_by_date__trafficbydate_mobileappsessionsb2bNUMERICtrafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report)trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_negativefeedbackreceivedTEXTtrafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report)trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentageNUMERICtrafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report)trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentageb2bNUMERICtrafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report)trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_pageviewsNUMERICtrafficByDate-pageViews (get_sales_and_traffic_report)trafficByDate-pageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_pageviewsb2bNUMERICtrafficByDate-pageViewsB2B (get_sales_and_traffic_report)trafficByDate-pageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_receivednegativefeedbackrateTEXTtrafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report)trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_sessionsNUMERICtrafficByDate-sessions (get_sales_and_traffic_report)trafficByDate-sessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_sessionsb2bNUMERICtrafficByDate-sessionsB2B (get_sales_and_traffic_report)trafficByDate-sessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentageNUMERICtrafficByDate-unitSessionPercentage (get_sales_and_traffic_report)trafficByDate-unitSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentageb2bNUMERICtrafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report)trafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report)

Amazon Seller Central (Amazon SP) get_v2_seller_performance_report fields

The get_v2_seller_performance_report report of the Amazon Seller Central (Amazon SP) connector includes 160 fields.

Amazon Seller Central (Amazon SP) get_v2_seller_performance_report fields (v2_seller_performance_report__account_status to v2_seller_performance_report__lateshipmentrate_reportingdaterange_reportingdatefrom)

IDTypeNameDescription
v2_seller_performance_report__account_statusTEXTaccount-status (get_v2_seller_performance_report)account-status (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_ahrscoreNUMERICaccountHealthRating-ahrScore (get_v2_seller_performance_report)accountHealthRating-ahrScore (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_ahrstatusTEXTaccountHealthRating-ahrStatus (get_v2_seller_performance_report)accountHealthRating-ahrStatus (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_reportingdaterange_reportingdatefromTEXTaccountHealthRating-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)accountHealthRating-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_reportingdaterange_reportingdatetoTEXTaccountHealthRating-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)accountHealthRating-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_defectscountNUMERICcustomerProductReviewsPolicyViolations-defectsCount (get_v2_seller_performance_report)customerProductReviewsPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_reportingdaterange_reportingdatefromTEXTcustomerProductReviewsPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)customerProductReviewsPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_reportingdaterange_reportingdatetoTEXTcustomerProductReviewsPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)customerProductReviewsPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_statusTEXTcustomerProductReviewsPolicyViolations-status (get_v2_seller_performance_report)customerProductReviewsPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_targetconditionTEXTcustomerProductReviewsPolicyViolations-targetCondition (get_v2_seller_performance_report)customerProductReviewsPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_targetvalueNUMERICcustomerProductReviewsPolicyViolations-targetValue (get_v2_seller_performance_report)customerProductReviewsPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_defectscountNUMERICdocumentRequests-defectsCount (get_v2_seller_performance_report)documentRequests-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_reportingdaterange_reportingdatefromTEXTdocumentRequests-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)documentRequests-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_reportingdaterange_reportingdatetoTEXTdocumentRequests-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)documentRequests-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_statusTEXTdocumentRequests-status (get_v2_seller_performance_report)documentRequests-status (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_targetconditionTEXTdocumentRequests-targetCondition (get_v2_seller_performance_report)documentRequests-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_targetvalueNUMERICdocumentRequests-targetValue (get_v2_seller_performance_report)documentRequests-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_defectscountNUMERICfoodAndProductSafetyIssues-defectsCount (get_v2_seller_performance_report)foodAndProductSafetyIssues-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_reportingdaterange_reportingdatefromTEXTfoodAndProductSafetyIssues-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)foodAndProductSafetyIssues-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_reportingdaterange_reportingdatetoTEXTfoodAndProductSafetyIssues-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)foodAndProductSafetyIssues-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_statusTEXTfoodAndProductSafetyIssues-status (get_v2_seller_performance_report)foodAndProductSafetyIssues-status (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_targetconditionTEXTfoodAndProductSafetyIssues-targetCondition (get_v2_seller_performance_report)foodAndProductSafetyIssues-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_targetvalueNUMERICfoodAndProductSafetyIssues-targetValue (get_v2_seller_performance_report)foodAndProductSafetyIssues-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_invoicedefect_countNUMERICinvoiceDefectRate-invoiceDefect-count (get_v2_seller_performance_report)invoiceDefectRate-invoiceDefect-count (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_invoicedefect_statusTEXTinvoiceDefectRate-invoiceDefect-status (get_v2_seller_performance_report)invoiceDefectRate-invoiceDefect-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_lateinvoice_countNUMERICinvoiceDefectRate-lateInvoice-count (get_v2_seller_performance_report)invoiceDefectRate-lateInvoice-count (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_lateinvoice_statusTEXTinvoiceDefectRate-lateInvoice-status (get_v2_seller_performance_report)invoiceDefectRate-lateInvoice-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_missinginvoice_countNUMERICinvoiceDefectRate-missingInvoice-count (get_v2_seller_performance_report)invoiceDefectRate-missingInvoice-count (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_missinginvoice_statusTEXTinvoiceDefectRate-missingInvoice-status (get_v2_seller_performance_report)invoiceDefectRate-missingInvoice-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_ordercountNUMERICinvoiceDefectRate-orderCount (get_v2_seller_performance_report)invoiceDefectRate-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_rateNUMERICinvoiceDefectRate-rate (get_v2_seller_performance_report)invoiceDefectRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_reportingdaterange_reportingdatefromTEXTinvoiceDefectRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)invoiceDefectRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_reportingdaterange_reportingdatetoTEXTinvoiceDefectRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)invoiceDefectRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_statusTEXTinvoiceDefectRate-status (get_v2_seller_performance_report)invoiceDefectRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_targetconditionTEXTinvoiceDefectRate-targetCondition (get_v2_seller_performance_report)invoiceDefectRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_targetvalueNUMERICinvoiceDefectRate-targetValue (get_v2_seller_performance_report)invoiceDefectRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_lateshipmentcountNUMERIClateShipmentRate-lateShipmentCount (get_v2_seller_performance_report)lateShipmentRate-lateShipmentCount (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_ordercountNUMERIClateShipmentRate-orderCount (get_v2_seller_performance_report)lateShipmentRate-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_rateNUMERIClateShipmentRate-rate (get_v2_seller_performance_report)lateShipmentRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_reportingdaterange_reportingdatefromTEXTlateShipmentRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)lateShipmentRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)

Amazon Seller Central (Amazon SP) get_v2_seller_performance_report fields (v2_seller_performance_report__lateshipmentrate_reportingdaterange_reportingdateto to v2_seller_performance_report__orderdefectrate_mfn_fulfillmenttype)

IDTypeNameDescription
v2_seller_performance_report__lateshipmentrate_reportingdaterange_reportingdatetoTEXTlateShipmentRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)lateShipmentRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_statusTEXTlateShipmentRate-status (get_v2_seller_performance_report)lateShipmentRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_targetconditionTEXTlateShipmentRate-targetCondition (get_v2_seller_performance_report)lateShipmentRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_targetvalueNUMERIClateShipmentRate-targetValue (get_v2_seller_performance_report)lateShipmentRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_defectscountNUMERIClistingPolicyViolations-defectsCount (get_v2_seller_performance_report)listingPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_reportingdaterange_reportingdatefromTEXTlistingPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)listingPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_reportingdaterange_reportingdatetoTEXTlistingPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)listingPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_statusTEXTlistingPolicyViolations-status (get_v2_seller_performance_report)listingPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_targetconditionTEXTlistingPolicyViolations-targetCondition (get_v2_seller_performance_report)listingPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_targetvalueNUMERIClistingPolicyViolations-targetValue (get_v2_seller_performance_report)listingPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__marketplaceidTEXTmarketplaceId (get_v2_seller_performance_report)marketplaceId (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_ontimedeliverycountNUMERIConTimeDeliveryRate-onTimeDeliveryCount (get_v2_seller_performance_report)onTimeDeliveryRate-onTimeDeliveryCount (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_rateNUMERIConTimeDeliveryRate-rate (get_v2_seller_performance_report)onTimeDeliveryRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_reportingdaterange_reportingdatefromTEXTonTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)onTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_reportingdaterange_reportingdatetoTEXTonTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)onTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_shipmentcountwithvalidtrackingNUMERIConTimeDeliveryRate-shipmentCountWithValidTracking (get_v2_seller_performance_report)onTimeDeliveryRate-shipmentCountWithValidTracking (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_statusTEXTonTimeDeliveryRate-status (get_v2_seller_performance_report)onTimeDeliveryRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_targetconditionTEXTonTimeDeliveryRate-targetCondition (get_v2_seller_performance_report)onTimeDeliveryRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_targetvalueNUMERIConTimeDeliveryRate-targetValue (get_v2_seller_performance_report)onTimeDeliveryRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_chargebacks_countNUMERICorderDefectRate-afn-chargebacks-count (get_v2_seller_performance_report)orderDefectRate-afn-chargebacks-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_chargebacks_statusTEXTorderDefectRate-afn-chargebacks-status (get_v2_seller_performance_report)orderDefectRate-afn-chargebacks-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_claims_countNUMERICorderDefectRate-afn-claims-count (get_v2_seller_performance_report)orderDefectRate-afn-claims-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_claims_statusTEXTorderDefectRate-afn-claims-status (get_v2_seller_performance_report)orderDefectRate-afn-claims-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_fulfillmenttypeTEXTorderDefectRate-afn-fulfillmentType (get_v2_seller_performance_report)orderDefectRate-afn-fulfillmentType (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_negativefeedback_countNUMERICorderDefectRate-afn-negativeFeedback-count (get_v2_seller_performance_report)orderDefectRate-afn-negativeFeedback-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_negativefeedback_statusTEXTorderDefectRate-afn-negativeFeedback-status (get_v2_seller_performance_report)orderDefectRate-afn-negativeFeedback-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_ordercountNUMERICorderDefectRate-afn-orderCount (get_v2_seller_performance_report)orderDefectRate-afn-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_orderwithdefects_countNUMERICorderDefectRate-afn-orderWithDefects-count (get_v2_seller_performance_report)orderDefectRate-afn-orderWithDefects-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_orderwithdefects_statusTEXTorderDefectRate-afn-orderWithDefects-status (get_v2_seller_performance_report)orderDefectRate-afn-orderWithDefects-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_rateNUMERICorderDefectRate-afn-rate (get_v2_seller_performance_report)orderDefectRate-afn-rate (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_reportingdaterange_reportingdatefromTEXTorderDefectRate-afn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)orderDefectRate-afn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_reportingdaterange_reportingdatetoTEXTorderDefectRate-afn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)orderDefectRate-afn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_statusTEXTorderDefectRate-afn-status (get_v2_seller_performance_report)orderDefectRate-afn-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_targetconditionTEXTorderDefectRate-afn-targetCondition (get_v2_seller_performance_report)orderDefectRate-afn-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_targetvalueNUMERICorderDefectRate-afn-targetValue (get_v2_seller_performance_report)orderDefectRate-afn-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_chargebacks_countNUMERICorderDefectRate-mfn-chargebacks-count (get_v2_seller_performance_report)orderDefectRate-mfn-chargebacks-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_chargebacks_statusTEXTorderDefectRate-mfn-chargebacks-status (get_v2_seller_performance_report)orderDefectRate-mfn-chargebacks-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_claims_countNUMERICorderDefectRate-mfn-claims-count (get_v2_seller_performance_report)orderDefectRate-mfn-claims-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_claims_statusTEXTorderDefectRate-mfn-claims-status (get_v2_seller_performance_report)orderDefectRate-mfn-claims-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_fulfillmenttypeTEXTorderDefectRate-mfn-fulfillmentType (get_v2_seller_performance_report)orderDefectRate-mfn-fulfillmentType (get_v2_seller_performance_report)

Amazon Seller Central (Amazon SP) get_v2_seller_performance_report fields (v2_seller_performance_report__orderdefectrate_mfn_negativefeedback_count to v2_seller_performance_report__productconditioncustomercomplaints_targetvalue)

IDTypeNameDescription
v2_seller_performance_report__orderdefectrate_mfn_negativefeedback_countNUMERICorderDefectRate-mfn-negativeFeedback-count (get_v2_seller_performance_report)orderDefectRate-mfn-negativeFeedback-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_negativefeedback_statusTEXTorderDefectRate-mfn-negativeFeedback-status (get_v2_seller_performance_report)orderDefectRate-mfn-negativeFeedback-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_ordercountNUMERICorderDefectRate-mfn-orderCount (get_v2_seller_performance_report)orderDefectRate-mfn-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_orderwithdefects_countNUMERICorderDefectRate-mfn-orderWithDefects-count (get_v2_seller_performance_report)orderDefectRate-mfn-orderWithDefects-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_orderwithdefects_statusTEXTorderDefectRate-mfn-orderWithDefects-status (get_v2_seller_performance_report)orderDefectRate-mfn-orderWithDefects-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_rateNUMERICorderDefectRate-mfn-rate (get_v2_seller_performance_report)orderDefectRate-mfn-rate (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_reportingdaterange_reportingdatefromTEXTorderDefectRate-mfn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)orderDefectRate-mfn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_reportingdaterange_reportingdatetoTEXTorderDefectRate-mfn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)orderDefectRate-mfn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_statusTEXTorderDefectRate-mfn-status (get_v2_seller_performance_report)orderDefectRate-mfn-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_targetconditionTEXTorderDefectRate-mfn-targetCondition (get_v2_seller_performance_report)orderDefectRate-mfn-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_targetvalueNUMERICorderDefectRate-mfn-targetValue (get_v2_seller_performance_report)orderDefectRate-mfn-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_defectscountNUMERICotherPolicyViolations-defectsCount (get_v2_seller_performance_report)otherPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_reportingdaterange_reportingdatefromTEXTotherPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)otherPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_reportingdaterange_reportingdatetoTEXTotherPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)otherPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_statusTEXTotherPolicyViolations-status (get_v2_seller_performance_report)otherPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_targetconditionTEXTotherPolicyViolations-targetCondition (get_v2_seller_performance_report)otherPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_targetvalueNUMERICotherPolicyViolations-targetValue (get_v2_seller_performance_report)otherPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__policyviolationwarnings_reportingdaterange_reportingdatefromTEXTpolicyViolationWarnings-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)policyViolationWarnings-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__policyviolationwarnings_reportingdaterange_reportingdatetoTEXTpolicyViolationWarnings-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)policyViolationWarnings-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__policyviolationwarnings_warningscountNUMERICpolicyViolationWarnings-warningsCount (get_v2_seller_performance_report)policyViolationWarnings-warningsCount (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_cancellationcountNUMERICpreFulfillmentCancellationRate-cancellationCount (get_v2_seller_performance_report)preFulfillmentCancellationRate-cancellationCount (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_ordercountNUMERICpreFulfillmentCancellationRate-orderCount (get_v2_seller_performance_report)preFulfillmentCancellationRate-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_rateNUMERICpreFulfillmentCancellationRate-rate (get_v2_seller_performance_report)preFulfillmentCancellationRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_reportingdaterange_reportingdatefromTEXTpreFulfillmentCancellationRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)preFulfillmentCancellationRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_reportingdaterange_reportingdatetoTEXTpreFulfillmentCancellationRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)preFulfillmentCancellationRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_statusTEXTpreFulfillmentCancellationRate-status (get_v2_seller_performance_report)preFulfillmentCancellationRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_targetconditionTEXTpreFulfillmentCancellationRate-targetCondition (get_v2_seller_performance_report)preFulfillmentCancellationRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_targetvalueNUMERICpreFulfillmentCancellationRate-targetValue (get_v2_seller_performance_report)preFulfillmentCancellationRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_defectscountNUMERICproductAuthenticityCustomerComplaints-defectsCount (get_v2_seller_performance_report)productAuthenticityCustomerComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_reportingdaterange_reportingdatefromTEXTproductAuthenticityCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)productAuthenticityCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_reportingdaterange_reportingdatetoTEXTproductAuthenticityCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)productAuthenticityCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_statusTEXTproductAuthenticityCustomerComplaints-status (get_v2_seller_performance_report)productAuthenticityCustomerComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_targetconditionTEXTproductAuthenticityCustomerComplaints-targetCondition (get_v2_seller_performance_report)productAuthenticityCustomerComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_targetvalueNUMERICproductAuthenticityCustomerComplaints-targetValue (get_v2_seller_performance_report)productAuthenticityCustomerComplaints-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_defectscountNUMERICproductConditionCustomerComplaints-defectsCount (get_v2_seller_performance_report)productConditionCustomerComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_reportingdaterange_reportingdatefromTEXTproductConditionCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)productConditionCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_reportingdaterange_reportingdatetoTEXTproductConditionCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)productConditionCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_statusTEXTproductConditionCustomerComplaints-status (get_v2_seller_performance_report)productConditionCustomerComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_targetconditionTEXTproductConditionCustomerComplaints-targetCondition (get_v2_seller_performance_report)productConditionCustomerComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_targetvalueNUMERICproductConditionCustomerComplaints-targetValue (get_v2_seller_performance_report)productConditionCustomerComplaints-targetValue (get_v2_seller_performance_report)

Amazon Seller Central (Amazon SP) get_v2_seller_performance_report fields (v2_seller_performance_report__productsafetycustomercomplaints_defectscount to v2_seller_performance_report__validtrackingrate_validtrackingcount)

IDTypeNameDescription
v2_seller_performance_report__productsafetycustomercomplaints_defectscountNUMERICproductSafetyCustomerComplaints-defectsCount (get_v2_seller_performance_report)productSafetyCustomerComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_reportingdaterange_reportingdatefromTEXTproductSafetyCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)productSafetyCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_reportingdaterange_reportingdatetoTEXTproductSafetyCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)productSafetyCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_statusTEXTproductSafetyCustomerComplaints-status (get_v2_seller_performance_report)productSafetyCustomerComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_targetconditionTEXTproductSafetyCustomerComplaints-targetCondition (get_v2_seller_performance_report)productSafetyCustomerComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_targetvalueNUMERICproductSafetyCustomerComplaints-targetValue (get_v2_seller_performance_report)productSafetyCustomerComplaints-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_defectscountNUMERICreceivedIntellectualPropertyComplaints-defectsCount (get_v2_seller_performance_report)receivedIntellectualPropertyComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_reportingdaterange_reportingdatefromTEXTreceivedIntellectualPropertyComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)receivedIntellectualPropertyComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_reportingdaterange_reportingdatetoTEXTreceivedIntellectualPropertyComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)receivedIntellectualPropertyComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_statusTEXTreceivedIntellectualPropertyComplaints-status (get_v2_seller_performance_report)receivedIntellectualPropertyComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_targetconditionTEXTreceivedIntellectualPropertyComplaints-targetCondition (get_v2_seller_performance_report)receivedIntellectualPropertyComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_targetvalueNUMERICreceivedIntellectualPropertyComplaints-targetValue (get_v2_seller_performance_report)receivedIntellectualPropertyComplaints-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_defectscountNUMERICrestrictedProductPolicyViolations-defectsCount (get_v2_seller_performance_report)restrictedProductPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_reportingdaterange_reportingdatefromTEXTrestrictedProductPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)restrictedProductPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_reportingdaterange_reportingdatetoTEXTrestrictedProductPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)restrictedProductPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_statusTEXTrestrictedProductPolicyViolations-status (get_v2_seller_performance_report)restrictedProductPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_targetconditionTEXTrestrictedProductPolicyViolations-targetCondition (get_v2_seller_performance_report)restrictedProductPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_targetvalueNUMERICrestrictedProductPolicyViolations-targetValue (get_v2_seller_performance_report)restrictedProductPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_defectscountNUMERICsuspectedIntellectualPropertyViolations-defectsCount (get_v2_seller_performance_report)suspectedIntellectualPropertyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_reportingdaterange_reportingdatefromTEXTsuspectedIntellectualPropertyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)suspectedIntellectualPropertyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_reportingdaterange_reportingdatetoTEXTsuspectedIntellectualPropertyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)suspectedIntellectualPropertyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_statusTEXTsuspectedIntellectualPropertyViolations-status (get_v2_seller_performance_report)suspectedIntellectualPropertyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_targetconditionTEXTsuspectedIntellectualPropertyViolations-targetCondition (get_v2_seller_performance_report)suspectedIntellectualPropertyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_targetvalueNUMERICsuspectedIntellectualPropertyViolations-targetValue (get_v2_seller_performance_report)suspectedIntellectualPropertyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_rateNUMERICunitOnTimeDeliveryRate-rate (get_v2_seller_performance_report)unitOnTimeDeliveryRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_reportingdaterange_reportingdatefromTEXTunitOnTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)unitOnTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_reportingdaterange_reportingdatetoTEXTunitOnTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)unitOnTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_statusTEXTunitOnTimeDeliveryRate-status (get_v2_seller_performance_report)unitOnTimeDeliveryRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_targetconditionTEXTunitOnTimeDeliveryRate-targetCondition (get_v2_seller_performance_report)unitOnTimeDeliveryRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_targetvalueNUMERICunitOnTimeDeliveryRate-targetValue (get_v2_seller_performance_report)unitOnTimeDeliveryRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_totalunitcountNUMERICunitOnTimeDeliveryRate-totalUnitCount (get_v2_seller_performance_report)unitOnTimeDeliveryRate-totalUnitCount (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_unitontimedeliverycountNUMERICunitOnTimeDeliveryRate-unitOnTimeDeliveryCount (get_v2_seller_performance_report)unitOnTimeDeliveryRate-unitOnTimeDeliveryCount (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_rateNUMERICvalidTrackingRate-rate (get_v2_seller_performance_report)validTrackingRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_reportingdaterange_reportingdatefromTEXTvalidTrackingRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)validTrackingRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_reportingdaterange_reportingdatetoTEXTvalidTrackingRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)validTrackingRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_shipmentcountNUMERICvalidTrackingRate-shipmentCount (get_v2_seller_performance_report)validTrackingRate-shipmentCount (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_statusTEXTvalidTrackingRate-status (get_v2_seller_performance_report)validTrackingRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_targetconditionTEXTvalidTrackingRate-targetCondition (get_v2_seller_performance_report)validTrackingRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_targetvalueNUMERICvalidTrackingRate-targetValue (get_v2_seller_performance_report)validTrackingRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_validtrackingcountNUMERICvalidTrackingRate-validTrackingCount (get_v2_seller_performance_report)validTrackingRate-validTrackingCount (get_v2_seller_performance_report)

Amazon Seller Central (Amazon SP) get_v2_settlement_report_data_flat_file_v2 fields

The get_v2_settlement_report_data_flat_file_v2 report of the Amazon Seller Central (Amazon SP) connector includes 26 fields.

IDTypeNameDescription
v2_settlement_report_data_flat_file_v2__adjustment_idTEXTadjustment-id (get_v2_settlement_report_data_flat_file_v2)adjustment-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__amountNUMERICamount (get_v2_settlement_report_data_flat_file_v2)amount (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__amount_descriptionTEXTamount-description (get_v2_settlement_report_data_flat_file_v2)amount-description (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__amount_typeTEXTamount-type (get_v2_settlement_report_data_flat_file_v2)amount-type (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__currencyTEXTcurrency (get_v2_settlement_report_data_flat_file_v2)currency (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__deposit_dateDATEdeposit-date (get_v2_settlement_report_data_flat_file_v2)deposit-date (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__fulfillment_idTEXTfulfillment-id (get_v2_settlement_report_data_flat_file_v2)fulfillment-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__marketplace_nameTEXTmarketplace-name (get_v2_settlement_report_data_flat_file_v2)marketplace-name (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__merchant_adjustment_item_idTEXTmerchant-adjustment-item-id (get_v2_settlement_report_data_flat_file_v2)merchant-adjustment-item-id(get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__merchant_order_idTEXTmerchant-order-id (get_v2_settlement_report_data_flat_file_v2)merchant-order-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__merchant_order_item_idTEXTmerchant-order-item-id (get_v2_settlement_report_data_flat_file_v2)merchant-order-item-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__order_idTEXTorder-id (get_v2_settlement_report_data_flat_file_v2)order-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__order_item_codeTEXTorder-item-code (get_v2_settlement_report_data_flat_file_v2)order-item-code (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__posted_dateDATEposted-date (get_v2_settlement_report_data_flat_file_v2)posted-date (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__posted_date_timeTEXTposted-date-time (get_v2_settlement_report_data_flat_file_v2)posted-date-time (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__promotion_idTEXTpromotion-id (get_v2_settlement_report_data_flat_file_v2)promotion-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__quantity_purchasedNUMERICquantity-purchased (get_v2_settlement_report_data_flat_file_v2)quantity-purchased (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__settlement_end_dateDATEsettlement-end-date (get_v2_settlement_report_data_flat_file_v2)settlement-end-date (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__settlement_idTEXTsettlement-id (get_v2_settlement_report_data_flat_file_v2)settlement-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__settlement_start_dateDATEsettlement-start-date (get_v2_settlement_report_data_flat_file_v2)settlement-start-date (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__shipment_idTEXTshipment-id (get_v2_settlement_report_data_flat_file_v2)shipment-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__skuTEXTsku (get_v2_settlement_report_data_flat_file_v2)sku (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__total_amountNUMERICtotal-amount (get_v2_settlement_report_data_flat_file_v2)total-amount (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__transaction_release_dateDATEtransaction-release-date (get_v2_settlement_report_data_flat_file_v2)transaction-release-date (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__transaction_statusTEXTtransaction-status (get_v2_settlement_report_data_flat_file_v2)transaction-status (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__transaction_typeTEXTtransaction-type (get_v2_settlement_report_data_flat_file_v2)transaction-type (get_v2_settlement_report_data_flat_file_v2)

Amazon Seller Central (Amazon SP) get_vat_transaction_data fields

The get_vat_transaction_data report of the Amazon Seller Central (Amazon SP) connector includes 95 fields.

Amazon Seller Central (Amazon SP) get_vat_transaction_data fields (vat_transaction_data__activity_period to vat_transaction_data__promo_price_of_items_vat_amt)

IDTypeNameDescription
vat_transaction_data__activity_periodDATEACTIVITY_PERIOD (get_vat_transaction_data)ACTIVITY_PERIOD (get_vat_transaction_data)
vat_transaction_data__activity_transaction_idTEXTACTIVITY_TRANSACTION_ID (get_vat_transaction_data)ACTIVITY_TRANSACTION_ID (get_vat_transaction_data)
vat_transaction_data__arrival_addressTEXTARRIVAL_ADDRESS (get_vat_transaction_data)ARRIVAL_ADDRESS (get_vat_transaction_data)
vat_transaction_data__arrival_cityCITYARRIVAL_CITY (get_vat_transaction_data)ARRIVAL_CITY (get_vat_transaction_data)
vat_transaction_data__arrival_countryCOUNTRYARRIVAL_COUNTRY (get_vat_transaction_data)ARRIVAL_COUNTRY (get_vat_transaction_data)
vat_transaction_data__arrival_post_codeTEXTARRIVAL_POST_CODE (get_vat_transaction_data)ARRIVAL_POST_CODE (get_vat_transaction_data)
vat_transaction_data__asinTEXTASIN (get_vat_transaction_data)ASIN (get_vat_transaction_data)
vat_transaction_data__buyer_nameTEXTBUYER_NAME (get_vat_transaction_data)BUYER_NAME (get_vat_transaction_data)
vat_transaction_data__buyer_vat_numberTEXTBUYER_VAT_NUMBER (get_vat_transaction_data)BUYER_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__buyer_vat_number_countryCOUNTRYBUYER_VAT_NUMBER_COUNTRY (get_vat_transaction_data)BUYER_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__commodity_codeTEXTCOMMODITY_CODE (get_vat_transaction_data)COMMODITY_CODE (get_vat_transaction_data)
vat_transaction_data__commodity_code_supplementary_unitTEXTCOMMODITY_CODE_SUPPLEMENTARY_UNIT (get_vat_transaction_data)COMMODITY_CODE_SUPPLEMENTARY_UNIT (get_vat_transaction_data)
vat_transaction_data__cost_price_of_itemsNUMERICCOST_PRICE_OF_ITEMS (get_vat_transaction_data)COST_PRICE_OF_ITEMS (get_vat_transaction_data)
vat_transaction_data__delivery_conditionsTEXTDELIVERY_CONDITIONS (get_vat_transaction_data)DELIVERY_CONDITIONS (get_vat_transaction_data)
vat_transaction_data__departure_countryCOUNTRYDEPARTURE_COUNTRY (get_vat_transaction_data)DEPARTURE_COUNTRY (get_vat_transaction_data)
vat_transaction_data__departure_post_codeTEXTDEPARTURE_POST_CODE (get_vat_transaction_data)DEPARTURE_POST_CODE (get_vat_transaction_data)
vat_transaction_data__depature_cityCITYDEPATURE_CITY (get_vat_transaction_data)DEPATURE_CITY (get_vat_transaction_data)
vat_transaction_data__export_outside_euTEXTEXPORT_OUTSIDE_EU (get_vat_transaction_data)EXPORT_OUTSIDE_EU (get_vat_transaction_data)
vat_transaction_data__gift_wrap_amt_vat_exclNUMERICGIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__gift_wrap_amt_vat_inclNUMERICGIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__gift_wrap_vat_amtNUMERICGIFT_WRAP_VAT_AMT (get_vat_transaction_data)GIFT_WRAP_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__gift_wrap_vat_rate_percentNUMERICGIFT_WRAP_VAT_RATE_PERCENT (get_vat_transaction_data)GIFT_WRAP_VAT_RATE_PERCENT (get_vat_transaction_data)
vat_transaction_data__invoice_urlTEXTINVOICE_URL (get_vat_transaction_data)INVOICE_URL (get_vat_transaction_data)
vat_transaction_data__item_descriptionTEXTITEM_DESCRIPTION (get_vat_transaction_data)ITEM_DESCRIPTION (get_vat_transaction_data)
vat_transaction_data__item_manufacture_countryCOUNTRYITEM_MANUFACTURE_COUNTRY (get_vat_transaction_data)ITEM_MANUFACTURE_COUNTRY (get_vat_transaction_data)
vat_transaction_data__item_qty_supplementary_unitNUMERICITEM_QTY_SUPPLEMENTARY_UNIT (get_vat_transaction_data)ITEM_QTY_SUPPLEMENTARY_UNIT (get_vat_transaction_data)
vat_transaction_data__item_weightNUMERICITEM_WEIGHT (get_vat_transaction_data)ITEM_WEIGHT (get_vat_transaction_data)
vat_transaction_data__marketplaceTEXTMARKETPLACE (get_vat_transaction_data)MARKETPLACE (get_vat_transaction_data)
vat_transaction_data__price_of_items_amt_vat_exclNUMERICPRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data)PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__price_of_items_amt_vat_inclNUMERICPRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data)PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__price_of_items_vat_amtNUMERICPRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data)PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__price_of_items_vat_rate_percentNUMERICPRICE_OF_ITEMS_VAT_RATE_PERCENT (get_vat_transaction_data)PRICE_OF_ITEMS_VAT_RATE_PERCENT (get_vat_transaction_data)
vat_transaction_data__product_tax_codeTEXTPRODUCT_TAX_CODE (get_vat_transaction_data)PRODUCT_TAX_CODE (get_vat_transaction_data)
vat_transaction_data__program_typeTEXTPROGRAM_TYPE (get_vat_transaction_data)PROGRAM_TYPE (get_vat_transaction_data)
vat_transaction_data__promo_gift_wrap_amt_vat_exclNUMERICPROMO_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)PROMO_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__promo_gift_wrap_amt_vat_inclNUMERICPROMO_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)PROMO_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__promo_gift_wrap_vat_amtNUMERICPROMO_GIFT_WRAP_VAT_AMT (get_vat_transaction_data)PROMO_GIFT_WRAP_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__promo_price_of_items_amt_vat_exclNUMERICPROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data)PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__promo_price_of_items_amt_vat_inclNUMERICPROMO_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data)PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__promo_price_of_items_vat_amtNUMERICPROMO_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data)PROMO_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data)

Amazon Seller Central (Amazon SP) get_vat_transaction_data fields (vat_transaction_data__promo_ship_charge_amt_vat_excl to vat_transaction_data__transaction_arrival_date)

IDTypeNameDescription
vat_transaction_data__promo_ship_charge_amt_vat_exclNUMERICPROMO_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)PROMO_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__promo_ship_charge_amt_vat_inclNUMERICPROMO_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)PROMO_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__promo_ship_charge_vat_amtNUMERICPROMO_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)PROMO_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__qtyNUMERICQTY (get_vat_transaction_data)QTY (get_vat_transaction_data)
vat_transaction_data__sale_arrival_countryCOUNTRYSALE_ARRIVAL_COUNTRY (get_vat_transaction_data)SALE_ARRIVAL_COUNTRY (get_vat_transaction_data)
vat_transaction_data__sale_depart_countryCOUNTRYSALE_DEPART_COUNTRY (get_vat_transaction_data)SALE_DEPART_COUNTRY (get_vat_transaction_data)
vat_transaction_data__sales_channelTEXTSALES_CHANNEL (get_vat_transaction_data)SALES_CHANNEL (get_vat_transaction_data)
vat_transaction_data__seller_arrival_country_vat_numberTEXTSELLER_ARRIVAL_COUNTRY_VAT_NUMBER (get_vat_transaction_data)SELLER_ARRIVAL_COUNTRY_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__seller_arrival_vat_number_countryCOUNTRYSELLER_ARRIVAL_VAT_NUMBER_COUNTRY (get_vat_transaction_data)SELLER_ARRIVAL_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__seller_depart_country_vat_numberTEXTSELLER_DEPART_COUNTRY_VAT_NUMBER (get_vat_transaction_data)SELLER_DEPART_COUNTRY_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__seller_depart_vat_number_countryCOUNTRYSELLER_DEPART_VAT_NUMBER_COUNTRY (get_vat_transaction_data)SELLER_DEPART_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__seller_skuTEXTSELLER_SKU (get_vat_transaction_data)SELLER_SKU (get_vat_transaction_data)
vat_transaction_data__ship_charge_amt_vat_exclNUMERICSHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__ship_charge_amt_vat_inclNUMERICSHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__ship_charge_vat_amtNUMERICSHIP_CHARGE_VAT_AMT (get_vat_transaction_data)SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__ship_charge_vat_rate_percentNUMERICSHIP_CHARGE_VAT_RATE_PERCENT (get_vat_transaction_data)SHIP_CHARGE_VAT_RATE_PERCENT (get_vat_transaction_data)
vat_transaction_data__statistical_code_arrivalTEXTSTATISTICAL_CODE_ARRIVAL (get_vat_transaction_data)STATISTICAL_CODE_ARRIVAL (get_vat_transaction_data)
vat_transaction_data__statistical_code_departTEXTSTATISTICAL_CODE_DEPART (get_vat_transaction_data)STATISTICAL_CODE_DEPART (get_vat_transaction_data)
vat_transaction_data__supplier_nameTEXTSUPPLIER_NAME (get_vat_transaction_data)SUPPLIER_NAME (get_vat_transaction_data)
vat_transaction_data__supplier_vat_numberTEXTSUPPLIER_VAT_NUMBER (get_vat_transaction_data)SUPPLIER_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__tax_calculation_dateDATETAX_CALCULATION_DATE (get_vat_transaction_data)TAX_CALCULATION_DATE (get_vat_transaction_data)
vat_transaction_data__tax_collection_responsibilityTEXTTAX_COLLECTION_RESPONSIBILITY (get_vat_transaction_data)TAX_COLLECTION_RESPONSIBILITY (get_vat_transaction_data)
vat_transaction_data__tax_reporting_schemeTEXTTAX_REPORTING_SCHEME (get_vat_transaction_data)TAX_REPORTING_SCHEME (get_vat_transaction_data)
vat_transaction_data__taxable_jurisdictionTEXTTAXABLE_JURISDICTION (get_vat_transaction_data)TAXABLE_JURISDICTION (get_vat_transaction_data)
vat_transaction_data__taxable_jurisdiction_levelTEXTTAXABLE_JURISDICTION_LEVEL (get_vat_transaction_data)TAXABLE_JURISDICTION_LEVEL (get_vat_transaction_data)
vat_transaction_data__total_activity_supplementary_unitNUMERICTOTAL_ACTIVITY_SUPPLEMENTARY_UNIT (get_vat_transaction_data)TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT (get_vat_transaction_data)
vat_transaction_data__total_activity_value_amt_vat_exclNUMERICTOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL (get_vat_transaction_data)TOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__total_activity_value_amt_vat_inclNUMERICTOTAL_ACTIVITY_VALUE_AMT_VAT_INCL (get_vat_transaction_data)TOTAL_ACTIVITY_VALUE_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__total_activity_value_vat_amtNUMERICTOTAL_ACTIVITY_VALUE_VAT_AMT (get_vat_transaction_data)TOTAL_ACTIVITY_VALUE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__total_activity_weightNUMERICTOTAL_ACTIVITY_WEIGHT (get_vat_transaction_data)TOTAL_ACTIVITY_WEIGHT (get_vat_transaction_data)
vat_transaction_data__total_gift_wrap_amt_vat_exclNUMERICTOTAL_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)TOTAL_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__total_gift_wrap_amt_vat_inclNUMERICTOTAL_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)TOTAL_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__total_gift_wrap_vat_amtNUMERICTOTAL_GIFT_WRAP_VAT_AMT (get_vat_transaction_data)TOTAL_GIFT_WRAP_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__total_price_of_items_amt_vat_exclNUMERICTOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data)TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__total_price_of_items_amt_vat_inclNUMERICTOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data)TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__total_price_of_items_vat_amtNUMERICTOTAL_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data)TOTAL_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__total_ship_charge_amt_vat_exclNUMERICTOTAL_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)TOTAL_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__total_ship_charge_amt_vat_inclNUMERICTOTAL_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)TOTAL_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__total_ship_charge_vat_amtNUMERICTOTAL_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)TOTAL_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__transaction_arrival_dateDATETRANSACTION_ARRIVAL_DATE (get_vat_transaction_data)TRANSACTION_ARRIVAL_DATE (get_vat_transaction_data)

Amazon Seller Central (Amazon SP) get_vat_transaction_data fields (vat_transaction_data__transaction_complete_date to vat_transaction_data__vat_inv_number)

IDTypeNameDescription
vat_transaction_data__transaction_complete_dateDATETRANSACTION_COMPLETE_DATE (get_vat_transaction_data)TRANSACTION_COMPLETE_DATE (get_vat_transaction_data)
vat_transaction_data__transaction_currency_codeTEXTTRANSACTION_CURRENCY_CODE (get_vat_transaction_data)TRANSACTION_CURRENCY_CODE (get_vat_transaction_data)
vat_transaction_data__transaction_depart_dateDATETRANSACTION_DEPART_DATE (get_vat_transaction_data)TRANSACTION_DEPART_DATE (get_vat_transaction_data)
vat_transaction_data__transaction_event_idTEXTTRANSACTION_EVENT_ID (get_vat_transaction_data)TRANSACTION_EVENT_ID (get_vat_transaction_data)
vat_transaction_data__transaction_seller_vat_numberTEXTTRANSACTION_SELLER_VAT_NUMBER (get_vat_transaction_data)TRANSACTION_SELLER_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__transaction_seller_vat_number_countryCOUNTRYTRANSACTION_SELLER_VAT_NUMBER_COUNTRY (get_vat_transaction_data)TRANSACTION_SELLER_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__transaction_typeTEXTTRANSACTION_TYPE (get_vat_transaction_data)TRANSACTION_TYPE (get_vat_transaction_data)
vat_transaction_data__transportation_modeTEXTTRANSPORTATION_MODE (get_vat_transaction_data)TRANSPORTATION_MODE (get_vat_transaction_data)
vat_transaction_data__unique_account_identifierTEXTUNIQUE_ACCOUNT_IDENTIFIER (get_vat_transaction_data)UNIQUE_ACCOUNT_IDENTIFIER (get_vat_transaction_data)
vat_transaction_data__vat_calculation_imputation_countryCOUNTRYVAT_CALCULATION_IMPUTATION_COUNTRY (get_vat_transaction_data)VAT_CALCULATION_IMPUTATION_COUNTRY (get_vat_transaction_data)
vat_transaction_data__vat_inv_converted_amtNUMERICVAT_INV_CONVERTED_AMT (get_vat_transaction_data)VAT_INV_CONVERTED_AMT (get_vat_transaction_data)
vat_transaction_data__vat_inv_currency_codeTEXTVAT_INV_CURRENCY_CODE (get_vat_transaction_data)VAT_INV_CURRENCY_CODE (get_vat_transaction_data)
vat_transaction_data__vat_inv_exchange_rateNUMERICVAT_INV_EXCHANGE_RATE (get_vat_transaction_data)VAT_INV_EXCHANGE_RATE (get_vat_transaction_data)
vat_transaction_data__vat_inv_exchange_rate_dateDATEVAT_INV_EXCHANGE_RATE_DATE (get_vat_transaction_data)VAT_INV_EXCHANGE_RATE_DATE (get_vat_transaction_data)
vat_transaction_data__vat_inv_numberTEXTVAT_INV_NUMBER (get_vat_transaction_data)VAT_INV_NUMBER (get_vat_transaction_data)

Amazon Seller Central (Amazon SP) other fields

The Amazon Seller Central (Amazon SP) connector has 22 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe account ID
account_nameTEXTAccount NameThe account name
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate to which metrics apply
day_of_monthTEXTDay of monthDay of the month
marketplace_countryCOUNTRYMarketplace CountryThe Marketplace Country
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20