tccand

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 15 total)
  • Thread Starter tccand

    (@tccand)

    https://github.com/woocommerce/woocommerce/issues/45167

    Thread Starter tccand

    (@tccand)

    Hello @shameemreza,

    Sorry for the delayed response.

    I am not sure I understand what you were trying to say here:
    “The?WC_Order_Item_Coupon->get_discount()?function retrieves the discount amount for the coupon, but the value might vary depending on when and how it’s applied.”

    There are 2 cases for my problem:
    1. adding a coupon from the admin side of wordpress.
    2. adding a coupon from the frontend site.

    get_discount() should return the same value after the order has been created for both of these cases.
    The problem is not theget_discount() function. The coupon data that is stored in the database is wrong.

    One way of checking this is to look in the database at the _woocommerce_order_itemmeta table:
    DB example
    Case 1:
    6190 | 887 | coupon_info | [204,”brmg”,”percent”,10]
    6189 | 887 | discount_amount_tax | 0.652294
    6188 | 887 | discount_amount | 7.247706

    Case 2:
    6187 | 886 | coupon_info | [204,”brmg”,”percent”,10]
    6186 | 886 | discount_amount_tax | 0.65
    6185 | 886 | discount_amount | 7.25

    Another way is to do a get order on the REST API:
    Case 1:
    “couponLines”: [
    {
    “id”: 892,
    “code”: “brmg”,
    “discount”: “7.247706”,
    “discountTax”: “0.652294”,
    “metaData”: [
    {
    “id”: 6220,
    “key”: “coupon_info”,
    “value”: “[204,\”brmg\”,\”percent\”,10]”,
    “displayKey”: “coupon_info”,
    “displayValue”: “[204,\”brmg\”,\”percent\”,10]”
    }
    ],
    “discountType”: “percent”,
    “nominalAmount”: 10,
    “freeShipping”: false
    }
    ],

    Case 2:
    “couponLines”: [
    {
    “id”: 891,
    “code”: “brmg”,
    “discount”: “7.25”,
    “discountTax”: “0.65”,
    “metaData”: [
    {
    “id”: 6217,
    “key”: “coupon_info”,
    “value”: “[204,\”brmg\”,\”percent\”,10]”,
    “displayKey”: “coupon_info”,
    “displayValue”: “[204,\”brmg\”,\”percent\”,10]”
    }
    ],
    “discountType”: “percent”,
    “nominalAmount”: 10,
    “freeShipping”: false
    }
    ],


    In both cases the order has the same items so the response should be the same.
    I look forward to your response.

    Thread Starter tccand

    (@tccand)

    Hey @shameemreza,

    I guess that answers my question.
    Based on your answer this is a bug:
    “If multiple VAT rates exist, the fee’s VAT will be calculated based on the first applicable tax rate.”
    If the value is negative the fee’s VAT is not calculated based on the first applicable tax rate (all of them are used, and the VAT is calculated “incorrectly”).

    Thank you for the clarification,
    I will continue this thread here.

    Thread Starter tccand

    (@tccand)

    Hey @anastas10s,

    No, I am not talking about something we’ve built on top of woocommerce.

    I will try to simplify this as much as possible.

    On this page https://woo.com/document/managing-orders/#viewing-and-editing-a-single-order
    There is this information:
    “Add fee. You can enter an amount or percentage to add a fee to an order.?Negative fees will apportion taxes between all other items, and will not make the cart total go below zero”

    I presented my case in this video https://www.loom.com/share/74711e21f55741f1a04d5066e4fc09a7?sid=8e691ea9-4507-4ee4-831d-8c6ab85dc8fd

    So please answer me this question.
    Which one of these options is it?
    A) In my video the order fee VAT(-50) is calculated correctly and the 19% should be -8.16 and 9% should be -0.64
    B) This is a bug the order fee VAT(-50) should be -9.5 for 19%.

    If A I would like to know why the value is 8.16 and how is it calculated.
    If B I would like to know if it will be fixed.

    Thank you!

    Thread Starter tccand

    (@tccand)

    Hello again @shameemreza,
    I can confirm that the error can be reproduced on WordPress 6.4.3 and Woocommerce 8.7.0

    After the order is created I use this PHP code to check for the discount value:

    $data ? ? ? ? ? ? ?= $order->get_data();
    $coupons ? ? ? ? ? = $data[‘coupon_lines’];
    foreach ( $coupons as $item ) {
    error_log(print_r($item->get_discount(),true));
    }

    Adding a coupon from wc-orders page will give different results than checkout page or cart page.

    Thank you!

    Thread Starter tccand

    (@tccand)

    Hey @anastas10s,

    We have a module/plugin built on top of woocommerce. Some of our users use the order item fee with negative amounts.
    Woocommerce allows this.
    Our clients/users, so far, have not used multiple VATs with negative order item fees. But we have tested this case in order to know what happens.

    There are 2 problems with the order item fee:
    1. When an order item fee is added to an order with multiple VATs only the first one is added to the order item fee (I am not sure if this is correct, we have no problem in handling this case on our side)

    2. When a negative value order item fee is added on an order with multiple VATs, the VATs are incorrect (see my initial example)
    -8.16 is not 19%
    also in this case both VATs are calculated (should still be one?).

    Even if there are both VATs or only 1 the value should still be -9.5 for the 19%

    We can not treat this problem on our side. I would like to know if this is a functionality that is allowed but not recommended (negative fees) or something along this line.

    Thank you.

    Thread Starter tccand

    (@tccand)

    Hello @shameemreza,

    I tried enabling “Calculate coupon discounts sequentially”. It made no difference.

    I am using WordPress 6.5-RC2 and Woocommerce 8.7.0-rc.1

    I also have “Round tax at subtotal level, instead of rounding per line” enabled.

    Is there anything else I can try?

    Thank you!

    Thread Starter tccand

    (@tccand)

    Hey, @carolm29
    Any updates?

    Thread Starter tccand

    (@tccand)

    Hey,
    Here is a short video:
    https://www.loom.com/share/74711e21f55741f1a04d5066e4fc09a7?sid=8e691ea9-4507-4ee4-831d-8c6ab85dc8fd

    Thank you!

    Thread Starter tccand

    (@tccand)

    That seems to solve the problem.
    Thank you!

    Thread Starter tccand

    (@tccand)

    I’ve tested this on a fresh install.
    There are no errors in the log files.

    ` WordPress Environment

WordPress address (URL): https://newoobill.lambda.brunomag.ro
Site address (URL): https://newoobill.lambda.brunomag.ro
WC Version: 8.4.0
REST API Version: ? 8.4.0
WC Blocks Version: ? 11.6.2
Action Scheduler Version: ? 3.7.0
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: – Server Environment

Server Info: Apache
PHP Version: 8.1.18
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.81.0
OpenSSL/3.0.2

SUHOSIN Installed: –
MySQL Version: 10.6.12-MariaDB-0ubuntu0.22.04.1
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.4.0
WC Database Prefix: wp_
Total Database Size: 5.28MB
Database Data Size: 3.58MB
Database Index Size: 1.70MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + 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.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + 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: 0.02MB + Index: 0.11MB + 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: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 2.48MB + Index: 0.06MB + Engine InnoDB
wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_posts: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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 Post Type Counts

attachment: 1
page: 7
post: 2
product: 1
revision: 1
shop_order_placehold: 3
wp_global_styles: 1
wp_navigation: 1
wp_template: 2 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (2)

SmartBill Facturare si Gestiune: by smarbill.ro – 3.1.7
WooCommerce: by Automattic – 8.4.0 Inactive Plugins (2)

Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3
Hello Dolly: by Matt Mullenweg – 1.7.2 Settings

API Enabled: –
Force SSL: –
Currency: RON (lei)
Currency Position: right_space
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 Woo.com: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: – WC Pages

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

Name: Twenty Twenty-Four
Version: 1.0
Author URL: https://www.ads-software.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: ? Not declared Templates

Overrides: /home/newoobill/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/error.php
/home/newoobill/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/notice.php
/home/newoobill/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/success.php Admin

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

Disabled Features: customize-store
minified-js
new-product-management-experience
product-external-affiliate
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-12-14 11:33:26 +00:00
Options: ?
Notes: 64
Onboarding: skipped Action Scheduler

Complete: 8
Oldest: 2023-12-13 11:34:30 +0000
Newest: 2023-12-13 11:41:07 +0000

Failed: 2
Oldest: 2023-12-13 11:37:09 +0000
Newest: 2023-12-13 11:37:26 +0000

Pending: 1
Oldest: 2023-12-14 11:34:30 +0000
Newest: 2023-12-14 11:34:30 +0000 Status report information

Generated at: 2023-12-13 15:21:05 +00:00
`
    • This reply was modified 11 months, 3 weeks ago by tccand.
    Thread Starter tccand

    (@tccand)

    I can no longer reproduce the error.

    Thread Starter tccand

    (@tccand)

    Here is woocommerce system status:


WordPress Environment

WC Version: 7.8.0
REST API Version: ? 7.8.0
WC Blocks Version: ? 10.2.2
Action Scheduler Version: ? 3.5.4
Log Directory Writable: ?
WP Version: ? 6.2-RC5-55605 - There is a newer version of WordPress available (6.3-alpha-55991)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

Server Environment

Server Info: Apache
PHP Version: 8.1.18
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.81.0
OpenSSL/3.0.2

SUHOSIN Installed: –
MySQL Version: 10.6.12-MariaDB-0ubuntu0.22.04.1
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

Database

WC Database Version: 7.8.0
WC Database Prefix: wp_
Total Database Size: 110.33MB
Database Data Size: 62.12MB
Database Index Size: 48.21MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + 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: 2.52MB + Index: 1.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 19.55MB + Index: 19.06MB + 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: 0.09MB + Index: 0.13MB + 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: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aelia_exchange_rates_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bwf_actions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_bwf_action_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwf_contact: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_bwf_contact_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bwf_funnelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwf_funnels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bwf_optin_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bwf_wc_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cky_banners: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_cky_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cky_cookie_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 1.52MB + Index: 0.92MB + Engine InnoDB
wp_etn_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_etn_trans_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_extCCFA_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_extCCFA_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + 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.06MB + 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_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mo_openid_linked_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 5.38MB + Index: 0.13MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 21.52MB + Index: 13.03MB + Engine InnoDB
wp_posts: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
wp_raffleplaywoo_audit: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_raffleplaywoo_main: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_raffleplaywoo_main_bk: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_raffleplaywoo_product: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_raffleplaywoo_raffle: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_raffleplaywoo_winners: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sameday_awb: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sameday_locker: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sameday_package: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sameday_pickup_point: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sameday_service: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_shopmagic_automation_outcome: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_automation_outcome_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_shopmagic_guest: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_guest_meta: Data: 0.44MB + Index: 0.23MB + Engine InnoDB
wp_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ssa_appointments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_ssa_appointment_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ssa_appointment_types: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_ssa_appointment_type_labels: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ssa_async_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_ssa_availability: Data: 0.08MB + Index: 0.16MB + Engine InnoDB
wp_ssa_availability_external: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_supsystic_tbl_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_supsystic_tbl_diagrams: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_supsystic_tbl_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_supsystic_tbl_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_usermeta: Data: 1.52MB + Index: 1.91MB + Engine InnoDB
wp_users: Data: 0.19MB + Index: 0.23MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.09MB + Index: 0.06MB + 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: 4.52MB + Index: 7.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.47MB + Index: 0.36MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + 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_wfacp_stats: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfco_report_views: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpdatacharts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpdatatables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpdatatables_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpdatatables_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpsi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpsi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpsi_posts: 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

attachment: 26
custom-css-js: 1
elementor_library: 1
page: 35
post: 2
product: 51
product_variation: 25
publications: 1
revision: 29
shop_coupon: 18
shop_order: 3833
shopmagic_automation: 1
tablepress_table: 1
tc_api_keys: 1
tc_templates: 1
um_directory: 1
um_form: 3
wfacp_checkout: 1
wp_global_styles: 2

Security

Secure connection (HTTPS): ?
Hide errors from visitors: ?Error messages should not be shown to visitors.

Active Plugins (15)

Gravity Forms: by Gravity Forms – 2.6.9
Test HubSpot Card: by –
Simple Custom CSS and JS: by SilkyPress.com – 3.38
FAQ Schema For Pages And Posts: by Krystian Szastok (SEO Consultant) – 2.3.0
Gravity Forms Stripe Add-On: by Gravity Forms – 4.3
Gravity Forms Twilio Add-On: by Gravity Forms – 2.9
Loco Translate: by Tim Whitlock – 2.6.3
NETOPIA Payments Payment Gateway: by Netopia – 1.3
Petice Brunomag: by –
WooCommerce Beta Tester: by WooCommerce – 2.1.0
WooCommerce Stripe Gateway: by WooCommerce – 7.4.1
WooCommerce: by Automattic – 7.8.0-rc.2 (update to version 7.8.0 is available)
SmartBill Facturare si Gestiune: by smarbill.ro – 3.1.3
WordPress Beta Tester: by WordPress Upgrade/Install Team – 3.4.1
WP Mail SMTP: by WPForms – 3.5.2

Inactive Plugins (60)

Akismet Anti-Spam: by Automattic – 5.1
BRMGWEB-120: by – 1.0.5
BRMGWEB-141: by – 1.0.0
BRMGWEB-177: by – 1.0.0
BRMGWEB-197: by Brunomag Concept SRL – 1.0.1
BRMGWEB-220: by Brunomag Concept SRL – 1.0.0
BRMGWEB-241: by Brunomag Concept SRL – 1.0.0
Brunomag Import: by – 1.0.0
Brunomag Mayoral Importer: by Brunomag Concept SRL – 1.0.0
Brunomag Utils: by Brunomag Concept SRL – 1.0.3
Brunomag Utils: by Brunomag Concept SRL – 1.0.3
Conditional Checkout Fields for WooCommerce: by FME Addons – 1.0.6
CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.8
Event Tickets Manager for WooCommerce: by WP Swings – 1.1.1
EZ SQL Reports Shortcode Widget and DB Backup: by Eli Scheetz – 5.21.35
Facturare - Persoana Fizica sau Juridica: by George Ciobanu – 1.1.2
FGO Premium: by i-Tom Solutions – 0.4.0
GTranslate: by Translate AI Multilingual Solutions – 2.9.6
Hello Dolly: by Matt Mullenweg – 1.7.2
Hide admin menu: by Bhavin Thummar & Maulik Patel (BM Studio) – 1.1.1
HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 8.0.227
Import and export users and customers: by codection – 1.18.4.4
MainWP Child: by MainWP – 4.1.9
Netopia mobilPay Payment Gateway: by Netopia – 1.0
Nextend Social Login: by Nextendweb – 3.1.7
Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC): by WebToffee – 2.1.3
Order Reports for WooCommerce: by Ramn – 1.0.3
Order Status Control for WooCommerce: by Bright Plugins – 0.2
Order Status History for WooCommerce: by alx359 – 1.7.5
Print PDF Generator and Publisher: by nopea.media – 1.1.2
Product Input Fields for WooCommerce: by Tyche Softwares – 1.3.1
Product Sales Report for WooCommerce: by Aspen Grove Studios – 1.5.1
PW WooCommerce Gift Cards: by Pimwick
LLC – 1.216

Raffle Play Woo: by dan009 – 2.0.0
SamedayCourier Shipping: by SamedayCourier – 1.0.28
Show Hooks: by rafiq91
exlac – 0.2

SmartBill WooCommerce: by Intelligent IT SRL – 99.13.37
Social Login: by OneAll Social Login [email protected] – 5.7
TablePress: by Tobias B?thge – 1.14
Termene Woocommerce: by – 1.0.5
Tickera: by Tickera.com – 3.5.1.0
Ultimate Member: by Ultimate Member – 2.5.1
User Menus: by Code Atlantic – 1.2.9
User Role Editor: by Vladimir Garagulya – 4.63
White Label CMS: by www.videousermanuals.com – 2.3
Woocommerce Customers Order History: by javmah – 5.2.0
WooCommerce EU VAT Assistant: by Aelia – 2.0.24.210211
Woo Custom Stock Status: by Softound Solutions – 1.3.0
WooFunnels Funnel Builder: by BuildWooFunnels – 1.9.0
Woo Simple Tickets: by vimes1984 – 1.0.10
WordPress Users & WooCommerce Customers Import Export(BASIC): by WebToffee – 2.2.2
WP Activity Log: by WP White Security – 4.3.3.1
WP Activity Log for WooCommerce: by WP White Security – 1.3.1
WP All Import: by Soflyy – 3.6.8
WP Data Access: by Passionate Programmers – 5.0.0
wpDataTables - Tables & Table Charts: by TMS-Plugins – 2.1.21
WP Multilang: by Valentyn Riaboshtan – 2.4.1
WP Smart Import: by Xylus Themes – 1.0.2
YITH WooCommerce Added to Cart Popup: by YITH – 1.8.0
Zapier for WordPress: by Zapier – 1.0.2

Settings

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: event_ticket_manager (event_ticket_manager)
external (external)
grouped (grouped)
pw gift card (pw-gift-card)
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: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

WC Pages

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

Theme

Name: Twenty Twenty-Two
Version: 1.4
Author URL: https://www.ads-software.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: –

Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-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
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: core-profiler
minified-js
new-product-management-experience
product-variation-management
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-06-23 16:20:32 +03:00
Options: ?
Notes: 161
Onboarding: completed

Action Scheduler

Complete: 92
Oldest: 2023-05-25 12:16:24 +0300
Newest: 2023-06-23 17:17:55 +0300

Failed: 79
Oldest: 2022-12-14 11:00:55 +0200
Newest: 2023-06-16 12:33:10 +0300

Pending: 3
Oldest: 2023-06-23 17:18:15 +0300
Newest: 2023-06-26 16:59:28 +0300

Status report information

Generated at: 2023-06-23 17:19:01 +03:00
`
    Thread Starter tccand

    (@tccand)

    Hello,
    Sorry for the late reply.

    Let me provide a few more details:

    As a payment method, I used “Direct bank transfer”.
    Just enabling it without any other configuration is enough in order to reproduce this problem.

    Yes, I am referring to a third-party module. But I would leave that aside for now, since the module does not need to be installed to reproduce the problem.
    I can not offer you a System Status report atm.
    I’ll submit it later today.

    For now, I’ll just provide a set of steps to reproduce the error:

    1. Install woocommerce

    2. (in Woocommerce/settings/payments) Enable “Direct bank transfer”

    3. Create 2 test orders (any status that is previous to the completed status will work)

    4. Go to order 1 from woocommerce/orders/Order #1 details

    5. Change the order status to completed (and press update) 6. Go back to woocommerce/orders and identify order 2

    7. In the orders table there should be a column named Actions if you dont see it that means it is hidden (top right corner “screen options”->check “actions”)

    8. Once you identified the actions column press on the button that says complete when hovering over it (for order 2).

    9. Now we have 2 orders that are completed. If we go to phpmyadmin one order will have “paid date” completed and one will not.
    Either both should have it or both should not.

    Hopefully, this is more clear now.

    Thank you!

    • This reply was modified 1 year, 5 months ago by tccand.
    Thread Starter tccand

    (@tccand)

    Hello,

    I’ll mark this as resolved.

    From what I understand Woocommerce is rounding to 4 decimals.
    I did some tests and I think that just changing the number of decimals to 4 will solve my problem.

    Spending more time on the other problems is probably not worth it.

    Thank you for your help!

Viewing 15 replies - 1 through 15 (of 15 total)