Sample

https://connectors.windsor.ai/amazon_mws?api_key=[your API key]&date_preset=last_7d&fields=date,product,transactions,transactionrevenue,marketplace,item_status&_renderer=csv
The Amazon Seller Central / Amazon MWS connector lets you pull Amazon Seller Central data on a transaction level. If you specify the fields date_from and date_to it will filter for a date range in which the products were purchased.

Fields

IDTypeNameDescription
afn_fulfillable_quantityTEXTAfn Fulfillable QuantityAfn fulfillable quantity
afn_future_supply_buyableTEXTAfn Future Supply BuyableAfn future supply buyable
afn_inbound_receiving_quantityTEXTAfn Inbound Receiving QuantityAfn inbound receiving quantity
afn_inbound_shipped_quantityTEXTAfn Inbound Shipped QuantityAfn inbound shipped quantity
afn_inbound_working_quantityTEXTAfn Inbound Working QuantityAfn inbound working quantity
afn_listing_existsTEXTAfn Listing ExistsAfn listing exists
afn_researching_quantityTEXTAfn Researching QuantityAfn researching quantity
afn_reserved_future_supplyTEXTAfn Reserved Future SupplyAfn reserved future supply
afn_reserved_quantityTEXTAfn Reserved QuantityAfn reserved quantity
afn_total_quantityTEXTAfn Total QuantityAfn total quantity
afn_unsellable_quantityTEXTAfn Unsellable QuantityAfn unsellable quantity
afn_warehouse_quantityTEXTAfn Warehouse QuantityAfn warehouse quantity
amazon_order_idTEXTAmazon Order IDThe Amazon Order ID
amazon_order_item_idTEXTAmazon Order Item IdAmazon order item id
amount_per_unitNUMERICAmount Per UnitAmount per unit
amount_totalNUMERICAmount TotalAmount total
approval_dateTEXTApproval DateApproval date
asinTEXTASINAmazon Standard Identification Number, assigned by Amazon
asin_limitTEXTAsin LimitAsin limit
brandTEXTBrandBrand
buyer_emailTEXTBuyer EmailBuyer email
campaignTEXTProduct Group (duplicate)Product group (duplicate)
cancelled_quantityTEXTCancelled QuantityCancelled quantity
carrierTEXTCarrierCarrier
conditionTEXTConditionCondition
condition_typeTEXTCondition TypeCondition type
currencyTEXTCurrencyCurrency
currency_unitTEXTCurrency UnitCurrency unit
dateDATEDateThe Order Date
detailed_dispositionTEXTDetailed DispositionDetailed disposition
disposed_quantityNUMERICDisposed QuantityDisposed quantity
dispositionTEXTDispositionDisposition
estimated_arrival_dateTEXTEstimated Arrival DateEstimated arrival date
estimated_cost_savings_of_removalNUMERICEstimated Cost Savings of RemovalEstimated Cost Savings of Removal
estimated_fee_totalNUMERICEstimated Fee TotalEstimated fee total
estimated_monthly_storage_feeNUMERICEstimated Monthly Storage FeeEstimated Monthly Storage Fee
estimated_order_handling_fee_per_orderNUMERICEstimated Order Handling Fee Per OrderEstimated order handling fee per order
estimated_referral_fee_per_unitNUMERICEstimated Referral Fee Per UnitEstimated referral fee per unit
estimated_variable_closing_feeNUMERICEstimated Variable Closing FeeEstimated variable closing fee
expected_domestic_fulfilment_fee_per_unitNUMERICExpected Domestic Fulfilment Fee Per UnitExpected domestic fulfilment fee per unit
expected_efn_fulfilment_fee_per_unit_deNUMERICExpected Efn Fulfilment Fee Per Unit DeExpected efn fulfilment fee per unit de
expected_efn_fulfilment_fee_per_unit_esNUMERICExpected Efn Fulfilment Fee Per Unit EsExpected efn fulfilment fee per unit es
expected_efn_fulfilment_fee_per_unit_frNUMERICExpected Efn Fulfilment Fee Per Unit FrExpected efn fulfilment fee per unit fr
expected_efn_fulfilment_fee_per_unit_itNUMERICExpected Efn Fulfilment Fee Per Unit ItExpected efn fulfilment fee per unit it
expected_efn_fulfilment_fee_per_unit_seNUMERICExpected Efn Fulfilment Fee Per Unit SeExpected efn fulfilment fee per unit se
expected_efn_fulfilment_fee_per_unit_ukNUMERICExpected Efn Fulfilment Fee Per Unit UkExpected efn fulfilment fee per unit uk
fnskuTEXTASINThe Fulfillment Network SKU
fulfilled_byTEXTFulfilled ByFulfilled by
fulfillment_center_idTEXTFulfillment Center IdFulfillment center id
fulfillment_channelTEXTFulfillment ChannelThe Fulfillment Channel
fulfillment_channel_skuTEXTFulfillment Channel SkuFulfillment channel sku
gift_wrap_priceNUMERICGift Wrap PriceThe Price of the Gift Wrap
gift_wrap_taxNUMERICGift Wrap TaxThe Tax of the Gift Wrap
has_local_inventoryTEXTHas Local InventoryHas local inventory
in_bound_quantityTEXTIn Bound QuantityIn bound quantity
in_process_quantityNUMERICIn Process QuantityIn process quantity
inbound_recommend_quantityTEXTInbound Recommend QuantityInbound recommend quantity
inv_age_0_to_90_daysTEXTInv Age 0 To 90 DaysInv age 0 to 90 days
inv_age_181_to_270_daysTEXTInv Age 181 To 270 DaysInv age 181 to 270 days
inv_age_271_to_365_daysTEXTInv Age 271 To 365 DaysInv age 271 to 365 days
inv_age_365_plus_daysTEXTInv Age 365 Plus DaysInv age 365 plus days
inv_age_91_to_180_daysTEXTInv Age 91 To 180 DaysInv age 91 to 180 days
is_business_orderBOOLEANIs business orderWhether or not this is a business order
is_hazmatTEXTIs HazmatIs hazmat
is_sold_by_abBOOLEANSold by Amazon Business EU SARLIs true if the items in this order were bought and re-sold by Amazon Business EU SARL (ABEU)
item_package_weightTEXTItem Package WeightItem package weight
item_priceNUMERICItem PriceThe Price of the Item
item_promotion_discountTEXTItem Promotion DiscountItem promotion discount
item_statusTEXTItem StatusThe Status of the Item
item_taxNUMERICItem TaxThe Tax of the Item
last_updated_dateDATELast Updated DateLast Updated Date
length_and_girthTEXTLength And GirthLength and girth
license_plate_numberTEXTLicense Plate NumberLicense plate number
longest_sideTEXTLongest SideLongest side
lowest_afn_new_priceTEXTLowest Afn New PriceLowest afn new price
lowest_afn_used_priceTEXTLowest Afn Used PriceLowest afn used price
lowest_mfn_new_priceTEXTLowest Mfn New PriceLowest mfn new price
lowest_mfn_used_priceTEXTLowest Mfn Used PriceLowest mfn used price
marketplaceTEXTMarketplaceThe Amazon Seller Central Marketplace
marketplace_countryTEXTMarketplace CountryMarketplace country
median_sideTEXTMedian SideMedian side
merchant_order_idTEXTMerchant Order IDThe Merchant Order ID
mfn_fulfillable_quantityTEXTMfn Fulfillable QuantityMfn fulfillable quantity
mfn_listing_existsTEXTMfn Listing ExistsMfn listing exists
num_afn_new_sellersTEXTNum Afn New SellersNum afn new sellers
num_afn_used_sellersTEXTNum Afn Used SellersNum afn used sellers
order_channelTEXTOrder ChannelThe Order Channel
order_idTEXTOrder IdOrder id
order_statusTEXTOrder StatusThe Order Status
payments_dateTEXTPayments DatePayments date
per_unit_volumeTEXTPer Unit VolumePer unit volume
price_designationTEXTPrice DesignationThe Price Designation
productTEXTProduct NameThe Product Name
product_groupTEXTProduct GroupProduct group
product_nameTEXTProduct NameThe Product Name (Duplicate of Product)
product_size_weight_bandTEXTProduct Size Weight BandProduct size weight band
projected_ltsf_12_moTEXTProjected Ltsf 12 MoProjected ltsf 12 mo
projected_ltsf_6_moTEXTProjected Ltsf 6 MoProjected ltsf 6 mo
promotion_idsTEXTPromotion IDThe Promotion ID
purchase_dateDATEPurchase DatePurchase date
purchase_order_numberTEXTPurchaser Order NumberThe Purchaser Order Number
qty_in_long_term_storage_programTEXTQty In Long Term Storage ProgramQty in long term storage program
qty_to_be_charged_ltsf_12_moTEXTQty To Be Charged Ltsf 12 MoQty to be charged ltsf 12 mo
qty_to_be_charged_ltsf_6_moTEXTQty To Be Charged Ltsf 6 MoQty to be charged ltsf 6 mo
qty_with_removals_in_progressTEXTQty With Removals In ProgressQty with removals in progress
quantityNUMERICProduct QuantityThe Product Quantity
quantity_availableTEXTQuantity AvailableQuantity available
quantity_for_local_fulfillmentTEXTQuantity For Local FulfillmentQuantity for local fulfillment
quantity_reimbursed_cashNUMERICQuantity Reimbursed CashQuantity reimbursed cash
quantity_reimbursed_inventoryNUMERICQuantity Reimbursed InventoryQuantity reimbursed inventory
quantity_reimbursed_totalNUMERICQuantity Reimbursed TotalQuantity reimbursed total
quantity_shippedTEXTQuantity ShippedQuantity shipped
reasonTEXTReasonReason
reimbursement_idTEXTReimbursement IdReimbursement id
removal_feeNUMERICRemoval FeeRemoval fee
reporting_dateTEXTReporting DateReporting date
requested_quantityNUMERICRequested QuantityRequested quantity
return_dateTEXTReturn DateReturn date
sales_channelTEXTSales ChannelThe Sales Channel
sales_priceTEXTSales PriceSales price
sales_rankTEXTSales RankSales rank
sellable_quantityTEXTSellable QuantitySellable quantity
seller_skuTEXTSeller SkuSeller sku
ship_cityTEXTShipping CityThe Shipping City
ship_countryTEXTShipping CountryThe Shipping Country
ship_postal_codeTEXTShipping Postal CodeThe Shipping Postal Code
ship_promotion_discountTEXTShip Promotion DiscountShip promotion discount
ship_service_levelTEXTShipping Service LevelThe Shipping Service Level
ship_stateTEXTShipping StateThe Shipping State
shipment_dateTEXTShipment DateShipment date
shipment_idTEXTShipment IdShipment id
shipment_item_idTEXTShipment Item IdShipment item id
shipping_priceNUMERICShipping PriceThe Shipping Price
shipping_taxTEXTShipping TaxShipping tax
shortest_sideTEXTShortest SideShortest side
skuTEXTSKUStock Keeping Unit, assigned by the Amazon merchant
spendNUMERICEstimated Fee Total (duplicate)Estimated fee total (duplicate)
statusTEXTStatusStatus
storage_rateNUMERICStorage RateStorage Rate
total_quantityTEXTTotal QuantityTotal quantity
tracking_numberTEXTTracking NumberTracking number
transactionrevenueNUMERICTransaction RevenueThe Transaction Revenue (Duplicate of Item Price)
transactionsNUMERICTransactionsThe Number of Transactions (Duplicate of Quantity)
unit_of_dimensionTEXTUnit Of DimensionUnit of dimension
unit_of_weightTEXTUnit Of WeightUnit of weight
units_shipped_last_180_daysTEXTUnits Shipped Last 180 DaysUnits shipped last 180 days
units_shipped_last_24_hrsTEXTUnits Shipped Last 24 HrsUnits shipped last 24 hrs
units_shipped_last_30_daysTEXTUnits Shipped Last 30 DaysUnits shipped last 30 days
units_shipped_last_365_daysTEXTUnits Shipped Last 365 DaysUnits shipped last 365 days
units_shipped_last_7_daysTEXTUnits Shipped Last 7 DaysUnits shipped last 7 days
units_shipped_last_90_daysTEXTUnits Shipped Last 90 DaysUnits shipped last 90 days
unsellable_quantityTEXTUnsellable QuantityUnsellable quantity
urlTEXTUrlUrl
warehouse_condition_codeTEXTWarehouse Condition CodeWarehouse condition code
weeks_of_cover_t180TEXTWeeks Of Cover T180Weeks of cover t180
weeks_of_cover_t30TEXTWeeks Of Cover T30Weeks of cover t30
weeks_of_cover_t365TEXTWeeks Of Cover T365Weeks of cover t365
weeks_of_cover_t7TEXTWeeks Of Cover T7Weeks of cover t7
weeks_of_cover_t90TEXTWeeks Of Cover T90Weeks of cover t90
your_priceTEXTYour PriceYour price