İçeriğe geç
YENİPazar yeri ve trig8n Agent: geliştirdiğinizi satın; planlar ve değişiklikler siz görmeden önce test edilsin. Yeniliklere bak

Kütüphane / Dosyalar ve Bulut Depolama

Dosyalar ve Bulut Depolama

n8n formlarıyla satış CSV yüklemelerini doğrula ve onay incelemesi ZIP dosyaları oluştur

Form yüklemesiyle tetiklenir; bir UTF-8 satış CSV dosyasını Data Table'da daha önce yayımlanmış partilere karşı doğrular, bir inceleyicinin onaylamasına veya reddetmesine izin verir ve bir denetim ZIP dosyası döndürür.

Ne yapar

## Validate sales CSVs and generate review ZIPs with n8n forms Review recurring sales exports before a manual import. Upload one UTF-8 CSV, validate orders, compare them with previously released batches, and save an exact review. An authenticated reviewer can download, approve the accepted subset or reject it. Each result is returned as an audit ZIP. ### How it works Checks required columns, calendar dates, currency precision and duplicate groups. An n8n Data Table stores immutable batch snapshots and one authoritative release registry. Approval binds to the review hash and commits the release plus decision in one conditional update. Identical historical orders and conflicting IDs are excluded. No shop or accounting import is executed. ### Setup Run the separate setup utility once. Copy stateTableId and actual reviewer emails into both Configure nodes. Keep n8n User Auth and Include User in Output enabled on both forms. Run the credential-free demo, then upload examples/sample.csv with a unique batch ID. Copy batch_id and review_hash from report.json into the decision form. Approve requires typing RELEASE ACCEPTED ROWS. ### Requirements and limits Tested on n8n 2.28.6; Data Tables and n8n-user Forms required. Built-in nodes; no service credentials for this workflow. Required headers: order_id,order_date,amount,currency. One order per row, max 1,000 rows per upload. Run one intake at a time. Registry limits: 5,000 released orders, 1,000 decisions, 4,000,000 serialized characters. Decisions expire after 24 hours by default. Re-upload with a new batch ID if release history changes. Customize limits only with tests.

Adımlar

  1. Upload sales CSV for review
  2. Configure intake and authenticate
  3. Read uploaded CSV
  4. Parse CSV and check headers
  5. Validate sale fields
  6. Resolve duplicate order IDs
  7. Build review files
  8. Read canonical validation report
  9. Read release registry for intake
  10. Read history and preserve input
  11. Check unique batch ID
  12. Build immutable history-aware review
  13. Save immutable batch snapshot
  14. Verify saved review

Toplam 30 adım.

Benzer otomasyonlar