Create / Import your Stores

Getting Started Viewed: 1979

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.

Creating a store manually step 1
Creating a store manually step 2

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.

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 buttons
sample import file
Importing the stores file
Store import report
This Post Has 22 Comments
  1. 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. 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

    1. 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. 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. 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.

    1. 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. 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. 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. 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!

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

  8. 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. 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. 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. 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. 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.

Leave a Reply

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