this one is easy,you try to create a configurable without having any
bindable simples defined.
for "creating" a new configurable, you need to have simples defined
(especially if you chose "simples before configurable" setting , making
simple lines mandatory in csv)
i could add a warning in this case in the next release

2013/2/28 Emanuele edeangelis@users.sf.net


Status: open
Created: Thu Feb 28, 2013 04:22 PM UTC by Emanuele
Last Updated: Thu Feb 28, 2013 04:22 PM UTC
Owner: nobody

Hi,
firt: Great job friend, this tool is fantastic.

I used your tool for few day and imported many product but today i can't
import configurable product and i don't know why.

I received this error:

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='620'' 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=?
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='620'' at line 3 - ERROR ON RECORD #1

My version is 1.7.2 and use magmi version v0.7.18.

this is a example file that i try to import:

configurable_attributes|attribute_set|type|sku|name|price|special_price|description|short_description|weight|tax_class_id
taglia_camicie|Calvin Klein Collection|configurable|15989|Camicia Calvin
Klein|100|48|Camicia Calvin |Camicia Calvin Klein|1|Nessuna

Thanks

Emanuele

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/magmi/support-requests/25/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/prefs/

 

Related

Support Requests: #25