Closed adinighter closed 3 years ago
same here! On email/web, quantity is ok, but not in the app. Now we are verifying all 3 to make sure and not to send wrong items. Happens on 6.3 too
### WordPress Environment ###
WC Version: 5.2.0
REST API Version: ✔ 5.2.0
WC Blocks Version: ✔ 4.7.1
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 2.1.5
Log Directory Writable: ✔
WP Version: 5.7
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: es_AR
External object cache: –
### Server Environment ###
Server Info: Apache
PHP Version: 7.4.16
PHP Post Max Size: 20 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.64.0
OpenSSL/1.1.1d
SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.9-MariaDB-1:10.5.9+maria~buster
Max Upload Size: 20 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
### Database ###
WC Database Version: 5.2.0
WC Database Prefix: wp_
Tamaño total de la base de datos: 9.41MB
Tamaño de los datos de la base de datos: 7.14MB
Tamaño del índice de la base de datos: 2.27MB
wp_woocommerce_sessions: Datos: 0.05MB + Índice: 0.02MB + Motor InnoDB
wp_woocommerce_api_keys: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB
wp_woocommerce_order_items: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Datos: 0.14MB + Índice: 0.14MB + Motor InnoDB
wp_woocommerce_tax_rates: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zones: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
wp_woocommerce_payment_tokens: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_woocommerce_log: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_actionscheduler_actions: Datos: 0.05MB + Índice: 0.11MB + Motor InnoDB
wp_actionscheduler_claims: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_actionscheduler_groups: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_actionscheduler_logs: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_commentmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_comments: Datos: 0.06MB + Índice: 0.09MB + Motor InnoDB
wp_links: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_litespeed_img_optm: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_litespeed_optimizer: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_options: Datos: 4.09MB + Índice: 0.14MB + Motor InnoDB
wp_postmeta: Datos: 1.50MB + Índice: 0.45MB + Motor InnoDB
wp_posts: Datos: 0.25MB + Índice: 0.09MB + Motor InnoDB
wp_smush_dir_images: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_termmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_terms: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_term_relationships: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_term_taxonomy: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_usermeta: Datos: 0.19MB + Índice: 0.16MB + Motor InnoDB
wp_users: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB
wp_wc_admin_notes: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
wp_wc_admin_note_actions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_wc_category_lookup: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
wp_wc_customer_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_wc_download_log: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_wc_order_coupon_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_wc_order_product_lookup: Datos: 0.05MB + Índice: 0.06MB + Motor InnoDB
wp_wc_order_stats: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB
wp_wc_order_tax_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
wp_wc_product_meta_lookup: Datos: 0.02MB + Índice: 0.09MB + Motor InnoDB
wp_wc_reserved_stock: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
wp_wc_tax_rate_classes: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_wc_webhooks: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
wp_wpforms_tasks_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
### Post Type Counts ###
attachment: 118
custom_css: 2
custom-css-js: 1
nav_menu_item: 6
page: 7
post: 1
product: 19
product_variation: 61
revision: 143
shop_order: 73
wp_block: 1
### Security ###
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
### Active Plugins (7) ###
Header and Footer Scripts: por Digital Liberation – 2.2.1
Jetpack por WordPress.com: por Automattic – 9.6.1
LiteSpeed Cache: por LiteSpeed Technologies – 3.6.4
WooCommerce: por Automattic – 5.2.0
WP Mail SMTP: por WPForms – 2.7.0
Smush: por WPMU DEV – 3.8.4
WPForms Lite: por WPForms – 1.6.6
### Inactive Plugins (0) ###
### Dropin Plugins (1) ###
advanced-cache.php: advanced-cache.php
### Settings ###
API Enabled: –
Force SSL: –
Currency: ARS ($)
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: –
### WC Pages ###
Casa matriz de la tienda: #8 - /
Carrito: #9 - /carrito/
Finalizar compra: #10 - /finalizar-compra/
Mi cuenta: #11 - /mi-cuenta/
Términos y condiciones: ❌ Página no definida
### Theme ###
Name: Freely
Version: 1.0.1
Author URL: https://wpzita.com/
Child Theme: ✔
Parent Theme Name: Zita
Parent Theme Version: 1.5.0
Parent Theme Author URL:
WooCommerce Support: ✔
### Templates ###
Archive Template: Tu tema tiene un archivo woocommerce.php
no podrás sobreescribir la plantilla personalizada woocommerce/archive-product.php ya que woocommerce.php tiene prioridad sobre archive-product.php. Esto es intencionado para prevenir problemas de visualización.
Overrides: –
### Action Scheduler ###
Completar: 65
Oldest: 2021-04-06 02:47:50 +0000
Newest: 2021-04-13 14:59:05 +0000
Pendiente: 4
Oldest: 2021-04-14 11:34:04 +0000
Newest: 2021-04-19 11:27:26 +0000
### Status report information ###
Generated at: 2021-04-13 23:06:28 -03:00
`
Proof on Android app (6.4.1 now)
Hi there @estebancano-dev and @adinighter!
Thank you for reporting this issue! We are as such unable to reproduce the same issue and would appreciate some details from your end. Looks like https://wpzita.com/ is the store url you are facing issue with? Would you be able to confirm that? That would be helpful in debugging what could be causing this issue.
Yeah, I cannot reproduce it too. Im using jetpack and "Freely" theme. I have nothing to do with wpzita.com. If you need to, I can send you a backup of some tables to make some tests, maybe you can connect it to android app and see whats going on. Don't know how to help you On woocommerce it looks like this (maths are good there):
Im looking at the tables. Order id is 2269.
Searching at
SELECT * FROM wp_woocommerce_order_items where order_id=2269
gives
and SELECT * FROM wp_woocommerce_order_itemmeta where order_item_id in (330,331,332)
gives
So, quantity on db seems right, that's why on email and web the order is ok (2 items and 1 item).
So, it's definetly something on the app that is not using _qty correctly?
I tried changing _qty 1 for 15 (meta_id 2864), and this happens!
And if I change quantity on the other products (2 for 15, meta_id 2853), it looks like this:
Its super weird the maths it's doing, the bigger the value, the total for the first product decreases. If I put _qty=50 (meta_id 2853), total price goes to $48.
If you need me to query some variations or products just ask, but I hope this helps you to find the bug that is there! Cheers
@designsimply @anitaa1990 any comments? Do you need aditional info to be able to reproduce it ?
I was unable to reproduce the problem using the following testing steps:
Result: I could see the correct quantity for the order on the web and in the app.
Tested with WCAndroid 6.8-rc-1 on Pixel 3 Android 11.
@estebancano-dev I saw the database info in your system status report says this:
MySQL Version: 5.5.5-10.5.9-MariaDB-1:10.5.9+maria~buster
The WordPress minimum requirements mention that you need MySQL version 5.6 or greater OR MariaDB version 10.1 or greater—do you think that could be the source of the problem in your case?
My MySQL version is 10.5.9, so that's for sure not the issue. Can I send you some dump of tables you need so you can continue testing it? Or maybe related registers of that order
Hey @estebancano-dev would you be able to send us the url for your store so we can test why this is happening? We're unable to reproduce this issue from our own stores.
@anitaa1990 Sent you an email
Thank you for the details @estebancano-dev! We found that the issue was indeed with the app and have opened a PR in #4193 with a fix. It should be released into beta within the next few hours. Thank you for taking the time to debug the problem and share all the details that helped us in fixing it 😄
Wow amazing, glad I was able to contribute to fix the issue!!
Describe the bug This bug does not happen all the time, it has happened to me twice so far (within a month). When a product variation is purchased with an amount of more than 1, in the mobile app only 1 is shown as the quantity. (as you can see in screenshots).
Screenshots
Expected behavior show the right quantity of the item that has been purchased.
Isolating the problem (mark completed items with an [x]):
Mobile Environment Please include:
WordPress Environment