GET api/product/{id}/history/sales/total?storeID={storeID}
Get sales history total for a product
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Product identifier |
globally unique identifier |
Required |
| storeID |
Store to restrict sales information to |
integer |
Default value is 0 |
| PLUG_UID | Collection of byte |
None. |
|
| PluGuid |
Product to get sales history of |
globally unique identifier |
None. |
| SummaryPeriod |
Period to summarise |
SalesHistorySummaryPeriod |
None. |
| StartDate |
Start of period to get history for |
date |
Required |
| EndDate |
End of period to get history for |
date |
Required |
| IncludeExternalSales |
Whether external sales should be included |
boolean |
None. |
| Stores |
List of stores to restrict sales records to |
Collection of integer |
None. |
| Skip |
Number of records to skip over |
integer |
None. |
| Take |
Number of records to take |
integer |
None. |
| TotalCount | integer |
Relation. This field may not always be loaded or used for updates. |
Body Parameters
None.
Response Information
Resource Description
Total sales history record
SalesHistory| Name | Description | Type | Additional information |
|---|---|---|---|
| StoreID | integer |
Relation. This field may not always be loaded or used for updates. |
|
| StoreName |
Store name |
string |
Relation. This field may not always be loaded or used for updates. |
| PeriodBeginning |
First day of summary period |
date |
Relation. This field may not always be loaded or used for updates. |
| Period |
First day of summary period |
SalesHistorySummaryPeriod |
Relation. This field may not always be loaded or used for updates. |
| Hour |
Hour of the summary if by hour |
integer |
Relation. This field may not always be loaded or used for updates. |
| PLUG_UID | Collection of byte |
Relation. This field may not always be loaded or used for updates. |
|
| PluGuid |
Product guid |
globally unique identifier |
Relation. This field may not always be loaded or used for updates. |
| Quantity |
Quantity of items sold |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| Dumped |
Quantity of items dumped |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| AvgUnitSellInc |
Average SellPrice for the period |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| AvgUnitSellEx |
Average SellPrice for the period |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| AvgUnitCostInc |
Average Cost for the period |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| AvgUnitCostEx |
Average Cost for the period |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| SalesInc |
Value of the Sale Price including tax of sales |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| SalesEx |
Value of the Sale Price excluding tax of sales |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| CostInc |
Value of the Cost including tax of sales |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| CostEx |
Value of the Cost excluding tax of sales |
decimal number |
Relation. This field may not always be loaded or used for updates. |
| GrossProfit |
Gross Profit dollar value |
decimal number |
Relation. This field may not always be loaded or used for updates. |
Response Formats
application/json, text/json
{
"storeID": 1,
"storeName": "sample string 1",
"periodBeginning": "2026-06-03T15:52:36.5919016",
"period": 0,
"hour": 1,
"quantity": 3.1,
"dumped": 4.1,
"avgUnitSellInc": 5.1,
"avgUnitSellEx": 6.1,
"avgUnitCostInc": 7.1,
"avgUnitCostEx": 8.1,
"salesInc": 9.1,
"salesEx": 10.1,
"costInc": 11.1,
"costEx": 12.1,
"grossProfit": 13.1
}
application/xml, text/xml
<SalesHistory xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.Sales"> <AvgUnitCostEx>8.1</AvgUnitCostEx> <AvgUnitCostInc>7.1</AvgUnitCostInc> <AvgUnitSellEx>6.1</AvgUnitSellEx> <AvgUnitSellInc>5.1</AvgUnitSellInc> <CostEx>12.1</CostEx> <CostInc>11.1</CostInc> <Dumped>4.1</Dumped> <GrossProfit>13.1</GrossProfit> <Hour>1</Hour> <PLUG_UID i:nil="true" /> <Period>Hourly</Period> <PeriodBeginning>2026-06-03T15:52:36.5919016+00:00</PeriodBeginning> <PluGuid i:nil="true" /> <Quantity>3.1</Quantity> <SalesEx>10.1</SalesEx> <SalesInc>9.1</SalesInc> <StoreID>1</StoreID> <StoreName>sample string 1</StoreName> </SalesHistory>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
PK �~�\�
� 5 xl/workbook.xml � (� ����0D�J��(� ��@��ҵCwCLA�����R�n������ر3f$5iWښ
��1�T�.fFv��
|����0�[ӿjϲ$�1�xi�rvt���r�E�N z5m(R��|"�Z�=%..�`�uW��-�~SU�Q
kڂJ�s�5M)���#�]q��4�y��`����/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
�~�\���R' ' _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="Rae086cc3d5bb4812" /></Relationships>PK �~�\0��� �
xl/worksheets/sheet1.xml � (� ��[s�0��
����\t�N[k���癣Q�
q k��JSˋ��[;qeM���w���D��2�� ��\.�t5����o_�;�}����4�ȆvT����H�ܑ�*m)�$,��l���2����o�.F�s3��Tś�>L�ͬ|��pQn!YF%a�ڣ�"V����2��Wp1ö�%��]�x���䟔������J�m��r��Z�e�]3���x*$Vz�r���V�$�.�wv� EV�|�2�{�j���+>��:�!����s���T~r�3��g� C9�>����Y�c=}^��N�E�)�1"p��+?_������=}��B���"B1cs��̀c�N��PB8�_Eu�@+��� e>� 83�n�����0V��@�L��}uàoŠ�x}�u��o����
���ꘀp�"������E8drge����c^^U���՝�5B�kרּ�6:q�&�N��щ�6Aub�&�Nܵ O'�m���}��u�M:�ؑ��Sb��܁��t F����[b$�ށ��:�S��*ޱ}��>\�:Zu�����iک�s<Q��1m�1�8��63i۱q�w�is�k�k��T�*3�Ǧ��SS���T}S}i����j�!S~�d0�wMƦ<��f^�:���-R�D6��Yy��V��PK �~�\�o�� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;q9*6�R.��8�H��6m9[=R�P�J�.�a5��ӓf�?��ۏi$o���lE�A+�l��)����G�D0�HZ����Li�'27�M���cJ}Og.��GZ�yM���Lr8����z��s�4������`#��=���@/��ȋ�`ϔXU�V���r�>L-������/d�J!
)�V+&0����k���K�ey�V�Vɺ�A��l.j��/6?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 �~�\;
� � xl/sharedStrings.xml � (� }�AO�0��J�;˶B�-�
�$��F�(j�.R�ؙ�O�P�q������Yq�@�c)g����o
v��ߟ�n� ��j�Jy��*�X�(R)����R���i��0��Ns*C���[���j>�^+�
J���\��L���3��GH#LUp�e`�,W�:K�W�`6�o�3���x�>�2�K�����W�d-ޢF6|���z�����F�[�v��?��x.<����ѭ�@#�o=�_1�{<�&���!"�z�B�1[����[�tk�PK- �~�\�
� 5 xl/workbook.xmlPK- �~�\���� � � [Content_Types].xmlPK-
�~�\���R' ' U _rels/.relsPK- �~�\0��� �
� xl/worksheets/sheet1.xmlPK- �~�\�o�� P � xl/_rels/workbook.xml.relsPK- �~�\Ѓc'2 E
xl/styles.xmlPK- �~�\;
� � � xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
PK �~�\�9u � 5 xl/workbook.xml � (� ����0��&�C���()��x�བ�m�-�����O ��mgv�������|l��1%c(5X�'?��v�+�$Ëy����˷Y�$Ћh�Cm�+�D� �~EYa��B���a`�EN�Vw6 [C�7��~�(℅�6"
J��V�LI(�4�e�^�<Mu�rP��wg���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
�~�\��G' ' _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="R67d17de90d414de5" /></Relationships>PK �~�\0��� �
xl/worksheets/sheet1.xml � (� ��[s�0��
����\t�N[k���癣Q�
q k��JSˋ��[;qeM���w���D��2�� ��\.�t5����o_�;�}����4�ȆvT����H�ܑ�*m)�$,��l���2����o�.F�s3��Tś�>L�ͬ|��pQn!YF%a�ڣ�"V����2��Wp1ö�%��]�x���䟔������J�m��r��Z�e�]3���x*$Vz�r���V�$�.�wv� EV�|�2�{�j���+>��:�!����s���T~r�3��g� C9�>����Y�c=}^��N�E�)�1"p��+?_������=}��B���"B1cs��̀c�N��PB8�_Eu�@+��� e>� 83�n�����0V��@�L��}uàoŠ�x}�u��o����
���ꘀp�"������E8drge����c^^U���՝�5B�kרּ�6:q�&�N��щ�6Aub�&�Nܵ O'�m���}��u�M:�ؑ��Sb��܁��t F����[b$�ށ��:�S��*ޱ}��>\�:Zu�����iک�s<Q��1m�1�8��63i۱q�w�is�k�k��T�*3�Ǧ��SS���T}S}i����j�!S~�d0�wMƦ<��f^�:���-R�D6��Yy��V��PK �~�\�U�� P xl/_rels/workbook.xml.rels � (� ��Kn� @��f����(N6�t��ۊ
Hۜ���W(J��H]t��h~OO��|����扼`�����V9=ھ�s2�v��'��DFI^���!%��4�g+���qa�)���^���r�
%n��x���3fT�w�<�M���8 & GzL��"����T ����b|�l8�]6hZ �nj1]&��^�y!cPac��5B�Wf��S
�ҥSY.�V\�g����d���Fo�b�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 �~�\;
� � xl/sharedStrings.xml � (� }�AO�0��J�;˶B�-�
�$��F�(j�.R�ؙ�O�P�q������Yq�@�c)g����o
v��ߟ�n� ��j�Jy��*�X�(R)����R���i��0��Ns*C���[���j>�^+�
J���\��L���3��GH#LUp�e`�,W�:K�W�`6�o�3���x�>�2�K�����W�d-ޢF6|���z�����F�[�v��?��x.<����ѭ�@#�o=�_1�{<�&���!"�z�B�1[����[�tk�PK- �~�\�9u � 5 xl/workbook.xmlPK- �~�\���� � [Content_Types].xmlPK-
�~�\��G' ' V _rels/.relsPK- �~�\0��� �
� xl/worksheets/sheet1.xmlPK- �~�\�U�� P � xl/_rels/workbook.xml.relsPK- �~�\Ѓc'2 E
xl/styles.xmlPK- �~�\;
� � � xl/sharedStrings.xmlPK � �