[Skip to main content](#vessel-content) # export import article ## - **[guido](/forum/user/4278-guido "View guido's Profile")** - [![guido's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4278-guido "View guido's Profile") Topic Author - [ Offline](/forum/user/4278-guido) Less More - Posts: 48 - Thank you received: 0 - - 14 years 7 months ago [\#43626](#43626) by [guido](/forum/user/4278-guido "View guido's Profile") *[export import article](/forum/3-bug-report/43626-export-import-article#43626 "I did put this question also in general ..... But i thought it would be better to put it in here. Hello, When i do an export of the articles, i see a column price_value. I have everything in euro. In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro. And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro. With regards, Guido")* was created by *[guido](/forum/user/4278-guido "View guido's Profile")* *This attachment is hidden for guests. Please log in or register to see it.* I did put this question also in general ..... But i thought it would be better to put it in here. Hello, When i do an export of the articles, i see a column price_value. I have everything in euro. In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro. And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro. With regards, Guido Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzYyNi1leHBvcnQtaW1wb3J0LWFydGljbGU/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 14 years 7 months ago [\#43628](#43628) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: export import article](/forum/3-bug-report/43626-export-import-article#43628 "I did put this question also in general ..... But i thought it would be better to put it in here. Hello, When i do an export of the articles, i see a column price_value. I have everything in euro. In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro. And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro. With regards, Guido")* I opened your CSV file on my end and the price is 4 not 400. It must come from a problem with your CSV editor. I'm using libreoffice's calc on my end and the price is fine. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzYyNi1leHBvcnQtaW1wb3J0LWFydGljbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[guido](/forum/user/4278-guido "View guido's Profile")** - [![guido's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4278-guido "View guido's Profile") Topic Author - [ Offline](/forum/user/4278-guido) Less More - Posts: 48 - Thank you received: 0 - - 14 years 7 months ago - 14 years 7 months ago [\#43630](#43630) by [guido](/forum/user/4278-guido "View guido's Profile") Replied by *[guido](/forum/user/4278-guido "View guido's Profile")* on topic *[Re: export import article](/forum/3-bug-report/43626-export-import-article#43630 "I did put this question also in general ..... But i thought it would be better to put it in here. Hello, When i do an export of the articles, i see a column price_value. I have everything in euro. In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro. And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro. With regards, Guido")* [ ![hikashopexport.csv-withLibreOfficeCalc_2012-03-18_17-17-28.jpg](/forum/attachment/3141) ](/forum/attachment/3141 "...8_17-17-28.jpg") [ ![MicrosoftExcel-Map1_2012-03-18_17-18-24.jpg](/forum/attachment/3140) ](/forum/attachment/3140 "...8_17-18-24.jpg") Nicolas, You're right. I attach both files, one with librecalc and one with excel. Strange that they behave different, i will use librecalc for the export and import from now. With regards, Guido - [ ![MicrosoftExcel-Map1_2012-03-18_17-18-24.jpg](/forum/attachment/3140) ](/forum/attachment/3140 "...8_17-18-24.jpg") [ ](/forum/attachment/3140?download=1 "...8_17-18-24.jpg") - [ ![hikashopexport.csv-withLibreOfficeCalc_2012-03-18_17-17-28.jpg](/forum/attachment/3141) ](/forum/attachment/3141 "...8_17-17-28.jpg") [ ](/forum/attachment/3141?download=1 "...8_17-17-28.jpg") Last edit: 14 years 7 months ago by [guido](/forum/user/4278-guido "View guido's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzYyNi1leHBvcnQtaW1wb3J0LWFydGljbGU/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 14 years 7 months ago [\#43633](#43633) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: export import article](/forum/3-bug-report/43626-export-import-article#43633 "I did put this question also in general ..... But i thought it would be better to put it in here. Hello, When i do an export of the articles, i see a column price_value. I have everything in euro. In the backend of an article i did put the price of 4, in the export i see 400.000 , am i mising something. Whem i look at the article it is 4 euro. And when i try an import and change 400.000 to 600.000 the price of that article is 600 euro, it should be 6 euro. With regards, Guido")* That's strange as we also tested it with excel and other users are using excel too. Not sure why though but it if works with calc it must be something coming from excel. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MzYyNi1leHBvcnQtaW1wb3J0LWFydGljbGU/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.054 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)