(Excel) Walmart - Update Inventory for an Item

Demonstrates how to update inventory for an item.

Note: This example requires Chilkat v9.5.0.67 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

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

' Sends the following PUT request:
' PUT https://marketplace.walmartapis.com/v2/inventory?sku={SKU}

Dim sbUrl As Chilkat.StringBuilder
Set sbUrl = Chilkat.NewStringBuilder

success = sbUrl.Append("https://marketplace.walmartapis.com/v2/inventory?sku={SKU}")

numReplaced = sbUrl.Replace("{SKU}","HOPP~904~51041")


requestMethod = "PUT"

' First we need to generate a signature for our request.
' The signature needs to be re-generated for each new Walmart HTTP request.
Dim authUtil As Chilkat.AuthUtil
Set authUtil = Chilkat.NewAuthUtil


wmConsumerId = "WALMART_CONSUMER_ID"

wmPrivateKey = "WALMART_PRIVATE_KEY"

jsonStr = authUtil.WalmartSignature(sbUrl.GetAsString(),wmConsumerId,wmPrivateKey,requestMethod)
If (authUtil.LastMethodSuccess <> True) Then
    Debug.Print authUtil.LastErrorText
    Exit Sub
End If

' The JSON returned by WalmartSignature contains the values to be used in the following
' header fields: WM_SEC.AUTH_SIGNATURE, WM_SEC.TIMESTAMP, and WM_QOS.CORRELATION_ID
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(jsonStr)

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.SetRequestHeader "WM_SVC.NAME","Walmart Marketplace"
http.SetRequestHeader "WM_QOS.CORRELATION_ID",json.StringOf("correlation_id")
http.SetRequestHeader "WM_SEC.TIMESTAMP",json.StringOf("timestamp")
http.SetRequestHeader "WM_SEC.AUTH_SIGNATURE",json.StringOf("signature")
http.SetRequestHeader "WM_CONSUMER.ID",wmConsumerId
http.Accept = "application/xml"

' Note: Do not explicitly set the "Host" header.  Chilkat will set it automatically.

' The body of the PUT request will be XML that looks like this:

' 	<?xml version="1.0" encoding="utf-8" ?>
' 	<wm:inventory xmlns:wm="http://walmart.com/">
' 	    <wm:sku>HOPP~904~51041</wm:sku>
' 	    <wm:quantity>
' 	        <wm:unit>EACH</wm:unit>
' 	        <wm:amount>235</wm:amount>
' 	    </wm:quantity>
' 	    <wm:fulfillmentLagTime>5</wm:fulfillmentLagTime>
' 	</wm:inventory>

' Build the XML request body:

originalAmount = 234

Dim xmlBody As Chilkat.Xml
Set xmlBody = Chilkat.NewXml
xmlBody.Tag = "wm:inventory"
success = xmlBody.AddAttribute("xmlns:wm","http://walmart.com/")
xmlBody.UpdateChildContent "wm:sku","HOPP~904~51041"
xmlBody.UpdateChildContent "wm:quantity|wm:unit","EACH"
xmlBody.UpdateChildContentInt "wm:quantity|wm:amount",originalAmount + 1
xmlBody.UpdateChildContent "wm:fulfillmentLagTime","5"

Debug.Print "PUT request body:"
Debug.Print xmlBody.GetXml()
Debug.Print "--"

' This is a simple PUT that can be sent w/ the PutText method.

xmlStr = http.PutText(sbUrl.GetAsString(),xmlBody.GetXml(),"utf-8","application/xml",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(xmlStr)

' A successful response should have a 200 response status
If (http.LastStatus <> 200) Then
    Debug.Print xml.GetXml()
    Debug.Print "Response Status Code: "; http.LastStatus
    Debug.Print "Failed."
    Exit Sub
End If

' A sample XML response is shown below..
Debug.Print xml.GetXml()
Debug.Print "--"
Debug.Print "Success!"

' ---------------------------------------
' Sample XML response
' ---------------------------------------

' <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
' <inventory xmlns="http://walmart.com/">
'     <sku>HOPP~904~51041</sku>
'     <quantity>
'         <unit>EACH</unit>
'         <amount>235</amount>
'     </quantity>
'     <fulfillmentLagTime>5</fulfillmentLagTime>
' </inventory>