1. khashiz
  2. RO CSVI
  3. Sunday, 28 December 2025
  4.  Subscribe via email
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
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.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 8 hours ago
  2. RO CSVI
  3. # 1
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
Attachments (2)
  1. 5 hours ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
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
  1. 2 hours ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!