Hey when i run fulfillment from Shopify to NetSui...
# integrations
d
Hey when i run fulfillment from Shopify to NetSuite i want to exclude one item from Celigo is that possible Thanks
t
Are you using the Shopify to NetSuite integration app? If so, the only way I can think of to do this is creating a workflow or script in NetSuite to remove the lines you don't want before the record is submitted. If you aren't using the integration app and it's a custom flow, you would need a script in Celigo to delete that item object from the line array from Shopify.
d
@Tyler Lamparter Hey yes it an integration app but if i remove it it's will fail becasue the item is populated in the Json payload so if tried to fulfill the item that i removed it will fail, is that what you mean Thanks for your reply 🙏
In SS is there a way when i fufill the 1st one before i submit it it's will uncheck the fulfill checkbox for just specific item
t
I see. So you have the item on the sales order, but don't need it on the fulfillment record? Could you just mark the item in NetSuite as not fulfillable?
🙌 1
d
is that will work because last time we have this item as unfulfilled we get this error failed to save the record because you are trying to fulfill nonexistent record but is it still will process the other items even we get this error
t
I think you would have to make a platform flow outside of the integration app to handle this use case. I would set the items to not be fulfilable, have the platform flow check if the item is fulfillable or not, then create the fulfillment only for items that are fulfillable.
1
d
@Tyler Lamparter Yes this the only option thank you so much Tyler 🙏
d
Driss, you need to replicate the flow as a custom flow and exclude items. We did it for many other Celigo customers that fulfill some items in NetSuite and some items in Shopify.
d
@Diego hey yes i figure it out and it's working when i don't want a specific item to not be fulfilled items : fulfilled = false replace all items = false and it's working Thank you so much
i did it in the app not custom flow i added some handlebars 😁
t
@Driss Talainte what was your handlebar expression out of curiosity?
d
i added 2 fields Dynamic mode = true items : item => that because if i didn't add it it's will always rest the item : fulfilled to true i changed replace all line = false For items : fulfill {{#compare line_items[].sku "==" "idkmysize-ringsizer"}}false{{else}}true{{/compare}}* @Tyler Lamparter
t
Ohh I see. Since you only have 1 item that needs the filtering the handlebar works. If you started to get a lot of items that need this, then the handlebar expression would become super long which is where a custom flow would be needed
d
Yes the long handlebar is just for some non-inventory items that have no SKU in shopify, we have just like 5 items
@Tyler Lamparter Hey Tyler i have a question please! about shopify-Nestuite app we have option to sync updates with filtering by Last modified date, but is that also going to sync new created orders in shopify or just modified ones ? Thank you 🫡
t
It will sync new orders and update already existing orders
d
@Tyler Lamparter Thank you so much 🙏🔥
m
I know this is old, but why not simply exclude it in the fulfillment saved search?
t
@mightyd3 because this is going from Shopify to NetSuite, not NetSuite to Shopify
m
details, details! Makes sense.