Knowledge Base
Save us time to focus on some great new features and try our self service knowledge base. Search for anything.
Create or Import Stores in WordPress
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.
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.
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?
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
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.
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
Please read this: https://www.elegantthemes.com/blog/wordpress/how-to-fix-the-sorry-this-file-type-is-not-permitted-for-security-reasons-error-in-wordpress
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.
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.
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
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?
Well for that large amount of stores, you may need to split up your excel files into small chunks.
I get the following error.
Your file seems to be corrupt.
This API project is not authorized to use this API.
I have set no restriction.
https://imgur.com/iPe35y9
There is a warning sign. Please check that.
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!
The problem is the server side API key that you have entered. You need to authorize / remove restrictions inside Google API Console.
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
You can import stores via Excel file, but customers can not edit their own store details.
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??
When you delete all first, how can you get duplicates at all? That makes no sense.
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?
CSV Files are not supported – only XLS or XLSX.
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.
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.
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.
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.
Please try using a excel file. Our plugin does not support csv.
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.
Please check your php error log or open the file in a text editor and look for php errors.
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!
Please make sure the lat / lng fields are empty in your excel file.
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?
Yes of course you can leave out the street etc.
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
HI Gabriele
Did you ever find a solution to this? We are having the same issue with the same 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
Let us know if you can help thanks
Where can I get sample import file
You can generate an example import file in plugin settings > get sample file.
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?
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?
Yes we use custom post types and custom meta data. You can pull them easy in your database or with external plugins.
Hi,
what do I write into the excel import table to have stores not published?
You can change the status of the store to „pending“ or „private“.
Hello there,
is there a way to upload and update our dealers daily via FTP?
Not by default, but you can use WP All import plugin for this.
Is there a free solution as well?
Please see WP Plugin Trial versions