7 Common AllChinaBuy Sheet Mistakes That Are Silently Costing You Money

Mistakes 1-3: The Data Entry Errors

Mistake 1—Forgetting domestic China shipping: Buyers diligently record product price and international freight but skip the ¥8-25 domestic shipping from supplier to warehouse. Over 20 orders, this invisible fee accumulates to ¥160-500. Fix: Add a mandatory "Domestic Shipping" column and never leave it blank—enter ¥0 when shipping is free so you build a data trail of which suppliers offer this benefit. Mistake 2—Using a fixed exchange rate for months: CNY-to-USD rates move daily. Using 7.28 for three months while the rate shifts to 7.12 creates a 2.2% error on every calculation. Fix: Use =GOOGLEFINANCE("CURRENCY:CNYUSD") in your rate cell for automatic daily updates, or update manually every Monday morning as a routine.

Mistake 3—Entering orders from memory days later: Human memory is terrible at precise numbers. When a buyer reconstructs an order from memory, shipping costs are typically recalled as 10-15% lower than reality. Fix: Log every order immediately after placing it, while the AllChinaBuy confirmation page is still open. Make this non-negotiable—no social media, no email, no anything until the order is in the sheet. The discipline pays for itself within your first three orders.

Mistakes 4-5: The Calculation Blind Spots

Mistake 4—Ignoring volumetric weight entirely: A lightweight but bulky item like a puffer jacket might weigh only 800g but occupy 4kg of volumetric space, tripling the actual shipping cost. Buyers who log only actual weight are shocked when their invoice arrives. Fix: Add a volumetric weight calculator column using the formula =LENGTH*WIDTH*HEIGHT/5000 and use the MAX of actual and volumetric weight as your shipping weight. Mistake 5—Not tracking returns and refunds as separate entries: When a return happens, many buyers simply delete the original order row, destroying valuable data about which suppliers have quality issues. Fix: Create a separate Returns tab and cross-reference it with your main sheet. Keep the original order row with a note about the return, and add a negative row for the refund to maintain accurate totals.

Mistakes 6-7: The Strategic Errors

Mistake 6—Tracking costs but never analyzing them: An AllChinaBuy sheet filled with data that nobody reviews is just digital clutter. Many buyers diligently enter every order for months but never open their Dashboard tab. Fix: Schedule a 15-minute weekly review every Sunday evening. Sort by profit margin, identify your bottom three products, and decide whether to negotiate with the supplier, adjust pricing, or drop the product. Mistake 7—Not tracking shipping cost per kilogram by carrier: After 15 orders, your sheet contains enough data to calculate which carrier is cheapest per kg. Buyers who skip this analysis often pay 15-20% more for shipping than necessary. Fix: Add a column for shipping cost per kg and create a simple pivot table comparing carriers. You will likely find one carrier that consistently undercuts the others by $2-4 per kg—savings that add up to hundreds of dollars annually.

These seven mistakes are not random—they are the natural result of treating your sheet as a passive log rather than an active management tool. Fix them systematically, one per week, and within two months your tracking system will be a genuine profit center. For more optimization strategies, read our complete Shopping Guide and explore additional resources on our homepage.

Frequently Asked Questions