Cssbuy Spreadsheet for Resellers: Inventory, Margins, and Profit Tracking

Reselling Changes Everything

Personal shoppers track items. Resellers track business. Your cssbuy spreadsheet becomes an inventory management system, accounting tool, and profit calculator rolled into one document.

Essential Reseller Columns

• Product Link
• Item Name
• Category
• Purchase Price (CNY)
• Domestic Shipping
• International Shipping
• Total Cost (auto-calculated)
• Local Market Price
• Estimated Profit (auto-calculated)
• ROI Percentage (auto-calculated)
• Platform: Where you plan to sell
• Listing Status: Not Listed, Listed, Sold, Returned
• Date Sold
• Buyer Notes

Calculating True Profit

True profit is not Local Price minus Item Price. It is Local Price minus Total Cost minus Platform Fees minus Packaging minus Shipping to Buyer. Build a formula that captures every expense so you know your real margin before listing.

Inventory Management

Use conditional formatting to highlight slow movers. Items unsold after 60 days turn yellow. After 90 days, turn red. This visual cue tells you when to discount, bundle, or remove listings.

Bulk Order Tracking

Resellers buy in volume. Add a Batch ID column to group items from the same warehouse shipment. When QC photos arrive, you know exactly which items belong together without cross-referencing order numbers.

Reseller Spreadsheet vs Basic Tracker Table

Scaling Your Sheet

When you pass 50 active items, consider splitting into multiple sheets. One for active inventory. One for sold history. One for wishlist research. Link them with IMPORTRANGE so data flows between sheets without duplicate entry.