# Отчёты по товарам

##### АВС по товарам

##### Роль: продуктовый аналитик, маркетолог  
Цель: исследование потребительских предпочтений

##### Отчет показывает подробную информацию о товарах

##### Фильтры отчета:

- Тип магазина
- Город
- Торговая точка
- Категория товаров
- Группа товаров
- Период

##### **Пример отчета:**

##### [![image-1735224707362.png](https://rzn-wb-02.1c-hosting.com/uploads/images/gallery/2024-12/scaled-1680-/image-1735224707362.png)](https://rzn-wb-02.1c-hosting.com/uploads/images/gallery/2024-12/image-1735224707362.png)

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%A2%D0%BE%D0%B2%D0%B0%D1%80-%D0%9A%D0%B0%D1%82%D0%B5%D0%B3%D0%BE%D1%80%D0%B8%D1%8F-%D0%9A%D0%BE%D0%BB%D0%B8" style="width: 683px;"><colgroup><col width="138"></col><col width="127"></col><col width="143"></col><col width="141"></col><col width="134"></col></colgroup><tbody><tr><td style="width: 138px;">Товар</td><td style="width: 127px;">Категория</td><td style="width: 143px;">Количество покупателей</td><td style="width: 141px;">Количество купленных позиций</td><td style="width: 134px;">Цена</td></tr><tr><td style="width: 138px;">Товар 1</td><td style="width: 127px;">Хоз. товары</td><td style="width: 143px;">75</td><td style="width: 141px;">145</td><td style="width: 134px;">560</td></tr></tbody></table>

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%A2%D0%9E-%D0%A2%D0%9E-%D1%81-%D1%83%D1%87%D1%91%D1%82%D0%BE%D0%BC-%D1%81%D0%BA%D0%B8%D0%B4%D0%BA"><colgroup><col width="116"></col><col width="89"></col><col width="108"></col><col width="136"></col><col width="89"></col><col width="89"></col><col width="89"></col></colgroup><tbody><tr><td>ТО</td><td>ТО с учётом скидки</td><td>Начислено</td><td>Доля в общем ТО</td><td>Группа</td><td>Фактическая скидка</td><td>Наценка</td></tr><tr><td>81200</td><td>80 000</td><td>4 000</td><td>5%</td><td>А</td><td>1 200</td><td>97%</td></tr></tbody></table>

##### Сортировка -  
Группировка -

##### **Расшифровка данных отчета:**

<table cellpadding="0" cellspacing="0" class="xslData;XLSY;v2;5264;BgaAAgAAB6ACAAABPgkAAAImEAAAA+MDAAAECwQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEbAAAA+gMAAAAADAANAA4ADwD7AAcAAAD6EgAAAAD7Aj4BAAD6AA8AAAAeBEIERwQ1BEIEPQQ+BEEEQgRMBC4AeABsAHMAeAABFAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAF8ATQBBAE4AUwBLAFYAMQACKgAAABwEMAQ9BEEEOgQ4BDkEIAASBDAEOwQ1BEAEOAQ5BCAAKABNAEEATgBTAEsAVgApACAAKABtAGEAbgBzAGsAdgBAAHIAYQByAHUAcwAuAHIAdQApAAMCAAAAMgA5AAUUAAAAMgAwADIANAAtADEAMgAtADIANgBUADEANAA6ADUAMgA6ADMANgBaAPsAWAAAAPoGDAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAAcIAAAAMgA2ADYAMQA3ADcANAA0AAkJAAAAOAAxADQANQAzADUAMQA0ADMACwQAAAAxADAANAA5APskAAAAAAAAAAABCwAAAAIGAAAAAAQAAAAAAwAAAAAPAAAAABsAAAAALwUAAAAqBQAAAUUAAAAABh4AAAAQBD0EMAQ7BDgENwQgAD4EQgRHBDUEQgQ+BDIEIAABBAEAAAACAQIDBhIAAABBADIAMwA1ADoAQwAyADQANgACtAAAAAMiAAAAAAEBAgQBAAAAAwQBAAAABAQBAAAABQUAAAAAgLZRQAYBAQMfAAAAAgQCAAAAAwQCAAAABAQCAAAABQUAAAAAAJAcQAYBAQMfAAAAAgQDAAAAAwQDAAAABAQDAAAABQUAAAAAAGljQAYBAQMfAAAAAgQEAAAAAwQEAAAABAQBAAAABQUAAAAAgARmQAYBAQMcAAAAAgQAQAAAAwQFAAAABAQBAAAABQUAAAAAAEgiQBY3AAAAFzIAAAAULQAAAAAIAAAAQQAyADMANQABBAAAAAAAAAACEgAAAEEAMgAzADUAOgBDADIANAA2AAsKAAAAAQUAAAAAAIAsQA48AAAAAAXNzMzMzMwxQAEFmpmZmZkZM0ACBc3MzMzMzDFAAwWamZmZmRkzQAQFexSuR+F6HkAFBXsUrkfheh5ADz8AAAABAQkCAQADAQAEBAEAAAAFAQAGAQAIBAEAAAAJBAEAAAAKBFgCAAAAAQELAQAPBGQAAAAQAQARAQESBFgCAAAQBgAAAAABAAEBAAkzAwAAIy4DAAAABgAAkQEAABHqAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAQAAAAAAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAIAAAAAAAAR6wAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAAAwAAAAAABw4BAAAAAgAAAAQAAAAAAAcOAgAAAAMAAAAFAAAAAAAAEewAAAAAAAAAWQEAAAAAAAAABw4AAAAABAAAAAYAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAABwAAAAAAABHtAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAQAAAAIAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAkAAAAAAAAR7gAAAAAAAABZAQAAAAAAAAAHDgAAAAAEAAAACgAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAALAAAAAAAAEe8AAAAAAAAAWQEAAAAAAAAABw4AAAAABAAAAAwAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAADQAAAAAAABHwAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAYAAAAOAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAA8AAAAAAAAR8QAAAAAAAABZAQAAAAAAAAAHDgAAAAAGAAAAEAAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAARAAAAAAAAEfIAAAAAAAAAWQEAAAAAAAAABw4AAAAABwAAABIAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAEwAAAAAAABHzAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAgAAAAUAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAABUAAAAAAAAR9AAAAAAAAABZAQAAAAAAAAAHDgAAAAAHAAAAFgAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAXAAAAAAAAEfUAAAAAAAAAWQEAAAAAAAAABw4AAAAABwAAABgAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAGQAAAAAAkgEABQAAAAAHAAAAAAwAAAAAGwAAAADkBgAAAA8AAAADCgAAACIEPgQyBDAEQAQABwAAAAMCAAAAKwAARwAAAANCAAAAHQQwBDcEMgQwBD0EOAQ1BCAAQgQ+BDIEMARABDAEIAAyBCAAOgQwBEAEQgQ+BEcEOgQ1BCAAQgQ+BDIEMARABDAEABcAAAADEgAAABoEMARCBDUEMwQ+BEAEOARPBAAHAAAAAwIAAAAtAAAtAQAAAygBAAAaBCAAOgQwBDoEPgQ5BCAAOgQwBEIENQQzBD4EQAQ4BDgEIABCBD4EMgQwBEAEPgQ+BDEEPgRABD4EQgQwBCAAPgRCBD0EPgRBBDgEQgRBBE8EIABCBD4EMgQwBEAEIAAoAEEAQgBDACAAQQQ1BDMEPAQ1BD0EQgQwBEYEOARPBCkAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgAAAxAAAAAywAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAPwQ+BDoEQwQ/BDAEQgQ1BDsENQQ5BABfAAAAA1oAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAOgQ7BDgENQQ9BEIEPgQyBCwAIAA6BEMEPwQ4BDIESAQ4BEUEIAAyBEsEMQRABDAEPQQ9BEsEOQQgAEIEPgQyBDAEQAQAPQAAAAM4AAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgADoEQwQ/BDsENQQ9BD0ESwRFBCAAPwQ+BDcEOARGBDgEOQQAYQAAAANcAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgAD8EQAQ+BDQEMAQ9BD0ESwRFBCAAPwQ+BDcEOARGBDgEOQQgADIESwQxBEAEMAQ9BD0EPgQzBD4EIABCBD4EMgQwBEAEMAQADQAAAAMIAAAAJgQ1BD0EMAQAaQAAAANkAAAAJgQ1BD0EMAQgAEIEPgQyBDAEQAQwBC4AIAAjBDoEMAQ3BDAEPQQwBCAAMgQgADoEMARABEIEPgRHBDoENQQgAEIEPgQyBDAEQAQwBCAAOAQ7BDgEIAA/BEAEPgQ0BDAENgQ4BAAJAAAAAwQAAAAiBB4EAFkAAAADVAAAABoEPgQ7BDgERwQ1BEEEQgQyBD4EIAA/BEAEPgQ0BDAEPQQ9BEsERQQgAEIEPgQyBDAEQAQ+BDIEIAAqACAARgQ1BD0EQwQgAEIEPgQyBDAEQAQwBAApAAAAAyQAAAAiBB4EIABBBCAAQwRHBFEEQgQ+BDwEIABBBDoEOAQ0BDoEOAQAUQAAAANMAAAAIAAiBB4EIABCBD4EMgQwBEAEMAQgAC0AIABBBDoEOAQ0BDoEOAQgAD0EMAQgADIESwQxBEAEMAQ9BD0ESwQ5BCAAQgQ+BDIEMARABAAXAAAAAxIAAAAdBDAERwQ4BEEEOwQ1BD0EPgQAaQAAAANkAAAAIQRDBDwEPAQwBCAAPQQwBEcEOARBBDsENQQ9BD0ESwRFBCAAMQQwBDsEOwQ+BDIEIAA/BEAEOAQgAD8EQAQ+BDQEMAQ2BDAERQQgAE0EQgQ+BDMEPgQgAEIEPgQyBDAEQAQwBAAjAAAAAx4AAAAUBD4EOwRPBCAAMgQgAD4EMQRJBDUEPAQgACIEHgQAOwAAAAM2AAAAIgQeBCAAQgQ+BDIEMARABDAEIAAvACAAPgQxBEkEOAQ5BCAAIgQeBCAAKgAgADEAMAAwACUAABEAAAADDAAAABMEQARDBD8EPwQwBAB9AAAAA3gAAAAaBCAAOgQwBDoEPgQ5BCAAOgQwBEIENQQzBD4EQAQ4BDgEIAA+BEIEPQQ+BEEEOARCBEEETwQgAEIEPgQyBDAEQAQsACAAQwQ6BDAENwQwBD0EPgQgADIEIAA0BDAEPQQ9BEsERQQgAD4EIABCBD4EMgQwBEAENQQAKQAAAAMkAAAAJAQwBDoEQgQ4BEcENQRBBDoEMARPBCAAQQQ6BDgENAQ6BDAEADMAAAADLgAAACIEHgQgAC0AIAAiBB4EIABBBCAAQwRHBDUEQgQ+BDwEIABBBDoEOAQ0BDoEOAQAEwAAAAMOAAAAHQQwBEYENQQ9BDoEMAQAXwAAAANaAAAAKAAgBD4ENwQ9BDgERwQ9BDAETwQgAEYENQQ9BDAEIAAvACAANwQwBDoEQwQ/BD4ERwQ9BDAETwQgAEYENQQ9BDAEIAAgAC0AIAAxACkAIAAqADEAMAAwACUAZgQAAAAtAAAAASgAAAAAAwAAAAEBCgEDAAAAAQEKAgMAAAABAQoEAwAAAAEBCgUDAAAAAQEKBFQAAAAFCwAAAAAGAAAAAgEAAAARBQsAAAAABgAAAAIBAAAACAUvAAAAACoAAAACAQAAABIDDQAAAAIBAAMFAAAAAAAAAAAEDQAAAAIBAAMFAAAAAAAAAAAG7wAAAAcqAAAAAQYDAAAAAgEBBAYOAAAAQwBhAGwAaQBiAHIAaQAJAQEGBQAAAAAAACZABzcAAAABBgMAAAACAQEEBh4AAABUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAGBQAAAAAAACxABz0AAAAAAQEBBgYAAAAABFCwAAAEBh4AAABUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAGBQAAAAAAACxABz0AAAAAAQEBBgYAAAAABAAA/wAEBh4AAABUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAGBQAAAAAAACxADikAAAADJAAAAAEBAQYEAAAAAAIBAQcEAAAAAAMBAQgEAAAAAAQBAQkEAAAAAAK/AQAAAx4AAAAGBAAAAAAHBAAAAAAIBAAAAAAJBAAAAAAMBAAAAAADIQAAAAYEAAAAAAcEAAAAAAMBAQgEAQAAAAkEAAAAAAwEAAAAAAMtAAAABgQAAAAABwQAAAAAAwEBCAQBAAAACQQAAAAAAAEBDQYDAAAAAAEADAQAAAAAAy0AAAAGBAAAAAAHBAAAAAADAQEIBAEAAAAJBAAAAAAAAQENBgMAAAAAAQUMBAAAAAADLQAAAAYEAAAAAAcEAAAAAAMBAQgEAgAAAAkEAAAAAAABAQ0GAwAAAAABAAwEAAAAAAMwAAAABgQAAAAAAgEBBwQCAAAAAwEBCAQDAAAACQQAAAAAAAEBDQYDAAAAAAEADAQAAAAAAzMAAAAGBAAAAAAHBAAAAAADAQEIBAIAAAAJBAAAAAAAAQENBgkAAAAAAQAHAQQIAQEMBAAAAAADMwAAAAYEAAAAAAcEAAAAAAMBAQgEAgAAAAkEAAAAAAABAQ0GCQAAAAABAAcBAQgBAQwEAAAAAAM2AAAABgQAAAAAAgEBBwQCAAAAAwEBCAQCAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAADygAAAAQIwAAAAAEAAAAAAAAAAQMAAAATgBvAHIAbQBhAGwABQQAAAAAAAAADE4AAAAAIgAAAFQAYQBiAGwAZQBTAHQAeQBsAGUATQBlAGQAaQB1AG0AMgABIgAAAFAAaQB2AG8AdABTAHQAeQBsAGUATABpAGcAaAB0ADEANgARNwAAAAAyAAAA+gARAAAAUwBsAGkAYwBlAHIAUwB0AHkAbABlAEwAaQBnAGgAdAAxAPsABAAAAAAAAAAIAAAAABMvAAAAACoAAABUAGkAbQBlAFMAbABpAGMAZQByAFMAdAB5AGwAZQBMAGkAZwBoAHQAMQA=" id="bkmrk-%D0%A2%D0%BE%D0%B2%D0%B0%D1%80-%D0%9D%D0%B0%D0%B7%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5-%D1%82%D0%BE%D0%B2%D0%B0%D1%80" style="width: 693px;"><tbody><tr><td style="width: 224px;">Товар</td><td style="width: 469px;">Название товара в карточке товара</td></tr><tr><td style="width: 224px;">Категория</td><td style="width: 469px;">К какой категории товарооборота относится товар (ABC сегментация)</td></tr><tr><td style="width: 224px;">Количество покупателей</td><td style="width: 469px;">Количество клиентов, купивших выбранный товар</td></tr><tr><td style="width: 224px;">Количество купленных позиций</td><td style="width: 469px;">Количество проданных позиций выбранного товара</td></tr><tr><td style="width: 224px;">Цена</td><td style="width: 469px;">Цена товара. Указана в карточке товара или продажи</td></tr><tr><td style="width: 224px;">Товарооборот</td><td style="width: 469px;">Количество проданных товаров \* цену товара</td></tr><tr><td style="width: 224px;">Товарооборот с учётом скидки</td><td style="width: 469px;">ТО товара - скидки на выбранный товар</td></tr><tr><td style="width: 224px;">Начислено</td><td style="width: 469px;">Сумма начисленных баллов при продажах этого товара</td></tr><tr><td style="width: 224px;">Доля в общем товарообороте</td><td style="width: 469px;">ТО товара / общий ТО \* 100%</td></tr><tr><td style="width: 224px;">Группа</td><td style="width: 469px;">К какой категории относится товар, указано в данных о товаре</td></tr><tr><td style="width: 224px;">Фактическая скидка</td><td style="width: 469px;">ТО - ТО с учетом скидки</td></tr><tr><td style="width: 224px;">Наценка</td><td style="width: 469px;">(Розничная цена / закупочная цена - 1) \*100%</td></tr></tbody></table>