Resolved Problem importing incomplete

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.

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

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: []

Dear Tharuna

Yes, done.
Attached
Best regards

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.