EDI Order Consolidation

EDI Order Consolidation by the Brand Owner

There are several business scenarios where order consolidation can be used by the brand owner. The following is just one example presented by GS1.

A brand owner has received two or more purchase orders from a retailer. The products contained in those orders are in different department or class numbers in the retailer’s system but are housed or displayed in close physical proximity to each other, in a store location or within the retailer’s location. By combining these purchase orders on a single ASN and in a carton for shipment, the merchandise will arrive at the retailer’s location using fewer cartons and will be shipped at less expense.

An example of this use case is a retailer sends several different purchase orders to a brand owner:

  • PO # 1234567 for Dept 555 (Girl’s 4-6x) for dresses (quantity of 2 items)
  • PO # 2234567 for Dept 575 (Boy’s Toddlers) for pants and T-Shirts (quantity of 3 items total)
  • PO # 3234567 for Dept 532 (Infants) for onesies (quantity of 2 items).

All of these items are merchandised in the store in the Children’s Department and could all fit easily into a single carton. They also have the same or similar PO ship windows, are shipped from the same brand owner distribution center (DC), and have the same payment terms. The brand owner creates an ASN that combines this merchandise from multiple purchase orders to reduce the amount of corrugate used (cartons) and to minimize the order shipping and handling costs.

Structure

The Shipment, Package, Order, Item SPOI structure, (pronounced ‘SPOI’) identifies the 856 Advance Ship Notice / Manifest or ASN structure in the BSN (Beginning Segment for Ship Notice) where BSN05 =0003 (Shipment, Packaging, Order, Item). There are a total of 83 codes delineated in the BSN (Beginning Segment for Ship Notice), they appear in the same order as they were developed prior to 1998 (v4010). The BSN05 suggests the hierarchy of the physical shipment which is described in the electronic version (856 Advance Ship Notice / Manifest) of the shipment in the order of appearance that being Shipment, Packaging, Order, and Item.

1 ST*856*0001
2 BSN*00*GlobalShpmentIdNo*21080819*2120*0003
3 HL*1**S
4 TD1**1****G*20.00*LB
5 TD5**2*UPSN*U*UPS*CC
6 REF*BM*BOLIdNo
7 MAN*SM*ShpmentIdNo
8 DTM*011*20181114*2120
9 N1*BY*CompanyName*UL*GobalLocationNumber
10 N2*AltName1*AltName2
11 N3*Addess1*Address2
12 N4*CityName*ST*C*C****Postal-Code
13 N1*BY*CompanyName*UL*GobalLocationNumber
14 N2*AltName1*AltName2
15 N3*Addess1*Address2
16 N4*CityName*ST*C*C****Postal-Code
17 HL*2*1*P
18 MAN*GM*005061414199999999999
19 HL*3*2*O
20 PRF*8195447387***20180814
21 HL*4*3*I
22 LIN**UP*614141025664*UK*00614141026664
23 SN1**120*EA
24 PID*F****Product or Item Description
25 HL*5*2*O
26 PRF*8195447288***20180814
27 HL*6*5*I
28 LIN**UP*614141025657*UK*00614141025657
29 SN1**120*EA
30 PID*F****Product or Item Description
31 CTT*6
32 SE*32*0001

The use of this structure is recommended because it uses existing standards and known data structures.

The ASN structures as defined within the VICS publications3 allows for several ASN structures or styles4 to exist. The SPOI structure allows more than one full order to be packed into the same carton aligning well with the guidance which follows.

Leave a Reply

Your email address will not be published.

Post Navigation