Short Answer
This free Excel sheet is a blank tracker for Daraz product research. You log each idea with its source, cost, planned price and competitor prices, get a quick margin estimate from your own numbers, move it through a status list, and score candidates on a separate sheet. It holds no data or demand claims.
This is a blank Excel tracker for Daraz product research. It keeps your ideas, suppliers, competitor prices and margin estimates in one place, so decisions rest on numbers you wrote down rather than on memory.
Download daraz-product-hunting-sheet.xlsx
The file is about 30 KB. No macros, no sign-up, and no pre-filled products or claims.
What Is on Each Sheet?
- Tracker: 200 rows. Columns for date, product, product link, category, supplier and supplier link, cost, planned price, lowest and highest competitor price, commission rate, other-fees allowance, packing and shipping to you, estimated profit, estimated margin, a status dropdown, decision date, notes and next action.
- Settings: one cell for VAT on commission, set to 15 percent because that is what we saw on the statements we checked.
- Scorecard: six criteria (demand, competition, margin after fees, ease of shipping and packing, return risk, supplier reliability) with weights you set, and a weighted score out of 5 per product.
- Read me: instructions and limits.
How Do I Use It?
- Add a row for each idea. Paste the product link, the supplier and what you would pay per unit.
- Enter the price you plan to sell at, and the lowest and highest competitor prices you saw on Daraz that day.
- Find the category in the Daraz commission list and type its rate in the commission column.
- Put an allowance for payment fee, handling and tax withholding in the other-fees column. Check a real weekly statement to choose it. Our guide to Daraz seller fees lists each line.
- Read the estimated margin. Move promising rows from Idea to Researching, then to Sample ordered or Listed. Mark the rest Rejected with a note on why.
- For the finalists, fill the Scorecard and compare weighted scores.
Example: How the Margin Estimate Works
Example (made-up numbers): planned price Rs 1,000, cost Rs 500, packing and shipping to you Rs 20, commission 10 percent, other-fees allowance 6 percent.
Commission with VAT is 10 x 1.15 = 11.5 percent. Add 6 percent and the percentage costs are 17.5 percent of price, Rs 175. Estimated profit is 1,000 - 500 - 20 - 175 = Rs 305, a 30.5 percent margin. Those rates are placeholders; you supply the real ones.
What Are the Honest Limits?
- It does not find products, count sales or judge demand. Any demand claim has to come from your own evidence.
- The margin estimate is a quick filter. It ignores returns, vouchers and shipping charges Daraz bills you. Run finalists through the profit calculator sheet or the online profit calculator.
- Rates and fees change. Check Seller Center.
- A spreadsheet tracks products; it does not list them. When you pick a winner, Seller's Revolution can copy a Daraz product from a link into your store.
Questions
Does the sheet find products for me?
No. It is a blank tracker. It does not scrape Daraz, estimate demand or list best sellers. You type what you find, from any source you trust, and the sheet organises it and estimates the margin from your own numbers.
How is the estimated margin calculated?
Estimated profit is planned price minus cost, minus packing and shipping to you, minus price times (commission rate with 15 percent VAT added, plus your allowance for other fees). It is a quick filter. For a full statement-style calculation, use the profit calculator sheet.
Where do I find the commission rate for a product?
Look up its category in the Daraz commission list and type the rate (excluding VAT) into the commission column. The sheet adds VAT on top using the Settings sheet.
Can I use the scorecard with my own criteria?
Yes. The scorecard has six criteria with a weight row you set from 0 to 5, and you rate each product from 1 to 5. Rename the headings to fit your own way of choosing products.
Sources
Related
Skip the Spreadsheet
Start free with 50 credits, or use a free tool first.