Categories
View Replies (5)

Resolved import updated virtuemart products

  1. pascal_pasvorm
    pascal_pasvorm
  2. RO CSVI
  3. Monday, 13 December 2021
  4.  Subscribe via email
Hi, I have lots of virtuemart products which need to be updated (manufacturers, description, ....)
For import I use product_sku and updated/modified fields.
I noticed after update the product Id's are newly created, is this correct?
And is this the right way to update/modify existing products?

Regards,
Pas
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Pas,
I thought the ID's in virtuemart were updated with new id in products view.
But I did not check the product sku, so sorry guess it's all fine.

No problem. We are happy to help with your queries.

So this is the best way to import updated/modified products?

Yes, using product_sku field you can update/modify existing products. If the product_sku value does not exists, a new product is created on import.
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
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hmmm I see my mistake...
I thought the ID's in virtuemart were updated with new id in products view.
But I did not check the product sku, so sorry guess it's all fine.
So this is the best way to import updated/modified products?

Regards,
Pas
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Pas,
Thank you for sending the debug log. As per the debug log you have imported two products and it shows that existing rows has been updated for both the products. No new product IDs are created. Can you tell me where you see the new product IDs? Please share a screenshot of it.
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
Anonymous User
Accepted Answer Pending Moderation
Hi Tharuna,
Here's the log file.

Regards,
Pas
Attachments (1)
com_csvi.log.8.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Pas,
And is this the right way to update/modify existing products?

No, the IDs should not change. If the product is updated then the existing row in database should be updated/modify which also means IDs stays the same. Please send the import debug log 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. # 5
  • Page :
  • 1


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