How do I create my packaging report for LUCID and Citeo?
On this page
Turn your shipped orders into kilograms of packaging per material and destination country, download the figures for LUCID, your dual system or Citeo, and keep a snapshot as evidence.
Before you start
- Set up your packaging and shipping rules and assign packaging to your products.
- Shopify only lets apps read the last 60 days of orders unless they have the
read_all_orderspermission. Annual reports need that permission. - In Settings, under Report defaults, set the CSV delimiter (Semicolon (;) for German or French spreadsheets) and the Default countries for reports.
Create the report
- In Custos, open Packaging EPR, then Reports.
- Choose the Period: this year to date, last year, last quarter, last month or a custom range.
- Keep All countries or pick the countries you report for.
- Choose whether to Exclude B2B orders (orders placed by a company through Shopify B2B).
- Click Create report.
The calculation runs in your browser; order data is not sent to Custos’s servers. Only the headline figures are saved on your shop for the overview, the alerts and Sidekick.
Germany: LUCID and dual system figures
The Germany tab shows kilograms shipped to consumers in Germany per LUCID material category, shipping boxes, void fill and tape included.
- Copy table, or download it as CSV or Excel.
- Create LUCID XML: choose the Report type (plan HPM1, intra-year HMM1, year-end HJM1, supplementary HNM1 or deducted HAM1) and your Dual system, check the period (one calendar year, whole months), click Download XML and upload it in LUCID. LUCID adds your registration number from your login.
- The German thresholds card shows where you stand against the 10 t annual threshold and the completeness declaration (Vollständigkeitserklärung) thresholds. Thresholds apply per calendar year.
France: Citeo declaration
The France tab shows the units (UVC) shipped to consumers in France and the suggested declaration mode: Flat fee (forfait), Simplified declaration or Declaration per UVC. Download the simplified declaration per product family (choose the Citeo tariff grid) or the per-UVC lines in Citeo’s column order.
Other tabs
- Austria, Spain, Italy, Netherlands: worksheets in each scheme’s own categories.
- All countries: kilograms by destination country in the PPWR material categories.
- Monthly: Germany by month and the total by country and month.
- Data quality: what is missing from the totals.
- US states: click Open US state reports (see “How do I prepare my US state packaging EPR figures?”).
Plan quantities and declared vs. shipped
From the top of Reports:
- Plan quantities starts from your full-year report or a forecast of this year, lets you add growth per category and downloads the LUCID plan report (HPM1). Save as declared plan quantities keeps the figures you sent.
- Declared vs. shipped compares the plan or year-end figures you gave your dual system with what you shipped, per category, and warns when you ship more than you declared.
Keep a snapshot as evidence
Under the results, enter a name and click Save snapshot. A snapshot keeps the figures together with your packaging library, shipping rules and the packaging of every shipped variant at that moment. On Report snapshots, download its evidence pack: a ZIP with summary.html (the figures and settings; open it in a browser to read or print it as PDF), CSV files per country, category, material, component, rule and variant, the full snapshot.json and, from the second snapshot, the changes since the previous one. The pack is written in your Custos language (English, German, French, Italian, Spanish or Japanese).
Verify it worked
The results start with Report for … – … and the number of shipments counted. If Data quality says “No gaps found”, your totals include all shipped packaging. You remain the declarant: check the figures before you report. You can also ask Sidekick “How close am I to the German 10 t threshold?”.
Troubleshooting
“Some packaging data is missing, so totals may be too low.” Click Open Data quality and fix each gap, then create the report again.
“Orders older than 60 days are not available yet”. Choose a period within the last 60 days until Shopify grants read_all_orders and you accept the updated permissions.
“No shipments to Germany in this period.” Check the period, the countries and that the orders were fulfilled.
“A year-end report (HJM1) must cover 1 January to 31 December of one year.” Run a report for the whole year first.