This is the message I get everytime i import from cvs file, the information gets in database but this error log is still present

Comments

rfay’s picture

You have an empty SKU in your import, probably more than one of them. Take a look at your import to see.

rustyblue100’s picture

Thank you

I see, is that possible to not report the empty SKU'S or duplicated ones

Another thing this is what i see in my log array I only have one PLU as a SKU in my importer and it shows two

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'sku'
Original item

array (
'guid' => '',
'nom' => '-----',
'prix' => '',
'categorie' => '',
'plu' => '',
'PLU' => '',
)

rfay’s picture

Sorry, I don't understand the question.

As far as I know, you need to either ignore the errors or you need to clean your input data. This is really a Feeds thing, not Commerce feeds.

pcambra’s picture

Status: Active » Postponed (maintainer needs more info)

I don't understand where the error is neither, the first error you're getting is most likely caused by an empty/wrong SKU reference in your source of import, about the second issue, I assume you're mapping PLU against SKU and I'm not sure PLU is unique at all.

pcambra’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Closing this one, please feel free to reopen it with more details on how to reproduce the error.

BrianLP’s picture

I had the same problem and it turned out that I had " ; " instead of a comma as separator. I adjusted it right before the import (/import) and it worked.

okokokok’s picture

I'm getting this same error. My importer is set to "Update existing products" so I'd expect the importer to not complain and simply update the existing product.

I suspect it could be because I'm importing from an Ubercart site where the SKU contains spaces. I will get back here after turning the spaces into underscores.

okokokok’s picture

Turned spaces into dashes with UPDATE uc_products SET model = REPLACE(model, ' ', '-') and now all seems fine!

johns10’s picture

I have been able to reliably reproduce this error by setting up an import, setting it to update existing nodes, and then not setting an intrinsically unique identifier to "unique" in the feild mappings. If you do that, you'll reliably get this error.

Summit’s picture

Hi Johns10, you helped me a lot. I forgot to set "unique" by this importer.
Can't better errormessages be displayed?
Thanks again and greetings, Martijn

knalstaaf’s picture

Issue summary: View changes

#9 works, thanks! Seems like a need 2 unique identifiers (e-mail and username in my case).