--- title: How can I import product options? description: The options are rather complex properties of the products, and it is hardly possible to put them into the same plain table with general products list. --- [Skip to content](https://learn.fcrmedia.ie/knowledge/how-can-i-import-product-options#main-content) [More support](https://learn.fcrmedia.ie/knowledge/kb-tickets/new?hsLang=en) ![fcr-logo-2020-pale.png\]](https://learn.fcrmedia.ie/hs-fs/hubfs/fcr-logo-2020-pale.png?height=40&name=fcr-logo-2020-pale.png) Open main navigation Close main navigation - [More support](https://learn.fcrmedia.ie/knowledge/kb-tickets/new) - [Get Your Online Store](https://fcrmedia.ie/) [Get Your Online Store](https://fcrmedia.ie/) Hello. What Is Your Question? - There are no suggestions because the search field is empty. 1. [Knowledge Centre](https://learn.fcrmedia.ie/knowledge?hsLang=en) 2. [Products](https://learn.fcrmedia.ie/knowledge/products?hsLang=en) 3. [Import and export](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#import-and-export) # How can I import product options? ## The options are rather complex properties of the products, and it is hardly possible to put them into the same plain table with general products list. So system doesn't allow importing product options using the CSV format described in [this article](https://knowledge.gpie.ie/Importing-products) yet. However, you can partially import product options using CSV files in X-Cart format.  The whole product options importing process can be separated at two steps: - Generate a CSV file with list of options that should be imported. Please, check the [Examples](https://learn.fcrmedia.ie/knowledge/how-can-i-import-product-options#examples) section where it is explained how to get the file for import - Import product options using X-cart format in Control panel → Catalog → Products → "Import products" button → "XCart" tab: ![](https://learn.fcrmedia.ie/hubfs/Knowledge%20Base%20Import/help.shopsettings.comhcen-usarticle_attachments115000036205import_dialog.png) ### Generating a CSV file for the import Currently, it is possible to import the options with **"Drop-down"** and **"Input text"** types using the CSV file with these columns.   ### Examples 1\. **Import "Size" and "Colour" options for the product** and set price modifier for "Size" one. Thus, the CSV file will looks like this: ![](https://learn.fcrmedia.ie/hubfs/Knowledge%20Base%20Import/help.shopsettings.comhcen-usarticle_attachments115000042865import_size.png) You can easily create this file in MS Excel or similar program and save it in CSV format after that.  When this file is imported (see the original file in [Attachment](https://learn.fcrmedia.ie/knowledge/how-can-i-import-product-options#attachment) - import\_options1.csv), products with SKU = Tshirt001 will get new options ("Size" and "Colour"). 2\. **Add "Size" options with price modifier in percentage**. Thus, the CSV file will looks like this:![](https://learn.fcrmedia.ie/hubfs/Knowledge%20Base%20Import/help.shopsettings.comhcen-usarticle_attachments115000044249import_size2.png) When this file is imported (see the original file in [Attachment](https://learn.fcrmedia.ie/knowledge/how-can-i-import-product-options#attachment) - import\_options2.csv), products with SKU = straw002 will get new option "Size" with 50% discount for "Small" variant **NOTE:** Don't forget to set "0" in "Price modifier" field, if the option doesn't affect the price. Empty value is not acceptable for this column. 3\. **Add a text type option "Gift message"** for our products and therefore, we want to use import functionality to add this option for many products at the same time. The CSV file for importing will have the following format: ![](https://learn.fcrmedia.ie/hubfs/Knowledge%20Base%20Import/help.shopsettings.comhcen-usarticle_attachments115000044229import_size3.png) When this file is imported (see the original file in [Attachment](https://learn.fcrmedia.ie/knowledge/how-can-i-import-product-options#attachment) - import\_options3.csv), all products with SKUs = CAR001 - CAR007 will get new "Gift message" option at the same time. 4\. If we need to **import options for several products** described above at the same time, we just put all options description in the same file one under another: ![](https://learn.fcrmedia.ie/hubfs/Knowledge%20Base%20Import/help.shopsettings.comhcen-usarticle_attachments115000042885import_size4.png) When this file is imported (see the original file in [Attachment](https://learn.fcrmedia.ie/knowledge/how-can-i-import-product-options#attachment) - import\_options\_all.csv), all products with SKUs from !PRODUCTCODE column will get corresponding options.  Product options import can be successfully used, when you need to add a lot of similar options to your products in the catalog (It could be sizes, colours, etc.) ### Attachments - [import\_options2.csv](https://help.shopsettings.com/hc/en-us/article_attachments/115000042825/import_options2.csv) - [import\_options1.csv](https://help.shopsettings.com/hc/en-us/article_attachments/115000044189/import_options1.csv) - [import\_options\_all.csv](https://help.shopsettings.com/hc/en-us/article_attachments/115000044209/import_options_all.csv) - [import\_options3.csv](https://help.shopsettings.com/hc/en-us/article_attachments/115000042845/import_options3.csv) \-------------------------- - [Step By Step Setup](https://learn.fcrmedia.ie/knowledge/step-by-step-setup?hsLang=en) - [Store Setting](https://learn.fcrmedia.ie/knowledge/store-setting?hsLang=en#main-content) - [Wordpress](https://learn.fcrmedia.ie/knowledge/store-setting?hsLang=en#wordpress) - [Products](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#main-content) - [Import and export](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#import-and-export) - [Product details](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#product-details) - [Categories](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#categories) - [Images](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#images) - [Managing stock](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#managing-stock) - [Adding products](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#adding-products) - [Digital products and services](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#digital-products-and-services) - [Options and variations](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#options-and-variations) - [Storefront display](https://learn.fcrmedia.ie/knowledge/products?hsLang=en#storefront-display) - [Guest Articles](https://learn.fcrmedia.ie/knowledge/guest-articles?hsLang=en) - [Extras](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#main-content) - [Payments](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#payments) - [Technical References](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#technical-references) - [Promotions](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#promotions) - [Basic Questions](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#basic-questions) - [Sales](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#sales) - [Staff Accounts](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#staff-accounts) - [Shipping](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#shipping) - [Products](https://learn.fcrmedia.ie/knowledge/extras?hsLang=en#products) - [Online sales channels](https://learn.fcrmedia.ie/knowledge/online-sales-channels?hsLang=en#main-content) - [Instant Site](https://learn.fcrmedia.ie/knowledge/online-sales-channels?hsLang=en#instant-site) - [Facebook](https://learn.fcrmedia.ie/knowledge/online-sales-channels?hsLang=en#facebook) - [Amazon](https://learn.fcrmedia.ie/knowledge/online-sales-channels?hsLang=en#amazon) - [Website](https://learn.fcrmedia.ie/knowledge/online-sales-channels?hsLang=en#website) - [Shipping and pickup](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#main-content) - [In-store pickup](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#in-store-pickup) - [Destination zones for shipping](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#destination-zones-for-shipping) - [Setting up shipping](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#setting-up-shipping) - [Shipping methods and rates](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#shipping-methods-and-rates) - [Guide to shipping](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#guide-to-shipping) - [Shipping management](https://learn.fcrmedia.ie/knowledge/shipping-and-pickup?hsLang=en#shipping-management) - [Marketing](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#main-content) - [Guide to marketing](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#guide-to-marketing) - [Social media](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#social-media) - [Advertising on Facebook](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#advertising-on-facebook) - [SEO](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#seo) - [Discounts](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#discounts) - [Sale prices](https://learn.fcrmedia.ie/knowledge/marketing?hsLang=en#sale-prices) - [Payments](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#main-content) - [Chargebacks and inquiries](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#chargebacks-and-inquiries) - [Accepting online payments](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#accepting-online-payments) - [Other online payments](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#other-online-payments) - [Accepting manual (offline) payments](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#accepting-manual-offline-payments) - [Fraud prevention](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#fraud-prevention) - [PayPal](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#paypal) - [Stripe](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#stripe) - [Guide to payments](https://learn.fcrmedia.ie/knowledge/payments?hsLang=en#guide-to-payments) - [Customers](https://learn.fcrmedia.ie/knowledge/customers?hsLang=en#main-content) - [Customer groups](https://learn.fcrmedia.ie/knowledge/customers?hsLang=en#customer-groups) - [Importing and exporting customers](https://learn.fcrmedia.ie/knowledge/customers?hsLang=en#importing-and-exporting-customers) - [Customer management](https://learn.fcrmedia.ie/knowledge/customers?hsLang=en#customer-management) - [Policy Documents For Your Store](https://learn.fcrmedia.ie/knowledge/policy-documents-for-your-store?hsLang=en) - [Orders](https://learn.fcrmedia.ie/knowledge/orders?hsLang=en#main-content) - [Filtering orders](https://learn.fcrmedia.ie/knowledge/orders?hsLang=en#filtering-orders) - [Returns](https://learn.fcrmedia.ie/knowledge/orders?hsLang=en#returns) - [Order notifications](https://learn.fcrmedia.ie/knowledge/orders?hsLang=en#order-notifications) - [Managing orders](https://learn.fcrmedia.ie/knowledge/orders?hsLang=en#managing-orders) - [Recovering abandoned carts](https://learn.fcrmedia.ie/knowledge/orders?hsLang=en#recovering-abandoned-carts) - [Analytics](https://learn.fcrmedia.ie/knowledge/analytics?hsLang=en#main-content) - [Google Analytics](https://learn.fcrmedia.ie/knowledge/analytics?hsLang=en#google-analytics) - [Guide to analytics](https://learn.fcrmedia.ie/knowledge/analytics?hsLang=en#guide-to-analytics) - [Getting reports](https://learn.fcrmedia.ie/knowledge/analytics?hsLang=en#getting-reports) - [Security](https://learn.fcrmedia.ie/knowledge/security?hsLang=en#main-content) - [Account security](https://learn.fcrmedia.ie/knowledge/security?hsLang=en#account-security) - [Phishing](https://learn.fcrmedia.ie/knowledge/security?hsLang=en#phishing) - [HTTPS and SSL](https://learn.fcrmedia.ie/knowledge/security?hsLang=en#https-and-ssl) [![Chill listening crop-3](https://learn.fcrmedia.ie/hs-fs/hubfs/fcr-logo-2019-blue-1k-1.png?width=230&height=24&name=fcr-logo-2019-blue-1k-1.png "Chill listening crop-3")](https://knowledge.gpie.ie/knowledge) Local Search | Web | VR Copyright © 2026, FCR Media