1. NetSuite Connector
  2. NetSuite Connector Sync Management
  3. NetSuite Connector Product Sync Management
  4. Mapping Product or Inventory Sync in NetSuite Connector

Mapping Product or Inventory Sync in NetSuite Connector

The Product Mapping page enables you to setup item mappings from NetSuite to your storefronts and marketplace channels. NetSuite Connector will use these mappings to create and update product listings on those channels.

To map product or inventory sync data:

  1. Login to NetSuite Connector.

  2. Select a connector.

  3. Go to Mappings > Products.

  4. Click Add Mapping.

  5. Complete the Add Field Mapping window:

    • On the Required row, select either Category or SKU.

    • ON the Standard row, select a NetSuite field.

  6. Click Add Mapping.

  7. Click the new mapping that is added at the bottom of the table.

  8. Complete the Mapping window:

    • If the mapping type is Category mapping:

      1. On the NetSuite Field ID row, enter a NetSuite Field ID.

      2. On the Value row, enter a value.

      Note:

      NetSuite Connector uses the Category mapping for a category to determine whether a particular item should be listed using that category. There are two typical ways to set up this mapping. First, we can check whether a certain field is populated; all items that have a value in that field will be categorized as 'ShopifyPriceQty' items, in this case. Place a value in the NetSuite Field ID box (and leave Value blank) to use this approach. Alternatively, we can check whether your chosen field has a certain value for items, and only items having that value will be categorized as 'ShopifyPriceQty'. Populate the NetSuite Field ID and Value boxes to use this approach.

    • If the mapping type is SKU mapping:

      1. On the Mapping Type column, select either Item Field, Item Field Translation, or Logic.

      2. On the second column:

        • If Item Field is selected in the Mapping Type column, enter a value in the NetSuite Field ID column.

        • If Item Field Translation is selected in the Mapping Type column:

          1. Click Translation Mapping – Click to Edit.

          2. In the first row:

            • Enter a value in the NetSuite Value column.

            • Enter a value in the second column.

          3. Enable the On/Off switch.

          4. Enter a value in the NetSuite Field field.

          5. Click Save Changes.

        • If Logic is selected in the Mapping Type column:

          1. Click Logic Mapping – Click to Edit.

          2. Complete the Edit Logic Mapping for ‘sku’ (BETA) window.

            • In the Check If row:

              1. In the first column select a condition for the filter.

                • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

                • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

                • Computed Value – a value that is a result of a condition or an equation or operation.

              2. In the second, third, fourth, and fifth column:

                • If Order Header Value is selected in the first column:

                  1. In the second column, select an order header value from the dropdown.

                  2. In the third column, select a condition how to evaluate from the dropdown.

                  3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

                  4. In the fifth column, enter a value to evaluate against in the Value 2 field.

                • If Fixed Value is selected in the first column –

                  1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

                  2. In the third column, select a condition how to evaluate from the dropdown.

                  3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

                  4. In the fifth column, enter a value to evaluate against in the Value 2 field.

                • If Computed Value is selected in the first column –

                  1. In the second column, click Click to View/Edit Value.

                  2. In the Value type row, select either Select Value Conditionally or Calculate Value.

                  3. Complete the form.

                    • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

                    • If Calculate Value is selected:

                      1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

                      2. In the second column:

                        • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                        • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                        • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

                      3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

                      4. Click Save Changes.

            • In the If True, Set Value To row:

              In the first column select a condition for the filter.

              • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

              • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

              • Computed Value – a value that is a result of a condition or an equation or operation.

              In the second, third, fourth, and fifth column:

              • If Order Header Value is selected in the first column:

                1. In the second column, select an order header value from the dropdown.

                2. In the third column, select a condition how to evaluate from the dropdown.

                3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

                4. In the fifth column, enter a value to evaluate against in the Value 2 field.

              • If Fixed Value is selected in the first column –

                1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

                2. In the third column, select a condition how to evaluate from the dropdown.

                3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

                4. In the fifth column, enter a value to evaluate against in the Value 2 field.

              • If Computed Value is selected in the first column –

                1. In the second column, click Click to View/Edit Value.

                2. In the Value type row, select either Select Value Conditionally or Calculate Value.

                3. Complete the form.

                  • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

                  • If Calculate Value is selected:

                    1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

                    2. In the second column:

                      • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                      • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                      • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

                    3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

                    4. Click Save Changes.

            • In the Otherwise, Set Value To row:

              In the first column select a condition for the filter.

              • Order Header Value – These are values that give general information about an order, such as billing and shipping information, order totals, the order date, and more.

              • Fixed Value – A constant value (something that does not change from order to order. An example would be a number ‘1’.

              • Computed Value – a value that is a result of a condition or an equation or operation.

              In the second, third, fourth, and fifth column:

              • If Order Header Value is selected in the first column:

                1. In the second column, select an order header value from the dropdown.

                2. In the third column, select a condition how to evaluate from the dropdown.

                3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

                4. In the fifth column, enter a value to evaluate against in the Value 2 field.

              • If Fixed Value is selected in the first column –

                1. In the second column, enter any value to evaluate the condition against in the Value 1 field.

                2. In the third column, select a condition how to evaluate from the dropdown.

                3. In the fourth column, select either Fixed Value, Order Header Value, Computed Value.

                4. In the fifth column, enter a value to evaluate against in the Value 2 field.

              • If Computed Value is selected in the first column –

                1. In the second column, click Click to View/Edit Value.

                2. In the Value type row, select either Select Value Conditionally or Calculate Value.

                3. Complete the form.

                  • If Select Value Conditionally is selected, the form follows the same rules and features as the entire Edit Logic Mapping form.

                  • If Calculate Value is selected:

                    1. In the Set Value To row, select either Order Header Value, Fixed Value, or Computed Value in the first column.

                    2. In the second column:

                      • If Order Header Value is selected in the first column, select an order header value from the dropdown.

                      • If Fixed Value is selected in the first column, enter a value to evaluate against in the Value 1 field.

                      • If Computed Value is selected in the last column, follow the steps listed in editing the filters for the Computed Value of the form.

                    3. In the third column, select an operation to do to the values, conditions, or filters in steps 1–2.

                    4. Click Save Changes.

            Note that in rows two and three, the Location we use is set when the condition is true, and the condition to use when it's false.

Related Topics

NetSuite Connector Product Sync Management
Viewing Product Mapping in NetSuite Connector
Mapping Required and Optional Fields for Product Sync
Mapping Cart Categories in NetSuite Connector
Mapping Inventories in NetSuite Connector
Mapping Custom Field Inventories in NetSuite Connector
Mapping Prices in NetSuite Connector
Troubleshooting Product Sync Issues in NetSuite Connector
NetSuite Connector Product Sync FAQ

General Notices