Chilkat Online Tools

SQL Server / PrestaShop Webservice Product Resource / Update product - complete update

Back to Collection Items

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @http int
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    EXEC sp_OASetProperty @http, 'BasicAuth', 1
    EXEC sp_OASetProperty @http, 'Login', '{{webservice_key}}'
    EXEC sp_OASetProperty @http, 'Password', 'password'

    -- Use this online tool to generate code from sample XML: Generate Code to Create XML

    -- The following XML is sent in the request body.

    -- <?xml version="1.0" encoding="UTF-8"?>
    -- <prestashop xmlns:xlink="http://www.w3.org/1999/xlink">
    --     <product>
    --         <id>{{product_id}}</id>
    --         <id_manufacturer><![CDATA[1]]></id_manufacturer>
    --         <id_supplier><![CDATA[1]]></id_supplier>
    --         <id_category_default><![CDATA[1]]></id_category_default>
    --         <new><![CDATA[1]]></new>
    --         <cache_default_attribute><![CDATA[1]]></cache_default_attribute>
    --         <id_default_image><![CDATA[1]]></id_default_image>
    --         <id_default_combination><![CDATA[1]]></id_default_combination>
    --         <id_tax_rules_group><![CDATA[1]]></id_tax_rules_group>
    --         <type><![CDATA[1]]></type>
    --         <id_shop_default><![CDATA[1]]></id_shop_default>
    --         <reference><![CDATA[123456]]></reference>
    --         <supplier_reference><![CDATA[ABCDEF]]></supplier_reference>
    --         <location><![CDATA[123]]></location>
    --         <width><![CDATA[12]]></width>
    --         <height><![CDATA[24]]></height>
    --         <depth><![CDATA[36]]></depth>
    --         <weight><![CDATA[48]]></weight>
    --         <quantity_discount><![CDATA[0]]></quantity_discount>
    --         <ean13><![CDATA[1231231231231]]></ean13>
    --         <isbn/>
    --         <upc/>
    --         <mpn><![CDATA[123456]]></mpn>
    --         <cache_is_pack><![CDATA[0]]></cache_is_pack>
    --         <cache_has_attachments><![CDATA[0]]></cache_has_attachments>
    --         <is_virtual/>
    --         <state><![CDATA[1]]></state>
    --         <additional_delivery_times/>
    --         <delivery_in_stock>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </delivery_in_stock>
    --         <delivery_out_stock>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </delivery_out_stock>
    --         <product_type><![CDATA[standard]]></product_type>
    --         <on_sale><![CDATA[0]]></on_sale>
    --         <online_only><![CDATA[0]]></online_only>
    --         <ecotax><![CDATA[0]]></ecotax>
    --         <minimal_quantity><![CDATA[0]]></minimal_quantity>
    --         <low_stock_threshold><![CDATA[0]]></low_stock_threshold>
    --         <low_stock_alert><![CDATA[0]]></low_stock_alert>
    --         <price><![CDATA[123.45]]></price>
    --         <wholesale_price><![CDATA[200]]></wholesale_price>
    --         <unity/>
    --         <unit_price><![CDATA[123.45]]></unit_price>
    --         <unit_price_ratio/>
    --         <additional_shipping_cost/>
    --         <customizable/>
    --         <text_fields/>
    --         <uploadable_files/>
    --         <active><![CDATA[1]]></active>
    --         <redirect_type/>
    --         <id_type_redirected/>
    --         <available_for_order><![CDATA[1]]></available_for_order>
    --         <available_date/>
    --         <show_condition/>
    --         <condition/>
    --         <show_price/>
    --         <indexed/>
    --         <visibility/>
    --         <advanced_stock_management/>
    --         <pack_stock_type/>
    --         <meta_description>
    --             <language id="1"><![CDATA[Description]]></language>
    --             <language id="2"><![CDATA[Description]]></language>
    --         </meta_description>
    --         <meta_keywords>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </meta_keywords>
    --         <meta_title>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </meta_title>
    --         <link_rewrite>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </link_rewrite>
    --         <name>
    --             <language id="1"><![CDATA[Product Name]]></language>
    --             <language id="2"><![CDATA[Product Name]]></language>
    --         </name>
    --         <description>
    --             <language id="1"><![CDATA[Description]]></language>
    --             <language id="2"><![CDATA[Description]]></language>
    --         </description>
    --         <description_short>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </description_short>
    --         <available_now>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </available_now>
    --         <available_later>
    --             <language id="1"/>
    --             <language id="2"/>
    --         </available_later>
    --         <associations>
    --             <categories>
    --                 <category>
    --                     <id><![CDATA[1]]></id>
    --                 </category>
    --             </categories>
    --             <images>
    --                 <image>
    --                     <id><![CDATA[1]]></id>
    --                 </image>
    --             </images>
    --         </associations>
    --     </product>
    -- </prestashop>
    -- 

    DECLARE @xml int
    -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT

    EXEC sp_OASetProperty @xml, 'Tag', 'prestashop'
    EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns:xlink', 'http://www.w3.org/1999/xlink'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|id', '{{product_id}}'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_manufacturer', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_supplier', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_category_default', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|new', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|cache_default_attribute', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_default_image', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_default_combination', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_tax_rules_group', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|type', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|id_shop_default', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|reference', 123456
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|supplier_reference', 'ABCDEF'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|location', 123
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|width', 12
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|height', 24
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|depth', 36
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|weight', 48
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|quantity_discount', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|ean13', '1231231231231'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|isbn', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|upc', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|mpn', 123456
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|cache_is_pack', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|cache_has_attachments', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|is_virtual', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|state', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|additional_delivery_times', ''
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|delivery_in_stock|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|delivery_in_stock|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|delivery_out_stock|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|delivery_out_stock|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|product_type', 'standard'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|on_sale', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|online_only', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|ecotax', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|minimal_quantity', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|low_stock_threshold', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|low_stock_alert', 0
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|price', '123.45'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|wholesale_price', 200
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|unity', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|unit_price', '123.45'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|unit_price_ratio', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|additional_shipping_cost', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|customizable', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|text_fields', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|uploadable_files', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|active', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|redirect_type', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|id_type_redirected', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|available_for_order', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|available_date', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|show_condition', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|condition', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|show_price', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|indexed', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|visibility', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|advanced_stock_management', ''
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|pack_stock_type', ''
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|meta_description|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|meta_description|language', 'Description'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|meta_description|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|meta_description|language[1]', 'Description'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|meta_keywords|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|meta_keywords|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|meta_title|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|meta_title|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|link_rewrite|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|link_rewrite|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|name|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|name|language', 'Product Name'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|name|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|name|language[1]', 'Product Name'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|description|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|description|language', 'Description'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|description|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'product|description|language[1]', 'Description'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|description_short|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|description_short|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|available_now|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|available_now|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|available_later|language', 1, 'id', '1'
    EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'product|available_later|language[1]', 1, 'id', '2'
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|associations|categories|category|id', 1
    EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'product|associations|images|image|id', 1

    DECLARE @sbRequestBody int
    -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbRequestBody OUT

    EXEC sp_OAMethod @xml, 'GetXmlSb', @success OUT, @sbRequestBody

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PTextSb', @resp OUT, 'PUT', 'https://localhost:8080/api/products/1', @sbRequestBody, 'utf-8', 'application/xml', 0, 0
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @xml
        EXEC @hr = sp_OADestroy @sbRequestBody
        RETURN
      END

    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    PRINT @iTmp0
    EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
    PRINT @sTmp0
    EXEC @hr = sp_OADestroy @resp


    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @xml
    EXEC @hr = sp_OADestroy @sbRequestBody


END
GO

Curl Command

curl -X PUT
	-u '{{webservice_key}}:password'
	-d '<?xml version="1.0" encoding="UTF-8"?>
<prestashop xmlns:xlink="http://www.w3.org/1999/xlink">
<product>
    <id>{{product_id}}</id>
	<id_manufacturer><![CDATA[1]]></id_manufacturer>
	<id_supplier><![CDATA[1]]></id_supplier>
	<id_category_default><![CDATA[1]]></id_category_default>
	<new><![CDATA[1]]></new>
	<cache_default_attribute><![CDATA[1]]></cache_default_attribute>
	<id_default_image><![CDATA[1]]></id_default_image>
	<id_default_combination><![CDATA[1]]></id_default_combination>
	<id_tax_rules_group><![CDATA[1]]></id_tax_rules_group>
	<type><![CDATA[1]]></type>
	<id_shop_default><![CDATA[1]]></id_shop_default>
	<reference><![CDATA[123456]]></reference>
	<supplier_reference><![CDATA[ABCDEF]]></supplier_reference>
	<location><![CDATA[123]]></location>
	<width><![CDATA[12]]></width>
	<height><![CDATA[24]]></height>
	<depth><![CDATA[36]]></depth>
	<weight><![CDATA[48]]></weight>
	<quantity_discount><![CDATA[0]]></quantity_discount>
	<ean13><![CDATA[1231231231231]]></ean13>
	<isbn><![CDATA[]]></isbn>
	<upc><![CDATA[]]></upc>
	<mpn><![CDATA[123456]]></mpn>
	<cache_is_pack><![CDATA[0]]></cache_is_pack>
	<cache_has_attachments><![CDATA[0]]></cache_has_attachments>
	<is_virtual><![CDATA[]]></is_virtual>
	<state><![CDATA[1]]></state>
	<additional_delivery_times><![CDATA[]]></additional_delivery_times>
	<delivery_in_stock><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></delivery_in_stock>
	<delivery_out_stock><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></delivery_out_stock>
	<product_type><![CDATA[standard]]></product_type>
	<on_sale><![CDATA[0]]></on_sale>
	<online_only><![CDATA[0]]></online_only>
	<ecotax><![CDATA[0]]></ecotax>
	<minimal_quantity><![CDATA[0]]></minimal_quantity>
	<low_stock_threshold><![CDATA[0]]></low_stock_threshold>
	<low_stock_alert><![CDATA[0]]></low_stock_alert>
	<price><![CDATA[123.45]]></price>
	<wholesale_price><![CDATA[200]]></wholesale_price>
	<unity><![CDATA[]]></unity>
	<unit_price><![CDATA[123.45]]></unit_price>
	<unit_price_ratio><![CDATA[]]></unit_price_ratio>
	<additional_shipping_cost><![CDATA[]]></additional_shipping_cost>
	<customizable><![CDATA[]]></customizable>
	<text_fields><![CDATA[]]></text_fields>
	<uploadable_files><![CDATA[]]></uploadable_files>
	<active><![CDATA[1]]></active>
	<redirect_type><![CDATA[]]></redirect_type>
	<id_type_redirected><![CDATA[]]></id_type_redirected>
	<available_for_order><![CDATA[1]]></available_for_order>
	<available_date><![CDATA[]]></available_date>
	<show_condition><![CDATA[]]></show_condition>
	<condition><![CDATA[]]></condition>
	<show_price><![CDATA[]]></show_price>
	<indexed><![CDATA[]]></indexed>
	<visibility><![CDATA[]]></visibility>
	<advanced_stock_management><![CDATA[]]></advanced_stock_management>
	<pack_stock_type><![CDATA[]]></pack_stock_type>
	<meta_description><language id="1"><![CDATA[Description]]></language><language id="2"><![CDATA[Description]]></language></meta_description>
	<meta_keywords><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></meta_keywords>
	<meta_title><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></meta_title>
	<link_rewrite><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></link_rewrite>
	<name><language id="1"><![CDATA[Product Name]]></language><language id="2"><![CDATA[Product Name]]></language></name>
	<description><language id="1"><![CDATA[Description]]></language><language id="2"><![CDATA[Description]]></language></description>
	<description_short><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></description_short>
	<available_now><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></available_now>
	<available_later><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></available_later>
<associations>
<categories>
	<category>
	<id><![CDATA[1]]></id>
	</category>
</categories>
<images>
	<image>
	<id><![CDATA[1]]></id>
	</image>
</images>
</associations>
</product>
</prestashop>'
https://localhost:8080/api/products/1

Postman Collection Item JSON

{
  "name": "Update product - complete update",
  "request": {
    "method": "PUT",
    "header": [
    ],
    "body": {
      "mode": "raw",
      "raw": "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<prestashop xmlns:xlink=\"http://www.w3.org/1999/xlink\">\n<product>\n    <id>{{product_id}}</id>\n\t<id_manufacturer><![CDATA[1]]></id_manufacturer>\n\t<id_supplier><![CDATA[1]]></id_supplier>\n\t<id_category_default><![CDATA[1]]></id_category_default>\n\t<new><![CDATA[1]]></new>\n\t<cache_default_attribute><![CDATA[1]]></cache_default_attribute>\n\t<id_default_image><![CDATA[1]]></id_default_image>\n\t<id_default_combination><![CDATA[1]]></id_default_combination>\n\t<id_tax_rules_group><![CDATA[1]]></id_tax_rules_group>\n\t<type><![CDATA[1]]></type>\n\t<id_shop_default><![CDATA[1]]></id_shop_default>\n\t<reference><![CDATA[123456]]></reference>\n\t<supplier_reference><![CDATA[ABCDEF]]></supplier_reference>\n\t<location><![CDATA[123]]></location>\n\t<width><![CDATA[12]]></width>\n\t<height><![CDATA[24]]></height>\n\t<depth><![CDATA[36]]></depth>\n\t<weight><![CDATA[48]]></weight>\n\t<quantity_discount><![CDATA[0]]></quantity_discount>\n\t<ean13><![CDATA[1231231231231]]></ean13>\n\t<isbn><![CDATA[]]></isbn>\n\t<upc><![CDATA[]]></upc>\n\t<mpn><![CDATA[123456]]></mpn>\n\t<cache_is_pack><![CDATA[0]]></cache_is_pack>\n\t<cache_has_attachments><![CDATA[0]]></cache_has_attachments>\n\t<is_virtual><![CDATA[]]></is_virtual>\n\t<state><![CDATA[1]]></state>\n\t<additional_delivery_times><![CDATA[]]></additional_delivery_times>\n\t<delivery_in_stock><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></delivery_in_stock>\n\t<delivery_out_stock><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></delivery_out_stock>\n\t<product_type><![CDATA[standard]]></product_type>\n\t<on_sale><![CDATA[0]]></on_sale>\n\t<online_only><![CDATA[0]]></online_only>\n\t<ecotax><![CDATA[0]]></ecotax>\n\t<minimal_quantity><![CDATA[0]]></minimal_quantity>\n\t<low_stock_threshold><![CDATA[0]]></low_stock_threshold>\n\t<low_stock_alert><![CDATA[0]]></low_stock_alert>\n\t<price><![CDATA[123.45]]></price>\n\t<wholesale_price><![CDATA[200]]></wholesale_price>\n\t<unity><![CDATA[]]></unity>\n\t<unit_price><![CDATA[123.45]]></unit_price>\n\t<unit_price_ratio><![CDATA[]]></unit_price_ratio>\n\t<additional_shipping_cost><![CDATA[]]></additional_shipping_cost>\n\t<customizable><![CDATA[]]></customizable>\n\t<text_fields><![CDATA[]]></text_fields>\n\t<uploadable_files><![CDATA[]]></uploadable_files>\n\t<active><![CDATA[1]]></active>\n\t<redirect_type><![CDATA[]]></redirect_type>\n\t<id_type_redirected><![CDATA[]]></id_type_redirected>\n\t<available_for_order><![CDATA[1]]></available_for_order>\n\t<available_date><![CDATA[]]></available_date>\n\t<show_condition><![CDATA[]]></show_condition>\n\t<condition><![CDATA[]]></condition>\n\t<show_price><![CDATA[]]></show_price>\n\t<indexed><![CDATA[]]></indexed>\n\t<visibility><![CDATA[]]></visibility>\n\t<advanced_stock_management><![CDATA[]]></advanced_stock_management>\n\t<pack_stock_type><![CDATA[]]></pack_stock_type>\n\t<meta_description><language id=\"1\"><![CDATA[Description]]></language><language id=\"2\"><![CDATA[Description]]></language></meta_description>\n\t<meta_keywords><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></meta_keywords>\n\t<meta_title><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></meta_title>\n\t<link_rewrite><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></link_rewrite>\n\t<name><language id=\"1\"><![CDATA[Product Name]]></language><language id=\"2\"><![CDATA[Product Name]]></language></name>\n\t<description><language id=\"1\"><![CDATA[Description]]></language><language id=\"2\"><![CDATA[Description]]></language></description>\n\t<description_short><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></description_short>\n\t<available_now><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></available_now>\n\t<available_later><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></available_later>\n<associations>\n<categories>\n\t<category>\n\t<id><![CDATA[1]]></id>\n\t</category>\n</categories>\n<images>\n\t<image>\n\t<id><![CDATA[1]]></id>\n\t</image>\n</images>\n</associations>\n</product>\n</prestashop>"
    },
    "url": {
      "raw": "{{webservice_url}}/api/products/{{product_id}}",
      "host": [
        "{{webservice_url}}"
      ],
      "path": [
        "api",
        "products",
        "{{product_id}}"
      ]
    }
  },
  "response": [
  ]
}