Rating 5 stars - 1 votes

Import Custom Options Easily

How to Set Up Custom Options in Magento 2

How to Import Products to Magento 2

Magento custom options is an easy and efficient way to sell product in variations in case you have unlimited number of items available in stock. Despite of the fact that drop-downs/options can be created with less efforts, than let’s say configurable products, in case you have hundreds or even thousands of goods for which custom options should be added, it may take considerable amount of time. You might say that import may solve the situation, but you might be shocked when discover that default admin functionality does not support this possibility.

If you are not much into coding and have no trusted script you can apply, you might be interested in solution that will be useful for both store owner and tech specialist. With Store Manager for Magento application you can carry out Magento custom options import procedure and assign them in bulk to already existing in your database products.

Basically, the procedure involves file preparation, import settings and actual import of custom options into Magento with further results viewing.

Let’s try to view each stage and see what is necessary to follow to do Magento import of custom options without special technical skills.

File Preparation

To upload custom options using Store Manager, the details on them should be available and properly arranged in the file that you are going to used for the upload.

The good idea is to add options to some simple products manually and then export it to see the fields that should be included and how information should be defined in them.

Generally, for custom options to be applied to existing products there should be the following columns:

  • field(s) used for identification of product to which custom options should be applied to (product ID, SKU or Product name+SKU);
  • custom options identifiers: option id (in case they are already in database and should be updated), options SKU or option SKU+title;
  • option type - indicate code for input type to be used for particular custom option;
  • view name - there should be indicated store view value;
  • title - here should be indicated name of option (like color, size, material etc);
  • value title - there should be indicated option values. For example for color there should be - green. If you have option of select type, each option value should be in separate row.
Magento import of custom options
Magento import of custom options

Additionally, you can indicate in the file columns with information on price mark-up of each option, their sort order, make them required etc.

Import Settings

When your file is ready you can proceed to its upload. In Store Manager there is separate Import/Export Wizard for custom options.<./p>

There you need to set certain settings, the most important of them are:

- selecting delimiters for proper parsing of file columns and information in them.

Magento import of custom options
Magento import of custom options

If you are not sure about the ones used in your file, do not worry, you will not have to cancel the process, as there is the step where you can preview your file.

- fields mapping and identifiers selection. At this step you need to select identifiers for your products and custom options (taking into consideration columns you have in the file) and also link columns of your custom options import file to database fields.

Magento import of custom options
Magento import of custom options

- selecting import options according to your needs (whether you need to add new custom options or update existing).

Magento import of custom options
Magento import of custom options

Import Running and Results

After you are all set, at the last step of Magento custom option import wizard you will see “Import” button. As soon as you hit it, the procedure of upload will start and there will appear progress bar notifying you about the percentage of task completeness.

When the process will be to end, you will see last window of wizard with detailed logging and statistics on the executed procedure. After that you can clear Magento cache and re-index and check the results at your front-end.

Magento import of custom options
Magento import of custom options

That's it. Now you have custom pptions imported into your Magento site. Make Magento site management easier with Store Manager for Magento!

Import custom options with Store Manager! Get it Now!

Related Articles:

Card image

Simple Products with Custom Options VS Configurable Products

Detailed comparizon of Magento configuable products and Magento simples with custom options. Read More...

Card image

How to Bulk Remove Magento Custom Options

Check how to massively delete custom options for selected products and replace them with new ones.Read More...

Card image

Clone Magento Custom Options to Assign Them to Multiple Products

Guides on how to assign already configured custom options to other products massively by means of copy/paste or import. Read More...

Card image

Upload Magento Swatch Images to Configurable Products

Get the full explanation of Magento swatch images and their purpuses and find out the ways to assign them to products via admin and Store Manager. Read More...

Be the first to comment.