How to Use CSSBuy Spreadsheet Step-by-Step

Learning how to use CSSBuy spreadsheet tools is the single biggest upgrade you can make to your shopping workflow. Instead of drowning in browser tabs and sticky notes, a properly configured spreadsheet turns chaos into a dashboard where every order status, cost, and deadline is visible at a glance. This tutorial assumes zero prior spreadsheet knowledge.

By the end of this guide, you will have a working CSSBuy spreadsheet that tracks items, calculates totals, estimates shipping, and updates status automatically. Let us dive in.

What You Will Need

Before starting, gather these basics. They take under two minutes to prepare and will save you from pausing mid-tutorial.

• A free Google account (for Google Sheets) or Microsoft account (for Excel Online)
• Our free CSSBuy spreadsheet template downloaded from this site
• A list of items you plan to buy, with Taobao or Weidian links
• The current CNY to your-currency exchange rate (Google it in ten seconds)

Step 1: Open and Duplicate the Template

Open our template in Google Sheets. The first thing you should do is duplicate it so you keep a clean master copy. Click the sheet tab at the bottom, choose Duplicate, and rename the new tab to something like "Haul May 2026." This habit keeps your order history organized forever.

Next, look at the setup area in the top-left corner. You will see a cell labeled "Exchange Rate." Enter today's CNY-to-your-currency rate here. Every price you enter in CNY will automatically convert to your local currency. This is the first formula working for you.

Step 2: Enter Your First Item

Click the first empty row under the headers. In the Item Name column, write something descriptive. Instead of "cool shirt," write "Nike Tech Fleece Hoodie Black Size L." Descriptive names prevent confusion when you have twenty items in warehouse later.

In the Product URL column, paste the full Taobao or Weidian link. This creates a clickable reference you can open anytime to check original listings, verify prices, or request refunds. In the Price CNY column, enter the item price exactly as shown on the seller page. Do not include domestic shipping here; that comes later.

The auto-total formula immediately adds the estimated agent fee. You will see your true cost appear in the Total column without touching a calculator. If the agent fee percentage looks wrong, adjust the percentage cell in the setup area. Most buyers use 8-12%.

Step 3: Add Product Details

Fill in Size, Color, and any custom options in the next columns. These details matter enormously during QC checks. When CSSBuy sends warehouse photos, you want to verify that the hoodie is actually black and size L, not navy and medium. Notes you enter now become your quality checklist later.

In the Estimated Weight column, enter your best guess. A T-shirt is roughly 200-300 grams. Sneakers are typically 800-1200 grams with box. Hoodies fall around 400-600 grams. These estimates let the shipping calculator give you a rough preview of final costs. Update with actual weights from QC photos when available.

Step 4: Update Status as Orders Progress

The Status column is where the magic happens. Change it from "Ordered" to "Arrived at Warehouse" when CSSBuy confirms delivery. The row will automatically change color based on our conditional formatting rules: yellow for in-progress, green for complete, red for issues. One glance at your sheet tells you the health of your entire haul.

When you submit your parcel for international shipping, update every item in that parcel to "Shipped" and enter the tracking number in the Tracking column. This links every item to its logistics journey, making it easy to answer questions from buyers if you are reselling.

Status Reference Table

Step 5: Estimate and Optimize Shipping

Once all items show "Arrived at Warehouse," use the shipping estimator. Enter the actual total weight from QC photos and compare lines like EMS, DHL, and SAL. Our template highlights the cheapest option in green and the fastest in blue. If your haul is heavy, the estimator might suggest splitting into two parcels to avoid customs scrutiny.

Many beginners skip this step and accept the first shipping quote CSSBuy offers. Spending two minutes in your spreadsheet can save 50-150 CNY on every haul. Over a year of regular buying, that adds up to hundreds of dollars saved simply because you compared options.

Step 6: Archive and Review

After delivery, do not delete your data. Move completed rows to an "Archive" sheet tab. This historical record becomes invaluable when you want to reorder a favorite item, compare price changes over time, or prove delivery to a resale customer. Experienced buyers maintain archives spanning years of purchases.

Review your haul summary before starting the next one. The template generates a mini-report showing total spent, average item cost, shipping ratio, and delivery time. Use this data to set smarter budgets and choose better shipping lines for future orders.

Conclusion

Now you know exactly how to use CSSBuy spreadsheet tools from first setup to final archive. The process is simple: duplicate the template, enter items with full details, update status as orders progress, compare shipping options, and save your history. Each step takes minutes but saves hours of confusion and potentially hundreds in unnecessary costs.

Start your first tracked haul today. Open the template, enter three items, and experience the difference that organized tracking makes. Once you see every cost and status at a glance, you will never shop unorganized again.

Frequently Asked Questions