Песочница: ALLEGROMAILS1

Intent ID: 7

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (Blooming city - 2026-16429 - 2026-02-26.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "145-9981 7594",
  "items": [
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 350,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.4,
      "box_marking": "HBJ",
      "total_price": 140.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 300,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 111.0
    },
    {
      "boxes": 1,
      "length": "",
      "variety": "P.O. : mix",
      "category": "ROSAS",
      "quantity": null,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": null,
      "box_marking": "HBJ",
      "total_price": null
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FULL MONTY",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "HIGH MAGIC",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MANDALA",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PALOMA",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PINK MONDIAL",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "TIFFANY",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 350,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.33,
      "box_marking": "HBJ",
      "total_price": 115.5
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 350,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.33,
      "box_marking": "HBJ",
      "total_price": 115.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "DEEP PURPLE",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FREEDOM",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FULL MONTY",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "HIGH MAGIC",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "HOT EXPLORER",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "NINA",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PHOENIX",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "LIGHT HOUSE",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20413",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    }
  ],
  "country": "Ecuador",
  "summary": {
    "total_boxes": 6,
    "total_stems": 1950,
    "total_amount": 710.0
  },
  "supplier": "ALLEGRO FARMS CIA LTDA",
  "invoice_date": "2026-02-26",
  "invoice_number": "2026-16429",
  "processing_report": {
    "notes": "Тип инвойса: Групповые коробки без агрегата (В). Обнаружено 1 физических коробок. Раскрытие мультибокса не применялось. Условия и примечания: 1. The Customer must pay this invoice according to the initial agreement. 2. Only written credits/claims for quality and/or quantity problems which are informed within the 48-hour period after shipment is received at your place would be accepted. (We consider a 12 day transportation period from the flight day out of Ecuador) 3. All claims must contain: invoice number, awb number, date shipment was received, variety, length of flowers, damaged stems count and claim amount 4. The Claim must include clear pictures or video of: 1. Box Label 2. Bunch with barcode label 3. Photos of all stems with phytosanitary problems 5. We will accept claims of flower with phytosanitary damage 6. ALLEGRO FARMS does not pay transportation costs, freight costs, related fees and/or other customer expenses",
    "status": "warning",
    "sum_boxes": 1,
    "sum_stems": 1950,
    "sum_amount": 710.0,
    "items_count": 21,
    "discrepancies": [
      "Несовпадение количества коробок"
    ],
    "expected_boxes": 6,
    "expected_stems": 1950,
    "expected_amount": 710.0
  }
}
Результат (Pass 2)

  
История (последние 20)
ID Файл Дата