[Skip to main content](#vessel-content) # Importing multiple user groups for price\_access ## - **[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile")** - [![yvo_wilms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") Topic Author - [ Offline](/forum/user/37661-yvo-wilms) Less More - Posts: 20 - Thank you received: 0 - - 11 years 4 months ago [\#206350](#206350) by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") *[Importing multiple user groups for price\_access](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206350 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : latest Hi, I'm making an import with a lot of articles (starting out small but it will be large once everything works) Most of those articles have 2 prices and 2 quantities ... price 1-> qty 1, from Qty 2 -> price 2 ... the regular stuff ... HOWEVER, I want price 2 to only be visible to 3 (or 4) user groups ... There is no problem if I want it for 1 user group (I can import price_access as "all|21" where 21 is the id of the user group). However, HOW can I import something like "all|21,13,8"? when I try this some strange things happen to my articles ... products appear in categories they don't belong and translations get all mixed-up ... I tried "all|21|13|8", "all|,21,|,13,|,8,", "all|21,13,8", "all|,21,13,8," ... none of these seem to work ... I usually use ";" as a separator for the fields and "|" as a separator inside the fields ... "," appears in some product names so might not be the best choice as a separator ... I also have access levels defined (Joomla!) with the correct user groups in them ... but how can I select those for import ... it appears only user groups can be selected ...")* was created by *[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile")* -- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : latest Hi, I'm making an import with a lot of articles (starting out small but it will be large once everything works) Most of those articles have 2 prices and 2 quantities ... price 1-> qty 1, from Qty 2 -> price 2 ... the regular stuff ... HOWEVER, I want price 2 to only be visible to 3 (or 4) user groups ... There is no problem if I want it for 1 user group (I can import price_access as "all|21" where 21 is the id of the user group). However, HOW can I import something like "all|21,13,8"? when I try this some strange things happen to my articles ... products appear in categories they don't belong and translations get all mixed-up ... I tried "all|21|13|8", "all|,21,|,13,|,8,", "all|21,13,8", "all|,21,13,8," ... none of these seem to work ... I usually use ";" as a separator for the fields and "|" as a separator inside the fields ... "," appears in some product names so might not be the best choice as a separator ... I also have access levels defined (Joomla!) with the correct user groups in them ... but how can I select those for import ... it appears only user groups can be selected ... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc4MDItaW1wb3J0aW5nLW11bHRpcGxlLXVzZXItZ3JvdXBzLWZvci1wcmljZS1hY2Nlc3M/dG1wbD1tYXJrZG93bg==) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 4 months ago [\#206387](#206387) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing multiple user groups for price\_access](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206387 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : latest Hi, I'm making an import with a lot of articles (starting out small but it will be large once everything works) Most of those articles have 2 prices and 2 quantities ... price 1-> qty 1, from Qty 2 -> price 2 ... the regular stuff ... HOWEVER, I want price 2 to only be visible to 3 (or 4) user groups ... There is no problem if I want it for 1 user group (I can import price_access as "all|21" where 21 is the id of the user group). However, HOW can I import something like "all|21,13,8"? when I try this some strange things happen to my articles ... products appear in categories they don't belong and translations get all mixed-up ... I tried "all|21|13|8", "all|,21,|,13,|,8,", "all|21,13,8", "all|,21,13,8," ... none of these seem to work ... I usually use ";" as a separator for the fields and "|" as a separator inside the fields ... "," appears in some product names so might not be the best choice as a separator ... I also have access levels defined (Joomla!) with the correct user groups in them ... but how can I select those for import ... it appears only user groups can be selected ...")* Hi, This writing style should work for the price_access column: "all|,21,13,8," Configure one product like you want and then export it by selecting it on the products listing and then clicking on the "export" button. Then, simply check the price_access column of the resulting CSV and that's what you want to use for the import. The following user(s) said Thank You: [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc4MDItaW1wb3J0aW5nLW11bHRpcGxlLXVzZXItZ3JvdXBzLWZvci1wcmljZS1hY2Nlc3M/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile")** - [![yvo_wilms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") Topic Author - [ Offline](/forum/user/37661-yvo-wilms) Less More - Posts: 20 - Thank you received: 0 - - 11 years 3 months ago [\#206702](#206702) by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") Replied by *[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile")* on topic *[Importing multiple user groups for price\_access](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : latest Hi, I'm making an import with a lot of articles (starting out small but it will be large once everything works) Most of those articles have 2 prices and 2 quantities ... price 1-> qty 1, from Qty 2 -> price 2 ... the regular stuff ... HOWEVER, I want price 2 to only be visible to 3 (or 4) user groups ... There is no problem if I want it for 1 user group (I can import price_access as "all|21" where 21 is the id of the user group). However, HOW can I import something like "all|21,13,8"? when I try this some strange things happen to my articles ... products appear in categories they don't belong and translations get all mixed-up ... I tried "all|21|13|8", "all|,21,|,13,|,8,", "all|21,13,8", "all|,21,13,8," ... none of these seem to work ... I usually use ";" as a separator for the fields and "|" as a separator inside the fields ... "," appears in some product names so might not be the best choice as a separator ... I also have access levels defined (Joomla!) with the correct user groups in them ... but how can I select those for import ... it appears only user groups can be selected ...")* It seems that one does work ... thanks ... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc4MDItaW1wb3J0aW5nLW11bHRpcGxlLXVzZXItZ3JvdXBzLWZvci1wcmljZS1hY2Nlc3M/dG1wbD1tYXJrZG93bg==) 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.174 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)