One of the most useful features of WP Maps is the ability to upload multiple products through CSV files.
To avoid any issues with product CSV uploads, users will have to follow the exact format for a CSV file that will be uploaded to the WP Maps platform.
This guide will explain in detail how you should structure and populate your product CSV file so that it can be recognized by the WP Maps platform.
List of Mandatory Data Columns
The following is a list of mandatory data columns that should appear in your product CSV file before you upload it into WP Maps. Please be sure all column headings are in lowercase.
- sku
- title
- description
- price
- images
- website
List of Optional Data Columns
The following is a list of optional data columns that you can add to your product CSV file. Furthermore, a CSV can be successfully uploaded even without these data columns. Please be sure all column headings are in lowercase and that each word is separated with a “_” (underscore) symbol. For example, “best_buy”:
- amazon
- walmart
- target
- costco
- the_home_depot
- best _buy
- kroger_co
Product CSV Data Format
This section will explain what each column heading means, and in what format you should enter the data for each column so that it is recognized by the WP Maps platform.
For each column heading you will need to enter data for it to be uploaded into the WP Maps platform.
Moreover, all mandatory column headings, such as “sku”, should be populated with data for proper CSV upload. However, there is one exception, the data in the “description” column is optional. As a result, the data in the “description” column won’t affect the CSV upload process.
Let’s go over each column heading one by one and see their requirements
Data Format for Mandatory Data Columns
1- sku
This column contains the stock keeping unit or SKU for each of your products. The data for the “sku” column can be added in any format.
Entering data for the “sku” column is mandatory.
2- title
This column contains the title of each of your products. The data for the “title” column can be added in any format.
Entering data for the “title” column is mandatory.
3-description
This column contains a brief description of each of your products. The data for the “description” column can be added in any format.
Entering data for the “description” column is optional.
4-price
This column contains the price of each of your products. The data for the “price” column should be added in numerical form.
Entering data for the “price” column is mandatory.
5-images
This column contains an online link for the image of each of your products. The data for the “images” column should be in the form of an online link (https://….)
Entering data for the “images” column is mandatory.
6- website
This column contains an online link to the website where each of your products is available. The data for the “website” column should be in the form of an online link (https://….)
Entering data for the “website” column is mandatory.
Data Format for Optional Data Columns
1- amazon
This column contains links for each of your products that are available on Amazon. The data should be entered as an online link (https://….)
The data for this column is optional.
2- walmart
This column contains links for each of your products that are available on Walmart. The data should be entered as an online link (https://….) i this column.
The data for this column is optional.
3- target
This column contains links for each of your products that are available on Target. The data should be entered as an online link (https://….) in this column.
The data for this column is optional.
4- costco
This column contains links for each of your products that are available on costco. The data should be entered as an online link (https://….) in this column.
The data for this column is optional.
5- the_home_depot
This column contains links for each of your products that are available on The Home Depot. The data should be entered as an online link (https://….) in this column.
The data for this column is optional.
6- best_buy
This column contains links for each of your products that are available on Best Buy. The data should be entered as an online link (https://….) in this column.
The data for this column is optional.
7- kroger_co
This column contains links for each of your products that are available on Kroger Co. The data should be entered as an online link (https://….) in this column.
The data for this column is optional.
These are all the things you need to know before you prep your product CSV for upload onto WP Maps. Please be sure to follow the above instruction to avoid any issues during CSV uploads.
For further assistance on any matter, please feel free to contact us at support@wpmaps.com.