Gelöst Löschen von Artikeln in der WaWi - in Shopware unvollständig

[TomL]

Hi,

wenn ich einen Artikel mit Varianten in der WaWi lösche, bleiben in Shopware einzelne Varianten bestehen. Es wird dabei auch eien Exection erzeugt, wenn ich das richtig gesehen habe. Da müsste ihr einfach mal 2-3 Artikel anlegen und löschen, dann seht ihr bestimmt, wo es hängt.

vG!

PS: Jetzt habe ich den Artikel händisch aus Shopware gelöscht. Obwohl er nicht mehr in der WaWi ist, schmeisst der Connector nun ne Fehlermeldung:
Fehler:
Bilder-Löschen-Fehler: Es müssen gültige Informationen angegeben werden, um die Zeichenfolge einzufügen.
Error converting value "" to type 'jtlDatabase.classes.ConnectorClasses.Interfaces.ImageRelationType'. Path 'relationType'.
bei System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
bei System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
bei Newtonsoft.Json.Utilities.EnumUtils.ParseEnumName(String enumText, Boolean isNullable, Type t)
bei Newtonsoft.Json.Converters.StringEnumConverter.ReadJson(JsonReader reader, Type objectType, Object existingValue, JsonSerializer serializer)

Warnung:
Artikelnummer 'test1-002' ist bereits vorhanden. Der Wawi-Artikel wird aktualisiert.

 

[Daniel B.]

AW: Löschen von Artikeln in der WaWi - in Shopware unvollständig

Hey,

da fehlt der relationType beim Löschen. Dies wird in der Connector Version 1.0.5 behoben sein.

Gruß,
Daniel

 

[TomL]

AW: Löschen von Artikeln in der WaWi - in Shopware unvollständig

ich hab das PRoblem immer noch. Habe aus einem Variantenartikel in der WaWi wieder alle Varianten gelöscht. Jetzt kommt wieder eine Fehlermeldung, dass der Artikel im Shop schon enthalten ist: Artikelnummer 'testartikel' ist bereits vorhanden. Der Wawi-Artikel wird aktualisiert.

JTL-Wawi: StartForm()
JTL-Wawi: MainWindow != null
JTL-Wawi: Sync start
JTL-Wawi: Licence is valid
JTL-Wawi: InitCall OK
JTL-Wawi: Initialize model getters...
>>> Category.statistic: {
  "method": "Category.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "28d2829304f840d7bd171f98fb4da0ea"
}
<<< Category.statistic: {"result":{"available":0,"controllerName":"category"},"error":null,"jtlrpc":"2.0","id":"28d2829304f840d7bd171f98fb4da0ea"}
>>> Product.statistic: {
  "method": "Product.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "1a9ea61cfd2b4c30965bd2b268653440"
}
<<< Product.statistic: {"result":{"available":1,"controllerName":"product"},"error":null,"jtlrpc":"2.0","id":"1a9ea61cfd2b4c30965bd2b268653440"}
>>> CrossSelling.statistic: {
  "method": "CrossSelling.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "b0d27c90d6934774ae543d8f8105cd88"
}
<<< CrossSelling.statistic: {"result":{"available":0,"controllerName":"crossSelling"},"error":null,"jtlrpc":"2.0","id":"b0d27c90d6934774ae543d8f8105cd88"}
>>> Customer.statistic: {
  "method": "Customer.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "6e11888b91004ca6b347701232267cb2"
}
<<< Customer.statistic: {"result":{"available":0,"controllerName":"customer"},"error":null,"jtlrpc":"2.0","id":"6e11888b91004ca6b347701232267cb2"}
>>> CustomerOrder.statistic: {
  "method": "CustomerOrder.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "15cbcbdcbb444c058bf3cf19e6e3791d"
}
<<< CustomerOrder.statistic: {"result":{"available":0,"controllerName":"customerOrder"},"error":null,"jtlrpc":"2.0","id":"15cbcbdcbb444c058bf3cf19e6e3791d"}
>>> Image.statistic: {
  "method": "Image.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "baaf7009e6fe4e43b3f5ac545e002a3e"
}
<<< Image.statistic: {"result":{"available":2,"controllerName":"image"},"error":null,"jtlrpc":"2.0","id":"baaf7009e6fe4e43b3f5ac545e002a3e"}
>>> Specific.statistic: {
  "method": "Specific.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "23ba868a1d894aca9d89fb1ffe36fb72"
}
<<< Specific.statistic: {"result":{"available":0,"controllerName":"specific"},"error":null,"jtlrpc":"2.0","id":"23ba868a1d894aca9d89fb1ffe36fb72"}
>>> Manufacturer.statistic: {
  "method": "Manufacturer.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "adf077a7c02f430c9eda20a23cace6d6"
}
<<< Manufacturer.statistic: {"result":{"available":0,"controllerName":"manufacturer"},"error":null,"jtlrpc":"2.0","id":"adf077a7c02f430c9eda20a23cace6d6"}
>>> Payment.statistic: {
  "method": "Payment.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "1a47ae7dfffa41ebb2d9518332726aa6"
}
<<< Payment.statistic: {"result":{"available":0,"controllerName":"payment"},"error":null,"jtlrpc":"2.0","id":"1a47ae7dfffa41ebb2d9518332726aa6"}
JTL-Wawi: ModelGetters OK
>>> global_data.pull: {
  "method": "global_data.pull",
  "params": {
    "limit": 50,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "4220651cbeba4cd2b1fcd08ba63af22f"
}
<<< global_data.pull: {"result":[{"configGroups":[],"configItems":[],"crossSellingGroups":[],"currencies":[{"id":["1",0],"delimiterCent":"","delimiterThousand":"","factor":1,"hasCurrencySignBeforeValue":false,"isDefault":true,"iso":"EUR","name":"Euro","nameHtml":"&euro;"}],"customerGroups":[{"id":["1",0],"applyNetPrice":false,"discount":0,"isDefault":true,"attributes":[],"i18ns":[{"customerGroupId":["1",0],"languageISO":"ger","name":"Shopkunden"}]},{"id":["2",0],"applyNetPrice":true,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["2",0],"languageISO":"ger","name":"H\u00e4ndler"}]},{"id":["3",0],"applyNetPrice":true,"discount":0,"isDefault":false,"attributes":[],"i18ns":[{"customerGroupId":["3",0],"languageISO":"ger","name":"bepado export"}]}],"languages":[{"id":["2",0],"isDefault":false,"languageISO":"eng","nameEnglish":"Englisch","nameGerman":"Englisch"},{"id":["1",0],"isDefault":true,"languageISO":"ger","nameEnglish":"Deutsch","nameGerman":"Deutsch"}],"measurementUnits":[{"id":["1",0],"code":"l","displayCode":"Liter","i18ns":[]},{"id":["2",0],"code":"g","displayCode":"Gramm","i18ns":[]},{"id":["5",0],"code":"lfm","displayCode":"lfm","i18ns":[]},{"id":["6",0],"code":"kg","displayCode":"Kilogramm","i18ns":[]},{"id":["8",0],"code":"Paket(e)","displayCode":"Paket(e)","i18ns":[]},{"id":["9",0],"code":"Stck.","displayCode":"St\u00fcck","i18ns":[]},{"id":["10",0],"code":"h","displayCode":"Stunde(n)","i18ns":[]}],"productTypes":[],"shippingClasses":[],"taxRates":[{"id":["1",0],"rate":19},{"id":["4",0],"rate":7}],"units":[],"warehouses":[]}],"error":null,"jtlrpc":"2.0","id":"4220651cbeba4cd2b1fcd08ba63af22f"}
>>> image.delete: {
  "method": "image.delete",
  "params": [
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        53
      ],
      "id": [
        "",
        62
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        50
      ],
      "id": [
        "",
        45
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        50
      ],
      "id": [
        "",
        49
      ],
      "relationType": "product",
      "sort": 2
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        53
      ],
      "id": [
        "",
        62
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        20
      ],
      "id": [
        "",
        35
      ],
      "relationType": "product",
      "sort": 2
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        20
      ],
      "id": [
        "",
        43
      ],
      "relationType": "product",
      "sort": 3
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        20
      ],
      "id": [
        "",
        55
      ],
      "relationType": "product",
      "sort": 5
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        20
      ],
      "id": [
        "",
        57
      ],
      "relationType": "product",
      "sort": 6
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        22
      ],
      "id": [
        "",
        1
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        22
      ],
      "id": [
        "",
        37
      ],
      "relationType": "product",
      "sort": 2
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        22
      ],
      "id": [
        "",
        47
      ],
      "relationType": "product",
      "sort": 3
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        22
      ],
      "id": [
        "",
        51
      ],
      "relationType": "product",
      "sort": 4
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        18
      ],
      "id": [
        "",
        41
      ],
      "relationType": "product",
      "sort": 2
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        17
      ],
      "id": [
        "",
        39
      ],
      "relationType": "product",
      "sort": 2
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        31
      ],
      "id": [
        "",
        9
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        21
      ],
      "id": [
        "",
        59
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        30
      ],
      "id": [
        "",
        11
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        29
      ],
      "id": [
        "",
        13
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        28
      ],
      "id": [
        "",
        15
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        23
      ],
      "id": [
        "",
        5
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        24
      ],
      "id": [
        "",
        3
      ],
      "relationType": "product",
      "sort": 1
    },
    {
      "filename": null,
      "remoteUrl": null,
      "foreignKey": [
        "",
        25
      ],
      "id": [
        "",
        7
      ],
      "relationType": "product",
      "sort": 1
    }
  ],
  "jtlrpc": "2.0",
  "id": "3235d99934f74ecaa222de257035097d"
}
<<< image.delete: {"result":[{"foreignKey":["",0],"id":["",53],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",50],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",50],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",53],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",20],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",20],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",20],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",20],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",22],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",22],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",22],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",22],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",18],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",17],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",31],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",21],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",30],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",29],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",28],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",23],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",24],"filename":"","relationType":"product","remoteUrl":"","sort":0},{"foreignKey":["",0],"id":["",25],"filename":"","relationType":"product","remoteUrl":"","sort":0}],"error":null,"jtlrpc":"2.0","id":"3235d99934f74ecaa222de257035097d"}
>>> Product.statistic: {
  "method": "Product.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "4c135691471b4ec5878654e9b1d3dc01"
}
<<< Product.statistic: {"result":{"available":1,"controllerName":"product"},"error":null,"jtlrpc":"2.0","id":"4c135691471b4ec5878654e9b1d3dc01"}
>>> product.pull: {
  "method": "product.pull",
  "params": {
    "limit": 50,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "8b409647bfb04bb983652e904d52ceb2"
}
<<< product.pull: {"result":[{"basePriceUnitId":["",0],"id":["932_212",0],"manufacturerId":["",0],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",0],"unitId":["",0],"asin":"","availableFrom":"2015-07-09T00:00:00+0200","basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":true,"considerVariationStock":false,"creationDate":null,"ean":"","epid":"","hazardIdNumber":"","height":0,"isActive":true,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","measurementQuantity":0,"measurementUnitCode":"","minimumOrderQuantity":1,"modified":null,"nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":true,"productWeight":0,"recommendedRetailPrice":0,"serialNumber":"","shippingWeight":0,"sku":"testartikel","sort":0,"stockLevel":{"productId":["932_212",0],"stockLevel":0},"supplierDeliveryTime":0,"supplierStockLevel":0,"taric":"","unNumber":"","upc":"","vat":0,"width":0,"attributes":[],"categories":[],"checksums":[],"configGroups":[],"customerGroupPackagingQuantities":[],"fileDownloads":[],"i18ns":[{"productId":["932_212",0],"deliveryStatus":"","description":"","languageISO":"ger","measurementUnitName":"","metaDescription":"","metaKeywords":"","name":"","shortDescription":"","titleTag":"","unitName":"","urlPath":""}],"invisibilities":[],"mediaFiles":[],"partsLists":[],"prices":[{"customerGroupId":["1",0],"customerId":["",0],"id":["932_212_0",0],"productId":["932_212",0],"items":[{"productPriceId":["932_212_0",0],"netPrice":0,"quantity":1}]},{"customerGroupId":["0",0],"customerId":["0",0],"id":["932_212_0",0],"productId":["932_212",0],"items":[{"productPriceId":["932_212_0",0],"netPrice":0,"quantity":0}]}],"specialPrices":[],"specifics":[],"varCombinations":[],"variations":[],"warehouseInfo":[]}],"error":null,"jtlrpc":"2.0","id":"8b409647bfb04bb983652e904d52ceb2"}
>>> core.connector.ack: {
  "method": "core.connector.ack",
  "params": {
    "identities": {
      "product": [
        [
          "932_212",
          53
        ]
      ]
    },
    "checksums": []
  },
  "jtlrpc": "2.0",
  "id": "24c74e186852449a913400c85c41d786"
}
<<< core.connector.ack: {"result":null,"error":{"code":23000,"message":"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`usrdb_casbocfr`.`jtl_connector_link_detail`, CONSTRAINT `jtl_connector_link_detail_1` FOREIGN KEY (`product_id`) REFERENCES `s_articles` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)","data":null},"jtlrpc":"2.0","id":"24c74e186852449a913400c85c41d786"}
>>> product.pull: {
  "method": "product.pull",
  "params": {
    "limit": 50,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "7eb39e325899463aab726e043ff354cc"
}
<<< product.pull: {"result":[{"basePriceUnitId":["",0],"id":["932_212",0],"manufacturerId":["",0],"masterProductId":["",0],"measurementUnitId":["",0],"partsListId":["",0],"productTypeId":["",0],"shippingClassId":["",0],"unitId":["",0],"asin":"","availableFrom":"2015-07-09T00:00:00+0200","basePriceDivisor":0,"basePriceFactor":0,"basePriceQuantity":0,"basePriceUnitCode":"","basePriceUnitName":"","considerBasePrice":false,"considerStock":true,"considerVariationStock":false,"creationDate":null,"ean":"","epid":"","hazardIdNumber":"","height":0,"isActive":true,"isBatch":false,"isBestBefore":false,"isbn":"","isDivisible":false,"isMasterProduct":false,"isNewProduct":false,"isSerialNumber":false,"isTopProduct":false,"keywords":"","length":0,"manufacturerNumber":"","measurementQuantity":0,"measurementUnitCode":"","minimumOrderQuantity":1,"modified":null,"nextAvailableInflowDate":null,"nextAvailableInflowQuantity":0,"note":"","originCountry":"","packagingQuantity":0,"permitNegativeStock":true,"productWeight":0,"recommendedRetailPrice":0,"serialNumber":"","shippingWeight":0,"sku":"testartikel","sort":0,"stockLevel":{"productId":["932_212",0],"stockLevel":0},"supplierDeliveryTime":0,"supplierStockLevel":0,"taric":"","unNumber":"","upc":"","vat":0,"width":0,"attributes":[],"categories":[],"checksums":[],"configGroups":[],"customerGroupPackagingQuantities":[],"fileDownloads":[],"i18ns":[{"productId":["932_212",0],"deliveryStatus":"","description":"","languageISO":"ger","measurementUnitName":"","metaDescription":"","metaKeywords":"","name":"","shortDescription":"","titleTag":"","unitName":"","urlPath":""}],"invisibilities":[],"mediaFiles":[],"partsLists":[],"prices":[{"customerGroupId":["1",0],"customerId":["",0],"id":["932_212_0",0],"productId":["932_212",0],"items":[{"productPriceId":["932_212_0",0],"netPrice":0,"quantity":1}]},{"customerGroupId":["0",0],"customerId":["0",0],"id":["932_212_0",0],"productId":["932_212",0],"items":[{"productPriceId":["932_212_0",0],"netPrice":0,"quantity":0}]}],"specialPrices":[],"specifics":[],"varCombinations":[],"variations":[],"warehouseInfo":[]}],"error":null,"jtlrpc":"2.0","id":"7eb39e325899463aab726e043ff354cc"}
>>> Image.statistic: {
  "method": "Image.statistic",
  "params": {
    "limit": 0,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "bbd95ba428334b8cbefc948e3882e757"
}
<<< Image.statistic: {"result":{"available":2,"controllerName":"image"},"error":null,"jtlrpc":"2.0","id":"bbd95ba428334b8cbefc948e3882e757"}
>>> image.pull: {
  "method": "image.pull",
  "params": {
    "limit": 50,
    "filters": {}
  },
  "jtlrpc": "2.0",
  "id": "90b60754cc5a4598899a70d8e1777873"
}
<<< image.pull: {"result":[{"foreignKey":["_",0],"id":["a_348_",0],"filename":"http:\/\/store.xx.de\/","relationType":"product","remoteUrl":"http:\/\/store.xx.de\/","sort":2},{"foreignKey":["_",0],"id":["a_770_",0],"filename":"http:\/\/store.xx.de\/","relationType":"product","remoteUrl":"http:\/\/store.xx.de\/","sort":2}],"error":null,"jtlrpc":"2.0","id":"90b60754cc5a4598899a70d8e1777873"}
JTL-Wawi: End sync

 

[Daniel B.]

AW: Löschen von Artikeln in der WaWi - in Shopware unvollständig

Das sieht schwer danach aus, dass deine Datenbank inkonsistent ist.
Die Datenbank arbeitet mit Constraints, sobald ein Fremd PK eingetragen werden soll, den es jedoch nicht in der Haupttabelle gibt, dann knallt das SQL.
Bitte einmal ein Backup einspielen, den Connector deinstallieren und installieren und erneut versuchen.