9-Figure Shopify Product Research Guide (model my spreadsheet)

A tutorial video showing how to conduct Shopify product research and populate a shared product-research spreadsheet. The presenter explains picking 3 research methods, copying the provided Google Sheet template, filing 5–10 candidate products (name, price, category, links to competitor sites and ads, video assets), and using competitor analysis (product pages, reviews, ads, price, scarcity/promotions) to model then iterate. Final step: share the sheet via the members portal for coach review.
Chapters
All right, welcome back. In this video, I'm going to show you how to do product research and then fill your sheet. So first thing you want to do in the course in pillar four, go through the different product research method methods that we teach. Study it first, get an idea what you can do, what are the different options? And then once you review that, you're going to pick your top three methods. You don't need to use all of them, just pick the ones you like that you find to be most useful, pick them and then begin your research. And now what you want to do is click here on file and then make a copy, right? So this sheet that you can actually edit, the master sheet you cannot because we give it to clients as a template to make a copy from. Okay, so now you're going to have your sheet, bookmark it, you're going to be using it, right? So just click the little star. Now once you have a copy, you're going to go ahead and research these five, 10 different products. I'm not going to show you how to do that in this video because there's plenty of others showing that. But I'll give you an example of how to fill it up and how the sheet works. Okay, so on the left hand side you've got categories. So you can also edit this and add your own categories if there's anything else that you want to look at. So right now we have beauty supplements, gadgets, home miscellaneous. So you just pick the category and then when you found the product that you like, you're gonna pull the name and just literally copy paste it. Okay, that's the name and then take the price, right? So you're gonna copy paste the price. And then this part over here is how much you could be charging for. Now the best way to begin is to model and then innovate. So what I mean by that is the fastest way to success is to find something that's working for somebody else, copy it, model it, maybe make some slight changes so it's obviously not copyright infringement, and then just run with that. And then in the future you can adjust the price, you can innovate, you can do things to make it better different or test different products. But in the beginning we work and we start with what works. So for instance, this one I found in my Neo, this Apple car Mini Play, there's even a video ad that you can use and I go to their site. So they charge 14k 400. So let's do the math on that. So in USD that's around 40 bucks. Okay. So here, excuse me, in the copy of the sheet. And maybe I'll just do this in the original one. So I'll go back here. Could be 40 bucks. Okay. And then obviously this would be like gadgets, okay? Wow factor. So let's. Let's look at this on AliExpress. All right? Like, some variables that make this a good product. So there's plenty of sold. Okay. These people are running ads to it. They're making money. Over here, you see the engagement. So they started in May, and it keeps growing, growing, growing. So that means they've been running for two months. The more engagement they're getting, the more money they're spending, the more money they're making. Okay, so in terms of the wow factor, it's something pretty cool. It's a tiny little USB and it enables CarPlay in the car. So. So in terms of wow factor, it's. It's not that unique, per se. It's just the video ad really shows it well. And this is one of those examples where the product doesn't have to be that unique or that cool, but it gets the job done. It has the utility benefit. It's great, clearly demonstrated and shown, and essentially it's just worth it. Whether you sell it for 30, 40, 50 bucks gets the job done. Okay, so this is a video ad that you can actually go ahead and download and then we can use later. So link to the product. You would take this copy, paste, just paste it there. Then competitor size. So you just take the URL and go here. Now I got the site link from right here. Okay. And so what you want to do in the beginning is you look at the competitor site and then just see how they're selling you. Right? They get the little benefits here, they got the cool different pictures and then more information about the products. You can see a lot of this they probably just pulled from AliExpress, all the cars it works with, etc. Even on AliExpress, you can scroll down and in these reviews, you'll be able to copy over and show us your review. So if I look at their site, they don't really show reviews. You know, that's one thing that you could do immediately to increase conversions and make it better. Okay, let's see what else they got. So you see, these are technically some of the pictures that they took, Right? So you could take these pictures and then just put it on your website. Perfect. So you can take these pictures. I would also take these. And then you can find the competitor without branding Right. Or in the future when you buy your own product, you could put your branding on it as well. Because in the future what you want to do, once this works, you go to supplier, you're going to start ordering them both. Maybe get 100 of these and then maybe instead of paying 19 bucks, you'll be able to pay $10 or even less. Okay, so let's go back here. So we got the link, the competitor site and then the ad link. So what you want to do here is click on see ad post. Then you're going to be able to take this link, then just put it here. If you find different ads and competitors ads, you could put them there and you can even create multiple rows. Add 1, 2, 3. Okay, so now that you have this here, you're able to. So I'll show you how to do that as well. Press stop. And in here you want to get this plugin over here and you're able to essentially download this video. So there's several versions. Trying to find the one with the. Alright, so this is probably the highest resolution because you can see the biggest file size. Okay. And there might be even a bigger one. So let me download this. Let me just make sure it is the correct one. In the meanwhile, let me tell you about this plugin. So it's called Video Downloader Professional. Okay. You just google that and it's this one, right? So you just add to Chrome and then anytime you see a video ad that could be good, you go ahead and download it. So it's still downloading, just give it a couple minutes. Meanwhile, I can also try to download the smaller size which was the three megabytes. Okay, let me try again. Okay. I'm not entirely sure what's up with the Internet. I use this earlier. Just fine. There's different plugins like this that can download these videos. So it shouldn't be a problem. It's just like a technical bug. In a worst case scenario, if it's not letting you download it, you can use an app, kind of like loom. Loom.com and then you just record your screen and then you take the video. So literally just do like a screen recording and then you have the same video with the audio. And then of course you want to make some minor changes. Right.
So to convert Wired carplay into wireless, The connection is simple. It's smoother than the original factory. How to convert Wired carplay into wireless.
And when you build your ad as well, you can see what works for them. Right. So the headline of the ad the copy, etc. And I'm looking at the copy. This could be made a lot better. Even the headline could be made better, the video could be made better. So essentially you take what works and you either copy it as closely as possible or once you get more experience and you know what works versus what doesn't. Like I'm just looking at this ad and there's an easy way to make this better in terms of the copy, in terms of the video. Even looking at the sales page, you're easily able to improve the sales page. And one of the biggest ones is just add testimonials and reviews from AliExpress, right? You can even put free shipping and there's many, many different things that you could do to make it better. Or you could even create a one page landing page for this and really just sell this one product is typically they convert better. I'll give you an example real quick. In this video, like these guys, they created a one page landing page, right? So you go here and instead of having like a product page that you typically see and like in this store, like a Shopify store, Woocommerce, you have a one page landing page, right? So it just kind of sells it pre sells it, you go click and now it actually goes to the product page. Once they pre sold, they read the sales page. It's nice, well put together. And so if you compare these two sites, I might as well take extra couple minutes to give some extra lessons. Like look at it, there's a discount given, right? That helps with the sales. Then low stock again, creating urgency, scarcity, right? Bunch of promotions here and coupon codes that they can leverage that helps with sales. Little banners like this that build trust. A little testimonial given here, right? It's all missing and it could help their conversions. You could even do a little what's included thing. This is what's missing that I'm talking about. So there's different Shopify WooCommerce plugins. You can take literally pictures, reviews that other people have given for the same exact product on AliExpress or just and drop or these different sites and boom, just go ahead and import it. Let's go through the rest, right? And they got PR media, these big benefit banners. And then you go through it and it just talks a lot, a lot more about the product. So they could do a lot better, right? You could also do a little comparison table, little faq. And then like I said, this is a review plugin that just goes ahead and imports literally hundreds or even thousands of reviews, really making your conversions go higher and creating that social proof that you're looking for. So hopefully you find that helpful. So this is how you fill the sheet. Next steps is go ahead and research five to 10 products and then when you're done, submit it for a review. So let me show you as a last step where to do it. So just go to the members portal, go to the course and then under Quick Start Action items, This is the shortlist my products button. So you go ahead and fill the sheet. Share your sheet with us when you go here. Click Share and then anyone with link, right, so that we can access it. Obviously you don't want to share the link with anybody else or your competitors. Just go ahead and take that link and when you fill this out, you know, obviously just put in your email. You can either share it directly with our emails or just enable sharing. It doesn't matter, we just need to get access to it, right? You click submit and we're good to go. Give us a few business days so that we can really go through. Look, look at it and then we can put our thoughts here in the notes section. You can also put your own thoughts and then whatever we think is best to go with, we're going to highlight. And obviously our coach is going to talk to you about building the store for that product and or just creating the ads. All right, hope this is helpful and speak to you soon.
More from Peter

278 Profitable Campaigns Documented Over A Year – Peter Szabo's Aicommerce Results

AI Commerce Client Feedback From Weekly Calls (for Peter Szabo's Aicommerce.co)

"I Felt Torn In The Beginning" | Wife & Husband Review of Aicommerce by Peter Szabo







