Mastering Group Orders: A Simple Guide to Using the Joyagoo Spreadsheet
Organizing shared hauls with friends has never been easier. The Joyagoo spreadsheet is your all-in-one tool to streamline the entire process, from listing items to final cost-splitting. This guide will walk you through how to use it effectively.
Getting Started: Setting Up Your Master Sheet
Begin by creating a new Joyagoo spreadsheet for your group order. Title it clearly, for example, "Summer Fashion Haul – June Order". The first tab should be your Master List.
- Column A - Item Link:
- Column B - Item Description:
- Column C - Price per Unit:
- Column D - Quantity:
- Column E - Buyer Name:
- Column B - Item Description:
Splitting Costs Fairly and Transparently
The true power of the Joyagoo sheet lies in its automatic calculations. Set up the following columns next to your Master List:
- Column F - Domestic Shipping:
- Column G - International Shipping Weight:
- Column H - Notes:
- Column G - International Shipping Weight:
Use a separate "Cost Summary"proportional split
Assigning Parcels and Tracking Details
As your order arrives at the warehouse and gets repacked, manage logistics seamlessly.
- Create a "Parcels" Tab:
- List the Parcel ID, Contents Summary, Total Weight, and Shipping Cost.
- Assign the parcel to the main receiver
- Include tracking numbers
Managing Multiple Buyers' Information Clearly
Keep sensitive data organized and confidential with a dedicated "Buyers Info"
Key Takeaways for a Smooth Group Order
By leveraging the Joyagoo spreadsheet, you turn the chaos of a group haul into a clear, manageable project. Centralize information, automate calculations, and maintain transparency