GET api/product/{id}/orderLookup
Order History information
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Product identifier |
globally unique identifier |
Required |
Body Parameters
None.
Response Information
Resource Description
Order detail and history information
OrderDetailLookup| Name | Description | Type | Additional 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": "WRFOylVZfkWvARYOV2HjzA==",
"pluGuid": "ca4e1159-5955-457e-af01-160e5761e3cc",
"inventoryGuid": "0/3IWncvJE6iMxNIgHph0Q==",
"inventoryIdentifier": "5ac8fdd3-2f77-4e24-a233-1348807a61d1",
"averageWeeklySales": 1.0,
"promotionalAverageWeeklySales": 1.0,
"inventoryAverageWeeklySales": 1.0,
"inventoryPromotionalAverageWeeklySales": 1.0,
"onHand": 1,
"onHandPacks": 1,
"onOrder": 1,
"onOrderPacks": 1,
"accuracy": 1,
"lastOrdered": "2026-06-03T18:36:51.4747096",
"lastOrderQuantity": 1.1,
"lastReceived": "2026-06-03T18:36:51.4747096",
"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>0/3IWncvJE6iMxNIgHph0Q==</InventoryGuid> <InventoryIdentifier>5ac8fdd3-2f77-4e24-a233-1348807a61d1</InventoryIdentifier> <InventoryPromotionalAverageWeeklySales>1</InventoryPromotionalAverageWeeklySales> <LastInvoiceStatus>1</LastInvoiceStatus> <LastOrderQuantity>1.1</LastOrderQuantity> <LastOrdered>2026-06-03T18:36:51.4747096+00:00</LastOrdered> <LastReceived>2026-06-03T18:36:51.4747096+00:00</LastReceived> <LastReceivedQuantity>1.1</LastReceivedQuantity> <OnHand>1</OnHand> <OnHandPacks>1</OnHandPacks> <OnOrder>1</OnOrder> <OnOrderPacks>1</OnOrderPacks> <PLUG_UID>WRFOylVZfkWvARYOV2HjzA==</PLUG_UID> <PluGuid>ca4e1159-5955-457e-af01-160e5761e3cc</PluGuid> <PromotionalAverageWeeklySales>1</PromotionalAverageWeeklySales> </OrderDetailLookup>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK ���\�7ѷ 5 xl/workbook.xml � (� ����0��&�C����&8q���{)[�H����[J ��mgv��if�_��/�ѓ �o���Մ.A�p�L� �5�I�'�B(��o
&��(.���&H�^i������ ��V�f���x@�Y�=�!�dlu�5D~SM��Y!�4��g�a����b���U�%-8��@+Z��;{�5d��}PK ���\���� � [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
���\N�6�' ' _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="R933aceaff3db4941" /></Relationships>PK ���\S˻G� �
xl/worksheets/sheet1.xml � (� ��[s�0����ﵵ�+d�ri�&<��.�� ƌmB~~���u������JGg�˯h�|�$
������.�e�}��l�C����!N>ҵ֙c�mz���u��.|?]�u�^��[S[�Id�5y���*\�i��Gz��!�'zdfT�w�{���^�.��2_B�9���p�NF��t?��I�j�^����?���P�ڳs���8�8�<,�.�Y���ᯉ�ԫ`�����^���̘�r�"ޤ���G�\'
���C����x�N)E
���اY�)�e��z|��I��TH����Г�|%9$�DH��zZ��0H� a�*l׳BϪ��c�3�WR f��Bϫ�ȣ)L(�zQ��Y���G���,Į��^V�'%�@c���U�Wg��"��*���1�3bN
+60�у��]����(N�@t uP�Hm�Y3. (����A<����\Q.����B=�eOx�`NEf+lȇ2|��k00���bhe��?d#�)��C�X�� �8s�������Kkd�d��'�˦����<��Ugn��ܙ�4�?�ڂ���$n�n�.A��m��Mb�%X����I�w �$��l�]B5��=��L}�AZ�>� -[_z����z����=H�ٷ�e����M����U�pWԲ��i�}3�e�Ep�HnK�'�3K��R���,�GK���d�=[j/���I��1ń��Z�j��Z�^�����h�S��ڍ�6��t2��L'��w�?:�PK ���\�X� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�N��ݰa���=N�&vd�О�G�
XE�Tb�������4����ޞ���b��w
�A��\��)هG�n�;U���H�
�)�O�F��b�gt�c}�T�i���QuHK�$
K�2��2����A�ק ]�L�|8�19��aj��5�"S���v%gZ۪n���
��M-�ˈ���;_Ȭ8�\U���e��*ӫ�f�B���iY^�Y^��H#-j���U�����PK ���\Ѓc'2 E
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��PK ���\���nh ^ xl/sharedStrings.xml � (� ��_k�0ſ�ѻb��t�.�J�@����1�E�NDm)������.�t�I���HG����w�����L,��Vi�����
_���5X�=�.��{�j|��D�q��{�{@�ֺ(l�.������.N�d��
���,,��5"tSQ�p����]_W15U�����p;h5��戆��4�*����#W���7ħn�@��,���R�����1���{�9<μ� �i�w��ޯ�,r%��@�S�<�Pxv���8@h�f�/(Q���[|h�j���=a��8~�15%�(Dq�����yQ"�6\,,ʥ�L�)S�\�Je<m˒���,�"�W����P����PK- ���\�7ѷ 5 xl/workbook.xmlPK- ���\���� � [Content_Types].xmlPK-
���\N�6�' ' V _rels/.relsPK- ���\S˻G� �
� xl/worksheets/sheet1.xmlPK- ���\�X� P xl/_rels/workbook.xml.relsPK- ���\Ѓc'2 E
T xl/styles.xmlPK- ���\���nh ^ � xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
Sample:
PK ���\�)� 5 xl/workbook.xml � (� ���� ��&�����i{�ū�H!�� �>���M�yۙ��v�Ʌ�ù����:�X��kB�P`x<86���,Ó8)��މ��ȑRF�<ig��>��+� |�
�qA�-��;����]����Zw6YB�7��vQ��@�{�8FŹ-�0
��ÍV�I��|�K^��
�w�PK ���\���� � [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
���\��'' ' _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="R0411d5c30d9d4877" /></Relationships>PK ���\S˻G� �
xl/worksheets/sheet1.xml � (� ��[s�0����ﵵ�+d�ri�&<��.�� ƌmB~~���u������JGg�˯h�|�$
������.�e�}��l�C����!N>ҵ֙c�mz���u��.|?]�u�^��[S[�Id�5y���*\�i��Gz��!�'zdfT�w�{���^�.��2_B�9���p�NF��t?��I�j�^����?���P�ڳs���8�8�<,�.�Y���ᯉ�ԫ`�����^���̘�r�"ޤ���G�\'
���C����x�N)E
���اY�)�e��z|��I��TH����Г�|%9$�DH��zZ��0H� a�*l׳BϪ��c�3�WR f��Bϫ�ȣ)L(�zQ��Y���G���,Į��^V�'%�@c���U�Wg��"��*���1�3bN
+60�у��]����(N�@t uP�Hm�Y3. (����A<����\Q.����B=�eOx�`NEf+lȇ2|��k00���bhe��?d#�)��C�X�� �8s�������Kkd�d��'�˦����<��Ugn��ܙ�4�?�ڂ���$n�n�.A��m��Mb�%X����I�w �$��l�]B5��=��L}�AZ�>� -[_z����z����=H�ٷ�e����M����U�pWԲ��i�}3�e�Ep�HnK�'�3K��R���,�GK���d�=[j/���I��1ń��Z�j��Z�^�����h�S��ڍ�6��t2��L'��w�?:�PK ���\�v� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�.����ݰ���=N�&vd����G�
XEWb�������4�����9���-�A��m��)�����'�D�%��bCC���A
8�P�m��gS�{�Hu�=�c����Lr�,��3fT���iF� �W�a@�@��[�)z
�HT ;�q%��J�9z7�/�_��<��{lL)P��`}W�Az�/ѧK�Ny9S��*5�a]SVUwU�7��PK ���\Ѓc'2 E
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��PK ���\���nh ^ xl/sharedStrings.xml � (� ��_k�0ſ�ѻb��t�.�J�@����1�E�NDm)������.�t�I���HG����w�����L,��Vi�����
_���5X�=�.��{�j|��D�q��{�{@�ֺ(l�.������.N�d��
���,,��5"tSQ�p����]_W15U�����p;h5��戆��4�*����#W���7ħn�@��,���R�����1���{�9<μ� �i�w��ޯ�,r%��@�S�<�Pxv���8@h�f�/(Q���[|h�j���=a��8~�15%�(Dq�����yQ"�6\,,ʥ�L�)S�\�Je<m˒���,�"�W����P����PK- ���\�)� 5 xl/workbook.xmlPK- ���\���� � � [Content_Types].xmlPK-
���\��'' ' U _rels/.relsPK- ���\S˻G� �
� xl/worksheets/sheet1.xmlPK- ���\�v� P
xl/_rels/workbook.xml.relsPK- ���\Ѓc'2 E
R xl/styles.xmlPK- ���\���nh ^ � xl/sharedStrings.xmlPK � �