You must keep your Magento 2 products in sync with NetSuite items so that any updates made to the products are automatically reflected in Magento 2. This lets you reduce errors related to product specifications across different product types.

Before you start

Before you can sync your items, there are some concepts to understand and actions to take.

Understand definitions and concepts

The following links and terminologies will help you understand the concepts that are necessary.

• NetSuite Items are also called Simple Products in Magento.
• NetSuite Matrix Items are also called Configurable Product in Magento.
• NetSuite Kit Items are also called Bundle Product in Magento.
• Customer Group, Website, Store, Store View, Attribute Set, Category.
• Virtual variation

Run these flows

You should run the following flow to setup your Integration App for item sync.

• Magento Customer Group to NetSuite: Run this flow to sync your Magento customer groups to "Celigo Magento 2 Customer Group" in NetSuite. 

• Magento Website to NetSuite: Run this flow to sync your Magento Websites to "Celigo Magento 2 Website" in NetSuite.

• Magento Store to NetSuite: Run this flow to sync your Magento stores to "Celigo Magento 2 Store" in NetSuite.
• Magento Store View to NetSuite: Run this flow to sync your Magento store views to "Celigo Magento 2 Store View" in NetSuite. 

• Magento Attribute Set to NetSuite: Run this flow to sync your Magento attribute sets to "Celigo Magento 2 Product Attribute Set" in NetSuite.

• Magento Category to NetSuite: Configure category sync and run this flow to sync your Magento categories to "Celigo Magento 2 Product Category" in NetSuite. 

Configure Magento category sync

1. In integrator.io, select the Magento 2 - NetSuite Integration App tile.
2. On the left, go to Settings > Integration Flows > General > Advanced Settings.
3. From Add Magento 2 Categories in NetSuite as, select the desired value.
   Info: Let’s you select the way Magento category information is displayed in the Magento 2 categories field under eTail > Magento of an item record in NetSuite. For example, if your Magento account contains the category as "Men’s -> Shoes -> Sport Shoes", the following is how it will be displayed in NetSuite based on the value you select.

Note: If you change and save the drop-down value, you will have to run the "Magento Category to NetSuite" flow again. This will change the display of category information in NetSuite accordingly.

1. (optional) Select Exclude default category from category name in NetSuite. 
   Info: Lets you exclude the Default Category when you import categories from Magento 2 to NetSuite. For example, if this check box is selected, "Men's -> Shoes -> Sport Shoes" will be displayed as "Men's: Shoes: Sport Shoes" in NetSuite. Otherwise, it will be displayed as "Default Category: Mens: Shoes: Sport Shoes". 
2. Select Save.

Map tier pricing

You can map NetSuite price levels to Magento customer groups of a Magento Website. Or, you can map NetSuite price levels to a Magento Website. The Magento tier pricing should be mapped appropriately in the Integration App so that no errors or duplicate products get created during product syncs.

1. In integrator.io, select the Magento 2 - NetSuite tile.
2. Go to Settings > Integration flows > Product > Advanced Settings > Map Magento Website/Customer Groups with NetSuite Price Levels.
3. Below the column names, select each Refresh icon. This will fetch values present in NetSuite and Magento.
4. Select either or both of the following.
• Under the "Magento 2 Website" column, select the desired Magento Website.
• Under the "Magento 2 Customer Groups" column, select the desired Magento customer group.
5. Under the "NetSuite Price Levels" column, select the desired price level for the values selected in step 2.
6. Under the "Default Price Level" column, select Yes if you want to set the price specified in NetSuite price level for syncing product price as the default price. This would sync the default price if no price is found for the mapped tier pricing.
7. Select Save.

Make sure your Magento product attributes are also in NetSuite

You must ensure that the product attributes present in Magento are also present in NetSuite. Generally, additional attributes are added as custom fields in the item record.

To ensure the required attributes are present in NetSuite, you must check the flow's field mapping and the Results tab of the NetSuite saved search.

For example, if you add a new attribute "color" in Magento, in NetSuite perform the following steps:

1. In the NetSuite Search bar, search for the required saved search and select it.

Info:

• If you are syncing simple products search for Celigo Magento 2 Item Export Search [your Magento instance].
• If you are syncing bundle products search for Celigo Magento 2 Kit Item Export Search [your Magento instance].
• If you are syncing simple products search for Celigo Magento 2 Matrix Item Export Search [your Magento instance].

1. Select Edit this search.
2. Select the Results tab.
3. Under the "Field" column, in the text box, enter "color". If the attribute is already present it will appear as a suggestion. Note: If the attribute does not appear as a suggestion, you must create a custom item field in NetSuite.
4. Add a value under the "Custom label" column for "color". 
5. Select Add.
6. Select Save.
7. In integrator.io, select the Magento 2 - NetSuite Integration App tile.
8. Go to Settings > Integrations Flows > Product.
9. Select the Field Mappings icon of the required flow.
• If you are syncing simple products select the "Field Mappings" icon of the "NetSuite Item to Magento Product" flow.
• If you are syncing configurable products select the "Field Mappings" icon of the "NetSuite Matrix Item to MagentoConfigurable Product" flow.
• If you are syncing simple products select the "Field Mappings" icon of the "NetSuite kit Item to Magento Bundle Product" flow.
10. Under the "Export Field" column, select "color" and map it to the Magento attribute "product.color" under the "Import Field" column.
11. Select Save & Close.

Configure NetSuite items

The Magento 2 - NetSuite Integration App identifies NetSuite items for sync only if it is configured for Magento.

To configure NetSuite items for Magento:

1. Sign in to your NetSuite account.
2. Go to Lists > Web Site > Items.
3. Select the item that you want to configure for Magento.
4. Select Edit.
5. Select eTail.
6. From Etail channel select "Magento 2".
7. (optional) Select Is virtual variation if you have configured virtual variation.
8. (optional) Select Is virtual parent if you want to mark this item as virtual variation parent.
9. Go to eTail > Magento2.
10. In Magento 2 Website, select the Magento Website to which this item belongs.
11. From Magento 2 attribute set, select the attribute set that belongs to this item.
12. In Magento 2 categories, select the category to which this item belongs.
13. In Magento 2 instance, select your Magento 2 instance to which this item belongs.
14. (optional) For kit and matrix items, you can select Dynamic SKU if you want the kit/matrix item's price to be calculated based on its child items. Note: If you provide pricing details in the item, these details will take precedence over dynamic pricing even if it is selected.
15. (optional) For kit/matrix items, you can select Price view.
16. Select Save.

Error: missing_website

Error message: Failed to Export Item #1234, Please select at least one website for this item.

Likely cause: The NetSuite Item to Magento Product Add/Update flow found no Magento 2 Website selection on the item that can be used for the Magento 2 instance the flow exports to. This often happens in a new install or a refreshed sandbox, where the item's selections were never made or no longer match.

Resolution: In NetSuite, open the item, go to eTail > Magento2, and select the Magento 2 Website and the Magento 2 instance that the item belongs to. The websites offered there come from the Magento Website to NetSuite flow, so in a new install or a refreshed sandbox run that flow first.

If the item's Magento 2 Website and Magento 2 instance are already selected, check the saved search that the flow's export reads. When that search includes a Category Id, Website Id, or price level column, the integration app stops looking up the item's websites itself and reads them only from a Website Id column, so an item without that value fails with this error. Point the export back to the saved search selected in Settings > Integration flows > Product > Advanced settings > NetSuite Saved Search for syncing item details, or include a populated Website Id column in your search.

Configure currency

You should configure the currency in which your NetSuite item price should be synced as products' price in Magento.

To configure the currency:

1. In integrator.io, select the Magento 2 - NetSuite tile.
2. Go to Settings > Integration flows > Product > Advanced settings.
3. From NetSuite currency for syncing product price, select the desired currency. For example, you can select "USA".
4. Select Save.

Other settings

• Import attributes values for all store views: 

Sync your simple product

The "NetSuite Item to Magento Product" flow lets you sync your simple products from NetSuite to Magento. When you run this flow, the simple product present in NetSuite is synced to Magento and the Magento ID is saved in the "Celigo Magento 2 Item Id Map List" record in NetSuite. This record can be found using the global search bar in NetSuite.

Configure and run the flow

Notes: 

• You should  schedule the flow to run at regular intervals to sync items that are added after the first execution of the flow.
• For syncing existing NetSuite items, you will have to manually edit and save them. Or, if you want to sync all the existing items, run the "NetSuite Kit Item to Magento Bundle Product" flow. This flow updates the "Celigo Magento 2 Item Id Map" record for existing items. You can then run the "NetSuite Item to Magento Product" flow again to sync all your existing items as products in Magento.

1. In integrator.io, select the Magento 2 - NetSuite tile.
2. Go to Settings > Integration flows > Product.
3. Turn on the NetSuite Item to Magento Product flow.
4. From NetSuite saved search for syncing item details, select the configured saved search. By default, Celigo Magento 2 Item Export Search [your Magento instance] is already selected.
5. Select Save.
6. Select the Run button corresponding to the NetSuite Item to Magento Product flow.

Define your criteria to sync simple product

To customize the saved search:

1. In NetSuite, in the global search bar, enter Celigo Magento 2 Item Export Search [your Magento instance].
2. Press Enter.
3. In the results that are displayed, find Celigo Magento 2 Item Export Search [your Magento instance].
4. Select Edit this Search.
5. Under the "Criteria" tab, add the desired criteria.
6. Select Save.

Sync your configurable product

The "NetSuite Matrix Item to Magento Configurable Product" flow lets you sync your configurable products from NetSuite to Magento. To sync your configurable products, you first have to sync all the NetSuite child items to Magento using the "NetSuite Item to Magento Product" flow. After the child item sync is successful, you can sync the parent item as a configurable product to Magento using the "NetSuite Matrix Item to Magento Configurable Product" flow. The Magento ID of the synced products is saved in the "Celigo Magento 2 Item Id Map List" record in NetSuite. This record can be found using the global search bar in NetSuite.

Configure and run the flow

Notes: 

• You will have to schedule to flow to run at regular intervals to sync items that added after the first execution of the flow.
• For syncing existing NetSuite items, you will have to manually edit and save them.

1. In integrator.io, select the Magento 2 - NetSuite tile.
2. Go to Settings > Integration flows > Product.
3. Turn on the NetSuite Item to Magento Product flow.
4. From NetSuite saved search for syncing item details, select the configured saved search. Generally, you will select  Celigo Magento 2 Item Export Search [your Magento instance].
5. From NetSuite saved search for syncing matrix item details, select the configured saved search. Generally, you will select  Celigo Magento 2 Matrix Item Export Search [your Magento instance]
6. Select Save.
7. Select the Run button corresponding to the NetSuite Item to Magento Product flow.
8. After successful execution of the above flow, select the Run button corresponding to the NetSuite Matrix Item to Magento Product flow.

Define your criteria to sync configurable product

To customize the saved search:

1. In NetSuite, in the global search bar, enter Celigo Magento 2 Matrix Item Export Search [your Magento instance].
2. Press Enter.
3. In the results that are displayed, find Celigo Magento 2 Matrix Item Export Search [your Magento instance].
4. Select Edit this Search.
5. Under the "Criteria" tab, add the desired criteria.
6. Select Save.

Sync your bundle product

The "NetSuite Kit Item to Magento Bundle Product" flow lets you sync your bundle products from NetSuite to Magento. To sync your bundle products, you first have to sync all the NetSuite child items to Magento using the "NetSuite Item to Magento Product" flow. After the child item sync is successful, you can sync the parent item as a bundle product to Magento using the "NetSuite Kit Item to Magento Kit Product" flow. The Magento ID of the synced products is saved in the "Celigo Magento 2 Item Id Map List" record in NetSuite. This record can be found using the global search bar in NetSuite.

Configure and run the flow

Notes: 

• You will have to schedule to flow to run at regular intervals to sync items that added after the first execution of the flow.
• For syncing existing NetSuite items, you will have to manually edit and save them.

To configure and run the flow:

1. In integrator.io, select the Magento 2 - NetSuite tile.
2. Go to Settings > Integration flows > Product.
3. Turn on the NetSuite Item to Magento Product flow.
4. From NetSuite saved search for syncing item details, select the configured saved search. Generally, you will select  Celigo Magento 2 Item Export Search [your Magento instance].
5. From NetSuite saved search for syncing kit item details, select the configured saved search. Generally, you will select  Celigo Magento 2 Kit Item Export Search [your Magento instance]
6. Select Save.
7. Select the Run button corresponding to the NetSuite Item to Magento Product flow.
8. After successful execution of the above flow, select the Run button corresponding to the NetSuite Kit Item to Magento Product flow.

Define your criteria to sync bundle product

To customize the saved search:

1. In NetSuite, in the global search bar, enter Celigo Magento 2 Kit Item Export Search [your Magento instance].
2. Press Enter.
3. In the results that are displayed, find Celigo Magento 2 Kit Item Export Search [your Magento instance].
4. Select Edit this Search.
5. Under the "Criteria" tab, add the desired criteria.
6. Select Save.