item-lookup

Diagnose ITEM_LOOKUP_MISSING failures on inbound 850 purchase orders.

6|6|Updated Apr 29, 2026
One-click install
npx skills add https://github.com/Orderful/orderful-netsuite-skills --skill item-lookup
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: item-lookup
Source: https://github.com/Orderful/orderful-netsuite-skills/tree/main/skills/item-lookup
Command: npx skills add https://github.com/Orderful/orderful-netsuite-skills --skill item-lookup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It diagnoses and helps you resolve NetSuite item mapping failures where inbound 850 purchase orders error out with ITEM_LOOKUP_MISSING due to missing or mismatched item lookup records.

Core Features & Use Cases

  • Pinpoint the failing qualifier/value on the exact inbound 850 line by pulling transaction + error context from NetSuite and corresponding PO content from Orderful.
  • Find existing cross-qualifier mappings so you can add only the missing qualifier/value lookup that the connector needs (without modifying the existing record).
  • Propose a single, scoped item-lookup mapping with confidence-based candidate selection using item master signals like partner SKU text matches, unit price alignment, and prior purchase history, while escalating when matches are ambiguous.

Quick Start

Diagnose a failing inbound 850 by providing the failing transaction identifier and the customer entity, then ask the assistant to propose the exact item-lookup record you should create for the missing qualifier/value mapping.

Frequently Asked Questions about item-lookup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fix NetSuite ITEM_LOOKUP_MISSING errors on failing inbound 850 purchase orders?

To fix ITEM_LOOKUP_MISSING errors on inbound 850 purchase orders, you diagnose the failing transaction and line context in NetSuite, correlate it with Orderful PO1 content, and create a scoped customrecord_orderful_item_lookup mapping for the missing qualifier and value.

What causes item mapping failures on inbound EDI 850 transactions in NetSuite?

Item mapping failures on inbound EDI 850 transactions occur when a partner part number and qualifier do not have a matching customrecord_orderful_item_lookup record configured for the customer-specific item lookup in NetSuite.

How do I map a partner part number to a NetSuite item using SuiteQL?

You map a partner part number by using SuiteQL to search the NetSuite item master for candidate matches based on partner SKU text, unit price alignment, and prior purchase history, then propose an approval-gated customrecord_orderful_item_lookup creation plan.

Can I add a missing item qualifier lookup without modifying existing NetSuite cross-qualifier mappings?

Yes, you can add a missing item qualifier lookup without modifying existing records by finding current cross-qualifier mappings and proposing only the specific new customrecord_orderful_item_lookup entry needed for the missing qualifier and value.

What happens when item master candidate matches are ambiguous during 850 error diagnosis?

When item master candidate matches are ambiguous during 850 error diagnosis, the system escalates the issue and refuses to propose unverified item guesses, ensuring only confidence-scored, approval-gated customrecord_orderful_item_lookup records are created.