Back to ER Diagram
Catalog & Pricing Management

Catalog & Pricing Management

Vendor catalog management including item approval workflows, price change requests, catalog refresh cycles, and punch-out catalog integration for seamless procurement.

PostgreSQL
4 Tables
Schema: catalog
Punch-Out Ready

Catalog Management Flow

ITEM SUBMITTED
UNDER REVIEW
APPROVED
ACTIVE
4
Catalog Processes
cXML
Punch-Out
Auto
Price Sync
Approval
Price Changes

1. Catalog Item Management

1

Vendor Catalog Items

Manage approved catalog items from vendors with pricing, availability, and lead time information.

catalog.catalog_items

  • catalog_item_number - Internal catalog SKU
  • vendor_part_number - Vendor's part number
  • unit_price / currency_code - Pricing
  • lead_time_days - Delivery timeline
  • min_order_qty - Minimum order quantity
  • effective_from / effective_to - Validity period

2. Catalog Item Approval

1

Approval Workflow

New items and modifications require approval from category managers before becoming available for purchase.

catalog.catalog_item_approvals

  • approval_type - NEW_ITEM, MODIFICATION, DEACTIVATION
  • change_summary - Description of changes
  • previous_values / new_values - Before/after JSON
  • status - PENDING, APPROVED, REJECTED

Approval Requirements

New items require category manager approval. Price changes over 5% require procurement head approval. Deactivations require finance sign-off if open POs exist.

3. Price Change Approval

1

Price Change Requests

Vendor-initiated or buyer-negotiated price changes with approval workflow and effective date management.

catalog.price_change_requests

  • request_type - VENDOR_REQUEST, NEGOTIATED, INDEX_BASED
  • current_price / requested_price - Price comparison
  • price_change_pct - Percentage change
  • justification - Reason for change
  • negotiated_price - Final agreed price

Price Change Rules

  • < 5% Auto-approve
  • 5-15% Manager approval
  • > 15% Director approval

Supporting Docs

  • • Raw material cost evidence
  • • Index/commodity price data
  • • Competitive quotes

4. Punch-Out Integration

1

Punch-Out Catalogs

Integration with vendor e-commerce sites for real-time catalog access using cXML or OCI protocols.

catalog.punchout_catalogs

  • punchout_url - Vendor's punch-out endpoint
  • protocol - CXML, OCI, ARIBA
  • credentials_encrypted - Secure credentials
  • buyer_cookie - Session identifier
  • last_sync_at / sync_status - Sync tracking
  • item_count - Items in catalog

Punch-Out Flow

User clicks punch-out → Redirected to vendor site → Shops and adds to cart → Returns to ProKure with cart contents → Cart items become PR lines.

Database Schema Summary

TablePurposeKey Columns
catalog.catalog_itemsCatalog itemsitem_number, price, lead_time
catalog.catalog_item_approvalsItem approvalapproval_type, status
catalog.price_change_requestsPrice changescurrent/requested price, pct
catalog.punchout_catalogsPunch-out setupprotocol, punchout_url