Orientdig Spreadsheet for Bulk Buyers Explained

Bulk buying requires different tracking. Learn the lot-based system, per-unit cost averaging, and supplier scorecards built for volume purchasing.

Bulk Buying Is a Different Game

Buying one item at a time is simple. Buying 500 items in a mixed lot is complex. You cannot track unit economics the same way. The orientdig spreadsheet bulk buyer edition introduces lot-based tracking, blended cost calculations, and supplier reliability scoring at scale.

Lot Tracking System

Every bulk purchase gets a Lot ID. This Lot ID ties together all items from a single buy. Your orientdig spreadsheet has a Lots master tab with: Lot ID, Purchase Date, Supplier, Total Cost, Total Items, and Notes. Individual items in the Product Registry reference their Lot ID. This linkage lets you trace profitability back to the original purchase decision.

Blended Cost Calculation

If you paid $1,000 for a lot of 100 mixed items, your blended cost per item is $10. But not all items are equal. A Jersey might retail for $80 while a T-Shirt retails for $25. Use a Weighted Cost column in your orientdig spreadsheet that adjusts the blended base by category multiplier. Jerseys get a 1.5x multiplier, T-Shirts get 0.8x. This reflects reality better than flat averaging.

Bulk vs Individual Buying Comparison

Supplier Scorecard for Bulk

Bulk suppliers are harder to evaluate because each order is large and infrequent. Track these metrics per lot: On-Time Delivery (yes/no), Accurate Count (expected vs received), Defect Rate (percentage), Communication Quality (1-5), and Will Reorder (yes/no/maybe). After 3-5 lots, patterns emerge. You will know which suppliers deserve your five-figure orders and which to avoid.

Cash Flow Planning

Bulk buying ties up capital. Add a Capital Tied Up column and a Days to Recover column in your orientdig spreadsheet. Capital Tied Up multiplies stock quantity by blended cost. Days to Recovery divides that by average daily profit. If a lot takes 120 days to recover, you know not to buy another until cash frees up. This discipline prevents the cash crunch that kills growing resellers.