Bulk Buying Guide: Using Your ACBuy Spreadsheet for Group Orders

Group orders require a fundamentally different ACBuy spreadsheet structure. Individual buyer sheets track one person's pipeline. Group sheets track a network of commitments, payments, and distributions.

Tab 1: Group Master. One row per item, not per person. Columns: Item ID, Product Name, Link, Agent, Total Quantity, Total Weight, Total Item Cost, International Shipping (actual), Grand Total, Status.

Tab 2: Member Assignments. One row per member-item pair. Columns: Member Name, Item ID (links to Group Master), Quantity Assigned, Member Item Cost, Member Shipping Share, Member Total, Payment Status, Received Status.

Tab 3: Member Directory. Contact info, payment preferences, shipping addresses, and reliability score (how many on-time payments). Reference this via VLOOKUP in Member Assignments.

Tab 4: Payment Tracker. Payment date, amount, method (PayPal, Venmo, CashApp), transaction ID, and reconciliation status. Cross-reference with Member Assignments to auto-calculate outstanding balances.

Tab 5: Shipping Split Calculator. Enter actual international shipping and weight per package. Auto-calculate per-member share using SUMIF on weight ratios. This is where most group disputes originate — automate it.

Payment disputes destroy group orders more than any other factor. The root cause is usually ambiguity: members do not know exactly what they owe, when it is due, or what happens if they miss the deadline.

Your ACBuy spreadsheet solves this with transparency. Every member can view a read-only link showing only their own rows. They see Item Cost, Shipping Share, Total Owed, Amount Paid, and Balance. No surprises. No trust required — just math.

Set payment deadlines in stone. Record them in the Member Directory tab and reference them in conditional formatting: yellow if unpaid within 48 hours of deadline, red if overdue. Send a single group message: 'Check your balance in the sheet. Payment due Friday.' The sheet becomes the single source of truth.

For convenience, add HYPERLINK() columns pointing to your PayPal.me, Venmo, or CashApp $cashtag. Members click, pay, and update their own Payment Status. This self-service model reduces your administrative time by 70%.

Equal shipping splits are almost always unfair. If one member buys a heavy hoodie and another buys a lightweight hat, splitting shipping 50/50 creates resentment and hidden subsidies.

Use weight-based splitting. Formula per member: (Member Total Weight / Group Total Weight) * Total International Shipping. Record item weights in the Group Master tab when QC photos arrive. Actual weight beats estimated weight every time.

For items with extreme weight disparities, consider a hybrid model: base fee ($3 per member) + weight ratio (remaining shipping). This prevents a member who bought one lightweight item from paying almost nothing while covering fixed packaging and handling costs.

Document your split formula explicitly in the spreadsheet. Add a 'Shipping Method' note in the Group Master tab. When members understand the math, disputes drop by 90%. Transparency is not just ethical — it is efficient.

Group orders never go exactly as planned. Items sell out. Members drop out. Agents refund partially. Your ACBuy spreadsheet must handle these changes without breaking.

Never delete rows. When a member drops out, mark their Assignment rows as 'Cancelled' and recalculate the group totals. This preserves the audit trail and prevents re-adding the same item by mistake.

Recalculate dynamically. Use SUMIF formulas that exclude 'Cancelled' rows. If your Total Group Cost formula is =SUMIF(Status,"<>Cancelled",Cost), cancellations automatically update the totals for remaining members.

Set a change deadline. Announce clearly: 'Changes accepted until Status = Paid. After payment, no cancellations without finding a replacement member.' Record this policy in the sheet's first cell so new members see it immediately.