extract data from qr code and deduct from inventory list

I have QR codes that gives me this data when scanned: {"id":"OiF9mMKP","product_order_id":"67b92426-c9cf-4c51-9737-2e574bb4342d","product_sku":"F52"}

I Want to use the product_sku to compare with a order list and deduct the scanned product from the list.

Aim is to scan products and match with delivery list to find any deviations.

example file is attached.

thanks in advance.

You could use this to extract the product_sku, e.g. "F52" in your example:

=MID(A3,FIND("product_sku",A3)+14,FIND(CHAR(34),A3,FIND("product_sku",A3)+14)-(FIND("product_sku",A3)+14))

I'm not sure how you want to "deduct" it from the list. If you want to change the list this would need VBA. If you want to check whether it is in the list then this can be done, but I'm not clear what you want to do with it. e.g. this will give you the position of F52 in your list:

=MATCH("F52",LEFT(A9:A40,3),0)

@AskMeAboutExcel

I thought of something like that for extracting the SKU, but was trying to make it work even if product_sku wasn't the last parameter. Although it is in the specific example.

Thanks for all the replies and willingness to help.
The formula for extracting the sku worked great.

I want to scan all recieved products and have them compared to a delivery list. Every time a product is scanned it should substract from the corresponding product row.

Originally Posted by Glenn Kennedy

If you want Excel to "remember" the number of times a formula has produced a result of "F52" or whatever... you will need VBA. It can not be done using a formula.

Thank you. VBA is new to me so will dig in and learn about it.