Version: eXtendAlphaBroder 1.0.2 and above
Audience: Administrator

The eXtendAlphaBroder bundle comes with a Map/Reduce script which can be used for auto-linking your legacy AlphaBroder items within your NetSuite account to AlphaBroder's item information.


Standard Item Linking Process

  1. Create a saved search against the legacy items you want to link with AlphaBroder.

    To exclude items which have already been linked, add a Criteria Value for AlphaBroder Item Color Text = Empty which will indicate the item hasn't been linked with AlphaBroder (since the linking process would populate that field value).

    Image Placeholder

    In your saved search results specify the Item Color, Item Size , and AlphaBroder Item Style fields to be used for finding the appropriate item on AlphaBroder's item database. These will be the values which will be used when contacting AlphaBroder's API and requesting item information. Example below where the existing items' Style, Color, and Size fields are in the results.
    Image Placeholder
  2. Create a new Script Deployment for the eXtendAlphaBroder Link Items Map Reduce script.

    On the Parameters subtab, enter parameters from your saved search.
    Image Placeholder
    1. Enter the Internal Id for your saved search.
    2. Enter the associated column number for your Formula Field containing the Item Color from your Saved Search.
    3. Enter the associated column number for your Formula Field containing the Item Size from your Saved Search.
    4. Enter the associated column number for your Formula Field containing the Item Style from your Saved Search.
    5. If you want to link the items based on externalIdIndex or gtinIndex then you can use this step by specifying values as per below mentioned details:
      1. External ID based search: If you want to include the external ID for matching your NetSuite SanMar items, then you can do so by including your external ID field in the saved search from step 1 and specifying the search column in the following format under the "Indices Saved Search Column Index" script parameter. If your search column sequence is 9, then you will need to set the value as {"externalIdIndex":9}.
        Note: The Item match will first be performed by matching Color/Size/Style, if provided, and then matched by externalid.
      2. Gtin Index based search: If you want to match your legacy NetSuite SanMar items based on the Gtin Index, then you need to include the NetSuite item field which contains the Gtin Index in the saved search from step 1 and you will need to specify it in the "Indices Saved Search Column Index" script parameter. If your search column sequence for the Gtin Index field in your search is 9, then you will need to set the value as {"gtinIndex":9}. 
        Note:The Item match will first be performed by matching Color/Size/Style, if provided, and then matched by gtinIndex.
  3. Save and Execute the script deployment for initiating the item linking process.Image Placeholder
  4. You can view the status of the script execution by clicking on the “Status Page” link.

    Image Placeholder


Custom Color Map For Item Linking

eXtendAlphaBroder enables you to specify a color name map based on which your AlphaBroder items will get linked with AlphaBroder.
This mapping will help to link those AlphaBroder items existing in your account whose color naming format is different from the one provided by AlphaBroder. For example: For all Graphite Grey color names you are using just Graphite then using this feature your AlphaBroder items with color name as Graphite will get linked with the AlphaBroder.
Below are the steps for implementing this feature:
  1. Create color mapping as shown below in suite_alpha_transformers.js file:

    var COLOR_MAP = { GRAPHITE: ['GRAPHITE', 'GRAPHITE GREY'] };
  2. You can add multiple colors as per your requirement in the above mapping.
  3. Now when the item linking script will execute then the item color if received in AlphaBroder response is 'GRAPHITE GREY' then it will be linked as 'GRAPHITE'.