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
- 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
- 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.