Product Customization: NSc Sync Mappings

Product Customization Index
##NSc Sync Mappings
After creating the four required fields in NSc PAM, we need to map them to the web store. This requires 5 mappings, one for each field and one for the tag along item.

###Field 1. The Customizable Field
This is the field that determines if a product can be customized by a shopper.
####Create NSc PAM Field

  • Open NSc PAM
  • Attributes Menu → Add New Attributes
  • Add the field name Customizable to the Attribute Name box;
  • Set the Attribute Type as PAM field type Checkbox (true/false);

####Creating NScSync Mappings

  • Open NScSync;
  • Press the Configuration button;
  • Select the Advanced->FieldMappings option;
  • Open the Item table;
  • Add Field*->PAM Field…;
  • Locate the NSc PAM table field you have created in PAM called Customizable, this field should be near the end of the drop down menu;
  • In the Remote Field Name add the following product_weblinxcustomnumber# where # is an unused number between 1 and 5. The spelling is VERY important! Note that we are feeding this to a custom number field not a custom text field.

###Field 2 (LineTitle), 3 (LineCost) and 4 (LineDetail Fields)
These are the fields that determine the type of customization available to a shopper.
####Create NSc PAM Fields
Create these PAM fields as described here:

  • Open NSc PAM
  • Attributes Menu → Add New Attributes
  • Repeat the following for each field
  • Add the field name (LineTitle, LineCost, LineDetail) to the Attribute Name box;
  • Set the Attribute Type as PAM field type String;
  • See the relevant forum post for filling out these fields;

####Create NSc Sync Mappings
To move these data from PAM to the web store we use NSc Sync as described here:

  • Open NSc Sync;
  • Press the Configuration button;
  • Select the Advanced->FieldMappings option;
  • Open the Item table;
  • For LineTitle, LineCost and LineDetail right click on the Item table and select Add FieldPAM Field…;
  • Locate the NScPAM table field you have created in PAM, the new fields are probably at the end of the drop down menu;
  • In the Remote Field Name add the following product_weblinxcustomtext# where # is an unused number between 1 and 10. The spelling is VERY important!

###Field 5 - The Tag Along Field
The following associates your tag along item with the items that are customizable.

  • Open NSc Sync;
  • Press the Configuration button;
  • Select the Advanced->FieldMappings option;
  • Open the Item table;
  • Add Field*->standard Field…;
  • Click the advanced button;
  • In the Remote Field Name add the following product_tagalong;
  • In the Field source add the following

case when nitroasl_pamtable.PCcustomizable=1 then (select item.id from item where itemlookupcode=‘Customization’) else ‘’ end

Change PCcustomizable to match the column name you created in PAM for whether the item is customizable or not.