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
- Serialized Inventory Item (matrix children and non-matrix) -> ‘Simple’ Product
- Assembly Items (simple , serialized, lot numbered) -> ‘Simple’ Product
- Non-Inventory Item for Sale (non-matrix only) -> ‘Virtual’ Product
- Non-Inventory Item for Resale (non-matrix only) -> ‘Virtual’ 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
Note: All other item types are not yet supported by the Magento Real-Time Item Export. 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. For more information on how to set this up, click here. The Item Export automatically exports your quantity pricing levels from NetSuite to Magento.
Note: The Item Export can only export prices as $USD. If exporting prices in currencies other than $USD is required, please contact Celigo to obtain pricing on this customization.
Note: If using a multi-store setup in Magento, the Item Export does not support setting different prices for different store views for the same item in Magento. If this is required, please contact Celigo to obtain pricing on this customization.
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 use the ‘Update Attributes’ option on the Magento Control Panel.
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. In the example below, the selected attribute set is ‘Shirts (General)’ and the fields under the ‘Shirts (General) – Attributes’ section such as ‘Manufacturer’, ‘Color’, etc. are the attributes associated with that attribute set. 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.
Important: 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). If you require additional attributes to be mapped to NetSuite fields instead of virtual fields as described above, it can be done as a customization. Please contact Celigo to obtain pricing for it.
- 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 Magento Control Panel. That is the responsibility of the customer.
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 Magento Control Panel 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.
Note: In order to use this functionality, additional services and fees may apply. Kit item exports are only supported in Celigo’s Magento Connector 2.0 and newer. Please contact Celigo to obtain pricing information regarding upgrading.
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 Celigo Integration Logs.
Note: In order to use this functionality, additional services and fees may apply. Matrix item exports are only supported in Celigo’s Magento Connector 2.0. Please contact Celigo to obtain pricing information regarding upgrading.
Note: Only 2 (two) matrix attributes are supported by default. E.g. one attribute would be “Color” and the other attribute would be “Size.” Additional matrix attributes can be set up for an additional one-time fee per attribute.
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.
Flow Schedule and Monitoring
The Item Export flow is a real-time flow, triggered when you save a NetSuite item that has the Magento Item box checked. Any error that occurs during an export is logged on the Custom tab of the item record in NetSuite, under the Celigo Integration Log subtab.
The following mappings are installed by default. Please consult your Celigo project resource for mapping additional fields, as it might not be possible to map certain fields. Custom Magento fields cannot be mapped unless you expose them to the Magento Web services API. If you need assistance, please contact Celigo to obtain pricing on this customization.
|NetSuite Field||Magento Field||Notes|
|Sales Description||Short Description||Mapped to NetSuite Purchase Description for item types Service Item for Sale, Non-Inventory Item for Sale, and Other Charge Item for Sale|
|Meta Tag HTML||Meta Description|
|Search Keywords||Meta Keywords|
|Special Price From||Special Price From Date||Custom field on NetSuite item record|
|Special Price To||Special Price To Date||Custom field on NetSuite item record|
|URL Key||URL Key||Custom field on NetSuite item record|
|Item Visibility||Visibility||Custom field on NetSuite item record|
|Weight||Weight||Only mapped for Inventory, Serialized Inventory, and Lot Numbered Inventory item types|
|Taxable||Tax Class||If Taxable checkbox is checked, “Taxable Goods” is exported, otherwise “Not Taxable” is used|
|Allow Gift Message||Allow Gift Message||“Use config” checkbox is not available at this time|