Magento

@rekorder
problem might come from magic_gpc_quotes settings.
it has to be turned off for magmi to work correctly.

Is there any way to update and delete some products with Magmi import?

@energyspeed
update : yes
delete : a plugin exists for it but is not released yet. will be part of 0.7.12 to come this weekend.

@gkadmin

Plugin conflict resolved, posted new configurables plugin (1.3.2) here as usual (will also be part of next 0.7.12)

I have a question concerning the configurable Items.

By the way we run Configurable Item processor v1.3.2.

I try to import configurable items als well as simples via csv-File over Magmi.

Because the sku of the configurable is not a constant part of the beginning of the simples skus,
I added a column “simples_skus” to my cvs-file (as described in the manual).
The column ist filled by the comma separated list of the simple skus to match with. (sku1,sku2,sku3,....)

I want to use the attributes color and size to describe the configurable item. Both attributes are therefore configurated properly.
For all articles I use the attribut-set “Default”, the attributes size and color part of this attribute-set.

When importing the file, the configurable articles are inserted, but there is no assignment to the Simples.
When opening the configurable via admin-tool, first the categories are inquired. Afterwards the simples can be chosen manual.

What is my mistake?
How can I define the categories wich should be used for the configurable products in the cvs-file?
Why does the plugin disregards the “simples_skus”?

Thank you very much for your help!
Anja

you need to set the configurable_attributes column and fill it with the names of your configurable attributes comma separated on the configurable line.
This should sort out the problem, if the wiki is not clear on this point, i’ll update it ASAP.
[Edit]
Wiki updated, more clear on what columns should be filled.

@dveeves

Thank you for that prompt reply, I will try it!

That’s really not my week this week!

I’ve just got another problem:

When trying to insert pictures (columns thumbnail, image and small_image in cvs-File) we get the following error:

# 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 ‘ON DUPLICATE KEY UPDATE label=VALUES(`label`)’ at line 4 - INSERT INTO mage_catalog_product_entity_media_gallery_value
(value_id,store_id,position,disabled,label)
VALUES
ON DUPLICATE KEY UPDATE label=VALUES(`label`)
# 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 ‘ON DUPLICATE KEY UPDATE label=VALUES(`label`)’ at line 4 - ERROR ON RECORD #1

All pictures are available in /media/import.

On my test-instance everything is fine, when importing on our customers machine I get the above described errors.
The Magento an Magmi-Versions are identical, but database differs.
We have 5.1.57, our customer uses 5.1.43/ubunto.

If I delete the values in columns thumbnail, image and small_image in the import file, the import proceeds without error?

Any idea?
If not, i suppose my customer will kill me :-(

Thank you very much
Anja

Hi Dweeves

i have a big problem, im trying to import products (simples and configurables) with magmi, and using the plugin Configurable Item processor (1.3.2) by you, the script goes well, but when i look into the configurable product, turns out that theres is no simple products associated to the configurable producto can you help me with this, i dont know if i using a wrong csv format or what, im using this format

store, websites, attribute_set, type, sku, category_ids, name, price, description, short_description, status, tax_class_id, visibility, qty, is_in_stock, weight, color, talla, associated, config_attributes

is there something wrong with this format??

Thank you

Hi Dweeves

i have a big problem, im trying to import products (simples and configurables) with magmi, and using the plugin Configurable Item processor (1.3.2) by you, the script goes well, but when i look into the configurable product, turns out that there is no simple products associated to the configurable product can you help me with this, i dont know if i using a wrong csv format or what

Im using this format

store, websites, attribute_set, type, sku, category_ids, name, price, description, short_description, status, tax_class_id, visibility, qty, is_in_stock, weight, color, talla, associated, config_attributes

is there something wrong with this format??

Thank you

@antomad
use column mapper plugin and map:
associated,config_attributes
then 2 textfield will appear, one for associated, other for config_attributes

associated=>simples_skus
config_attributes=>configurable_attributes

and your configurables will be ok.

@criollo95

Made an update for image processor (1.0.17) avaiable here as usual.

Fixed processing where no data have to be inserted for image (strange however, since it means in that case that there is no valid target store id for inserting data)

Thanks for you quick reply, but i still cant get it to work :(

i got this trying to import the csv

Running Magmi Product Import Engine v1.2.1 by dweeves
Import Mode:create
CSV Datasource v1.1 - Importing CSV : ../../var/import/importar.csv using separator [ , ] enclosing [ “ ]
Performing Datasouce Lookup…
Found 3 records, took 0.00029993057251 sec
CSV Datasource v1.1 - 20 CSV headers columns found
Column mapper v0.0.3 - Replacing Column associated by simples_skus
Column mapper v0.0.3 - Replacing Column config_attributes by configurable_attributes
Configurable Item processor v1.3.2 - no options_container set, defaulting to :Block after product info
Ajusted processed columns:22

its stuck trying to import the configurable product, any suggestion?

@antomad
can you PM me your magmi url so that i can check what’s going wrong.

@All
0.7.12rc1 pre release available here as usual.

This pre release is stable, just not incorporating all the changes i wanted in 0.7.12 but most of them.

I provided it early because latest Configurable 1.3.2 used a new utility function in the core that was not present in 0.7.11.

Thanks antomad for submitting the problem (your setup is already up to date !!!)

So for all those who are using latest configurable plugin, just update to this 0.7.12rc1 pre release, many improvements but will provide changelog this weekend. You’ll find a good surprise in the UI behaviour