howacoglass

Thank you. I do have custom sorting + name chosen, but unfortunately it doesn’t do anything, I still have to drag and drop to organize them. I use Divi as my theme if that matters.

After thinking about it, I do not believe the custom coding has anything to do with it. The reason I think that is because the reports and the analytics show different amounts of orders. Counting the number of orders for my state would have nothing to do with the items in the order that generate the sales tax.
I am working on updating the PHP and will look at doing a test in the staging site, that might take me a couple days to get that figured out and I will be back with the results. Thank you so much for your help!

• This reply was modified 2 years, 3 months ago by howacoglass.

Ohhhhhh, just had a thought, I don’t think this should matter, but, I had some custom work done on my site to be able to sell some items in fractional quantities. Some of my items can be sold in 0.25, 0.50, 0.75 or 1.25, 1.5 etc. I know that is not the norm for woocommerce, but, on the orders the sales tax is calculated correctly, I have double checked many of them when the work on the site was first done, but wondering if maybe that could mess something up in the reports somewhere else maybe?

Thank you again. Screen shots and report:

https://snipboard.io/UOT1hm.jpg
https://snipboard.io/adIkVl.jpg

### WordPress Environment ###

WordPress address (URL): https://howacoglass.com
Site address (URL): https://howacoglass.com
WC Version: 6.7.0
REST API Version: ? 6.7.0
WC Blocks Version: ? 7.8.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.33
PHP Post Max Size: 16 MB
PHP Time Limit: 720
PHP Max Input Vars: 1000
cURL Version: 7.84.0
OpenSSL/1.1.1q

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.48-MariaDB
Max Upload Size: 16 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? wp_remote_get() failed. Contact your hosting provider.

### Database ###

WC Database Version: 6.7.0
WC Database Prefix: wp9c_
Total Database Size: 197.81MB
Database Data Size: 125.38MB
Database Index Size: 72.43MB
wp9c_woocommerce_sessions: Data: 45.63MB + Index: 0.52MB + Engine MyISAM
wp9c_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_order_items: Data: 0.34MB + Index: 0.18MB + Engine MyISAM
wp9c_woocommerce_order_itemmeta: Data: 6.33MB + Index: 1.81MB + Engine MyISAM
wp9c_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
bf_activitylog: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
bf_core_hashes: Data: 0.33MB + Index: 0.39MB + Engine InnoDB
bf_files: Data: 8.52MB + Index: 28.98MB + Engine InnoDB
bf_files_last: Data: 8.52MB + Index: 26.92MB + Engine InnoDB
bf_folders: Data: 0.47MB + Index: 0.83MB + Engine InnoDB
bf_folders_to_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp9c_actionscheduler_actions: Data: 0.62MB + Index: 0.33MB + Engine MyISAM
wp9c_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_actionscheduler_logs: Data: 0.41MB + Index: 0.35MB + Engine MyISAM
wp9c_ce4wp_abandoned_checkout: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_comments: Data: 0.56MB + Index: 0.25MB + Engine MyISAM
wp9c_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailchimp_carts: Data: 0.31MB + Index: 0.01MB + Engine MyISAM
wp9c_mailchimp_jobs: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_newsletter_templates: Data: 1.04MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_scheduled_tasks: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_mailpoet_scheduled_task_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_subscribers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_options: Data: 3.62MB + Index: 0.38MB + Engine MyISAM
wp9c_postmeta: Data: 11.10MB + Index: 3.63MB + Engine MyISAM
wp9c_posts: Data: 2.24MB + Index: 0.60MB + Engine MyISAM
wp9c_redirection_404: Data: 16.87MB + Index: 3.05MB + Engine MyISAM
wp9c_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wp9c_redirection_logs: Data: 4.43MB + Index: 0.70MB + Engine MyISAM
wp9c_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp9c_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_term_relationships: Data: 0.11MB + Index: 0.23MB + Engine MyISAM
wp9c_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp9c_usermeta: Data: 0.60MB + Index: 0.29MB + Engine MyISAM
wp9c_users: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wp9c_wc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp9c_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp9c_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_wc_customer_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
wp9c_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wc_order_product_lookup: Data: 0.46MB + Index: 0.40MB + Engine MyISAM
wp9c_wc_order_stats: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
wp9c_wc_order_tax_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_wc_product_meta_lookup: Data: 0.32MB + Index: 0.44MB + Engine MyISAM
wp9c_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wdr_order_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wdr_order_item_discounts: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp9c_wdr_rules: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp9c_wfblockediplog: Data: 0.19MB + Index: 0.13MB + Engine MyISAM
wp9c_wfblocks7: Data: 0.06MB + Index: 0.04MB + Engine MyISAM
wp9c_wfconfig: Data: 2.59MB + Index: 0.02MB + Engine MyISAM
wp9c_wfcrawlers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp9c_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wffilemods: Data: 3.07MB + Index: 0.37MB + Engine MyISAM
wp9c_wfhits: Data: 0.74MB + Index: 0.16MB + Engine MyISAM
wp9c_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wfissues: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp9c_wfknownfilelist: Data: 2.22MB + Index: 0.11MB + Engine MyISAM
wp9c_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wflogins: Data: 0.52MB + Index: 0.11MB + Engine MyISAM
wp9c_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp9c_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp9c_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp9c_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_wfstatus: Data: 0.12MB + Index: 0.06MB + Engine MyISAM
wp9c_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp9c_woo_shippment_provider: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp9c_wpforms_tasks_meta: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp9c_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp9c_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp9c_yoast_indexable: Data: 2.42MB + Index: 0.57MB + Engine MyISAM
wp9c_yoast_indexable_hierarchy: Data: 0.07MB + Index: 0.17MB + Engine MyISAM
wp9c_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp9c_yoast_primary_term: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp9c_yoast_seo_links: Data: 0.01MB + Index: 0.01MB + Engine MyISAM

### Post Type Counts ###

attachment: 2314
custom_css: 1
customize_changeset: 17
feedback: 220
mailpoet_page: 1
nav_menu_item: 80
page: 8
product: 2046
product_variation: 259
revision: 254
shop_coupon: 1
shop_order: 596
shop_order_refund: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (16) ###

Advanced Automatic Updates: by pento – 1.0.2
Classic Editor: by WordPress Contributors – 1.6.2
Flexible Shipping: by Octolize – 4.13.2
Jetpack: by Automattic – 11.1.2
Mailchimp for WooCommerce: by Mailchimp – 2.7.1
Min and Max Quantity for WooCommerce: by BeRocket – 1.3.2.4
Redirection: by John Godley – 5.3.0
Advanced Shipment Tracking for WooCommerce: by zorem – 3.4.4
Woo Discount Rules: by Flycart – 2.4.3
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.11.4
WooCommerce: by Automattic – 6.7.0
Wordfence Security: by Wordfence – 7.5.11
Yoast SEO: by Team Yoast – 19.3
WP Force SSL: by WebFactory Ltd – 1.65
WP Mail SMTP: by WPForms – 3.5.1
WPForms Lite: by WPForms – 1.7.5.3

### Inactive Plugins (5) ###

Facebook for WooCommerce: by Facebook – 2.6.18
Google Ads & Marketing by Kliken: by Kliken – 1.0.8
mywpguru: by Phil Taylor – is fully automatically updated to the latest
WooCommerce Shipping & Tax: by WooCommerce – 1.26.2
Woo Custom Stock Status: by Softound Solutions – 1.3.0

### Settings ###

API Enabled: –
Force SSL: ?
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

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: ?
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #8 - /shop/
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: HowacoGlass
Version: 1.0
Author URL: 
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 4.17.3
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ?

### Templates ###

Overrides: HowacoGlass/woocommerce/archive-product.php
HowacoGlass/woocommerce/global/quantity-input.php
HowacoGlass/woocommerce/global/sidebar.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-08-02 23:50:06 -04:00
Options: ?
Notes: 63
Onboarding: completed

### Action Scheduler ###

Canceled: 2
Oldest: 2022-07-02 22:11:26 +0000
Newest: 2022-07-26 12:22:47 +0000

Complete: 800
Oldest: 2022-07-10 02:26:11 +0000
Newest: 2022-08-02 03:46:45 +0000

Pending: 5
Oldest: 2022-08-02 07:05:54 +0000
Newest: 2022-08-09 03:46:45 +0000

### Status report information ###

Generated at: 2022-08-02 00:02:44 -04:00

Thank you for your reply, but that actually makes it even more confusing. Canceled and Failed orders taxes should not be included in the sales tax and those are checked in my setup. I should not pay in sales tax on orders that did not complete.
But, so why are my Reports still showing so much less “collected” sales tax? If the Analytics is excluding info, the reports should show more tax then the Analytics, not less, correct?
But, this still leaves me confused, I have NO idea if I paid in the right amount of sales tax for 2021. My website has only been up and running since last summer, so there is no historical data to bring in, it is all current. How can I figure out what sales tax figure is right? Only sales tax I should be paying to the state is on completed orders, that is pretty cut and dry, but I have no idea how to get that correct amount from the setup that is available to me.
Your help is greatly appreciated.
I did decide to try to import the historical data “just because” and it won’t, it says: Status: Nothing To Import

• This reply was modified 2 years, 4 months ago by howacoglass.

Thank you. I didn’t realize that only some options were in the product and the other options were within the plugin set up.

I found out what caused the issue but still don’t like the result. When I am in my Paypal account and am capturing the payment there is the option to choose to have additional authorization. That actually serves no purpose at all, but sometimes when trying to click through capturing the payment quickly that can accidently be chosen. That option is a 30 day authorization.
So when that authorization time frame ends, Paypal sends an IPN stating that the capture was a fail. Then Woocommerce changes the order from completed to fail. That should not happen because the order is fully completed and the customers already have their items. So I am going to contact Paypal and Woocommerce both to try to figure out how to not have this happen.

I am not using a plug in. In Woocommerce you can choose to direct people to a Paypal payment page in the payments tab.