Categories
View Replies (3)

Resolved Import prices virtuemart

  1. Anonymous User
  2. RO CSVI
  3. Monday, 25 May 2026
  4.  Subscribe via email
I'm trying to import prices from csv to virtuemart

CSV file content:
virtuemart_product_id product_price product_currency virtuemart_shoppergroup_id modified_on
141549 369600 RUB 8 1779368322

When I start it up it says: Price Skipped 1. Message "Missing required fields"

The log ends like this: [QUERY] SELECT `virtuemart_currency_id` FROM `dpelq_virtuemart_currencies` WHERE `currency_code_3` = 'RUB' AND `virtuemart_vendor_id` = 1

If you run this query in the database, the result is: it finds one row with the value virtuemart_currency_id = 131

What's the problem?
Attachments (1)
com_csvi.log.20.zip
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
product_sku is required field in VirtueMart Price import so using virtuemart_product_id is not going to help. The reason we do not support fields ending _id is that these fields are primary key fields of database tables and so should let database handle it.

But using VirtueMart product import template you can update price using virtuemart_product_id. To do that in VirtueMart Product import template on Options tab set Import based on field to virtuemart_product_id and save the template. This setting will update products and its price based on virtuemart_product_id.

Now there are two things with this import

1. You are using virtuemart_shoppergroup_id field in CSV for shopper group you should use shopper_group_name field instead. RO CSVI will find the shopper group ID based on name on import and update the price.
2. Using VirtueMart Product import you can update only the first product price record. I mean If a product has multiple prices then VirtueMart Product import will update the first price record. You can update multiple prices only by using VirtueMart Price import.

Let me know if this helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
tooler
tooler
Accepted Answer Pending Moderation
I need virtuemart_product_id. Product_sku is not used in my database.
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
When I start it up it says: Price Skipped 1. Message "Missing required fields"

You are missing product_sku field in CSV content and so the error. Instead of using virtuemart_product_id field use product_sku and run the import. See if that solves your issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks 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!