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 Field → PAM 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.