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

394 metrics521 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 915 fields (394 metrics, 521 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.

ID Type Name Description
afn_inventory_data_by_country__asin TEXT asin (get_afn_inventory_data_by_country) asin (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__condition_type TEXT condition-type (get_afn_inventory_data_by_country) condition-type (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__country COUNTRY country (get_afn_inventory_data_by_country) country (get_afn_inventory_data_by_country)
afn_inventory_data_by_country__fulfillment_channel_sku TEXT fulfillment-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_fulfillment NUMERIC quantity-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_sku TEXT seller-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)

ID Type Name Description
amazon_fulfilled_shipments_data_general__amazon_order_id TEXT amazon-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_id TEXT amazon-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_1 TEXT bill-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_2 TEXT bill-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_3 TEXT bill-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_city CITY bill-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_country COUNTRY bill-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_code TEXT bill-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_state TEXT bill-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_email TEXT buyer-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_name TEXT buyer-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_number TEXT buyer-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__carrier TEXT carrier (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__currency TEXT currency (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_date DATE estimated-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_id TEXT fulfillment-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_channel TEXT fulfillment-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_price NUMERIC gift-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_tax NUMERIC gift-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_price NUMERIC item-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_discount NUMERIC item-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_tax NUMERIC item-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_id TEXT merchant-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_id TEXT merchant-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_date DATE payments-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_name TEXT product-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_date DATE purchase-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_shipped NUMERIC quantity-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_name TEXT recipient-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_date DATE reporting-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_channel TEXT sales-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_1 TEXT ship-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_2 TEXT ship-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_3 TEXT ship-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_city CITY ship-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_country COUNTRY ship-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_number TEXT ship-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_code TEXT ship-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_discount NUMERIC ship-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_level TEXT ship-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)

ID Type Name Description
amazon_fulfilled_shipments_data_general__ship_state TEXT ship-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_date DATE shipment-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_id TEXT shipment-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_id TEXT shipment-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_price NUMERIC shipping-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_tax NUMERIC shipping-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__sku TEXT sku (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_number TEXT tracking-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.

ID Type Name Description
brand_analytics_market_basket_report__asin TEXT asin (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__combinationpct NUMERIC combinationPct (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__enddate DATE endDate (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__purchasedwithasin TEXT purchasedWithAsin (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__purchasedwithrank NUMERIC purchasedWithRank (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__startdate DATE startDate (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)

ID Type Name Description
brand_analytics_search_query_performance_report__asin TEXT asin (get_brand_analytics_search_query_performance_report) asin (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_asincartaddcount NUMERIC cartAddData-asinCartAddCount (get_brand_analytics_search_query_performance_report) cartAddData-asinCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_asincartaddshare NUMERIC cartAddData-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_amount NUMERIC cartAddData-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_currencycode TEXT cartAddData-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_totalcartaddcount NUMERIC cartAddData-totalCartAddCount (get_brand_analytics_search_query_performance_report) cartAddData-totalCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalcartaddrate NUMERIC cartAddData-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_amount NUMERIC cartAddData-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_currencycode TEXT cartAddData-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_totalonedayshippingcartaddcount NUMERIC cartAddData-totalOneDayShippingCartAddCount (get_brand_analytics_search_query_performance_report) cartAddData-totalOneDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totalsamedayshippingcartaddcount NUMERIC cartAddData-totalSameDayShippingCartAddCount (get_brand_analytics_search_query_performance_report) cartAddData-totalSameDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__cartadddata_totaltwodayshippingcartaddcount NUMERIC cartAddData-totalTwoDayShippingCartAddCount (get_brand_analytics_search_query_performance_report) cartAddData-totalTwoDayShippingCartAddCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_asinclickcount NUMERIC clickData-asinClickCount (get_brand_analytics_search_query_performance_report) clickData-asinClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_asinclickshare NUMERIC clickData-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_amount NUMERIC clickData-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_currencycode TEXT clickData-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_totalclickcount NUMERIC clickData-totalClickCount (get_brand_analytics_search_query_performance_report) clickData-totalClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalclickrate NUMERIC clickData-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_amount NUMERIC clickData-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_currencycode TEXT clickData-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_totalonedayshippingclickcount NUMERIC clickData-totalOneDayShippingClickCount (get_brand_analytics_search_query_performance_report) clickData-totalOneDayShippingClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totalsamedayshippingclickcount NUMERIC clickData-totalSameDayShippingClickCount (get_brand_analytics_search_query_performance_report) clickData-totalSameDayShippingClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__clickdata_totaltwodayshippingclickcount NUMERIC clickData-totalTwoDayShippingClickCount (get_brand_analytics_search_query_performance_report) clickData-totalTwoDayShippingClickCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__enddate DATE endDate (get_brand_analytics_search_query_performance_report) endDate (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__impressiondata_asinimpressioncount NUMERIC impressionData-asinImpressionCount (get_brand_analytics_search_query_performance_report) impressionData-asinImpressionCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__impressiondata_asinimpressionshare NUMERIC impressionData-asinImpressionShare (get_brand_analytics_search_query_performance_report) impressionData-asinImpressionShare (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__impressiondata_totalqueryimpressioncount NUMERIC impressionData-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_amount NUMERIC purchaseData-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_currencycode TEXT purchaseData-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_asinpurchasecount NUMERIC purchaseData-asinPurchaseCount (get_brand_analytics_search_query_performance_report) purchaseData-asinPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_asinpurchaseshare NUMERIC purchaseData-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_amount NUMERIC purchaseData-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_currencycode TEXT purchaseData-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_totalonedayshippingpurchasecount NUMERIC purchaseData-totalOneDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report) purchaseData-totalOneDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalpurchasecount NUMERIC purchaseData-totalPurchaseCount (get_brand_analytics_search_query_performance_report) purchaseData-totalPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalpurchaserate NUMERIC purchaseData-totalPurchaseRate (get_brand_analytics_search_query_performance_report) purchaseData-totalPurchaseRate (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totalsamedayshippingpurchasecount NUMERIC purchaseData-totalSameDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report) purchaseData-totalSameDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__purchasedata_totaltwodayshippingpurchasecount NUMERIC purchaseData-totalTwoDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report) purchaseData-totalTwoDayShippingPurchaseCount (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__searchquerydata_searchquery TEXT searchQueryData-searchQuery (get_brand_analytics_search_query_performance_report) searchQueryData-searchQuery (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__searchquerydata_searchqueryscore NUMERIC searchQueryData-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)

ID Type Name Description
brand_analytics_search_query_performance_report__searchquerydata_searchqueryvolume NUMERIC searchQueryData-searchQueryVolume (get_brand_analytics_search_query_performance_report) searchQueryData-searchQueryVolume (get_brand_analytics_search_query_performance_report)
brand_analytics_search_query_performance_report__startdate DATE startDate (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.

ID Type Name Description
fba_estimated_fba_fees_txt_data__asin TEXT asin (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__brand TEXT brand (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__currency TEXT currency (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_total NUMERIC estimated-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_order NUMERIC estimated-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_unit TEXT estimated-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_unit NUMERIC estimated-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_fee NUMERIC estimated-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_unit NUMERIC estimated-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_unit NUMERIC expected-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__fnsku TEXT fnsku (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_by TEXT fulfilled-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_weight NUMERIC item-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_girth NUMERIC length-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_side NUMERIC longest-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_side NUMERIC median-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_group TEXT product-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_name TEXT product-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_tier TEXT product-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_price NUMERIC sales-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_side NUMERIC shortest-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__sku TEXT sku (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_dimension TEXT unit-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_weight TEXT unit-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_price NUMERIC your-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.

ID Type Name Description
fba_fulfillment_customer_returns_data__asin TEXT asin (get_fba_fulfillment_customer_returns_data) asin (get_fba_fulfillment_customer_returns_data) Amazon standard itemnumber
fba_fulfillment_customer_returns_data__customer_comments TEXT customer-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_disposition TEXT detailed-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__fnsku TEXT fnsku (get_fba_fulfillment_customer_returns_data) fnsku (get_fba_fulfillment_customer_returns_data) Fulfillment networkSKU
fba_fulfillment_customer_returns_data__fulfillment_center_id TEXT fulfillment-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_number TEXT license-plate-number (get_fba_fulfillment_customer_returns_data) license-plate-number (get_fba_fulfillment_customer_returns_data)
fba_fulfillment_customer_returns_data__order_id TEXT order-id (get_fba_fulfillment_customer_returns_data) order-id (get_fba_fulfillment_customer_returns_data)
fba_fulfillment_customer_returns_data__product_name TEXT product-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__quantity NUMERIC quantity (get_fba_fulfillment_customer_returns_data) quantity (get_fba_fulfillment_customer_returns_data) Number of unitsof this item returned
fba_fulfillment_customer_returns_data__reason TEXT reason (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_date DATE return-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__sku TEXT sku (get_fba_fulfillment_customer_returns_data) sku (get_fba_fulfillment_customer_returns_data) Seller's itemidentifier
fba_fulfillment_customer_returns_data__status TEXT status (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)

ID Type Name Description
fba_fulfillment_inventory_health_data__asin TEXT asin (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_limit NUMERIC asin-limit (get_fba_inventory_planning_data) asin-limit (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__condition TEXT condition (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__currency TEXT currency (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__fnsku TEXT fnsku (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_quantity NUMERIC in-bound-quantity (get_fba_inventory_planning_data) in-bound-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__inbound_recommend_quantity NUMERIC inbound-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_days NUMERIC inv-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_days NUMERIC inv-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_days NUMERIC inv-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_days NUMERIC inv-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_days NUMERIC inv-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_hazmat TEXT is-hazmat (get_fba_inventory_planning_data) is-hazmat (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__lowest_afn_new_price NUMERIC lowest-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_price NUMERIC lowest-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_price NUMERIC lowest-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_price NUMERIC lowest-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_sellers NUMERIC num-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_sellers NUMERIC num-afn-used-sellers (get_fba_inventory_planning_data) num-afn-used-sellers (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__per_unit_volume NUMERIC per-unit-volume (get_fba_inventory_planning_data) per-unit-volume (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__product_group TEXT product-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_name TEXT product-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_mo NUMERIC (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_mo NUMERIC (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_program NUMERIC qty-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_mo NUMERIC (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_mo NUMERIC (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_progress TEXT qty-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_price NUMERIC sales-price (get_fba_inventory_planning_data) sales-price (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__sales_rank NUMERIC sales-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_quantity NUMERIC sellable-quantity (get_fba_inventory_planning_data) sellable-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__sku TEXT sku (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_date DATE snapshot-date (get_fba_inventory_planning_data) snapshot-date (get_fba_inventory_planning_data) The date the reportwas generated
fba_fulfillment_inventory_health_data__total_quantity NUMERIC total-quantity (get_fba_inventory_planning_data) total-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__units_shipped_last_180_days NUMERIC units-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_hrs NUMERIC units-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_days NUMERIC units-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_days NUMERIC units-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_days NUMERIC units-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_days NUMERIC units-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)

ID Type Name Description
fba_fulfillment_inventory_health_data__unsellable_quantity NUMERIC unsellable-quantity (get_fba_inventory_planning_data) unsellable-quantity (get_fba_inventory_planning_data)
fba_fulfillment_inventory_health_data__weeks_of_cover_t180 TEXT weeks-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_t30 TEXT weeks-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_t365 TEXT weeks-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_t7 TEXT weeks-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_t90 TEXT weeks-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_price NUMERIC your-price (get_fba_inventory_planning_data) your-price (get_fba_inventory_planning_data) Your listed price
fba_inventory_planning_data__alert TEXT alert (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__available NUMERIC available (get_fba_inventory_planning_data) available (get_fba_inventory_planning_data) Available (sellableinventory) quantity
fba_inventory_planning_data__days_of_supply NUMERIC days-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_days NUMERIC estimated-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_actions NUMERIC estimated-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_quantity NUMERIC estimated-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_charge TEXT (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_month NUMERIC estimated-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_price NUMERIC featuredoffer-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_level NUMERIC healthy-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_quantity NUMERIC inbound-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_received NUMERIC inbound-received (get_fba_inventory_planning_data) inbound-received (get_fba_inventory_planning_data) Shipments inreceiving status
fba_inventory_planning_data__inbound_shipped NUMERIC inbound-shipped (get_fba_inventory_planning_data) inbound-shipped (get_fba_inventory_planning_data) Shipments in shippedstatus
fba_inventory_planning_data__inbound_working NUMERIC inbound-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_days TEXT inv-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_days TEXT inv-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_days TEXT inv-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_days TEXT inv-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_days TEXT inv-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_volume NUMERIC item-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_shipping TEXT lowest-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_used TEXT lowest-price-used (get_fba_inventory_planning_data) lowest-price-used (get_fba_inventory_planning_data)
fba_inventory_planning_data__marketplace TEXT marketplace (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_months NUMERIC no-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_quantity NUMERIC pending-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)

ID Type Name Description
fba_inventory_planning_data__projected_ltsf_9_mo TEXT (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_mo TEXT (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_action TEXT recommended-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_quantity NUMERIC recommended-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_days NUMERIC recommended-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_price NUMERIC recommended-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_days NUMERIC sales-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_days NUMERIC sales-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_days NUMERIC sales-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_days NUMERIC sales-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_through NUMERIC sell-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_type TEXT storage-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_volume NUMERIC storage-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_t30 NUMERIC units-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_t60 NUMERIC units-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_t7 NUMERIC units-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_t90 NUMERIC units-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_measurement TEXT volume-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.

ID Type Name Description
fba_myi_unsuppressed_inventory_data__afn_fulfillable_quantity NUMERIC afn-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_buyable NUMERIC afn-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_quantity NUMERIC afn-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_quantity NUMERIC afn-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_quantity NUMERIC afn-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_exists TEXT afn-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_quantity NUMERIC afn-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_supply NUMERIC afn-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_quantity NUMERIC afn-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_quantity NUMERIC afn-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_quantity NUMERIC afn-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_quantity NUMERIC afn-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__asin TEXT asin (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__condition TEXT condition (get_fba_myi_unsuppressed_inventory_data) condition (get_fba_myi_unsuppressed_inventory_data) The condition ofyour product.
fba_myi_unsuppressed_inventory_data__fnsku TEXT fnsku (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_quantity TEXT mfn-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_exists TEXT mfn-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_volume NUMERIC per-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_name TEXT product-name (get_fba_myi_unsuppressed_inventory_data) product-name (get_fba_myi_unsuppressed_inventory_data) The title ofyour product.
fba_myi_unsuppressed_inventory_data__sku TEXT sku (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_price NUMERIC your-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.

ID Type Name Description
fba_reimbursements_data__amazon_order_id TEXT amazon-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_unit NUMERIC amount-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_total NUMERIC amount-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_date DATE approval-date (get_fba_reimbursements_data) approval-date (get_fba_reimbursements_data) The date the reimbursementwas approved.
fba_reimbursements_data__asin TEXT asin (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_id TEXT case-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__condition TEXT condition (get_fba_reimbursements_data) condition (get_fba_reimbursements_data) The condition of your item(for example, New).
fba_reimbursements_data__currency_unit TEXT currency-unit (get_fba_reimbursements_data) currency-unit (get_fba_reimbursements_data) The currency for theapplicable marketplace.
fba_reimbursements_data__fnsku TEXT fnsku (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_id TEXT original-reimbursement-id (get_fba_reimbursements_data) original-reimbursement-id (get_fba_reimbursements_data)
fba_reimbursements_data__original_reimbursement_type TEXT original-reimbursement-type (get_fba_reimbursements_data) original-reimbursement-type (get_fba_reimbursements_data)
fba_reimbursements_data__product_name TEXT product-name (get_fba_reimbursements_data) product-name (get_fba_reimbursements_data) The name of your product.
fba_reimbursements_data__quantity_reimbursed_cash NUMERIC quantity-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_inventory NUMERIC quantity-reimbursed-inventory (get_fba_reimbursements_data) quantity-reimbursed-inventory (get_fba_reimbursements_data) The numberof units reimbursed with inventory.
fba_reimbursements_data__quantity_reimbursed_total NUMERIC quantity-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__reason TEXT reason (get_fba_reimbursements_data) reason (get_fba_reimbursements_data) The reason for the reimbursement(for example, Damaged: Warehouse).
fba_reimbursements_data__reimbursement_id TEXT reimbursement-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__sku TEXT sku (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.

ID Type Name Description
fba_uno_inventory_data__asin TEXT (Deprecated) asin (get_fba_uno_inventory_data) asin (get_fba_uno_inventory_data)
fba_uno_inventory_data__price NUMERIC (Deprecated) price (get_fba_uno_inventory_data) price (get_fba_uno_inventory_data)
fba_uno_inventory_data__quantity NUMERIC (Deprecated) quantity (get_fba_uno_inventory_data) quantity (get_fba_uno_inventory_data)
fba_uno_inventory_data__sku TEXT (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.

ID Type Name Description
flat_file_all_orders_data_by_last_update_general__amazon_order_id TEXT amazon-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__asin TEXT asin (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__currency TEXT currency (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_channel TEXT fulfillment-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_price NUMERIC gift-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_tax NUMERIC gift-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_order TEXT is-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_price NUMERIC item-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_discount TEXT item-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_status TEXT item-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_tax NUMERIC item-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_date DATE last-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_id TEXT merchant-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_channel TEXT order-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_status TEXT order-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_designation TEXT price-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_name TEXT product-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_ids TEXT promotion-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_date DATE purchase-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_number TEXT purchase-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__quantity TEXT quantity (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_channel TEXT sales-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_city CITY ship-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_country COUNTRY ship-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_code TEXT ship-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_discount TEXT ship-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_level TEXT ship-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_state TEXT ship-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_price NUMERIC shipping-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_tax TEXT shipping-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__sku TEXT sku (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.

ID Type Name Description
flat_file_all_orders_data_by_order_date_general__amazon_order_id TEXT amazon-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__asin TEXT asin (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__currency TEXT currency (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_channel TEXT fulfillment-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_price NUMERIC gift-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_tax NUMERIC gift-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_order TEXT is-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_price NUMERIC item-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_discount TEXT item-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_status TEXT item-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_tax NUMERIC item-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_date DATE last-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_id TEXT merchant-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_channel TEXT order-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_status TEXT order-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_designation TEXT price-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_name TEXT product-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_ids TEXT promotion-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_date TIMESTAMP purchase-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_number TEXT purchase-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__quantity TEXT quantity (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_channel TEXT sales-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_city CITY ship-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_country COUNTRY ship-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_code TEXT ship-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_discount TEXT ship-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_level TEXT ship-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_state TEXT ship-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_price NUMERIC shipping-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_tax TEXT shipping-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__sku TEXT sku (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.

ID Type Name Description
flat_file_open_listings_data__asin TEXT asin (get_flat_file_open_listings_data) asin (get_flat_file_open_listings_data)
flat_file_open_listings_data__business_price TEXT Business Price (get_flat_file_open_listings_data) Business Price (get_flat_file_open_listings_data)
flat_file_open_listings_data__price NUMERIC price (get_flat_file_open_listings_data) price (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_lower_bound_1 TEXT Progressive 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_2 TEXT Progressive 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_3 TEXT Progressive 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_1 TEXT Progressive Price 1 (get_flat_file_open_listings_data) Progressive Price 1 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_2 TEXT Progressive Price 2 (get_flat_file_open_listings_data) Progressive Price 2 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_3 TEXT Progressive Price 3 (get_flat_file_open_listings_data) Progressive Price 3 (get_flat_file_open_listings_data)
flat_file_open_listings_data__progressive_price_type TEXT Progressive Price Type (get_flat_file_open_listings_data) Progressive Price Type (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity NUMERIC quantity (get_flat_file_open_listings_data) quantity (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_lower_bound_1 TEXT Quantity 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_2 TEXT Quantity 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_3 TEXT Quantity 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_4 TEXT Quantity 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_5 TEXT Quantity 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_1 TEXT Quantity Price 1 (get_flat_file_open_listings_data) Quantity Price 1 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_2 TEXT Quantity Price 2 (get_flat_file_open_listings_data) Quantity Price 2 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_3 TEXT Quantity Price 3 (get_flat_file_open_listings_data) Quantity Price 3 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_4 TEXT Quantity Price 4 (get_flat_file_open_listings_data) Quantity Price 4 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_5 TEXT Quantity Price 5 (get_flat_file_open_listings_data) Quantity Price 5 (get_flat_file_open_listings_data)
flat_file_open_listings_data__quantity_price_type TEXT Quantity Price Type (get_flat_file_open_listings_data) Quantity Price Type (get_flat_file_open_listings_data)
flat_file_open_listings_data__sku TEXT sku (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.

ID Type Name Description
flat_file_returns_data_by_return_date__a_to_z_claim TEXT A-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_id TEXT Amazon 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__asin TEXT ASIN (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_code TEXT Currency 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_policy TEXT In 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_number TEXT Invoice 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_prime TEXT Is 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_name TEXT Item 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_cost NUMERIC Label 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_by TEXT Label 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_type TEXT Label 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_id TEXT Merchant 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_sku TEXT Merchant 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_amount NUMERIC Order 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_date DATE Order 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_id TEXT Order 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_quantity NUMERIC Order 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_amount NUMERIC Refunded 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__resolution TEXT Resolution (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_carrier TEXT Return 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_date DATE Return 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_quantity NUMERIC Return 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_reason TEXT Return 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_date DATE Return 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_status TEXT Return 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_type TEXT Return 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_reason TEXT SafeT 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_time TIMESTAMP SafeT 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_id TEXT SafeT 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_amount NUMERIC SafeT 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_state TEXT SafeT 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_id TEXT Tracking 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.

ID Type Name Description
ledger_detail_view_data__asin TEXT ASIN (get_ledger_detail_view_data) ASIN (get_ledger_detail_view_data)
ledger_detail_view_data__country COUNTRY Country (get_ledger_detail_view_data) Country (get_ledger_detail_view_data)
ledger_detail_view_data__date DATE Date (get_ledger_detail_view_data) Date (get_ledger_detail_view_data)
ledger_detail_view_data__disposition TEXT Disposition (get_ledger_detail_view_data) Disposition (get_ledger_detail_view_data)
ledger_detail_view_data__event_type TEXT Event Type (get_ledger_detail_view_data) Event Type (get_ledger_detail_view_data)
ledger_detail_view_data__fnsku TEXT FNSKU (get_ledger_detail_view_data) FNSKU (get_ledger_detail_view_data)
ledger_detail_view_data__fulfillment_center TEXT Fulfillment Center (get_ledger_detail_view_data) Fulfillment Center (get_ledger_detail_view_data)
ledger_detail_view_data__msku TEXT MSKU (get_ledger_detail_view_data) MSKU (get_ledger_detail_view_data)
ledger_detail_view_data__quantity NUMERIC Quantity (get_ledger_detail_view_data) Quantity (get_ledger_detail_view_data)
ledger_detail_view_data__reason TEXT Reason (get_ledger_detail_view_data) Reason (get_ledger_detail_view_data)
ledger_detail_view_data__reconciled_quantity NUMERIC Reconciled Quantity (get_ledger_detail_view_data) Reconciled Quantity (get_ledger_detail_view_data)
ledger_detail_view_data__reference_id TEXT Reference ID (get_ledger_detail_view_data) Reference ID (get_ledger_detail_view_data)
ledger_detail_view_data__title TEXT Title (get_ledger_detail_view_data) Title (get_ledger_detail_view_data)
ledger_detail_view_data__unreconciled_quantity NUMERIC Unreconciled 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.

ID Type Name Description
ledger_summary_view_data__asin TEXT ASIN (get_ledger_summary_view_data) ASIN (get_ledger_summary_view_data)
ledger_summary_view_data__customer_returns NUMERIC Customer Returns (get_ledger_summary_view_data) Customer Returns (get_ledger_summary_view_data)
ledger_summary_view_data__customer_shipments NUMERIC Customer Shipments (get_ledger_summary_view_data) Customer Shipments (get_ledger_summary_view_data)
ledger_summary_view_data__damaged NUMERIC Damaged (get_ledger_summary_view_data) Damaged (get_ledger_summary_view_data)
ledger_summary_view_data__date DATE Date (get_ledger_summary_view_data) Date (get_ledger_summary_view_data)
ledger_summary_view_data__disposed NUMERIC Disposed (get_ledger_summary_view_data) Disposed (get_ledger_summary_view_data)
ledger_summary_view_data__disposition TEXT Disposition (get_ledger_summary_view_data) Disposition (get_ledger_summary_view_data)
ledger_summary_view_data__ending_warehouse_balance NUMERIC Ending Warehouse Balance (get_ledger_summary_view_data) Ending Warehouse Balance (get_ledger_summary_view_data)
ledger_summary_view_data__fnsku TEXT FNSKU (get_ledger_summary_view_data) FNSKU (get_ledger_summary_view_data)
ledger_summary_view_data__found NUMERIC Found (get_ledger_summary_view_data) Found (get_ledger_summary_view_data)
ledger_summary_view_data__in_transit_between_warehouses NUMERIC In Transit Between Warehouses (get_ledger_summary_view_data) In Transit Between Warehouses (get_ledger_summary_view_data)
ledger_summary_view_data__location TEXT Location (get_ledger_summary_view_data) Location (get_ledger_summary_view_data)
ledger_summary_view_data__lost NUMERIC Lost (get_ledger_summary_view_data) Lost (get_ledger_summary_view_data)
ledger_summary_view_data__msku TEXT MSKU (get_ledger_summary_view_data) MSKU (get_ledger_summary_view_data)
ledger_summary_view_data__other_events NUMERIC Other Events (get_ledger_summary_view_data) Other Events (get_ledger_summary_view_data)
ledger_summary_view_data__receipts NUMERIC Receipts (get_ledger_summary_view_data) Receipts (get_ledger_summary_view_data)
ledger_summary_view_data__starting_warehouse_balance NUMERIC Starting Warehouse Balance (get_ledger_summary_view_data) Starting Warehouse Balance (get_ledger_summary_view_data)
ledger_summary_view_data__title TEXT Title (get_ledger_summary_view_data) Title (get_ledger_summary_view_data)
ledger_summary_view_data__unknown_events NUMERIC Unknown Events (get_ledger_summary_view_data) Unknown Events (get_ledger_summary_view_data)
ledger_summary_view_data__vendor_returns NUMERIC Vendor Returns (get_ledger_summary_view_data) Vendor Returns (get_ledger_summary_view_data)
ledger_summary_view_data__warehouse_transfer_in_out NUMERIC Warehouse 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.

ID Type Name Description
merchant_listings_all_data__add_delete TEXT add-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__asin1 TEXT asin1 (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__asin2 TEXT asin2 (get_merchant_listings_all_data) asin2 (get_merchant_listings_all_data) This is used for backwardscompatibility only.
merchant_listings_all_data__asin3 TEXT asin3 (get_merchant_listings_all_data) asin3 (get_merchant_listings_all_data) This is used for backwardscompatibility only.
merchant_listings_all_data__bid_for_featured_placement TEXT bid-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_shipping TEXT expedited-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_channel TEXT fulfillment-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_url IMAGE_URL image-url (get_merchant_listings_all_data) image-url (get_merchant_listings_all_data)
merchant_listings_all_data__item_condition NUMERIC item-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_description TEXT item-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_marketplace TEXT item-is-marketplace (get_merchant_listings_all_data) item-is-marketplace (get_merchant_listings_all_data) This will alwaysbe y.
merchant_listings_all_data__item_name TEXT item-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_note TEXT item-note (get_merchant_listings_all_data) item-note (get_merchant_listings_all_data) Your description of thelisting.
merchant_listings_all_data__listing_id TEXT listing-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_group TEXT merchant-shipping-group (get_merchant_listings_all_data) merchant-shipping-group (get_merchant_listings_all_data)
merchant_listings_all_data__open_date DATE open-date (get_merchant_listings_all_data) open-date (get_merchant_listings_all_data) The date the listing wascreated.
merchant_listings_all_data__pending_quantity TEXT pending-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__price NUMERIC price (get_merchant_listings_all_data) price (get_merchant_listings_all_data) The price you are asking forthe product.
merchant_listings_all_data__product_id TEXT product-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_type NUMERIC product-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__quantity TEXT quantity (get_merchant_listings_all_data) quantity (get_merchant_listings_all_data) The quantity of the productavailable for purchase.
merchant_listings_all_data__seller_sku TEXT seller-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__status TEXT status (get_merchant_listings_all_data) status (get_merchant_listings_all_data)
merchant_listings_all_data__will_ship_internationally TEXT will-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_boldface TEXT zshop-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_path TEXT zshop-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_category1 TEXT zshop-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_fee TEXT zshop-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_feature TEXT zshop-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.

ID Type Name Description
merchant_listings_all_data_custom__asin1 TEXT asin1 (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_name TEXT item-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_price NUMERIC maximum-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_price NUMERIC minimum-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_sku TEXT seller-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.

ID Type Name Description
restock_inventory_recommendations_report__alert TEXT Alert (get_restock_inventory_recommendations_report) Alert (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__asin TEXT ASIN (get_restock_inventory_recommendations_report) ASIN (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__available NUMERIC Available (get_restock_inventory_recommendations_report) Available (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__condition TEXT Condition (get_restock_inventory_recommendations_report) Condition (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__country COUNTRY Country (get_restock_inventory_recommendations_report) Country (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__currency_code TEXT Currency code (get_restock_inventory_recommendations_report) Currency code (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__customer_order NUMERIC Customer Order (get_restock_inventory_recommendations_report) Customer Order (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__days_of_supply_at_amazon_fulfillment_network TEXT Days 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_processing NUMERIC FC Processing (get_restock_inventory_recommendations_report) FC Processing (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fc_transfer NUMERIC FC transfer (get_restock_inventory_recommendations_report) FC transfer (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fnsku TEXT FNSKU (get_restock_inventory_recommendations_report) FNSKU (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__fulfilled_by TEXT Fulfilled by (get_restock_inventory_recommendations_report) Fulfilled by (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__inbound NUMERIC Inbound (get_restock_inventory_recommendations_report) Inbound (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__merchant_sku TEXT Merchant SKU (get_restock_inventory_recommendations_report) Merchant SKU (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__price NUMERIC Price (get_restock_inventory_recommendations_report) Price (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__product_name TEXT Product Name (get_restock_inventory_recommendations_report) Product Name (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__receiving NUMERIC Receiving (get_restock_inventory_recommendations_report) Receiving (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__recommended_action TEXT Recommended action (get_restock_inventory_recommendations_report) Recommended action (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__recommended_replenishment_qty NUMERIC Recommended replenishment qty (get_restock_inventory_recommendations_report) Recommended replenishment qty(get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__recommended_ship_date DATE Recommended ship date (get_restock_inventory_recommendations_report) Recommended ship date (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__sales_last_30_days NUMERIC Sales last 30 days (get_restock_inventory_recommendations_report) Sales last 30 days (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__shipped NUMERIC Shipped (get_restock_inventory_recommendations_report) Shipped (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__supplier TEXT Supplier (get_restock_inventory_recommendations_report) Supplier (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__supplier_part_no. TEXT Supplier 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) TEXT Total 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_units NUMERIC Total Units (get_restock_inventory_recommendations_report) Total Units (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__unfulfillable NUMERIC Unfulfillable (get_restock_inventory_recommendations_report) Unfulfillable (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__units_sold_last_30_days NUMERIC Units Sold Last 30 Days (get_restock_inventory_recommendations_report) Units Sold Last 30 Days (get_restock_inventory_recommendations_report)
restock_inventory_recommendations_report__working NUMERIC Working (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)

ID Type Name Description
sales_and_traffic_report_by_date__childasin TEXT childAsin (get_sales_and_traffic_report) childAsin (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__parentasin TEXT parentAsin (get_sales_and_traffic_report) parentAsin (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitem_amount NUMERIC salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report) salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitem_currencycode TEXT (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_amount NUMERIC (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_currencycode TEXT (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_amount NUMERIC salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report) salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averagesellingprice_currencycode TEXT (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_amount NUMERIC (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_currencycode TEXT (Deprecated) salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report) salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averageunitsperorderitem NUMERIC (Deprecated) salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report) salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_averageunitsperorderitemb2b NUMERIC (Deprecated) salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report) salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_claimsamount_amount TEXT (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_currencycode TEXT (Deprecated) salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report) salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_claimsgranted TEXT (Deprecated) salesByAsin-claimsGranted (get_sales_and_traffic_report) salesByAsin-claimsGranted (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsales_amount NUMERIC salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report) salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsales_currencycode TEXT salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report) salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsalesb2b_amount NUMERIC salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report) salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_orderedproductsalesb2b_currencycode TEXT salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report) salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_ordersshipped NUMERIC (Deprecated) salesByAsin-ordersShipped (get_sales_and_traffic_report) salesByAsin-ordersShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_refundrate NUMERIC salesByAsin-refundRate (get_sales_and_traffic_report) salesByAsin-refundRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_shippedproductsales_amount NUMERIC salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report) salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_shippedproductsales_currencycode TEXT (Deprecated) salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report) salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_totalorderitems NUMERIC salesByAsin-totalOrderItems (get_sales_and_traffic_report) salesByAsin-totalOrderItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_totalorderitemsb2b NUMERIC salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report) salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsordered NUMERIC salesByAsin-unitsOrdered (get_sales_and_traffic_report) salesByAsin-unitsOrdered (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsorderedb2b NUMERIC salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report) salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsrefunded NUMERIC (Deprecated) salesByAsin-unitsRefunded (get_sales_and_traffic_report) salesByAsin-unitsRefunded (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbyasin_unitsshipped NUMERIC salesByAsin-unitsShipped (get_sales_and_traffic_report) salesByAsin-unitsShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_averageoffercount NUMERIC (Deprecated) trafficByAsin-averageOfferCount (get_sales_and_traffic_report) trafficByAsin-averageOfferCount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_averageparentitems NUMERIC trafficByAsin-averageParentItems (get_sales_and_traffic_report) trafficByAsin-averageParentItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviews NUMERIC trafficByAsin-browserPageViews (get_sales_and_traffic_report) trafficByAsin-browserPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewsb2b NUMERIC trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report) trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewspercentage NUMERIC trafficByAsin-browserPageViewsPercentage (get_sales_and_traffic_report) trafficByAsin-browserPageViewsPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browserpageviewspercentageb2b NUMERIC trafficByAsin-browserPageViewsPercentageB2B (get_sales_and_traffic_report) trafficByAsin-browserPageViewsPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionpercentage NUMERIC trafficByAsin-browserSessionPercentage (get_sales_and_traffic_report) trafficByAsin-browserSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionpercentageb2b NUMERIC trafficByAsin-browserSessionPercentageB2B (get_sales_and_traffic_report) trafficByAsin-browserSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessions NUMERIC trafficByAsin-browserSessions (get_sales_and_traffic_report) trafficByAsin-browserSessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_browsersessionsb2b NUMERIC trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report) trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentage NUMERIC trafficByAsin-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)

ID Type Name Description
sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentageb2b NUMERIC trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report) trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_feedbackreceived TEXT (Deprecated) trafficByAsin-feedbackReceived (get_sales_and_traffic_report) trafficByAsin-feedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviews NUMERIC trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report) trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewsb2b NUMERIC trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report) trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewspercentage NUMERIC trafficByAsin-mobileAppPageViewsPercentage (get_sales_and_traffic_report) trafficByAsin-mobileAppPageViewsPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewspercentageb2b NUMERIC trafficByAsin-mobileAppPageViewsPercentageB2B (get_sales_and_traffic_report) trafficByAsin-mobileAppPageViewsPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionpercentage NUMERIC trafficByAsin-mobileAppSessionPercentage (get_sales_and_traffic_report) trafficByAsin-mobileAppSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionpercentageb2b NUMERIC trafficByAsin-mobileAppSessionPercentageB2B (get_sales_and_traffic_report) trafficByAsin-mobileAppSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessions NUMERIC trafficByAsin-mobileAppSessions (get_sales_and_traffic_report) trafficByAsin-mobileAppSessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionsb2b NUMERIC trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report) trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_negativefeedbackreceived TEXT (Deprecated) trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report) trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_orderitemsessionpercentage NUMERIC trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report) trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_orderitemsessionpercentageb2b NUMERIC (Deprecated) trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report) trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviews NUMERIC trafficByAsin-pageViews (get_sales_and_traffic_report) trafficByAsin-pageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewsb2b NUMERIC trafficByAsin-pageViewsB2B (get_sales_and_traffic_report) trafficByAsin-pageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewspercentage NUMERIC trafficByAsin-pageViewsPercentage (get_sales_and_traffic_report) trafficByAsin-pageViewsPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_pageviewspercentageb2b NUMERIC trafficByAsin-pageViewsPercentageB2B (get_sales_and_traffic_report) trafficByAsin-pageViewsPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_receivednegativefeedbackrate TEXT trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report) trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionpercentage NUMERIC trafficByAsin-sessionPercentage (get_sales_and_traffic_report) trafficByAsin-sessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionpercentageb2b NUMERIC trafficByAsin-sessionPercentageB2B (get_sales_and_traffic_report) trafficByAsin-sessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessions NUMERIC trafficByAsin-sessions (get_sales_and_traffic_report) trafficByAsin-sessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_sessionsb2b NUMERIC trafficByAsin-sessionsB2B (get_sales_and_traffic_report) trafficByAsin-sessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentage NUMERIC trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report) trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentageb2b NUMERIC trafficByAsin-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)

ID Type Name Description
sales_and_traffic_report_by_date__date DATE date (get_sales_and_traffic_report) date (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_amount NUMERIC salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report) salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_currencycode TEXT salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report) salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_amount NUMERIC salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report) salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_currencycode TEXT salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report) salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingprice_amount NUMERIC salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report) salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingprice_currencycode TEXT salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report) salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_amount NUMERIC salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report) salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_currencycode TEXT salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report) salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitem NUMERIC salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report) salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitemb2b NUMERIC salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report) salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_claimsamount_amount TEXT salesByDate-claimsAmount-amount (get_sales_and_traffic_report) salesByDate-claimsAmount-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_claimsamount_currencycode TEXT salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report) salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_claimsgranted TEXT salesByDate-claimsGranted (get_sales_and_traffic_report) salesByDate-claimsGranted (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsales_amount NUMERIC salesByDate-orderedProductSales-amount (get_sales_and_traffic_report) salesByDate-orderedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsales_currencycode TEXT salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report) salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_amount NUMERIC salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report) salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_currencycode TEXT salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report) salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_ordersshipped NUMERIC salesByDate-ordersShipped (get_sales_and_traffic_report) salesByDate-ordersShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_refundrate NUMERIC salesByDate-refundRate (get_sales_and_traffic_report) salesByDate-refundRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_shippedproductsales_amount NUMERIC salesByDate-shippedProductSales-amount (get_sales_and_traffic_report) salesByDate-shippedProductSales-amount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_shippedproductsales_currencycode TEXT salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report) salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_totalorderitems NUMERIC salesByDate-totalOrderItems (get_sales_and_traffic_report) salesByDate-totalOrderItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_totalorderitemsb2b NUMERIC salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report) salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsordered NUMERIC salesByDate-unitsOrdered (get_sales_and_traffic_report) salesByDate-unitsOrdered (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsorderedb2b NUMERIC salesByDate-unitsOrderedB2B (get_sales_and_traffic_report) salesByDate-unitsOrderedB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsrefunded NUMERIC salesByDate-unitsRefunded (get_sales_and_traffic_report) salesByDate-unitsRefunded (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__salesbydate_unitsshipped NUMERIC salesByDate-unitsShipped (get_sales_and_traffic_report) salesByDate-unitsShipped (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_averageoffercount NUMERIC trafficByDate-averageOfferCount (get_sales_and_traffic_report) trafficByDate-averageOfferCount (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_averageparentitems NUMERIC trafficByDate-averageParentItems (get_sales_and_traffic_report) trafficByDate-averageParentItems (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browserpageviews NUMERIC trafficByDate-browserPageViews (get_sales_and_traffic_report) trafficByDate-browserPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browserpageviewsb2b NUMERIC trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report) trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browsersessions NUMERIC trafficByDate-browserSessions (get_sales_and_traffic_report) trafficByDate-browserSessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_browsersessionsb2b NUMERIC trafficByDate-browserSessionsB2B (get_sales_and_traffic_report) trafficByDate-browserSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_buyboxpercentage NUMERIC trafficByDate-buyBoxPercentage (get_sales_and_traffic_report) trafficByDate-buyBoxPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_buyboxpercentageb2b NUMERIC trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report) trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_feedbackreceived TEXT trafficByDate-feedbackReceived (get_sales_and_traffic_report) trafficByDate-feedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_mobileapppageviews NUMERIC trafficByDate-mobileAppPageViews (get_sales_and_traffic_report) trafficByDate-mobileAppPageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_mobileapppageviewsb2b NUMERIC trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report) trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_mobileappsessions NUMERIC trafficByDate-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)

ID Type Name Description
sales_and_traffic_report_by_date__trafficbydate_mobileappsessionsb2b NUMERIC trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report) trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_negativefeedbackreceived TEXT trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report) trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentage NUMERIC trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report) trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentageb2b NUMERIC trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report) trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_pageviews NUMERIC trafficByDate-pageViews (get_sales_and_traffic_report) trafficByDate-pageViews (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_pageviewsb2b NUMERIC trafficByDate-pageViewsB2B (get_sales_and_traffic_report) trafficByDate-pageViewsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_receivednegativefeedbackrate TEXT trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report) trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_sessions NUMERIC trafficByDate-sessions (get_sales_and_traffic_report) trafficByDate-sessions (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_sessionsb2b NUMERIC trafficByDate-sessionsB2B (get_sales_and_traffic_report) trafficByDate-sessionsB2B (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentage NUMERIC trafficByDate-unitSessionPercentage (get_sales_and_traffic_report) trafficByDate-unitSessionPercentage (get_sales_and_traffic_report)
sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentageb2b NUMERIC trafficByDate-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)

ID Type Name Description
v2_seller_performance_report__account_status TEXT account-status (get_v2_seller_performance_report) account-status (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_ahrscore NUMERIC accountHealthRating-ahrScore (get_v2_seller_performance_report) accountHealthRating-ahrScore (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_ahrstatus TEXT accountHealthRating-ahrStatus (get_v2_seller_performance_report) accountHealthRating-ahrStatus (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_reportingdaterange_reportingdatefrom TEXT accountHealthRating-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) accountHealthRating-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__accounthealthrating_reportingdaterange_reportingdateto TEXT accountHealthRating-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) accountHealthRating-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_defectscount NUMERIC customerProductReviewsPolicyViolations-defectsCount (get_v2_seller_performance_report) customerProductReviewsPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_reportingdaterange_reportingdatefrom TEXT customerProductReviewsPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) customerProductReviewsPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_reportingdaterange_reportingdateto TEXT customerProductReviewsPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) customerProductReviewsPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_status TEXT customerProductReviewsPolicyViolations-status (get_v2_seller_performance_report) customerProductReviewsPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_targetcondition TEXT customerProductReviewsPolicyViolations-targetCondition (get_v2_seller_performance_report) customerProductReviewsPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__customerproductreviewspolicyviolations_targetvalue NUMERIC customerProductReviewsPolicyViolations-targetValue (get_v2_seller_performance_report) customerProductReviewsPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_defectscount NUMERIC documentRequests-defectsCount (get_v2_seller_performance_report) documentRequests-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_reportingdaterange_reportingdatefrom TEXT documentRequests-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) documentRequests-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_reportingdaterange_reportingdateto TEXT documentRequests-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) documentRequests-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_status TEXT documentRequests-status (get_v2_seller_performance_report) documentRequests-status (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_targetcondition TEXT documentRequests-targetCondition (get_v2_seller_performance_report) documentRequests-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__documentrequests_targetvalue NUMERIC documentRequests-targetValue (get_v2_seller_performance_report) documentRequests-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_defectscount NUMERIC foodAndProductSafetyIssues-defectsCount (get_v2_seller_performance_report) foodAndProductSafetyIssues-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_reportingdaterange_reportingdatefrom TEXT foodAndProductSafetyIssues-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) foodAndProductSafetyIssues-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_reportingdaterange_reportingdateto TEXT foodAndProductSafetyIssues-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) foodAndProductSafetyIssues-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_status TEXT foodAndProductSafetyIssues-status (get_v2_seller_performance_report) foodAndProductSafetyIssues-status (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_targetcondition TEXT foodAndProductSafetyIssues-targetCondition (get_v2_seller_performance_report) foodAndProductSafetyIssues-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__foodandproductsafetyissues_targetvalue NUMERIC foodAndProductSafetyIssues-targetValue (get_v2_seller_performance_report) foodAndProductSafetyIssues-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_invoicedefect_count NUMERIC invoiceDefectRate-invoiceDefect-count (get_v2_seller_performance_report) invoiceDefectRate-invoiceDefect-count (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_invoicedefect_status TEXT invoiceDefectRate-invoiceDefect-status (get_v2_seller_performance_report) invoiceDefectRate-invoiceDefect-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_lateinvoice_count NUMERIC invoiceDefectRate-lateInvoice-count (get_v2_seller_performance_report) invoiceDefectRate-lateInvoice-count (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_lateinvoice_status TEXT invoiceDefectRate-lateInvoice-status (get_v2_seller_performance_report) invoiceDefectRate-lateInvoice-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_missinginvoice_count NUMERIC invoiceDefectRate-missingInvoice-count (get_v2_seller_performance_report) invoiceDefectRate-missingInvoice-count (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_missinginvoice_status TEXT invoiceDefectRate-missingInvoice-status (get_v2_seller_performance_report) invoiceDefectRate-missingInvoice-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_ordercount NUMERIC invoiceDefectRate-orderCount (get_v2_seller_performance_report) invoiceDefectRate-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_rate NUMERIC invoiceDefectRate-rate (get_v2_seller_performance_report) invoiceDefectRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_reportingdaterange_reportingdatefrom TEXT invoiceDefectRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) invoiceDefectRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_reportingdaterange_reportingdateto TEXT invoiceDefectRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) invoiceDefectRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_status TEXT invoiceDefectRate-status (get_v2_seller_performance_report) invoiceDefectRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_targetcondition TEXT invoiceDefectRate-targetCondition (get_v2_seller_performance_report) invoiceDefectRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__invoicedefectrate_targetvalue NUMERIC invoiceDefectRate-targetValue (get_v2_seller_performance_report) invoiceDefectRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_lateshipmentcount NUMERIC lateShipmentRate-lateShipmentCount (get_v2_seller_performance_report) lateShipmentRate-lateShipmentCount (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_ordercount NUMERIC lateShipmentRate-orderCount (get_v2_seller_performance_report) lateShipmentRate-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_rate NUMERIC lateShipmentRate-rate (get_v2_seller_performance_report) lateShipmentRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_reportingdaterange_reportingdatefrom TEXT lateShipmentRate-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)

ID Type Name Description
v2_seller_performance_report__lateshipmentrate_reportingdaterange_reportingdateto TEXT lateShipmentRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) lateShipmentRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_status TEXT lateShipmentRate-status (get_v2_seller_performance_report) lateShipmentRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_targetcondition TEXT lateShipmentRate-targetCondition (get_v2_seller_performance_report) lateShipmentRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__lateshipmentrate_targetvalue NUMERIC lateShipmentRate-targetValue (get_v2_seller_performance_report) lateShipmentRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_defectscount NUMERIC listingPolicyViolations-defectsCount (get_v2_seller_performance_report) listingPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_reportingdaterange_reportingdatefrom TEXT listingPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) listingPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_reportingdaterange_reportingdateto TEXT listingPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) listingPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_status TEXT listingPolicyViolations-status (get_v2_seller_performance_report) listingPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_targetcondition TEXT listingPolicyViolations-targetCondition (get_v2_seller_performance_report) listingPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__listingpolicyviolations_targetvalue NUMERIC listingPolicyViolations-targetValue (get_v2_seller_performance_report) listingPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__marketplaceid TEXT marketplaceId (get_v2_seller_performance_report) marketplaceId (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_ontimedeliverycount NUMERIC onTimeDeliveryRate-onTimeDeliveryCount (get_v2_seller_performance_report) onTimeDeliveryRate-onTimeDeliveryCount (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_rate NUMERIC onTimeDeliveryRate-rate (get_v2_seller_performance_report) onTimeDeliveryRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_reportingdaterange_reportingdatefrom TEXT onTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) onTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_reportingdaterange_reportingdateto TEXT onTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) onTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_shipmentcountwithvalidtracking NUMERIC onTimeDeliveryRate-shipmentCountWithValidTracking (get_v2_seller_performance_report) onTimeDeliveryRate-shipmentCountWithValidTracking (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_status TEXT onTimeDeliveryRate-status (get_v2_seller_performance_report) onTimeDeliveryRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_targetcondition TEXT onTimeDeliveryRate-targetCondition (get_v2_seller_performance_report) onTimeDeliveryRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__ontimedeliveryrate_targetvalue NUMERIC onTimeDeliveryRate-targetValue (get_v2_seller_performance_report) onTimeDeliveryRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_chargebacks_count NUMERIC orderDefectRate-afn-chargebacks-count (get_v2_seller_performance_report) orderDefectRate-afn-chargebacks-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_chargebacks_status TEXT orderDefectRate-afn-chargebacks-status (get_v2_seller_performance_report) orderDefectRate-afn-chargebacks-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_claims_count NUMERIC orderDefectRate-afn-claims-count (get_v2_seller_performance_report) orderDefectRate-afn-claims-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_claims_status TEXT orderDefectRate-afn-claims-status (get_v2_seller_performance_report) orderDefectRate-afn-claims-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_fulfillmenttype TEXT orderDefectRate-afn-fulfillmentType (get_v2_seller_performance_report) orderDefectRate-afn-fulfillmentType (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_negativefeedback_count NUMERIC orderDefectRate-afn-negativeFeedback-count (get_v2_seller_performance_report) orderDefectRate-afn-negativeFeedback-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_negativefeedback_status TEXT orderDefectRate-afn-negativeFeedback-status (get_v2_seller_performance_report) orderDefectRate-afn-negativeFeedback-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_ordercount NUMERIC orderDefectRate-afn-orderCount (get_v2_seller_performance_report) orderDefectRate-afn-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_orderwithdefects_count NUMERIC orderDefectRate-afn-orderWithDefects-count (get_v2_seller_performance_report) orderDefectRate-afn-orderWithDefects-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_orderwithdefects_status TEXT orderDefectRate-afn-orderWithDefects-status (get_v2_seller_performance_report) orderDefectRate-afn-orderWithDefects-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_rate NUMERIC orderDefectRate-afn-rate (get_v2_seller_performance_report) orderDefectRate-afn-rate (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_reportingdaterange_reportingdatefrom TEXT orderDefectRate-afn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) orderDefectRate-afn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_reportingdaterange_reportingdateto TEXT orderDefectRate-afn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) orderDefectRate-afn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_status TEXT orderDefectRate-afn-status (get_v2_seller_performance_report) orderDefectRate-afn-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_targetcondition TEXT orderDefectRate-afn-targetCondition (get_v2_seller_performance_report) orderDefectRate-afn-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_afn_targetvalue NUMERIC orderDefectRate-afn-targetValue (get_v2_seller_performance_report) orderDefectRate-afn-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_chargebacks_count NUMERIC orderDefectRate-mfn-chargebacks-count (get_v2_seller_performance_report) orderDefectRate-mfn-chargebacks-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_chargebacks_status TEXT orderDefectRate-mfn-chargebacks-status (get_v2_seller_performance_report) orderDefectRate-mfn-chargebacks-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_claims_count NUMERIC orderDefectRate-mfn-claims-count (get_v2_seller_performance_report) orderDefectRate-mfn-claims-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_claims_status TEXT orderDefectRate-mfn-claims-status (get_v2_seller_performance_report) orderDefectRate-mfn-claims-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_fulfillmenttype TEXT orderDefectRate-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)

ID Type Name Description
v2_seller_performance_report__orderdefectrate_mfn_negativefeedback_count NUMERIC orderDefectRate-mfn-negativeFeedback-count (get_v2_seller_performance_report) orderDefectRate-mfn-negativeFeedback-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_negativefeedback_status TEXT orderDefectRate-mfn-negativeFeedback-status (get_v2_seller_performance_report) orderDefectRate-mfn-negativeFeedback-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_ordercount NUMERIC orderDefectRate-mfn-orderCount (get_v2_seller_performance_report) orderDefectRate-mfn-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_orderwithdefects_count NUMERIC orderDefectRate-mfn-orderWithDefects-count (get_v2_seller_performance_report) orderDefectRate-mfn-orderWithDefects-count (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_orderwithdefects_status TEXT orderDefectRate-mfn-orderWithDefects-status (get_v2_seller_performance_report) orderDefectRate-mfn-orderWithDefects-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_rate NUMERIC orderDefectRate-mfn-rate (get_v2_seller_performance_report) orderDefectRate-mfn-rate (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_reportingdaterange_reportingdatefrom TEXT orderDefectRate-mfn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) orderDefectRate-mfn-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_reportingdaterange_reportingdateto TEXT orderDefectRate-mfn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) orderDefectRate-mfn-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_status TEXT orderDefectRate-mfn-status (get_v2_seller_performance_report) orderDefectRate-mfn-status (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_targetcondition TEXT orderDefectRate-mfn-targetCondition (get_v2_seller_performance_report) orderDefectRate-mfn-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__orderdefectrate_mfn_targetvalue NUMERIC orderDefectRate-mfn-targetValue (get_v2_seller_performance_report) orderDefectRate-mfn-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_defectscount NUMERIC otherPolicyViolations-defectsCount (get_v2_seller_performance_report) otherPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_reportingdaterange_reportingdatefrom TEXT otherPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) otherPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_reportingdaterange_reportingdateto TEXT otherPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) otherPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_status TEXT otherPolicyViolations-status (get_v2_seller_performance_report) otherPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_targetcondition TEXT otherPolicyViolations-targetCondition (get_v2_seller_performance_report) otherPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__otherpolicyviolations_targetvalue NUMERIC otherPolicyViolations-targetValue (get_v2_seller_performance_report) otherPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__policyviolationwarnings_reportingdaterange_reportingdatefrom TEXT policyViolationWarnings-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) policyViolationWarnings-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__policyviolationwarnings_reportingdaterange_reportingdateto TEXT policyViolationWarnings-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) policyViolationWarnings-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__policyviolationwarnings_warningscount NUMERIC policyViolationWarnings-warningsCount (get_v2_seller_performance_report) policyViolationWarnings-warningsCount (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_cancellationcount NUMERIC preFulfillmentCancellationRate-cancellationCount (get_v2_seller_performance_report) preFulfillmentCancellationRate-cancellationCount (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_ordercount NUMERIC preFulfillmentCancellationRate-orderCount (get_v2_seller_performance_report) preFulfillmentCancellationRate-orderCount (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_rate NUMERIC preFulfillmentCancellationRate-rate (get_v2_seller_performance_report) preFulfillmentCancellationRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_reportingdaterange_reportingdatefrom TEXT preFulfillmentCancellationRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) preFulfillmentCancellationRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_reportingdaterange_reportingdateto TEXT preFulfillmentCancellationRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) preFulfillmentCancellationRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_status TEXT preFulfillmentCancellationRate-status (get_v2_seller_performance_report) preFulfillmentCancellationRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_targetcondition TEXT preFulfillmentCancellationRate-targetCondition (get_v2_seller_performance_report) preFulfillmentCancellationRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__prefulfillmentcancellationrate_targetvalue NUMERIC preFulfillmentCancellationRate-targetValue (get_v2_seller_performance_report) preFulfillmentCancellationRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_defectscount NUMERIC productAuthenticityCustomerComplaints-defectsCount (get_v2_seller_performance_report) productAuthenticityCustomerComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_reportingdaterange_reportingdatefrom TEXT productAuthenticityCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) productAuthenticityCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_reportingdaterange_reportingdateto TEXT productAuthenticityCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) productAuthenticityCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_status TEXT productAuthenticityCustomerComplaints-status (get_v2_seller_performance_report) productAuthenticityCustomerComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_targetcondition TEXT productAuthenticityCustomerComplaints-targetCondition (get_v2_seller_performance_report) productAuthenticityCustomerComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__productauthenticitycustomercomplaints_targetvalue NUMERIC productAuthenticityCustomerComplaints-targetValue (get_v2_seller_performance_report) productAuthenticityCustomerComplaints-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_defectscount NUMERIC productConditionCustomerComplaints-defectsCount (get_v2_seller_performance_report) productConditionCustomerComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_reportingdaterange_reportingdatefrom TEXT productConditionCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) productConditionCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_reportingdaterange_reportingdateto TEXT productConditionCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) productConditionCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_status TEXT productConditionCustomerComplaints-status (get_v2_seller_performance_report) productConditionCustomerComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_targetcondition TEXT productConditionCustomerComplaints-targetCondition (get_v2_seller_performance_report) productConditionCustomerComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__productconditioncustomercomplaints_targetvalue NUMERIC productConditionCustomerComplaints-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)

ID Type Name Description
v2_seller_performance_report__productsafetycustomercomplaints_defectscount NUMERIC productSafetyCustomerComplaints-defectsCount (get_v2_seller_performance_report) productSafetyCustomerComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_reportingdaterange_reportingdatefrom TEXT productSafetyCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) productSafetyCustomerComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_reportingdaterange_reportingdateto TEXT productSafetyCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) productSafetyCustomerComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_status TEXT productSafetyCustomerComplaints-status (get_v2_seller_performance_report) productSafetyCustomerComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_targetcondition TEXT productSafetyCustomerComplaints-targetCondition (get_v2_seller_performance_report) productSafetyCustomerComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__productsafetycustomercomplaints_targetvalue NUMERIC productSafetyCustomerComplaints-targetValue (get_v2_seller_performance_report) productSafetyCustomerComplaints-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_defectscount NUMERIC receivedIntellectualPropertyComplaints-defectsCount (get_v2_seller_performance_report) receivedIntellectualPropertyComplaints-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_reportingdaterange_reportingdatefrom TEXT receivedIntellectualPropertyComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) receivedIntellectualPropertyComplaints-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_reportingdaterange_reportingdateto TEXT receivedIntellectualPropertyComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) receivedIntellectualPropertyComplaints-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_status TEXT receivedIntellectualPropertyComplaints-status (get_v2_seller_performance_report) receivedIntellectualPropertyComplaints-status (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_targetcondition TEXT receivedIntellectualPropertyComplaints-targetCondition (get_v2_seller_performance_report) receivedIntellectualPropertyComplaints-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__receivedintellectualpropertycomplaints_targetvalue NUMERIC receivedIntellectualPropertyComplaints-targetValue (get_v2_seller_performance_report) receivedIntellectualPropertyComplaints-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_defectscount NUMERIC restrictedProductPolicyViolations-defectsCount (get_v2_seller_performance_report) restrictedProductPolicyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_reportingdaterange_reportingdatefrom TEXT restrictedProductPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) restrictedProductPolicyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_reportingdaterange_reportingdateto TEXT restrictedProductPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) restrictedProductPolicyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_status TEXT restrictedProductPolicyViolations-status (get_v2_seller_performance_report) restrictedProductPolicyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_targetcondition TEXT restrictedProductPolicyViolations-targetCondition (get_v2_seller_performance_report) restrictedProductPolicyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__restrictedproductpolicyviolations_targetvalue NUMERIC restrictedProductPolicyViolations-targetValue (get_v2_seller_performance_report) restrictedProductPolicyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_defectscount NUMERIC suspectedIntellectualPropertyViolations-defectsCount (get_v2_seller_performance_report) suspectedIntellectualPropertyViolations-defectsCount (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_reportingdaterange_reportingdatefrom TEXT suspectedIntellectualPropertyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) suspectedIntellectualPropertyViolations-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_reportingdaterange_reportingdateto TEXT suspectedIntellectualPropertyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) suspectedIntellectualPropertyViolations-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_status TEXT suspectedIntellectualPropertyViolations-status (get_v2_seller_performance_report) suspectedIntellectualPropertyViolations-status (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_targetcondition TEXT suspectedIntellectualPropertyViolations-targetCondition (get_v2_seller_performance_report) suspectedIntellectualPropertyViolations-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__suspectedintellectualpropertyviolations_targetvalue NUMERIC suspectedIntellectualPropertyViolations-targetValue (get_v2_seller_performance_report) suspectedIntellectualPropertyViolations-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_rate NUMERIC unitOnTimeDeliveryRate-rate (get_v2_seller_performance_report) unitOnTimeDeliveryRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_reportingdaterange_reportingdatefrom TEXT unitOnTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) unitOnTimeDeliveryRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_reportingdaterange_reportingdateto TEXT unitOnTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) unitOnTimeDeliveryRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_status TEXT unitOnTimeDeliveryRate-status (get_v2_seller_performance_report) unitOnTimeDeliveryRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_targetcondition TEXT unitOnTimeDeliveryRate-targetCondition (get_v2_seller_performance_report) unitOnTimeDeliveryRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_targetvalue NUMERIC unitOnTimeDeliveryRate-targetValue (get_v2_seller_performance_report) unitOnTimeDeliveryRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_totalunitcount NUMERIC unitOnTimeDeliveryRate-totalUnitCount (get_v2_seller_performance_report) unitOnTimeDeliveryRate-totalUnitCount (get_v2_seller_performance_report)
v2_seller_performance_report__unitontimedeliveryrate_unitontimedeliverycount NUMERIC unitOnTimeDeliveryRate-unitOnTimeDeliveryCount (get_v2_seller_performance_report) unitOnTimeDeliveryRate-unitOnTimeDeliveryCount (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_rate NUMERIC validTrackingRate-rate (get_v2_seller_performance_report) validTrackingRate-rate (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_reportingdaterange_reportingdatefrom TEXT validTrackingRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report) validTrackingRate-reportingDateRange-reportingDateFrom (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_reportingdaterange_reportingdateto TEXT validTrackingRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report) validTrackingRate-reportingDateRange-reportingDateTo (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_shipmentcount NUMERIC validTrackingRate-shipmentCount (get_v2_seller_performance_report) validTrackingRate-shipmentCount (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_status TEXT validTrackingRate-status (get_v2_seller_performance_report) validTrackingRate-status (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_targetcondition TEXT validTrackingRate-targetCondition (get_v2_seller_performance_report) validTrackingRate-targetCondition (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_targetvalue NUMERIC validTrackingRate-targetValue (get_v2_seller_performance_report) validTrackingRate-targetValue (get_v2_seller_performance_report)
v2_seller_performance_report__validtrackingrate_validtrackingcount NUMERIC validTrackingRate-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 27 fields.

ID Type Name Description
v2_settlement_report_data_flat_file_v2__adjustment_id TEXT adjustment-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__amount NUMERIC amount (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_description TEXT amount-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_type TEXT amount-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__currency TEXT currency (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_date DATE deposit-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_id TEXT fulfillment-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_name TEXT marketplace-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_id TEXT merchant-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_id TEXT merchant-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_id TEXT merchant-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_id TEXT order-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_code TEXT order-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_date DATE posted-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_time TEXT posted-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_id TEXT promotion-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_purchased NUMERIC quantity-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__report_id TEXT report-id (get_v2_settlement_report_data_flat_file_v2) report-id (get_v2_settlement_report_data_flat_file_v2)
v2_settlement_report_data_flat_file_v2__settlement_end_date DATE settlement-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_id TEXT settlement-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_date DATE settlement-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_id TEXT shipment-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__sku TEXT sku (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_amount NUMERIC total-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_date DATE transaction-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_status TEXT transaction-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_type TEXT transaction-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)

ID Type Name Description
vat_transaction_data__activity_period DATE ACTIVITY_PERIOD (get_vat_transaction_data) ACTIVITY_PERIOD (get_vat_transaction_data)
vat_transaction_data__activity_transaction_id TEXT ACTIVITY_TRANSACTION_ID (get_vat_transaction_data) ACTIVITY_TRANSACTION_ID (get_vat_transaction_data)
vat_transaction_data__arrival_address TEXT ARRIVAL_ADDRESS (get_vat_transaction_data) ARRIVAL_ADDRESS (get_vat_transaction_data)
vat_transaction_data__arrival_city CITY ARRIVAL_CITY (get_vat_transaction_data) ARRIVAL_CITY (get_vat_transaction_data)
vat_transaction_data__arrival_country COUNTRY ARRIVAL_COUNTRY (get_vat_transaction_data) ARRIVAL_COUNTRY (get_vat_transaction_data)
vat_transaction_data__arrival_post_code TEXT ARRIVAL_POST_CODE (get_vat_transaction_data) ARRIVAL_POST_CODE (get_vat_transaction_data)
vat_transaction_data__asin TEXT ASIN (get_vat_transaction_data) ASIN (get_vat_transaction_data)
vat_transaction_data__buyer_name TEXT BUYER_NAME (get_vat_transaction_data) BUYER_NAME (get_vat_transaction_data)
vat_transaction_data__buyer_vat_number TEXT BUYER_VAT_NUMBER (get_vat_transaction_data) BUYER_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__buyer_vat_number_country COUNTRY BUYER_VAT_NUMBER_COUNTRY (get_vat_transaction_data) BUYER_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__commodity_code TEXT COMMODITY_CODE (get_vat_transaction_data) COMMODITY_CODE (get_vat_transaction_data)
vat_transaction_data__commodity_code_supplementary_unit TEXT COMMODITY_CODE_SUPPLEMENTARY_UNIT (get_vat_transaction_data) COMMODITY_CODE_SUPPLEMENTARY_UNIT (get_vat_transaction_data)
vat_transaction_data__cost_price_of_items NUMERIC COST_PRICE_OF_ITEMS (get_vat_transaction_data) COST_PRICE_OF_ITEMS (get_vat_transaction_data)
vat_transaction_data__delivery_conditions TEXT DELIVERY_CONDITIONS (get_vat_transaction_data) DELIVERY_CONDITIONS (get_vat_transaction_data)
vat_transaction_data__departure_country COUNTRY DEPARTURE_COUNTRY (get_vat_transaction_data) DEPARTURE_COUNTRY (get_vat_transaction_data)
vat_transaction_data__departure_post_code TEXT DEPARTURE_POST_CODE (get_vat_transaction_data) DEPARTURE_POST_CODE (get_vat_transaction_data)
vat_transaction_data__depature_city CITY DEPATURE_CITY (get_vat_transaction_data) DEPATURE_CITY (get_vat_transaction_data)
vat_transaction_data__export_outside_eu TEXT EXPORT_OUTSIDE_EU (get_vat_transaction_data) EXPORT_OUTSIDE_EU (get_vat_transaction_data)
vat_transaction_data__gift_wrap_amt_vat_excl NUMERIC GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__gift_wrap_amt_vat_incl NUMERIC GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__gift_wrap_vat_amt NUMERIC GIFT_WRAP_VAT_AMT (get_vat_transaction_data) GIFT_WRAP_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__gift_wrap_vat_rate_percent NUMERIC GIFT_WRAP_VAT_RATE_PERCENT (get_vat_transaction_data) GIFT_WRAP_VAT_RATE_PERCENT (get_vat_transaction_data)
vat_transaction_data__invoice_url TEXT INVOICE_URL (get_vat_transaction_data) INVOICE_URL (get_vat_transaction_data)
vat_transaction_data__item_description TEXT ITEM_DESCRIPTION (get_vat_transaction_data) ITEM_DESCRIPTION (get_vat_transaction_data)
vat_transaction_data__item_manufacture_country COUNTRY ITEM_MANUFACTURE_COUNTRY (get_vat_transaction_data) ITEM_MANUFACTURE_COUNTRY (get_vat_transaction_data)
vat_transaction_data__item_qty_supplementary_unit NUMERIC ITEM_QTY_SUPPLEMENTARY_UNIT (get_vat_transaction_data) ITEM_QTY_SUPPLEMENTARY_UNIT (get_vat_transaction_data)
vat_transaction_data__item_weight NUMERIC ITEM_WEIGHT (get_vat_transaction_data) ITEM_WEIGHT (get_vat_transaction_data)
vat_transaction_data__marketplace TEXT MARKETPLACE (get_vat_transaction_data) MARKETPLACE (get_vat_transaction_data)
vat_transaction_data__price_of_items_amt_vat_excl NUMERIC PRICE_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_incl NUMERIC PRICE_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_amt NUMERIC PRICE_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_percent NUMERIC PRICE_OF_ITEMS_VAT_RATE_PERCENT (get_vat_transaction_data) PRICE_OF_ITEMS_VAT_RATE_PERCENT (get_vat_transaction_data)
vat_transaction_data__product_tax_code TEXT PRODUCT_TAX_CODE (get_vat_transaction_data) PRODUCT_TAX_CODE (get_vat_transaction_data)
vat_transaction_data__program_type TEXT PROGRAM_TYPE (get_vat_transaction_data) PROGRAM_TYPE (get_vat_transaction_data)
vat_transaction_data__promo_gift_wrap_amt_vat_excl NUMERIC PROMO_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_incl NUMERIC PROMO_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_amt NUMERIC PROMO_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_excl NUMERIC PROMO_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_incl NUMERIC PROMO_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_amt NUMERIC PROMO_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)

ID Type Name Description
vat_transaction_data__promo_ship_charge_amt_vat_excl NUMERIC PROMO_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_incl NUMERIC PROMO_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_amt NUMERIC PROMO_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) PROMO_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__qty NUMERIC QTY (get_vat_transaction_data) QTY (get_vat_transaction_data)
vat_transaction_data__sale_arrival_country COUNTRY SALE_ARRIVAL_COUNTRY (get_vat_transaction_data) SALE_ARRIVAL_COUNTRY (get_vat_transaction_data)
vat_transaction_data__sale_depart_country COUNTRY SALE_DEPART_COUNTRY (get_vat_transaction_data) SALE_DEPART_COUNTRY (get_vat_transaction_data)
vat_transaction_data__sales_channel TEXT SALES_CHANNEL (get_vat_transaction_data) SALES_CHANNEL (get_vat_transaction_data)
vat_transaction_data__seller_arrival_country_vat_number TEXT SELLER_ARRIVAL_COUNTRY_VAT_NUMBER (get_vat_transaction_data) SELLER_ARRIVAL_COUNTRY_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__seller_arrival_vat_number_country COUNTRY SELLER_ARRIVAL_VAT_NUMBER_COUNTRY (get_vat_transaction_data) SELLER_ARRIVAL_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__seller_depart_country_vat_number TEXT SELLER_DEPART_COUNTRY_VAT_NUMBER (get_vat_transaction_data) SELLER_DEPART_COUNTRY_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__seller_depart_vat_number_country COUNTRY SELLER_DEPART_VAT_NUMBER_COUNTRY (get_vat_transaction_data) SELLER_DEPART_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__seller_sku TEXT SELLER_SKU (get_vat_transaction_data) SELLER_SKU (get_vat_transaction_data)
vat_transaction_data__ship_charge_amt_vat_excl NUMERIC SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data)
vat_transaction_data__ship_charge_amt_vat_incl NUMERIC SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data)
vat_transaction_data__ship_charge_vat_amt NUMERIC SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__ship_charge_vat_rate_percent NUMERIC SHIP_CHARGE_VAT_RATE_PERCENT (get_vat_transaction_data) SHIP_CHARGE_VAT_RATE_PERCENT (get_vat_transaction_data)
vat_transaction_data__statistical_code_arrival TEXT STATISTICAL_CODE_ARRIVAL (get_vat_transaction_data) STATISTICAL_CODE_ARRIVAL (get_vat_transaction_data)
vat_transaction_data__statistical_code_depart TEXT STATISTICAL_CODE_DEPART (get_vat_transaction_data) STATISTICAL_CODE_DEPART (get_vat_transaction_data)
vat_transaction_data__supplier_name TEXT SUPPLIER_NAME (get_vat_transaction_data) SUPPLIER_NAME (get_vat_transaction_data)
vat_transaction_data__supplier_vat_number TEXT SUPPLIER_VAT_NUMBER (get_vat_transaction_data) SUPPLIER_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__tax_calculation_date DATE TAX_CALCULATION_DATE (get_vat_transaction_data) TAX_CALCULATION_DATE (get_vat_transaction_data)
vat_transaction_data__tax_collection_responsibility TEXT TAX_COLLECTION_RESPONSIBILITY (get_vat_transaction_data) TAX_COLLECTION_RESPONSIBILITY (get_vat_transaction_data)
vat_transaction_data__tax_reporting_scheme TEXT TAX_REPORTING_SCHEME (get_vat_transaction_data) TAX_REPORTING_SCHEME (get_vat_transaction_data)
vat_transaction_data__taxable_jurisdiction TEXT TAXABLE_JURISDICTION (get_vat_transaction_data) TAXABLE_JURISDICTION (get_vat_transaction_data)
vat_transaction_data__taxable_jurisdiction_level TEXT TAXABLE_JURISDICTION_LEVEL (get_vat_transaction_data) TAXABLE_JURISDICTION_LEVEL (get_vat_transaction_data)
vat_transaction_data__total_activity_supplementary_unit NUMERIC TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT (get_vat_transaction_data) TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT (get_vat_transaction_data)
vat_transaction_data__total_activity_value_amt_vat_excl NUMERIC TOTAL_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_incl NUMERIC TOTAL_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_amt NUMERIC TOTAL_ACTIVITY_VALUE_VAT_AMT (get_vat_transaction_data) TOTAL_ACTIVITY_VALUE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__total_activity_weight NUMERIC TOTAL_ACTIVITY_WEIGHT (get_vat_transaction_data) TOTAL_ACTIVITY_WEIGHT (get_vat_transaction_data)
vat_transaction_data__total_gift_wrap_amt_vat_excl NUMERIC TOTAL_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_incl NUMERIC TOTAL_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_amt NUMERIC TOTAL_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_excl NUMERIC TOTAL_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_incl NUMERIC TOTAL_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_amt NUMERIC TOTAL_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_excl NUMERIC TOTAL_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_incl NUMERIC TOTAL_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_amt NUMERIC TOTAL_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) TOTAL_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data)
vat_transaction_data__transaction_arrival_date DATE TRANSACTION_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)

ID Type Name Description
vat_transaction_data__transaction_complete_date DATE TRANSACTION_COMPLETE_DATE (get_vat_transaction_data) TRANSACTION_COMPLETE_DATE (get_vat_transaction_data)
vat_transaction_data__transaction_currency_code TEXT TRANSACTION_CURRENCY_CODE (get_vat_transaction_data) TRANSACTION_CURRENCY_CODE (get_vat_transaction_data)
vat_transaction_data__transaction_depart_date DATE TRANSACTION_DEPART_DATE (get_vat_transaction_data) TRANSACTION_DEPART_DATE (get_vat_transaction_data)
vat_transaction_data__transaction_event_id TEXT TRANSACTION_EVENT_ID (get_vat_transaction_data) TRANSACTION_EVENT_ID (get_vat_transaction_data)
vat_transaction_data__transaction_seller_vat_number TEXT TRANSACTION_SELLER_VAT_NUMBER (get_vat_transaction_data) TRANSACTION_SELLER_VAT_NUMBER (get_vat_transaction_data)
vat_transaction_data__transaction_seller_vat_number_country COUNTRY TRANSACTION_SELLER_VAT_NUMBER_COUNTRY (get_vat_transaction_data) TRANSACTION_SELLER_VAT_NUMBER_COUNTRY (get_vat_transaction_data)
vat_transaction_data__transaction_type TEXT TRANSACTION_TYPE (get_vat_transaction_data) TRANSACTION_TYPE (get_vat_transaction_data)
vat_transaction_data__transportation_mode TEXT TRANSPORTATION_MODE (get_vat_transaction_data) TRANSPORTATION_MODE (get_vat_transaction_data)
vat_transaction_data__unique_account_identifier TEXT UNIQUE_ACCOUNT_IDENTIFIER (get_vat_transaction_data) UNIQUE_ACCOUNT_IDENTIFIER (get_vat_transaction_data)
vat_transaction_data__vat_calculation_imputation_country COUNTRY VAT_CALCULATION_IMPUTATION_COUNTRY (get_vat_transaction_data) VAT_CALCULATION_IMPUTATION_COUNTRY (get_vat_transaction_data)
vat_transaction_data__vat_inv_converted_amt NUMERIC VAT_INV_CONVERTED_AMT (get_vat_transaction_data) VAT_INV_CONVERTED_AMT (get_vat_transaction_data)
vat_transaction_data__vat_inv_currency_code TEXT VAT_INV_CURRENCY_CODE (get_vat_transaction_data) VAT_INV_CURRENCY_CODE (get_vat_transaction_data)
vat_transaction_data__vat_inv_exchange_rate NUMERIC VAT_INV_EXCHANGE_RATE (get_vat_transaction_data) VAT_INV_EXCHANGE_RATE (get_vat_transaction_data)
vat_transaction_data__vat_inv_exchange_rate_date DATE VAT_INV_EXCHANGE_RATE_DATE (get_vat_transaction_data) VAT_INV_EXCHANGE_RATE_DATE (get_vat_transaction_data)
vat_transaction_data__vat_inv_number TEXT VAT_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.

ID Type Name Description Report
account_id TEXT Account ID The account ID
account_name TEXT Account Name The account name
data_fetched_at TIMESTAMP Data fetched at UTC 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.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date Date to which metrics apply
day_of_month TEXT Day of month Day of the month
marketplace_country COUNTRY Marketplace Country The Marketplace Country
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20