Shopify: SKU -> Product ID mapper

Hi,

we need a mapper for shopify. What we need is a script that does the following: we have a SKU and we would like to open a product page. So let me give you an example.

In shopify you can open every product through an URL like:
https://shopname.myshopify.com/admin/products/[productno.]

For every product no. we have an SKU. What we need is: when you open a link through an SKU given by parameter shopify should show the product page. So if i klick on:
http://demoshop.com?sku=99 -> https://shopname.myshopify.com/admin/products/[productno.]

So what the script has to do is: search in the shopify database for SKU 99 and open the product page that is related to this SKU.

Unfortunately shopify itself does not offer something like this. Thats why we are searching for a small script that does it.

Hope you understand what we need. Further questions? feel free to ask.

Thanks a lot.


Best regards,
Torsten