Keep WooCommerce prices in line with your main store

import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http

WOO = "https://shop.example.com/wp-json/wc/v3"
SHOPIFY = "https://northwind.myshopify.com/admin/api/2024-07/products.json"
ME = "me@northwind.com"

@on_trigger
def run(event):
    shop = http.get(SHOPIFY, headers={"X-Shopify-Access-Token": credentials.secret("SHOPIFY_TOKEN")}, params={"limit": 250}).json()
    source = {v["sku"]: v["price"] for p in shop["products"] for v in p["variants"] if v.get("sku")}
    auth = (credentials.secret("WOO_KEY"), credentials.secret("WOO_SECRET"))
    changes = []
    for p in http.get(f"{WOO}/products", auth=auth, params={"per_page": 100}).json():
        new = source.get(p.get("sku"))
        if new and float(new) != float(p["regular_price"] or 0):
            http.put(f"{WOO}/products/{p['id']}", auth=auth, json={"regular_price": new}).raise_for_status()
            changes.append(f"{p['sku']} {p['name']}: {p['regular_price']} -> {new}")
    if changes:
        msg = EmailMessage()
        msg["To"], msg["Subject"] = ME, f"{len(changes)} WooCommerce prices updated"
        msg.set_content("\n".join(changes))
        gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
        gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    return {"changed": len(changes)}