Before creating a store you should setup your store categories & filters. The, when you want to create a store you have two options: Either you add it manually or you import a store.

Create a store manually

If you want to create a store manually, just go to Store Locator > New Store inside your Admin Panel. From there you can add all the necessary information for your store.

create a new store in WordPress
create a new store in WordPress

Importing Stores

If you have many stores you better use the import functionality. Therefore you go to Store Locator > Settings > General. On the bottom you will find an “Get Sample Import file”-Button. Press this button and you will get a sample Excel import file filled with all store information + categories + filters.

get sample import file
get sample import file

 

Use this sample import to fill out your import. If you have set a Server Side Google API Key, you can leave out the Latitute / Longitute values, because they will be fetched automatically.

Then you go back to General settings and press “Import Stores”-Button. Then select your file and click on import. You will see a report of the added stores afterwards.

import excel stores file
import excel stores file

40 thoughts on “Create or Import Stores in WordPress

  1. Maciej says:

    Hello!

    I have problem with import sample file, i can download it but i can’t open in office 365 and open office. Error exist on .xls and .xlsx, Can you attached sample file and reply to my email address?

  2. Michael Wynn says:

    I noticed the import sample document and our initial tests don’t have the categories mapping into the store locator listing, it instead put the categories in the description. I have over 800 listings to import and ideally *do not* want to manually have to assign all the categories, is there no map to include these as part of the spreadsheet?

    Thanks,
    Michael @ fullblastcreative.ca

    • WeLaunch says:

      Of course its possible – you just need to export the sample import file from plugin settings. This will contain categories, that you created before. Fill it out with a 0 or 1 and reimport it again.

  3. Roi says:

    im tring to import my xsl file. its not working. im getting an error mesagge: Error uploading file: The file type is not licensed for security reasons.

    please help

  4. george says:

    Hi,

    I’m getting this message when I try to import the file I’ve prepared:

    “Your file seems to be corrupt.
    API keys with referer restrictions cannot be used with this API.”

    Please advise.
    Thanks.

    • WeLaunch says:

      Well your Google API key has restrictions and can not be used for importing stores. Either you remove the server side key from plugin settings (but then you can not automatically fetch lat / lng). Or you go to Google API Console and adjust the referrer restrictions.

  5. George says:

    There is not restriction… here is screen shot from my settings:
    http://gorme.s409.upress.link/wp-content/uploads/2019/10/rest.jpg

    I have also a questions about the map:
    1. the geolocation doesn’t take my exact location – it shows my location near (couple of KM), I’ve tried 2 different location and the issue in both tests, what can I do to make show my exact location?
    2. the branches on map show only the branches in the choosen radius, when I expand radius the map is zoomed out and the pins become too close (or even on top of each other) which makes it not friendly to find the branch… how can I show all branches on map on a radius of 5 KM?

    Thanks

  6. Christina says:

    Hello, it seems I get a 504 error when i upload a seemingly small xlsx spreadsheet (less than 900kb). So I had the server folks increase the PHP max time to 1800 and am still experiencing the 504 errors. I was wondering if there is a way to upload the spreadsheet on the backend? And if so, which tables and columns shall I update in the database?

  7. Leonardo Guerrini says:

    Hello,
    I’ve just tried to import stores, with xlsx file, and putting the aPI Key in the “Google Api Key (Server Side)”. This is the error message: “This API project is not authorized to use this API.”. While, if I import the same list without insert tke API Key, I have the complete list in the plugin, but without coordinates, and this is a problem for me. Where is the problem? Thank!

    • WeLaunch says:

      The problem is the server side API key that you have entered. You need to authorize / remove restrictions inside Google API Console.

  8. Ryan says:

    Hi,

    Do you have to upload a store list for each category or can you just have categories (walmart/CSV pharmacy/Rite Aid/ Korgers/Target) and then let a customer type in their address. The results would then populate stores with the address entered using the google API. Our client’s products are sold in these popular pharmacy and big brand stores. Importing all the stores and keeping them updated is something we are trying to avoid.

    Thanks in advance for your time.
    Regards,
    Ryan

  9. Vincent says:

    When I upload stores via csv, the plugin creates many duplicates (sometimes 3 or 4) of certain stores. There are no duplicates in my spreadsheets and I cannot figure out why this is happening.

    I’ve tried purging all my stores and re-uploading, tried clicking “Try Updating Stores”, all the data in my spreadsheets are correct… why am I getting so many duplicates??

  10. Vincent says:

    When I import stores from CSV, the plugin produces duplicates (seemingly at random). Sometimes 3-4 duplicates per store. I have double and triple-checked my files and there are no duplicates in them. I am using “Try Updating Stores”, all my stores have unique IDs, and I’m still get duplicates. What is causing this?

  11. Dj says:

    2 questions, hoping you can help, please.

    1. I have created categories and tried to download the excel file but inside, there are no columns showing categories. I just have id field and customer id fields in first 2 columns. Is there something that I have to select before I download the import file? What am doing wrong ?

    2. how do I authorize / remove restrictions inside Google API Console. Would you happened to have a manual? It would be greatly appreciated.

    Thank you so much for your help in advance.

  12. Dj says:

    2 questions.

    1. I have added the category before I downloaded the excel sheet but do not see the category column. Just see id and customer id in the first 2 columns. Do I have to select something before I download the import excel file? What am I doing wrong?

    2. Is there a manual to authorize/remove restrictions of server-side API key inside Google API Console. It will be greatly appreciated.

    Thank you for your help in advance.

  13. Aaron Lett says:

    2 critical issues:

    1). in the “Search by Store Name” search box (named “Search by Physician Name” in my usage, not ALL names are returning. For example, typing “Yakel” should return 2 results (it only shows one – Demian Yakel), the only way to find the “other” Yakel is to type in his first name (Stefan), as you will see, the last names are IDENTICAL – what’s the issue here?

    2). Many of the Stores do not exist in the Back Office to be updated (they “cannot be found”). The only way to successfully update or remove a “store” is to export the .csv, make the edits in the ACTUAL data file, perform “Delete All Stores,” then re-Import Stores with the newest updates. INCREDIBLY time-consuming and not UX friendly. What could be the issue here?

    Sorry, I didn’t mean to hijack this thread, but i see NO other way to ask about issues.

  14. Amy Santiago says:

    I tried something, when I upload stores via csv, the plugin creates many duplicates (sometimes 3 or 4) of certain stores. There are no duplicates in my spreadsheets and I cannot figure out why this is happening.

  15. Matt says:

    The Get sample import file is corrupt and does not work. I have tried several times to download the file and I cannot get the file to open in Excel. I am using Microsoft Office 365 Excel.

  16. Cedric says:

    Hi! I uploaded 263 stores with an excel file and have set up my server side key with no restrictions. However, the plugin couldn’t fetch the lat & lng data. Any idea why?

    Thanks in advance!

  17. Matt says:

    Hi there, we are looking for a locator where we can just enter the zip code / suburb / city. The client does not want to show the exact address. Is this possible?

  18. gabriele says:

    Hi Daniele, I’m trying to import stores, but I get this error:
    Your file seems to be corrupt.
    You must enable Billing on the Google Cloud Project at https://console.cloud.google.com/project/_/billing/enable Learn more at https://developers.google.com/maps/gmp-get-started

    However, the billing is enabled, so I don’t understand if the file is really corrupt even if I used the simple file, or if I have a real problem on google.

    It gives me the same error even if I try to import the backup file I downloaded from the site and not the new file!

    can you help me?

    Best regards

    Gabriel

  19. Gregory Krief says:

    Hello, we are trying to upload the xlsx file but we have this message : xlsx is not recognised as an OLE file. We have use your sample exemple file without any change. Could you help us?

  20. Eser says:

    Pre-sale question: I am using a Custom Post Type for stores. Is it possible to automatically pull this data? And also the custom fields?

Leave a Reply

Your email address will not be published. Required fields are marked *