[Skip to main content](#vessel-content) # Write my own CSV file ## - **[holm76](/forum/user/9743-holm76 "View holm76's Profile")** - [![holm76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9743-holm76 "View holm76's Profile") Topic Author - [ Offline](/forum/user/9743-holm76) Less More - Posts: 152 - Thank you received: 11 - - - - 14 years 1 month ago [\#68238](#68238) by [holm76](/forum/user/9743-holm76 "View holm76's Profile") *[Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#68238 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* was created by *[holm76](/forum/user/9743-holm76 "View holm76's Profile")* Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend --- I'm using firebug, forumsearch, dokumentation and then I ask.. It's so easy ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 14 years 1 month ago [\#68261](#68261) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#68261 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Hi, I think that you can : - Create a product with variants - Export your products - Use this CSV structure Hope this will help you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[holm76](/forum/user/9743-holm76 "View holm76's Profile")** - [![holm76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9743-holm76 "View holm76's Profile") Topic Author - [ Offline](/forum/user/9743-holm76) Less More - Posts: 152 - Thank you received: 11 - - - - 14 years 1 month ago [\#68583](#68583) by [holm76](/forum/user/9743-holm76 "View holm76's Profile") Replied by *[holm76](/forum/user/9743-holm76 "View holm76's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#68583 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Hey Thx, I agree about this, but our catalog have so many numbers, so its easyer to go the other way and make it from an existing xls file and definde the columns by my self > Mohamed Thelji wrote: Hi, > > I think that you can : > \- Create a product with variants > \- Export your products > \- Use this CSV structure > > Hope this will help you. --- I'm using firebug, forumsearch, dokumentation and then I ask.. It's so easy ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 1 month ago [\#68691](#68691) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#68691 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Then I would recommend you to read the documentation of the CSV import: [ www.hikashop.com/en/support/documentatio...hikashop-import.html](http://www.hikashop.com/en/support/documentation/73-hikashop-import.html) It explains how you can handle characteristics/variants in CSVs. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[holm76](/forum/user/9743-holm76 "View holm76's Profile")** - [![holm76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9743-holm76 "View holm76's Profile") Topic Author - [ Offline](/forum/user/9743-holm76) Less More - Posts: 152 - Thank you received: 11 - - - - 14 years 1 month ago [\#68747](#68747) by [holm76](/forum/user/9743-holm76 "View holm76's Profile") Replied by *[holm76](/forum/user/9743-holm76 "View holm76's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#68747 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* I will try to read it again. I have also tried to create some products manually, and then exporting the csv file, and then write some new products in it.. THat works, but some of the variants on another products where deletet, after that and the prices where set together.. Another question: When I have exportet the csv file the price are like this: 67.040.000, but it have to be 6.704,00 - how do we insert the right price? is it just to overwrite it, but if the price not is edit, it will stand like in the csv file on the shop? --- I'm using firebug, forumsearch, dokumentation and then I ask.. It's so easy ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 1 month ago [\#68922](#68922) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#68922 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Make sure that you change the product_code values and remove the product_id column when you insert new products based on previous products. Otherwise, if HikaShop finds a match for a product/variant, it will update its information instead of creating a new product/variant. Prices are added to the CSV as they are stored in the database. We allow for a lot of decimals as some users need it. So the exported prices should look like this: 67040.00000 In any case, in your CSV, just enter the price with one dot or one comma for the decimal separation and no other separation and it will work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[holm76](/forum/user/9743-holm76 "View holm76's Profile")** - [![holm76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9743-holm76 "View holm76's Profile") Topic Author - [ Offline](/forum/user/9743-holm76) Less More - Posts: 152 - Thank you received: 11 - - - - 14 years 1 month ago [\#69104](#69104) by [holm76](/forum/user/9743-holm76 "View holm76's Profile") Replied by *[holm76](/forum/user/9743-holm76 "View holm76's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#69104 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Thanks for the reply. However, we still have a problem I hope You can help us to solve When we have to adjust the prices there are as I see it 3 options: 1 make the update manual, which will take time because we have a lot of items. 2 to create the products again and again, just as there are customer groups 3 make it in a csv file which we intend. But since we have several customer groups, it is not possible to make it simple in/with excel, where we have the datas. As the price structure in csv file is right now, are the prices like: price | price | price, theís option can’t we use in excel while its not are so in our own system. Therefore, we will be glad whether there is any potential for an easy way to update prices depending on the customer groups. --- I'm using firebug, forumsearch, dokumentation and then I ask.. It's so easy ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 1 month ago [\#69219](#69219) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#69219 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* It's quite easy to update prices for several user groups via CSV import. You can use such CSV: product_code,price_value,price_access my_prod1,10;12,12:5 That will configure two prices for the product "my_prod1". One price at 10 for the user group with the id 12 and one price at 12 for the user group with the id 5. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[holm76](/forum/user/9743-holm76 "View holm76's Profile")** - [![holm76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9743-holm76 "View holm76's Profile") Topic Author - [ Offline](/forum/user/9743-holm76) Less More - Posts: 152 - Thank you received: 11 - - - - 14 years 1 month ago [\#69249](#69249) by [holm76](/forum/user/9743-holm76 "View holm76's Profile") Replied by *[holm76](/forum/user/9743-holm76 "View holm76's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#69249 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Yes I know that, but the problem is to copy-paste from the main pricelist, there is it not separated with , or ;. But its only in a column. --- I'm using firebug, forumsearch, dokumentation and then I ask.. It's so easy ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 1 month ago [\#69342](#69342) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#69342 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* Well, each ecommerce software has its own CSV format and there is no standard on that. Same for payment platforms. I don't have a magic bullet for you. Either you generate the CSV like HikaShop wants (maybe with some Excel macro, you could do it based on the CSV of your other system) or you add that directly with a custom script in the database (more work than option 1 I think), or you use the interface and enter everything by hand. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[holm76](/forum/user/9743-holm76 "View holm76's Profile")** - [![holm76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9743-holm76 "View holm76's Profile") Topic Author - [ Offline](/forum/user/9743-holm76) Less More - Posts: 152 - Thank you received: 11 - - - - 14 years 1 month ago [\#69421](#69421) by [holm76](/forum/user/9743-holm76 "View holm76's Profile") Replied by *[holm76](/forum/user/9743-holm76 "View holm76's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#69421 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* I have found a solution In one column in excel I insert price1 in the next a | 3. price2 and a | etc The same do I with the access levels After that I let excel merged them with =column1&column2&solumn3&... etc, now its in one cell and the csv is imported correct ![:)](/media/kunena/emoticons/3.png ":)") --- I'm using firebug, forumsearch, dokumentation and then I ask.. It's so easy ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 1 month ago [\#69558](#69558) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Write my own CSV file](/forum/2-general-talk-about-hikashop/68238-write-my-own-csv-file#69558 "Hello I have a little question In my firm we are making a shop, where there have to be a lot of specified prices on the same produkt. In the future we would like to update the prices from a xls file where we will define the different columns by our self. But how do I define the product variants? I have tried product_variant and variant with the variant number, but it not showing in the product in backend")* That's great ! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzY4MjM4LXdyaXRlLW15LW93bi1jc3YtZmlsZT90bXBsPW1hcmtkb3du) 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.082 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)