- Expand SELECT_COLUMNS to include tags, outfit_recommendations, description_text_full
- Replace _enrich_with_outfit() (SQLite lookup) with _parse_outfit_recommendations() (JSON parse)
- Remove sqlite3 and os imports from search_engine.py
- Add 6 characterization tests verifying the refactor

refactor: unified SKU search (exact match, no subsequence) + store search upgrade (token AND + reverse LIKE fallback)

feat(ai-stylist): Refactor product grouping logic; enforce internal_ref_code mapping for variants and clamp product_ids prompt to master code only

fix: cast json_query to VARCHAR for StarRocks DISTINCT, add sku_color to API, merge knowledge tool to 1 query

- product_mapping.py: Add RELATED_LINES for Quần lót family (Quần lót đùi, Quần lót tam giác)
- product_mapping.py: Add synonyms quần sịp đùi, quần boxer, quần sịp tam giác, quần brief
- product_search_helpers.py: Expand LIKE filter to also match on product_line_vn
  (product_name uses 'quần sịp' but product_line_vn uses 'Quần lót đùi')

- Replace 'có hình in' with 'có họa tiết trang trí' for generic products
- Keep specific prints (Mickey, Doraemon, etc.) unchanged
- Remove 200-char truncation on description field
- Update prompt examples in 01_core.txt and 02_rules.txt

feat: Codex/Responses API compatibility, cache TTL 24h, prompt optimization, n8n test tools, gitignore cleanup

- NEW: store_search_tool.py - query dedicated store table
- NEW: store_search_tool.txt - tool prompt
- UPDATE: brand_knowledge_tool.py - pure semantic search
- UPDATE: product_mapping.py - fuzzy match for typos
- UPDATE: system_prompt.txt - section 5.5.1 canifa_store_search
- UPDATE: get_tools.py + prompt_utils.py - register new tool
- UPDATE: promotion_canifa_tool.py - new salerule table
- All prompts pushed to Langfuse

refactor: improve system prompt - anti-fabrication, body comment ban, price handling, stylist mode, response length limits, Langfuse cache hit trace