Take control of your order tracking by adding custom columns, tags, and formulas to perfectly match your personal workflow.
While CSSBuy provides a powerful spreadsheet for tracking your purchases and shipments, its true power is unlocked through customization. A spreadsheet tailored to your workflow dramatically improves clarity, reduces errors, and saves you time. This guide will show you how.
Why Customize Your Spreadsheet?
- Enhanced Clarity:
- Improved Tracking:
- Automated Calculations:
- Better Sorting & Filtering:
- Improved Tracking:
Step 1: Adding Custom Columns
Insert new columns to track data important to you. Right-click on a column header and select "Insert Column."
Suggested Custom Columns:
| Column Name | Purpose |
|---|---|
Domestic Shipping |
Track the cost from the seller to the CSSBuy warehouse. |
Est. Profit |
For resellers, estimate your selling price minus total cost. |
Destination Country |
Filter items by where they are being shipped. |
Quality Check Status |
Mark as "Pending," "Approved," or "Needs Exchange." |
Step 3: Leveraging Formulas for Automation
Formulas automatically calculate values, eliminating manual errors. Click a cell and start with =.
Essential Formulas for CSSBuy:
// Total Item Cost (Item Price + Domestic Shipping):
=SUM(B2, C2)
// Cost Per KG in Final Parcel (Parcel Cost / Parcel Weight):
=D2/E2
// Profit Margin Calculation ((Sale Price - Total Cost) / Sale Price):
=(F2-G2)/F2
// IF Statement to Flag High Cost:
=IF(H2>100, "Review", "OK")Replace cell references (B2, C2, etc.) with the actual cells in your spreadsheet.
Putting It All Together: A Sample Workflow
- Order Placed:
- At Warehouse:NEEDS QC
- After QC:QC PASS. Add item weight. Formula updates "Cost/KG Estimate."
- Building Parcel:IN HAUL #5. Use sorting to group them together.
- Shipped:
- At Warehouse:NEEDS QC