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: 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 ()
error 2:SQLSTATE: 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
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.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606