The Magento Item Export flow exports an item’s field data from NetSuite to Magento. This flow is a real-time flow – it is triggered when the Magento Item box on a NetSuite item record is checked and the record is saved. The following item types are supported (NetSuite type -> Magento type):
- Inventory Item (matrix children and non-matrix) -> ‘Simple’ Product
- Inventory Item (matrix parents) -> ‘Configurable’ Product
- Lot Numbered Inventory Item (matrix children and non-matrix) -> ‘Simple’ Product
- Lot Numbered Inventory Item (matrix parents) -> ‘Configurable’ Product
- Serialized Inventory Item (matrix children and non-matrix) -> ‘Simple’ Product
- Serialized Inventory Item (matrix parents) -> ‘Configurable’ Product
- Non-Inventory Item for Sale (non-matrix only) -> ‘Simple’ Product
- Non-Inventory Item for Resale (non-matrix only) -> ‘Simple’ Product
- Service Item for Sale (non-matrix only) -> ‘Virtual’ Product
- Service Item for Resale (non-matrix only) -> ‘Virtual’ Product
- Other Charge Item for Sale (non-matrix only) -> ‘Virtual’ Product
- Other Charge Item for Resale (non-matrix only) -> ‘Virtual’ Product
- Kits -> ‘Bundle’ Product
- Assembly item -> Simple Product
- Lot Numbered Assembly Item -> Simple Product
- Serialized Assembly Item -> Simple Product
Note: Exporting an unsupported item type causes failure and an error is logged in the Celigo integration logs.
When an export is triggered, the Connector searches Magento for an existing item with a SKU that matches a NetSuite item Name/Number. If no matching item is found, the Connector creates a new item in Magento using the NetSuite item data. If a match is found, the Connector updates the Magento item with the NetSuite data.
Once the item is exported to Magento, the Connector sets the Magento ID field on the Magento tab of the NetSuite item to maintain a hard link between the NetSuite item and the Magento item. If more than one item with a similar SKU is found in Magento, or if multiple NetSuite items have the same Magento Item ID, the item export fails, and an error is logged in the integration logs.
The Item Export flow can also set the item prices in Magento using data from your NetSuite item records. You must specify the NetSuite fields to set as the Magento item’s Price and Special Price fields. You can either create a custom ‘currency’ type field to store the Magento price, use the standard item ‘Rate’ field, or use a NetSuite price level such as Online Price for either of these Magento Price fields.
In addition, the Item Export can export a NetSuite item’s price levels as Magento tiered pricing. To use this feature, you must map your NetSuite price levels to a Magento customer group. Your Celigo resource can provide more information on how to set this up. The Item Export automatically exports your quantity pricing levels from NetSuite to Magento.
Attribute Sets and Attribute Fields
Magento has a concept of ‘Attribute Sets’, which is a collection of item fields called ‘Attributes’. An item created in Magento is associated with a specific attribute set, which determines what attributes are available to be set for that item. There are certain ‘system’ attributes such as ‘Name’, ‘SKU’, ‘Weight’, etc. that are available to all items irrespective of the attribute set. Then there are custom/additional attributes that are only available if they are assigned to a specific attribute set.
The Connector provides an easy way to set a Magento item’s additional attribute values in NetSuite. It imports the list of attribute sets, attributes, and associated attribute options (for drop-down type attributes) from Magento and displays them on the NetSuite item record for you to set the values. This means that you don’t need to create fields on the NetSuite item record for each attribute that you create in Magento, and there is no need to explicitly map every field between the two systems. You just need to set up the attribute sets and attributes in Magento, and they can be easily imported into NetSuite and shown on the NetSuite item record. To import the list of attribute sets and attributes from Magento, or to update the list if you make any changes in Magento, you need to run the ‘Item Attributes Import’ data flow within the Magento section of the integration dashboard.
Once the import of attributes list from Magento is complete, you can select an attribute set on your NetSuite item, as shown below. When you choose a value in the ‘Attribute Set’ field, the attributes associated with that attribute set will be displayed in item fields at the bottom of the page. The values you set in these fields will be exported to the corresponding item in Magento. When you view the item in NetSuite after saving it, the attribute fields are still visible and show the values you set, but are disabled for editing. If you do not want the Item Export to update attribute fields, leave the Attribute Set field on the NetSuite item record blank. This disables the attribute field export – the export does not change attribute fields in Magento, and the attribute fields remain editable in Magento.
The Item Export maps the values in the Item Categories field in NetSuite to the Product Categories in Magento. The Item Categories field is a multi-select field – you can select one or many values in this field in NetSuite, and the categories you select are set on the Magento item’s Category list.
The list of categories must be imported from Magento to NetSuite via the integration dashboard before you can set and export categories from NetSuite to Magento. It is the customer’s responsibility to import these values after the initial Connector setup.
Managed Field Sync
The Item Export uses a managed field sync for item updates. If a field in NetSuite is blank, the value in the field in Magento is deleted when the export runs. In addition, the Item Export clears the value for Magento attribute fields if the Attribute Set field is blank in NetSuite. If you do not want to use the managed field sync, please ask your Celigo project resource to disable this functionality for you at no additional cost.
The item image export uploads item images from your NetSuite File Cabinet to Magento for use on your product page. The item image export can set the Default Image, Small Image, and Thumbnail image in Magento using the images you have selected in the related fields on the item record in NetSuite, under the Magento tab. There is one image field for each image placement type. If you change the image in NetSuite, the export changes the image in Magento. The original image is overwritten and is not preserved.
Note: Images are not exported by default. You must check the Export Item Images to Magento box in NetSuite to trigger an image export when the item is saved. Clearing an image field in NetSuite deletes the image in Magento so that the two systems stay in sync. Uploading images into NetSuite and/or Magento is the client’s responsibility and is not done as part of Celigo’s installation.
Reverse Sync from Magento
If you do not yet have items in NetSuite and need to create them, you can use the Item Export’s reverse sync functionality to import data from your Magento item catalog.
To activate the reverse sync:
- Create a new item in NetSuite that has an Item Name/Number matching a Magento SKU.
- On the Magento tab, check the Magento Item box.
- Check the Run Reverse Sync from Magento box.
- Click Save.
The export process downloads the Magento item and maps the following values to NetSuite:
- Standard Magento fields map to NetSuite standard fields. See the Field Mapping section below for a list of fields.
- Custom Magento attributes map to dynamic NetSuite fields. See the Attribute Sets and Attribute Fields section above for the available field types.
- Magento Tier Prices map to NetSuite price levels.
- Magento Product Categories map to NetSuite item categories.
Note: The reverse sync does not download Magento item images into NetSuite. The reverse sync is not supported for NetSuite Kit items or NetSuite Matrix items of any item type.
Kit items in NetSuite are exported as Magento bundled products. Kit items are treated much like inventory items-you can export body fields, attributes and attribute sets, product category selections, and images to Magento.
Kit items exported as Magento bundled products only stay in sync with Magento as long as the Bundled Product’s member list is not modified in Magento. If you add, delete, or change a Bundled Product in Magento, subsequent exports from NetSuite will fail with errors logged in the integration Logs.
Matrix parent items in NetSuite are exported as Magento configurable products. Matrix parent items are exported to Magento much like individual inventory items-you can export body fields, attributes and attribute sets, category selections, and images to Magento.
Before exporting a matrix item, your Celigo project resource must map your Magento configurable product attribute fields and values to the corresponding NetSuite Matrix Item Fields and Matrix Item Values. If you would like to receive training on setting up these mappings yourself, please ask your project resource.
When an Item Export is triggered, the Connector exports all of the matrix child items to Magento to ensure that the child items are synced. If 2 or more matrix child items are exported to Magento successfully, the Item Export creates a new Magento configurable product. The Magento configurable product is linked to the NetSuite matrix parent item, and its configurable attributes and dimensions are set on the child items.
Other item types not listed in the flow description are not supported by the Magento Real-Time Item Export out of the box.
The Item Export can only export prices as $USD.
Attribute Sets and Attribute Fields
The fields in NetSuite that represent attributes such as ‘Manufacturer’, ‘Color’, etc. in the example below are ‘virtual’ fields. That is, they are not custom fields similar to the ones you can create in NetSuite by going to Setup->Customizations->Item Fields, they are fields generated by the Connector on-the-fly for display. The Connector cannot map additional attributes to physical NetSuite fields (standard or custom), only the system attributes listed in the table at the bottom of this page can be mapped to NetSuite fields (as specified in the table).
Mapping additional attributes to NetSuite fields instead of virtual fields as described above is not supported out of the box.
Magento does not provide a way to retrieve an attribute’s label. The Connector uses the attribute ID instead to display as label in NetSuite, after converting it to a readable form.
Currently, only drop-down, text, and number type attributes from Magento are supported.
Performance issues may occur if there is a large number of attributes and/or attribute options in your Magento attribute set.
After the initial Connector setup, Celigo is not responsible for importing the list of attributes and attribute sets that need using the Celigo Integration Dashboard. That is the responsibility of the customer.
Manage Attribute Sets
Creating new attribute set
Attribute set saved
In this example, Internal ID of the attribute ‘Watches’ is 23
Run Attribute set flow in the integrator.
Attribute set is then successfully imported (to NetSuite).
In NetSuite, the attribute set is configured in the following record
In this example, Watches (with internal ID: 23) was created in Magento is imported into NetSuite.
Reverse Sync from Magento
The reverse sync does not download Magento item images into NetSuite. The reverse sync is not supported for NetSuite Kit items or NetSuite Matrix items of any item type.
Deletion of items is not supported; if a Magento item is deleted in NetSuite the connector does not delete this item in Magento.
Inventory Item creation in NetSuite
Discount items mapped
Magento Item checked
Setting up images, websites
Item exported into Magento with the attributes that were set up in NetSuite
Discount mapping from NetSuite visible in Magento
As per Mapping List in NetSuite
Store view settings in Magento
Website config in Magento
Category view in Magento
Product is visible in the front end commerce website
Matrix Items Views and Configurations
Matrix item configuration
Matrix field mapping list
Matrix value mapping list
Magento Attribute set list
Magento Item Category List
Creating Root Category
In this example ‘Sporting Goods’ is created.
Category and Subcategory (Sporting Goods, Boxing)
Run Item Categories Import Flow in the Integrator
In NetSuite records, the item category and sub-category are visible
The features are visible in the Item creation record