You can now create a custom item field to sort matrix items or items with variations in ascending order in Shopify. You can then use the custom item field to specify the item position. For example, if you have 5 matrix items, in the custom item field you can specify the position (1 through 5) for each matrix item. Generally, in the order in which you want the items to appear in Shopify.
To sort the items (matrix/variation) in Shopify in ascending order:
- In NetSuite, go to Customization > Lists, Records, & Fields > Item Fields > New to create a new custom item field. The custom item field can only be used for a matrix item or virtual variation item and the item should be an Inventory item (including assembly items).
- Add the custom field to the Celigo Shopify Matrix Item Export saved search and assign a label for easy identification in the integration app mappings.
- Update mappings of the NetSuite Matrix Item to Shopify Product Add/Update flow:
- Add the destination field: position with the datatype as number.
- From the source field dropdown, select the custom field label created in the saved search above.
If you change the Shopify Store name, the Shopify—NetSuite Integration App automatically changes the store name in NetSuite Saved Searches and Flow Names in integrator.io.
Note: Only the default components (flows and Saved Searches) that came with the Integration App will get modified. Any customized component will require manual modification.