1. fatelettronica
  2. RO CSVI
  3. Friday, 20 September 2024
  4.  Subscribe via email
I noticed that a product was missing from the site but was present in the file to upload.
I repeated the cron job and now it is present in my DB and published on the site. But unfortunately I notice that the number of published products (1473) is different from the number of products in the file (1501). So 74 product rows are not inserted into the DB.
Why does this happen? and is it random?
Regards
Accepted Answer Pending Moderation
Hello,
This is the same error as my other post that I thought was solved by uploading a new "index.icecat" file see post "Problem importing data from ICECAT".

In the other post you mentioned manually downloading ICEcat file and loading index worked. Did that work without any error and loading of ICECat index finished?

I have product X in the model file. I start the cron and at the end of the job the product X is not present in virtuemart, it does not exist.

Can you give an example product so I can check in debug log on what is going on? Send produict_sku of product which did not 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
Accepted Answer Pending Moderation
Dear Tharuna

This is the same error as my other post that I thought was solved by uploading a new "index.icecat" file see post "Problem importing data from ICECAT".
This problem does not load the ICECAT data but the product is still loaded into the DB and is visible in virtuemart obviously without ICECAT data.

Now it is not the same thing. Now I also found that a product present in my model is not actually written to the server DB.
I'll try to explain better.
I have product X in the model file. I start the cron and at the end of the job the product X is not present in virtuemart, it does not exist.
So now there are two problems that I hope you can solve.

Greetings
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thank you for the debug log. So I had a look into it and found that for few products there is no response received from ICECat. For example the first product in debug log with Ubiquiti and part number LOCOM2 you can see the response received from ICECat is empty. This product is missing in database and so nothing is imported. That is the case with other products too. When you load ICECat index, did it run without any error?



Found ICEcat mpn reference: LOCOM2
2024-09-20 10:50:03 1 [DEBUG] Found ICEcat manufacturer name: Ubiquiti
2024-09-20 10:50:03 1 [DEBUG] Find the ICEcat ID for manufacturer Ubiquiti and part number LOCOM2
2024-09-20 10:50:03 1 [QUERY] SELECT product_id FROM `jos_csvi_icecat_index` AS `i` LEFT JOIN `jos_csvi_icecat_suppliers` AS `s` ON `s`.`supplier_id` = `i`.`supplier_id` WHERE `i`.`prod_id` = 'LOCOM2' AND `s`.`supplier_name` = 'Ubiquiti'
2024-09-20 10:50:03 1 [DEBUG] Find the ICEcat ID by similar SKU for manufacturer Ubiquiti and part number LOCOM2
2024-09-20 10:50:03 1 [DEBUG] Find the ICEcat ID as alternative ID for manufacturer Ubiquiti and part number LOCOM2
2024-09-20 10:50:03 1 [QUERY] SELECT product_id FROM `jos_csvi_icecat_index` AS `i` LEFT JOIN `jos_csvi_icecat_suppliers` AS `s` ON `s`.`supplier_id` = `i`.`supplier_id` WHERE `i`.`m_prod_id` = 'LOCOM2' AND `s`.`supplier_name` = 'Ubiquiti'
2024-09-20 10:50:03 1 [DEBUG] Received ICEcat data: []
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
Accepted Answer Pending Moderation
Dear Tharuna

Yes, done.
Attached
Best regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Please post import debug log to check. To get the debug log see How to collect debug information? document. Also by default debug log has first 20 entries you can increase this limit from RO CSVI config page. Increase the log entries and then run the import. Post the latest debug log 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. # 5
  • Page :
  • 1


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