Rating 5 stars - 2 votes

Import Magento 2 Custom Options from CSV

How to Import Products to Magento 2: Learn how to properly prepare CSV file and configure import settings for product upload

Import is a quick way to apply Magento custom options in bulk. And, arguably, it's more efficient and rational compared to adding custom options manually. Luckily, Magento 2 import tool allows you to upload custom options for multiple products. For successful import, you need to have properly configured file. How to prepare such a file, we'll describe below.



Product with Custom Options
Product with Custom Options

Import Magento 2 Custom Options Via Admin

If you want to import custom options via Magento admin, all customizable fields that should be assigned to a product must be 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


Import Magento 2 Custom Options from CSV
Import Magento 2 Custom Options from CSV

  • Magento 2 custom option name - specify custom option name as it should be displayed for customers at the frontend (for example Print, Color, Shipped Till)
  • Type - input a 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. Import Magento 2 Custom Options from CSV
    Import Magento 2 Custom Options from CSV

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

Using import to create custom options in bulk is really handy. Though, many users find it frustrating to create a properly structured import file since all related custom options seem to pile up and it is difficult to sort them.


FREE Tool for Magento Custom Options Import

Set Up FREE

An Alternative Way to Assign Custom Options to Magento 2 Products

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



Import Custom Options with Store Manager File Example
Import Custom Options with Store Manager File Example

Below are the details that must be included in the file to assign Magento 2 custom options to products successfully:

  • 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 a 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. To open the Custom Options Import Wizard, navigate to sidebar -> Imports/Exports. After the wizard is launched, indicate a path to the source file with data to be imported.


  2. Import Custom Options with Store Manager
    Import Custom Options with Store Manager

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


  4. Import Delimiters in Store Manager
    Import Delimiters in Store Manager

  5. If you import Magento 2 custom options to a specific store view, select it in the following step by selecting a respective check box.

  6. Select a product and custom option identifier and map the fields that you have in the .csv file to the corresponding database fields.


  7. Assign Columns During Import
    Assign Columns During Import

  8. Preview custom file data in the following step.


  9. Import Custom Options Preview
    Import Custom Options Preview

  10. Set suitable import options in the last step of the import.


  11. Import Options Step
    Import Options Step

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


  13. Check Imported Custom Options in Store Manager
    Check Imported Custom Options in Store Manager

As you can see, import of custom options is much easier with Store Manager for Magento. You can also update existing custom options, assign new options to products that already have customizations, and do more in terms of custom option management.



Related Articles:


Card image

Magento Automated Custom Options Import

Schedule Magento custom options import to be accomplished automativally according to pre-set time. Read More...

Card image

How to Import Products in Magento 2

A very detailed guide on importing products to Magento 2: step-by-setp tutorial, CSV sample, useful tips. Read More...

Card image

Magento 2 Configurable Product Creating

Learn how to create Magento 2 configurable attributes and assign simple products to them. Read More...

Card image

Required Magento 2 Import Values

Get deep guide to prepare an accurate CSV for Magento 2 import. Read More...


COMMENTS
Be the first to comment.