{"id":13462,"date":"2018-04-03T15:36:30","date_gmt":"2018-04-03T15:36:30","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=13462"},"modified":"2018-04-06T07:50:46","modified_gmt":"2018-04-06T07:50:46","slug":"9-2-2-creating-item-sales-report-by-using-product-tag","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/9-2-2-creating-item-sales-report-by-using-product-tag\/","title":{"rendered":"9.2.2. Creating Item Sales Report by Using Product Tag"},"content":{"rendered":"


1. What is Item Sales Report Based on Product Tag Groups?
\n2. Creating Product Tag Captions
\n3. Grouping Products by Tagging
\n4. Creating New Report<\/p>\n

1. What is Item Sales Report Based on Product Tag Groups?<\/strong><\/span><\/p>\n

Product Sales Report Based on Product Tag Group:<\/strong>\u00a0In default SambaPOS settings Product Sales Report is created according to group codes<\/strong> that defined in the product list.\u00a0In some restaurants Product Sales Report might be requested based on different categories (Group Codes).\u00a0 It is possible to create Product Sales Report in different categories by creating item tags.<\/p>\n

\"\"<\/p>\n

2. Creating Product Tag Captions<\/strong><\/span>
\nManage > Settings > Program Settings > General Settings > Product Tag Captions (Edit) > Product Sales Categories<\/p>\n

Note:<\/strong>\u00a0It is possible to select a proper caption as tag caption according to need.<\/p>\n

\"\"<\/p>\n

3. Grouping Products by Tagging<\/strong><\/span>
\nManage > Products > Product Tag Editor Product Sales Categories<\/p>\n

Save by adding categories \/ Groups for products into related tag caption. Save the categories into related product line instantly.<\/p>\n

\"\"<\/p>\n

4. Creating New Report<\/strong><\/span><\/p>\n

Settings > Reports > Add New Report<\/p>\n

Report Name:<\/strong>\u00a0Product Sales Report Based on Categories
\nDisplay in Report Explerer [X]\u00a0 Navigation > Reports if desired under the Reports menu, mark this box.<\/p>\n

Template:<\/strong><\/p>\n\n\n\n
[Product Tag (Categories) Based Product Sales Report:2,5 , 2, 2]<\/code>
\n >Product Tag|Products|[N]Quantity|Amount<\/code>
\n @{REPORT ORDER DETAILS:MT.Product Sales Categories,O.Quantity.Sum::{0}:,}<\/code>
\n >>$1<\/code>
\n {REPORT ORDER DETAILS:,OT.,M.Name.asc,O.Quantity.Sum,O.ExactTotal.Sum:(MT.Product Sales Categories=$1)}<\/code>
\n >Total:|||{REPORT ORDER DETAILS:O.ExactTotal.Sum:(MT.Product Sales Categories=$1)}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

1. What is Item Sales Report Based on Product Tag Groups? 2. Creating Product Tag Captions 3. Grouping Products by Tagging 4. Creating New Report 1. What is Item Sales Report Based on Product Tag Groups? Product Sales Report Based on Product Tag Group:\u00a0In default SambaPOS settings Product Sales Report is created according to group […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-13462","post","type-post","status-publish","format-standard","hentry","category-reports"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=13462"}],"version-history":[{"count":3,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13462\/revisions"}],"predecessor-version":[{"id":13527,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13462\/revisions\/13527"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=13462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=13462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=13462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}