Seller ratings change over time. This tutorial explains how to refresh data, import new sheets, and keep your Kakobuy Spreadsheet aligned with the latest community information.
Maintaining an accurate Kakobuy Seller Spreadsheet is crucial for making informed purchasing decisions. As seller performance evolves, your data needs to reflect these changes. Follow this guide to ensure your spreadsheet is always up-to-date.
1. Refreshing Existing Seller Data
To update the ratings and status of sellers already listed in your sheet:
- Locate the "Data" Menu:Data
- Refresh All Connections:Refresh AllRefresh Sheet. This will fetch the latest metrics for sellers linked to live Kakobuy data sources.
- Verify the Update:"Last 30-Day Rating", "Transaction Count", and "Store Status"
2. Importing a New Data Sheet
When the community releases a completely new version of the seller list:
- Download the Latest File:kakobuy_sellers_v2.5.xlsx) from the official channel.
- Create a Backup:
- Import or Copy Data:
- Option A:File > Import
- Option B:
- Import or Copy Data:
3. Aligning & Merging Information
To combine historical notes with new data without losing customization:
- Use VLOOKUP or XLOOKUP:
- Highlight Discrepancies:
- Archive Old Data:
- Highlight Discrepancies:
Best Practices for Data Hygiene
- Schedule Regular Updates:
- Validate Sources:
- Maintain Your Notes:
- Validate Sources: