Explaining EDI: Guide to Field Limitations

SHARE
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Below is your guide to EDI (Electronic Data Interchange) field limitations, including character quantity and special characters usage.

Field Limitations: Character limit

  • SKU – 48 character limit
  • SKU description field – 45 character limit
  • SKU length – 8 character limit
  • SKU width – 8 character limit
  • SKU height – 8 character limit
  • SKU weight – 8 character limit
  • Lot code – 12 character limit

Field Limitations: Restricted Characters for SKU or Name/Product Description Fields

  • Do not use the following:  * : ; & , . / ? ! ^ % ~ + “
    • Exceptions: dates and special instructions
  • Do not use apostrophes at the end of a word.
      • If it is in the middle of the word, then it is okay.
  • Decimals are usually okay.
  • Underscore and hyphens are fine.
  • () {} [] are only allowed in text fields (not in dates or math).

Related Reading: Explaining EDI – 200 Transaction Codes

Field Limitations: Special Characters

It is best practice to avoid commas, pipes, asterisks, and back or forward slashes. These are often used in EDI as segment or line terminators and can cause issues with mapping. As we move away from the use of CSV files towards other EDI translation options, the restrictions on data are diminishing but, for now, avoid using the following: * % ? . * \ | /:

New to EDI? Check out our post: What is EDI (Electronic Data Interchange)?

SSO post header

When to do SSOs (Store-Specific Orders)

There are many reasons for creating a store-specific order, but the main idea is that they are entered when a store needs more product than is currently in the pipeline. Here are some reasons for creating an SSO.

Read More »

What Are the Most Common Walmart Deductions Codes?

Ever get a check back from Walmart with big, fat negative numbers and some mystery codes attached to them? Walmart will sometimes subtract deductions from your invoiced amount for various infractions and label them with corresponding reason codes. The three most common adjustment codes are 22, 24, and 25.

Read More »
Otif Part 3

Improving OTIF Performance

Making sure you are compliant with OTIF requirements can be tricky. You’ll need to do in-depth analysis into potential issues, such as warehouse issues and carrier delays. The various silos of your organization must interact with each other to ensure full compliance and prevent future chargebacks from happening.

Read More »

Why is OTIF Important?

Not complying with your purchasers’ OTIF requirements can be very costly, and result in hefty fines. For example, Walmart fines its vendors 3% of the cost of goods sold if the order fails OTIF requirements. In 2016, Target stores increased their OTIF penalties to 5% of the order cost, five times what it previously was. That kind of money adds up!

Read More »

How to explain OTIF to your 5-year-old

OTIF stands for On Time In Full and is a key performance indicator (KPI) of your products’ supply chain. OTIF is a crucial measurement of how well your operations team fulfills your orders according to the requirements of your customers.

Read More »
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Contact us

Drop your information in our handy form, including a brief message of what you’re looking for, and one of our sales experts will get back to you as soon as possible!

Headquarters

3739 N Steele Blvd,
Ste 300
Fayetteville, AR 72703
479-385-7472

Seattle Office

1700 Seventh Ave,
Ste 2100
Seattle, WA 98101