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": "jsLnby8GP0mi4+aE5FoviA==",
"pluGuid": "6fe7c28e-062f-493f-a2e3-e684e45a2f88",
"inventoryGuid": "FJzEWfvzt0iWmpDWYm4Lvg==",
"inventoryIdentifier": "59c49c14-f3fb-48b7-969a-90d6626e0bbe",
"averageWeeklySales": 1.0,
"promotionalAverageWeeklySales": 1.0,
"inventoryAverageWeeklySales": 1.0,
"inventoryPromotionalAverageWeeklySales": 1.0,
"onHand": 1,
"onHandPacks": 1,
"onOrder": 1,
"onOrderPacks": 1,
"accuracy": 1,
"lastOrdered": "2026-04-03T06:18:49.4140666",
"lastOrderQuantity": 1.1,
"lastReceived": "2026-04-03T06:18:49.4140666",
"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>FJzEWfvzt0iWmpDWYm4Lvg==</InventoryGuid> <InventoryIdentifier>59c49c14-f3fb-48b7-969a-90d6626e0bbe</InventoryIdentifier> <InventoryPromotionalAverageWeeklySales>1</InventoryPromotionalAverageWeeklySales> <LastInvoiceStatus>1</LastInvoiceStatus> <LastOrderQuantity>1.1</LastOrderQuantity> <LastOrdered>2026-04-03T06:18:49.4140666+00:00</LastOrdered> <LastReceived>2026-04-03T06:18:49.4140666+00:00</LastReceived> <LastReceivedQuantity>1.1</LastReceivedQuantity> <OnHand>1</OnHand> <OnHandPacks>1</OnHandPacks> <OnOrder>1</OnOrder> <OnOrderPacks>1</OnOrderPacks> <PLUG_UID>jsLnby8GP0mi4+aE5FoviA==</PLUG_UID> <PluGuid>6fe7c28e-062f-493f-a2e3-e684e45a2f88</PluGuid> <PromotionalAverageWeeklySales>1</PromotionalAverageWeeklySales> </OrderDetailLookup>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK X2�\I_#�� 5 xl/workbook.xml � (� ����0D�&�C���P")��x��}�EhK��|o�vfgߎ���+cz�Q�v��i���1����Q�]k��}1Ӷ����o�ڳKqfq /�v�]i���h�!z5�(R��x D�͞'��`lug��5�~Sb���"��,ν����0<R�r��$��$��Fw�l�]|PK X2�\���� � [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
X2�\���<' ' _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="R5461b96538b248b8" /></Relationships>PK X2�\_�� �
xl/worksheets/sheet1.xml � (� ���r�@�_��~az�c��$Ɯ���������;"�j��B��w7=5/����4�7#<�:z3���}����^���8�HWZg��7� ��,�|?��t�^��[�Id�6y���2��I<�Ez��!�'zd�T�
��{���\�6��"o!ZSEA�q��Eh��w���0�a������}zv���On�#�߂�y���Y�e�[g�x���Uf��r�<^�����ѹN|���p����'�R�%\g�K�8�]��,G=.���'�S� �bH���Г��JrHp)����BO���S$�0J��Y�gU}�1�V�+���y��U}�Q�&��
v�(��Ǧ��
!0�����˪��Db��Rv�*��WP�qO]@�qP�9f쌘SÊ�T����_k����u@=�0#�*�=J�9�mz��%%�97(��� {RQƌ}6�z2�փ3� Ỏ��<
��P����P�����)bd���L��KB�@��`N�Q�wg��(�Z� ��$�;I6�W��2�w�Y_�Y��c4�?ڂ�jP'����6A��M��ub�&X��m�Nܵ Q'�ۄ�mBՉǎ�5��ԁ4��܁4��ҁ4���i��iL��i�vցT����N�Õ�p[��UҘ�u�I��#�)��O-�[K�����,�GK��{��^�c�
�3 0o���ji�F���'z�&�uw{���V��O'�8�t�����/PK X2�\9�px� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�i�VM�a�m��3��&�e����G�
XE�Tb�������4����M#y�g[(�r�`�NI?<�v���(S��f��[0)��Q�d,�G�;څI����z���G�`L�0g�-�.�CtZ
��:Mh�`zv�
br�����O)�k(�L��Z�7�B�45G�B��e������dIJlj�U�}8�]e��=��/=w��gj�V�n�R!�\/�U�����PK X2�\Ѓ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 X2�\���of ^ xl/sharedStrings.xml � (� ��mK�0��J���]Wk+m�ԁ��~���v��Ln���F����)��p���7��Ac�V9����j����O�g T �V��-��Z��l�VD�#߷b�
ؑ^�rN�M�f�۵A(�
���� ���yB��r���*����Np�Ȩ���_�̧�OE�j[�n/[Y��ڠ"m�_�i�VYI4���,���fP��6�������]�?F�p������ ^�S��{+"'B�D�ׯ���{�Yw-��i��G�r3{��1-���;�����#|z�q��"L�qX�(�TB�p����$�3��R1�x5�<J�<�S�iP�qc�X��R| PK- X2�\I_#�� 5 xl/workbook.xmlPK- X2�\���� � [Content_Types].xmlPK-
X2�\���<' ' V _rels/.relsPK- X2�\_�� �
� xl/worksheets/sheet1.xmlPK- X2�\9�px� P xl/_rels/workbook.xml.relsPK- X2�\Ѓc'2 E
J xl/styles.xmlPK- X2�\���of ^ � xl/sharedStrings.xmlPK � w
application/vnd.ms-excel
Sample:
PK X2�\k�
� 5 xl/workbook.xml � (� ����0��&�C���&�p��Ճ�
[i�?ik��-%�x�3;������a��z2��5bt!�@�p�L�I뵈I�'�R�Z۽4�H
J���$��&����a�A�a �zZQZ(���!�4�+�C����]LD��M��.�BFh�q+��(;�G�|��p+/ЗLR&81F���`�|7PK X2�\���� � [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
X2�\7�ΐ' ' _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="Rca7d70e584134a7a" /></Relationships>PK X2�\_�� �
xl/worksheets/sheet1.xml � (� ���r�@�_��~az�c��$Ɯ���������;"�j��B��w7=5/����4�7#<�:z3���}����^���8�HWZg��7� ��,�|?��t�^��[�Id�6y���2��I<�Ez��!�'zd�T�
��{���\�6��"o!ZSEA�q��Eh��w���0�a������}zv���On�#�߂�y���Y�e�[g�x���Uf��r�<^�����ѹN|���p����'�R�%\g�K�8�]��,G=.���'�S� �bH���Г��JrHp)����BO���S$�0J��Y�gU}�1�V�+���y��U}�Q�&��
v�(��Ǧ��
!0�����˪��Db��Rv�*��WP�qO]@�qP�9f쌘SÊ�T����_k����u@=�0#�*�=J�9�mz��%%�97(��� {RQƌ}6�z2�փ3� Ỏ��<
��P����P�����)bd���L��KB�@��`N�Q�wg��(�Z� ��$�;I6�W��2�w�Y_�Y��c4�?ڂ�jP'����6A��M��ub�&X��m�Nܵ Q'�ۄ�mBՉǎ�5��ԁ4��܁4��ҁ4���i��iL��i�vցT����N�Õ�p[��UҘ�u�I��#�)��O-�[K�����,�GK��{��^�c�
�3 0o���ji�F���'z�&�uw{���V��O'�8�t�����/PK X2�\��S�� P xl/_rels/workbook.xml.rels � (� ��Kn� �����<�h�ɦ�n�\���m�Hۜ���W(J��H]t����7>�?6��i$/���lKE�)��l��s�Œ=�*���@�Z��8���I���`S��TL��ج�Iu�$�
�9��2��2��q����y� �W�O����� ��'
�z�"Q)y2-ݗ`�y���N㳻��x!�z}י�Q\�R��㲩LY�U�W�s�iӹSgj��\���ī���/PK X2�\Ѓ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 X2�\���of ^ xl/sharedStrings.xml � (� ��mK�0��J���]Wk+m�ԁ��~���v��Ln���F����)��p���7��Ac�V9����j����O�g T �V��-��Z��l�VD�#߷b�
ؑ^�rN�M�f�۵A(�
���� ���yB��r���*����Np�Ȩ���_�̧�OE�j[�n/[Y��ڠ"m�_�i�VYI4���,���fP��6�������]�?F�p������ ^�S��{+"'B�D�ׯ���{�Yw-��i��G�r3{��1-���;�����#|z�q��"L�qX�(�TB�p����$�3��R1�x5�<J�<�S�iP�qc�X��R| PK- X2�\k�
� 5 xl/workbook.xmlPK- X2�\���� � � [Content_Types].xmlPK-
X2�\7�ΐ' ' U _rels/.relsPK- X2�\_�� �
� xl/worksheets/sheet1.xmlPK- X2�\��S�� P xl/_rels/workbook.xml.relsPK- X2�\Ѓc'2 E
J xl/styles.xmlPK- X2�\���of ^ � xl/sharedStrings.xmlPK � w