Skip to content

NetSuite - Magento Connector - Video - Configuration 1

Hello everyone, today I’m going to demonstrate how you can customize different forms with different custom fields in NetSuite, and then how we can transfer such customizations into Magento. So to begin, first I enabled “Map Custom Fields” in NetSuite Configuration panel in Magento. Then let me show you one example in NetSuite. So this is an example form to create a new inventory in NetSuite. As you can see there are a lot of different import fields. Many fields could be just a stream, could be a number, could be a yes no as a check box. In our example, we will actually demonstrate a relatively complex case, which is actually a drop down list. So you can see I actually created two demo fields which is size and color. To allow these two fields in NetSuite there are basically two steps I need to finish.

First, I need to create a drop down list with all the sizes and all the colors. Then, I need to assign such fields into specific forms. This has been done here, I already created a custom color list with all the colors and same story with the sizes. Next, I’m assigning this custom color towards creating the list/ record of the inventory item and this is on the main tab, that’s why it’s appearing over here. To fully synchronize this complex step, we are going to do the same story in two steps in Magento. The first part is basically having a place where we can accommodate the drop down list. The second place is we are going to assemble the thing toward a specific product detail page.

To begin with, in Magento, each of this drop down list can be characterized by its attributes so they can be managed over here. I already created such attributes in advance. You can see there’s already a color and size. However, they’re not synchronized. You can see there’s no specific color over here, neither are there any sizes. To synchronize these two is relatively simple. So to begin with, let me tell Magento. By this specific customized mapping, my Magento attribute code 190, which is attribute code for color is mapped towards NetSuite color. Same story with magento size to NetSuite size. Once that mapping is set, I can simply run a synchronization over here. This panel basically tells me what configurations are given, like say my customized size 190 is mapped to NetSuite 417. Same story with color. And then I can click start. It is going to automatically pull all the possible sizes from NetSuite and save it into Magento. Like these are all the sizes and all the colors. And similarly if you go to the specific attributes, you can see the colors are listed.

So the next step is once you have this one ready, your Magento store manager or Magento developer would need to assemble those attributes into Magento product detail page. The easiest way to do this is just to manage attribute sets and in my example, I dragged both attributes into a new tab. So that when I look at a new product, there’s going to be a new tab called demo customization and all the fields are over here. The next step is tell Magento when you synchronize this product you also have to take care of these two attributes so this is taken care of if you config again.