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