WiFi Money Guy
WiFi Money Guy

@WiFiMoneyGuy

15 Tweets 10 reads Jan 14, 2023
Knowing exactly what to sell online can be challenging.
One wrong move and you end up with a bunch of inventory that won't sell!
Here's how I can spy on ACTUAL sales from successful Shopify Stores 🧵🧵
We've all been there, we know we want to start selling online.
Start making that WiFi Money that everyone is talking about.
But have a lingering fear.
"What if what I pick doesn't sell?"
"How do I even know what to sell?"
Well...
You want to make sure something has demand before you even try to sell it.
And there's pre-selling to help you do just that.
But there are things you can do even before you try to pre-sell to raise your own confidence.
You can spy on competitors.
Yet most ppl do it wrong
Here's one of the many processes I use to spy on my competitors.
have to give @BowTiedSystems a shout as he's helped me make this even better (duh, he's named Systems after all).
Alright here's how you do it...
Step 1: Get PPSpy Chrome Ext
We'll use this chrome extension to spy on the live sales of a Shopify store.
Today we'll be looking at Alpha Lion.
I left PPSpy running on this page for roughly 7 hours today.
PPSpy shows up at the bottom of the page like this
Step 2: Get Instant Data Scraper Chrome Ext
We'll want to pop open PPSpy and look at live sales.
Then open up Instant Data Scraper to scrape the entire list (automatically).
This scraped about 500 sales in 7 hours.
Step 3: Copy All
We want to copy the data from Instant Data Scraper by selecting "Copy All"
Step 4: Let's move it all to Google Sheets
I need to be able to manipulate this data for the next step.
For that I'll have to move it to Google Sheets.
Step 5: Use my formula / query
Look, I used to be a coder.
I have formulas for a lot of stuff 🤣
It'll select the column with the product names, and it will check how often they were purchased.
=QUERY(D2:D501,"select D, count(D) where D is not null group by D order by count(D) DESC label D 'Product', count(D) 'Count'",-1)
Step 6: Analyze it
We need to now see which products are selling the most.
And beware of product name typos...
You want to look into why these names are different, but based on this.
I want to look into Superhuman Pre-workout.
Step 7: Meta Ads Library
I want to actually check what ads are running to these products... why?
Because I know they are selling!
99% certain actually.
I want to start by looking at the oldest ads as those are likely the most profitable.
Bonus: Other tools
Take a look at TikTok's Creative Center and Vidtao for YT ads.
Creative Center is free, Vidtao is not.
That being said all of the tools I used here are free, some have premium memberships.
And...
If you liked this thread and more like this then...
1) Give it a RT first, then a good ol' like,
2) Give me a follow too @WiFiMoneyGuy
If you join my newsletter today, I have 5 days to show you why you should stay with my "License 2 Print Cash" free email marketing course.
Click the link below to get instant access: course.makewifibread.com

Loading suggestions...