5% Off Storewide
Rating 5 stars - 2 votes

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

option name=NAME, type=OPTION TYPE (file, date, image), required=VALUE (1 or 0), price=VALUE, price_type=TYPE (fixed or percent), sku=CUSTOM OPTION SKU

Magento 2 Custom Options of Select Type

option name=NAME, option type=TYPE (dropdown, radio button, checkbox, multiple select), required=VALUE (1 or 0), price=VALUE, price_type=TYPE (fixed or percent), sku=CUSTOM OPTION SKU, option_title=CUSTOM OPTION TITLE



  • Magento 2 custom option name - specify custom option name as it should display for customers at the frontend (for example Print, Color, Shipped Till)
  • Type - input type for custom option to be created (dropdown, image, date, multiple select, text field, etc)
  • Required - mark this field as required using 1 value and respectively put 0 if customer is not obliged to adjust this option before adding product to cart
  • Price - if the customization, represented by Magento 2 custom option, should draw additional cost specify its value
  • 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
  1. Run import profile from System->Import.
  2. Select type of the entity to be uploaded to Magento 2 via the admin.
  3. Adjust the setting on this page before importing Magento 2 custom options, like import behaviour, field separators.
  4. Choose the file that stores products with custom options.
  5. Validate the file and confirm import if no warnings appear afterwards.


  6. 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

Set Up FREE

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:

  1. 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.


  2. Preview custom file data on the following step.


  3. Set delimiters used to detach details in .csv file.


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

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


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


  7. 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.

Free upgrade to Magento 2 supported version