Step-by-Step CSSBuy Spreadsheet Guide: From Zero to Organized

This is the guide we wish existed when we started. Every step, no assumptions, no skipped details. By the end, you will have a fully functional cssbuy spreadsheet tracking your orders, calculating your profits, and alerting you to problems before they cost you money.

We use Google Sheets in these instructions because it is free, accessible everywhere, and handles formulas well. Excel works identically for most steps. Pick whichever platform you prefer.

Step 1: Create Your Sheet

Open Google Sheets and create a blank spreadsheet. Name it something clear like "CSSBuy Orders 2026." The name matters when you have multiple sheets later.

Immediately share it with yourself by email (File → Share) so you have a backup access method if your primary account has issues.

Step 2: Build Your Header Row

In row 1, enter these exact headers across columns A to M:

Step 3: Add Formulas

Click cell I2 (Total Cost) and enter this formula:

This adds item cost, domestic shipping, international shipping, and agent fee into one total. Drag this formula down column I for all future rows.

Now click cell K2 (Profit) and enter:

This subtracts total cost from selling price to show your profit per item. Again, drag it down column K.

Step 4: Add Dropdown Validation

Select column L (Status). Go to Data → Data Validation. Under "Criteria," choose "List of items" and enter these statuses separated by commas:

Ordered, Paid, To Warehouse, In Warehouse, Shipped, In Transit, Customs, Delivered, Issue

Now every row gets a dropdown instead of free-text typing. No more typos. No more "shiped" instead of "shipped."

Step 5: Format and Color-Code

Select the header row. Bold it. Freeze it (View → Freeze → 1 row). Now your headers stay visible as you scroll through hundreds of orders.

Apply conditional formatting to the Status column:

• Delivered = Green background
• In Transit, Shipped = Yellow background
• Issue, Customs = Red background
• Ordered, Paid = Gray background

Step 6: Add a Summary Dashboard

Create a new sheet named "Dashboard." In cell A1, type "Total Orders." In B1, enter:

In A2 type "Total Spent." In B2:

In A3 type "Total Profit." In B3:

Your dashboard now auto-updates as you add orders. One glance tells you exactly where your business stands.

Step 7: Test With Real Data

Enter one real order. Check that Total Cost and Profit calculate correctly. Verify the status dropdown works. Make sure conditional formatting applies. Fix any issues now, before you have fifty rows to correct.

Once the test order works perfectly, delete it and start fresh. Or keep it as a visible example at the top.

Step-by-Step FAQ