Hi. i want to update HikaShop product prices with excel file
i have a file which first column is product code and second column is my new prices
i tried to update the prices with tutorials on the website but it didnt worked
- khashiz
- RO CSVI
- Sunday, 28 December 2025
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello,
You need to give us little more details on your import so we can check what went wrong. Post the import debug log to check. To get the debug log read How to collect debug information? document. Also post sample of import file used.
You need to give us little more details on your import so we can check what went wrong. Post the import debug log to check. To get the debug log read How to collect debug information? document. Also post sample of import file used.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
i have two problems :
1st.
I noticed that for updating price, i have to specify both current price and new price in csv file in column price_value and price_value_new
however
in my new csv file, i do not have old prices, i only have product code and updated price
2nd
when i deleted the current price and reupload the file, price is added to the product without any problem, however, it seems there is a limit on characters count of the price,
when put 500 as the new price it works, but when i put 9150000 it gives the following error
1st.
I noticed that for updating price, i have to specify both current price and new price in csv file in column price_value and price_value_new
however
in my new csv file, i do not have old prices, i only have product code and updated price
2nd
when i deleted the current price and reupload the file, price is added to the product without any problem, however, it seems there is a limit on characters count of the price,
when put 500 as the new price it works, but when i put 9150000 it gives the following error
Attachments (2)
Accepted Answer
Pending Moderation
Hello,
In RO CSVI 9.2.0 version we added a feature to detect if a product in HikaShop has a single price or multiple prices. If a product has single price then price_value with new price is enough to update existing price. But if a product has multiple price then it needs price_value and price_value_new fields. That is because RO CSVI has to find matching row in database to update the price. I see you are using RO CSVI 9.0.1 version, please update to latest RO CSVI 9.3.0 version to get this feature. If your HikaShop product has single price then updating to RO CSVI 9.3.0 and running import with price_value field with new price should solve your issue.
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.
1st.
I noticed that for updating price, i have to specify both current price and new price in csv file in column price_value and price_value_new
however
in my new csv file, i do not have old prices, i only have product code and updated price
In RO CSVI 9.2.0 version we added a feature to detect if a product in HikaShop has a single price or multiple prices. If a product has single price then price_value with new price is enough to update existing price. But if a product has multiple price then it needs price_value and price_value_new fields. That is because RO CSVI has to find matching row in database to update the price. I see you are using RO CSVI 9.0.1 version, please update to latest RO CSVI 9.3.0 version to get this feature. If your HikaShop product has single price then updating to RO CSVI 9.3.0 and running import with price_value field with new price should solve your issue.
2nd
when i deleted the current price and reupload the file, price is added to the product without any problem, however, it seems there is a limit on characters count of the price,
when put 500 as the new price it works, but when i put 9150000 it gives the following error
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.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »