[Shopify-NetSuite IA] Shopify Published Scope/Sales channels not updating correctly when Online Store is unchecked in NetSuite

Integration Apps
1

Hello Everyone,

In Shopify-NetSuite IA, I migrated the NetSuite Item to Shopify Product flow from the old REST API (deprecated) to GraphQL.

For the Published Scope field, I enabled option “Sync published scope from NetSuite to Shopify.” with only one sales channel— Online Store available in both systems.

The flow correctly updates Shopify product’s sales channel to Online Store when NetSuite item’s Shopify Product Visibility is set to Online Store. However, when we remove Online Store from Shopify Product Visibility in NetSuite, the flow does not clear the sales channel in Shopify — it stays as Online Store instead of clearing the field.

Thanks in Advance.

Regards

Ankit

2

Hi @Ankit_Lal :waving_hand:

This may help in your query. If not, let us know.

3

Hi Ankit,

I wonder if the Celigo flow does not handle blank values well with this mapping. Perhaps it skips them.

In your saved search you could try using a text formula, that returns a default value when the Shopify Product Visibility field is empty. Something like;
NVL({custitem_celigo_shpf_prod_visiblity_id},NULL)
would return the value NULL, which would be ignored by shopify, but I’m hoping would help clear that online store channel. I don’t know if the the formula would need ‘NULL’ rather than NULL, or any other value you’d prefer, as long as it doesn’t relate to an actual channel that exists.

I don’t know if this would work or not, but it’s probably what I would try.

1 Like