PushizoDocs
Messaging & campaigns

Product catalog

Upload your products once and use them in campaigns, journeys and email designs. Decision record: ADR-0061.

Upload your products once and use them in campaigns, journeys and email designs. Decision record: docs/adr/0061-urun-katalogu.md.

Uploading data

Dashboard → Product Catalog, or the public API:

curl -X POST https://api.pushizo.example/v1/apps/$APP_ID/catalogs \
  -H "Authorization: Bearer $API_KEY" -H "Content-Type: application/json" \
  -d '{"name":"urunler","currency":"TRY"}'

curl -X POST https://api.pushizo.example/v1/apps/$APP_ID/catalogs/$CATALOG_ID/items/upload \
  -H "Authorization: Bearer $API_KEY" -F file=@urunler.csv

curl -X PUT https://api.pushizo.example/v1/apps/$APP_ID/catalogs/$CATALOG_ID/items \
  -H "Authorization: Bearer $API_KEY" -H "Content-Type: application/json" \
  -d '{"items":[{"id":"SKU1","title":"Kalem","price":49.9,"url":"https://ornek.com/kalem","in_stock":true}]}'
id,title,description,image_url,url,price,sale_price,category,in_stock,renk
SKU1,Kalem,Mavi tükenmez,https://ornek.com/kalem.jpg,https://ornek.com/kalem,49.90,39.90,Kırtasiye,true,mavi
  • id and title are required. url and image_url must be https.
  • Unknown columns become attributes: {{ urun.attributes.renk }}.
  • Uploads perform an upsert: items with the same ID are updated and empty fields in the row are cleared; products not in the file are left untouched. To delete a product, use DELETE …/items/{itemId}.
  • Limits: 20 catalogs per app, 1,000,000 products per catalog, 100,000 rows and 20 MB per upload, 1000 products per request.

Using it in templates

{% catalog_item 'urunler' id: custom_data.product_id as urun %}
{% if urun and urun.in_stock %}{{ urun.title }}: {{ urun.price_text }}{% endif %}

{% catalog_items 'urunler' ids: user.tags.son_urunler as urunler %}
{% for u in urunler %}{{ u.title }} {% endfor %}
  • Fields: id, title, description, image_url, url, price, sale_price, currency, category, brand, in_stock, attributes.
  • price_text and sale_price_text are formatted with the currency in the recipient's language.
  • ids can be an array or comma-separated text; at most 50 IDs are read.
  • If the product is not found, urun is empty; always use {% if %}.
  • If the ID depends on a local variable inside a {% for %}, it cannot be loaded before sending and returns empty.
  • Works for push, email, SMS, WhatsApp and RCS sends. In in-app messages the tag returns empty.

Email block

In the email designer, drag in the Product block and choose the catalog name and product source. The block renders an image, title, description, price and button. If the product is not found or is out of stock, the block is hidden in the email and the email is still sent. The preview shows a sample product.

On this page