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.

InventoryAverageWeeklySales

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": "vSyXqwwl6k+EJF/079PRqA==",
  "pluGuid": "ab972cbd-250c-4fea-8424-5ff4efd3d1a8",
  "inventoryGuid": "Sl9TVgPo1UeHbOuVTKIkcQ==",
  "inventoryIdentifier": "56535f4a-e803-47d5-876c-eb954ca22471",
  "averageWeeklySales": 1.0,
  "inventoryAverageWeeklySales": 1.0,
  "onHand": 1,
  "onHandPacks": 1,
  "onOrder": 1,
  "onOrderPacks": 1,
  "accuracy": 1,
  "lastOrdered": "2025-08-02T23:17:51.6453137",
  "lastOrderQuantity": 1.1,
  "lastReceived": "2025-08-02T23:17:51.6453137",
  "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>Sl9TVgPo1UeHbOuVTKIkcQ==</InventoryGuid>
  <InventoryIdentifier>56535f4a-e803-47d5-876c-eb954ca22471</InventoryIdentifier>
  <LastInvoiceStatus>1</LastInvoiceStatus>
  <LastOrderQuantity>1.1</LastOrderQuantity>
  <LastOrdered>2025-08-02T23:17:51.6453137+00:00</LastOrdered>
  <LastReceived>2025-08-02T23:17:51.6453137+00:00</LastReceived>
  <LastReceivedQuantity>1.1</LastReceivedQuantity>
  <OnHand>1</OnHand>
  <OnHandPacks>1</OnHandPacks>
  <OnOrder>1</OnOrder>
  <OnOrderPacks>1</OnOrderPacks>
  <PLUG_UID>vSyXqwwl6k+EJF/079PRqA==</PLUG_UID>
  <PluGuid>ab972cbd-250c-4fea-8424-5ff4efd3d1a8</PluGuid>
</OrderDetailLookup>

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Sample:
PK9�[K�1<�5xl/workbook.xml �(�����0D�&�C��"�N\�z𾖭4Ж�5��B	$޼��ξ>Z�=���G����mC��-j�;��v�:
a��Ŭ�J`m�[�	�t<��aAY�[5x���a��!4�E�_P���~G��=�>��X��&aK���x�mQKZCJ�skJ�P�
5
��#f��<�L\S��7g���PK9�[����	�[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
9�[m�P�''_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="R79dda43bb9dc4b5b" /></Relationships>PK9�[z�����	xl/worksheets/sheet1.xml �(���Yo�0��
�}���JR�Mӽ��a�I��p���C �EЙ���~��\]1����ΧN���S�::^�u�O�}��!����`��4�:s,���
�lw�y�*Б��ӱ�mL��}L�=�ل+=7�}����r/�[?�[�A�Kݣ�w��]��uq�h{���0vg�uh���;��L�+t�Į��&�+ԇ�l��o�ǘ���a=ua�zxQl�L�����m���u�d�I�Ь�6-~�(�[�:��U��u��N)�
	%\g�O3�.˕�Q�K=>�	� *!�B��a=)��|%9Pp)���RO��%@�3J�T�4�g����+�(gX	��lX�K=?�Jq���Y�a�(��WQ��N�:ٸ7�	#�gX15�W�^��V����@�Q�P)q8E��mOL�)�ȝ�*t�N� �nf��5q�b��r'� �A�}6�P��=C=TgC{��sHa�9r��
�Ӈ8���`�`����(&�����$1')��?_]�eZ�;:R;�>gp�}�ڒ���I�t	�$�]�4��.A�ĢK�&q�%x����I<t	�$��jO=k5��iu��i���i���i5vكԝ�ldN��unpW�j�u���͸˼i��m��ds1P����j������y�2)�R��l�aZF��7z4Z�����l���G'c2�S��96�PK9�[��N��Pxl/_rels/workbook.xml.rels �(���An� E��f_c��Q�l��6�&x��؀���ٺ�z��Tj��n�B���f�|���ަ����5
Y����`��Q?T��n�4bL7B?����ctk΃�iYG&u���T��;T'�/��~΀[&;\��h�=Zu���?����S�"���b?Q�ף��S����J"I�JKU`�nj!^F
�^��L�֨IhQ�ڥԢ��L�����Ӧ�N�x>�EYKQ�Q.�j��_l�PK9�[Ѓ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��PK9�[Td�W�xl/sharedStrings.xml �(���QO�0������16fA�HB��c̥����ö#��[
b2&>5=�~�''�GE�PiQʄt;qP���I���F��$�����5qFi��q,*uB���\W�-�;��u�R`�Um\�W\oM�������$++i��!q*)�+�9	v�Hc�.f���jz�&��/��դ�)O��)U}ќr{�L�j��m��g�]^/!G��#����m�]]۵s��C�Vd�X���M}�|Sx�d=T`k0��#2�v�ǻ�ۚJ�pi�Tg���6Xt�k�/�M�Á�֜���h�!�(�fY���.DM&쇽0�b��h0�!�}Fq=����ko�	PK-9�[K�1<�5xl/workbook.xmlPK-9�[����	��[Content_Types].xmlPK-
9�[m�P�''U_rels/.relsPK-9�[z�����	�xl/worksheets/sheet1.xmlPK-9�[��N��P�xl/_rels/workbook.xml.relsPK-9�[Ѓc'2E
xl/styles.xmlPK-9�[Td�W��	xl/sharedStrings.xmlPK�6

application/vnd.ms-excel

Sample:
PK9�[�E��5xl/workbook.xml �(�����0��&�C��@Q��x��}��4П�5��$޼���~;�d��3���/\E�l��=*�'cQ�]g���{1�uR`c�[�,K�s8B�F�^ZOW�?,o����A�+J�Դ>)�f��_d4���I�b��r���"V���,��YєW�8ܯ۔�9$"�;�ѝ��J����PK9�[����	�[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
9�[>+�''_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="Re4b4bd57c5394019" /></Relationships>PK9�[z�����	xl/worksheets/sheet1.xml �(���Yo�0��
�}���JR�Mӽ��a�I��p���C �EЙ���~��\]1����ΧN���S�::^�u�O�}��!����`��4�:s,���
�lw�y�*Б��ӱ�mL��}L�=�ل+=7�}����r/�[?�[�A�Kݣ�w��]��uq�h{���0vg�uh���;��L�+t�Į��&�+ԇ�l��o�ǘ���a=ua�zxQl�L�����m���u�d�I�Ь�6-~�(�[�:��U��u��N)�
	%\g�O3�.˕�Q�K=>�	� *!�B��a=)��|%9Pp)���RO��%@�3J�T�4�g����+�(gX	��lX�K=?�Jq���Y�a�(��WQ��N�:ٸ7�	#�gX15�W�^��V����@�Q�P)q8E��mOL�)�ȝ�*t�N� �nf��5q�b��r'� �A�}6�P��=C=TgC{��sHa�9r��
�Ӈ8���`�`����(&�����$1')��?_]�eZ�;:R;�>gp�}�ڒ���I�t	�$�]�4��.A�ĢK�&q�%x����I<t	�$��jO=k5��iu��i���i���i5vكԝ�ldN��unpW�j�u���͸˼i��m��ds1P����j������y�2)�R��l�aZF��7z4Z�����l���G'c2�S��96�PK9�[%�b�Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞8q�&EM�a�m��=��&vd����G�
XEWb�������4����޾M#9���TE	�tj�}��Z�n�{EL�s iņL��#�A�D(܌6u��)�=��<�)+�%�9n��p��?D�� ���ӄ6�����A�@��;�)z
U��@v��}S�KU/jQJ�ùл��x1�z}癌f�]r�b��8
qW#<���ӥs������E#�U�5�W5z��/PK9�[Ѓ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��PK9�[Td�W�xl/sharedStrings.xml �(���QO�0������16fA�HB��c̥����ö#��[
b2&>5=�~�''�GE�PiQʄt;qP���I���F��$�����5qFi��q,*uB���\W�-�;��u�R`�Um\�W\oM�������$++i��!q*)�+�9	v�Hc�.f���jz�&��/��դ�)O��)U}ќr{�L�j��m��g�]^/!G��#����m�]]۵s��C�Vd�X���M}�|Sx�d=T`k0��#2�v�ǻ�ۚJ�pi�Tg���6Xt�k�/�M�Á�֜���h�!�(�fY���.DM&쇽0�b��h0�!�}Fq=����ko�	PK-9�[�E��5xl/workbook.xmlPK-9�[����	��[Content_Types].xmlPK-
9�[>+�''U_rels/.relsPK-9�[z�����	�xl/worksheets/sheet1.xmlPK-9�[%�b�P�xl/_rels/workbook.xml.relsPK-9�[Ѓc'2E
xl/styles.xmlPK-9�[Td�W��	xl/sharedStrings.xmlPK�5