This tutorial walks you through every single step of building a functional hipobuy spreadsheet. You do not need any experience. Just open Google Sheets and follow along. By the end, you will have a working tracker that you can use for your next order.
Open Google Sheets and click Blank. Name your sheet Order Tracker. This will be your main workspace. You can create additional sheets later for different agents or time periods.
Set up your column headers in row 1. Make them bold. Add a light background color so they stand out. These headers are the foundation of your system.
In row 2, add your first item. For example: Item Name = Nike Dunk Low, Link = the product URL, Size = 42, Color = Panda, Price = 45, Qty = 2.
Leave the calculated columns empty for now. We will add formulas in the next step.
In the Total column (I2), enter: =E2*F2+G2+H2. This calculates total cost. In the Profit column (K2), enter: =J2-I2. This shows your profit per item.
Select these cells and drag the fill handle down to copy the formulas to future rows. Now every new row will auto-calculate.
Create a status column with dropdown values. In Google Sheets, select the column, go to Data > Data validation, and enter these options: Ordered, In Warehouse, Shipped, Delivered, QC Issue.
This prevents typos and keeps your status tracking consistent.
Conditional formatting makes your sheet visual. Select the Status column, go to Format > Conditional formatting, and create rules: green for Delivered, yellow for Shipped, red for QC Issue.
Now you can see your order health at a glance without reading every row.
Yes. Common additions include: Weight, Tracking Number, QC Photos, Customer Name, and Notes.
Check that the cell references point to the right columns. If you add columns, formulas may shift.
Create a separate sheet without profit columns. Share only the necessary information.
Start with one. Add more sheets when you have a clear reason, like separating by agent or month.
Go to File > Print. You can adjust margins and scale to fit on one page.
Get the best hipobuy spreadsheet templates and start tracking today.