Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Importing errors
Avatar
Murray Williams

New
September 8, 2014 - 4:29 pm
Member Since: September 1, 2014
Forum Posts: 2
sp_UserOfflineSmall Offline

Hey guys,

I am receiving 2 errors when trying to update a current product within my site, I have double checked the SKU and it’s correct along with the column names so not sure what I am missing here.

The errors I am receiving are:

error 1:SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘None’ for column ‘value’ at row 3 – INSERT INTO catalog_product_entity_int

(`entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`)

VALUES (?,?,?,?,?),(?,?,?,?,?),(?,?,?,?,?) ON DUPLICATE KEY UPDATE `value`=VALUES(`value`)
error 2:SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘None’ for column ‘value’ at row 3 – ERROR ON RECORD #1
warning:Skus imported KO:1/1

I have attached the CSV file for reference.

Thanks

Avatar
Dave Furness

Founder
September 8, 2014 - 6:55 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Murray,

As you may know I am not a Magmi expert, however looking at the error it looks like the value you have for the import is not what Magento is expecting. Are you trying to add in the value as a word or a number?

Also the file didn’t attach in the post above.

I am going to ping Matt as I am now 100% sure I am right.

Dave

Every expert was once a beginner

Avatar
Murray Williams

New
September 9, 2014 - 7:42 am
Member Since: September 1, 2014
Forum Posts: 2
sp_UserOfflineSmall Offline

Hi Dave

Thanks for coming back to me. So I am trying to import a new product and I am using a CSV file (I have re-attached it to this reply) So if you are saying the formatting of my values are not correct would a CSV file not strip out any type of formatting? If not should I then select the SKU values and set them as numbers?

Regards,

Murray

Avatar
Dave Furness

Founder
September 9, 2014 - 10:53 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Murray,

Apologies I didn’t mean formatting in that sense. I meant the spelling of the values it is expecting to be correct, or alternatively using the numbers that they correlate too. Have you seen this guide here https://understandinge.com/lesson/imp-0009/ which may help explain this a little better.

Dave

Every expert was once a beginner

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
17 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5222

Posts: 27489

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606