Item Lookup

Item Lookups should be considered an exception. By default, we will attempt to match your items based on the following logic.

itemid or the custom field set in Global Settings for the SKU FIELD

VN : Vendor's (Seller's) Item Number
VP : Vendor's (Seller's) Part Number

upccode or the custom field set in Global Settings for the Item UPC Code

UP : U.P.C. Consumer Package Code (1-5-5-1)
UK : U.P.C./EAN Shipping Container Code (1-2-5-5-1)
EN : European Article Number (EAN) (2-5-5-1)

If your partner uses a qualifier outside of this list but it still matches either itemid or upccode, you could write a rule in Orderful to copy it using a qualifier from the list. With a rule, you can skip maintaining the item lookup!

We recommend copying the item identifier to an empty pair. This means the original pair will automatically write to outbound transactions possibly reduce rules on the way back.

Examples

Write a rule to copy the VC pair to an unused productServiceID pairing using the VN qualifier instead

IF(EQUALS("VC", $transactionSets.*.PO1_loop.*.baselineItemData.*.productServiceIDQualifier), SET("VN))

IF(EQUALS("VC", $transactionSets.*.PO1_loop.*.baselineItemData.*.productServiceIDQualifier), SET($transactionSets.*.PO1_loop.*.baselineItemData.*.productServiceID))

Write a rule to copy UA an unused productServiceID pairing using the UP qualifier instead.

IF(EQUALS("UA", $transactionSets.*.PO1_loop.*.baselineItemData.*.productServiceIDQualifier), SET("UP"))

IF(EQUALS("UA", $transactionSets.*.PO1_loop.*.baselineItemData.*.productServiceIDQualifier), SET($transactionSets.*.PO1_loop.*.baselineItemData.*.productServiceID))

If your partner only provides their identifiers or you have a unique item setup for a specific partner, then an item lookup will get the job done.

Subsidiary Select if this item lookup should be limited to a specific subsidiary (optional).
Item Select the NetSuite to return based on the lookup.
Product Qualifier Choose which type of item identifier you would like to match from your partner.
Qualifier Value Enter your customers unique item value here.