0% found this document useful (0 votes)
295 views24 pages

Edi Inventory Feed Documentation

The document contains a table listing customer/vendors that communicate with the company via EDI, email, or FTP. It includes the communication type, IP address if applicable, user ID, and password for each customer/vendor. It also includes tables with additional details about EDI transactions, file sends, and item number selection criteria for various customers/vendors.

Uploaded by

Vamsi Vellanki
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
295 views24 pages

Edi Inventory Feed Documentation

The document contains a table listing customer/vendors that communicate with the company via EDI, email, or FTP. It includes the communication type, IP address if applicable, user ID, and password for each customer/vendor. It also includes tables with additional details about EDI transactions, file sends, and item number selection criteria for various customers/vendors.

Uploaded by

Vamsi Vellanki
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 24

Customer / Comm IP User ID Password

Vendor Type Address


EDI N/A N/A N/A

AutoZone
EDI N/A N/A N/A

Buckeye Sales (JEGS)


EDI N/A N/A N/A

Gcommerce
EDI N/A N/A N/A

NAPA

MAI ONLY!
EDI N/A N/A N/A

NAPA

MSS ONLY!
EDI N/A N/A N/A

O'Reilly Auto Parts


(Ozark)

MAI ONLY!
EDI N/A N/A N/A
O'Reilly Auto Parts
(Ozark)

MSS ONLY!
EDI N/A N/A N/A

Worldpac
EMAIL N/A N/A N/A

American Crane
& Tractor
EMAIL N/A N/A N/A

Autom Mngmemt Sys-


Motor Parts
EMAIL N/A N/A N/A

Expoquip, Inc
EMAIL N/A N/A N/A

Highway and
Heavy Parts
EMAIL N/A N/A N/A

Meridian Auto Parts


EMAIL N/A N/A N/A

Modern Engine Inc


EMAIL N/A N/A N/A

Morris Automotive
Supply
EMAIL N/A N/A N/A

Off Road Equipment


Parts, Inc
EMAIL N/A N/A N/A

Real Street Performance


EMAIL N/A N/A N/A

Reliant Gasket
EMAIL N/A N/A N/A

Turn 14
Distribution
FTP 205.132.9.204 078388571 Ymdg39Ya

Advance Auto Parts


FTP 12.157.136.12 apwclvt clvt1701

APW Knox-Seeman
Whse, Inc.
FTP 216.244.126.132 automotive_ bBb272djs72gdmmdg
supply3_ebay

Automotive
Supply Inc
FTP 47.22.154.116 mahle qooC3UhkCiHF

FCP Euro
FTP 216.49.105.94 MeyerCLE MeyerCLE2016

Meyer
Distributing Inc
FTP 67.214.129.14 mahle aut0parts!

Parts Authority
FTP 216.21.167.187 mahle motorville14

Selco, Inc.
FTP 192.249.121.46 vendor_mah@ 0Sr3ab9o
stockwiseauto.com

Stockwise Auto
FTP 12.176.129.204 cle Cle7it3$

Summit Racing
Equipment

Performance Warehouse

Motor State
Transmission File Send Send Program Robot
E-mail Address Type Frequency Time Name(s) Name
N/A EDI Daily 4:25 - EDIC116 EDI_007
(every 60 21:30 EDIR116
minutes)

N/A EDI Daily 19:35 EDIC124 EDI_004


EDIR124

N/A EDI Daily (2x) 5:05 EDIC115 EDI_020


12:00 EDIR115

N/A EDI Daily 5:07 EDIC112 EDI_021


EDIR112

N/A EDI Daily 10:05 EDIC112 EDI_024


EDIR112

N/A EDI Daily 19:35 EDIC124 EDI_004


EDIR113

N/A EDI Daily 10:00 EDIC113 EDI_023


EDIR113
N/A EDI Daily 8:15 EDIC119W EDI_025
EDIR119W

[email protected] CSV Daily 5:45 EDIC219 EDI_003


EDIR219

[email protected] TXT Daily 6:05 EDIC228A EDI_013


EDIR228A

[email protected] CSV Daily 5:00 EDIC231 EDI_016


EDIR231

niseler@ CSV Daily 6:07 EDIC229 EDI_014


highwayandheavyparts.com EDIR229

[email protected] TXT Daily 5:52 EDIC228 EDI_011


EDIR228

aa@modernengine CSV Daily 5:57 EDIC220 EDI_012


EDIR220

[email protected] TXT Daily 5:49 EDIC227 EDI_010


EDIR227
[email protected] CSV Daily 5:47 EDIC222 EDI_005
EDIR222A
EDIR222

parts@ CSV Daily 5:48 EDIC125 EDI_009


realstreetperformance.com EDIR125

[email protected] CSV Daily 5:00 EDIC234 EDI_016


EDIR234

[email protected] CSV Daily 9:30 EDIC237 EDI_022


EDIR237

N/A CSV Daily (3x) 8:00 EDIC218 EDI_006


12:00 EDIR218
17:00 FTPCMD51
N/A TXT Daily 4:30 FTPBAT46 EDI_001
APWQFIL1
APWQFIL2
APWQFIL3
FTPCMDS46

N/A CSV Daily 5:03 EDIC235 EDI_018


EDIR235
FTPCMD235

N/A CSV Daily 6:00 EDIC238 EDI_026


EDIR238
FTPCMD238

N/A CSV Daily 4:48 EDIC236 EDI_019


EDIR236
FTPCMD236
N/A CSV Daily 19:00 EDIC232 EDI_015
EDIR232
FTPCMD232

N/A CSV Daily 00:30 EDIC225 EDI_008


EDIR225
FTPCMDS52
EDIC225M
EDIR225M
FTPCMDS52M

N/A CSV Daily 5:02 EDIC233 EDI_017


EDIR233
FTPCMD233

N/A CSV Daily 00:45 FTPBAT50 EDI_002


EDIR217
FTPCMDS50

Daily

Daily
Transaction Map (EDI) or Item Number
Target File Name (Email/FTP) Selection Criteria
AZ846 WHS = 05 or 22 and
STS <> DN, SN and
POP CODE <> K, N and
ITEM in INVP105X (customer part interchange file)

JEGS846 WHS = 05 or 22 and


STS <> DN and
INV TYP <> KIT and
POP CODE <> K, N, O, P and
BRAND <> CP, CX, OE and
POSITION 15 of ITEM = blank

VIC846 WHS = 05 or 22 and


STS <> DN, SN and
INV TYP = F/G and
POP CODE <> K, N, O, P and
BRAND <> CP, MX and
PRICE CLASS <> FEL, MMP and
DIST CODE = 23 and
PRICE CODE = 001 and
POSITION 15 of ITEM <> B, C and
ITEM not in EDIP846E (VIC part exception file)

NAPA846A WHS = 05 or 22 and


STS <> DN, SN and
POP CODE <> K, N, and
PRICE CODE = 343

NAPA846 WHS = 08 and


STS <> DN, SN and
POP CODE <> K, N, and
PRICE CODE = 450

OZK846 WHS = 05 or 22 and


STS <> DN, SN and
POP CODE <> K, N and
BRAND = CL or MA and
PRICE CODE = 333

OZK846M WHS = 08 and


STS <> DN, SN and
POP CODE <> K, N and
PRICE CODE = 10, 620
WPAC846 WHS = 05 or 22 and
STS <> DN and
INV TYP <> KIT and
POP CODE <> K, N, O, P and
BRAND <> CP, CX, OE and
DIST CODE = 23 and
PRICE CODE = 365

edip219.csv WHS = 05 or 22 and


STS <> DN and
INV TYP <> KIT and
POP CODE <> K, N, O, P and
BRAND <> CP, CX, OE and
PRICE CODE = 005 or 348 and
POSITION 15 of ITEM = blank

wsheet.txt WHS = 05 or 22 and


STS <> DN, SN and
((POP CODE <> K, N, O, P or
(POP CODE = G and QTY AVAIL > 0)) and
POSITION 15 of ITEM = blank

mahle_edip231.csv WHS = 05 or 22 and


STS <> DN and
POP CODE <> K, N, O, P and
PRICE CODE = 001

wsheet.txt WHS = 05 or 22 and


STS <> DN, SN and
((POP CODE <> K, N, P or
(POP CODE = G and QTY AVAIL > 0)) and
POSITION 15 of ITEM = blank

wsheet.txt WHS = 05 or 22 and


STS <> DN, SN and
((POP CODE <> K, N, O, P or
(POP CODE = G and QTY AVAIL > 0)) and
POSITION 15 of ITEM = blank

mahle.csv WHS = 05 or 22 and


STS <> DN, SN and
((POP CODE <> K, N, O, P or
(POP CODE = G and QTY AVAIL > 0)) and
CLASS = 10, 15, 30, 60, 65, 75 and
POSITION 15 of ITEM = blank

z03.txt WHS = 22
STS <> DN, SN and
POP CODE <> K, N, O, P
edip222.csv WHS = 05 or
(WHS = 22 and INV TYP <> KIT)

edip125.csv WHS = 05 or 22 and


STS <> DN, SN and
POP CODE <> K, N, O and
CLASS = 30

mahle_edip234.csv WHS = 05 or 22 and


STS <> DN and
POP CODE <> K, N, O, P and
PRICE CODE = 001

mahle_edip237.csv WHS = 05 or 22 and


STS <> DN and
POP CODE <> K, N, O, P and
PRICE CODE = 001

csvp218.csv WHS = 05 and


PRICE CODE = 360

File 1: clevite.txt File 1: WHS = 22 and STS <> DN, SN and CLASS <> 15, 60
File 2: perfect.txt File 2: WHS = 22 and STS <> DN, SN and CLASS = 15
File 3: victor.txt File 3: WHS = 22 and STS <> DN, SN and CLASS = 60

csvp23520180730.csv WHS = 05 or 22 and


(csvp235ccyymmdd.csv) STS <> DN and
POP CODE <> K, N, O, P and
PRICE CODE = 001 and
MIN ORD QTY < 2

mahle_mai_238.csv WHS = 05 or 22 and


STS <> DN, SN and
POP CODE <> K, N, O, P and
PRICE CODE = 001

meyer_dropship_236.csv WHS = 05 or 22 and


STS <> DN and
POP CODE <> K, N, O, P and
PRICE CODE = 001 and
MIN ORD QTY < 2
csvp232.csv WHS = 05 or 22 and
PRICE CODE = 001

File 1: clevite.csv WHS = 05 or 22 and


File 2: mahleboh.csv STS <> DN, SN and
INV TYP <> BUL, CON, KIT and
POP CODE <> K, N, O, P and
BRAND <> BU, CP, CX, FM, OE and
CLASS <> 80, 90 and
GROUP <> 100001, 121000, 155501, 161000, 200001,
300001, 306406, 311000, 400001, 500001, 557500, 601001,
603007, 700001, 750001 and
POSITION 1-2 of ITEM <> HD and
POSITION 15 of ITEM = blank

csvp233.csv WHS = 05 or 22 and


STS <> DN and
POP CODE <> K, N, O, P and
PRICE CODE = 001

mahleclevite.csv WHS = 05 or 22 and


STS <> DN and
INV TYP <> KIT and
POP CODE <> K, N, O, P and
BRAND <> CP, CX, OE and
POSITION 15 of ITEM = blank

WHS = 05 or 22 and
STS <> DN and
INV TYP <> KIT and
POP CODE <> K, N, O, P and
BRAND <> CP, CX, OE and
POSITION 15 of ITEM = blank

WHS = 05 or 22 and
STS <> DN and
INV TYP <> KIT and
POP CODE <> K, N, O, P and
BRAND <> CP, CX, OE and
POSITION 15 of ITEM = blank
Item Quantity
Selection Criteria
If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 500, set QTY AVAIL = 500

If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100


If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL = 0, skip record

If QTY AVAIL > 500, set QTY AVAIL = 500

If QTY AVAIL >= 0 and < 9999, send record

If QTY AVAIL > 200, set QTY AVAIL = 200

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0 and < 9999, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0 and < 9999, send record

If QTY AVAIL > 200, set QTY AVAIL = 200

If QTY AVAIL >= 0 and < 9999, send record

If QTY AVAIL > 200, set QTY AVAIL = 200

If QTY AVAIL >= 0 and < 99999, send record

If QTY AVAIL > 2, set QTY AVAIL = 2


If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If INV TYP = KIT, set QTY AVAIL = 1

If QTY AVAIL >= 0, send record

If QTY AVAIL > 500, set QTY AVAIL = 500

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100


All files: If QTY AVAIL > 0 and < 9999000, send record

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100


If QTY AVAIL >= 0, send record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL >= 0, send record

If QTY AVAIL > 200, set QTY AVAIL = 200

If QTY AVAIL = 0 and WHS = 22, skip record

If QTY AVAIL > 100, set QTY AVAIL = 100

If QTY AVAIL = 0, skip record

If QTY AVAIL > 500, set QTY AVAIL = 500


Notes Contact
Name
Send multiple warehouses in one cumulative record.

Send multiple warehouses in one cumulative record.

If QTY AVAIL = 0, retrieve ETA date from PO detail file.


If QTY AVAIL > 0, do not retrieve ETA date.

Send separate records for each warehouse.

If price code not found, do not send item.


Replace following item desc characters with blanks:
`~!@#$%¢&*{}¬¦|:;"<,>.?/

Run twice as follows:


Run 1: Warehouse 05
Run 2: Warehouse 22

Send separate records for each warehouse.

If price code not found, do not send item.

Run twice as follows:


Run 1: Warehouse 05
Run 2: Warehouse 22

If price code not found, do not send item.

Replace following item desc characters with blanks:


`~*¬¦|:">

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

If price code not found, do not send item.


Send separate records for each warehouse.

If price code not found, do not send item.

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

Replace following item desc characters with blanks:


`~!@#$%¢&*{}¬¦|:;"<,>.?/

Send individual warehouses in one record (file contains


separate fields for each warehouse).

Retrieve price using PRICE CODE = 001.

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

Send individual warehouses in one record (file contains


separate fields for each warehouse).

Retrieve price using PRICE CODE = 001.

If price code not found, do not send item.

Send individual warehouses in one record (file contains


separate fields for each warehouse).

Send individual warehouses in one record (file contains


separate fields for each warehouse).

Send multiple warehouses in one cumulative record.

If QTY AVAIL = 0, retrieve ETA date from PO detail file.


If QTY AVAIL > 0, do not retrieve ETA date.

Retrieve price using PRICE CODE = 001.


Send separate records for each warehouse.

Retrieve price using PRICE CODE = 348.

Send multiple warehouses in one cumulative record.

If QTY AVAIL = 0, retrieve ETA date from PO detail file.


If QTY AVAIL > 0, do not retrieve ETA date.

Retrieve price using PRICE CODE = 001.

Replace ',' with '.' in item description.

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

If price code not found, do not send item. Reeda Dunford

Send all three files in one transmission. Charles

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

Replace following item desc characters with blanks:


`~!@#$%¢&*{}¬¦|:;"<,>.?/

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.


Send separate records for each warehouse.

Retrieve price using PRICE CODE = 001.

If price code not found, do not send item.

Send multiple warehouses in one cumulative record.

Run twice as follows:


Run 1: Set EDIID (line code) = CLE
Run 2: Set EDIID (line code) = MHL

Send multiple warehouses in one cumulative record.

If price code not found, do not send item.

Send separate records for each warehouse. Cheryl Ives


Contact Contact
E-mail Address Phone Number
[email protected] 540-561-1711

[email protected] 310-884-5000 x 124


[email protected]

[email protected] 330-633-2555 x 7262

You might also like