super_attribute_pricing problem

systcp
2011-06-27
2012-09-20
  • systcp

    systcp - 2011-06-27

    Hi,

    I'm using Magmi (0.7.11) to import configurable products with success. I'm
    able to import all attributes and I can set different prices in different
    website. But when I try to set different values for "super_attribute_pricing"
    in different web site, only the last website in the csv is correct, while the
    previuos are set to "default value". It's a strange behaviour, maybe I missed
    something in the csv?

    Thanks in advance.

     
  • Sebastien Bracquemont

    Hi, thanks for reporting.

    could you attach or send part of your csv so that i can investigate a bit ?

     
  • systcp

    systcp - 2011-06-27

    Yes, cerainly.

    Here is an example of one configurable product and 3 different websites: only
    the "eu" store (the last in the example) has the correct prices in the
    frontend. (I'm omitting some attribute columns that's not important for me,
    but tell me if you need them) . Thank you.

    store;websites;categories;tax_class_id;visibility;type;attribute_set;configura
    ble_attributes;short_description;name;sku;colore;taglia;description;price;supe
    r_attribute_pricing

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__001;Azzurro ;2 anni;Minigonna in denim
    colorato;95.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__002;Azzurro ;3 anni;Minigonna in denim
    colorato;95.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__003;Azzurro ;4 anni;Minigonna in denim
    colorato;95.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__004;Azzurro ;5 anni;Minigonna in denim
    colorato;95.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__005;Azzurro ;6 anni;Minigonna in denim
    colorato;95.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__006;Azzurro ;7 anni;Minigonna in denim
    colorato;99.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__007;Azzurro ;8 anni;Minigonna in denim
    colorato;99.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__008;Azzurro ;9 anni;Minigonna in denim
    colorato;99.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__009;Azzurro ;10 anni;Minigonna in denim
    colorato;99.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__010;Azzurro ;12 anni;Minigonna in denim
    colorato;105.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__011;Azzurro ;14 anni;Minigonna in denim
    colorato;105.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__012;Azzurro ;15 anni;Minigonna in denim
    colorato;105.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__013;Azzurro ;16 anni;Minigonna in denim
    colorato;105.00;

    admin;it,uk,eu;"Girl;;Girl/Gonne";none;Catalog,
    Search;configurable;myAttributeSet;colore,taglia;Minigonna in denim
    colorato;Minigonna in denim colorato;U37010U0095;;;Minigonna in denim
    colorato;95.00;"taglia::2 anni:0;3 anni:0;4 anni:0;5 anni:0;6 anni:0;7
    anni:4;8 anni:4;9 anni:4;10 anni:4;12 anni:10;14 anni:10;15 anni:10;16
    anni:10"

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__001;Azzurro ;2 anni;Coloured denim mini
    skirt;117.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__002;Azzurro ;3 anni;Coloured denim mini
    skirt;117.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__003;Azzurro ;4 anni;Coloured denim mini
    skirt;117.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__004;Azzurro ;5 anni;Coloured denim mini
    skirt;117.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__005;Azzurro ;6 anni;Coloured denim mini
    skirt;117.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__006;Azzurro ;7 anni;Coloured denim mini
    skirt;122.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__007;Azzurro ;8 anni;Coloured denim mini
    skirt;122.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__008;Azzurro ;9 anni;Coloured denim mini
    skirt;122.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__009;Azzurro ;10 anni;Coloured denim mini
    skirt;122.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__010;Azzurro ;12 anni;Coloured denim mini
    skirt;129.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__011;Azzurro ;14 anni;Coloured denim mini
    skirt;129.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__012;Azzurro ;15 anni;Coloured denim mini
    skirt;129.00;

    uk;uk;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__013;Azzurro ;16 anni;Coloured denim mini
    skirt;129.00;

    uk;uk;"Girl;;Girl/Gonne";none;Catalog,
    Search;configurable;myAttributeSet;colore,taglia;Coloured denim mini
    skirt;Coloured denim mini skirt;U37010U0095;;;Coloured denim mini
    skirt;117.00;"taglia::2 anni:0;3 anni:0;4 anni:0;5 anni:0;6 anni:0;7 anni:5;8
    anni:5;9 anni:5;10 anni:5;12 anni:12;14 anni:12;15 anni:12;16 anni:12"

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__001;Azzurro ;2 anni;Minigonna in denim
    colorato;95.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__002;Azzurro ;3 anni;Minigonna in denim
    colorato;95.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__003;Azzurro ;4 anni;Minigonna in denim
    colorato;95.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__004;Azzurro ;5 anni;Minigonna in denim
    colorato;95.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__005;Azzurro ;6 anni;Minigonna in denim
    colorato;95.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__006;Azzurro ;7 anni;Minigonna in denim
    colorato;99.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__007;Azzurro ;8 anni;Minigonna in denim
    colorato;99.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__008;Azzurro ;9 anni;Minigonna in denim
    colorato;99.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__009;Azzurro ;10 anni;Minigonna in denim
    colorato;99.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__010;Azzurro ;12 anni;Minigonna in denim
    colorato;105.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__011;Azzurro ;14 anni;Minigonna in denim
    colorato;105.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__012;Azzurro ;15 anni;Minigonna in denim
    colorato;105.00;

    it;it;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Minigonna in denim colorato;Minigonna in
    denim colorato;U37010U0095606__013;Azzurro ;16 anni;Minigonna in denim
    colorato;105.00;

    it;it;"Girl;;Girl/Gonne";none;Catalog,
    Search;configurable;myAttributeSet;colore,taglia;Minigonna in denim
    colorato;Minigonna in denim colorato;U37010U0095;;;Minigonna in denim
    colorato;95.00;"taglia::2 anni:0;3 anni:0;4 anni:0;5 anni:0;6 anni:0;7
    anni:4;8 anni:4;9 anni:4;10 anni:4;12 anni:10;14 anni:10;15 anni:10;16
    anni:10"

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__001;Azzurro ;2 anni;Coloured denim mini
    skirt;109.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__002;Azzurro ;3 anni;Coloured denim mini
    skirt;109.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__003;Azzurro ;4 anni;Coloured denim mini
    skirt;109.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__004;Azzurro ;5 anni;Coloured denim mini
    skirt;109.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__005;Azzurro ;6 anni;Coloured denim mini
    skirt;109.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__006;Azzurro ;7 anni;Coloured denim mini
    skirt;113.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__007;Azzurro ;8 anni;Coloured denim mini
    skirt;113.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__008;Azzurro ;9 anni;Coloured denim mini
    skirt;113.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__009;Azzurro ;10 anni;Coloured denim mini
    skirt;113.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__010;Azzurro ;12 anni;Coloured denim mini
    skirt;120.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__011;Azzurro ;14 anni;Coloured denim mini
    skirt;120.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__012;Azzurro ;15 anni;Coloured denim mini
    skirt;120.00;

    eu;eu;"Girl;;Girl/Gonne";none;Not Visible
    Individually;simple;myAttributeSet;;Coloured denim mini skirt;Coloured denim
    mini skirt;U37010U0095606__013;Azzurro ;16 anni;Coloured denim mini
    skirt;120.00;

    eu;eu;"Girl;;Girl/Gonne";none;Catalog,
    Search;configurable;myAttributeSet;colore,taglia;Coloured denim mini
    skirt;Coloured denim mini skirt;U37010U0095;;;Coloured denim mini
    skirt;109.00;"taglia::2 anni:0;3 anni:0;4 anni:0;5 anni:0;6 anni:0;7 anni:4;8
    anni:4;9 anni:4;10 anni:4;12 anni:11;14 anni:11;15 anni:11;16 anni:11"

     
  • systcp

    systcp - 2011-06-28

    Hi,

    have you any news about the problem?

    Do you need more information about the problem?

     
  • Sebastien Bracquemont

    Hi, found the problem.

    This is due to current configurable plugin behaviour.

    It deletes/recreates the relation between configurable attributes &
    configurable product for each sku.

    I didn't anticipate the multiple line declaration of same SKU for configurable
    related info.

    This delete is "CASCADING" in the sub tables handling princing, so only the
    last occurence will be saved.

    I'm currently investigating it, on a way to a fix.

    However, the fix will need to add a "magmi:override" column in the CSV since
    you don't declare the configurables consecutively.

    Magmi has only "1 line cache" in order to have very low memory footprint and
    be able to ingest millions of record.

    So , putting a supplementary special column "magmi:override" (and putting 1 on
    the cell value for the SKU you want) would tell magmi to consider line as an
    override and not a "redeclaration" of the product to import. So magmi will be
    able to not delete current product info but extending them.

    Would this kind of solution be ok for you ?

     
  • Sebastien Bracquemont

    Latest update, found a way to not use "magmi:override" column that might work
    on your case.

    will provide a plugin update soon.

    btw i'm reachable online at the following IM coords

    gmail/jabber: dweeves@gmail.com

    skype:dweeves

    msn:dweeves@hotmail.com

    So we can interact live on your problem.

     
  • systcp

    systcp - 2011-06-29

    Ok, thank you for your reply. I just sent you a skype contact request.

    I would specify that I use two csv files to import products: one for "admin"
    store and one for "uk" and "eu", so the products with the same SKU are not
    consecutive. But the behaviour of configurable plugin is the same.

     
  • systcp

    systcp - 2011-06-30

    Hi, thank you for the plugin update. I tried to import my csv and I got the
    following error:

    SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    SELECT product_super_attribute_id as psaid FROM `` WHERE product_id=? AND
    attribute_id=?

    2 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    ERROR ON RECORD #14

    3 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    SELECT product_super_attribute_id as psaid FROM `` WHERE product_id=? AND
    attribute_id=?

    4 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    ERROR ON RECORD #28

    5 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    SELECT product_super_attribute_id as psaid FROM `` WHERE product_id=? AND
    attribute_id=?

    6 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    ERROR ON RECORD #42

    7 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    SELECT product_super_attribute_id as psaid FROM `` WHERE product_id=? AND
    attribute_id=?

    8 SQLSTATE: Syntax error or access violation: 1103 Incorrect table name '' -
    ERROR ON RECORD #56

    Seem that "table name" is missing in the FROM clause

     
  • systcp

    systcp - 2011-06-30

    Ok, I tried to debug your code and I found three little mistake in
    "magmi_configurableprocessor.php" file:

    Row 237:

    Old: $sql="SELECT product_super_attribute_id as psaid FROM $psa WHERE
    product_id=? AND attribute_id=?";

    New: $sql="SELECT product_super_attribute_id as psaid FROM $**c**psa WHERE
    product_id=? AND attribute_id=?";

    Row 238:

    Old: $psaid=$this->selectOne($sql,array($pid,$attid),"psaid");

    New: $psaid=$this->selectOne($sql,array($pid,$attrid),"psaid");

    Row 106:

    Old: JOIN catalog_product_entity AS cpe ON cpe.sku $cond

    New: JOIN ".$this->tablename("catalog_product_entity")." AS cpe ON
    cpe.sku $cond

    I tried to reimpiort csv and now is ok.

    Tell me if my solutions are right, thank you again.

     
  • Sebastien Bracquemont

    Thanks for fixing !!!

    Sorry for the typos, (i think 2am is not the best time for coding ;) )

    I'll provide an 1.3.2 including those fixed & open choice for simples
    visiblity value forcing.

     
  • Nobody/Anonymous

    Hi,

    I have Magento CE1.6.2 + Magmi v0.7.17beta5 + Configurable Item processor
    v1.3.6

    I would like to import some configurable product and every thing is fine. Just
    the super_product_pricing values are not working. After the import there
    aren't the values. (values fields are empty)

    Can you halp me?

    Thx a lot!

     
  • Nobody/Anonymous

    SORRY SORRRRRY :)

    The previous problem is SOLVED: The column header name was wrong in the csv
    file.

     

Log in to post a comment.