{"id":3652,"date":"2023-08-19T11:00:36","date_gmt":"2023-08-19T11:00:36","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/?p=3652"},"modified":"2024-01-09T09:41:32","modified_gmt":"2024-01-09T09:41:32","slug":"billing-city-report","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/billing-city-report\/","title":{"rendered":"Generate billing city report with the WooCommerce report plugin"},"content":{"rendered":"\n<p>If you manage an online store providing many products for customers in various cities, exploring localized sales patterns and identifying top-performing cities is one of your most important tasks. This tutorial teaches you how to generate a billing city report with the <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-report\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">WooCommerce report plugin<\/span><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is a billing city report?<\/h2>\n\n\n\n<p>A billing city report is a simple report providing a list of all cities that customers place their orders in. You can find useful information like the number of orders and the total amount of orders related to each city in this report.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why do managers need to explore localized sales by billing city reports?<\/h2>\n\n\n\n<p>The most important reason for preparing the billing city report is that managers of online stores can identify in which cities their customers place orders the most. By reviewing this information, they can take the necessary steps to supply enough products and prepare shipping methods and strategies to honor their loyal customers. On the other hand, by identifying cities that have experienced low sales, they can also use marketing and advertising to increase their sales in those cities.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to generate a WooCommerce billing city report?<\/h2>\n\n\n\n<p>To generate a billing city report in our plugin, first, you need to navigate to the below address:<\/p>\n\n\n\n<p><strong>More Reports -&gt; Billing City<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-01-click-billing-city.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"309\" height=\"349\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-01-click-billing-city.png\" alt=\"click billing city menu\" class=\"wp-image-3658\"\/><\/a><\/figure>\n\n\n\n<p>Then by opening the <strong>Search<\/strong> form, you have to set a date range as illustrated below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-02-set-date-range-billing-city.png\"><img decoding=\"async\" width=\"494\" height=\"839\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-02-set-date-range-billing-city.png\" alt=\"set date range billing city of filter form\" class=\"wp-image-3654\"\/><\/a><\/figure>\n\n\n\n<p>Finally, clicking the <strong>Search<\/strong> button lets you observe the <strong>Billing City<\/strong> report.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-03-result-billing-city.png\"><img decoding=\"async\" width=\"1532\" height=\"737\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-03-result-billing-city.png\" alt=\"result billing city columns\" class=\"wp-image-3655\"\/><\/a><\/figure>\n\n\n\n<p>There are 5 columns in this report by default which are sorted by the name of the cities in the first column, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Billing City<\/strong>: The name of the city that received the orders.<\/li>\n\n\n\n<li><strong>Billing State<\/strong>: The state that the city belongs to.<\/li>\n\n\n\n<li><strong>Billing Country<\/strong>: The country that the city belongs to.<\/li>\n\n\n\n<li><strong>Order Count<\/strong>: The number of orders placed in the city.<\/li>\n\n\n\n<li><strong>Amount<\/strong>: The total amount of orders placed in the city.<\/li>\n<\/ul>\n\n\n\n<p>If you want to sort the report by the data of other columns, you can easily click the <strong>Up\/Down<\/strong> arrow next to it. For example, by pressing the arrows next to the <strong>Amount<\/strong> column, the city with the total amount of orders will be shown at the top of the table, followed by other amounts in ascending order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-05-choose-other-columns.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1517\" height=\"600\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-05-choose-other-columns.png\" alt=\"choose other columns billing city\" class=\"wp-image-3656\"\/><\/a><\/figure>\n\n\n\n<p>A brief report is at the bottom of the table, displaying useful information, including <strong>Billing City Count, Order Count, and Total Amount<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-07-result-total-amount-billing-city.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1528\" height=\"159\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-content\/uploads\/sites\/16\/2023\/08\/031-07-result-total-amount-billing-city.png\" alt=\"result total amount billing city\" class=\"wp-image-3657\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>If you manage an online store providing many products for customers in various cities, exploring localized sales patterns and identifying top-performing cities is one of your most important tasks. This tutorial teaches you how to generate a billing city report with the WooCommerce report plugin. What is a billing city report? A billing city report [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3652","post","type-post","status-publish","format-standard","hentry","category-plugin-usage"],"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts\/3652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/comments?post=3652"}],"version-history":[{"count":0,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/posts\/3652\/revisions"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/media?parent=3652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/categories?post=3652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-report\/wp-json\/wp\/v2\/tags?post=3652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}