Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Magmi Upload Error
Colin Tait

New
November 11, 2015 - 4:57 pm
Member Since: June 30, 2015
Forum Posts: 1
sp_UserOfflineSmall Offline

Hello Matt/Dave

I have been loving following along with your videos on using Magmi and I am importing configurable/simple products to my site, however I seem to be encountering an error (below) when uploading the csv.

The simple products are uploading correctly but the configurables do not seem to be registering at all and I cannot make head nor tale of the error message to be able to fix this issue.

Please can you help, csv file attached

error 1:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)
WHERE cpec.entity_id=’1835” at line 3 – INSERT INTO catalog_product_super_link (`parent_id`,`product_id`) SELECT cpec.entity_id as parent_id,cpes.entity_id as product_id
FROM catalog_product_entity as cpec
JOIN catalog_product_entity as cpes ON cpes.type_id IN (‘simple’,’virtual’) AND cpes.sku IN ()
WHERE cpec.entity_id=?
error 2:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)
WHERE cpec.entity_id=’1835” at line 3 – ERROR ON RECORD #275

Avatar
Dave Furness

Founder
December 7, 2015 - 7:34 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hi Colin,

Hmmm I will have to ask Matt on this one as he tends to know more about these SQL errors, I’ll ask him to take a look for you.

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:
24 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: 5221

Posts: 27485

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606