Organizing Orders with Joyagoo Spreadsheet

Stage 1: Warehouse Receipt

When your agent confirms an item has arrived at their warehouse, update the Status to Arrived (Agent) and record the arrival date in a new column. If your agent provides warehouse photos, paste the QC URL immediately. This is your evidence baseline.

Add a Warehouse Notes column for agent messages like slight color variation or box damage. These notes inform your resale description. If the box is crushed, mention it in the listing. Buyers appreciate honesty, and it prevents return disputes later.

Stage 2: Quality Control Gate

Before any item ships internationally, it passes QC. Create a QC Status column with values: Pending, Inspected, Passed, Failed, Returned. Only Passed items move forward. Failed items trigger a refund request immediately.

Add a QC Date column and a Days in QC formula that calculates how long an item has sat at this stage. Anything over 5 days is a yellow flag. Over 10 days is a red flag. Chase the agent before the return window closes.

Stage 3: Batch Shipping

When you are ready to ship, filter your sheet to show only Passed items. Select the ones going to you, update their Status to Shipped (International), and record the tracking number in a Tracking column. Copy that tracking number to your freight forwarder or postal dashboard.

If you split a haul into two shipping batches, use a Shipment ID column. S01 for the first box, S02 for the second. Later, when items arrive, you can sort by Shipment ID and verify each box contents against the sheet without opening every package first.

Stage 4: Arrival and Inventory

When the box arrives, open it with the sheet visible on your phone. Check each item against the Size and Color columns. Mark Status as Arrived (Local) only after physical verification. If something is wrong, photograph it immediately and update Status to Issue with a description in Notes.

Create an Inventory Location column for resellers with storage space. Values like Shelf A, Box 3, or Prepped Pile tell you where to find the item when an order comes in. Without this, you will tear through boxes every time you make a sale.

Stage 5: Listing and Selling

When you list an item for resale, update Status to Listed and paste the listing URL into a new column. Add a Listed Date and a Days Listed formula. If an item sits unsold for 30 days, consider a price drop or a platform change.

When it sells, update Status to Sold, record the Sale Price, and calculate the Actual Margin against your true cost. Compare Actual Margin to your Estimated Margin. If they diverge consistently, your cost assumptions need recalibration.

Comparison Table

Continue Learning

Frequently Asked Questions