WP Maps does support importing data into the system using multiple ways that include CSV Import, API Access, or Google Sheet Add-On. Importing data through a CSV file is always the better way to import more data in less amount of time.
In this article, we will discuss how to import your stores and product data into WP Maps. For this, we first need two CSV files, one for stores and the other for products. Below are the details of the columns that are required by the store's CSV file.
The very basic columns that must be part of the CSV import file are as follows.
title, description, street, city, state, zip, country, lat, lng, phone, fax, email, website, open_hours
Empty Coordinates (Lat/Lng)
Our import system will fetch and fill the missing coordinates smartly on the basis of address data which are city, state, zip, and country. Therefore, it is crucial that the geocoding service provider, which includes Mapbox, Google, or ArcGIS, is configured properly.
How to Import a Store CSV file
To import a Store CSV file you will need to follow the steps mentioned in the below section. Firstly, you will need a store.csv file to import.
Below is a snapshot of a stores.csv file
Store CSV file
In the stores’ file, all the stores’ columns can be imported into WP Maps except the “Branch Type” column, which is a custom column. Therefore we will need to add “Branch Type” to our store schema section before importing the file.
To add a Custom Field, follow the below steps:
Step 1: Go to the “Super Admin” section on the side window and go to the “Store Schema” tab
Store Schema Page
Step 2: Click on the “NEW ATTRIBUTE” button and fill in the schema attribute. In our case the Field Title is “Branch Type” and the Field Name is “branch_type”.
Step 3: Choose the “Field Type” and click on “ADD ATTRIBUTE”, and “Branch Type” will be added to the store schema.
Add Attribute Section
Now our Stores CSV file is ready to be imported, to import the stores do the following:
Step 1: Go to the “Stores” Page on the side window and select “Import/Export”
Step 2: Click on the “UPLOAD” button and select the store’s CSV file.
Step 3: Once the file is uploaded it will be listed under the list of imported files, click on the “IMPORT” button next to the file's name.
Store Import/Export Page
Step 4: A dialog box will pop up asking for which geocoder service you would like to use. Choose a geocoding service and click on the “Import Stores” button.
Geocode Selection Box
Upon successful importing of the stores, you will get a notification. Furthermore, you can verify the import, by clicking on the “Stores” section on the sidebar. You will see the stores you imported under “Manage Store List”
How to Import a Product Data CSV File
Importing a product CSV file is similar to importing a store CSV file with only a few slight changes.
How to Add Additional Product Attribute Fields for Product CSV Import
If your product CSV file has an extra field that is not supported by WP Maps, then you will need to first create an additional product attribute field via the “Product Schema” before you upload the CV file.
To add additional product attribute fields to the WP Maps database, please follow the below steps:
- Go to the “Super Admin” tab, and navigate to “Product Schema”
- Click on “New Attribute”
- Fill in the required fields, and press “Add Attribute”
Now the new attribute field will be successfully added to the WP Maps database.
Product Schema Section
To import the products CSV file you need to go to the “Products” section in the side window and click on “Import/Export”.
Product Import Section
To verify the import, click on the “Products” page again to view your products.
The rest of the steps are similar to how a store CSV file is imported.