How to import single order with multiple products in it ?

Hi @sohaibahmed293,

Please advise how to map different number of products inside a single order item while importing ?

The easiest method would be to re-enable the “Display each product in its own row” option, then use the {orderid[1]} element as the Unique Identifier in the import. Each row with the same import ID will be added to the same order.

Otherwise, you’d have to use some advanced XPath to dynamically output the product information, e.g.:

{*[starts-with(name(),"orderlineid") and string()]}

And set the delimiter to “,” as shown here: https://d.pr/i/4oMVN8.

The easiest method would be to re-enable the “Display each product in its own row” option, then use the {orderid[1]} element as the Unique Identifier in the import. Each row with the same import ID will be added to the same order.

First time I imported using the same settings but the subsequent rows with same order ID were skipped and hence not imported.

Otherwise, you’d have to use some advanced XPath to dynamically output the product information,

Is this the method for when the Display each product in its own row option is enabled ? Also, is it tested or not ?

Hi @sohaibahmed293,

First time I imported using the same settings but the subsequent rows with same order ID were skipped and hence not imported.

It sounds like “Update existing orders with changed data in your file” was disabled in the Import Settings. Can you double check that and let me know?

Is this the method for when the Display each product in its own row option is enabled ? Also, is it tested or not ?

No, it’s for when that option is disabled, and yes I tested it with my own test data.

Hi @sohaibahmed293,

I’m marking this as resolved since we haven’t heard back in a while. Please open up a new topic if you still have questions.