Ignore a specific sku when creating Fulfillment in NetSuite
Hi,
I have a custom flow that fetches the shipments from the platform named Ship Bob and create Item Fulfillments in NetSuite. In some of the Shipments in Ship bob an extra Thank You card item is added but these items are not present in the NetSuite Order. hence the flow gives error when trying to create the Item Fulfillment as the Thank You card item present in ShipBob shipment is not found while fulfilling in NetSuite. I need to figure out a solution to handle this scenario. Is there a way to neglect the product line with the Thank You card item?
Currently I'm using a standard mapping type for the product line as shown below.
Thanks in advance.
-
Have you considered transforming the sales order into a fulfillment rather than specify the items on a new fulfillment? This only makes sense if you know the orders will be shipped complete. When you transform you'll have an Item Fulfillment that only contains the items from the order. There is a NetSuite preference to default items to fulfilled which will also need to be set, otherwise you'll need to handle that in IIO.
For our Ship Bob integrations we end up with some scripting to reliably handle the shipment data from ShipBob, the main reason is how they consolidate order lines by SKU.
0 -
Hi Steve Klett,
We have the scenario of partial Shipments hence completely transforming the Sales order into Fulfillment will not suite for us. I'm specifying the "created from" sales order and then replacing all the item lines
Please see the mapping below. I believe my issue will be resolved if we are able to neglect/skip the particular Thank You card SKU when mapping.
Can you suggest how this can be handled?
0 -
Aishwarya M J I don't know of a way to do accomplish that without scripting. We probably script 90% of our fulfillment flows for various reasons.
0 -
Aishwarya M J like Steve Klett said, this would require a pretty simple script. Here is an example of how you could do this with a preMap script.
function preMap (options) {
return options.data.map((d) => {
d.products_new = d.products.filter(function (p) {
return p.sku != "Thank you card";
}
);
return {
data: d
}
})
}
0 -
Hi Tyler Lamparter,
Thank you so much for the sample script. I will try out this to see if it works as expected.
0
Please sign in to leave a comment.
Comments
5 comments