Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
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
Comment #1
rfayYou have an empty SKU in your import, probably more than one of them. Take a look at your import to see.
Comment #2
rustyblue100 CreditAttribution: rustyblue100 commentedThank 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
Comment #3
rfaySorry, 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.
Comment #4
pcambraI 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.
Comment #5
pcambraClosing this one, please feel free to reopen it with more details on how to reproduce the error.
Comment #6
BrianLP CreditAttribution: BrianLP commentedI 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.
Comment #7
okokokok CreditAttribution: okokokok commentedI'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.
Comment #8
okokokok CreditAttribution: okokokok commentedTurned spaces into dashes with UPDATE uc_products SET model = REPLACE(model, ' ', '-') and now all seems fine!
Comment #9
johns10 CreditAttribution: johns10 commentedI 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.
Comment #10
Summit CreditAttribution: Summit commentedHi 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
Comment #11
knalstaaf CreditAttribution: knalstaaf commented#9 works, thanks! Seems like a need 2 unique identifiers (e-mail and username in my case).