Skip to content
  • There are no suggestions because the search field is empty.

How to Map Worldpac 23-Character Product Codes

This article explains how to properly map Worldpac's 23-character product codes in Spark. Worldpac uses a specific format that must be followed exactly to ensure successful order processing.

The Worldpac product code consists of 23 characters divided into two main sections:
  • Product Code (Positions 1-20)
  • Brand Code (Positions 21-23)

Format Breakdown

  1. Product Code Section (20 characters)

The Product Code can consist of a combination of letters, numbers, and hyphens. It may also include empty spaces, which should be filled with blank spaces to maintain uniformity. Here are some examples of valid Product Codes:

  • A6000-13782
  • W0133-254683
  • 63 21 7 372 793
  • 63 21 7 313 039

 

  1. Brand Code Section (3 characters)

This section consists of exactly 3 alphabetical characters, which uniquely identify the brand associated with the product.

Examples include:

  • MAN (Mann)
  • AE (AE)
  • OES (OE Supplier)
  • TYC (TYC)

Important Requirements

Product Code Guidelines

  • The product code must be left-aligned within a 20-character space.
  • Fill any unused positions with blank spaces to ensure a complete 20-character length.
  • It is essential to preserve the original formatting, including any spaces and hyphens present in the product code.
  • The total length of the product code must be precisely 23 characters.

Implementation Checklist

  • ✓ Ensure the original formatting of the product code is retained.
  • ✓ Pad the product code section with spaces to achieve a total of 20 characters.
  • ✓ Confirm the overall length is exactly 23 characters.
  • ✓ Maintain all existing spaces and hyphens in the product code.
  • ✓ Position the brand code in the final three character spaces.

Note: Failing to adhere to these formatting guidelines may lead to issues with order processing. Always double-check the format before submission.

Example Worldpac SKU Mappings

A6000-13782         MAN
W0133-254683        AE
63 21 7 372 793     OES
63 21 7 313 039     TYC
48510-35080         TYT
LF-3321             FRM
P550335             DFL
WIX-51348           WIX
15400-PLM-A02       HON
04152-YZZA1         TOY

 

Each example above follows these rules:

  • Total length is exactly 23 characters
  • Product code uses first 20 spaces (including any spaces needed for padding)
  • Brand code uses last 3 positions
  • Original formatting (spaces/hyphens) is preserved

Common brand codes (These may be outdated so please refer to known brand codes):

  • MAN - Mann
  • AE - AE
  • OES - OE Supplier
  • TYC - TYC
  • TYT - Toyota
  • HON - Honda
  • FRM - Fram
  • WIX - Wix
  • DFL - Delphi
  • TOY - Toyota

How Spark Shipping Uses This Code

  • Spark Shipping sends the Vendor SKU to Worldpac exactly as it is mapped, both when checking inventory and when placing orders, and asks Worldpac for an exact match. It does not add spaces or the brand code for you, so the Vendor SKU itself must be in the 23-character format above.
  • Worldpac does not provide a product catalog through Spark Shipping, so each product must be mapped to its Worldpac code.
  • To connect, enter your Customer Account Number, API Key, API Token and Environment under Credentials.