WP Maps does support importing data into the system using multiple ways that include CSV Import, API Access, or Google Sheet Add-On, Import 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 products 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 stores 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” into 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
Step 4: Press on the “Update Schema” Button
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-widow 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 Products CSV File
Importing a product CSV file is similar to importing a store CSV file with only a few slight changes.
- To add a custom field you need to go to “ Product Schema” in the “Super Admin” page.
Product Schema Section
- To import the products CSV file you need to go to the “Products” section in the side-widow 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.