What is the outcome? #
This system shows you how to add location pages in bulk to a website using a plugin called All Import Pro. The purpose of this is to quickly add many pages without having to individually create them.
Before you start #
In order to carry out this task successfully you must have the following completed:
- Website set up
- Elementor set up
- All Import Pro plugin installed and updated
- Location Page Template Set Up
Process #
Find List Of Suburbs Within Radius or Area #
- Go to google and search Postcode Radius
- Click EMBR GROUP – Search Australian Postcodes by KM Radius
- Choose between the 3 options shown. (Usually 3rd one – Search KM Radius…)
- Once filled out/completed, an output column will show up
- Scroll down until you see Combined – Post Code, Suburbs
- Copy the list by clicking into the box
Create CSV Document #
- Open up Location Lists – Template doc located in folder D:\Dropbox\Paperclip Designs\Templates
- Paste the list in the Postcode column
- Select the column and go Data > Text to Columns
- Click next > tick Comma > Finish
- To remove duplicate Suburbs, select Postcode & Suburb columns
- Go to Data > Remove Duplicates > Untick Postcode > click OK
- NOTE: The title of the pages are going to be the suburb names
- Slug
- Need a keyword depending on the site (eg. pest-control-SUBURB)
- Video time 6:25
- Can either fill each suburb out this way or use formula =”key-word-“&B2 and then use the small circle in the corner of the selected cell and drag down.
- If you used the formula, select all the rows in column slug
- Copy and paste the column back in its same spot but paste as Values
- Click on the first one and use formula =lower(“key-word-“&B2) and then drag it down to change the other rows.
- Then Copy and paste the column again back in its same spot but paste as Values
- Select the Slug column again and hit CTRL-F on your keyboard
- In the Find What section put a space
- In the Replace With section put a –
- Then click replace all
- Meta Title
- Video time 10:08
- Use business name/keywords then have %%title%% after it to bring in the suburb
- Then use the | and have %%title%% *different keywords* (the video will make more sense)
- Once completed, drag it down to change all the other rows
- Meta Description
- Video time 11:19
- Check the meta description on the homepage of the website you are working on (that description will usually be best because it should have keywords)
- Copy the description over if it is suitable. Make sure to change any suburb/area mention to %%title%%
- Once completed, drag it down to change all the rows
- SAVE DOCUMENT AS A CSV INTO THE CLIENT FOLDER
- Title Link
- Video time 13:30
- Type in this formula =hyperlink(“/locations/”&C2,”KEY WORD “&B2)
- Where is says KEY WORD – use the keywords you have been using above (eg. Pest Control)
- Once completed, drag it down to fill in the other rows
- Now copy the list in Title Link and paste them into a new word doc, and put aside.
Upload Location Pages Using All Import Pro #
- Going back to the dashboard on the website, make sure All Import Pro is installed
- Go to All Import > New Import > Upload a file
- Find the CSV file you just created and upload
- Click on the Posts drop down > select Pages > Continue to step 2
- Have a quick check that it all looks in order (there shouldn’t be anything showing up for Titlelink)
- Continue to step 3
- Drag & Drop
- Drag and drop the titles in the right column to the ones in the left (video time 18.50)
- Title = suburb
- Open Custom Fields dropdown > click into Name and select these
- _yoast_wpseo_title = drag metatitle to VALUE
- _yoast_wpseo_metadesc = drag metadescription to VALUE
- Open Other Page Options dropdown
- Post Slug – drag in slug
- Set the Parent Page from (no parent) to the Locations page
- At the bottom, tick Save settings as a template and name it Location Pages
- Continue to step 4 > drag the slug into the Unique Identifier
- Click Continue > Confirm & Run Import
Update Location Page Template With Hyperlinks #
- Go to Pages > find the Locations page and Edit > Edit with Elementor
- Create a section with title (eg. Areas We Service) and text box
- Go back to the Word doc with all the links > copy and paste them into the text box
- Click Update
- NOTE: always view the page after this to make sure the links are working. If the links are not working, copy them from the original excel document and paste them over instead.
Add Location Page To Footer #
- Edit the footer
- Add the link to the Locations page option
- If there isn’t one already, add one underneath the others
- Link should be /locations