7 Allchinabuy Spreadsheet Mistakes That Cost You Money

Mistake 1: Forgetting Agent Fees

The seller price is not your final price. Agents charge a service fee that typically ranges from five to fifteen percent of the item cost. Beginners often record only the product page price and get shocked when their total budget jumps by twenty percent after fees and shipping.

Fix: Add an Agent Fee column immediately after Unit Price. Enter the percentage or flat fee your agent charges. If the fee varies by item, write the exact amount. Never leave this column blank, even if you think you know the approximate total.

Mistake 2: Ignoring Domestic Shipping

Domestic shipping covers the journey from the seller to the agent warehouse inside the origin country. It is separate from international shipping and often costs five to fifteen dollars per item. Buyers who skip this column underestimate their total by a significant margin.

Fix: Add a Domestic Shipping column and research rates before you buy. Some sellers include free domestic shipping above a threshold. Record that in your Notes column so you remember to hit the minimum next time.

Mistake 3: Inconsistent Status Labels

One row says Shipped. Another says On The Way. A third says In Transit. When you filter by status, those variations split into separate groups and your overview breaks. Inconsistent labeling destroys the main benefit of a spreadsheet: quick clarity.

Fix: Use Data Validation to create a dropdown list. Lock the Status column to exactly these labels: Pending, Ordered, At Warehouse, Shipped, Delivered, Issue. No abbreviations, no synonyms, no creativity.

Mistake 4: Not Recording Sizes and Colors

When you order three black hoodies in different sizes from the same seller, the links look identical. If you do not write down Size and Color, you will not know which item is which when they arrive at the warehouse. That leads to wrong shipments, returns, and wasted agent fees.

Fix: Add dedicated Size and Color columns next to Item Name. Fill them in the moment you paste the link, while the product page is still open. Do not rely on memory, even for a single item.

Mistake 5: Skipping the Notes Column

The Notes column feels optional, which is why so many buyers leave it empty. That emptiness costs them later. Notes are where you record special instructions, seller communication, quality warnings, and agent preferences. Without notes, every haul starts from zero.

Fix: Make Notes a habit. Write one sentence per item. Examples include 'Seller ships in three days,' 'Agent warned about loose stitching,' or 'Consider sizing up.' Those sentences compound into buying wisdom over time.

Mistake 6: Failing to Back Up

Cloud storage is reliable but not invincible. Accidental deletions, account issues, and sync errors happen. Buyers who rely on a single copy of their allchinabuy spreadsheet risk losing months of organized data in seconds.

Fix: Export a CSV backup every month. Store it in a different folder or email it to yourself. The backup takes ten seconds and can save hours of reconstruction if something goes wrong.

Mistake 7: Never Reviewing Old Sheets

Every completed haul sheet contains valuable data about seller speed, sizing accuracy, and hidden fees. Buyers who delete or abandon old sheets throw away a free education. They repeat the same mistakes on every new order because they never look back.

Fix: Before starting a new haul, open your previous sheet and scan for patterns. Which seller delivered fastest? Which category had the most sizing issues? Which agent offered the best shipping rate? Write those observations in a master notes document. Your future self will thank you.

Quick Comparison

Frequently Asked Questions