[Skip to main content](#vessel-content) # Update Prices ## - **[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")** - [![khashiz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/61259-khashiz "View khashiz's Profile") Topic Author - [ Offline](/forum/user/61259-khashiz) Less More - Posts: 240 - Thank you received: 13 - - 10 months 2 weeks ago [\#369890](#369890) by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") *[Update Prices](/forum/26-product-category-display/910006-update-prices#369890 "-- HikaShop version -- : 6.1.1 -- Joomla version -- : 6.0.1 -- PHP version -- : 8.3 Hi. i'm trying to update my products prices using an excel file with RO CSVI extension (latest version) when i put a 3 digits number 915 as my new price it work well, but when i put the new number 9150000 it doesnt works and i get this error : Data truncated for column "price_value" i asked this in RO CSVI support and they said : "That character limit is set for price_value field in #__hikashop_price table by HikaShop and is not an RO CSVI issue. Check this field definition in your database." but i see price_value is decimal (17,5) and it should not have problem with this 7 digit number as new price 9150000 can you help me with this ?")* was created by *[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")* -- HikaShop version -- : 6.1.1 -- Joomla version -- : 6.0.1 -- PHP version -- : 8.3 Hi. i'm trying to update my products prices using an excel file with RO CSVI extension (latest version) when i put a 3 digits number 915 as my new price it work well, but when i put the new number 9150000 it doesnt works and i get this error : Data truncated for column "price_value" i asked this in RO CSVI support and they said : "That character limit is set for price_value field in #__hikashop_price table by HikaShop and is not an RO CSVI issue. Check this field definition in your database." but i see price_value is decimal (17,5) and it should not have problem with this 7 digit number as new price 9150000 can you help me with this ? - [ ![2025-12-29_13-22-48.png](/forum/attachment/61093) ](/forum/attachment/61093 "...9_13-22-48.png") [ ](/forum/attachment/61093?download=1 "...9_13-22-48.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MTAwMDYtdXBkYXRlLXByaWNlcz90bXBsPW1hcmtkb3du) 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 - - 10 months 1 week ago [\#369891](#369891) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update Prices](/forum/26-product-category-display/910006-update-prices#369891 "-- HikaShop version -- : 6.1.1 -- Joomla version -- : 6.0.1 -- PHP version -- : 8.3 Hi. i'm trying to update my products prices using an excel file with RO CSVI extension (latest version) when i put a 3 digits number 915 as my new price it work well, but when i put the new number 9150000 it doesnt works and i get this error : Data truncated for column "price_value" i asked this in RO CSVI support and they said : "That character limit is set for price_value field in #__hikashop_price table by HikaShop and is not an RO CSVI issue. Check this field definition in your database." but i see price_value is decimal (17,5) and it should not have problem with this 7 digit number as new price 9150000 can you help me with this ?")* Hi, As you said, the type of the column in the database is 17,5 so that means 12 digits before the decimal and 5 digits after. So, as far as I understand, 9150000 should not be a problem. In fact, you can try to set that price manually in a product in your HikaShop backend or via your PHPMyAdmin and you'll see if it works. If it does, then it means that the explanation provided by RO CSVI is not accurate and there's something else at play here. To me, it points at a bug at RO CSVI, but I didn't look at its code so I wouldn't be able to say for sure. You'll have to talk with them again I'm afraid. The following user(s) said Thank You: [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MTAwMDYtdXBkYXRlLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")** - [![khashiz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/61259-khashiz "View khashiz's Profile") Topic Author - [ Offline](/forum/user/61259-khashiz) Less More - Posts: 240 - Thank you received: 13 - - 10 months 1 week ago [\#369892](#369892) by [khashiz](/forum/user/61259-khashiz "View khashiz's Profile") Replied by *[khashiz](/forum/user/61259-khashiz "View khashiz's Profile")* on topic *[Update Prices](/forum/26-product-category-display/910006-update-prices#369892 "-- HikaShop version -- : 6.1.1 -- Joomla version -- : 6.0.1 -- PHP version -- : 8.3 Hi. i'm trying to update my products prices using an excel file with RO CSVI extension (latest version) when i put a 3 digits number 915 as my new price it work well, but when i put the new number 9150000 it doesnt works and i get this error : Data truncated for column "price_value" i asked this in RO CSVI support and they said : "That character limit is set for price_value field in #__hikashop_price table by HikaShop and is not an RO CSVI issue. Check this field definition in your database." but i see price_value is decimal (17,5) and it should not have problem with this 7 digit number as new price 9150000 can you help me with this ?")* is it possible to do it with HikaShop's own import system ? i have a cvs file which contains product_code and price_value Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MTAwMDYtdXBkYXRlLXByaWNlcz90bXBsPW1hcmtkb3du) 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 - - 10 months 1 week ago [\#369893](#369893) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update Prices](/forum/26-product-category-display/910006-update-prices#369893 "-- HikaShop version -- : 6.1.1 -- Joomla version -- : 6.0.1 -- PHP version -- : 8.3 Hi. i'm trying to update my products prices using an excel file with RO CSVI extension (latest version) when i put a 3 digits number 915 as my new price it work well, but when i put the new number 9150000 it doesnt works and i get this error : Data truncated for column "price_value" i asked this in RO CSVI support and they said : "That character limit is set for price_value field in #__hikashop_price table by HikaShop and is not an RO CSVI issue. Check this field definition in your database." but i see price_value is decimal (17,5) and it should not have problem with this 7 digit number as new price 9150000 can you help me with this ?")* Hi, Yes. You can use a mass action (menu System>Mass actions) with a filter "CSV import" for that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS85MTAwMDYtdXBkYXRlLXByaWNlcz90bXBsPW1hcmtkb3du) 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.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)