Categories
View Replies (22)

Resolved Import Issue: virtuemart_products table is not populating

  1. oogloo
    oogloo
  2. RO CSVI
  3. Monday, 06 March 2017
  4.  Subscribe via email
Hi RolandD -

I am trying to import products, the process just runs fine and import records in virtuemart_products_en_gb, also in prices, categories etc tables. However, nothing is imported in virtuemart_products table. I have checked the log and there is no INSERT query for virtuemart_products but multiple update_queries exist.

Attached is a sample of file i am trying to import, and the log file and below are the versions. (both in one .zip file)

Joomla: 3.6.5
Virtuemart: 3.0.18
CSVI Pro: 7.0.2

Please let me know if I am missing anything or if there is some issue with this.

thanks and best regards,
Syed
0
Responses (22)
oogloo
oogloo
Accepted Answer Pending Moderation
Thanks Tharuna -

I will do that and will get back to you with the updates.

thanks much.
  1. more than a month ago
  2. RO CSVI
  3. # 21
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Syed,
There is an update query running for virtuemart_products table as per your debug log and that is because of virtuemart_product_id field in your import file. Using the fields ending with _id will only do the update of records as it says that the record is already there in the database tables. CSVI imports products based on product_sku field so you can removed the virtuemart_product_id from your import file and then run the 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. # 22
  • Page :
  • 1
  • 2


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