1. Anonymous User
  2. RO CSVI
  3. Friday, 05 February 2021
  4.  Subscribe via email
I need to update VirtueMart products based on product_name (add sku and gtin to existing products)
I created a template but it does not work, because "Row cannot be loaded. Error: Missing field in database: VirtueMartTableProduct product_name. "
I've attached the log file
Could you please check this?
Attachments (1)
Accepted Answer
Accepted Answer Pending Moderation
Hello,
I need to update VirtueMart products based on product_name (add sku and gtin to existing products)

Instead of product_name field use virtuemart_product_id field to update SKU and GTIN fields. The reason is that product_name field does not belong to #__virtuemart_products table and import based on field supports only fields from #__virtuemart_products table.


I created a template but it does not work, because "Row cannot be loaded. Error: Missing field in database: VirtueMartTableProduct product_name. "

This error is because the field product_name does not belong to #__virtuemart_products table but it is from #__virtuemart_product_XX_XX (XX_XX is the language) language table.
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
Accepted Answer Pending Moderation
Hi

Thank you for your reply.
I don't have virtuemart_product_id/sku etc, the remote system provides only product_name.
I know it's not in the products table, so for this time I created my own script to update, this was just a notice maybe there are other users who want to import based on this field.
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


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