Amazon Vendor Central - ASN 856 - Hierarchical Parent ID Numbers

Integrator.io
,
1

The pre-built template for AVC 856s has this for the HL section:

{
"name": "HL",
"required": true,
"maxOccurrence": 1000,
"relativeDataPath": "Shipment",
"elements": [
{
"name": "HL",
"value": "HL"
},
{
"name": "Hierarchical ID Number",
"counter": true,
"value": "{{{_counter.[Hierarchical ID Number]}}}"
},
{
"name": "Hierarchical Shipment Parent ID Number",
"value": "{{{[Hierarchical Shipment Parent ID Number]}}}"
},
{
"name": "Hierarchical Shipment Level Code",
"value": "S"

This part is working correctly: "value": "{{{_counter.[Hierarchical ID Number]}}}", where it creates a new number for each subsequent Hierarchical ID Number. However, this is not generating any values in the output: "value": "{{{[Hierarchical Shipment Parent ID Number]}}}".

What or how should this be configured so that the {{{[Hierarchical Shipment Parent ID Number]}}} is generating the correct numbers?

Thanks,

Cory

2

Hi Cory Anderson,
For the pre-built template for 856's, We are working on the same to generate the values for the Hierarchical Parent ID Numbers for all HL-Segments.
As a workaround, if you are exporting only 1 record from the export which consists of 1 shipment with 1 order, 1 order with 1 tare, 1 tare with 1 package, 1 package with multiple items.
We can hardcode the Hierarchical Parent ID Numbers. For Shipment Hierarchical Parent ID will be empty and the Shipment Hierarchical ID Number will be 1, for Order Hierarchical Parent ID will be 1 and Order Hierarchical ID Number will be 2, for Tare Hierarchical Parent ID will be 2 and Tare Hierarchical ID Number will be 3 and so on.
The expected output will be
HL*1**S~
HL*2*1*O~
HL*3*2*T~
HL*4*3*P~
HL*5*4*I~
HL*6*4*I~
HL*7*4*I~

Hope this helps!

3

Has there been any update on this? I've seen counters and there doesn't seem to be anyway for celigo to handle the HL levels for us. Is that actually the way it works?

It seems like a very limiting assumption to think that there is only 1 of each item.

4

Hi Cory Anderson,
For the pre-built template for 856's, We are working on the same to generate the values for the Hierarchical Parent ID Numbers for all HL-Segments.
As a workaround, if you are exporting only 1 record from the export which consists of 1 shipment with 1 order, 1 order with 1 tare, 1 tare with 1 package, 1 package with multiple items.
We can hardcode the Hierarchical Parent ID Numbers. For Shipment Hierarchical Parent ID will be empty and the Shipment Hierarchical ID Number will be 1, for Order Hierarchical Parent ID will be 1 and Order Hierarchical ID Number will be 2, for Tare Hierarchical Parent ID will be 2 and Tare Hierarchical ID Number will be 3 and so on.
The expected output will be
HL*1**S~
HL*2*1*O~
HL*3*2*T~
HL*4*3*P~
HL*5*4*I~
HL*6*4*I~
HL*7*4*I~

Hope this helps!

5

Has there been any update on this? I've seen counters and there doesn't seem to be anyway for celigo to handle the HL levels for us. Is that actually the way it works?

It seems like a very limiting assumption to think that there is only 1 of each item.