Every new seller asks me what software I use to run my business. They expect me to say some fancy CRM or some $200/month tool with a dashboard and 47 integrations. Nope. Google Sheets. That is it. I have three sheets that run everything. Let me walk you through them. THE BUY SHEET Every single purchase I make goes in here. The ASIN, which retailer I bought from, the order number, how many units, what I paid, the expected sell price, and my estimated ROI after fees. Every. Single. Purchase. This is the sheet that saved me when I started feeding my data into AI tools in 2025. Three years of purchase history, every retailer, every price point, every outcome. That gave me a competitive advantage nobody else had because nobody else tracked it. Most people think tracking purchases is boring busywork. It is. But two years from now you will either have a goldmine of data or nothing. Your choice. THE LEAD DATABASE I have about 2,300 lines in my lead database right now. Every ASIN I have ever looked at, from which stores, at what prices, and why I passed on it or bought it. Here is the thing. You will be gated in 80-90% of the leads you find. That is fine. This database is not just for today. It is for your future. One year later you Control+F an ASIN and you can see every time you looked at it, from which stores, at what prices. Conditions change. Gating changes. Prices change. A lead you passed on 6 months ago might be a winner today. The sellers doing $20K months are not finding brand new products every single day. They are recycling their lead database and catching products when conditions change. THE PREP SHEET This one tracks what has been labeled, what has been shipped, and what is sitting at my prep center. Sounds simple but when you are managing 50-100 SKUs, you need to know exactly where everything is at all times. Without this sheet, you end up with units sitting at your prep center for 3 weeks because you forgot to send shipping instructions. That is money sitting on a shelf doing nothing.

Most people start OA by randomly browsing retailer websites hoping to find a deal. That works sometimes. But it is painfully slow and there is zero consistency to it. What changed everything for me was building a seller ID database. Once you have one, you are not guessing anymore. You are working from a list of products that REAL resellers are already selling profitably. Here is exactly how I do it. STEP 1: FIND CROWDED LISTINGS Open Keepa Product Finder and set the minimum FBA offers to something like 8 or 10. You are NOT looking for a good listing to sell on. You are looking for a listing with a LOT of resellers on it. The more sellers, the better for this step. Those sellers are your goldmine. STEP 2: EXTRACT THE SELLER IDs Once you find a crowded listing, scroll down to the Keepa chart. Click the Data tab, then the Offers tab. You will see all the sellers listed there. Copy their seller IDs one by one. Yes it takes a bit of time. That is the point. You are building an asset. STEP 3: VALIDATE EACH SELLER Paste each seller ID into the Keepa Product Finder seller ID section. Check how many products they carry. If they have 15 to 20 or more products listed, they are probably a reseller just like you. Add them to your spreadsheet. If they only have 2 or 3 products, skip them. They are probably just clearing out their garage. STEP 4: TREAT THIS LIKE A SOURCING SESSION Here is the mindset shift that most people miss. Do not try to build your database AND source leads at the same time. Separate the two. Spend a dedicated hour JUST collecting seller IDs. No analyzing products. No checking margins. Just building the list. Then later, you use the list. STEP 5: USE THE DATABASE WITH KEEPA PRODUCT FINDER Once you have a solid list, take 20 seller IDs at a time. Format them as a comma separated list (I just paste my spreadsheet into ChatGPT and ask it to format them). Drop those 20 IDs into Keepa Product Finder and it will pull up every product those 20 sellers carry. That is usually around 1000 listings. Then you apply your filters to narrow it down to a realistic batch you can actually analyze in one sitting.