AccountPastDue
AmountPastDue
AnythingPoints
AuctionCurrency
AuctionDuration
AuctionOutcome
AuctionType
BidCount
BidIncrement
BindingAuction
BuyerAddress
BuyerEmail
BuyerFeedbackScore
BuyerId
BuyerName
BuyerProtection
BuyingFeedbackToReceiveCount
BuyingFeedbackToSendCount
BuyItNowFee
BuyItNowPrice
Category2Id
CategoryFullName
CategoryId
CheckoutEnabled
CheckoutRedirect
CheckoutStatus
CompleteStatus
Counter
CounterValue
CurrentBalance
CurrentPrice
CustomLabel
Description
DispatchTimeMax
EndTime
ExpeditedService1
ExpeditedService2
ExpeditedService3
ExpressListing
FeedbackReceived
FinalValueFee
GalleryFee
GetItFast
GiftIcon
GiftServices
HasBuyerSelectedShipping
HighestBidder
ImmediatePaymentRequired
InsertionFee
InsuranceFee
InsuranceOption
IsPrivate
IsSellerCIPBankAccountStored
IsSellerEbayGoodStanding
IsSellerIdVerified
IsSellerLAAuthorized
IsSellerNewUser
IsSellerStoreOwner
ItemRevised
ItemSpecifics
ItemURL
LargestN
LastAmountPaid
LastPaymentDate
ListingEnhancements
ListingFee
Location
MinimumToBid
OutbidCount
PackagingHandlingCosts
PaymentMethods
PaymentMethodUsed
PaymentStatus
PaymentToReceiveCount
PaymentToSendCount
PayPalEmailAddress
PayPalFee
PictureURL
PostalCode
PurchaseDate
Quantity
QuantitySold
ReferrerCredit
RelistingNeededCount
Reserve
ReserveMet
ReservePrice
Revenue
SalesTaxPercent
SalesTaxState
ScheduledFee
SecondChanceEligible
SecondChanceOfferCount
SellerAboutMe
SellerFeedbackScore
SellerId
SellerIdChanged
SellerIdLastChanged
SellerLevel
SellerRegDate
SellingFeedbackToReceiveCount
SellingFeedbackToSendCount
ShippingCostSummary
ShippingDate
ShippingDiscount
ShippingInTax
ShippingIrregularBox
ShippingNeededCount
ShippingService1
ShippingService2
ShippingService3
ShippingServiceAdditionalCost1
ShippingServiceAdditionalCost2
ShippingServiceAdditionalCost3
ShippingServiceCost1
ShippingServiceCost2
ShippingServiceCost3
ShippingTimeMax1
ShippingTimeMax2
ShippingTimeMax3
ShippingTimeMin1
ShippingTimeMin2
ShippingTimeMin3
ShipToLocations
ShippingTracking
SiteId
StartPrice
StartTime
StoreCategory2Id
StoreCategoryId
StoreURL
Subtitle
TimeLeft
Title
TotalAmountCollected
UnansweredQuestions
WatchCount
Weight
WeightOunce
WeightPound
Function:
AccountPastDue()
Description:
Used to check if
your eBay account payment is past due or not.
Parameters:
No
parameters are needed
Return
Value:
String:
yes - if your account is past due
String:
no - if your account is not past due
String:
error msg - if an error has occurred
Examples:
=AccountPastDue()
Function:
AmountPastDue()
Description:
Returns the
amount of money that your eBay account is past due.
Parameters:
No
parameters are needed
Return
Value:
Currency:
amount of money past due
String:
error msg - if an error has occurred
Examples:
=AmountPastDue()
Function:
AnythingPoints(ItemNumber)
Description:
Used to
check if the seller of this item accepts AnythingPoints as a form of payment or
not.
Parameters:
ItemNumber:
The item number of an eBay auction
Return
Value:
String: yes
")if
AnythingPoints is accepted
String:
no - if
AnythingPoints is not accepted
String:
error msg - if an
error occurred during the call
Examples:
=AnythingPoints(8267515464)
=AnythingPoints(A1)
(where cell A1 contains the eBay
item number)
=FunctionCall(8267515464, “AnythingPoints")
=FunctionCall(A1, B1) (where cell A1 contains the eBay item number and B1 contains
the word "AnythingPoints")
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:
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