GET api/product/{id}/orderLookup

Order History information

Request Information

URI Parameters

NameDescriptionTypeAdditional information
id

Product identifier

globally unique identifier

Required

Body Parameters

None.

Response Information

Resource Description

Order detail and history information

OrderDetailLookup
NameDescriptionTypeAdditional information
PLUG_UID

Collection of byte

None.

PluGuid

globally unique identifier

None.

InventoryGuid

Collection of byte

None.

InventoryIdentifier

globally unique identifier

None.

AverageWeeklySales

decimal number

None.

PromotionalAverageWeeklySales

decimal number

None.

InventoryAverageWeeklySales

decimal number

None.

InventoryPromotionalAverageWeeklySales

decimal number

None.

OnHand

integer

None.

OnHandPacks

integer

None.

OnOrder

integer

None.

OnOrderPacks

integer

None.

Accuracy

integer

None.

LastOrdered

date

None.

LastOrderQuantity

decimal number

None.

LastReceived

date

None.

LastReceivedQuantity

decimal number

None.

LastInvoiceStatus

ProductStatus

None.

Response Formats

application/json, text/json

Sample:
{
  "pluG_UID": "MVQu3/MuMUO/ipKtWK9Kdg==",
  "pluGuid": "df2e5431-2ef3-4331-bf8a-92ad58af4a76",
  "inventoryGuid": "95vvrink2kact/TyKeAyQg==",
  "inventoryIdentifier": "aeef9bf7-e429-46da-9cb7-f4f229e03242",
  "averageWeeklySales": 1.0,
  "promotionalAverageWeeklySales": 1.0,
  "inventoryAverageWeeklySales": 1.0,
  "inventoryPromotionalAverageWeeklySales": 1.0,
  "onHand": 1,
  "onHandPacks": 1,
  "onOrder": 1,
  "onOrderPacks": 1,
  "accuracy": 1,
  "lastOrdered": "2025-10-04T23:59:27.4400305",
  "lastOrderQuantity": 1.1,
  "lastReceived": "2025-10-04T23:59:27.4400305",
  "lastReceivedQuantity": 1.1,
  "lastInvoiceStatus": 1
}

application/xml, text/xml

Sample:
<OrderDetailLookup xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.Orders">
  <Accuracy>1</Accuracy>
  <AverageWeeklySales>1</AverageWeeklySales>
  <InventoryAverageWeeklySales>1</InventoryAverageWeeklySales>
  <InventoryGuid>95vvrink2kact/TyKeAyQg==</InventoryGuid>
  <InventoryIdentifier>aeef9bf7-e429-46da-9cb7-f4f229e03242</InventoryIdentifier>
  <InventoryPromotionalAverageWeeklySales>1</InventoryPromotionalAverageWeeklySales>
  <LastInvoiceStatus>1</LastInvoiceStatus>
  <LastOrderQuantity>1.1</LastOrderQuantity>
  <LastOrdered>2025-10-04T23:59:27.4400305+00:00</LastOrdered>
  <LastReceived>2025-10-04T23:59:27.4400305+00:00</LastReceived>
  <LastReceivedQuantity>1.1</LastReceivedQuantity>
  <OnHand>1</OnHand>
  <OnHandPacks>1</OnHandPacks>
  <OnOrder>1</OnOrder>
  <OnOrderPacks>1</OnOrderPacks>
  <PLUG_UID>MVQu3/MuMUO/ipKtWK9Kdg==</PLUG_UID>
  <PluGuid>df2e5431-2ef3-4331-bf8a-92ad58af4a76</PluGuid>
  <PromotionalAverageWeeklySales>1</PromotionalAverageWeeklySales>
</OrderDetailLookup>

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Sample:
PKm�D[<q迶5xl/workbook.xml �(�����@�{��r��䠢���_a��O�����O ��ۙ��v�h\�4�g5h���w!���)�'cIO��8�a���meM��ߊt�$�2p4`�F�NZ�W�?,oa�;����Pj^����C��9[��d���7%�~�(�QQ�+���ܚ�ǜ�\N�=N)����5M�Q���l��/PKm�D[����	�[Content_Types].xml �(����J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
m�D[��;''_rels/.rels �(�<?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R90d6ae1cc56e48e1" /></Relationships>PKm�D[Eyx��
xl/worksheets/sheet1.xml �(���Is�0�������ڕRIY&+���Dpc�vB~�c���\@���k��J0:��6ΧN�0ގ]����"^�۷����~H�|2���{��:s�Mϒ��βݙ溜���ԋwzkj�8���<&o~�Z�=���f>F�����i���]�ݾ��,�-D��U�[w2Z����{'ѫ�{gs�:�d�ÿB�Okk��&����p��(g�<˛�$�R���M6���:|[gfH,�,�M�:Qx��D�W����ڬ��8�R�@(�:��4���E�t9�q��'=0B%%�BbjדBO���� ��R!�zZ�i�?bS)��@�]�
=��+�Qΰ\I%���?�(A
�A�^zq�c�)��
!0��e��U�W�@c���U�W'��"��*���A�0bN
+6�Nу�]����Œ(N�@�8��R�m�L�KJ <pnP��������"l���A-{�s"(2�†����=��Z��9E��>�0�:�2�P%��)��`�`����"�o�i��Q�$/����,���3�Wj.��	��mA\v	hW]7�i� M�K�&1��I�t	�$n��hw]B6��.���Ϟ����Ѓ���؃���ԃ���܃��҃�&�ڃ�F;�A���&x���*}�+j���i��j�e�Ep�H�K�'�3K��R����,�{K���`�=ZjO�e�P���8&@e}n�x�����^�F���s��n����Yg:�����_PKm�D[ �d�Pxl/_rels/workbook.xml.rels �(���Mn� F��f_���(N6�t��ۊ
Hۜ���W(j��H]t��o��i������m��:?�C�1 ����z8����v�Ǚ�xÏ��$>Ѿ�1��ԋ�3cQǎ2n�!�n�����5ԥ�e�����F�I��u�L_�;�19p7`��'���ȳH�${��59�vuQ1��wS��2����։�۲æ)U%e}W��;����M�Ni���U�*K�u�:���Ϳ�~PKm�D[Ѓc'2E
xl/styles.xml �(��S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v�F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}���LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PKm�D[{z�d^xl/sharedStrings.xml �(���kK�0��J���[Vw���u x��"r��l�6�����(:�+�����yxONHv�V������l����R�U����E��H(���5�YtTd�SP�s�&�&�k����Mp�uP8�U�7A�5"Ue���QR�6,�6�3>`Qm�k��;!D�"���jq񼘝e	Y�}�e}Qkٖgf���k~5g2�Zit��0X��K�̡D��le)�ʿ�w��(�W����ӭހx���ܿ��܉Q;M[�O��5��nk��N��m7���Ƈ�Y-pN@�^���V�����mJ�� b�j�ð[�	�S�`*�����.�8ƔO�t$C�X�c�*Χ���0I� �;PK-m�D[<q迶5xl/workbook.xmlPK-m�D[����	��[Content_Types].xmlPK-
m�D[��;''U_rels/.relsPK-m�D[Eyx��
�xl/worksheets/sheet1.xmlPK-m�D[ �d�Pxl/_rels/workbook.xml.relsPK-m�D[Ѓc'2E
Gxl/styles.xmlPK-m�D[{z�d^�	xl/sharedStrings.xmlPK�r

application/vnd.ms-excel

Sample:
PKm�D[m�˶�5xl/workbook.xml �(�����0D�&�C���(R8q���{�Eh�ik��-H�yۙ�};bB7<�ѣ�+i�-�MZ�Z0qס�2D�^�N5Pc��`;'I��2(4�W�ӕ��[��=@���RZ����C�����l���oJ,��bQ�H
%�e��,έ-)��*�,�y�r�d�撤q��w�`���PKm�D[����	�[Content_Types].xml �(����J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
m�D[���''_rels/.rels �(�<?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="Ra9f6146d2d2b434a" /></Relationships>PKm�D[Eyx��
xl/worksheets/sheet1.xml �(���Is�0�������ڕRIY&+���Dpc�vB~�c���\@���k��J0:��6ΧN�0ގ]����"^�۷����~H�|2���{��:s�Mϒ��βݙ溜���ԋwzkj�8���<&o~�Z�=���f>F�����i���]�ݾ��,�-D��U�[w2Z����{'ѫ�{gs�:�d�ÿB�Okk��&����p��(g�<˛�$�R���M6���:|[gfH,�,�M�:Qx��D�W����ڬ��8�R�@(�:��4���E�t9�q��'=0B%%�BbjדBO���� ��R!�zZ�i�?bS)��@�]�
=��+�Qΰ\I%���?�(A
�A�^zq�c�)��
!0��e��U�W�@c���U�W'��"��*���A�0bN
+6�Nу�]����Œ(N�@�8��R�m�L�KJ <pnP��������"l���A-{�s"(2�†����=��Z��9E��>�0�:�2�P%��)��`�`����"�o�i��Q�$/����,���3�Wj.��	��mA\v	hW]7�i� M�K�&1��I�t	�$n��hw]B6��.���Ϟ����Ѓ���؃���ԃ���܃��҃�&�ڃ�F;�A���&x���*}�+j���i��j�e�Ep�H�K�'�3K��R����,�{K���`�=ZjO�e�P���8&@e}n�x�����^�F���s��n����Yg:�����_PKm�D[S�\�Pxl/_rels/workbook.xml.rels �(���Kn�0@�b;��LB*�n�.0u�IDbG�i�l]�H�B�"�F�V��==i���c�=O#{%g��FV�v�]�hV�ݬw4bL���Ҋ

�1Ώ��ӄ�p3��1�OS�;>�>bG|!D�}΀[&;\f��3hzr�4��������E`��~J�Y$*�綁]Uײm��R+QJ`�nj!^F
�^�<�)�~)uE5��������G�.�;��LMJ��HY)�R�����|PKm�D[Ѓc'2E
xl/styles.xml �(��S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v�F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}���LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PKm�D[{z�d^xl/sharedStrings.xml �(���kK�0��J���[Vw���u x��"r��l�6�����(:�+�����yxONHv�V������l����R�U����E��H(���5�YtTd�SP�s�&�&�k����Mp�uP8�U�7A�5"Ue���QR�6,�6�3>`Qm�k��;!D�"���jq񼘝e	Y�}�e}Qkٖgf���k~5g2�Zit��0X��K�̡D��le)�ʿ�w��(�W����ӭހx���ܿ��܉Q;M[�O��5��nk��N��m7���Ƈ�Y-pN@�^���V�����mJ�� b�j�ð[�	�S�`*�����.�8ƔO�t$C�X�c�*Χ���0I� �;PK-m�D[m�˶�5xl/workbook.xmlPK-m�D[����	�[Content_Types].xmlPK-
m�D[���''V_rels/.relsPK-m�D[Eyx��
�xl/worksheets/sheet1.xmlPK-m�D[S�\�Pxl/_rels/workbook.xml.relsPK-m�D[Ѓc'2E
Gxl/styles.xmlPK-m�D[{z�d^�	xl/sharedStrings.xmlPK�r