WP Maps Excel Tool to allow Google Excel to get integrated with your WP Maps account, there are 2 essential steps of WP Maps Excel Tool in Add-ons needs to be followed:
Configuration
Starting with Configuration, you’re required to configure your WP Maps by accessing two ways connection, so that your data could be transferred from your WP Maps to Google Excel and vice versa.
Figure 1: Add-ons: Configuration
Add Client ID and Access Token from your WP Maps, which is already provided once you’ve subscribed to WP Maps for your products and stores.
Figure 2: Add-ons: Configuration – Access Token
Once you’ve entered the required Client ID and Access Token, a message of success will be shown.
Figure 3: Add-ons: Configuration – Success Message
Publish
Moving on with Publishing. With the help of publishing, you can fetch your stores and products. Please make sure to switch to a new tab to get both the products and stores on a new tab separately.
Figure 4: Add-ons: Publishing
Either you make changes here or the changes are performed in your own WP Maps, it will be auto-effective on both sides as WP Maps intelligently creates a two-way connection with Google Excel. For an already published product locator, you’re required to add Publish ID so that it can work the same as it works with an unpublished product locator.
Figure 5: Add-ons: Publishing – Fetch Data
Publish ID is to be copied from the intended build. Each build has its own Publish ID.
Figure 6: Add-ons: WP Maps – Publish ID
Once Publish ID is added, you can access the live data to manage and edit it by using Google Excel.
Figure 7: Add-ons: Publishing – Publish ID