I have an a little bit crazy feature request. I have a Excel/CSV file with 5 description fields. Description 1, Description 2, Description 3 ... and need during the import to merge them with breakline

Description 1 Description 2 Description 3 Description 4 Description 5

into one description field.

I know via PHP is it possible but the guy who needs this want it so simple as possible via CSV or better Excel.

  • Not much to do with Magento, oder? – user487772 May 6 '14 at 11:25
  • I know but i need this as simple solution like this. The guy wants to upload the import data as CSV or MS Excel XML file and it needs to merge during the import progress more than 1 columns into 1 description column with breaklines. I prefer a quick and easy solution because i don't want write a extension for that. – Alexander May 6 '14 at 20:29

So it is not really a quick solution but you could look into building something using FastSimple Import

This would allow you to build your own product converter where you can merge the fields you need into the description field and then pass this into the importer. I have been working with this extension on a couple of products and highly recommend it when building custom import mappings.

| improve this answer | |

Use Excel formule ---> Text ---> Merge fields

| improve this answer | |
  • 1
    That is what the guy doesn't want. He wants to upload the data file with the 5 fields and merge then during the import progress. Maybe possible with Magento Dataflow and additional XML actions? – Alexander May 6 '14 at 12:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.