{"id":20132,"date":"2023-09-20T17:21:25","date_gmt":"2023-09-20T17:21:25","guid":{"rendered":"https:\/\/synder.com\/help\/?p=20132"},"modified":"2026-08-19T14:46:39","modified_gmt":"2026-08-19T14:46:39","slug":"how-to-map-summaries-by-product-categories","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/how-to-map-summaries-by-product-categories\/","title":{"rendered":"How To Map Your Summaries by Product Categories"},"content":{"rendered":"\n
Grouping by product category allows Synder to post sales to income accounts based on product categories defined in your catalog. This guide explains how to enable grouping by product category and map each category to the appropriate income account.<\/p>\n\n\n\n
Use this guide if<\/p>\n\n\n\n
Don\u2019t use this guide if<\/p>\n\n\n\n
After configuration, summaries are grouped by category, and each summary line impacts the income account selected for that category in the Mappings list.<\/p>\n\n\n\n
For most integrations, you\u2019ll need to add categories to the products<\/strong> and then enable grouping by product category<\/strong>.<\/p>\n\n\n\n Note: For Shopify, WooCommerce, and Square, categories can be imported automatically. See the dedicated section below.<\/em><\/p>\n\n\n\n You can add categories manually or upload them using a CSV file.<\/p>\n\n\n\n Option A \u2013 Add product categories manually<\/strong><\/p>\n\n\n\n Repeat for additional products as needed.<\/em><\/p>\n\n\n\n Option B: Upload Categories via CSV<\/strong> Once mapping is complete, newly generated summaries and summaries with the Ready to sync<\/strong> status will reflect the assigned categories and accounts!<\/p>\n\n\n\n When you map summaries by product category, Synder posts a separate income line for each mapped category<\/strong>:<\/p>\n\n\n\n For Shopify, WooCommerce, and Square integrations, Synder automatically imports product categories and displays them in the Products and Services tab if categories are set up in the source platform.<\/p>\n\n\n\n After enabling Group by product category<\/strong>, sales are automatically grouped by imported categories inside the Summaries.<\/p>\n\n\n\n Example category imported from Shopify product:<\/strong><\/p>\n\n\n\n After you import transactions from your integrations, Synder will fetch the product category automatically:<\/strong><\/p>\n\n\n\n After import, updated categories appear under the Product category<\/strong> column!<\/p>\n\n\n\n If you add categories before enabling \u201cGroup by product category\u201d<\/p>\n If you add categories after enabling \u201cGroup by product category\u201d:<\/strong><\/p>\n\n\n\n Reach out to Synder Team<\/em><\/a> via online support chat or email with any questions you have \u2013 we are always happy to help you!<\/p>\n","protected":false},"excerpt":{"rendered":" Grouping by product category allows Synder to post sales to income accounts based on product categories defined in your catalog. This guide explains how to enable grouping by product category and map each category to the appropriate income account. Use this guide if Don\u2019t use this guide if After configuration, summaries are grouped by category, […]<\/p>\n","protected":false},"author":2233,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":"","_ppma_block_editor_authors":""},"categories":[392,376,379,361],"tags":[],"ppma_author":[338],"class_list":["post-20132","post","type-post","status-publish","format-standard","hentry","category-products-inventory-cogs-summary","category-transaction-recording-summary","category-categorization","category-products-inventory-cogs"],"yoast_head":"\nStep 1:<\/strong> Add product categories<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\n
<\/strong><\/p>\n\n\n\n\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\nStep 2: Enable Grouping by Product Category<\/strong><\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\nStep 3: <\/strong>Map Product Categories to Accounts<\/strong><\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\nWhat it looks like in QuickBooks Online<\/h2>\n\n\n\n
<\/figure>\n\n\n\nProduct categories for Shopify, WooCommerce, and Square<\/strong><\/h2>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nImportant notes<\/strong><\/h2>\n\n\n\n
\n
\n
\n
\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nFAQ<\/strong><\/h2>\n\n\n\n
\n
\n
\n
\n
<\/strong>
If you assigned categories after enabling grouping, rebuild the summaries to apply the updated mapping.<\/li>\n\n\n\n
<\/strong>
Products imported without assigned categories appear under a No category row on the Mapping page. Review the Products and Services tab and categorize any products as needed.<\/li>\n<\/ol>\n\n\n\n