• Context
  • Index
  • Home
  • Catalog
    • Departments
      • Landing Page
      • Foundation
      • Managing Products
    • Product
      • Landing Page
      • Foundation & Description
      • Departments
      • Cross Sales
      • Properties
      • Relations
      • Specifications
    • Brand
    • SEO Download
  • Marketing
    • Promotions
      • Landing Page
    • Cross Sales
      • Landing Page
      • Creating & Editing
      • Mass Upload
    • Site Ads
      • Landing Page
      • Creating & Managing
      • Performance Reports
      • Ad Weights
    • Referrers
      • Referrer Landing Page
      • Creating a Referrer
      • Using the RefererID
      • Landing Page
      • RefID Detail Report
      • Referrer and Conversion Analysis
      • Increasing Conversion Ratio
      • Tracking Return on Referrers
      • Referrer tracking conclusion
    • Store Locator
      • Mass Upload
      • Manual Upload
      • Data Controller
      • Deleting Listings
      • Editing Listings
    • Image Manager
      • Process of Uploading Images
        • FTP Upload of images
      • About Image Quality and File Formats
      • About Aspect Ratio (Shape)
      • Where to Get Source Images
      • Landing Page
      • Image Edit Page
      • Manage Variants
        • Managing Variants with Multiple Languages
    • Data Feeds (BETA)
    • Reviews
      • Landing Page
  • Reports
    • Orders
      • Landing Page
      • Currency Summary
      • Quick Search
      • Advanced Search
      • Order Status
        • Status Setup
        • Using Status in Order Manager
        • Status Mass Upload
        • Quick Tip Videos
  • Language
    • Categories
    • Edit LRM's
  • Shipping Manager
    • About Shipping Groups
    • Creating and Editing Shipping Groups
      • Country Groups
      • State/Province Groups
      • City Groups
    • Populating the Shipping Group
    • Case Study for Setting up Shipping Groups
    • Setting up Shipping Methods
      • Case Study for Setting up Shipping Methods
  • Gift Certficate Implementation
  • Open Graph
  • CommerceCM Help Request
  • About Shipping Groups
  • Aspect Ratio (Shape)
  • CommerceCM Help
  • Create and Edit City Groups
  • Create and Edit Country Groups
  • Create and Edit Shipping Groups
  • Create and Edit State/Province
  • Creating and Editing
  • Cross Sales
  • Cross Sales - Landing Page
  • Data Feed Generator (Beta)
  • Departments
  • Design Implications
  • Getting Source Images
  • Image Landing Page
  • Image Manager
  • Image Quality and File Formats
  • Landing Page
  • Populating the Shipping Group
  • Process of Uploading Images
  • Setting Up Shipping Methods
  • Shipping Groups Case Study
  • Shipping Manager
  • Shipping Methods Case Study

Mass Upload

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.

 Name Address 1 Address 2  City

Province/State 

Postal Code  Phone Country Fax 
 Great Store Ltd.  19800 something street   Vancouver  BC   V2V 2V2 604-738-0906 CA  555-555-6666
 US Store  1234 Another Blvd.  Unit 304  Seattle  WA  12345 555-555-5555 US  

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.

 

+1 (888) 374 0906