Skip to main content
Published: July 05 2012, 2:38:00 PMUpdated: November 28 2020, 10:33:44 PM

I was not able to retreive delivery address information for the orders in SoldReport on Sandbox. I can confirm that I specifically entered a new delivery address. What's wrong with the SoldReports?

For the SoldReport to return the buyer's delivery address for each of the orders, the payment by the buyer should be complete and the order status should be completed. It could be possible that the eBayPaymentStatus was PayPalPaymentInProcess. For example consider the part of SoldReport below,

<OrderDetails>
<OrderID>110099204103-26936670001</OrderID>
<BuyerUserID>testuser_offtek001</BuyerUserID>
<BuyerFirstName><![CDATA[Test]]></BuyerFirstName>
<BuyerLastName><![CDATA[User]]></BuyerLastName>
<BuyerEmail><![CDATA[brian@offtek.co.uk]]></BuyerEmail>
<BuyerPhone>1 800 111 1111</BuyerPhone>
<ShippingService><![CDATA[Royal Mail 1st Class Standard]]></ShippingService>
<CheckoutSiteID>0</CheckoutSiteID>
<OrderCreationTime>2012-06-20T18:35:20.000Z</OrderCreationTime>
<TaxAmount currencyID="GBP">0.0</TaxAmount>
<InsuranceCost currencyID="GBP">0.0</InsuranceCost>
<ShippingCost currencyID="GBP">0.0</ShippingCost>
<OrderTotalCost currencyID="GBP">4.5</OrderTotalCost>
<OrderItemDetails>
<OrderLineItem>
<OrderLineItemID>110099204103-26936670001</OrderLineItemID>
<ItemID>110099204103</ItemID>
<SKU>898904</SKU>
<QuantitySold>1</QuantitySold>
<SalePrice currencyID="GBP">4.5</SalePrice>
<TaxAmount currencyID="GBP">0.0</TaxAmount>
<ShippingCost currencyID="GBP">0.0</ShippingCost>
<TotalCost currencyID="GBP">4.5</TotalCost>
<InsuranceCost currencyID="GBP">0.0</InsuranceCost>
<ListingSiteID>3</ListingSiteID>
<BuyerPaymentTransactionNumber>1NX38058S6785045G</BuyerPaymentTransactionNumber>
<Status>
<PaymentHoldStatus>None</PaymentHoldStatus>
</Status>
</OrderLineItem>
</OrderItemDetails>
<ShippingServiceToken>UK_RoyalMailFirstClassStandard</ShippingServiceToken>
<CheckoutStatus>
<eBayPaymentStatus>PayPalPaymentInProcess</eBayPaymentStatus>
<PaymentMethod>PayPal</PaymentMethod>
<Status>Complete</Status>
</CheckoutStatus>
<PaymentHoldStatus>None</PaymentHoldStatus>
<ExternalTransaction>
<ExternalTransactionID>1NX38058S6785045G</ExternalTransactionID>
<ExternalTransactionTime>2012-06-20T18:40:29.000Z</ExternalTransactionTime>
<FeeOrCreditAmount currencyID="GBP">0.00</FeeOrCreditAmount>
<PaymentOrRefundAmount currencyID="GBP">4.50</PaymentOrRefundAmount>
</ExternalTransaction>
</OrderDetails>

There are a couple of reasons why the eBayPaymentStatus could be PayPalPaymentInProcess:

* The seller has not setup the account with PayPal to receive payments. The seller needs to sign up with PayPal and confirm the email address in order to be able to receive payments. See the PayPal help page for more details.
* The seller has enabled the account for Payment Review.  The seller needs to go to the PayPal account and either accept all the payments or disable Payment Review.

If you are just testing the orders in Sandbox, you can also disable the Payment review for the seller's paypal account.

For an order to return the buyer's delivery address, CheckoutStatus container should look like below,

<CheckoutStatus>
<eBayPaymentStatus>NoPaymentFailure</eBayPaymentStatus>
<PaymentMethod>PayPal</PaymentMethod>
<Status>Complete</Status>
</CheckoutStatus>

How well did this answer your question?