Eastmallbuy Spreadsheet Guide: The Complete 2026 Tutorial

Understanding the Core Spreadsheet Philosophy

The best eastmallbuy spreadsheet is not a data dump. It is a decision-making tool. Every column should answer a question: Is this item in stock? Is the price fair? Have I already ordered something similar? When your sheet is designed around decisions, you spend less time scrolling and more time buying strategically.

Professional buyers treat their spreadsheet like a CRM. They log seller response times, note fabric quality from previous orders, and color-code rows by urgency. You do not need to start at that level, but understanding the philosophy helps you build a foundation that grows with your habits.

Column-by-Column Setup Guide

Let us build the perfect sheet together. Open a blank workbook and create these twelve columns. We will explain the purpose of each one and show you which formulas make the sheet truly intelligent.

1. 1

   Column A: Item ID

   Create a simple numbering system (001, 002, 003). This becomes your reference code when talking to agents or sellers.

2. 2

   Column B: Product Link

   Paste the direct Weidian or Taobao URL. Use HYPERLINK formula to make it clickable without cluttering the cell.

3. 3

   Column C: Product Name

   Write a short, searchable name. Avoid copying the full Chinese title. Use terms like "Jordan 4 Retro Black Cat" instead.

4. 4

   Column D: Category

   Use dropdown data validation with your main categories: Shoes, Hoodies, T-Shirts, Jackets, Pants, Accessories.

5. 5

   Column E: Seller

   Record the store name or agent name. This becomes invaluable when you need a refund or want to reorder.

6. 6

   Column F: Price CNY

   Enter the Yuan price from the listing. In the next column, we will convert it automatically.

7. 7

   Column G: Price USD

   Use the formula =F2*0.14 (or current exchange rate). This auto-converts CNY to USD for budget clarity.

8. 8

   Column H: Size / Notes

   Your target size, colorway, and any special requests like "no shoebox" or "extra QC photos."

9. 9

   Column I: Status

   Dropdown with: Wishlist, Ordered, In Warehouse, Shipped, Received, Returned. This powers your visual workflow.

10. 10

    Column J: Priority

    1-3 scale. 1 means buy immediately if restocked. 3 means nice to have. Sort by this column before every purchase session.

11. 11

    Column K: Date Added

    TODAY() formula. Knowing how long an item has sat in your wishlist helps you decide if you still want it.

12. 12

    Column L: Notes

    Free text for QC results, fit reviews, or links to Reddit comparison threads.

Advanced Formulas for Power Users

Once your basic sheet is running, these three formulas will save you hours every month. They turn a static list into a living dashboard.

• Auto-Budget Summary: In a separate sheet tab named "Dashboard," use =SUMIF('Master List'!I:I,"Ordered",'Master List'!G:G) to see your total committed spend without manual addition.
• Category Breakdown: Use =COUNTIF('Master List'!D:D,"Shoes") to count how many shoe items are in your list. Repeat for every category to visualize your collection balance.
• Restock Alerts: Combine IF and DATEDIF to flag items older than 30 days: =IF(DATEDIF(K2,TODAY(),"D")>30,"Stale","Fresh"). Review stale items monthly and delete what you no longer want.

Workflow Integration with oocbuy.com

Your eastmallbuy spreadsheet should feel like an extension of the oocbuy.com website, not a separate tool. Here is the recommended workflow that connects both platforms seamlessly.

Start every session by opening your spreadsheet and filtering by Priority = 1. These are your hot items. Open each link in a new tab and confirm the listing is still live. If the price changed, update your sheet before adding anything to your oocbuy.com cart. This prevents checkout surprises.

After placing an order, change the Status to "Ordered" and note the date. When you receive QC photos, paste the Imgur link into the Notes column. When the item arrives, update Status to "Received" and add a one-line fit review. Within six months, your sheet becomes a personalized database of trusted sellers and reliable sizing.