Setup new empty WP site on DB server (on SG) stagingnames-10.xyz/sitedomain.com
Copy this folder “new” into new folder name match end site url ie annapolismovers.bbgetsyoumoving.com
Create Database, username, password from SG , grant access of database to user and label database, usernames with website URL:
Update wp-config.php file with the created databasename, username, password
Open install URL https://stagingnames-10.xyz/annapolismovers.bbgetsyoumoving.com to install WordPress and create admin account
From wp admin, activate Avada theme, all plugins
Avada theme image
Delete Demo Pages and Posts
Export root DB pages (with variables) from rootdomain. Stagingnames-10.xyz
Import into
stagingnames-10.xyz/sitedomain.com
in our example,
stagingnames-10.xyz/annapolismovers.bbgetsyoumoving.com
Do suitable search replace for locations, Zips, NAPs client info using “better search replace plugin”
__Location 1__ => client location #1
__Location 2__ => client location #2
….
__Zip 1__ => client zip #1
__Zip 2__ => client zip #2
….
__Location-1__ => client location #1 (with dash vs space)
__Location-2__ => client location #2 (with dash vs space)
….
Other NAP info:
**START YEAR**
**NAME OF BUSINESS**
**MAINLocation**
**MAINLocation-dashes**
**SERVICE**
**service-dashes**
**OWNER 1**
**STATE FULL**
**STATE ABBREVIATION**
**PHONE**
**ENDURL**
**YEAR** (ex. “2023”)
**MONTH** (ex.”03” : 2 digits)
NOTE:
Ensure posts, postmeta, options + yoast tables are selected
Bulk Draft remaining pages with locations not changed ( our DBs support up to 500 locations/zips, so if client # of locations is less, we draft these remaining pages ( run php script draft-unneeded-pages.php can run from browser stagingnames-10.xyz/annapolismovers.bbgetsyoumoving.com/var/inner/draft-unneeded-pages.php or shell
Export live pages
Use script-1-create-shortcodes-from-pages.php to convert these DB full content pages into reduced pages with only shortcodes so that we protect our content and don’t put it directly on root website: script-1-create-shortcodes-from-pages.php export.xml
Import result into WP of client website
Prepare good client images, crop, merge 2 images if needed to be used with DB pages
images crop with windows image viewer
Copy paste images to the needed count.
Go to media and click on *Add New* Here you will get new tab Here you will get 2 options First click for drag and drop Second click on *Select Files* and find images folder on your PC , then press Ctrl + A for select all images then press *open* button bottom on folder right side / images uploading.
Use resize-imgs-random.php ro randomly resize images so no 2 images are same.
resize-imgs-random.php
use auto renamer software to generate image names
i. add files > select all images or drop all images
ii. Click on Actions > Select , Take names from list > here past images name and click on Go button (Green color Button)
Mass upload images to client live site
Test and ensure DB pages load correctly, PC/AMP iframe issues ..etc
If everything is ok, submit sitemap
"Setup new empty WP site on DB server (on SG) stagingnames-10.xyz/sitedomain.com"
"Create New Database :"
"wp-config.php"
"Create Admin Account :"
"Activate Plugins and Avada theme :"
"Delete Pages / Posts :"
"Export Live Pages :"
"Script 1 Create Shortcodes :"
"Import Result :"
Create 21 clones of WP client template ( ie create mysql DBs, create subdomains in hosting, DNS ..etc restore the WP client template to the needed subdomains
For each subdomain export DB page with variables from subdomainname.stagingnames-10.xyz
Import each into corresponding subdomain
Do suitable search replace for locations, Zips, NAPs client info using “better search replace plugin”
Draft remaining pages with locations not changed ( our DBs support up to 200 locations/zips, so if client # of locations is less, we draft these remaining pages
Update homepage for each subdomain
Prepare good client images, crop, merge 2 images if needed to be used with DB pages
Copy paste images to the needed count
Use resize-imgs-random.php ro randomly resize images so no 2 images are same.
use auto renamer software to generate image names
Mass upload images to client live site
Test and ensure DB pages load correctly, PC/AMP iframe issues ..etc
Optimize website with wp rocket, object cache, do needed updates also to wp config
Run imagify to optimize images
Test website, if things are ok, submit sitemap
If everything is ok, submit sitemap
same as in #3 but location size = 500
Same as in #3 but location size = 500
Create author that is with name of client website, logo, bio ..etc
Bulk assign posts to this author
Same as movers subdomain process but DB is divided into 3 parts:
Local moveto DB
main location to long distance locations (2700 locations)
Long distance locations to main location (2700 locations)
We use 5 main subdomains ie county1movers, county2movers …. county5movers
Its pages are based on having DB pages belong to move to county1 to all other counties, county2 to all other counties..etc
We do steps for subdomain process for these 5 counties
Up to 119,600 pages delivered with all the above DBs.