(Excel) 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

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

' 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 Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
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",False)
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",True)
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"


Set resp = http.PostJson3("https://www.wixapis.com/stores/v1/products","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

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


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


productId = jResp.StringOf("product.id")

productName = jResp.StringOf("product.name")

productSlug = jResp.StringOf("product.slug")

productVisible = jResp.BoolOf("product.visible")

productProductType = jResp.StringOf("product.productType")

productDescription = jResp.StringOf("product.description")

productStockTrackInventory = jResp.BoolOf("product.stock.trackInventory")

productStockInStock = jResp.BoolOf("product.stock.inStock")

productPriceCurrency = jResp.StringOf("product.price.currency")

productPricePrice = jResp.StringOf("product.price.price")

productPriceDiscountedPrice = jResp.StringOf("product.price.discountedPrice")

productPriceFormattedPrice = jResp.StringOf("product.price.formatted.price")

productPriceFormattedDiscountedPrice = jResp.StringOf("product.price.formatted.discountedPrice")

productPriceDataCurrency = jResp.StringOf("product.priceData.currency")

productPriceDataPrice = jResp.StringOf("product.priceData.price")

productPriceDataDiscountedPrice = jResp.StringOf("product.priceData.discountedPrice")

productPriceDataFormattedPrice = jResp.StringOf("product.priceData.formatted.price")

productPriceDataFormattedDiscountedPrice = jResp.StringOf("product.priceData.formatted.discountedPrice")

productManageVariants = jResp.BoolOf("product.manageVariants")

productProductPageUrlBase = jResp.StringOf("product.productPageUrl.base")

productProductPageUrlPath = jResp.StringOf("product.productPageUrl.path")

productNumericId = jResp.StringOf("product.numericId")

productInventoryItemId = jResp.StringOf("product.inventoryItemId")

productDiscountType = jResp.StringOf("product.discount.type")

productDiscountValue = jResp.IntOf("product.discount.value")

i = 0

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