3-Clicks Updates

Function: AuctionCurrency(ItemNumber)

Description: Used to check which currency the seller of this item accepts for payment.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: currency type

String: error msg - if an error occurred during the call

Examples:

=AuctionCurrency(8267515464)

=AuctionCurrency(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “AuctionCurrency")

=FunctionCall(A1, B1) (where cell A1 contains the eBay item number and B1 contains the word "AuctionCurrency")

Function: AuctionDuration(ItemNumber)

Description: Returns the duration of this auction in days.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: duration of auction

String: error msg - if an error occurred during the call

Examples:

=AuctionDuration(8267515464)

=AuctionDuration(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “AuctionDuration")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "AuctionDuration")

Function: AuctionOutcome(ItemNumber)

Description: Used to check whether the auction was successful in selling the item or not

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: Successful or Unsuccessful

String: error msg - if an error occurred during the call

Examples:

=AuctionOutcome(8267515464)

=AuctionOutcome(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “AuctionOutcome")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "AuctionOutcome")

Function: AuctionType(ItemNumber)

Description: Returns the type of auction. The possibilties are "Chinese", "Dutch", "Fixed Price" and "Ad Type".

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: Type of auction

String: error msg - if an error occurred during the call

Examples:

=AuctionType(8267515464)

=AuctionType(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “AuctionType")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "AuctionType")



Function: BidCount(ItemNumber)

Description:

Returns the bid count of this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Integer: number of bids

String: error msg - if an error occurred during the call

Examples:

=BidCount(8267515464)

=BidCount(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BidCount")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word BidCount "))

Function: BidIncrement(ItemNumber)

Description:

Returns the smallest amount a bid must be above the current high bid.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Currency: smallest amount a bid must be above the current high bid

String: error msg - if an error occurred during the call

Examples:

=BidIncrement(8267515464)

=BidIncrement(A1)      (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BidIncrement")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BidIncrement")

Function: BindingAuction(ItemNumber)

Description:

This is applicable to Real Estate auctions only. Used to check if buyers and sellers are expected to follow through on the sale.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if buyers and sellers are expected to follow through

String: no - if bids are only expressions of interest

String: error msg - if an error occurred during the call

Examples:

=BindingAuction(8267515464)

=BindingAuction(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BindingAuction")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BindingAuction")



Function: BuyerAddress(ItemNumber, Optional N)

Description:

Returns the shipping address of the buyer, if available. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

String: shipping address

String: error msg - if an error occurred during the call

Examples:

=BuyerAddress(8267515464)

=BuyerAddress(8267515464, 2)

=BuyerAddress(A1)   (where cell A1 contains the eBay item number)

=BuyerAddress(A1, 2)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BuyerAddress")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyerAddress")



Function: BuyerEmail(ItemNumber, Optional N)

Description:

Returns the buyer's email address of, if available. Note: eBay does not return this if requested after 14 days of transaction. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

String: email address

String: error msg - if an error occurred during the call

Examples:

=BuyerEmail(8267515464)

=BuyerEmail(8267515464, 2)

=BuyerEmail(A1)   (where cell A1 contains the eBay item number)

=BuyerEmail(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BuyerEmail")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyerEmail")



Function: BuyerFeedbackScore(ItemNumber, Optional N)

Description:

Returns buyer’s feedback score, if available. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

Double: buyer’s feedback score

String: error msg - if an error occurred during the call

Examples:

=BuyerFeedbackScore(8267515464)

=BuyerFeedbackScore(8267515464, 2)

=BuyerFeedbackScore(A1) (where cell A1 contains the eBay item number)

=BuyerFeedbackScore(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, ")/span>BuyerFeedbackScore")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyerFeedbackScore")

Function: BuyerId(ItemNumber, Optional N)

Description:

Returns buyer’s eBay ID, if available. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

String: buyer’s eBay user ID.

String: error msg - if an error occurred during the call

Examples:

=BuyerId(8267515464)

=BuyerId(8267515464, 2)

=BuyerId(A1) (where cell A1 contains the eBay item number)

=BuyerId(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BuyerId")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyerId")

Function: BuyerName(ItemNumber, Optional N)

Description:

Returns buyer’s name, if available. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

String: buyer’s name

String: error msg - if an error occurred during the call

Examples:

=BuyerName(8267515464)

=BuyerName(8267515464, 2)

=BuyerName(A1) (where cell A1 contains the eBay item number)

=BuyerName(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BuyerName")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyerName")

Function: BuyerProtection(ItemNumber)

Description:

Used to check if item is eligible for the PayPal Buyer Protection program or not.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: Eligibility of buyer protection

String: error msg - if an error occurred during the call

Examples:

=BuyerProtection(8267515464)

=BuyerProtection(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BuyerProtection")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyerProtection")

Function: BuyingFeedbackToReceiveCount()

Description:

Returns the number of feedbacks to receive for items purchased.

Parameters:

No parameters are needed

Return Value:

Integer: number of feedbacks to receive

String: error msg - if an error occurred during the call

Examples:

=BuyingFeedbackToReceiveCount()



Function: BuyingFeedbackToSendCount()

Description:

Returns the number of feedbacks to send for items purchased.

Parameters:

No parameters are needed

Return Value:

Integer: number of feedbacks to send

String: error msg - if an error occurred during the call

Examples:

=BuyingFeedbackToSendCount()

Function: BuyItNowFee(ItemNumber)

Description:

Returns the Buy It Now Fee that eBay charged for this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Currency: Buy It Now fee

String: error msg - if an error occurred during the call

Examples:

=BuyItNowFee(8267515464)

=BuyItNowFee(A1)   (where cell A1 contains the eBay item number)

=BuyItNowFee(8267515464, “BuyItNowFee")

=BuyItNowFee(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyItNowFee")

Function: BuyItNowPrice(ItemNumber)

Description:

Returns the Buy It Now price for this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Currency: Buy It Now price

String: error msg - if an error occurred during the call

Examples:

=BuyItNowPrice(8267515464)

=BuyItNowPrice(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “BuyItNowPrice")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "BuyItNowPrice")

Function: Category2FullName(ItemNumber)

Description:

Returns the name of the secondary category of this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: name of the secondary category

String: error msg - if an error occurred during the call

Examples:

=Category2FullName(8267515464)

=Category2FullName(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Category2FullName")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Category2FullName")

Function: Category2Id(ItemNumber)

Description:

Returns the secondary category ID of this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Double: secondary category ID

String: error msg - if an error occurred during the call

Examples:

=Category2Id(8267515464)

=Category2Id(A1)        (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Category2Id")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Category2Id")

Function: CategoryFullName(ItemNumber)

Description:

Returns the name of the primary category of this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: name of the primary category

String: error msg - if an error occurred during the call

Examples:

=CategoryFullName(8267515464)

=CategoryFullName(A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CategoryFullName")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CategoryFullName")

Function: CategoryId(ItemNumber)

Description:

Returns the primary category ID of this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: primary category ID

String: error msg - if an error occurred during the call

Examples:

=CategoryId(8267515464)

=CategoryId(A1)          (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CategoryId")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CategoryId")



Function: CheckoutEnabled(ItemNumber)

Description:

Used to check if this auction has a checkout process or not.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if there is a checkout process

String: no - if there isn’t a checkout process

String: error msg - if an error occurred during the call

Examples:

=CheckoutEnabled(8267515464)

=CheckoutEnabled(A1)          (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CheckoutEnabled")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CheckoutEnabled")

Function: CheckoutRedirect(ItemNumber)

Description:

Used to check if the checkout process for this auction redirects the buyer to a system on another website or not.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if the checkout process redirects the buyer to another site

String: no - if the checkout process does not redirect the buyer to another site

String: error msg - if an error occurred during the call

Examples:

=CheckoutRedirect (8267515464)

=CheckoutRedirect (A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CheckoutRedirect")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CheckoutRedirect")

Function: CheckoutStatus(ItemNumber, Optional N)

Description:

Returns the checkout status of this auction. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

String: checkout status

String: error msg - if an error occurred during the call

Examples:

=CheckoutStatus(8267515464)

=CheckoutStatus(8267515464, 2)

=CheckoutStatus(A1) (where cell A1 contains the eBay item number)

=CheckoutStatus(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CheckoutStatus")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CheckoutStatus")



Function: CompleteStatus(ItemNumber, Optional N)

Description:

Used to check if the auction has been completed or not. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction.

N: Used to specify which buyer to return from.

Return Value:

String: complete status

String: error msg - if an error occurred during the call

Examples:

=CompleteStatus(8267515464)

=CompleteStatus(8267515464, 2)

=CompleteStatus(A1) (where cell A1 contains the eBay item number)

=CompleteStatus(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CompleteStatus")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CompleteStatus")

Function: Counter(ItemNumber)

Description:

Returns the type of hit counter that is associated with this auction, if available

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: Counter Type

String: error msg - if an error occurred during the call

Examples:

=Counter(8267515464)

=Counter(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Counter")

=FunctionCall(A1, B1) (where cell A1 contains the eBay item number and B1 contains the word "Counter")

Function: CounterValue(ItemNumber)

Description:

Returns the hit counter value of this auction.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: counter value

String: error msg - if an error occurred during the call

Examples:

=CounterValue(8267515464)

=CounterValue(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CounterValue")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CounterValue")

Function: CurrentBalance()

Description:

Returns the current balance of your eBay account. The value is positive for debits and negative for credits.

Parameters:

No parameters are needed

Return Value:

Currency: amount of money in the current balance

String: error msg - if an error has occurred

Examples:

=CurrentBalance()

Function: CurrentPrice(ItemNumber)

Description:

Returns the current price of this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Currency: current price

String: error msg - if an error occurred during the call

Examples:

=CurrentPrice(8267515464)

=CurrentPrice(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CurrentPrice)

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CurrentPrice")

Function: CustomLabel(ItemNumber)

Description:

Returns the custom label this item, if available.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: custom label - if available

String: "none" if custom label not available

Examples:

=CustomLabel(8267515464)

=CustomLabel(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “CustomLabel)

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "CustomLabel")

Function: Description (ItemNumber)

Description:

Returns the description of the item in text or html format

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: description of item

String: error msg - if an error occurred during the call

Examples:

=Description(8267515464)

=Description(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Description")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Description")

Function: DispatchTimeMax(ItemNumber)

Description:

Returns the maximum number of business days the seller is committed to ship out this item after receiving payment.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Integer: maximum number of days

String: error msg - if an error occurred during the call

Examples:

=DispatchTimeMax (8267515464)

=DispatchTimeMax (A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “DispatchTimeMax")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "DispatchTimeMax")

Function: EndTime(ItemNumber)

Description:

Returns the end date and time of this auction.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Date: end date and time of auction in the following format YYYY-MM-DD HH:MM:SS

String: error msg - if an error occurred during the call

Examples:

=EndTime(8267515464)

=EndTime(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “EndTime")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "EndTime")

Function: ExpeditedService1(ItemNumber)

Description:

Used to check if the seller of this item provides expedite shipping for the primary shipping service.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if expedite shipping is available

String: no - if expedite shipping is not available

String: unspecified - if seller has not specified whether or not expedite shipping is provided

String: error msg - if an error occurred during the call

Examples:

=ExpeditedService1(8267515464)

=ExpeditedService1(A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ExpeditedService1")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ExpeditedService1")

Function: ExpeditedService2(ItemNumber)

Description:

Used to check if the seller of this item provides expedite shipping for the secondary shipping service.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if expedite shipping is available

String: no - if expedite shipping is not available

String: unspecified - if seller has not specified whether or not expedite shipping is provided

String: error msg - if an error occurred during the call

Examples:

=ExpeditedService2(8267515464)

=ExpeditedService2(A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ExpeditedService2")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ExpeditedService2")

Function: ExpeditedService3(ItemNumber)

Description:

Used to check if the seller of this item provides expedite shipping for the tertiary shipping service.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if expedite shipping is available

String: no - if expedite shipping is not available

String: unspecified - if seller has not specified whether or not expedite shipping is provided

String: error msg - if an error occurred during the call

Examples:

=ExpeditedService3(8267515464)

=ExpeditedService3(A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ExpeditedService3")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ExpeditedService3")

Function: ExpressListing (ItemNumber)

Description:

Used to check if this item is an eBay Express item or not.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if this item is an eBay Express item

String: no - if this item is not an eBay Express item

String: error msg - if an error occurred during the call

Examples:

=ExpressListing(8267515464)

=ExpressListing(A1)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ExpressListing")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ExpressListing")

Function: FeedbackReceived(ItemNumber, Optional N)

Description:

Returns the feedback comments received for this item, if available. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay auction

N: Used to specify which buyer to return from.

Return Value:

String: Feedback comments

String: error msg - if an error occurred during the call

Examples:

=FeedbackReceived(8267515464)

=FeedbackReceived(8267515464, 2)

=FeedbackReceived(A1)         (where cell A1 contains the eBay item number)

=FeedbackReceived(A1, 2)         (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “FeedbackReceived")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "FeedbackReceived")

Function: FinalValueFee(ItemNumber)

Description:

Returns the Final Value Fee (eBay commission) for the sales of this item. Only available upon completion of this auction.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Currency: final value fee amount

String: error msg - if an error occurred during the call

Examples:

=FinalValueFee (8267515464)

=FinalValueFee (A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “FinalValueFee")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "FinalValueFee")

Function: GalleryFee(ItemNumber)

Description:

Returns the Gallery Fee in which eBay charged for this item.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

Currency: gallery value fee amount

String: error msg - if an error occurred during the call

Examples:

=GalleryFee (8267515464)

=GalleryFee (A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “GalleryFee ")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "GalleryFee ")

Function: GetItFast(ItemNumber)

Description:

Used to check if this auction has a GetItFast option or not.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if GetItFast option available

String: no - if GetItFast option not available

String: error msg - if an error occurred during the call

Examples:

=GetItFast (8267515464)

=GetItFast (A1)           (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “GetItFast")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "GetItFast")



Function: GiftIcon(ItemNumber)

Description:

Used to check if this auction has a gift icon associated with it.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if there is a gift icon

String: no - if there isn’t a gift icon

String: error msg - if an error occurred during the call

Examples:

=GiftIcon(8267515464)

=GiftIcon(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “GiftIcon")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "GiftIcon")

Function: GiftServices (ItemNumber)

Description:

Returns the gift services that the seller is willing to provide.



Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: gift services available

String: error msg - if an error occurred during the call

Examples:

=GiftServices(8267515464)

=GiftServices(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “GiftServices")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "GiftServices")

Function: HasBuyerSelectedShipping(ItemNumber, Optional N)

Description:

Used to check if the buyer of this item has selected a shipping method yet. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay listing

N: Used to specify which buyer to return from.

Return Value:

String: yes ")if buyer has selected shipping method already

String: no - if buyer has not selected shipping method yet

String: error msg - if an error occurred during the call

Examples:

=HasBuyerSelectedShipping(8267515464)

=HasBuyerSelectedShipping(8267515464, 2)

=HasBuyerSelectedShipping(A1)       (where cell A1 contains the eBay item number)

=HasBuyerSelectedShipping(A1, 2)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “HasBuyerSelectedShipping")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "HasBuyerSelectedShipping")

Function: HighestBidder(ItemNumber)

Description:

Returns the highest bidder ID of this auction, if available

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: eBay user ID of highest bidder

String: error msg - if an error occurred during the call

Examples:

=HighestBidder(8267515464)

=HighestBidder(A1) (where cell A1 contains the eBay item number)

=HighestBidder(")/span>HighestBidder")

=HighestBidder(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "HighestBidder")

Function: ImmediatePaymentRequired(ItemNumber)

Description:

Used to check if the seller of this item requires immediate payment or not.

Parameters:

ItemNumber: The item number of an eBay auction

Return Value:

String: yes ")if seller of this item requires immediate payment

String: no - if seller of this item does not require immediate payment

String: error msg - if an error occurred during the call

Examples:

=ImmediatePaymentRequired(8267515464)

=ImmediatePaymentRequired(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ImmediatePaymentRequired")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word “ImmediatePaymentRequired")

Function: InsertionFee(ItemNumber)

Description:

Returns the insertion fee eBay charged for this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: insertion fee amount

String: error msg - if an error occurred during the call

Examples:

=InsertionFee(8267515464)

=InsertionFee(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “InsertionFee")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "InsertionFee")

Function: InsuranceFee(ItemNumber)

Description:

Returns the insurance fee associated with this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: insurance fee amount

String: error msg - if an error occurred during the call

Examples:

=InsuranceFee(8267515464)

=InsuranceFee(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “InsuranceFee")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "InsuranceFee")

Function: InsuranceOption(ItemNumber)

Description:

Used to check if the seller of this item provides an insurance option for shipping.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: Insurance Option

String: error msg - if an error occurred during the call

Examples:

= InsuranceOption(8267515464)

= InsuranceOption(A1)           (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “InsuranceOption")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "InsuranceOption")

Function: IsPrivate(ItemNumber)

Description:

Used to check if this is a private auction or not.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if this is a private auction

String: no - if this is not a private auction

String: error msg - if an error occurred during the call

Examples:

=IsPrivate(8267515464)

=IsPrivate(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsPrivate")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsPrivate")

Function: IsSellerCIPBankAccountStored(ItemNumber)

Description:

Used to check if the seller of this item has stored bank account information with eBay in order to use the "CIP in checkout" feature.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if bank information is stored

String: no - if bank information is not stored

String: unspecified - if unknown whether bank information is stored or not

String: error msg - if an error occurred during the call

Examples:

=IsSellerCIPBankAccountStored(8267515464)

=IsSellerCIPBankAccountStored(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsSellerCIPBankAccountStored")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsSellerCIPBankAccountStored")

Function: IsSellerEbayGoodStanding(ItemNumber)

Description:

Used to check if the seller of this item is in good standing with eBay.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if seller is in good standing

String: no - if seller is not in good standing

String: error msg - if an error occurred during the call

Examples:

=IsSellerEbayGoodStanding(8267515464)

=IsSellerEbayGoodStanding(A1)        (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsSellerEbayGoodStanding")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsSellerEbayGoodStanding")

Function: IsSellerIdVerified(ItemNumber)

Description:

Used to check if the seller of this item has their ID verified.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if seller Id is verified

String: no - if seller Id is not verified

String: error msg - if an error occurred during the call

Examples:

=IsSellerIdVerified(8267515464)

=IsSellerIdVerified(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsSellerIdVerified")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsSellerIdVerified")

Function: IsSellerLAAuthorized(ItemNumber)

Description:

Used to check if the seller of this item is authorized to list lot items to the eBay Live Auctions site or not.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if seller is authorized to list lot items to the eBay Live Auctions site

String: no - if seller is not authorized to list lot items to the eBay Live Auctions site

String: error msg - if an error occurred during the call

Examples:

=IsSellerLAAuthorized(8267515464)

=IsSellerLAAuthorized(A1)      (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsSellerLAAuthorized")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsSellerLAAuthorized")

Function: IsSellerNewUser(ItemNumber)

Description:

Used to check if the seller of this item is a new user of eBay or not.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if seller is a new user

String: no - if seller is not a new user

String: error msg - if an error occurred during the call

Examples:

=IsSellerNewUser(8267515464)

=IsSellerNewUser(A1)            (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsSellerNewUser")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsSellerNewUser")

Function: IsSellerStoreOwner(ItemNumber)

Description:

Used to check if the seller of this item is an eBay store owner or not.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if seller is an eBay store owner

String: no - if seller is not an eBay store owner

String: error msg - if an error occurred during the call

Examples:

=IsSellerStoreOwner(8267515464)

=IsSellerStoreOwner(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “IsSellerStoreOwner")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "IsSellerStoreOwner")

Function: ItemRevised(ItemNumber)

Description:

Used to check if this auction has been revised or not.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if this auction has been revised

String: no - if this auction has not been revised

String: error msg - if an error occurred during the call

Examples:

=ItemRevised(8267515464)

=ItemRevised(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ItemRevised")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ItemRevised")

Function: ItemSpecifics(ItemNumber)

Description:

Returns the item specifics in a number ID format.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: item specifics

Examples:

=ItemSpecifics(8267515464)

=ItemSpecifics(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ItemSpecifics")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ItemSpecifics")

Function: ItemURL(ItemNumber)

Description:

Returns the URL of this auction.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: URL of auction

String: error msg - if an error occurred during the call

Examples:

=ItemURL(8267515464)

=ItemURL(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ItemURL")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ItemURL")

Function: LargestN(ItemNumber)

Description:

Returns the largest N value for multiple data items, where N is the number of buyers for example.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Integer: N value

String: error msg - if an error has occurred

Examples:

=LargestN(8267515464)

=LargestN(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “LargestN")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "LargestN")

Function: LastAmountPaid()

Description:

Returns the amount of money your last payment to eBay was for.

Parameters:

No parameters are needed

Return Value:

Currency: amount of money your last payment was for

String: error msg - if an error has occurred

Examples:

=LastAmountPaid()

Function: LastPaymentDate()

Description:

Returns the date of your last payment to eBay.

Parameters:

No parameters are needed

Return Value:

Date: date of your last payment

String: error msg - if an error has occurred

Examples:

=LastPaymentDate()

Function: ListingEnhancements(ItemNumber)

Description:

Returns the listing enhancement options associated with this auction.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: URL of auction

String: error msg - if an error occurred during the call

Examples:

=ListingEnhancements(8267515464)

=ListingEnhancements(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ListingEnhancements")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ListingEnhancements")

Function: ListingFee(ItemNumber)

Description:

Returns the listing fee amount for this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: Amount of the listing fee

String: error msg - if an error occurred during the call

Examples:

=ListingFee(8267515464)

=ListingFee(A1)       (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ListingFee")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ListingFee")

Function: Location(ItemNumber)

Description:

Returns the geographic location the item is in.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: location of item

String: error msg - if an error occurred during the call

Examples:

=Location(8267515464)

=Location(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Location")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Location")

Function: MinimumToBid(ItemNumber)

Description:

Returns the smallest amount the next bid on the item can be.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: minimum bid amount

String: error msg - if an error occurred during the call

Examples:

=MinimumToBid(8267515464)

=MinimumToBid(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “MinimumToBid")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "MinimumToBid")

Function: OutbidCount()

Description:

Returns the number of items from that someone else outbid you.

Parameters:

No parameters are needed

Return Value:

Integer: number of outbids

String: error msg - if an error occurred during the call

Examples:

=OutbidCount()

Function: PackagingHandlingCosts(ItemNumber)

Description:

Returns the packaging and handling cost of this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: Packaging and Handling cost amount

String: error msg - if an error occurred during the call

Examples:

=PackagingHandlingCosts(8267515464)

=PackagingHandlingCosts(A1)          (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PackagingHandlingCosts")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PackagingHandlingCosts")

Function: PaymentMethods(ItemNumber)

Description:

Returns the payment methods the seller of this item will accept.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: payment methods that are accepted

String: error msg - if an error occurred during the call

Examples:

=PaymentMethod(8267515464)

=PaymentMethod(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PaymentMethod")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PaymentMethod")

Function: PaymentMethodUsed(ItemNumber, Optional N)

Description:

Returns the payment method that the buyer has used. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay listing

N: Used to specify which buyer to return from.

Return Value:

String: payment status of the item

String: error msg - if an error occurred during the call

Examples:

=PaymentMethodUsed(8267515464)

=PaymentMethodUsed(8267515464, 2)

=PaymentMethodUsed(A1) (where cell A1 contains the eBay item number)

=PaymentMethodUsed(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PaymentMethodUsed")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PaymentMethodUsed")

Function: PaymentStatus(ItemNumber, Optional N)

Description:

Returns the payment status of this item. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay listing

N: Used to specify which buyer to return from.

Return Value:

String: payment status of the item

String: error msg - if an error occurred during the call

Examples:

=PaymentStatus(8267515464)

=PaymentStatus(8267515464, 2)

=PaymentStatus(A1) (where cell A1 contains the eBay item number)

=PaymentStatus(A1, 2) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PaymentStatus")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PaymentStatus")

Function: PaymentToReceiveCount()

Description:

Returns the number of payments to receive from sales.

Parameters:

No parameters are needed

Return Value:

Integer: number of payments to receive

String: error msg - if an error occurred during the call

Examples:

=PaymentToReceiveCount()

Function: PaymentToSendCount()

Description:

Returns the number of payments to send for purchases.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Integer: number of payments to send

String: error msg - if an error occurred during the call

Examples:

=PaymentToSendCount()

Function: PayPalEmailAddress(ItemNumber)

Description:

Returns the seller’s PayPal email address.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: PayPal email address

String: error msg - if an error occurred during the call

Examples:

=PayPalEmailAddress(8267515464)

=PayPalEmailAddress(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PayPalEmailAddress")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PayPalEmailAddress")

Function: PayPalFee(ItemNumber)

Description:

Returns the PayPal Fee associated with this item. You must be the seller of this item in order to return the PayPal Fee. You must also grant PayPal access to Prime 2s before you can use this function. To do this, go through the following steps:

1. Login to your PayPal Account

2. Click on the "My Account" tab
3. Click on the "Profile" Tab
4. Click on "API Access" (First Column)
5. Click on "Grant API Permission"
6. Type in "email_api1.prime2s.com" in the API Partner Username textbox
7. Check the "Admin_API" checkbox
8. Click on "Submit"
9. Click on "Give permission"

NOTE: There is a bug associated with this function. It may not return the correct value if a buyer pays for multiple auctions with different item numbers all in one PayPal transaction.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: PayPal Fee

String: error msg - if an error occurred during the call

Examples:

=PayPalFee(8267515464)

=PayPalFee(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PayPalFee")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PayPalFee")

Function: PictureURL(ItemNumber)

Description:

Returns the URL of the picture associated with this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: URL of the picture

String: error msg - if an error occurred during the call

Examples:

=PictureURL(8267515464)

=PictureURL(A1)        (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PictureURL")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PictureURL")

Function: PostalCode (ItemNumber)

Description:

Returns the postal code this item is located in.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Integer: PostalCode (Zip code if in United States)

String: error msg - if an error occurred during the call

Examples:

=PostalCode(8267515464)

=PostalCode(A1)        (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PostalCode")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PostalCode")

Function: PurchaseDate(ItemNumber, Optional N)

Description:

Returns the purchase date of this item sold in the auction. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay listing.

N: Used to specify which buyer to return from.

Return Value:

Date: purchase date of buyer(s)

String: error msg - if an error occurred during the call

Examples:

=PurchaseDate(8267515464)

=PurchaseDate(8267515464, 2)

=PurchaseDate(A1)      (where cell A1 contains the eBay item number)

=PurchaseDate(A1, 2)      (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “PurchaseDate")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "PurchaseDate")

Function: Quantity(ItemNumber)

Description:

Returns the quantity of the item that is associated with the auction.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Integer: quantity

String: error msg - if an error occurred during the call

Examples:

=Quantity(8267515464)

=Quantity(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Quantity")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Quantity")

Function: QuantitySold(ItemNumber, Optional N)

Description:

Returns the quantity of this item sold in the auction. If N is not specified, this function returns comma separated data if there are more than one buyer for an auction. If N=1,2,3,etc. is specified, it is used to specify which buyer to return from.

Parameters:

ItemNumber: The item number of an eBay listing.

N: Used to specify which buyer to return from.

Return Value:

Integer: quantity sold

String: error msg - if an error occurred during the call

Examples:

=QuantitySold(8267515464)

=QuantitySold(8267515464, 2)

=QuantitySold(A1)      (where cell A1 contains the eBay item number)

=QuantitySold(A1, 2)      (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “QuantitySold")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "QuantitySold")

Function: ReferrerCredit(ItemNumber)

Description:

Returns the referral credit that eBay issued to you for this item.

Parameters:

ItemNumber: The item number of an eBay listing.

Return Value:

Currency: referrer credit value

String: error msg - if an error occurred during the call

Examples:

=ReferrerCredit(8267515464)

=ReferrerCredit(A1)      (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ReferrerCredit")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ReferrerCredit")

Function: RelistingNeededCount()

Description:

Returns the number of auctions that is not sold and perhaps needs relisting.

Parameters:

No parameters are needed

Return Value:

Integer: number of auctions that need relisting

String: error msg - if an error occurred during the call

Examples:

=RelistingNeededCount()

Function: Reserve(ItemNumber)

Description:

Used to check if there is a reserve price associated with this auction.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if there is a reserve price

String: no - if there isn’t a reserve price

String: error msg - if an error occurred during the call

Examples:

=Reserve(8267515464)

=Reserve(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “Reserve")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Reserve")

Function: ReserveMet(ItemNumber)

Description:

Used to check if the reserve price is met or not.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if reserve price is met already

String: no - if reserve price is met yet

String: error msg - if an error occurred during the call

Examples:

=ReserveMet(8267515464)

=ReserveMet(A1)        (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ReserveMet")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ReserveMet")

Function: ReservePrice(ItemNumber)

Description:

Returns the reserve price for this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: reserve price amount

String: error msg - if an error occurred during the call

Examples:

=ReservePrice(8267515464)

=ReservePrice(A1)     (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ReservePrice")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ReservePrice")

Function: Revenue(ItemNumber)

Description:

Returns the revenue of this auction, excluding shipping charges. If the item quantity sold is greater than 1, the number sold is multiplied by the ending price.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: Revenue price amount

String: error msg - if an error occurred during the call

Examples:

=Revenue (8267515464)

=Revenue (A1)     (where cell A1 contains the eBay item number)

=Revenue (“Revenue")

=Revenue (A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "Revenue")

Function: SalesTaxPercent(ItemNumber)

Description:

Returns the sales tax percentage of this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Float: sales tax

String: error msg - if an error occurred during the call

Examples:

=SalesTaxPercent(8267515464)

=SalesTaxPercent(A1)           (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “SalesTaxPercent")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "SalesTaxPercent")

Function: SalesTaxState(ItemNumber)

Description:

Returns the state or jurisdiction for which the sales tax is being collected.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: state of the associated tax

String: error msg - if an error occurred during the call

Examples:

=SalesTaxState(8267515464)

=SalesTaxState(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “SalesTaxState")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "SalesTaxState")

Function: ScheduledFee(ItemNumber)

Description:

Returns the scheduling fee eBay charged for this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Currency: scheduled fee value

String: error msg - if an error occurred during the call

Examples:

=ScheduledFee(8267515464)

=ScheduledFee(A1)   (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “ScheduledFee")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "ScheduledFee")

Function: SecondChanceEligible(ItemNumber)

Description:

Used to check if the seller is elegible to extend a second chance offer for this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if elegible for second chance offer

String: no - if not elegible for second chance offer

String: error msg - if an error occurred during the call

Examples:

=SecondChanceEligible(8267515464)

=SecondChanceEligible(A1) (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “SecondChanceEligible")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "SecondChanceEligible")

Function: SecondChanceOfferCount()

Description:

Returns the number of second chance offers associated with this item.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Integer: number of second chance offers

String: error msg - if an error occurred during the call

Examples:

=SecondChanceOfferCount()

Function: SellerAboutMe(ItemNumber)

Description:

Used to check if the seller of this item has an AboutMe page.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

String: yes ")if seller has AboutMe page

String: no - if seller does not have AboutMe page

String: error msg - if an error occurred during the call

Examples:

=SellerAboutMe(8267515464)

=SellerAboutMe(A1)    (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “SellerAboutMe")

=FunctionCall(A1, B1)                      (where cell A1 contains the eBay item number and B1 contains the word "SellerAboutMe")

Function: SellerFeedbackScore(ItemNumber)

Description:

Returns the seller’s feedback score.

Parameters:

ItemNumber: The item number of an eBay listing

Return Value:

Double: seller’s feedback score

String: error msg - if an error occurred during the call

Examples:

=SellerFeedbackScore(8267515464)

=SellerFeedbackScore(A1)    (where cell A1 contains the eBay item number)

=FunctionCall(8267515464, “SellerFeedbackScore")

=FunctionCall(A1, B1)                      (where cell A