PHP Script: SKU to Product ID

Job Description:

Hi,

I am using a shopify system.

Through this URL shopify shows the product id of a SKU:

https://[...]/admin/products/[login to view URL]:80

80 = SKU

When opening this website in a shopify system it shows the data of a product like this:

{"products":[{"id":7584457720037,"title":"Deutschland Fahne | Schwarz Rot Gold | Hissflagge + 2 Ösen | Flagge | 150x90cm | Fußball WM","body_html":"\u003cul data-mce-fragment=\"1\"\u003e\n\u003cli data-mce-fragment=\"1\"\u003eFahnengröße: 90x150 cm\u003cbr data-mce-fragment=\"1\"\u003e\u003cbr data-mce-fragment=\"1\"\u003e\n\u003c\/li\u003e\n\u003cli data-mce-fragment=\"1\"\u003eseitlich zwei Metallösen zum Hissen\u003cbr data-mce-fragment=\"1\"\u003e\u003cbr data-mce-fragment=\"1\"\u003e\n\u003c\/li\u003e\n\u003cli data-mce-fragment=\"1\"\u003ean den Rändern mit Sicherheitsnähten doppelt gesäumt\u003cbr data-mce-fragment=\"1\"\u003e\u003cbr data-mce-fragment=\"1\"\u003e\n\u003c\/li\u003e\n\u003cli data-mce-fragment=\"1\"\u003ean der Mastseite zusätzlich verstärkt\u003cbr data-mce-fragment=\"1\"\u003e\u003cbr data-mce-fragment=\"1\"\u003e\n\u003c\/li\u003e\n\u003cli data-mce-fragment=\"1\"\u003eintensive Farben\u003cbr data-mce-fragment=\"1\"\u003e\u003cbr data-mce-fragment=\"1\"\u003e\n\u003c\/li\u003e\n\u003cli data-mce-fragment=\"1\"\u003eMaterial 100% Polyester, bei 30 Grad waschbar\u003c\/li\u003e\n\u003c\/ul\u003e","vendor":"U.S.X.","product_type":"Flaggen \u0026 Windsäcke","created_at":"2022-01-29T08:28:13+01:00","handle":"deutschland-fahne-schwarz-rot-gold-hissflagge-2-osen-flagge-150x90cm-fussball-wm","updated_at":"2022-09-06T00:50:33+02:00","published_at":"2022-01-29T08:28:12+01:00","template_suffix":"","published_scope":"global","tags":"adler, bundesadler, deutschland, fahne, fußball, nationalmannschaft, weltmeisterschaft, wm","admin_graphql_api_id":"gid:\/\/shopify\/Product\/7584457720037","variants":[{"product_id":7584457720037,"id":42414302953701,"title":"Default Title","price":"5.69","sku":"80","position":1,"inventory_policy":"deny","compare_at_price":"6.99","fulfillment_service":"manual","inventory_management":"shopify","option1":"Default Title","option2":null,"option3":null,"created_at":"2022-01-29T08:28:13+01:00","updated_at":"2022-09-06T00:47:51+02:00","taxable":true,"barcode":"0751405237569","grams":67,"image_id":null,"weight":67.0,"weight_unit":"g","inventory_item_id":44508661743845,"inventory_quantity":892,"old_inventory_quantity":892,"requires_shipping":true,"admin_graphql_api_id":"gid:\/\/shopify\/ProductVariant\/42414302953701"}],"options":[{"product_id":7584457720037,"id":9660774056165,"name":"Title","position":1,"values":["Default Title"]}],"images":[{"product_id":7584457720037,"id":36594770444517,"position":1,"created_at":"2022-01-29T08:28:54+01:00","updated_at":"2022-01-29T08:28:54+01:00","alt":null,"width":500,"height":500,"src":"https:\/\/[login to view URL]\/s\/files\/1\/0624\/4912\/3557\/products\/[login to view URL]","variant_ids":[],"admin_graphql_api_id":"gid:\/\/shopify\/ProductImage\/36594770444517"}],"image":{"product_id":7584457720037,"id":36594770444517,"position":1,"created_at":"2022-01-29T08:28:54+01:00","updated_at":"2022-01-29T08:28:54+01:00","alt":null,"width":500,"height":500,"src":"https:\/\/[login to view URL]\/s\/files\/1\/0624\/4912\/3557\/products\/[login to view URL]","variant_ids":[],"admin_graphql_api_id":"gid:\/\/shopify\/ProductImage\/36594770444517"}}]}

So what I need is a PHP script on an EXTERNAL server that opens the link with the SKU, reads the product id and opens the product website in shopify:

https://[...]/admin/products/[product_id]

So all I need is a script that logs into shopify and opens the url.

Any question? Feel free to ask.

Best,

Torsten

Fähigkeiten: PHP, Shopify Development, Shopify

Projekt-ID: #34566105