ARA-Affiliate: Affiliate plugin for JTL-Shop and JTL-Wawi
Recommendations from bloggers, clubs, retailers or regular customers often bring in exactly the customers who fit your product range. If you want to pay such partners fairly, every order has to be credited to the right partner. You also need a commission that is still correct after returns and invoice corrections, and statements your tax advisor can process without asking questions.
ARA-Affiliate handles all of this directly in your JTL-Shop and calculates with the invoices from your JTL-Wawi. You decide who becomes a partner and on what terms. The plugin takes care of order attribution, calculation and credit notes. If you are unsure about a setting, just ask the built-in AI assistant.
Why you need the plugin
Without a dedicated tool, an affiliate program usually runs on voucher codes and a spreadsheet. At the end of each month you look up the orders with the code and compare them with the invoices. You deduct returns and write a credit note for every partner. With two partners that is still manageable. With twenty it takes hours every month, and every calculation error will be noticed by the partner sooner or later.
With ARA-Affiliate, these steps become part of normal shop operations. At checkout, the plugin credits the order to the partner, whether the customer came through a partner link or used a voucher code. As soon as JTL-Wawi creates the invoice, the commission is booked. The plugin also offsets invoice corrections and cancellations from JTL-Wawi automatically.
The AI assistant answers your questions
An affiliate program with commission rules, lifetime attribution, credit notes and JTL-Wawi workflows has many settings. So you don't have to search the manual, ARA-Affiliate includes an assistant that answers your questions in plain language. The "Help" button at the bottom right opens a panel on the right edge, on every tab of the plugin. You can ask, for example, how to give a partner a higher rate for one category, why a booking shows €0, or which JTL-Wawi workflow you need for invoice corrections.
The answers are based on the manual and on a knowledge base that ARA-Marketing maintains with every new version. The panel stays open when you switch tabs, so you can apply the answer right away. Follow-up questions refer to the conversation so far.
Data protection: The assistant only becomes active once you have accepted the privacy notice in the "Help" tab. You can withdraw your consent there at any time. The only data sent is your question, the conversation history, the shop domain and the license. It goes encrypted to the ARA-Marketing license server and from there to the AI service Anthropic. No customer, partner or order data from your shop is transmitted.
ARA-Marketing keeps questions the assistant cannot answer for up to 90 days to improve the manual. The assistant is included in the license and has a daily limit per shop.
The work it takes off your hands
-
No recalculation: Commission follows the JTL-Wawi invoice. If the amount changes, the commission changes with it.
-
Commission on your terms: For each partner you decide which categories and customer groups earn commission. If you like, you can also set individual rates per manufacturer, category or customer group. Instead of a percentage, you can use a fixed amount per order. You can also set a maximum commission per order and a limit to a customer's first orders or to new customers only. Each of these rules can be switched on separately.
-
Traceable amounts: For every booking, the plugin stores the calculation: which item was calculated at which rate, what a voucher deducted, and whether a cap applied. You see it in the backend, and your partners can see it in the partner area if you allow it.
-
No manual credit notes: For each settlement, the plugin creates a self-billed credit note for every partner in accordance with § 14 UStG (German VAT Act). It is an e-invoice in ZUGFeRD format and is emailed to the partner.
-
One list for bank transfers: Once a month you receive an email with all amounts due and your partners' bank details. After payment, you mark the credit notes as paid.
-
See which channel sells: A partner who promotes you on Instagram, YouTube and in a newsletter creates a separate link for each channel, e.g.
?partner=SPORTBLOG-NEWS. Clicks, orders and revenue are then shown separately for each link, both for the partner and for you. The commission stays the same; only the reporting changes.
-
Fewer questions from partners: Your partners get their own area in your shop with four tabs: their links and promotional material, statistics with the history of the last twelve months, statements with bookings per month and credit notes, and the details you have on file for them. If you wish, partners receive an email when commissions are approved or paid out.
-
Applications through your shop: If you wish, prospective partners apply through a page in your shop, including tax and bank details. Once you have reviewed an application, its details are already filled in when you create the partner.
-
Partner terms with proof of acceptance: The plugin creates a page for your partner terms. Partners accept them in the partner area, and the date and version are stored.
-
Overview for accounting and reporting: Credit notes and bookings are available per month as CSV. Charts show revenue and commission per month, where orders came from, and your top ten partners.
How it differs from external affiliate networks
An external service runs your affiliate program on its own servers. ARA-Affiliate runs as a plugin in your shop. That has practical consequences:
-
Your data stays with you. Partners, clicks, orders and credit notes are stored in your shop database. No other service provider is involved in tracking.
-
Commission is based on the invoice. It is calculated on the net merchandise value that your JTL-Wawi actually invoiced, including later corrections.
-
You pay a fixed annual price. There is no fee per referred order and no share of your partners' revenue. As your affiliate program grows, your costs stay the same.
-
Your partners stay in your shop. The partner area is a page of your shop, in your template, and partners sign in with their customer account. There is no extra portal with a separate login.
-
It fits JTL. Attribution uses the JTL standard campaign and the JTL consent manager. Settlement uses the invoices and workflows of JTL-Wawi.
Features at a glance
Tracking
- Partner links with a partner code. The shop redirects with a 301 to the clean URL, and links from the link generator carry
rel="sponsored".
- Individual links per partner, for example for Instagram, Facebook, YouTube or a newsletter. Partners create them themselves in the partner area, or you create them in the backend. You decide whether partners may create links themselves and how many. The link code is passed to JTL-Wawi as the order attribute
affiliate_link.
- Voucher codes as a second way to credit orders, with several codes per partner.
- Visits are tracked via the JTL standard campaign. Orders are credited at checkout and passed to JTL-Wawi as an order attribute.
- Cookie lifetime can be set. The JTL consent manager is respected: without consent, the attribution only applies to the current session.
- Lifetime attribution: If you wish, a customer stays assigned to the partner after the first invoice. For repeat orders you can set a separate rate or fixed amount, and a separate duration per partner. If the order is returned in full, the attribution ends.
- Partners' own orders are recognized (by customer account and email address, including variants such as
name+shop@…) and earn no commission.
Commission rules
- Commission on the net merchandise value of the JTL-Wawi invoice, excluding shipping. Invoice corrections and cancellations are offset as negative bookings. The connection runs via four JTL-Wawi workflows, and the plugin provides their parameters ready to copy.
- Partial invoices are not paid twice. JTL-Wawi reports the entire order with every invoice. So the first invoice books the commission, and each further invoice for the same order only books an additional amount, for example if the quantity was increased in JTL-Wawi.
- "Commission applies to": can be limited per partner to categories (including subcategories) and customer groups. Discounts and vouchers are distributed proportionally across the line items.
- Individual rates per manufacturer, category and customer group. Order of priority per line item: manufacturer, then the deepest category, then customer group, otherwise the partner rate. 0% excludes an item. If several rates apply within one invoice, the list and the credit note show the blended rate.
- A fixed amount per order instead of a percentage, booked once with the first invoice. A partial return does not change it; a full return reverses it.
- Maximum commission per order, calculated across all invoices for that order. Corrections to a capped order are calculated proportionally.
- Commission only for a customer's first X orders, or for new customers only. The order still counts towards the partner's statistics.
- Calculation per booking in the backend and, if you choose, in the partner area.
Settlement
- Approval in fixed steps: pending, open, approved, settled, paid. You set the waiting period before approval; a cron job handles the approval.
- Self-billed credit notes in accordance with § 14 UStG with their own number range, cancellation credit notes, and the tax types standard taxation, small business (Kleinunternehmer) and reverse charge.
- E-invoice in ZUGFeRD/Factur-X format: PDF/A-3 with embedded XML according to EN 16931, tested with the Mustang, KoSIT and veraPDF validators. The XML is also available as a separate download.
- Every document is archived unalterably when it is created and secured with a SHA-256 checksum. The archive directory is blocked against web access, and the plugin checks this block daily.
- A monthly email to the shop owner with a bank transfer list. Amounts below the minimum you set are carried over to the next month. The plugin does not make any payments.
- Credit notes can be selected by month in the backend, and open ones are always shown at the top. If needed, you create the credit notes with one click right away instead of waiting for the next cron run.
- CSV export of credit notes and bookings per month, as a download and as an attachment to the monthly email.
Partner management and reporting
- Create partners in the backend with commission rules, codes, tax and bank details, and invite them by email. Blocked partners are shown in a separate view.
- A "Links" section for each partner with clicks, orders, revenue and commission per link. Links can be created and deactivated, and deleted as long as no orders were placed through them.
- Self-registration (optional): an application page "Become a partner" with double opt-in. An "Applications" tab lets you review, accept or reject applications, optionally with a rejection email.
- The application page is protected by a honeypot, a minimum completion time, a form token and, if active in the shop, the shop's CAPTCHA. IP addresses are not stored.
- A "Partner terms" page as a normal shop page with a template, blocked for search engines. Acceptances are stored per partner with date and version.
- Emails to partners for new commissions, approvals and payouts, each switchable separately, with the option to exclude individual partners. Approvals are combined in one daily email.
- "Reports" tab: clicks, orders by source, revenue and commission per partner and month, charts, top 10 partners, CSV export.
- A separate list of partner orders that still have no invoice from JTL-Wawi after a set number of days.
- Manual bookings for special cases.
Partner area in the shop
- "Partner links & integration": main link and individual links per channel with figures per link. Also a link generator for any shop page, promotional material and a logo snippet for a selected link, plus the partner's own voucher codes.
- "Statistics": clicks, orders, commissions and attributed customers, with the history of the last twelve months as a chart.
- "Statements": commissions by status, bookings per month with an expandable calculation, and credit notes as PDF and XML downloads.
- "Your details": billing details for review with a masked IBAN, acceptance of the partner terms with one click, and a printable partner guide.
Operation, help and security
- AI assistant as a side panel on every tab of the plugin, after a one-time consent to the privacy notice, which can be withdrawn at any time.
- A detailed manual for shop owners directly in the backend, with its own section for each commission rule.
- Database access in the frontend only for partner visits, at checkout, in the partner area and on the application page. Reports are precalculated by a cron job.
- Encrypted backup with restore, including partner vouchers. Before uninstalling, the plugin automatically creates a backup.
- If you uninstall with data deletion, the plugin only removes the vouchers it created itself. Your other shop vouchers and the document archive are kept.
- The JTL-Wawi workflows pass all values URL-encoded. If JTL-Wawi reports a higher net value than the shop order, that value is booked and marked for review.
System requirements
- JTL-Shop 5.5 or later; credit note as PDF requires JTL-Shop 5.8 or later
- PHP 8.2 or later
- JTL-Wawi with workflows (connected via webhook)
- Developed and tested with the NOVA template