You have built your fishgoo spreadsheet. Now it is time to make it work for you, not the other way around. This guide covers advanced techniques that separate casual users from power users: conditional formatting, automated alerts, multi-currency handling, supplier scorecards, and the exact workflow top resellers use to process 50+ items per week without breaking a sweat.
Start With Conditional Formatting
Conditional formatting turns a boring grid into a visual dashboard. In Google Sheets, select your Profit Margin column, open Format → Conditional Formatting, and set three rules: green for margins above 30%, yellow for 10–30%, and red for below 10%. At a glance, you will know which items are worth buying and which are not.
Apply the same logic to your Status column. Use color coding: gray for Researching, blue for Ordered, orange for Shipped, and green for Arrived. Your entire pipeline becomes a traffic light system.
Build a Supplier Scorecard
Not all sellers are equal. Create a separate sheet tab named Suppliers. Track each seller by: Name, Store Link, Items Ordered, Average Quality Rating (1–5), Average Shipping Time, Return Rate, and Overall Score. Use an AVERAGE formula for the Overall Score column.
After 10 orders, patterns emerge. You will discover which sellers deliver fast, which pad their photos, and which are worth repeat business. This data alone can save you hundreds of dollars in bad purchases.
Automate Currency Conversion
Manually checking exchange rates is tedious and error-prone. In Google Sheets, use the GOOGLEFINANCE function: =GOOGLEFINANCE("CURRENCY:CNYUSD") to pull the live CNY-to-USD rate. Then reference this cell in all your price calculations.
For multi-currency buyers, create a small Settings tab with cells for CNY→USD, CNY→EUR, and CNY→GBP rates. Reference these cells in your formulas. One rate update refreshes your entire sheet.
Set Up Automated Alerts
Use Google Apps Script to send yourself email alerts when a status changes. For example, when you mark an item as Arrived, the script can automatically email you a reminder to take QC photos and list the item for resale.
Even without scripting, you can use Zapier or Make.com to connect your Google Sheet to Telegram, Discord, or email. Set triggers for status changes, low-margin alerts, or shipping delays.
Advanced Filtering and Search
As your sheet grows past 100 rows, finding items becomes painful. Use Filter Views (Data → Filter Views) to create saved filters: one for Items in Warehouse, one for High-Margin Opportunities, one for Items Awaiting QC Photos. Each filter view is a saved lens on your data.
For even faster search, add a Search column using the FILTER function. Create a cell where you type a keyword, and a separate area instantly shows all rows where Item Name or Store Link contains that keyword.
Batch Processing Workflow
Top resellers do not process one item at a time. They batch. Here is the exact workflow: once per week, export your agent's warehouse photos into a folder named with the date. Cross-reference each photo with your sheet using the Order ID column. Mark Arrived items, update profit margins with actual shipping costs, and flag any items that fail QC for return.
This 30-minute weekly ritual keeps your sheet accurate, your inventory clean, and your profit calculations honest. Skipping it is how margins silently disappear.
Put Your Spreadsheet to Work
All the planning in the world means nothing without action. Visit our main fashion store and turn your organized research into real purchases.
Frequently Asked Questions
Common questions about fishgoo spreadsheets answered.