4

I've seen a few similar threads that asked this question but they were either using an outdated version or did not exactly meet my needs. So I thought I'd ask here:

  • Does Magento allow importing of custom options for "simple products" ? (ver 1.7.0.0)
  • If it doesn't, by default, is there an easy way to allow such functionality?

Note: If neither of these are possible, I am also open to suggestions about extensions (free or not) that address this need.

Improve this question

4 Answers 4

Reset to default
3

Have you looked into using Magmi? It has a lot of extra functionality for imports, one of their plugins may meet your needs, if it isn't already in Magmi.

Magmi on Sourceforge

Documentation

Improve this answer
3
  • This is what I ended up going with. Thanks for the suggestion.
    – Adrift
    Jan 28, 2014 at 2:49
  • You're welcome, it has served me quite well.
    – DWils
    Jan 28, 2014 at 6:20
  • Just a word of warning about Magmi and custom options. I just tried it to append an extra field onto the end of a custom options list and it ended up removing them all! Luckily I backed up the database first, but just... be careful.
    – Thomas Harding
    Dec 14, 2017 at 16:25
5

Magento's ImportExport module (not the dataflow one) allows you to import custom options.

You need the following fields:

  • _custom_option_store
  • _custom_option_type
  • _custom_option_title
  • _custom_option_is_required
  • _custom_option_price
  • _custom_option_sku
  • _custom_option_max_characters
  • _custom_option_sort_order
  • _custom_option_file_extension
  • _custom_option_image_size_x
  • _custom_option_image_size_y
  • _custom_option_row_title
  • _custom_option_row_price
  • _custom_option_row_sku
  • _custom_option_row_sort

As found here: https://github.com/LokeyCoding/magento-mirror/blob/magento-1.8/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php#L232

Logic is implemented here: https://github.com/LokeyCoding/magento-mirror/blob/magento-1.8/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php#L670

Explanation of fields: http://www.magentocommerce.com/knowledge-base/entry/exporting-custom-variants-and-options

Presentation of the Mage ImportExport module, maybe this gives you some insight in how it works: http://www.slideshare.net/MagentoImagine/magentos-imagine-ecommerce-conference-2011-using-the-new-import-module

I can't really find an example how to use it.

EDIT

After exporting a product with some custom options, here's an example:

example export

Improve this answer
3
  • Do I get it right that this module doesn't have any GUI in Community Edition? All the instruction articles are related to Magento Go.
    – Victor Sergienko
    Sep 23, 2014 at 17:19
  • Magento go uses the same GUI as Magento CE.
    – Paul Hachmang
    Sep 23, 2014 at 22:39
  • I must be missing something: the only export with a changeable field mapping I see in CE 1.9 is the DataFlow one. And the last incomplete phrase of the answer is something I still feel like :)
    – Victor Sergienko
    Sep 24, 2014 at 4:34
-1

If you follow the below link for importing products with custom options, it will be properly imported to magento catalog.

http://wiki.magmi.org/index.php?title=Custom_Options

If you are importing product using .csv file, the file must be having the column format as follows:

Name:Type:Is Required:sort number (where, sort number is an optional)

Example: Size:drop_down:0

So the quick example for dropdown's custom option value is,

Medium:fixed:5|Large:fixed:10

with | symbol you can add more row for an option.

Note: under Itemprocessors section, Custom Options must be chosen.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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