Research: Cleveland Kraut PO Channel Inventory (ENG-459)
Problem Premise Validation
Section titled “Problem Premise Validation”The initial premise that customerservice@clevelandkraut.com handles a significant portion of real PO emails is validated. In fact, this is the only automated channel for all Cleveland Kraut purchase orders that are processed by the Ordermatic system, including those originating from EDI and specific large customers.
Scope & Findings
Section titled “Scope & Findings”1. Total Monthly PO Volume Across All Channels
Section titled “1. Total Monthly PO Volume Across All Channels”All automated POs for Cleveland Kraut are ingested through the email pipeline. To determine the total monthly volume, an engineer or analyst would need to query the extracted_orders table (filtered by clerk_organization_id for Cleveland Kraut) and group the count of orders by month. There are no other direct automated ingestion channels for Ordermatic.
2. Breakdown of PO Volume by Channel
Section titled “2. Breakdown of PO Volume by Channel”-
Email (Mailboxes): The sole mailbox monitored for automated PO ingestion is
customerservice@clevelandkraut.com. A scheduled Temporal workflow (ScheduledCkGmailPollWorkflow) actively polls this inbox. -
EDI (Provider): The identified EDI provider is SPS Commerce. However, the integration is indirect and manual. There is no direct EDI feed into the Ordermatic system. Instead, POs from SPS Commerce are manually downloaded as PDF files from their web portal by users and then forwarded via email to
customerservice@clevelandkraut.com. These are subsequently processed by the standard email attachment pipeline. -
Vendor Portals: The only vendor portal identified in the context of PO ingestion is SPS Commerce, utilized manually as described above. The system does not currently feature any automated vendor portal scraping or direct integrations.
3. Confirmation: Giant Eagle POs (XLSX via Email vs. SPS Commerce EDI)
Section titled “3. Confirmation: Giant Eagle POs (XLSX via Email vs. SPS Commerce EDI)”It is confirmed that Giant Eagle sends Purchase Orders as XLSX files via email. The system has specific logic and test cases in place (apps/temporal-worker/tests/unit/activities/test_pre_extraction.py mentions _make_xlsx and Giant Eagle Vendor #092019) to handle their multi-tab spreadsheet format. Giant Eagle does not use SPS Commerce EDI for sending POs to Cleveland Kraut via this pipeline.
4. Identification of Large Customers and Their Channels
Section titled “4. Identification of Large Customers and Their Channels”Large customers identified whose POs are processed through the same email pipeline include: Kroger, Marcs, SpartanNash, and Sysco. The specific format of their POs (e.g., PDF, XLSX) may vary, but the ingestion channel remains customerservice@clevelandkraut.com.
Acceptance Criteria Decisions
Section titled “Acceptance Criteria Decisions”- Written PO channel breakdown for CK: Completed and detailed above.
- Giant Eagle xlsx premise confirmed or invalidated: Confirmed - Giant Eagle sends XLSX via email.
- Decision: is
customerservice@sufficient for demo? Yes,customerservice@clevelandkraut.comis sufficient for a demo, as it is the central and sole automated ingestion point for all Cleveland Kraut POs within the Ordermatic system.