Import Model: Brands

Introduction

There are many different ways that WSM allows you to customize your Product profile imports. The blue table below can be used as a quick reference tool which will assist you in using the data import feature properly and effectively when importing products into WSM.

Contents

Overview

Let's say that you have a large amount of products that you would like to be put onto your website. Would you rather enter each item manually or create a spreadsheet that would allow you to import them all in just a few clicks? I would venture a guess that you would pick the latter of the two. By utilizing the product data import fields, you will be able to upload a virtually unlimited amount of products in a tidy way with minimal setup.

Steps

When using the product import data feature you will need to first create a spreadsheet indicating all of the values that you would like to display along with product. These values usually consist of the item#, primary description (summary), secondary description (summary2), image(s) and any other information that you would also like to have shown on your product page. Once you have created your spreadsheet and saved it as a CSV file, as described in a previous topic, you can begin to set up the back end of WSM to allow importing of your products.

The table below will help to determine which values and definitions each of your fields require. You will utilize this chart once your product profile is created and you are beginning to add fields to allow for your csv product spreadsheet to be imported.

Definitions of Terms

  • Default:The value which is automatically displayed if you have not designated a value on your import file.
  • Values:Indicates how you must enter the text for that particular field category.
  • Delimited: Indicates what you must use for your Multi-Value Delimiter when having multiple cells load into one profile field. This feature is most commonly used when loading product images, as many times clients wish to show multiple product images for each item. If the MVD was a - your VALUES would read as the following: ${column header1}-${column header2}-${column header3}
  • Force Update:Indicates whether a force update must be clicked to have the new data load over the existing data. A force update is needed when an existing field’s information does not automatically update with the new csv file’s data.
  • Character: Either a restriction or recommendation for this field.
  • Special Notes:See special notes section for any additional details that may need to be referenced.

Field Names Defined:

Description

Default: Blank
Values: Text, HTML Allowed
Delimited: N/A
Force Update: No
Character Limit: N/A
Special Notes: When entered the information will appear next to the brand image and below the Name. You can use HTML when entering this information into the Import File to create formatted text. 

Extended Description

Default: Blank
Values: Text, HTML Allowed
Delimited: N/A
Force Update: No
Character Limit: 2,000,000
Special Notes: Used as the Extended Description and is displayed below the products that appear on the brand page. You can use HTML when entering this information into the Import File to create formatted text. 

IdDefault: System Generated by WSM
Values: Numerical ID
Delimited: N/A
Force Update: No
Special Notes: This ID can only be used when updating existing brands in your site. It cannot be used too create new brands.
Image

Default: None
Values: Full URL for Location of the file
Delimited: N/A
Force Update: Yes
Character Limit: 255
Special Notes: When enabled your brand image can appear above your product image on the category and product page.

Meta Description

Default: Blank/System Generated by WSM from your brand description.
Values: Text, No HTML
Delimited: N/A
Force Update: No
Special Notes: We recommend a maximum length of 200 characters and/or 2 sentences. Do not excessively repeat targeted keywords (spam).

Meta Keywords

Default: Blank/System Generated by WSM from your brand description.
Values: Text, No HTML
Delimited: N/A
Force Update: No
Special Notes: We recommend a maximum length of 20 keywords (words or phrases separated by commas).

Name

Default: Blank
Values: Text, no HTML
Delimited: N/A
Force Update: No
Character Limit: 255
Special Notes: This will be the brand name displayed to the customer. This name should be unique. When a brand is assigned to a product it will be displayed on the product's detail's tab.

Meta Title

Default: Blank/System Generated by WSM matching your brand name.
Values: Text, No HTML
Delimited: N/A
Force Update: No
Special Notes: We recommend a maximum length of 60 characters.

Priority

Default: 500
Values: Numeric 1-999
Delimited: N/A
Force Update: No
Special Notes: The priority will control the order of the products on the page. The higher the priority number, the closer to the top of the page it will appear.

Template

Default: None
Values: Text, No HTML
Delimited: N/A
Force Update: No
Special Notes: The "Default" template in your WSM site is always used as your devault template unless otherwise sepcified. Typically a site will only have one template.

Summary

Importing brands is an important aspect of your data import process because it has an effect on your customer's shopping experience. If a brand does not exist and you are importing products that include the brand column a brand will automatically be created for you. This model will allow you to add content to your brand pages. This content will guide your user's shopping experience. When used correctly it also has the ability to improve the search value of your site.

For additional assistance with importing please complete our support request form.