How do I split international shipping fairly?

The fairest method is by weight. Ask your agent for the weight of each item. Divide total shipping cost by total weight to get a per-gram rate. Multiply each item weight by that rate.

What if a member cancels after I have ordered?

Your policy should be clear before collection: no cancellations after the order deadline. If you must absorb the item, track it as "Organizer Inventory" and resell it independently.

How many members is too many for one spreadsheet?

Up to 20 members is manageable in one sheet. Beyond that, use a member-facing summary tab and keep the master details in a separate organizer-only tab.

Should I charge an organizer fee?

Most organizers add 5-10% or a flat fee per item to cover their time, risk, and shipping materials. Be transparent about this fee in your initial announcement.

Bulk Buying Guide: Using Basetao Spreadsheet for Group Orders

Bulk buying through Basetao saves money per item, but it multiplies complexity. When you are coordinating sizes, payments, and shipping for multiple buyers, a simple list is not enough. You need a basetao spreadsheet built specifically for group orders and bulk coordination.

This bulk buying guide covers the complete workflow: collecting member requests, organizing the master order, tracking individual payments, managing warehouse distribution, and closing out the financials. Every step includes a basetao spreadsheet technique to keep you organized.

Phase 1: Collecting Member Requests

Before placing any order, collect all member requests in a standardized format. Create a Google Form with fields for Item Name, Product Link, Size, Color, and Quantity. Responses feed directly into a new tab in your basetao spreadsheet.

Standardized collection eliminates the chaos of DMs, screenshots, and voice messages. Members cannot claim they requested a different size when their submission is timestamped and documented. The form becomes your legal record.

Phase 2: Building the Master Order Sheet

Consolidate all form responses into a master order tab. Group identical items together. If five members want the same T-shirt in different sizes, create one row per size with a comma-separated member list or a sub-table.

Your master order basetao spreadsheet needs these columns beyond the standard buyer setup: Member Names, Member Payment Status, Size Breakdown, and Shipping Share. The Shipping Share column divides total international shipping proportionally by item weight or value.

Column	Purpose	Formula/Format	Why Essential
Member Names	Who ordered this item	Comma separated list	Distribution accuracy
Payment Status	Who has paid	Dropdown: Paid/Pending	Cash flow tracking
Size Breakdown	Quantity per size	S:2, M:3, L:1	Agent clarity
Item Subtotal	Price * total quantity	=E2*F2	Budget planning
Shipping Share	Intl shipping per member	Proportional split	Fair cost distribution
Member Total	What each person owes	Sum of their items + shipping	Collection accuracy

Phase 3: Payment Collection

Create a separate "Payments" tab in your basetao spreadsheet. List every member, their total owed, what they have paid, and their balance. Use conditional formatting to highlight members with outstanding balances in red.

Never place the master order until you have collected at least 80% of funds. This protects you from members who ghost after you have already paid the agent. Set clear deadlines and enforce them. Your basetao spreadsheet makes enforcement objective because the numbers are public to the group.

Phase 4: Warehouse to Member Distribution

When items arrive at the warehouse, your agent sends QC photos. Match each photo to your basetao spreadsheet rows. Update the Status column to "In Warehouse" and paste the photo album link in a QC Link column.

Create a member notification system. When all items for a specific member are in warehouse, message them with a summary from your sheet. They approve shipping individually or as a group. Your spreadsheet tracks who has approved so you do not ship items that members want to hold for consolidation.

Phase 5: Final Reconciliation

After all items are delivered, close the financial loop. Compare your actual costs (agent invoice + international shipping + any surprise fees) against what you collected. If you over-collected, refund the difference. If you under-collected, explain the shortfall with line-item transparency from your basetao spreadsheet.

Transparency builds trust. Members who see exact numbers are more likely to join your next bulk buy. Members who feel overcharged without explanation will not return. Your spreadsheet is your reputation.

Always over-estimate shipping by 10-15% when collecting initial payments. Refund the difference later. Members prefer a surprise refund over a surprise extra charge.

Designate one person as the sole data entry point. Multiple people editing a group order sheet creates version conflicts and formula breaks.

Share a read-only view of the master sheet with all members. Transparency reduces questions and disputes. Lock payment columns so only you can edit them.

Keep a "Disputes" note column. If a member complains about anything, document it in the sheet. This prevents "he said she said" situations and shows you take accountability seriously.