[Skip to main content](#vessel-content) # Setting values for import ## - **[daalouw](/forum/user/813-daalouw "View daalouw's Profile")** - [![daalouw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/813-daalouw "View daalouw's Profile") Topic Author - [ Offline](/forum/user/813-daalouw) Less More - Posts: 12 - Thank you received: 0 - - 15 years 9 months ago [\#5768](#5768) by [daalouw](/forum/user/813-daalouw "View daalouw's Profile") *[Setting values for import](/forum/4-how-to/5768-setting-values-for-import#5768 "I am really struggling to set up my CSV file for import with Business Edition and would appreciate help. I have many products. Each product has a characteristic called "Size". Each characteristic has 3 variants... small, medium and large, each with its own price. My main problem is that I am struggling to set up the prices for my products as the price table (#_hikashop_price) has only 1 column for price_value. The #_hikashop_characteristic and #_hikashop_variant tables do not have a price in them so how do I set up the price for each of my variants? Regards Deon")* was created by *[daalouw](/forum/user/813-daalouw "View daalouw's Profile")* I am really struggling to set up my CSV file for import with Business Edition and would appreciate help. I have many products. Each product has a characteristic called "Size". Each characteristic has 3 variants... small, medium and large, each with its own price. My main problem is that I am struggling to set up the prices for my products as the price table (#_hikashop_price) has only 1 column for price_value. The #_hikashop_characteristic and #_hikashop_variant tables do not have a price in them so how do I set up the price for each of my variants? Regards Deon Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU3Njgtc2V0dGluZy12YWx1ZXMtZm9yLWltcG9ydD90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 15 years 9 months ago [\#5774](#5774) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Setting values for import](/forum/4-how-to/5768-setting-values-for-import#5774 "I am really struggling to set up my CSV file for import with Business Edition and would appreciate help. I have many products. Each product has a characteristic called "Size". Each characteristic has 3 variants... small, medium and large, each with its own price. My main problem is that I am struggling to set up the prices for my products as the price table (#_hikashop_price) has only 1 column for price_value. The #_hikashop_characteristic and #_hikashop_variant tables do not have a price in them so how do I set up the price for each of my variants? Regards Deon")* You can do like this: product_code,product_parent_id,size,price_value main_product,,S,10 variant_1,main_product,S,10 variant_2,main_product,L,12 variant_3,main_product,XL,14 variant_4,main_product,XXL,16 Note that you need to already have the characteristic "size" defined with at least the values S, L, XL and XXL entered for it, otherwise, the system won't be able to import the product in that example. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU3Njgtc2V0dGluZy12YWx1ZXMtZm9yLWltcG9ydD90bXBsPW1hcmtkb3du) 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.060 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)