You have no items in your shopping cart.

Profile: deaqlees@gmail.com

Avatar
Statistics

    - Error Row 1. Cannot insert the value NULL into column 'Id', table 'nopthree.dbo.Category'; column does not allow nulls. INSERT fails. The statement has been terminated.

    Thinking that the plugin sends the id for the category, I set it to prevent the category id from giving automatic values in the database, I don't think there is a problem in my xml table and plugin settings. I think that the plugin does not directly print the id drawn from the xml to the database.
    Can you help with this issue, I'm opening this topic because I don't have a chance to edit the plugin.

    <ArrayOfCategory xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
    <Category>
    <Id>1</Id>
    <Name>Grup</Name>
    <Parent i:nil="true"/>
    </Category>
    <Category>
    <Id>11</Id>
    <Name>Marka</Name>
    <Parent>1</Parent>
    </Category>
    <Category>
    <Id>111</Id>
    <Name>Model</Name>
    <Parent>11</Parent>
    </Category>
    <Category>
    <Id>1111</Id>
    <Name>Pozisyon</Name>
    <Parent>111</Parent>
    </Category>
    <Mapping>
    <Category>1111</Category>
    <Sku>123123</Sku>
    </Mapping>
    </ArrayOfCategory>

    Entity;  Category
    Entity Key (Product Key);    ID




    2 years ago

    This is the xml structure I created, so I send the images by separating them with commas, but it doesn't work, I don't have a problem when I send the image individually, but I have to send multiple.
    I saw that it worked once, I got a result in one of my tests. The xml structure was like this, but then it never worked again.

    2 years ago

    <ArrayOfOem xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
    <Oem>
    <Categories>JCB/3 CX -4 CX 2006-/2006-2020/Ön Kapı Camı/Sağ,Tümosan/Klasik Kabin/2000/Ön Kapı Camı/Sağ,Bmw/740/2019-2021/Ön Kapı Camı/Sağ,Bmw/740/2015-2018/Ön Kapı Camı/Sağ,Bmw/740/2009-2011/Ön Kapı Camı/Sağ,</Categories>
    <DisableBuy>true</DisableBuy>
    <ErpCode>123456E</ErpCode>
    <FullDescription><table style='width:100%'><tr><td>Marka-Model-Yıl: <br/>JCB-3 CX -4 CX 2006--2006-2020<br/>Tümosan-Klasik Kabin-2000<br/>Bmw-740-2019-2021<br/>Bmw-740-2015-2018<br/>Bmw-740-2009-2011</td></tr><tr><td>Özellik: Çıtalı-Ayna Demirli-Isıtmalı-</td></tr><tr><td>Ölçü:120.00 x 120.00</td></tr><tr><td>Üretici: OEM</td></tr><tr><td>Çapraz Referans:1234564hgu-123-123-OemNo22</td></tr><tr><td>Üretici Donanım Bilgisi: </td></tr><tr><td>Delik:5</td></tr><tr><td>Cam Tipi:Temperli</td></tr><tr><td>Cam Konumu:Ön Kapı Camı - Sağ</td></tr></table></FullDescription>
    <Height>100.00</Height>
    <Id>1-2-1-2-0000000004-49</Id>
    <Length>120.00</Length>
    <PartNumber>1234564hgu-123-123</PartNumber>
    <Picture>https://localhost:44397/assets/oemPhotos/placeholder-f5c39cf2b22248a5812e6c3493640994.jpg,https://localhost:44397/assets/oemPhotos/placeholder-f5c39cf2b22248a5812e6c3493640994.jpg,https://localhost:44397/assets/oemPhotos/placeholder-f5c39cf2b22248a5812e6c3493640994.jpg</Picture>
    <Price>12.3000</Price>
    <ProductLabel>1234564hgu-123-123,34-504-502,282828-37-35,343434-37-35,50672-37-35,51337268719-2467LGNH3FD,51357269561-2467LGNH5RVZ,</ProductLabel>
    <ProductName>Ön Kapı Camı-Sağ-Kırmızı-Beyaz-Temperli</ProductName>
    <Publish>true</Publish>
    <SearchForPrice>true</SearchForPrice>
    <ShippingEnabled>true</ShippingEnabled>
    <ShortDefinition>123</ShortDefinition>
    <Weight>1.61280000</Weight>
    <Width>120.00</Width>
    </Oem>
    </ArrayOfOem>



    2 years ago

    Powered by nopCommerce

    Copyright © 2023 FoxNetSoft. All rights reserved