Import Magento 2 Custom Options from CSV

Applying Magento 2 custom options in bulk will be more efficient and rational when comparing it to manual configuring. Magento 2 import profile facilitates custom option upload and respectively provides you with the opportunity to bypass custom options configuring on the per product basis.

Instead of manual manipulations you can instantly enrich products with customizable options if you have them adjusted in the source import file. So the question is, what does the file look like or, more specifically, how should custom options be arranged to assign them to products successfully?

Import Magento 2 Custom Options Via Admin

Magento 2 import tool uploads custom options along with products in one go. Therefore all customizable fields that should be assigned to one product are nested in one file column in the following format.

Magento 2 Custom Options of Text, File or Date Type

Magento 2 Custom Options of Select Type

Magento 2 custom option name - specify custom option name as it should display for customers at the frontend (for example Print, Color, Shipped Till)

Price_type - decide on price type, to be exact how custom option price will be calculated - by percentage from simple product price or as fixed value

SKU - provide unique identifier for each custom option

Option_title - if you import custom option of select type, you are supposed to configure its value

Run import profile from System->Import.

Select type of the entity to be uploaded to Magento 2 via the admin.

Adjust the setting on this page before importing Magento 2 custom options, like import behaviour, field separators.

Choose the file that stores products with custom options.

Validate the file and confirm import if no warnings appear afterwards.

Once import finishes, check whether custom options have been created.

Import custom options in bulk is really handy, although majority of users find it frustrating to create properly structured import file. It might be perplexing, since all related custom options seem to pile up and it is difficult to sort them out at times, especially if one product has custom options of various types.

FREE Tool for Magento Custom Options Import

Alternative Way to Assign Custom Options to Magento 2 Products

Import custom options in bulk is really handy, although majority of users find it frustrating to create properly structured import file. It might be perplexing, since all related custom options seem to pile up and it is difficult to sort them out at times, especially if one product has custom options of various types.

File pattern, required by Store Manager for Magento import tool, allows you to smartly structure custom options within separate rows in the spreadsheet. Each option and value (custom option of select type) takes a separate row in the file. The screenshot below shows how it looks.

What details should be included to assign Magento 2 custom options to products successfully in the course of import. Here is the list

Option_type - specify the type for custom option you need to create

Is_required - put 1 in this column if custom option must be selected/configured/filled by customer at the frontend

SKU - insert the identifier for Magento custom option

Value_SKU - uploading customized fields of select type, you certainly have values for each and these values should have SKU as well

Product SKU - add product identifier in this column, so custom options will be assigned to necessary product in the process of import

Sort_order - set position for custom options

Title - input name of custom option in this column

Price - provide price for custom options (non-select type)

Price_type - specify what way price should calculate - percentage or fixed value

Value_price - uploading options of select type, you need to insert prices in this column

Value_price_type - set percentage or fixed if this field

Value_sort_order - set position for values, as they should display at the frontend

View_name - specify store view name

All characteristics of the import file can be gleaned from exporting existing custom options data and taking a look at it.

Import of Magento 2 custom options through Store Manager is fulfilled in several simple steps:

Open custom option import wizard either from main menu or from product lower grid and indicate path to source file with data to be imported.

Preview custom file data on the following step.

Set delimiters used to detach details in .csv file.

If you import Magento 2 custom options to specific store view, select it on the following step checking box for it respectively.

Select product and custom option identifier and map fields, you have in .csv file to corresponding database.

Set suitable import options options on the last step of the import wizard.

Check the products with custom options in Store Manager after import finishes.

Custom options import to Magento 2 is performed flawlessly with Store Manager for Magento, you can also update existing custom options, assign new options to merchandise that already have customizations and do more in terms of custom option management.