Categories
View Replies (9)

Resolved export product_price, each product has 3 export only gives one

  1. Helmut
    Helmut
  2. RO CSVI
  3. Saturday, 07 March 2020
  4.  Subscribe via email
Hello, in Virtuemart our products have each 3 prices for different user groups. If we export virtuemart_product_id and product_price we only get one price per product.
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
IMPORT Fields
shopper_group_name_new
shopper_group_name
virtuemart_shoppergroup_id
virtuemart_product_id
product_price

We do not recommend use of fields ending with _id. They are primary key fields of database and it has to be handled by database itself. In your import fields you can use product_sku field instead of virtuemart_product_id and you don't need virtuemart_shoppergroup_id as you have shopper_group_name field. RO CSVI will find the id values based on product_sku and shopper_group_name fields. You also need product_currency field in your import. Do these changes and run the import. If you still have problem, post the import debug log along with your import file to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (9)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I guess you are now using VirtueMart Product export to export the price. For exporting multiple prices for a product you should use VirtueMart Price export operation.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Helmut
Helmut
Accepted Answer Pending Moderation
Thank you, got it, now I do export shopper_group_id, product_id and price and I do get multiple prices. However If I create the same template for import, only one price is imported.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you post the debug log of the import to check? To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Helmut
Helmut
Accepted Answer Pending Moderation
thank you for yo response, log file attached.
Attachments (1)
com_csvi.log.300.txt
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
To update VirtueMart Product price, RO CSVI needs few required field on import. RO CSVI uses needed field to select a record from database, If a record with these matching field values are found then the existing row is updated else a new row is inserted. These needed fields are explained in Virtuemart Prices Import document. Since these fields are missing in your import, prices are not updated. You need to add these needed fields to your import file.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Helmut
Helmut
Accepted Answer Pending Moderation
I have the import field the same as the export fields, the export works but the import does not, what field am I missing?

EXPORT Fields:
virtuemart_shoppergroup_id
shopper_group_name
virtuemart_product_id
product_price

IMPORT Fields
shopper_group_name_new
shopper_group_name
virtuemart_shoppergroup_id
virtuemart_product_id
product_price
  1. more than a month ago
  2. RO CSVI
  3. # 6
Helmut
Helmut
Accepted Answer Pending Moderation
Love the Support, it now works, thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Glad to know that your import works :)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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