[Skip to main content](#vessel-content) # Importing variants ## - **[trogladyte](/forum/user/2197-trogladyte "View trogladyte's Profile")** - [![trogladyte's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2197-trogladyte "View trogladyte's Profile") Topic Author - [ Offline](/forum/user/2197-trogladyte) Less More - Posts: 279 - Thank you received: 1 - - 9 years 3 months ago [\#274045](#274045) by [trogladyte](/forum/user/2197-trogladyte "View trogladyte's Profile") *[Importing variants](/forum/37-import-export-csv-xls/891149-importing-variants#274045 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.3 -- Error-message(debug-mod must be tuned on) -- : None I've gone through and added all the characteristics. Now I'm working on the CSV file. I know I need the product_parent_code (for which product the variants are attached to), the product code (the final product code after variants are selected), and the product_type (main or variant) as a minimum. Then I have columns for every variant (and there's a lot!). However, some variants have an extra cost associated with them. I'm not sure of the column heading for this. I added a variant with extra cost to one product, then looked in the database in the variants table but there was nothing there. Can someone tell me what column heading the price increase should have? Thanks.")* was created by *[trogladyte](/forum/user/2197-trogladyte "View trogladyte's Profile")* -- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.3 -- Error-message(debug-mod must be tuned on) -- : None I've gone through and added all the characteristics. Now I'm working on the CSV file. I know I need the product_parent_code (for which product the variants are attached to), the product code (the final product code after variants are selected), and the product_type (main or variant) as a minimum. Then I have columns for every variant (and there's a lot!). However, some variants have an extra cost associated with them. I'm not sure of the column heading for this. I added a variant with extra cost to one product, then looked in the database in the variants table but there was nothing there. Can someone tell me what column heading the price increase should have? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTExNDktaW1wb3J0aW5nLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 9 years 3 months ago [\#274053](#274053) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing variants](/forum/37-import-export-csv-xls/891149-importing-variants#274053 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.3 -- Error-message(debug-mod must be tuned on) -- : None I've gone through and added all the characteristics. Now I'm working on the CSV file. I know I need the product_parent_code (for which product the variants are attached to), the product code (the final product code after variants are selected), and the product_type (main or variant) as a minimum. Then I have columns for every variant (and there's a lot!). However, some variants have an extra cost associated with them. I'm not sure of the column heading for this. I added a variant with extra cost to one product, then looked in the database in the variants table but there was nothing there. Can someone tell me what column heading the price increase should have? Thanks.")* Hi, It's the column "price_value" you want to use. I would recommend to create first a product like you want in your backend, then click on the "export" button of the products listing after checking the checkbox of that product so that you would get a CSV that you can base yourself on for how to create your own CSV. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTExNDktaW1wb3J0aW5nLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[trogladyte](/forum/user/2197-trogladyte "View trogladyte's Profile")** - [![trogladyte's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2197-trogladyte "View trogladyte's Profile") Topic Author - [ Offline](/forum/user/2197-trogladyte) Less More - Posts: 279 - Thank you received: 1 - - 9 years 3 months ago [\#274061](#274061) by [trogladyte](/forum/user/2197-trogladyte "View trogladyte's Profile") Replied by *[trogladyte](/forum/user/2197-trogladyte "View trogladyte's Profile")* on topic *[Importing variants](/forum/37-import-export-csv-xls/891149-importing-variants#274061 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.3 -- Error-message(debug-mod must be tuned on) -- : None I've gone through and added all the characteristics. Now I'm working on the CSV file. I know I need the product_parent_code (for which product the variants are attached to), the product code (the final product code after variants are selected), and the product_type (main or variant) as a minimum. Then I have columns for every variant (and there's a lot!). However, some variants have an extra cost associated with them. I'm not sure of the column heading for this. I added a variant with extra cost to one product, then looked in the database in the variants table but there was nothing there. Can someone tell me what column heading the price increase should have? Thanks.")* Thank you. I didn't know if it used the same as the main product. Will use your export suggestion! ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTExNDktaW1wb3J0aW5nLXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.053 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)