Refunds

Your Gross Profit Column is Wrong (Use These Metrics Instead)

Many experienced dropshippers using Google Sheets for their accounting make a critical mistake: they calculate 'gross profit' solely as (eBay Sale Price - AliExpress Product Cost). This figure is fundamentally flawed and will lead you to misjudge your store's actual profitability. This isn't theoretical; we've seen this directly in the thousands of orders Fetch Order Tracking processes. Your real gross profit is significantly lower once you account for the full lifecycle of an order, particularly refunds and associated costs.

The Flawed Gross Profit Calculation

Let's break down why eBay Sale Price - AliExpress Product Cost is an incomplete picture. This calculation ignores:

• Refunds: The biggest blind spot. A significant portion of your orders will result in a full or partial refund. If you're not deducting these from your revenue, your 'profit' is inflated.
• Shipping Costs: You might offer 'free shipping' on eBay, but you're paying for it on AliExpress. This is a direct cost of goods sold.
• eBay Fees: Final value fees, insertion fees, promoted listings fees – these are all direct deductions from your eBay sale price.
• Payment Processing Fees: PayPal or other payment gateway fees further erode your net revenue.
• AliExpress Discounts/Coupons: While these reduce your cost, they are often not consistently applied in manual tracking, leading to discrepancies.

Consider a typical order: you sell an item for $25 on eBay, and it costs you $10 on AliExpress. Your 'flawed gross profit' is $15. But what if the customer initiates a return, and you issue a $20 refund? Your actual profit for that order is now negative. Without automated tracking, reconciling these scenarios at scale becomes impossible, leaving your 'profit' column looking healthy while your bank account tells a different story.

Your real gross profit isn't static upon sale; it's a dynamic figure that evolves based on refunds, fees, and logistics outcomes.

The Fetch Order Tracking Approach: Accurate Profitability Metrics

Fetch Order Tracking provides the granular data needed to build a truly accurate profitability dashboard in your Google Sheet. Instead of one misleading 'gross profit' column, you should be tracking several key metrics for each order.

1. Net Revenue (eBay)

This is your actual income from the eBay sale, after accounting for any refunds issued. Fetch Order Tracking pulls the gmt_refund timestamp and refund_amount directly from your AliExpress orders. You'll need to manually track eBay refunds, but the principle is the same.

• Formula: eBay Sale Price - eBay Refund Amount
• Example: $25 (eBay Sale Price) - $5 (Partial eBay Refund) = $20 Net Revenue

2. Total AliExpress Cost

This is the true cost of getting the product to your customer. It includes the product price, shipping, and any other associated fees on the AliExpress side.

• Formula: AliExpress Product Price + AliExpress Shipping Cost - AliExpress Coupons/Discounts
• Fetch Data: Use the ali_product_cost and ali_shipping_cost fields.
• Example: $10 (Product) + $3 (Shipping) - $1 (Coupon) = $12 Total AliExpress Cost

3. eBay Fees Per Order

These are the direct costs eBay charges for facilitating the sale. While Fetch Order Tracking focuses on AliExpress data, you must integrate your eBay fee reports.

• Common Fees: Final Value Fee (FVF), Insertion Fees, Promoted Listings Fees.
• Example: $25 (eBay Sale Price) * 13.25% (FVF) + $0.30 (FVF per order) = ~$3.61 eBay Fees

4. Payment Processing Fees

If you use PayPal, Stripe, or similar, factor in their transaction fees.

• Example: $25 (eBay Sale Price) * 2.9% + $0.30 = ~$1.03 Payment Fees

5. True Gross Profit Per Order

This is the figure that matters. It accounts for all direct costs associated with a single order.

• Formula: Net Revenue (eBay) - Total AliExpress Cost - eBay Fees Per Order - Payment Processing Fees
• Example: $20 (Net Revenue) - $12 (AliExpress Cost) - $3.61 (eBay Fees) - $1.03 (Payment Fees) = $3.36 True Gross Profit

Leveraging Fetch Order Tracking for Refund-Aware Profitability

Fetch Order Tracking excels at bringing clarity to the most volatile part of your dropshipping operation: refunds and order status changes. The order_status, logistics_status, end_reason, and gmt_refund fields are critical for accurate profit calculation.

• Real-time Refund Detection: The gmt_refund timestamp tells you exactly when an AliExpress refund was processed. You can set up conditional formatting or formulas in Google Sheets to flag orders with refunds and adjust their profitability accordingly.
• Status-Based Adjustments: An order with order_status: FINISH and logistics_status: BUYER_ACCEPT_GOODS is far more likely to be profitable than one with order_status: CANCELLED or end_reason: BUYER_REFUND. You can build formulas that assign a profit of $0 or even negative values to orders that didn't complete successfully or resulted in a full refund.
• Identifying Problem SKUs: By tracking true gross profit per order, you can quickly identify products with high refund rates or low margins that are dragging down your overall profitability.

Without integrating these real-world costs and outcomes into your per-order profitability calculation, you're operating with an illusion of higher profits. Fetch Order Tracking gives you the data foundation to move beyond guesswork and build a robust, refund-aware profit tracking system in your Google Sheets.

Ready to fix your gross profit column and see your true profitability? Explore how Fetch Order Tracking can automate your data sync at Fetch Order Tracking.

---