How to Use Eastmallbuy Spreadsheet Step-by-Step

What You Need Before You Start

Before opening your first eastmallbuy spreadsheet, gather three things: a list of products you plan to order, your supplier catalog with SKU codes, and a clear idea of your customer delivery addresses. Having these ready prevents mid-setup interruptions that break your flow.

Choose your platform. Google Sheets works best for beginners because it is free, auto-saves every keystroke, and runs on any device with a web browser. Excel offers more advanced formula power but requires a subscription for full cloud features. Apple Numbers is excellent for Mac users who value clean design.

Download our free eastmallbuy spreadsheet template to skip the setup phase entirely. The template includes pre-built formulas, dropdown menus, and conditional formatting rules. Open it, make a copy under your own account, and you are ready to begin.

Understanding the Column Structure

Every eastmallbuy spreadsheet relies on a logical column structure. Understanding what each column does before you enter data prevents costly reorganizations later.

Column A is Order ID. Assign a simple sequential number to every order. This becomes your primary reference when customers ask about specific purchases. Never reuse an Order ID, even if an order cancels.

Column B is Order Date. Use a standard date format like YYYY-MM-DD so sorting works correctly across international time zones. This column feeds into reporting formulas that calculate weekly and monthly sales trends.

Column C is Product Name. Write the full product name exactly as it appears in your supplier catalog. Consistent naming lets you filter and group identical products to see which SKUs sell best.

Column D is SKU. The supplier stock-keeping unit is the most critical field for accuracy. One wrong digit means the wrong item ships. Use data validation to restrict SKU entries to a predefined list from your supplier.

Column E is Size and Column F is Color. For fashion items, these columns separate otherwise identical SKUs. Always enter the standardized size format your supplier uses to avoid confusion between US, UK, and EU sizing.

Column G is Unit Price. Record the supplier price in the currency they charge you. Do not convert here; conversion happens in a separate column so you preserve the original data for dispute resolution.

Column H is Quantity. This drives your total cost formula. Enter integers only. Decimals in quantity fields break most inventory calculations.

Column I is Total Cost. This formula multiplies Unit Price by Quantity. Lock this column so you never accidentally overwrite a formula with a static number.

Column J is Status. Use a dropdown with options: Quoted, Ordered, Paid, Shipped, Delivered, Cancelled, Returned. This single column powers your entire visual dashboard when combined with conditional formatting.

Entering Your First Batch of Orders

Now that your columns are ready, populate the sheet with real data. Start small. Enter ten to fifteen orders manually before importing bulk data. This practice reveals any column-width issues, formula errors, or formatting quirks.

Type directly into each cell or copy and paste from supplier invoices. If you copy from PDF invoices, watch for hidden line breaks that split product names across multiple rows. Clean these with Find and Replace before proceeding.

After entering the first batch, verify every Total Cost cell shows the correct multiplication result. Click a few cells to inspect their formulas. If you see a number instead of a formula, someone overwrote the cell. Restore the formula immediately.

Apply filters to the header row by selecting the entire header and clicking the filter icon. Test each filter. Sort by Status to see only Shipped items. Sort by Product Name to group identical SKUs. If filters behave strangely, check for extra blank rows between data entries.

Setting Up Conditional Formatting for Visual Tracking

Conditional formatting turns a boring grid into an intuitive dashboard. With three simple rules, your eastmallbuy spreadsheet communicates status at a glance.

Rule one: highlight Delivered rows in green. Select the Status column, open conditional formatting, and set the rule Status equals Delivered. Choose a soft green fill. Now every completed order visually fades into the background, letting you focus on active orders.

Rule two: highlight Cancelled and Returned rows in red. Use a pale red fill so problem orders stand out immediately during your daily review. This prevents accidentally re-ordering returned items before resolving the underlying issue.

Rule three: highlight Quoted rows in yellow. These are orders you have priced but not yet confirmed. The yellow reminder ensures no quote expires unnoticed, especially for suppliers with limited stock windows.

Add a fourth rule for rows older than fourteen days with Status still set to Ordered. Use a light orange fill. This catches orders that suppliers forgot to ship, a common problem with high-volume bulk sellers.

Maintaining Your Eastmallbuy Spreadsheet Over Time

A spreadsheet is only useful if it stays current. Build these maintenance habits from day one and your eastmallbuy spreadsheet will remain accurate for years.

Habit one: update status immediately. The moment you receive tracking, change the status to Shipped. The moment delivery is confirmed, change it to Delivered. Delayed updates multiply into inaccurate inventory counts and unhappy customers.

Habit two: archive monthly. Create a new tab or file every month. Name it clearly, like Orders-May-2026. Keep the current month active and move completed older months to an Archive folder. This keeps your working file fast and responsive.

Habit three: audit weekly. Every Sunday, scan for orphan rows where Status is blank or Total Cost looks suspiciously high. These are early warnings of data entry mistakes before they affect customer orders.

Habit four: backup daily. Even cloud storage has outages. Export a CSV copy to your local drive every evening. The thirty seconds this takes saves weeks of reconstruction if something goes wrong.