Robust NetSuite Integrator: How to list NetSuite products in Shopify?

Robust NetSuite Integrator: How to list NetSuite products in Shopify?


If you are interested in (listing / syncing) all your NetSuite products in your Shopify store with all their available details, then follow these below-mentioned steps.

Step 1:

Inside the Robust NetSuite Integrator app, please go to the  Configuration Page  >  App Settings   > and scroll-down to this "List Product from NetSuite to Shopify" toggle, and turn it on.


Step 2:

Inside NetSuite, from the top navigation pane, please go to the Cutomization > Lists, Records, & Fields > Item Fields and click on the New button. Below is a screenshot to help you understand this visually.


Step 3:

Follow, the steps displayed in the below image.
Note: 
This should be done twice i.e. for two fields. 1) To list products on Shopify. 2) To delete products from Shopify.
SAVE these two newly created NetSuite field IDs i.e. Field ID to list products on Shopify, and Field ID to delete products from Shopify.

Step 4: 

Inside the Robust NetSuite Integrator app, please go to the  Configuration Page > App Settings > and scroll-down to this "NetSuite Product Import" section.
  1. NetSuite Field ID to identify active products on Shopify:

    Here, enter a NetSuite Field ID from Step 3 that represents "List products on Shopify".
  2. Temporary field to save Shopify Product ID:

    Here, enter a NetSuite Field ID at which you want to see a newly created Shopify product ID i.e. 123456789.
  3. NetSuite Field ID to identify products to delete from Shopify:

    Here, enter a NetSuite Field ID from Step 3 that represents "Delete products on Shopify".

Below is a screenshot to help you understand this visually.

Note: 

All these fields must be entered to move to the next step.

Step 5:


  1. To configure product fields mapping. Click on the Configure Product Mapping button. Below is a screenshot to help you understand this visually.

  2. Once the button is clicked, you will see this below-displayed pop-up.

  3. To configure meta fields mapping. Click on the Configure Product Mapping button. Below is a screenshot to help you understand this visually.

  4. Once the button is clicked, you will see this below-displayed pop-up.


Important notes:

  1. All of these above-mentioned fields support both standard & custom NetSuite field IDs. Also, please make sure to save the changes before leaving the configuration page.
  2. If you are going to use this feature, before updating any item in NetSuite, please be careful with parent & child relationship items. For instance: If the parent item P1 has 2 child items (variants) called A&B in Shopify and the parent item P2 has 1 child item (variants) called C in Shopify.

    Then, in that case, if you want to update variant C under the parent item P1 in Shopify then firstly you need to de-list variant C by selecting the delete checkbox from NetSuite. Once it is deleted from Shopify then re-list the variant C by selecting the update checkbox from NetSuite.
  3. If you want to delete parent item including variants from Shopify then you need to Select the checkbox of Delete custom field of that parent item only from Netsuite. This will not only delete the parent item but also its variant items from Shopify.
  4. If you want to delete single variant of parent item from Shopify then you need to Select the checkbox of Delete custom field of that variant item only from NetSuite. Once the variant item gets deleted, it will also delete the parent item from Shopify too.
  5. Each product can have a maximum of three options and a maximum of 100 variants. e.g. If the product has 200 variants then it will list only hundred variants on Shopify due to restriction from Shopify.
  6. While listing products from NetSuite to Shopify, Missing items with Reason are logged in the CSV file which can be downloaded from configuration (only a week old log will be available for download).
  7. This feature is available as a part of our Advance Unlimited yearly plan or you can purchase it separately as an add-on from the Plans page in the app.