SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab( JsonData VARCHAR(8000) );
INSERT INTO tab VALUES('{
  "Products": [ 
  {
    "id": 4379711799354,
    "variant_id": 31291380727866,
    "title": "*NEW* Kayslin Sneaker in Blush",
    "quantity": 1,
    "sku": "79000212",
    "variant_title": "3Y",
    "vendor": "TESTVENDOR",
    "fulfillment_service": "manual",
    "product_id": 4371426607162,
    "requires_shipping": true,
    "taxable": true,
    "gift_card": false,
    "name": "*NEW* Kayslin Sneaker in Blush - 3Y",
    "variant_inventory_management": "shopify",
    "properties": [
      {
        "name": "Item Ships Separately",
        "value": "ABC"
      }
    ]
    }
,
  {
    "id": 4379711832122,
    "variant_id": 31031946838074,
    "title": "*NEW* Mama Bird Necklace Set in Gold",
    "quantity": 1,
    "sku": "83000109",
    "variant_title": "",
    "vendor": "TESTVENDOR",
    "fulfillment_service": "manual",
    "product_id": 4320751878202,
    "requires_shipping": true,
    "taxable": true,
    "gift_card": false,
    "name": "*NEW* Mama Bird Necklace Set in Gold",
    "variant_inventory_management": "shopify",
    "properties": [],
    "product_exists": true,
    "fulfillable_quantity": 0,
    "grams": 113,
    "price": "29.50",
    "total_discount": "0.00",
    "fulfillment_status": "fulfilled",
    "pre_tax_price": "29.50",
    "price_set": {
      "shop_money": {
        "amount": "29.50",
        "currency_code": "USD"
      },
      "presentment_money": {
        "amount": "29.50",
        "currency_code": "USD"
      }
    },
    "pre_tax_price_set": {
      "shop_money": {
        "amount": "29.50",
        "currency_code": "USD"
      },
      "presentment_money": {
        "amount": "29.50",
        "currency_code": "USD"
      }
    },
    "total_discount_set": {
      "shop_money": {
        "amount": "0.00",
        "currency_code": "USD"
      },
      "presentment_money": {
        "amount": "0.00",
        "currency_code": "USD"
      }
    } } ] }');
  
1 rows affected

SELECT Q2.*
  FROM tab
 CROSS APPLY OPENJSON(JsonData,'$.Products')
             WITH (
                    Products nvarchar(max) '$' AS JSON
                    ) Q1
 CROSS APPLY OPENJSON (Q1.Products) 
             WITH (
                    ID         nvarchar(max) '$.id',
                    variant_id nvarchar(max) '$.variant_id',
                    quantity   nvarchar(max) '$.quantity',
                    properties nvarchar(max) '$.properties[0].name',
                    properties nvarchar(max) '$.properties[0].value',
                    price_shop_money_amt nvarchar(max) '$.price_set.shop_money.amount',
                    price_shop_money_cur nvarchar(max) '$.price_set.shop_money.currency_code'
                  ) Q2 
   


ID
variant_id
quantity
properties
properties
price_shop_money_amt
price_shop_money_cur


4379711799354
31291380727866
1
Item Ships Separately
ABC
null
null

4379711832122
31031946838074
1
null
null
29.50
USD
ID	variant_id	quantity	properties	properties	price_shop_money_amt	price_shop_money_cur
4379711799354	31291380727866	1	Item Ships Separately	ABC	null	null
4379711832122	31031946838074	1	null	null	29.50	USD