Filter SKU from JSON output

  • Resolved olegrob

    (@mobitouch)


    4 years, 5 months ago

    Hello,

    im trying to import this JSON File:

    {
    “comlexName”: null,
    “criteria”: “Description”,
    “lastUpdateDate”: “0001-01-01T00:00:00”,
    “measurement”: null,
    “orderNo”: null,
    “value”: “description 123467”
    },
    {
    “comlexName”: null,
    “criteria”: “Vendor Homepage”,
    “lastUpdateDate”: “0001-01-01T00:00:00”,
    “measurement”: null,
    “orderNo”: null,
    “value”: “www.supermicro.com/products/system/1U/6019/SSG-6019P-ACR12L.cfm”
    },
    {
    “comlexName”: null,
    “criteria”: “Unit Gross Weight”,
    “lastUpdateDate”: “0001-01-01T00:00:00”,
    “measurement”: “kg”,
    “orderNo”: null,
    “value”: “15”
    },
    {
    “elkoCode”: 1285705
    }

    Basically it has product attributes etc. Problem is that every product has different rows. Sometimes one has 10 rows, other times 40 rows. Depends on the product type. I could manually map the fields, but the fields are different for every product.

    What i need: i need to map each product by this field “elkoCode”. Every product has this field in the JSON file end. Im guessing i would need custom PHP script that will check and try to find this field “elkoCode” and add its value as SKU. How can that be achieved?

  • The topic ‘Filter SKU from JSON output’ is closed to new replies.