Building A 2000+ Page Programmatic Directory From Scratch Using Wordpress and Geodirectory
Get Managed Wordpress Hosting: https://hostinger.com/freychu
(Use 10% off coupon code: FREYCHU)
I create a comic book shop directory from scratch using Wordpress and Geodirectory. You can find all the details below, including the full techstack used, extra footage and more.
🚢 Join SYD Pro: https://shipyourdirectory.com/
🟢 Join SYD Free Community: https://ship-your-directory.circle.so/
✍️ Subscribe to SYD Newsletter: https://shipyourdirectory.kit.com
𝕏 Follow me on 𝕏 @freychu
***NOTE: Due to a recently corrupted Riverside.fm file (where I recorded this video), I had most of my extra footage deleted which included the two files where I designed the listing page + home page. Sorry about this y'all :(
Data Enrichment Tools
Automate Enrichment: https://www.enrich.directory/
Automate Listing Descriptions: https://www.enrich.directory/llm-enrich
Wordpress Tools/Plugins
Geodirectory: https://wpgeodirectory.com/?ref=478
Elementor Pro WP theme: https://be.elementor.com/visit/?bta=2...
WP All Import: https://www.wpallimport.com/
WP Bulk Delete: https://wordpress.org/plugins/wp-bulk...
EWWW Image Optimizer: https://ewww.io/plans/ref/898/
Export Media URLs: https://wordpress.org/plugins/export-...
Rankmath SEO: https://wordpress.org/plugins/seo-by-...
Timestamps
03:19 Directory niche + the main competitor
04:01 Directory on the 1st page ranking on Google
04:29 Keywords I’m targeting
06:05 Planning how I’d get backlinks
07:45 Monetization potential of this niche
08:22 Buying my domain + setting up web hosting + Wordpress
12:25 Starting my data scraping
15:15 Cleaning my scraped data
21:23 Starting my data enrichment process
23:23 Automating data enrichment based on Google map reviews
27:30 Automating custom listing descriptions
35:10 Setting up the basics in Wordpress
35:23 Choosing a template in Geodirectory
41:00 How to edit your listing template in Geodirectory
43:00 Adding breadcrumbs to my listing template
45:22 Preparing for the final CSV for Geodirectory
46:30 Preparing, uploading, resizing, and exporting images
59:43 Building your final CSV for geo directory
1:00:53 A look at the final CSV format
1:02:04 Re-formatting my post content using chatgpt
1:04:12 Re-formatting my working hours using chatgpt
1:06:15 Re-formatting phone numbers
1:06:49 Filling out necessary columns in final CSV template
1:06:53 Separating street 1 and street 2 addresses for Geodirectory
1:09:25 PSA about the “country” column in Geodirectory
1:10:00 Fixing postal codes missing a digit
1:11:18 Test small batch import to bulk create listing pages
1:11:48 Checking my listings + fixing issues with street address
1:12:10 Fixing street address import issue
1:12:58 Updating and improving the listing descriptions
1:14:08 Preparing to upload your entire master CSV to Geodirectory
1:14:48 Fixing Image Alt Text import with Geodirectory
1:19:02 Adding internal links to my listing page and location pages
1:26:04 Styling the “second” location page in Geodirectory
1:28:26 Creating the homepage and foundation pages
1:30:34 Fixing abbreviated states showing up on my location pages
1:34:40 Adding Google analytics, GSC and submitting sitemap