Resolved icecat import for VM goes wrong :(

Hello Marcel,

The only thing missing from your report is the debug log. That I need to know what is happening during your import. Post that as well please

Excuse me
Here is the log

Well that helps Now we can see that CSVI doesn't find any related ICEcat ID:

2015-01-30	09:26:05	2	[DEBUG]	Looking for ICEcat ID

2015-01-30	09:26:05	2	[QUERY]	 SELECT product_id FROM `at0nr_csvi_icecat_index` AS  i LEFT JOIN `at0nr_csvi_icecat_suppliers` AS s ON s.supplier_id = i.supplier_id WHERE i.`prod_id` = 'EM4544' AND s.`supplier_name` = 'Eminent'

2015-01-30	09:26:05	2	[DEBUG]	Looking for ICEcat ID

2015-01-30	09:26:05	2	[QUERY]	 SELECT product_id FROM `at0nr_csvi_icecat_index` AS  i LEFT JOIN `at0nr_csvi_icecat_suppliers` AS s ON s.supplier_id = i.supplier_id WHERE i.`prod_id` LIKE 'EM4544%' AND s.`supplier_name` = 'Eminent'

2015-01-30	09:26:05	2	[DEBUG]	Looking for ICEcat ID

2015-01-30	09:26:05	2	[QUERY]	 SELECT product_id FROM `at0nr_csvi_icecat_index` AS  i LEFT JOIN `at0nr_csvi_icecat_suppliers` AS s ON s.supplier_id = i.supplier_id WHERE i.`m_prod_id` = 'EM4544' AND s.`supplier_name` = 'Eminent'

These queries have no result and as a result CSVI can't contact ICEcat because there is no product ID from ICEcat.

The IDs you use need to be present in the ICEcat database.

Roland,

I used the example you are providing me:
http://www.csvimproved.com/en/support/import/203-virtuemart/794-import-icecat-product-specifications

I attached the import file.

its al about the first product (thats in the example)
second line is a wild try and you can forget about it

Hello,

I see that ICEcat seems to have removed that example product from their list. One product that is present in my list is product SKU 10J0001 from manufacturer Lexmark.

You can have a try with that.

Thank you very much,
That helped alot.

Next problem is that the image(s) are not saved
I included the log
I hope you can help

Next problem is that the image(s) are not saved

You have not included the image fields, so they are not processed. You need to include the file_url and file_url_thumb fields.

It works
Thank you for your great help.
I bet i need you again

At this moment i do not understand the following

this is the import file:
product_sku;manufacturer_name;product_name;product_desc;product_s_desc;features;file_url;file_url_thumb
10J0001;Lexmark;;;;;;
EW3705;Ewent;;;;;;
EM6105;Eminent;;;;;;

first line is your example.
the other 2 i created myself.
I can find them in ice cat but they are not correct imported
And yes i am feeling stupid

the other 2 i created myself.
I can find them in ice cat but they are not correct imported

CSVI cannot find them in your ICEcat data. It looks for them here

2015-02-02	09:39:43	3	[DEBUG]	Zoeken naar ICEcat ID

2015-02-02	09:39:43	3	[QUERY]	 SELECT product_id FROM `at0nr_csvi_icecat_index` AS  i LEFT JOIN `at0nr_csvi_icecat_suppliers` AS s ON s.supplier_id = i.supplier_id WHERE i.`prod_id` = 'EM6105' AND s.`supplier_name` = 'Eminent'

2015-02-02	09:39:43	3	[DEBUG]	Zoeken naar ICEcat ID

2015-02-02	09:39:43	3	[QUERY]	 SELECT product_id FROM `at0nr_csvi_icecat_index` AS  i LEFT JOIN `at0nr_csvi_icecat_suppliers` AS s ON s.supplier_id = i.supplier_id WHERE i.`prod_id` LIKE 'EM6105%' AND s.`supplier_name` = 'Eminent'

2015-02-02	09:39:43	3	[DEBUG]	Zoeken naar ICEcat ID

2015-02-02	09:39:43	3	[QUERY]	 SELECT product_id FROM `at0nr_csvi_icecat_index` AS  i LEFT JOIN `at0nr_csvi_icecat_suppliers` AS s ON s.supplier_id = i.supplier_id WHERE i.`m_prod_id` = 'EM6105' AND s.`supplier_name` = 'Eminent'

This means there is no id by that code or no supplier by that name or both. Remember the Free ICEcat database does not contain all products compared to the paid ICEcat database. I checked your last entry against my ICEcat database that I just updated and it is found. Check if your ICEcat database is up-to-date otherwise load it again. You should get 463315 files and 2964 manufacturers when you go to the Settings -> ICEcat tab.

Table Count
Files 203000
Supplier 3097

When i update the database it always crashes at the end with a error and a 404.
Is it usefull to give you access to my backend?

Gzip was bothering me i guess
now i imported with no error

Files 581077
Supplier 3074

differs from you (Country related?)

It imported now also the EM6105

But not the EW3705
Is it possible to check in your DB if its there? (to be sure)

Thanks

This can be country related I think. At least you have a lot of them As for the EW3705, this is also present here.