@app.route('/click_event')
def clicks():
    sku = request.args.get("sku")
    pattern = re.compile('([A-Z]{5})(d{5})')
    if pattern.match(sku):
        entry = db.session.query(Product.id,Product.sku,Product.clicks).filter(Product.sku==sku).first()
        if entry is None:
            new_product = Product(sku=sku, clicks=1, buys=0, cart_adds=0)
            db.session.add(new_product)
            db.session.commit()
            return json.dumps(new_product)
        else:
            entry.clicks += 1
            db.session.commit()
            return json.dumps(entry._asdict())
        db.session.flush()
    else:
        return "Not Found!"

{"sku": "ABCDE12345", "id": 5, "clicks": 2}

{"sku": "ABCDE12345", "id": 5, "clicks": 2}

id |    sku     | clicks | buys | cart_adds
----+------------+--------+------+-----------
5 | ABCDE12345 |      1 |    0 |         0