API

Why eBay Order API Earnings Data is Often Misleading

When automating your eBay dropshipping operations, relying solely on the totalPrice.amount field from eBay's Order API for earnings calculations can lead to significant discrepancies in your financial reporting. This field represents the total amount paid by the buyer, which includes the item price, shipping charged to the buyer, and any sales tax collected by eBay. It does not represent your net profit or even your gross revenue after eBay fees and AliExpress costs.

Understanding totalPrice.amount

The totalPrice.amount field is a crucial piece of data, but it needs context. For an order where the buyer paid $25.00 for an item, $5.00 for shipping, and $2.00 in sales tax, the totalPrice.amount would be $32.00. While this is the total amount transacted, it’s not what hits your bank account, nor is it your profit.

• Item Price: The core cost of the product.
• Shipping Charged to Buyer: What the buyer paid for shipping.
• Sales Tax: Collected by eBay and remitted directly to tax authorities. This money never touches your hands and should not be factored into your gross revenue or profit calculations.

The Missing Pieces: What totalPrice.amount Doesn't Include

To get a true picture of your earnings, you need to account for several factors not present in the totalPrice.amount:

1. eBay Fees

eBay charges various fees that directly impact your net earnings. These are deducted before the payout reaches your bank account. Key fees include:

• Final Value Fees (FVF): A percentage of the total sale amount (item + shipping), varying by category. For example, a 13.25% FVF on a $30 item + shipping means $3.97 in fees.
• Insertion Fees: Though often waived for a certain number of listings, these can apply.
• International Fees: If you sell globally, expect additional fees.
• Promoted Listing Fees: If you use Promoted Listings, these are a significant deduction.

These fees are detailed in your eBay Seller Hub financial reports, but they are not directly exposed within the Order API’s totalPrice.amount.

2. AliExpress Product and Shipping Costs

As a dropshipper, your primary cost of goods sold comes from your AliExpress supplier. This includes:

• AliExpress Product Price: The cost you pay for the item on AliExpress.
• AliExpress Shipping Cost: The shipping fee you pay to the AliExpress supplier.

These are your direct variable costs and are essential for calculating gross profit. They are entirely external to eBay's API data.

3. Refunds and Returns

The totalPrice.amount reflects the initial transaction. If an order is later refunded, either partially or fully, this amount is no longer accurate. Fetch Order Tracking's gmt_refund field helps you identify when a refund occurred, but you'll still need to track the actual refund amount and correlate it with the original order's totalPrice.amount to adjust your earnings.

Relying solely on totalPrice.amount for profit calculation is like checking your bank balance without subtracting your rent or groceries. It shows you money in, but not money out, leading to an inflated sense of profitability.

Calculating Accurate Net Profit

For accurate financial tracking, you need to integrate data from multiple sources. Here’s a basic formula:

Net Profit = (eBay totalPrice.amount - eBay Sales Tax) - eBay Fees - AliExpress Product Cost - AliExpress Shipping Cost - Other Operating Costs

Let’s break this down with an example:

• eBay Sale Price (totalPrice.amount): $32.00 (Item: $25, Shipping: $5, Tax: $2)
• eBay Sales Tax: -$2.00 (deducted, never touches your account)
• eBay Final Value Fee (13.25% of $30): -$3.97 (deducted from payout)
• AliExpress Product Cost: -$10.00
• AliExpress Shipping Cost: -$3.00
• Net Profit: $32.00 - $2.00 - $3.97 - $10.00 - $3.00 = $13.03

In this scenario, if you only looked at totalPrice.amount, you might incorrectly assume $32.00 in earnings, when your actual profit is $13.03.

How Fetch Order Tracking Helps

Fetch Order Tracking provides the eBay Order API data, including totalPrice.amount, directly into your Google Sheet. It also automates the tracking of your AliExpress orders, giving you access to critical logistics statuses (logistics_status) and potential refund indicators (gmt_refund, order_status, end_reason) which are crucial for managing costs and preventing losses.

While Fetch Order Tracking delivers the raw eBay data, it's up to you to combine this with your eBay Seller Hub financial reports (for actual fees) and your AliExpress order history (for actual product and shipping costs) to build a robust profit calculation model in your Google Sheet.

Workflow for Accurate Tracking:

1. Import eBay Orders: Use Fetch Order Tracking to get totalPrice.amount and other eBay order details.
2. Record AliExpress Costs: Manually or via integration, log the exact product and shipping costs you paid on AliExpress for each order.
3. Fetch eBay Fee Data: Regularly download your transaction reports from eBay Seller Hub to get actual FVF and other fee deductions.
4. Calculate Net Profit: Use formulas in your Google Sheet to combine these data points for each order, subtracting all costs and fees from the buyer's payment (minus sales tax).
5. Monitor Refunds: Utilize Fetch Order Tracking's gmt_refund and order_status fields to identify refunded orders and adjust your profit calculations accordingly. An order_status of BUYER_ACCEPT_GOODS or FINISH typically indicates a completed, non-refunded transaction, but always cross-reference with gmt_refund for full clarity.

By understanding the limitations of the totalPrice.amount field and integrating data from all relevant sources, you can build a truly accurate financial picture of your dropshipping business, enabling better decision-making and sustainable growth.

Ready to streamline your order tracking and get better insights? Learn more about Fetch Order Tracking.

---