To use the Mass Upload you need to have a carefully formatted data file. The file can be created in any spread sheet program (MS Excel) but must be converted to a Comma Separated value (*.csv) file before it is uploaded.
There are eight fields that must appear in the correct order with a header named appropriately. Any changes in the names of the fields will cause your upload to fail.
1. Name: The name of the store.
2. Address 1: The first line of the address.
3. Address 2: The second line of the address. Usually this is the something like a suite or unit number.
4. City: The name of the City.
5. Province/State: In Canada and the US, these must be the correct 2 letter ISO abbreviations. In other countries there is a bit more flexibility and this can include counties or other postal districts. For a complete list of ISO Codes, please see the CommerceCM Help site.
6. Postal Code: This is the postal, zip or other code.
7. Phone: The phone number of the store. The phone number supports 25 characters so that International phone numbers can be entered. In the file Upload example, we show the format XXX-XXX-XXXX. It is an example format, that is not enforced. You simply need to standardize on a format that you would like to use for your site.
8. Country: The official ISO 2 letter abbreviation for the country. Canada is CA, the United States is US, England is GB etc. For a complete list of ISO codes, please see the Store Locator section of the CommerceCM Help site.
9. Fax: this is the Fax number of the Store. It is not mandatory.
A sample table is shown below. You can download a sample Microsoft Excel file from the Store Locator section of the CommerceCM Help Site.
Province/State
Once you have created your file you need to us Save As in the File menu to save it as Comma Separated Value CSV(*.csv) text file.
When doing a Mass Upload, you have two choices: Replace List and Append to List.
Replace: This does exactly what it says. It will replace your entire list of stores.
Append: This adds the stores in your file to the your list of stores already on your site. This is an effective way to add a months worth of new retailers. If you upload a store that is already in the list, you will not receive a warning and will simply have the store listed twice.