I am trying to create an online catalog of products, that could be filtered, sorted, etc, and I followed these steps:

  • I have created a content type (product)
  • I have created a view where I can view and filter/sort these products

Now, the major problem is to manually enter hundreds of products! I have product descriptions in Excel, and image files with links, but I don't know how to upload everything in bulk.

How could I do this?

  • if you have an excel sheet, then you can create its csv. Now create a php script that will iterate through every entries and create node programmatically – subhojit777 Jan 15 '13 at 8:28
  • Welcome to DA! I've written down an answer that should be appropriate for both a "site builder" and a "developer" role. I'm not sure how well Feeds will handle images, but I wish you the best of luck and hope my answer is of use to you. :) – Letharion Jan 15 '13 at 8:38

Maximum flexibility:

I would use the Migrate module. It has CSV support, and there's even direct spreadsheet support in the works. Migrate documentation.

It will require some coding, yes, and Migrate module is not the easiest module to get a grip on, so if you're new to coding, you may need some help with that, but I think it's by far the best solution.

Easier implementation:

The Feeds module claims that it can

Import or aggregate CSV files

I haven't used that particular piece of functionality myself, but from previous use of Feeds, I'm under the impression that this could be configured from the UI, and thus wouldn't require any code. Feeds documentation.

|improve this answer|||||
  • Thank you for welcoming me and of course for your help! I'll definitely check out Migrate module to import text fields. As for images - I will still be waiting suggestions from DA community. Thanks again – user12702 Jan 15 '13 at 10:15
  • Your welcome. :) Migrate handles files (and thus images) just fine. Not sure about feeds though. – Letharion Jan 15 '13 at 13:20
  • I used feeds combined with feeds tamper module to upload text and multi-value fields and it worked great! thanks again! – user12702 Jan 17 '13 at 10:38

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.