3 Replies Latest reply on Feb 20, 2017 3:08 PM by TheBCMan

    Soap WSDL - Product_UpdateInsert failing for the last 6 days

    garyf65183822

      Hi for the last year I've been using a C# app to upload products to BC, using the CatalystEcommerceWebserviceSoap, WSDL and has been working fine, but since last week I can continue to download the full product list, but when i try to re-upload the same product list all product fails, With the message, "Server was unable to process request. ---> ERROR: Import process failed on record [0] and reported [ There was a system error. ]." then the usual error of 1) Mandatory columns, 2) right number of columns, 3) Line breaks appear at the end of each line and not within the line, product pricing etc.

       

      Has anyone else had a similar sort of issue or can suggest some ways to remedy it, I would have thought if the product is loaded in BC and all I'm doing is downloading it and re-uploading i would expect it to work, the client hasn't been able to help with any info to suggest a change or update that would have caused all products to no longer upload.

       

      Thanks in advance

        • 1. Re: Soap WSDL - Product_UpdateInsert failing for the last 6 days
          TheBCMan Adobe Community Professional

          Not having any issues here, take a look at the XML and make sure there isn't a syntax error or a stray < > messing things up. You might also want to try just one product and see if that sync's.

          • 2. Re: Soap WSDL - Product_UpdateInsert failing for the last 6 days
            garyf65183822 Level 1

            Thanks TheBCMan, but still no products can load, I've tried loading every item individually and all 1704 items fail, so I can't see how all worked one day and then all failed the next, it doesn't make sense.

            Below is the product details retrieved from BC, I then put the same data in the Product UpdateInsert and it fails, I would love to know if someone is able to load the exact below data into their BC system.

            <Product_RetrieveResult>

                        <productId>9904925</productId>

                        <productCode>51414138-3qtr-Alicia-Top-BLK</productCode>

                        <productName>3qtr Alicia Top</productName>

                        <description>Casual jersey top. Featuring an asymmetric hemline side hem drape jewel neckline 3/4 sleeves &amp; a double raw edge neck bind.</description>

                        <smallImage>/_assets/img/shop/51414138-3qtr-Alicia-Top-BLK-FR.jpg</smallImage>

                        <largeImage>/_assets/img/shop/51414138-3qtr-Alicia-Top-BLK-SW.jpg</largeImage>

                        <cataloguesArray>

                           <string>/Shop/Tops/</string>

                        </cataloguesArray>

                        <pricesSaleArray>

                           <string>AU/139.00</string>

                        </pricesSaleArray>

                        <pricesRetailArray>

                           <string>AU/139.00</string>

                        </pricesRetailArray>

                        <pricesWholesaleArray>

                           <string>AU/139.00</string>

                        </pricesWholesaleArray>

                        <wholesaleTaxCodeArray/>

                        <taxCodeArray/>

                        <groupProducts/>

                        <groupProductsDescriptions/>

                        <supplierCommission>0</supplierCommission>

                        <weight>20162099</weight>

                        <relatedProducts>

                           <string>1469-PARKA-VEST-BLK</string>

                           <string>1471-REVER-VEST-BLK</string>

                           <string>1622-NOMAD-TOP-BLK</string>

                           <string>51642-DREAM-BOAT-SHIRT-BLK</string>

                           <string>11636-SHARMAN-SHIRT-BLK</string>

                           <string>51627-CATALAN-TOP-BLK</string>

                        </relatedProducts>

                        <tags/>

                        <unitType/>

                        <minUnits>0</minUnits>

                        <maxUnits>0</maxUnits>

                        <inStock>94</inStock>

                        <onOrder>0</onOrder>

                        <reOrder>0</reOrder>

                        <inventoryControl>true</inventoryControl>

                        <canPreOrder>false</canPreOrder>

                        <custom1>BLACK</custom1>

                        <custom2>94% Viscose 6% Spandex   Warm hand wash Darks colours separately Do not bleach Do not tumble dry warm iron on reverse.  Dry cleanable.    Garment made in Australia</custom2>

                        <custom3/>

                        <custom4>51414138</custom4>

                        <popletImages>/_assets/img/shop/51414138-3qtr-Alicia-Top-BLK-FR.jpg;/_assets/img/shop/514 14138-3qtr-Alicia-Top-BLK-BA.jpg;/_assets/img/shop/51414138-3qtr-Alicia-Top-BLK-SI.jpg;/_a ssets/img/shop/51414138-3qtr-Alicia-Top-BLK-CR.jpg;</popletImages>

                        <captureDetails>false</captureDetails>

                        <downloadLimitCount>0</downloadLimitCount>

                        <limitDownloadsToIP>0</limitDownloadsToIP>

                        <isOnSale>false</isOnSale>

                        <hideIfNoStock>true</hideIfNoStock>

                        <productAttributes>Size*|5|Y:S|,M|,L|,XL|,XXL|</productAttributes>

                        <isGiftVoucher>false</isGiftVoucher>

                        <enableDropShipping>false</enableDropShipping>

                        <productWeight>0</productWeight>

                        <productWidth>0</productWidth>

                        <productHeight>0</productHeight>

                        <productDepth>0</productDepth>

                        <excludeFromSearch>false</excludeFromSearch>

                        <productTitle>3qtr Alicia Top</productTitle>

                        <cycletypeId>1</cycletypeId>

                        <cycletypeCount>-1</cycletypeCount>

                        <slug>51414138-3qtr-Alicia-Top-BLACK</slug>

                        <hasVariations>true</hasVariations>

                        <variations>

                           <ProductVariation>

                              <id>551669</id>

                              <options>S;</options>

                              <code>51414138-3qtrAliciaTop-BLK-S</code>

                              <enabled>true</enabled>

                              <inStock>21</inStock>

                              <onOrder>0</onOrder>

                           </ProductVariation>

                           <ProductVariation>

                              <id>551670</id>

                              <options>M;</options>

                              <code>51414138-3qtrAliciaTop-BLK-M</code>

                              <enabled>true</enabled>

                              <inStock>18</inStock>

                              <onOrder>0</onOrder>

                           </ProductVariation>

                           <ProductVariation>

                              <id>551671</id>

                              <options>L;</options>

                              <code>51414138-3qtrAliciaTop-BLK-L</code>

                              <enabled>true</enabled>

                              <inStock>14</inStock>

                              <onOrder>0</onOrder>

                           </ProductVariation>

                           <ProductVariation>

                              <id>551672</id>

                              <options>XL;</options>

                              <code>51414138-3qtrAliciaTop-BLK-XL</code>

                              <enabled>true</enabled>

                              <inStock>17</inStock>

                              <onOrder>0</onOrder>

                           </ProductVariation>

                           <ProductVariation>

                              <id>551673</id>

                              <options>XXL;</options>

                              <code>51414138-3qtrAliciaTop-BLK-XXL</code>

                              <enabled>true</enabled>

                              <inStock>24</inStock>

                              <onOrder>0</onOrder>

                           </ProductVariation>

                        </variations>

                        <roleResponsible/>

                        <metaDescription/>

                     </Product_RetrieveResult>

            • 3. Re: Soap WSDL - Product_UpdateInsert failing for the last 6 days
              TheBCMan Adobe Community Professional

              The format for Product_Update is different than the receive, if you are sending this XML to the product update end point it will fail. Take a look at the structure it needs (it is also case sensitive so be careful!)

               

              CatalystEcommerceWebservice Web Service