For the past couple of weeks, I’ve had two friends helping me with my business. One searches for products online and the other scans bar codes in the retail stores.
Having helpers is new to me and I wanted to make their first “jobs” as easy as possible. Luckily, I learned about ScanSheet beforehand because it made their initial tasks simple. In this post, I’ll tell you more about what we (and ScanSheet) are doing.
Using ScanSheet for Finding Profitable Products Online
After some initial training, I started Mary (name changed for privacy) with doing online product searches for me. I gave her the links to a couple of websites and gave her a category to focus on. Her task was to find the product match on Amazon, then copy the ASIN, Title and Buy Cost into a spreadsheet:
As you can see, the spreadsheet doesn’t tell me anything about the quality of the product finds. I have no idea if the products are profitable or not. However, with ScanSheet, I’m easily able to find out.
Using ScanSheet to Analyze Spreadsheets
ScanSheet requires an Excel spreadsheet in a specific format. Therefore, the first thing that I do is copy the ASIN, Title and Cost columns from the spreadsheet that Mary completed and paste it into Excel. Then I take about 30 seconds to format it correctly:
The next step is to upload the spreadsheet to ScanSheet and let it run its magic.
Once done, I get an interactive page that displays the Rank, ROI %, Net Profit, Category and other helpful data for each item that ScanSheet found an Amazon match for. There are also links to the Amazon Product page, CCC, Keepa and PriceZombie so I can research the products further:
To make it easier to find products that meet a specific buying criteria, ScanSheet lets you filter the results by Min Profit, Min ROI %, Max Rank and Category. Also, you can download the results to your computer as an Excel Comma Separated Value (.csv) file.
What I like about ScanSheet is that Mary didn’t have to be trained on how to use the FBA Calculator or how to pick a product based on my criteria. This saved us both on training time and neither of us became overwhelmed early on.
** Training Mary in person worked well for me, but I do plan on making some training videos for her. However, I couldn’t do that earlier because I didn’t have a microphone! Yesterday, my new Blue Yeti Microphone was delivered and I’m going to make practice videos right away.
Using ScanSheet with RA and Wholesale
Besides running Mary’s spreadsheets, I also use ScanSheet to run the spreadsheets that my other friend sends me. This friend scans bar codes in the retail stores using Scoutify (InventoryLab’s Scouting App). When she’s finished, she emails me the Buy List that Scoutify created:
Besides helping with OA and RA, I’ll be using ScanSheet with any wholesale price sheets that I hope to receive soon. **By the way, I was recently approved for my first wholesale account!
It’s easy to sign up for ScanSheet. Just go to the sales page and scroll down to the bottom. There, you’ll see the different subscription plans with “Subscribe” buttons. I’m currently on their $10 a month plan.
As always, please let me know if you have any questions either in the comment form below or on my Facebook page!