Skip to content

1.8.5

🚀 Summary

  • Targets-met Discord embeds — include ASIN and clickable GTIN / ASIN links (Amazon.de + Qogita catalog search), matching the watchlist table in the frontend.
  • Embed title — links to Amazon when an ASIN is known, otherwise to Qogita catalog search.
  • Catalog flag correction — Discord sample lines also use markdown links for GTIN and ASIN.
  • Shared URL helpers — watchlist_links.py mirrors qogitaWatchlistPrefs.js on the backend.

✨ Improvements

Discord — watchlist targets met

Embeds sent after the Qogita cron catalog-targets refresh now include:

Field Content
GTIN [8719134203318](https://www.qogita.com/categories/?query=…)
ASIN [B000E7YJVU](https://www.amazon.de/dp/…) or —
Title Product name; embed url → Amazon (preferred) or Qogita
Avg VK (30d) Keepa 30-day average selling price (VK brutto)

Existing fields unchanged: target EK, catalog price, seller, stock, on-Qogita flag, Qogita price/qty when qid is set.

Discord — catalog flag correction

Sample lines changed from plain `GTIN` to:

• [688575134490](qogita…) · ASIN [B000E7YJVU](amazon…) — Qogita 23.11 EUR, stock 12

watchlist_links.py

  • resolve_watchlist_asin() — from asin column or ASIN: stub GTIN.
  • amazon_de_product_url() — https://www.amazon.de/dp/{asin}.
  • qogita_catalog_search_url() — https://www.qogita.com/categories/?query={gtin} (skips ASIN: stubs).
  • discord_markdown_link() — [label](url) for Discord embed fields.

✨ Tests

  • test_watchlist_links.py — ASIN resolution, Amazon/Qogita URLs, markdown link formatting.
cd backend/service_omni
pytest app/tests/test_watchlist_links.py -v

📁 Files changed

Backend (service_omni)

  • app/services/qogita/watchlist_links.py (new)
  • app/services/price_alerts/discord_notifications.py
  • app/tests/test_watchlist_links.py (new)

🔧 Deploy

Restart service-omni. No database migration.

Discord webhook URL is unchanged — configure it on the watchlist tab (Discord webhook field) or via the Qogita cron job arguments.

Usage notes

When alerts fire

  1. Qogita watchlist cron runs (default every 6h).
  2. After sync, wholesale catalog targets are refreshed.
  3. Rows that newly meet target EK (are_targets_met false → true) trigger Discord embeds.
  4. Click GTIN in Discord → Qogita catalog search; click ASIN or the embed title → Amazon.de product page.

ASIN from Keepa-only rows

  • Resolved from asin column after fetch/analyze, or from ASIN:{asin} stub GTIN before EAN is known.