The Odoo staging instance was regenerated and the previous credentials no longer authenticate. Until we have working credentials, 4 catalog queries are blocked (dimensions for Parke GU10, ROB 7W, 600×600 flange panels, and recessed slim linear ~600mm).
URL: https://stage-aronlight.odoo.com
DB name: aronlight-staging-33149390 (confirmed via API — may have changed again)
User + password: any account with read access to product.template and sale.order models is enough.
Contact: can be sent by Manel or any team member with Odoo admin access.
The matching engine needs hard cutoffs. Proposed values below based on Jun 2 call + industry practice. Please confirm or adjust each row.
| Spec | Proposed rule | Source | OK? |
|---|---|---|---|
| Lumen | ≥ spec (no upper cap) | Jun 2 call | ✓ |
| Wattage | ≤ 2× spec — reject if more than double | Jun 2 call (30W→60W = rejected) | confirm |
| IP | ≥ spec (no upper cap) | Jun 2 call | ✓ |
| CCT | ±200K tolerance | Estimated — not discussed | confirm |
| CRI | ≥ spec CRI if stated; ≥ 80 default | Jun 2 call (important, no threshold) | confirm |
| IK | ≥ spec if stated; ignore if not stated | Not discussed | confirm |
| Dimensions (recessed) | Cutout size ≥ spec; outer ≤ spec + 10mm | Jun 2 call ("não pode ser mais pequeno") | ✓ |
| Dimensions (surface) | ±15% accepted | Estimated | confirm |
Rule 1 logic: sum(strip watts) × 1.20 → pick smallest PSU that covers it. We need the correct W/m for each strip SKU. Proposed values parsed from product names:
| SKU | Product | Proposed W/m | Correct? |
|---|---|---|---|
ILAR-00620 | ProStrip 24V monochrome 5m | 14.4 W/m | confirm |
ILAR-00638 | ProStrip 24V RGB 5m | 14.4 W/m | confirm |
ILAR-01404 | COB PRO strip | 10.0 W/m | confirm |
Also: is there a 230V strip in the catalog? If yes, Rule 1 should not fire for it (no PSU needed).
Suggest profile only when order includes strip AND project description mentions a visible install location (no "industrial", "warehouse", "trunking", "canaleta" keywords).
Or should the profile always be suggested and the reviewer removes it?
Monochrome (width unspecified): suggest ILAR-03322 (10mm) + note "8mm variant ILAR-03314 also available — confirm strip width."
RGB strip ILAR-00638: always ILAR-00641 (4-pin RGB connector).
Is ILAR-03322 the right default? Any missing connector SKU?
If order has ≥ 5 luminaires and no ILEM- SKU → suggest "have you included emergency lighting?"
If order has only ILEM- SKUs and no luminaires → flag for reviewer (standalone emergency or retrofit?).
Is the 5-luminaire threshold right, or should the flag fire on any commercial order regardless of count?
| # | Trigger | Suggests | Qty | Status |
|---|---|---|---|---|
| R5 | Panel 300×1200mm ILAR-02979 | Aro frame ILAR-00508 | 1:1 | HIGH — confirm |
| R6 | Thane pendant ILAR-00711 | Suspension kit ILAR-00713 | 1:1 | HIGH — confirm |
| R7 | GU10 lamp (recessed) | Aro trim ring | 1:1 | How to detect recessed vs track? |
| R8 | DALI luminaire | DALI driver | 1:1 | HIGH — confirm |
| R9 | Panel 300×600mm ILAR-01774 | Bracket ILDV-00032 | 1 per 2 panels? | Confirm ratio |
| R10 | Meller body | Espelho trim ring | 1:1 | HIGH — confirm |
When an email arrives with an empty body ("ver anexos") and the attachment is unreadable (corrupted, expired link, wrong format):
Auto-reply to sender: "We received your request but could not read the attachment. Please resend directly as PDF or Excel." Log the email in Odoo with a note. No manual team notification.
Or should the team always be notified so they can follow up personally?
Case 19, Saltoki: "50 metres of ILAR-01691 neon RGB tube." Product sold in 5m reels → 50m = 10 reels, each needing a PSU.
Parse reel length from product name (e.g. "5M" → 5m per reel) and calculate reel count + PSU count automatically.
Is reel length always in the product name? Are there other strip/tube SKUs sold by reel we should know about?
Case 16: Aura Light BOGT3 and MILA M appear discontinued — no current datasheet online.
Work from whatever specs the customer provided in the email. If specs are incomplete, flag the item as "insufficient spec — team to verify" and include it in the partial quote with a note. Do not block the whole quote.
Does Aronlight have an archive of competitor datasheets we could query?
Case 17: email from jordi.marco@aronlight.es (internal commercial delegate for Spain).
Treat as regular RFQ but skip "find client in Odoo" — the delegate is the client record. Produce a quote and reply to the delegate directly.
Should @aronlight.es emails create a sale order in Odoo, or are they informal quotes only?
Case 07, Biobanco Azul: 8 items with Lum_A01.x codes. Only 1 of 8 identifiable.
Process the 1 identified item, quote it, reply with: "We identified 1 of 8 items. The remaining 7 use internal project codes. Please send the caderno de encargos to complete the quote." Do not wait for the full spec.
Confirm: partial quote + explicit list of unmatched items = correct response here?
Case 13: customer describes a technical installation problem but does not ask for a specific product.
Route to technical specialist immediately. The agent does not infer a product need from a problem description.
Who is the technical routing contact in PT and ES?
Healthcare and office specs require a flanged/overlap variant for Armstrong-type modular ceilings. If one exists, how is it identified in the catalog — separate SKU, attribute, or name suffix?
Case 01 needs 49 units. The Kaya 60cm is surface-mount only. If no recessed slim linear exists in the catalog, the team needs to know before the quote goes out.
ILAR-00965/966) — cutout dimensions
Blocked
Customer spec requires approximately 90×90mm square recessed. What is the external dimension and ceiling cutout size for this SKU?
ILAR-02387) square bezel — cutout dimensions
Blocked
CLIMAR TALLES RECESSED 90 SQ requires approximately 90mm square cutout. What is the external dimension and cutout size of the ROB 7W square bezel variant?
Infraestrutura de Portugal 2-lot public tender. Contact: pedro.moreira@pedromoreiraecia.pt (Bruno Lacerda). Please resend as direct attachment.
Huelva building. Contact: david.huarte@macinfor.com (David Huarte). Please resend as direct attachment.
7 of 8 items unidentifiable without the spec document. Originally from Tiago Vaz (tiagovaz@l3w.pt), forwarded to Alexandre Videira. Please resend.
When is a new orcamento created vs. the existing one revised? AlpLuz has three with identical quantities: OR 2026/5710, 7864, 7866.
- 3-3 — How often do RFQs arrive via WeTransfer/TransferNow rather than direct attachment?
- 3-4 — Abbreviated brand codes in cadernos: "OH SCUBA", "OHB BUC BEAM", "OH POD R" — mapping table?
- 3-5 — Functional labels "Tipo F", "Tipo G" — internal product category mapping?
- 3-6 — How often do requests arrive in Spanish Excel medicion format?
- 3-7 — Is Odoo staging a complete copy of production or partial?
- 3-8 — Should the agent search clients across both PT (company_id=3) and ES (company_id=2), or restrict by country?