# API Variante anlegen SQL Error

**URL:** <https://forum.shopware.com/t/api-variante-anlegen-sql-error/67168>\
**Category:** Programmierung\
**Created:** [25. Mai 2020 um 07:53 UTC](https://forum.shopware.com/t/api-variante-anlegen-sql-error/67168 "2020-05-25T07:53:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![NicoDeluxe](https://avatars.discourse-cdn.com/v4/letter/n/c0e974/32.png) [@NicoDeluxe](https://forum.shopware.com/u/NicoDeluxe)\
**Post date:** [25. Mai 2020 um 07:53 UTC](https://forum.shopware.com/t/api-variante-anlegen-sql-error/67168/1 "2020-05-25T07:53:22Z")

</div>

Hallo zusammen,

ich versuche in einen Shop Variante anzulegen, in meinem Testshop neueste Version geht das 1a, in dem anderen Shop bekomme ich allerdings folgende Fehlermeldung (SW 5.5.1.0):

```
{"success":false,"message":"Error message: An exception occurred while executing 'INSERT INTO s_article_configurator_options (group_id, name, position, media_id) VALUES (?, ?, ?, ?)' with params [13, \"Small\", 0, null]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '13-Small' for key 'group_id'"}

```

Das seltsame ist, ich sehe den Eintrag nicht in der Tabelle. HAt jemand ne Idee?&nbsp;

Hier mein Variant Json was ich auf eine Artikel ID putte:

```
{
    "configuratorSet": {
        "groups": [
            {
                "name": "Größe",
                "options": [
                    {
                        "name": "Small"
                    }
                ]
            },
            {
                "name": "Größe",
                "options": [
                    {
                        "name": "Large"
                    }
                ]
            },
            {
                "name": "Größe",
                "options": [
                    {
                        "name": "Medium"
                    }
                ]
            },
            {
                "name": "Größe",
                "options": [
                    {
                        "name": "XL"
                    }
                ]
            },
            {
                "name": "Größe",
                "options": [
                    {
                        "name": "XXL"
                    }
                ]
            }
        ]
    },
    "variants": [
        {
            "configuratorOptions": [
                {
                    "group": "Größe",
                    "option": "Small"
                }
            ],
            "number": "1566S",
            "isMain": true,
            "prices": [
                {
                    "pseudoPrice": 17.95,
                    "price": 0,
                    "customerGroupKey": "EK"
                }
            ],
            "active": true,
            "shippingTime": "3-5 Tage",
            "purchasePrice": "9.02",
           
            "ean": ""
        },
        {
            "configuratorOptions": [
                {
                    "group": "Größe",
                    "option": "Large"
                }
            ],
            "number": "32339200203",
            "isMain": true,
            "prices": [
                {
                    "pseudoPrice": 17.95,
                    "price": 0,
                    "customerGroupKey": "EK"
                }
            ],
            "active": true,
            "shippingTime": "3-5 Tage",
            "purchasePrice": "9.02",
            
            "ean": ""
        },
        {
            "configuratorOptions": [
                {
                    "group": "Größe",
                    "option": "Medium"
                }
            ],
            "number": "32339200203x2",
            "isMain": true,
            "prices": [
                {
                    "pseudoPrice": 17.95,
                    "price": 0,
                    "customerGroupKey": "EK"
                }
            ],
            "active": true,
            "shippingTime": "3-5 Tage",
            "purchasePrice": "9.02",
           
            "ean": ""
        },
        {
            "configuratorOptions": [
                {
                    "group": "Größe",
                    "option": "XL"
                }
            ],
            "number": "32339200204",
            "isMain": true,
            "prices": [
                {
                    "pseudoPrice": 17.95,
                    "price": 0,
                    "customerGroupKey": "EK"
                }
            ],
            "active": true,
            "shippingTime": "3-5 Tage",
            "purchasePrice": "9.02",
         
            "ean": ""
        },
        {
            "configuratorOptions": [
                {
                    "group": "Größe",
                    "option": "XXL"
                }
            ],
            "number": "32339200205",
            "isMain": true,
            "prices": [
                {
                    "pseudoPrice": 17.95,
                    "price": 0,
                    "customerGroupKey": "EK"
                }
            ],
            "active": true,
            "shippingTime": "3-5 Tage",
            "purchasePrice": "9.02",
           
            "ean": ""
        }
    ]
}

```

&nbsp;