Excel Functions To Access Individual Amazon Product Data Attributes (MWS)

Product Attribute Excel Function
Author  =azAuthor(ASIN)
Belongs To Requester – New BuyBox  =azIhaveNewBuyBox(ASIN)
Belongs To Requester – Used BuyBox  =azIhaveUsedBuyBox(ASIN)
Binding  =azBinding(ASIN)
Brand  =azBrand(ASIN)
Condition – New BuyBox  =azConditionNewBuyBox(ASIN)
Condition – Used BuyBox  =azConditionUsedBuyBox(ASIN)
List Price Currency Code  =azCurrencyCode(ASIN)
Edition  =azEdition(ASIN)
FBA Fees  =azFbaFees(ASIN, Optional PRICE)
Image URL  =azImageURL(ASIN)
IsEligibleForTradeIn  =azIsEligibleForTradeIn(ASIN)
Item Dimensions Height  =azItemDimensionsHeight(ASIN)
Item Dimensions Height Units  =azItemDimensionsHeightUnits(ASIN)
Item Dimensions Length  =azItemDimensionsLength(ASIN)
Item Dimensions Length Units  =azItemDimensionsLengthUnits(ASIN)
Item Dimensions Weight  =azItemDimensionsWeight(ASIN)
Item Dimensions Weight Units  =azItemDimensionsWeightUnits(ASIN)
Item Dimensions Width  =azItemDimensionsWidth(ASIN)
Item Dimensions Width Units  =azItemDimensionsWidthUnits(ASIN)
Label  =azLabel(ASIN)
Landed Price – Used BuyBox  =azLandedPriceUsedBuyBox(ASIN)
Landed Price – New Buy Box  =azLandedPriceNewBuyBox(ASIN)
Listing Price – New BuyBox  =azListingPriceNewBuyBox(ASIN)
Listing Price – Used BuyBox  =azListingPriceUsedBuyBox(ASIN)
Lowest Offer NEW FBA – Price  =azLowestOfferNewFbaPrice(ASIN)
Lowest Offer NEW FBA – Shipping Price  =azLowestOfferNewFbaShippingPrice(ASIN)
Lowest Offer NEW MFN – Price  =azLowestOfferNewMfnPrice(ASIN)
Lowest Offer NEW MFN – Shipping Price  =azLowestOfferNewMfnShippingPrice(ASIN)
Lowest Offer USED FBA – Landed Price  =azLowestOfferUsedFbaLandedPrice(ASIN)
Lowest Offer USED FBA – Price  =azLowestOfferUsedFbaPrice(ASIN)
Lowest Offer USED FBA – Shipping Price  =azLowestOfferUsedFbaShippingPrice(ASIN)
Lowest Offer USED MFN – Landed Price  =azLowestOfferUsedMfnLandedPrice(ASIN)
Lowest Offer USED MFN – Price  =azLowestOfferUsedMfnPrice(ASIN)
Lowest Offer USED MFN – Shipping Price  =azLowestOfferUsedMfnShippingPrice(ASIN)
Manufacturer  =azManufacturer(ASIN)
New Offers  =azNewOffers(ASIN)
Number Of Items  =azNumberOfItems(ASIN)
Package Dimensions Height  =azPackageDimensionsHeight(ASIN)
Package Dimensions Height Units  =azPackageDimensionsHeightUnits(ASIN)
Package Dimensions Length  =azPackageDimensionsLength(ASIN)
Package Dimensions Length Units  =azPackageDimensionsLengthUnits(ASIN)
Package Dimensions Weight  =azPackageDimensionsWeight(ASIN)
Package Dimensions Weight Units  =azPackageDimensionsWeightUnits(ASIN)
Package Dimensions Width  =azPackageDimensionsWidth(ASIN)
Package Dimensions Width Units  =azPackageDimensionsWidthUnits(ASIN)
Pages  =azPages(ASIN)
Per Item Fee  =azPerItemFee(ASIN As String, PRICE optional)
Product Group  =azProductGroup(ASIN)
Product Type Name  =azProductTypeName(ASIN)
Publication Date  =azPublicationDate(ASIN)
Publisher  =azPublishe (ASIN)
Referral Fee  =azReferralFee(ASIN,PRICE) Set price to ZERO to get the percentage
Sales Rank  =azSalesRank(ASIN)
Sales Rank Category  =azSalesRankCategory(ASIN)
Shipping Price – New BuyBox  =azShippingPriceNewBuyBox(ASIN)
Shipping Price – Used BuyBox  =azShippingPriceUsedBuyBox(ASIN)
Studio  =azStudio(ASIN)
Subcondition – New BuyBox  =azSubconditionNewBuyBox(ASIN)
Subcondition – Used BuyBox  =azSubconditionUsedBuyBox(ASIN)
Title  =azTitle(ASIN)(ASIN)
Total Fees  =azTotalFees(ASIN,PRICE)
Total Offers  =azTotalOffers
Used Offers  =azUsedOffers(ASIN)