IMPORTANT! End of Life for NCR Retail Online: 3/31/18 ~ Learn More
MY CART - $0.00

You have no items in your shopping cart.

NRO Extras Demo Store

Documentation - Custom Mapping File

Basic ecommerce fields are already uploading from Counterpoint to NRO. Default fields include name, description, price, quantity, brand, etc. See Default Counterpoint Mapping below for more fields.However, you may wish to utilize additional NCR Counterpoint fields for your item attributes. With a custom mapping file, you can import Counterpoint profile fields, item attribute fields, or other data as desired.

Note: If you need high-level overview information on attributes, see Understanding Attributes in the NRO Help Center.

Existing Mapping File

To determine whether you already have a custom mapping file in place, add /media/NROMappingCustom.xml to the end of the store's URL. For example, to find out if there's a custom mapping file on the Demo store, visit http://demoextras.nrostores.com/media/NROMappingCustom.xml

Important: The filename must match exactly, as it's case-sensitive.

 

Custom Mapping - Additional Item Fields

In many cases, we recommend starting with our Ultimate Mapping File that includes many additional fields from Counterpoint. You may have additional change requests, in addition to adding the following attribute fields from Counterpoint. The additional item fields that are included with a custom mapping are typically as follows (although your specific needs may be different):

DataCounterpoint Field Where Data is Located in CounterpointMaps to NRO Attribute Code (Attributes / Manage Attributes)
Counterpoint Profile Fields
Code Profile 1 PROF_COD_1 Inventory / Items on the Profiles tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_profile_code_1
Code Profile 2 PROF_COD_2 Inventory / Items on the Profiles tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_profile_code_2
Code Profile 3 PROF_COD_3 Inventory / Items on the Profiles tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_profile_code_3
Code Profile 4 PROF_COD_4 Inventory / Items on the Profiles tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_profile_code_4
Code Profile 5 PROF_COD_5 Inventory / Items on the Profiles tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_profile_code_5
Date Profile 1 PROF_DAT_1 Inventory / Items on the Profiles tab nro_custom_profile_date_1
Date Profile 2 PROF_DAT_2 Inventory / Items on the Profiles tab nro_custom_profile_date_2
Date Profile 3 PROF_DAT_3 Inventory / Items on the Profiles tab nro_custom_profile_date_3
Date Profile 4 PROF_DAT_4 Inventory / Items on the Profiles tab nro_custom_profile_date_4
Date Profile 5 PROF_DAT_5 Inventory / Items on the Profiles tab nro_custom_profile_date_5
Alphanumeric Profile 1 PROF_ALPHA_1 Inventory / Items on the Profiles tab
nro_custom_profile_alpha_1
Alphanumeric Profile 2 PROF_ALPHA_2 Inventory / Items on the Profiles tab nro_custom_profile_alpha_2
Alphanumeric Profile 3 PROF_ALPHA_3 Inventory / Items on the Profiles tab nro_custom_profile_alpha_3
Alphanumeric Profile 4 PROF_ALPHA_4 Inventory / Items on the Profiles tab nro_custom_profile_alpha_4
Alphanumeric Profile 5 PROF_ALPHA_5 Inventory / Items on the Profiles tab nro_custom_profile_alpha_5
Profile Numeric 1 PROF_NO_1 Inventory / Items on the Profiles tab nro_custom_profile_numeric_1
Profile Numeric 2 PROF_NO_2 Inventory / Items on the Profiles tab nro_custom_profile_numeric_2
Profile Numeric 3 PROF_NO_3 Inventory / Items on the Profiles tab nro_custom_profile_numeric_3
Profile Numeric 4 PROF_NO_4 Inventory / Items on the Profiles tab nro_custom_profile_numeric_4
Profile Numeric 5 PROF_NO_5 Inventory / Items on the Profiles tab nro_custom_profile_numeric_5
Counterpoint Item Attribute Fields
Item Attribute 1 ATTR_COD_1 Inventory / Items on the Description tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_attribute_1
Item Attribute 2 ATTR_COD_2 Inventory / Items on the Description tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_attribute_2
Item Attribute 3 ATTR_COD_3 Inventory / Items on the Description tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_attribute_3
Item Attribute 4 ATTR_COD_4 Inventory / Items on the Description tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_attribute_4
Item Attribute 5 ATTR_COD_5 Inventory / Items on the Description tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_attribute_5
Item Attribute 6 ATTR_COD_6 Inventory / Items on the Description tab (note the profile Description (not the Code) is used in the storefront display) nro_custom_attribute_6
Meta Data Fields - used for Search engine marketing and Google Shopping
Meta Description Item note field named METADESC Inventory / Items, then click the item Note icon in the toolbar (or select Data / Item Notes) and enter a note with a note ID of METADESC meta_description
Meta Keywords Item note field named METAKEY Inventory / Items, then click the item Note icon in the toolbar (or select Data / Item Notes) and enter a note with a note ID of METAKEY meta_keyword
Meta Title Item note field named METATITLE Inventory / Items, then click the item Note icon in the toolbar (or select Data / Item Notes) and enter a note with a note ID of METATITLE meta_title
Google Fields - used for Google Shopping and similar product feeds
Age Group     nro_custom_age_group
Condition     nro_custom_condition
Gender     nro_custom_gender
Google Category Item note field named GOOGLECAT Inventory / Items, then click the item Note icon in the toolbar (or select Data / Item Notes) and enter a note with a note ID of GOOGLECAT nro_custom_google_category
GTIN Barcode Inventory / Items on the Barcodes tab, for all barcodes with a barcode type of GTIN; note that you can map either the GTIN or the MPN from the barcode field, but not both nro_custom_gtin
MPN Barcode  Inventory / Items on the Barcodes tab, for all barcodes with a barcode type of MPN; note that you can map either the GTIN or the MPN from the barcode field, but not both nro_custom_mpn

Additional fields can be mapped from Counterpoint to NRO, depending on your needs.

Download the complete XML file (default custom mapping file): NROMappingCustom.xml

 

Enabling Profile and Attribute Fields in Counterpoint

To utilize the profile fields and attribute fields on the Inventory / Items screens in Counterpoint, you must first enable the fields themselves in Counterpoint under Setup / System / Quick Setup on the Items tab.

 

Default Counterpoint Mapping - Default Item Fields

The item fields that already come from Counterpoint by default (i.e., without any custom mapping file in place) are as follows:

DataCounterpoint Field Where Data is Located in CounterpointMaps to NRO Attribute Code (Attributes / Manage Attributes)
Item # Item number Inventory / Items > Item number sku
Name Additional Description 1, 2, or 3 Depending on how the Name field is mapped on the Items tab under Setup / Ecommerce / Control in Counterpoint, you will be pulling the product name from one of several choices. Typically Additional Description 1, 2, or 3 is used, as those fields provide the most number of characters. name
Description HTML description Inventory / Items on the Ecommerce tab description
Short Description Item note field named NRO-SHORTDESC Inventory / Items, then click the item Note icon in the toolbar (or select Data / Item Notes) and enter a note with a note ID of NRO-SHORTDESC short_description
Brand Primary Vendor Depending on how the Vendor source field is mapped on the Items tab under Setup / Ecommerce / Control in Counterpoint, you will be pulling the vendor from one of several choices. brand
Manufacturer     manufacturer
[Grid Dimensions] Color, Size, Pattern, and all other grid dimensions For all gridded items, the grid dimensions are defined on the Grid tab under Inventory / Items; [grid dimensions, i.e., color, size pattern]
Image Filename Images stored in ItemImages folder Images must be named itemnumber.jpg and be located in the ItemImages directory (e.g., C:\Program Files (x86)\Radiant Systems\CounterPoint\CPSQL.1\Toplevel\[COMPANY NAME]\Configuration\ItemImages). Learn more about configuring the item images folder in NRO Connection Configuration Instructions. Learn more about image naming conventions in Adding Item Images. image
Unit Choose to publish the stocking unit, the preferred unit, or multiple units Depending on how the Units allowed field is mapped on the Items tab under Setup / Ecommerce / Control in Counterpoint, you will be publishing the units to NRO accordingly  
Price List Price Depending on how the List price field is mapped on the Prices tab under Setup / Ecommerce / Control in Counterpoint, you will be publishing the prices to NRO accordingly   price
Special Price Selling Price Depending on how the Selling price field is mapped on the Prices tab under Setup / Ecommerce / Control in Counterpoint, you will be publishing the prices to NRO accordingly special_price
MSRP Price-1 Inventory / Items, click the Prices button msrp
Weight Weight Inventory / Items on the Other tab weight
IsTaxable Taxable Inventory / Items on the Main tab   
Tax Category Tax category Inventory / Items on the Main tab    
Quantity Choose to publish the item qty available, item qty on hand, location qty available, or location qty on hand Depending on how the Qty available field is mapped on the Items tab under Setup / Ecommerce / Control in Counterpoint, you will be publishing the quantity to NRO accordingly  
Allow Discounts Discountable Inventory / Items on the Main tab  
New Until Date New Until Inventory / Items on the Ecommerce tab news_to_date
Status     status

This is only a partial list of fields that are uploaded from Counterpoint. Download the complete XML file (default standardmapping file): NROMapping.xml

 

Elements of a Product Detail Page

Please wait...

{{var product.name}} has been added to your cart.

Continue shopping
View cart & checkout