Categories
View Replies (23)

Resolved Problem importing data from ICECAT

  1. fatelettronica
    fatelettronica
  2. RO CSVI
  3. Saturday, 31 August 2024
  4.  Subscribe via email
I noticed that sometimes analyzing the log file I find a problem with importing data from ICECAT.
I am sure that the data exists and can be downloaded for the "iTek" brand. in icecat I see that there is a photo, for example.
I write you the first lines of the log file where I find the anomaly.

2024-08-31 10:32:55 50 [DEBUG] Found ICEcat mpn reference: ITGCADCDSB
2024-08-31 10:32:55 50 [DEBUG] Found ICEcat manufacturer name: ITEK
2024-08-31 10:32:55 50 [DEBUG] Find the ICEcat ID for manufacturer ITEK and part number ITGCADCDSB
2024-08-31 10:32:55 50 [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` = 'ITGCADCDSB' AND `s`.`supplier_name` = 'ITEK'
2024-08-31 10:32:55 50 [DEBUG] Find the ICEcat ID by similar SKU for manufacturer ITEK and part number ITGCADCDSB
2024-08-31 10:32:55 50 [DEBUG] Find the ICEcat ID as alternative ID for manufacturer ITEK and part number ITGCADCDSB
2024-08-31 10:32:55 50 [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` = 'ITGCADCDSB' AND `s`.`supplier_name` = 'ITEK'
2024-08-31 10:32:55 50 [DEBUG] Received ICEcat data: []

As you can see it does not receive anything [ ]

While a correct answer, from another article, is this:
2024-08-31 10:32:02 1 [DEBUG] Calling ICEcat URL: https://data.icecat.biz/export/freexml.int/IT/87646936.xml
2024-08-31 10:32:02 1 [DEBUG] Dialling...
2024-08-31 10:32:02 1 [DEBUG] Finished talking to ICEcat
2024-08-31 10:32:02 1 [DEBUG] Closed connection

Thanks
0
Responses (23)
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
Dear

If it can be useful I attach the two lines of the products in question, extracted from the file "files.index.csv"
Attachments (1)
righe_Index.txt
  1. more than a month ago
  2. RO CSVI
  3. # 21
fatelettronica
fatelettronica
Accepted Answer Pending Moderation
Dear Roland
I did as you asked.
I only put two products, both present in the ICECAT file "files.index.csv". One is ok but the one indicated in the previous post does not download the data. (Received ICEcat data: [])
There was no active cron job and nothing that can work with my and ICECAT's server
I attach the log file

Thanks
Attachments (1)
com_csvi.log.17.zip
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

We have been through this before if I remember correctly. First thing to check would be, what happens if you import that product alone? Does it also not receive any data? The one thing that comes to mind is that there are too many requests from your server to ICEcat and that ICEcat stops responding for a moment.

Do that 1 product import and let's see how that goes.
Kind regards,

RolandD

=========================
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. # 23
  • Page :
  • 1
  • 2


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