Some notes on the behavior and functionality of this flow
- The mass update only picks up online applicable products. In cases where you might be wondering why there are more items in Shopify than what's shown on the dashboard job, some of the items might not be marked for online sales and will therefore not be picked up by the flow
- Make sure that there are no duplicate SKUs in Shopify. Shopify allows duplicate SKUs so when the mass update flow runs and sees duplicate SKUs, it will also create duplicate records for item id map
- For the error message "Product you are trying to create already exists on Shopify with Product Id: ##############. Please update the Celigo Shopify Item Id Map for item in NetSuite", on the product export flow. -for this error, check the item id maps. make sure there are no duplicates and check if any existing items are in shopify. also check if the product and variant ids in shopify match what is in the item id map records
- For mass update flow, if a field other than "nameinternal" for SKU is being used, lookup needs to be updated in 2 places. One in Mapping and the second one is at the record level.
Comments
1 comment
Hi Stein, each time I run this item id mass update flow, it is creating a new record in NetSuite for some reason though there's a Shopify item id map record already existing in NetSuite. Is there any possible reason why? I've verified the record level lookup and it says add or update only. Please advise.

Note: I'm using two item fields to find a match which is the "OR" condition in the mappings. Should we use the same at the record level as well? Please let me know.
Please sign in to leave a comment.