Hello Everyone,
I am working on a SO Import and ideally I would like to have the least amount of lines possible on the sales order. For instance, let’s say my data provider has 8 lines for a cheeseburger, is it possible to combine those 8 lines into one?
For instance combine the asparagus and cheeseburger lines into one:
Best answer by vkumar
Hi
I don't see an option to achieve this on import scenario. You may find a way to get the data merged at database provider / source file level.
The option
Hope this clarifies,
Regards,
+19Hi,
which will check for the InventoryID, and if it already exists it will go and update the same line and pass the proper qty for the line.
What type is your data provider? If it perchance is SQL, then you could create a view in SQL to combine items before your import scenario runs. Just a thought.
Hi,
which will check for the InventoryID, and if it already exists it will go and update the same line and pass the proper qty for the line.
This does not seem to add the 2 lines together, it just takes the second line.
What type is your data provider? If it perchance is SQL, then you could create a view in SQL to combine items before your import scenario runs. Just a thought.
CSV File.
Hi
I don't see an option to achieve this on import scenario. You may find a way to get the data merged at database provider / source file level.
The option
Hope this clarifies,
Regards,
Hi
I don't see an option to achieve this on import scenario. You may find a way to get the data merged at database provider / source file level.
The option
Hope this clarifies,
Regards,
Thank you for the confirmation!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
