Resolved "Success updated" when importing - but no changes

Hello Fabio,

Let's start by cleaning up your template, empty the XML node and default value fields.

What I am doing wrong?

I am not sure as I don't have the debug log. Post that also and let's see what is in there.

Dear Rolandd,
This is the file.
Thanks.
Fabio

I am resending the file - zipped.

Hello Fabio,

A few things that stand out from the log

• Your template has less fields than your import file. I suggest you create a new template using the Field mapper in CSVI. All the fields you don't want to use, set them to Skip.
• Your SKU is read correctly but later reset to empty. This is why you see an update but nothing happening.

After you made the new template with all the fields, run the import again and see how it goes.

Dear Roland,
Thank you for your help.
I have still some problems...
I have created the new template.
I don'ìt find the tab that modifies the sku.
Can you figure out what am I doing wrong?
Thanks,
Fabio for Ivano

This is the log file

Hello Fabio,

I don'ìt find the tab that modifies the sku.

You want to change the SKU of your products?

You should also empty the template_field_name column in your template, it is not for CSV files.

Edit: Debug log was on the next page :side:

And this is the log file.

Dear Roland,
Thanks again for the help.

"Your SKU is read correctly but later reset to empty. This is why you see an update but nothing happening"
>>> Is there something I can do for this? I don't know where it is set to empty.

I don'ìt find the tab that modifies the sku. [I was referring to the point above]
> You want to change the SKU of your products? ////
>>> No, I don't want to change the SKU.

>Where is the debug log? I must have it otherwise I can't give you an answer.
>>> I didn't realize that I can not upload zip files or php files.I have trasformed in ".txt".

You should also empty the template_field_name column in your template, it is not for CSV files.
>>> Done.

>>> I have fixed the point "emptly the template_field_name" and I have rechecked but still no change in virtuemart.

I am uploading the new debug log
com_csvi.log.1418138641.txt

Hello,

I see in the debug log you have 2x the field product_in_stock, there can only be 1 such field. So you have to change 1 of them. The last field is callled custom_price, this has no effect because the custom_price is only used if you are importing custom fields. So you need to choose another field for this or set it to skip as well.

"Your SKU is read correctly but later reset to empty. This is why you see an update but nothing happening"
>>> Is there something I can do for this? I don't know where it is set to empty.

The last debug log is good. The SKU is fine now and not reset anymore.

I don'ìt find the tab that modifies the sku.
> You want to change the SKU of your products? ////
>>> No, I don't want to change the SKU.

What do you mean then?

>Where is the debug log? I must have it otherwise I can't give you an answer.
>>> I didn't realize that I can not upload zip files or php files.I have trasformed in ".txt".

You can upload zip files but I see you didn't read my edit on my post. The debug log was on the 2nd page, that is why I missed it

>>> I have fixed the point "emptly the template_field_name" and I have rechecked but still no change in virtuemart.

The update statement is fine now when I look at your debug log. Look at this query

UPDATE `replaced_virtuemart_products_it_it` SET `product_s_desc`='· DSUB 25 Pin Maschio<br/>· Centronics 36 Pin Maschio<br/>· Lunghezza mt. 1,80',`product_desc`='<p>Cavo prolunga seriale</p><br/><p><strong>Connettori:</strong> <br /> • DSUB 25 Pin Maschio <br /> • Centronics 36 Pin Maschio</p><br/><p><strong>Caratteristiche: <br /></strong> • Lunghezza mt. 1,80 <br /> • Colore grigio<br />• Schermato <br />• Calotte assemblate</p>',`product_name`='Cavo PC Stampante DB 25p - M/Centronics 36p. M  1,8 mt 25 cond.-' WHERE `virtuemart_product_id`='4654'

You see that this product with ID 4654 is being updated, this is for SKU ICOC 01-CP-25.

I wonder if you are looking at the correct tables in VirtueMart. VirtueMart is not taking the data from an English table in the database?