Categories
View Replies (41)

Resolved Virtuemart Prices import - Huge problem

  1. roderic
    roderic
  2. RO CSVI
  3. Sunday, 16 January 2022
  4.  Subscribe via email
Hello,

I have 5 templates (attached) to import prices and discounted prices. These are imported every night and usually works like expected. There have been a few times, and it seems to occur more often recently, that the discounted price of product X also gets added to Product Y. The product that gets the price from the other product, is one row below in the XML file. This has lead to 2 orders of products with a price of around 100 euro for a product that's actually about 6000 euro and one that was 1700 euro. This of course is a big issue. As soon as we've seen problems like this, I've manually run the 5 templates and then the price was normal again.

Today however I also had this problem after manually importing and thus I have the corresponding log file. I've attached this logfile (log.1703) and if you look for:
virtuemart_product_id` = 366

You will find the product that got the wrong price (101.2500). This price belongs to virtuemart_product_id` = 5896

As you can see in the logfile, this product is being dealt with just before the other one. The product with ID 366 should be skipped with this template. That's what happened when I ran the same import again.

Could it be that sometimes the import is still working on one product and it already starts with the next product but then these values get mixed up?

The XML file is also attached.
Attachments (3)
com_csvi.log.1703.rar
csvi_templates_www.woest-sport.nl_20220116.xml
Products.rar
0
Responses (41)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Roderic,
Today however I also had this problem after manually importing and thus I have the corresponding log file. I've attached this logfile (log.1703) and if you look for:
virtuemart_product_id` = 366

You will find the product that got the wrong price (101.2500). This price belongs to virtuemart_product_id` = 5896

As you can see in the logfile, this product is being dealt with just before the other one. The product with ID 366 should be skipped with this template. That's what happened when I ran the same import again.

The difference i see is that product with ID 366 and ID 5896 is that ID 366 product does not have node ActionPrices/ActionPrice to get product_override_price. I am still looking into this issue. Will update you with my findings.


Could it be that sometimes the import is still working on one product and it already starts with the next product but then these values get mixed up?

If you look at the debug log you can see that line number are mixed up. When the line number 181 is processed the log for line number 182 is entered with line number 181. You can see that happening all over the import debug log. One possibility with this case is that your database processing is slower than import. So by the time the query is finished the next import process is already ready and running. Still testing this so i have confirmation on what is going on.
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. # 41
  • Page :
  • 1
  • 2
  • 3


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