(Visual Basic 6.0) WiX Create Product

Creates a new product.

Note: If you get a 403 error response, try refreshing the access token.

For more information, see https://dev.wix.com/api/rest/wix-stores/catalog/product/create-product

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

' 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

' Implements the following CURL command:

' curl -X POST \
'    'https://www.wixapis.com/stores/v1/products' \
'     --data-binary '{
'                      "product": {
'                        "name": "T-shirt",
'                        "productType": "physical",
'                        "priceData": {
'                          "price": 10.5
'                        },
'                        "description": "nice summer t-shirt",
'                        "sku": "123df",
'                        "visible": false,
'                        "weight": 0.2,
'                        "discount": {
'                        	"type": "AMOUNT",
'                        	"value": 1
'                        },
'                        "manageVariants": true,
'                        "productOptions": [
'                          {
'                            "name": "Size",
'                            "choices": [
'                              {
'                                "value": "S",
'                                "description": "S"
'                              },
'                              {
'                                "value": "L",
'                                "description": "L"
'                              }
'                            ]
'                          }
'                        ]
'                      }
'                    }' \
'    -H 'Content-Type: application/json' \
'    -H 'Authorization: <AUTH>'

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

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

' The following JSON is sent in the request body.

' {
'   "product": {
'     "name": "T-shirt",
'     "productType": "physical",
'     "priceData": {
'       "price": 10.5
'     },
'     "description": "nice summer t-shirt",
'     "sku": "123df",
'     "visible": false,
'     "weight": 0.2,
'     "discount": {
'       "type": "AMOUNT",
'       "value": 1
'     },
'     "manageVariants": true,
'     "productOptions": [
'       {
'         "name": "Size",
'         "choices": [
'           {
'             "value": "S",
'             "description": "S"
'           },
'           {
'             "value": "L",
'             "description": "L"
'           }
'         ]
'       }
'     ]
'   }
' }

Dim json As New ChilkatJsonObject
success = json.UpdateString("product.name","T-shirt")
success = json.UpdateString("product.productType","physical")
success = json.UpdateNumber("product.priceData.price","10.5")
success = json.UpdateString("product.description","nice summer t-shirt")
success = json.UpdateString("product.sku","123df")
success = json.UpdateBool("product.visible",0)
success = json.UpdateNumber("product.weight","0.2")
success = json.UpdateString("product.discount.type","AMOUNT")
success = json.UpdateInt("product.discount.value",1)
success = json.UpdateBool("product.manageVariants",1)
success = json.UpdateString("product.productOptions[0].name","Size")
success = json.UpdateString("product.productOptions[0].choices[0].value","S")
success = json.UpdateString("product.productOptions[0].choices[0].description","S")
success = json.UpdateString("product.productOptions[0].choices[1].value","L")
success = json.UpdateString("product.productOptions[0].choices[1].description","L")

http.AuthToken = "ACCESS_TOKEN"
http.SetRequestHeader "Content-Type","application/json"

Dim resp As ChilkatHttpResponse
Set resp = http.PostJson3("https://www.wixapis.com/stores/v1/products","application/json",json)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As New ChilkatStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

Dim respStatusCode As Long
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

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "product": {
'     "id": "e28e4ddd-6ed0-4098-a5e5-cf4bd9c4f7b5",
'     "name": "T-shirt",
'     "slug": "t-shirt-1",
'     "visible": false,
'     "productType": "physical",
'     "description": "nice summer t-shirt",
'     "stock": {
'       "trackInventory": false,
'       "inStock": true
'     },
'     "price": {
'       "currency": "ILS",
'       "price": 10.5,
'       "discountedPrice": 9.5,
'       "formatted": {
'         "price": "10.50",
'         "discountedPrice": "9.50"
'       }
'     },
'     "priceData": {
'       "currency": "ILS",
'       "price": 10.5,
'       "discountedPrice": 9.5,
'       "formatted": {
'         "price": "10.50",
'         "discountedPrice": "9.50"
'       }
'     },
'     "additionalInfoSections": [
'     ],
'     "ribbons": [
'     ],
'     "media": {
'       "items": [
'       ]
'     },
'     "customTextFields": [
'     ],
'     "manageVariants": true,
'     "productOptions": [
'       {
'         "optionType": "drop_down",
'         "name": "Size",
'         "choices": [
'           {
'             "value": "S",
'             "description": "S",
'             "inStock": true,
'             "visible": true
'           },
'           {
'             "value": "L",
'             "description": "L",
'             "inStock": true,
'             "visible": true
'           }
'         ]
'       }
'     ],
'     "productPageUrl": {
'       "base": "https://www.itsjusttooeasy123.com/",
'       "path": "/product-page/t-shirt-1"
'     },
'     "numericId": "1567588455405000",
'     "inventoryItemId": "1d71b222-912f-bf67-5a1a-30b4263b084a",
'     "discount": {
'       "type": "AMOUNT",
'       "value": 1
'     },
'     "collectionIds": [
'     ],
'     "variants": [
'       {
'         "id": "00000000-0000-0001-0005-93fc95e0514a",
'         "choices": {
'           "Size": "S"
'         },
'         "variant": {
'           "priceData": {
'             "currency": "ILS",
'             "price": 10.5,
'             "discountedPrice": 9.5,
'             "formatted": {
'               "price": "10.50",
'               "discountedPrice": "9.50"
'             }
'           },
'           "weight": 10,
'           "visible": true
'         }
'       },
'       {
'         "id": "00000000-0000-0002-0005-93fc95e0514a",
'         "choices": {
'           "Size": "L"
'         },
'         "variant": {
'           "priceData": {
'             "currency": "ILS",
'             "price": 10.5,
'             "discountedPrice": 9.5,
'             "formatted": {
'               "price": "10.50",
'               "discountedPrice": "9.50"
'             }
'           },
'           "visible": true
'         }
'       }
'     ]
'   }
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON

Dim optionType As String
Dim name As String
Dim j As Long
Dim count_j As Long
Dim value As String
Dim description As String
Dim inStock As Long
Dim visible As Long
Dim id As String
Dim choicesSize As String
Dim variantPriceDataCurrency As String
Dim variantPriceDataPrice As String
Dim variantPriceDataDiscountedPrice As String
Dim variantPriceDataFormattedPrice As String
Dim variantPriceDataFormattedDiscountedPrice As String
Dim variantWeight As Long
Dim variantVisible As Long

Dim productId As String
productId = jResp.StringOf("product.id")
Dim productName As String
productName = jResp.StringOf("product.name")
Dim productSlug As String
productSlug = jResp.StringOf("product.slug")
Dim productVisible As Long
productVisible = jResp.BoolOf("product.visible")
Dim productProductType As String
productProductType = jResp.StringOf("product.productType")
Dim productDescription As String
productDescription = jResp.StringOf("product.description")
Dim productStockTrackInventory As Long
productStockTrackInventory = jResp.BoolOf("product.stock.trackInventory")
Dim productStockInStock As Long
productStockInStock = jResp.BoolOf("product.stock.inStock")
Dim productPriceCurrency As String
productPriceCurrency = jResp.StringOf("product.price.currency")
Dim productPricePrice As String
productPricePrice = jResp.StringOf("product.price.price")
Dim productPriceDiscountedPrice As String
productPriceDiscountedPrice = jResp.StringOf("product.price.discountedPrice")
Dim productPriceFormattedPrice As String
productPriceFormattedPrice = jResp.StringOf("product.price.formatted.price")
Dim productPriceFormattedDiscountedPrice As String
productPriceFormattedDiscountedPrice = jResp.StringOf("product.price.formatted.discountedPrice")
Dim productPriceDataCurrency As String
productPriceDataCurrency = jResp.StringOf("product.priceData.currency")
Dim productPriceDataPrice As String
productPriceDataPrice = jResp.StringOf("product.priceData.price")
Dim productPriceDataDiscountedPrice As String
productPriceDataDiscountedPrice = jResp.StringOf("product.priceData.discountedPrice")
Dim productPriceDataFormattedPrice As String
productPriceDataFormattedPrice = jResp.StringOf("product.priceData.formatted.price")
Dim productPriceDataFormattedDiscountedPrice As String
productPriceDataFormattedDiscountedPrice = jResp.StringOf("product.priceData.formatted.discountedPrice")
Dim productManageVariants As Long
productManageVariants = jResp.BoolOf("product.manageVariants")
Dim productProductPageUrlBase As String
productProductPageUrlBase = jResp.StringOf("product.productPageUrl.base")
Dim productProductPageUrlPath As String
productProductPageUrlPath = jResp.StringOf("product.productPageUrl.path")
Dim productNumericId As String
productNumericId = jResp.StringOf("product.numericId")
Dim productInventoryItemId As String
productInventoryItemId = jResp.StringOf("product.inventoryItemId")
Dim productDiscountType As String
productDiscountType = jResp.StringOf("product.discount.type")
Dim productDiscountValue As Long
productDiscountValue = jResp.IntOf("product.discount.value")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("product.additionalInfoSections")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("product.ribbons")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("product.media.items")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("product.customTextFields")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("product.productOptions")
Do While i < count_i
    jResp.I = i
    optionType = jResp.StringOf("product.productOptions[i].optionType")
    name = jResp.StringOf("product.productOptions[i].name")
    j = 0
    count_j = jResp.SizeOfArray("product.productOptions[i].choices")
    Do While j < count_j
        jResp.J = j
        value = jResp.StringOf("product.productOptions[i].choices[j].value")
        description = jResp.StringOf("product.productOptions[i].choices[j].description")
        inStock = jResp.BoolOf("product.productOptions[i].choices[j].inStock")
        visible = jResp.BoolOf("product.productOptions[i].choices[j].visible")
        j = j + 1
    Loop
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("product.collectionIds")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("product.variants")
Do While i < count_i
    jResp.I = i
    id = jResp.StringOf("product.variants[i].id")
    choicesSize = jResp.StringOf("product.variants[i].choices.Size")
    variantPriceDataCurrency = jResp.StringOf("product.variants[i].variant.priceData.currency")
    variantPriceDataPrice = jResp.StringOf("product.variants[i].variant.priceData.price")
    variantPriceDataDiscountedPrice = jResp.StringOf("product.variants[i].variant.priceData.discountedPrice")
    variantPriceDataFormattedPrice = jResp.StringOf("product.variants[i].variant.priceData.formatted.price")
    variantPriceDataFormattedDiscountedPrice = jResp.StringOf("product.variants[i].variant.priceData.formatted.discountedPrice")
    variantWeight = jResp.IntOf("product.variants[i].variant.weight")
    variantVisible = jResp.BoolOf("product.variants[i].variant.visible")
    i = i + 1
Loop