Two Orders Missing “Sales” Info but Still Showing “Refund” Amounts
-
I am having trouble with incorrectly-reported WooCommerce order data.
When I ran a report on the Dec 2021 sales, I saw a significantly lower amount in the “Gross Sales” than should have been possible.
Here is a screenshot of my Report from WooComemrce for Dec 2021.
https://www.dropbox.com/s/s4bvtyg96ymwrx5/WordpressSalesDataReportDecember2021.jpg?dl=0
I did some manual calculations by reviewing all the WooCommerce orders for the month of Dec 2021 marked as “complete”.
By doing this, I was able to discover that there are two legitimate +$1,000 refunds showing up in the WooCommerce Report, but the initial income from those two refunds was not reported at all.
Basically, it seems like WooCommerce is not tracking the income from these sales, but the report is still subtracting their refund amounts.
How can I manually correct this incorrectly-reported sales information so that my WooCommerce Reports (and soon WooCommerce Analytics) is accurate and trustworthy?
- This topic was modified 2 years, 10 months ago by CarletonTorpin.
-
Thanks for sharing the screenshot.
This kind of unusual behavior is usually caused by a conflict with your theme or with another plugin.
?
The best way to determine this is to:- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Repeat the action that is causing the problem
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
You can test this out on a staging site using a plugin like WP Staging.
Thank you for your response, Margaret.
I am using my staging server for all of the proceeding tests
I have switched to Storefront theme.
I have disabled all plugins except for WooCommerce.
I re-visited the WooCommerce Reports and checked the Dec 2021 timeframe sales.
The issue persists, and appears the same as before.
Two orders show a refund amount, but the initial sale income for those orders is not reflected.
I am pasting my system status below.
`
### WordPress Environment ###WordPress address (URL): https://stagebilliards.wpengine.com
Site address (URL): https://stagebilliards.wpengine.com
WC Version: 6.1.1
REST API Version: ? 6.1.1
WC Blocks Version: ? 6.5.2
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.0.3
Log Directory Writable: ?
WP Version: 5.9
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –### Server Environment ###
Server Info: Apache
PHP Version: 7.4.26
PHP Post Max Size: 100 MB
PHP Time Limit: 3600
PHP Max Input Vars: 10000
cURL Version: 7.58.0
OpenSSL/1.1.1SUHOSIN Installed: –
MySQL Version: 5.7.36-39-log
Max Upload Size: 50 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?### Database ###
WC Database Version: 6.1.1
WC Database Prefix: wp_
Total Database Size: 292.62MB
Database Data Size: 221.67MB
Database Index Size: 70.95MB
wp_woocommerce_sessions: Data: 9.52MB + Index: 0.14MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.19MB + Index: 0.08MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 2.09MB + Index: 2.23MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 5.48MB + Index: 6.59MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 3.39MB + Index: 3.63MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.33MB + Index: 0.33MB + Engine InnoDB
wp_comments: Data: 1.52MB + Index: 1.31MB + Engine InnoDB
wp_csshero4: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_item_attributes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_item_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_item_ecomm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_item_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_item_prices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewlpos_item_shops: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kc_us_clicks: Data: 0.02MB + Index: 0.20MB + Engine InnoDB
wp_kc_us_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kc_us_links: Data: 0.02MB + Index: 0.19MB + Engine InnoDB
wp_kc_us_links_groups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_calendarCategories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_calendarEvents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_calendarReminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_calendars: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_coupons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_customers: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_lfb_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_forms: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_lfb_items: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_lfb_layeredImages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_logs: Data: 20.52MB + Index: 0.00MB + Engine InnoDB
wp_lfb_redirConditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_steps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_lfb_variables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mc4wp_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mclean_refs: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nextend2_image_storage: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nextend2_smartslider3_sliders: Data: 1.52MB + Index: 0.03MB + Engine InnoDB
wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nextend2_smartslider3_slides: Data: 1.52MB + Index: 0.11MB + Engine InnoDB
wp_options: Data: 11.41MB + Index: 1.61MB + Engine InnoDB
wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 132.59MB + Index: 27.06MB + Engine InnoDB
wp_posts: Data: 8.50MB + Index: 3.59MB + Engine InnoDB
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_analytics_ga: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_analytics_objects: Data: 1.52MB + Index: 0.27MB + Engine InnoDB
wp_rank_math_internal_links: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.33MB + Index: 0.02MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides: Data: 2.52MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_say_what_strings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_short_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_short_link_clicks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_short_link_replacements: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sm_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tap_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tcb_api_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tcm_email_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tcm_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_td_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_td_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.19MB + Index: 0.22MB + Engine InnoDB
wp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_term_relationships: Data: 0.47MB + Index: 0.41MB + Engine InnoDB
wp_term_taxonomy: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
wp_usermeta: Data: 7.52MB + Index: 11.03MB + Engine InnoDB
wp_users: Data: 0.45MB + Index: 0.42MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.36MB + Index: 0.25MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.23MB + Index: 0.30MB + Engine InnoDB
wp_wc_order_stats: Data: 0.28MB + Index: 0.30MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.22MB + Index: 0.44MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdslayer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdsslide: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdsslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpie_template: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_wps_index: Data: 3.52MB + Index: 6.55MB + Engine InnoDB
wp_wps_key: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wps_uri: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB### Post Type Counts ###
_tcb_form_settings: 64
attachment: 3531
avia_framework_post: 10
br_filters_group: 12
br_product_filter: 52
custom_css: 3
customize_changeset: 7
ep-synonym: 3
ml-slide: 1
ml-slider: 1
nav_menu_item: 261
oembed_cache: 23
page: 245
post: 15
product: 912
product_variation: 595
product-feed: 1
rank_math_schema: 1
revision: 380
shop_coupon: 1
shop_order: 2008
shop_order_refund: 301
soliloquy: 1
sp_wps_shortcodes: 7
super-simple-slider: 1
tcb_content_template: 71
tcb_symbol: 77
thrive_demo_page: 1
thrive_demo_post: 1
thrive_layout: 15
thrive_section: 5
thrive_template: 22
thrive_typography: 2
tm_global_cp: 90
tve_notifications: 1
wapf_product: 1
wc_product_tab: 712
wc_product_table: 1
wc_xml_feeds: 6
wds-slider: 1
wpautoterms_page: 1
wpf_post_it: 2### Security ###
Secure connection (HTTPS): ?
Hide errors from visitors: ?### Active Plugins (1) ###
WooCommerce: by Automattic – 6.1.1
### Inactive Plugins (50) ###
Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.9
Additional Variation Images Gallery for WooCommerce – Pro: by Emran Ahmed – 1.2.7
Advanced Product Fields Extended for WooCommerce: by StudioWombat – 1.9.1
Akismet Anti-Spam: by Automattic – 4.2.2
Classic Editor: by WordPress Contributors – 1.6.2
Duplicate Page: by mndpsingh287 – 4.4.8
ElasticPress: by 10up – 3.6.6
ELEX Hide WooCommerce Shipping Methods: by ELEXtensions – 1.1.3
Extendons: WooCommerce & Light Speed POS Integration: by Extendons – 1.0.0
Gravity Forms: by Gravity Forms – 2.5.5.1
Gravity Forms Styles Pro: by Warp Lord – 3.0
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6
MC4WP: Mailchimp for WordPress Premium: by ibericode – 4.8.20
Product Description on Shop Page: by KoalaApps – 1.0.1
Product Slider Pro for WooCommerce: by ShapedPlugin – 2.7.3
Rank Math SEO: by Rank Math – 1.0.81.1
Rank Math SEO PRO: by Rank Math – 3.0.5
Smart Manager For WooCommerce – Stock Management, Bulk Edit & more…: by StoreApps – 5.31.0
Thrive Architect: by Thrive Themes – 3.6
Thrive Automator: by Thrive Themes – 0.5
Thrive Comments: by Thrive Themes – 2.2
Thrive Product Manager: by Thrive Themes – 1.2.7
TinyPNG – JPEG, PNG & WebP image compression: by TinyPNG – 3.3
User Role Editor: by Vladimir Garagulya – 4.61.1
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19
Variation Swatches for WooCommerce – Pro: by Emran Ahmed – 1.1.18
WooCommerce Affirm Gateway: by WooCommerce – 1.1.10
WooCommerce Authorize.Net Gateway: by SkyVerge – 3.6.2
WooCommerce Dynamic Pricing & Discounts: by RightPress – 2.4.3
WooCommerce Lead Time: by Barn2 Plugins – 1.5.3
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.11.4
WooCommerce Product Reviews Pro: by SkyVerge – 1.15.4
WooCommerce Putler Connector – Accurate Analytics and Reports for your WooCommerce Store: by putler
storeapps – 2.10.0WooCommerce Shipment Tracking: by WooCommerce – 1.6.29
WooCommerce Tab Manager: by SkyVerge – 1.12.2
WooCommerce TM Extra Checkout Options: by themeComplete – 1.7.6
WooCommerce TM Extra Product Options: by themeComplete – 5.1
WooCommerce UPS Shipping: by WooCommerce – 3.2.36
WooCommerce USPS Shipping: by WooCommerce – 4.4.67
Woocommerce XML Feeds: by Spyros Vlachopoulos – 1.0.7
WordPress Webp Converter: by XfinitySoft – 1.0.0
WP AutoTerms: by WP AutoTerms – 2.4.9
WP Cost Estimation & Payment Forms Builder: by Biscay Charly (loopus) – 10.1.26
WP Crontrol: by John Blackbourn & crontributors – 1.12.0
WPDash Notes: by WPFormation
NicolasKulka
WPServeur – 1.3.1WP Engine Smart Plugin Manager: by WP Engine – 5.10.1
WP Rocket: by WP Media – 3.10.7
YITH Infinite Scrolling: by YITH – 1.6.0
YITH Infinite Scrolling Premium: by YITH – 1.5.2
YITH WooCommerce Request A Quote Premium: by YITH – 3.1.3### Dropin Plugins (1) ###
advanced-cache.php: advanced-cache.php
### Must Use Plugins (6) ###
Force Strong Passwords – WPE Edition: by Jason Cosper – 1.8.0
WPE ElasticPress Autosuggest Logger: by WP Engine – 1.0.0
WP Engine Cache Plugin: by WP Engine – 1.0.5
WP Engine Seamless Login Plugin: by WP Engine – 1.5.5
WP Engine Security Auditor: by wpengine – 1.0.10
WP Engine System: by WP Engine – 5.0.1### Settings ###
API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: downloadable (downloadable)
external (external)
grouped (grouped)
simple (simple)
variable (variable)
virtual (virtual)Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)Connected to WooCommerce.com: –
### WC Pages ###
Shop base: ? Page not set
Cart: #7 – /cart/
Checkout: #8 – /checkout/
My account: #9 – /my-account/
Terms and conditions: #1328 – /support/terms-and-conditions/### Theme ###
Name: Storefront
Version: 3.9.1
Author URL: https://woocommerce.com/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?### Templates ###
Overrides: –
### Action Scheduler ###
Complete: 13,512
Oldest: 2022-01-28 01:48:03 +0000
Newest: 2022-02-01 03:36:02 +0000Pending: 2
Oldest: 2022-02-01 03:41:54 +0000
Newest: 2022-02-03 19:41:04 +0000Canceled: 16
Oldest: 2022-01-30 18:44:08 +0000
Newest: 2022-01-30 18:44:08 +0000### Status report information ###
Generated at: 2022-02-01 03:41:40 +00:00
Hi there,
Can you please check if there are any errors on the site?
Error Log: Share a copy of any fatal
error log
found under WooCommerce > System Status > Logs (if available).Let us know, thank you.
I have navigated to the WooCommerce > System Status > Logs.
There are many logs, but none say they are errors.
Here’s a screenshot of the dropdown for that page:
https://www.dropbox.com/s/zem124xm49n9je3/Screen%20Shot%202022-02-01%20at%207.39.27%20AM.png?dl=0
Hi @carletontorpin! Thanks for touching base!
If I understood you correctly, those refunded orders aren’t showing up on your Gross Sale report, is that correct?
I am trying to confirm this because the Gross Sales report doesn’t include refunds, it also doesn’t include tax, shipping, and coupons.
You can check this article from our documentation, right under the Definition of terms topic:
https://woocommerce.com/document/woocommerce-analytics/
If I’m not understanding you correctly, there’s no problem at all, share more details with us about the issue you’re facing and we’ll do our best to help you out!
My very best,
The Gross Sales are not reflecting that there was any initial income from (at least) two orders, but it is still showing that those orders got refunded.
Basically, the report is indicating that I’ve refunded money that I never received.
This is factually incorrect, and I have the evidence from all the past “Completed” orders for the given month.
When I add all the “completed” orders up for the month, manually, I am given a figure that is representative of the amount of money earned in the month.
When I use the “Reports” feature, two of those orders are missing entirely in the Gross Sales total.
Please refer to the circled area of this screenshot of my Report from WooComemrce for Dec 2021.
There should be a Blue spike in the area where the refunds are given out, but instead it only shows refunds, with no initial income.
https://www.dropbox.com/s/s4bvtyg96ymwrx5/WordpressSalesDataReportDecember2021.jpg?dl=0
I’ve used WooCommerce and the WooCommerce Reports feature for many years and this is the first time I’ve encountered such a discrepancy in the accounting.
I want to know if I can manually fix this discrepancy.
Specifically, how I can I tell WooCommerce that these orders did generate income, rather than showing as only a refund?
Hello,
Thanks for following up with this.
May I ask when you go to Analytics > Settings, are there statuses that are excluded?
Link to image: https://snipboard.io/XlygJa.jpgLet us know.
My Analytics > Settings look identical to the screenshot you sent.
Here’s what mine are set to.
https://www.dropbox.com/s/cr0smh0hbju5se5/Screen%20Shot%202022-02-02%20at%207.53.24%20AM.png?dl=0
Do the “Analytics” Settings have any effect on the WooCommerce Reports option?
I’ve been using the WooCommerce > Reports feature, but the Analytics feature also gives me erroneous data about my Dec 2021 sales figures.
Hi @carletontorpin,
There should be a Blue spike in the area where the refunds are given out
Can you check those orders and take a screenshot of the order notes? You can use https://snipboard.io/ to share a screenshot.
This probably happens because on Dec 30 you’ve processed refunds but orders were completed on a different date.
Cheers.
Thank you for you reply.
The orders in-question were purchased and refunded on Dec 29th and Dec 30th, respectively
I have pasted screenshots from both of the orders below:
Dec 29th Order for $350-ish https://snipboard.io/EnyoQb.jpg
Dec 30th Order for $1,400-ish https://snipboard.io/atFzXd.jpg
Hi @carletontorpin,
Thanks so much for sharing those screenshots. I’ve performed some cross-testing to check the WooCommerce Reports functionality and this is what I found out.
When your order is in the Processing Status the order amount will show under gross sales and net Sales in Reports > Orders (you will see a blue spike). But then when the order is refunded, gross sales and net sales values will be removed and you will only see a red spike for the refund.
Now, I’m not sure this should be the default behavior and I’d suggest that you report your findings at our public GitHub repository for WooCommerce Admin.
https://github.com/woocommerce/woocommerce-admin/issues/new/choose
Create a new issue and fill out the requested information.
There is a possibility that this is an intended feature but WooCommerce developers will be able to respond to your inquiry and let you know.
Please note that since the release of WooCommerce 4.0 in March 2019, WooCommerce Reports are deprecated and they will not receive any further updates.
Cheers.
- The topic ‘Two Orders Missing “Sales” Info but Still Showing “Refund” Amounts’ is closed to new replies.