Order creation from XL

[Former Member]

Hi , We have a requirement to create orders through XL. The Details that are required for order creation (product, MOQ, customer,address etc..) are populated in an XL fie, when uploaded an order needs to be created for a customer. Any inputs on this is highly appreciated .

[arvind-kumar_avinash · Accepted solution]

There is no out-of-the-box solution for this. I can think of a couple of options like:

1. If the data has been put in separate CSV files as per their types:

   • You can use the hot folder processing. You can check https://help.hybris.com/1808/hcd/8ad0ddef866910148b9ba21d1ffa31cf.html and https://wiki.hybris.com/pages/viewpage.action?pageId=294094383 for futher details.

   • You can import the CSV files manually using ImpEx script. You can refer https://answers.sap.com/questions/12758731/modeappend-not-working-when-import-tools-is-used.html for an example.

2. Use an MS Excel processing API e.g. Apache POI, to read the data from the spreadsheet and write into Hybris database. Alternatively, you can convert the Excel data into ImpEx and then you can import the ImpEx file.

Please note that products can be easily imported also using Excel. You can refer https://help.hybris.com/1808/hcd/aec3d83d840a422faf2e5904eb5e1ae2.html for more information.

[arvind-kumar_avinash · Accepted solution]

Hi - was it helpful to you in any way?

[Former Member · Accepted solution]

Thanks a ton. Yes i think Impex script method would suit my requirement.

[arvind-kumar_avinash · Accepted solution]

You are most welcome.