NOTE: To show product information mouseovers in Flip, or to use the Product Tab in Create, you need to import product data into the Active Merchandiser Product Library.

 

NOTE: If your account uses Active Merchandiser automated product loading, you will not need to use the Product Library to load your data. It’s already done for you!

 

Step 1

Log in to your Active Merchandiser account. On your Home page, select “Product Library.”

You will then be presented with the “My Product Data” page. This is where you will be able to upload and review your products.

 

Step 2

Select “Add Products,” then choose “browse” on the following page to search for your product file. When you’ve found it, double‐click to select it. The upload will begin automatically.

 

 

When the upload is complete, select “next” to process the file.

 

Don’t have a product file? You can download the Active Merchandiser standard product template, and build one using Excel. To download the template: login as shown below, go to your Product Library page, choose “Add Product” and click the “here” link to begin the download.

 

 

When the upload is complete, Active Merchandiser will display a preview of your data. Please check it for accuracy, and make any necessary changes to the field mappings. To make changes, select the “Map Fields” tab.

NOTE: Ignored fields will be displayed in grey and notation of affected fields will be displayed above the chart.

 

Step 4

Active Merchandiser uses a standard vocabulary for product fields. For example, if you use “Item ID” for your unique product identifier, you will need to change that field to “SKU” (Active Merchandiser’s standard field for identifying a product code). See the Active Merchandiser Product Fields table (found at the end of this tutorial) for a list of Active Merchandiser’s standard fields. In the “Map Fields” window, you can change your fields to those that Active Merchandiser recognizes. If fields do not comply with the correct vocabulary, they will be ignored by default and displayed in grey.

 

 

Step 5

---

After you have made your changes, click “save.”

 

Select “Next.” The Import Report will tell you if any products were not successfully imported and why. Click the “Done” button to finish.

 

Your Product Data page will now show the number of all the successfully imported products. From this page, you can delete, add, or replace products; export your data as an .xls (Excel) file; review your last import; and select the source for your product images.

 

Step 6

 

Set the location from which your images will be taken. Product images can be fetched from:

1. Your Active Merchandiser Image Library (default)
2. Dynamically fetched from a website

 

If you already have corresponding product images in your Image Library, click the “Change” tab to set the identifying link. Please see the “How to Use Flip” or “How to use Blink” tutorials for information on how to load images to your Image Library.

 

NOTE: If you have your images hosted on your website, you can easily draw them from your site using the “My Website” option.

For Example: if your product data SKU field is set to ‘123’, load an image into your account’s Image Library named ‘123’. Alternatively, name or re‐name an existing image with the identifier ‘123’.

 

NOTE: Some companies use a name for their product images that is not associated with a SKU or item code. If this is your case, click the “field to name the image files after” drop down menu. Select the corresponding field.

 

Click “Save Settings” button when you have finished.

 

To fetch images from your Website, first switch the configuration option to “My Website,” then enter the URL paths for your images in the boxes provided. An easy way to do this using Internet Explorer is to browse to the product detail page on your website, right click the product image, and copy the address found on the “properties” menu.  Paste this address into the appropriate (thumbnail or large image) “beginning path” area. Add the term ‘.jpg’ to the “ending path” area, removing it from the “beginning path” address if necessary.

 

NOTE: for most websites, smaller (thumbnail) images are shown on search result pages, and larger (full size) images are shown on the product detail pages. In Active Merchandiser, the thumbnail image path is used only to display product images in the “Select Products” function of the

Active Merchandiser Blink or Create menus. The full‐size image path is used for inserting large images into your catalog.

 

To test the image path set up, enter one of your image name field values in the test box at the bottom of the Product Image Location Page, and click “Verify Paths.”

 

 

Your images should now appear on the page.

Click “Save Settings” button when you have finished.

 

Now that you’ve loaded product data and linked images to your product library files, you can visit your Product Data page at any time to update, remove, or export information. Just log in to www.activemerchandiser.com, and return to your project or your product library files.

 

Please contact support@activemerchandiser.com for further assistance.

Active Merchandiser Product Fields

 

 

Field	Field Type / Limit	Description / Notes
SKU	Text (40)
UPC	Text (12)
PRODUCT NAME	Text (120)
CATEGORY PATH	Text (255)	Format '/category/subcategory/subcategory' - Only up to three levels
WHOLESALE PRICE	Currency
SALES PRICE	Currency
DISCOUNTING INFO	Text (255)
RETAIL PRICE	Currency
SHORT DESCRIPTION	Text (50)
LONG DESCRIPTION	Text (1995)
MINIMUM	Number
UNIT INCREMENTS	Number
THEME	Text (80)
DESIGNER	Text (80)
KEYWORD1	Text (80)
KEYWORD2	Text (80)
KEYWORD3	Text (80)
KEYWORD4	Text (80)
KEYWORD5	Text (80)
KEYWORD6	Text (80)
CUSTOM 1	Text (1995)
CUSTOM 2	Text (1995)
CUSTOM 3	Text (1995)
CUSTOM 4	Text (1995)
CUSTOM 5	Text (1995)
CUSTOM 6	Text (1995)
CUSTOM 7	Text (1995)
CUSTOM 8	Text (1995)
CUSTOM 9	Text (1995)
CUSTOM 10	Text (1995)
DISPLAY ORDER	Text (10)
QUANTITY ON HAND	Text (50)
RELATED SKUS	Text (255)
SOURCE FILE PATH	Text (255)
RETAIL SHORT DESCRIPTION	Text (42)
RETAIL LONG DESCRIPTION	Text (255)
DISCONTINUED_FLAG	Flag	Set to ‘1’ for yes or ‘0’ for no. No values provided (blank) is assumed to be ‘0’.
NEW	Flag	Set to ‘1’ for yes or ‘0’ for no. No values provided (blank) is assumed to be ‘0’.
BEST SELLER	Flag	Set to ‘1’ for yes or ‘0’ for no. No values provided (blank)

 

 

 

		is assumed to be ‘0’.
CLOSEOUT_FLAG	Flag	Set to ‘1’ for yes or ‘0’ for no. No values provided (blank) is assumed to be ‘0’.
HOT BUY	Flag	Set to ‘1’ for yes or ‘0’ for no. No values provided (blank) is assumed to be ‘0’.
QTY1	Number
QTY1PRICE	Currency
QTY2	Number
QTY2PRICE	Currency
QTY3	Number
QTY3PRICE	Currency
QTY4	Number
QTY4PRICE	Currency
QTY5	Number
QTY5PRICE	Currency
QTY6	Number
QTY6PRICE	Currency
QTY7	Number
QTY7PRICE	Currency
LEVELA	Currency
LEVELB	Currency
LEVELC	Currency
LEVELD	Currency
LEVELE	Currency

 

For Spotlight Product field mapping, please see the following page:

Product Details Data Mapping

 

Data Column

ITEM_CODE

PRODUCT_NAME

INVENTORY

LONG_DESCRIPTION

MINIMUM_QUANTITY

MULTIPLE_QUANTITY

HOT_BUY_FLAG

IS_NEW_FLAG

BEST_SELLER_FLAG

RELATED_PRODUCT

[Pricing Logic]