(Excel) Walmart - Update bulk inventory

See Update bulk inventory for more information about this call.

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 POST request:
' POST https://marketplace.walmartapis.com/v2/feeds?feedType=inventory


url = "https://marketplace.walmartapis.com/v2/feeds?feedType=inventory"


requestMethod = "POST"

' 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(url,wmConsumerId,wmPrivateKey,requestMethod)
If (authUtil.LastMethodSuccess <> True) Then
    Debug.Print authUtil.LastErrorText
    Exit Sub
End If

' Build the HTTP POST request.
Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.ContentType = "multipart/form-data"
req.Path = "/v2/feeds?feedType=inventory"
req.AddHeader "Accept","application/xml"

' 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)

req.AddHeader "WM_SVC.NAME","Walmart Marketplace"
req.AddHeader "WM_QOS.CORRELATION_ID",json.StringOf("correlation_id")
req.AddHeader "WM_SEC.TIMESTAMP",json.StringOf("timestamp")
req.AddHeader "WM_SEC.AUTH_SIGNATURE",json.StringOf("signature")
req.AddHeader "WM_CONSUMER.ID",wmConsumerId
'  Note: Make sure to replace "WALMART_CHANNEL_TYPE" with the actual value for your seller account...
req.AddHeader "WM_CONSUMER.CHANNEL.TYPE","WALMART_CHANNEL_TYPE"

' The body of the POST will contain XML.  In this example, we'll load the XML
' from a file.  The XML contains inventory data that looks something like this:

' <InventoryFeed xmlns="http://walmart.com/">
'   <InventoryHeader>
'       <version>1.4</version>
'   </InventoryHeader>
'   <inventory>
'       <sku>1068155</sku>
'       <quantity>
'           <unit>EACH</unit>
'           <amount>10</amount>
'       </quantity>
'       <fulfillmentLagTime>1</fulfillmentLagTime>
'   </inventory>
'   <inventory>
'       <sku>10210321</sku>
'       <quantity>
'           <unit>EACH</unit>
'           <amount>20</amount>
'       </quantity>
'       <fulfillmentLagTime>3</fulfillmentLagTime>
'   </inventory>
' </InventoryFeed>

success = req.AddFileForUpload2("inventory","qa_data/walmart/inventory.xml","application/xml")
If (success <> True) Then
    Debug.Print req.LastErrorText
    Exit Sub
End If

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

Set resp = http.SynchronousRequest("marketplace.walmartapis.com",443,True,req)
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(resp.BodyStr)

' A successful response should have a 200 response status
If (resp.StatusCode <> 200) Then
    Debug.Print xml.GetXml()
    Debug.Print "Response Status Code: "; resp.StatusCode
    Debug.Print "Failed."

    Exit Sub
End If

' Show the XML response..
Debug.Print xml.GetXml()
Debug.Print "--"
Debug.Print "Success!"