[Skip to main content](#vessel-content) # Importing csv with multiple prices ## - **[rndm](/forum/user/40094-rndm "View rndm's Profile")** - [![rndm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40094-rndm "View rndm's Profile") Topic Author - [ Offline](/forum/user/40094-rndm) Less More - Posts: 40 - Thank you received: 1 - - 9 years 5 months ago [\#270689](#270689) by [rndm](/forum/user/40094-rndm "View rndm's Profile") *[Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270689 "-- HikaShop version -- : HikaShop Business 3.1.0 Hello! I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1. The only way I found to get it when importing csv was to make two lines for this product like that: product_code|product_name|price_value|price_access p-br-1|Bread|100|all p-br-1|Bread|70|,10, And it looks like everything is ok. The question is: is this way of importing right? Documentation says: "You never need or should have more than one line of information per product in your CSV".")* was created by *[rndm](/forum/user/40094-rndm "View rndm's Profile")* -- HikaShop version -- : HikaShop Business 3.1.0 Hello! I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1. The only way I found to get it when importing csv was to make two lines for this product like that: product_code|product_name|price_value|price_access p-br-1|Bread|100|all p-br-1|Bread|70|,10, And it looks like everything is ok. The question is: is this way of importing right? Documentation [ here](https://www.hikashop.com/support/documentation/73-hikashop-import.html) says: "You never need or should have more than one line of information per product in your CSV". - [ ![pic1_2017-05-31.jpg](/forum/attachment/38388) ](/forum/attachment/38388 "...2017-05-31.jpg") [ ](/forum/attachment/38388?download=1 "...2017-05-31.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA0NjktaW1wb3J0aW5nLWNzdi13aXRoLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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: 86358 - Thank you received: 14293 - - 9 years 5 months ago [\#270696](#270696) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270696 "-- HikaShop version -- : HikaShop Business 3.1.0 Hello! I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1. The only way I found to get it when importing csv was to make two lines for this product like that: product_code|product_name|price_value|price_access p-br-1|Bread|100|all p-br-1|Bread|70|,10, And it looks like everything is ok. The question is: is this way of importing right? Documentation says: "You never need or should have more than one line of information per product in your CSV".")* Hi, That's indeed not correct. I would rather recommend doing like that: Code: product_code;product_name;price_value;price_access p-br-1;Bread;100|70;all|,10, The following user(s) said Thank You: [rndm](/forum/user/40094-rndm "View rndm's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA0NjktaW1wb3J0aW5nLWNzdi13aXRoLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rndm](/forum/user/40094-rndm "View rndm's Profile")** - [![rndm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40094-rndm "View rndm's Profile") Topic Author - [ Offline](/forum/user/40094-rndm) Less More - Posts: 40 - Thank you received: 1 - - 9 years 5 months ago [\#270723](#270723) by [rndm](/forum/user/40094-rndm "View rndm's Profile") Replied by *[rndm](/forum/user/40094-rndm "View rndm's Profile")* on topic *[Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270723 "-- HikaShop version -- : HikaShop Business 3.1.0 Hello! I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1. The only way I found to get it when importing csv was to make two lines for this product like that: product_code|product_name|price_value|price_access p-br-1|Bread|100|all p-br-1|Bread|70|,10, And it looks like everything is ok. The question is: is this way of importing right? Documentation says: "You never need or should have more than one line of information per product in your CSV".")* For some reason I can't use ; as a delimeter. Will this be fine? product_code|product_name|price_value|price_access p-br-1|Bread|100;70|all;,10, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA0NjktaW1wb3J0aW5nLWNzdi13aXRoLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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: 86358 - Thank you received: 14293 - - 9 years 5 months ago [\#270737](#270737) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270737 "-- HikaShop version -- : HikaShop Business 3.1.0 Hello! I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1. The only way I found to get it when importing csv was to make two lines for this product like that: product_code|product_name|price_value|price_access p-br-1|Bread|100|all p-br-1|Bread|70|,10, And it looks like everything is ok. The question is: is this way of importing right? Documentation says: "You never need or should have more than one line of information per product in your CSV".")* Hi, No, the multiple prices values have to be separated by a pipe. However, the main separator of the file can be either , or ; or \t or | Note that you can also use double quotes around the values of the cells of the CSV so that you can use the same delimiter for the prices and the main separator. The following user(s) said Thank You: [rndm](/forum/user/40094-rndm "View rndm's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA0NjktaW1wb3J0aW5nLWNzdi13aXRoLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rndm](/forum/user/40094-rndm "View rndm's Profile")** - [![rndm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40094-rndm "View rndm's Profile") Topic Author - [ Offline](/forum/user/40094-rndm) Less More - Posts: 40 - Thank you received: 1 - - 9 years 5 months ago [\#270784](#270784) by [rndm](/forum/user/40094-rndm "View rndm's Profile") Replied by *[rndm](/forum/user/40094-rndm "View rndm's Profile")* on topic *[Importing csv with multiple prices](/forum/37-import-export-csv-xls/890469-importing-csv-with-multiple-prices#270784 "-- HikaShop version -- : HikaShop Business 3.1.0 Hello! I'm trying to import products with multiple prices (different user groups should have their own prices). Here is an example of a result I want to get - see pic 1. The only way I found to get it when importing csv was to make two lines for this product like that: product_code|product_name|price_value|price_access p-br-1|Bread|100|all p-br-1|Bread|70|,10, And it looks like everything is ok. The question is: is this way of importing right? Documentation says: "You never need or should have more than one line of information per product in your CSV".")* Thanks! I should have thought about double quotes... I'll try it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84OTA0NjktaW1wb3J0aW5nLWNzdi13aXRoLW11bHRpcGxlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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.084 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)