Chilkat Online Tools

VB6 / PrestaShop Webservice Product Resource / Update product - complete update

Back to Collection Items

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp
Dim success As Long

http.BasicAuth = 1
http.Login = "{{webservice_key}}"
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>
' 

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

Dim sbRequestBody As New ChilkatStringBuilder
success = xml.GetXmlSb(sbRequestBody)

Dim resp As ChilkatHttpResponse
Set resp = http.PTextSb("PUT","https://localhost:8080/api/products/1",sbRequestBody,"utf-8","application/xml",0,0)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print resp.StatusCode
Debug.Print resp.BodyStr

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": [
  ]
}