(Excel) Shopware 6 - Create Product

See more Shopware 6 Examples

Create a new product.

For more information, see https://docs.shopware.com/en/shopware-platform-dev-en/admin-api-guide/writing-entities#creating-entities

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' Sends the following POST

' POST /api/v3/product/
' {
'     "name" : "Test123",
'     "productNumber" : "random",
'     "stock" : 10,
'     "price" : [
'         {
'             "currencyId" : "b7d2554b0ce847cd82f3ac9bd1c0dfca", 
'             "gross": 15, 
'             "net": 10, 
'             "linked" : false
'         }
'     ],
'     "tax" : {
'         "name": "test", 
'         "taxRate": 15
'     }    
' }

' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON

' Create a product named "Test123"
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("name","Test123")
success = json.UpdateString("productNumber","XYZ-1234")
success = json.UpdateInt("stock",10)
success = json.UpdateString("price[0].currencyId","b7d2554b0ce847cd82f3ac9bd1c0dfca")
success = json.UpdateInt("price[0].gross",15)
success = json.UpdateInt("price[0].net",10)
success = json.UpdateBool("price[0].linked",False)
success = json.UpdateString("tax.name","test")
success = json.UpdateInt("tax.taxRate",15)

' Load the access token previously obtained in Shopware 6 OAuth2 Client Credentials
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject
success = jsonToken.LoadFile("qa_data/tokens/shopware6.json")

' This causes the "Authorization: Bearer <access_token>" header to be added.
http.AuthToken = jsonToken.StringOf("access_token")


Set resp = http.PostJson3("https://my-shopware-6-shop.de/api/v3/product","application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

' A successful response is a 204 response status code with an empty response body.
Debug.Print "Response Body:"
Debug.Print jResp.Emit()

' If we get a 401 response, it may be that our access token expired and we need to fetch a new one.

respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If