Wholesale Price Not displaying decimal values

Hi @hgomesc,

It Would be great if you could send me all the information from the WooCommerce->System Status page. There’s a little button there that will let you copy and paste it to me:

https://snipboard.io/eOc7jD.jpg

Hello! Here it goes

### WordPress Environment ###

WordPress address (URL): https://fribeirolda.com
Site address (URL): https://fribeirolda.com
WC Version: 5.0.0
REST API Version: ? 5.0.0
WC Blocks Version: ? 4.0.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.9.0
Log Directory Writable: ?
WP Version: 5.6.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: pt_PT
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.15
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 5000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.36-MariaDB-cll-lve
Max Upload Size: 8 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.0.0
WC Database Prefix: wpga_
Tamanho total da base de dados: 4.11MB
Tamanho dos dados da base de dados: 3.67MB
Tamanho do índice da base de dados: 0.44MB
wpga_woocommerce_sessions: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_api_keys: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_attribute_taxonomies: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_downloadable_product_permissions: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_order_items: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_order_itemmeta: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_tax_rates: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_tax_rate_locations: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_shipping_zones: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_shipping_zone_locations: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_shipping_zone_methods: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_payment_tokens: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_payment_tokenmeta: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_woocommerce_log: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_actionscheduler_actions: Dados: 0.03MB + índice: 0.03MB + Engine MyISAM
wpga_actionscheduler_claims: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_actionscheduler_groups: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_actionscheduler_logs: Dados: 0.02MB + índice: 0.02MB + Engine MyISAM
wpga_commentmeta: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_comments: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_links: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_loginizer_logs: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_ms_snippets: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_options: Dados: 1.84MB + índice: 0.07MB + Engine MyISAM
wpga_postmeta: Dados: 1.40MB + índice: 0.14MB + Engine MyISAM
wpga_posts: Dados: 0.36MB + índice: 0.04MB + Engine MyISAM
wpga_snippets: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_termmeta: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_terms: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_term_relationships: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_term_taxonomy: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_usermeta: Dados: 0.01MB + índice: 0.01MB + Engine MyISAM
wpga_users: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_user_registration_sessions: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_admin_notes: Dados: 0.01MB + índice: 0.00MB + Engine MyISAM
wpga_wc_admin_note_actions: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_category_lookup: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_customer_lookup: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_wc_download_log: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_order_coupon_lookup: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_order_product_lookup: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_wc_order_stats: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_wc_order_tax_lookup: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_product_meta_lookup: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_wc_reserved_stock: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wc_tax_rate_classes: Dados: 0.00MB + índice: 0.01MB + Engine MyISAM
wpga_wc_webhooks: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wpforms_tasks_meta: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM
wpga_wpmailsmtp_tasks_meta: Dados: 0.00MB + índice: 0.00MB + Engine MyISAM

### Post Type Counts ###

attachment: 52
custom_css: 2
customize_changeset: 29
elementor_library: 1
iksm: 1
nav_menu_item: 7
oceanwp_library: 1
page: 15
post: 2
product: 38
product_variation: 24
revision: 154
seedprod: 1
shop_order: 2
user_registration: 2

### Security ###

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

### Active Plugins (21) ###

Iks Menu: por IksStudio – 1.9.0
Advanced noCaptcha & invisible Captcha: por Shamim Hasan – 6.1.5
AJAX Search for WooCommerce: por Damian Góra – 1.8.2
Code Snippets: por Code Snippets Pro – 2.14.0
Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: por SeedProd – 6.0.11.1
Cookie Notice & Compliance for GDPR / CCPA: por Hu-manity.co – 2.0.3
Delete Me: por Clinton Caldwell – 3.0
Elementor Pro: por Elementor.com – 3.1.0
Elementor: por Elementor.com – 3.1.2
Loco Translate: por Tim Whitlock – 2.5.1
Loginizer: por Softaculous – 1.6.6
NIF (Num. de Contribuinte Português) para WooCommerce: por Webdados – 4.2.4.2
Ocean Extra: por OceanWP – 1.7.3
Perfect Brands for WooCommerce: por QuadLayers – 1.8.6
User Registration: por WPEverest – 1.9.4.1
NP Quote Request WooCommerce: por Neah Plugins – 1.8.247
WooCommerce Wholesale Prices: por Rymera Web Co – 1.13.2
WooCommerce: por Automattic – 5.0.0
WP Mail SMTP: por WPForms – 2.6.0
WPForms Lite: por WPForms – 1.6.5
Custom Product Tabs for WooCommerce: por YIKES
Inc. – 1.7.6

### Inactive Plugins (0) ###

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
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 ###

Página da Loja: #796 - /loja/
Carrinho: #8 - /cart/
Finalizar compras: #9 - /checkout/
Minha conta: #10 - /minha-conta/
Termos e condi??es: ? Página n?o definida

### Theme ###

Name: OceanWP Child
Version: 1.0
Author URL: https://oceanwp.org/
Child Theme: ?
Parent Theme Name: OceanWP
Parent Theme Version: 2.0.2
Parent Theme Author URL: https://oceanwp.org/about-me/
WooCommerce Support: ?

### Templates ###

Overrides: oceanwp/woocommerce/cart/mini-cart.php
oceanwp/woocommerce/content-single-product.php
oceanwp/woocommerce/loop/loop-start.php
oceanwp/woocommerce/single-product/title.php

### Action Scheduler ###

Concluída: 110
Oldest: 2021-02-10 16:08:54 +0000
Newest: 2021-03-07 10:47:41 +0000

Pendente: 3
Oldest: 2021-03-08 10:47:41 +0000
Newest: 2021-03-10 10:54:43 +0000

Hi @hgomesc,

Could you please let me know how do you import the JSON? Do you use a third-party plugin?

Also, could you please provide me with the JSON file? You can send it over via wetransfer.com

We do this using a PHP program developed using the WooCommerce API. Unfortunately I will not be able to provide you the full code. I will give you the lines that import this information.

This is the line of the PHP
update_post_meta( $product_id , ‘wholesale_customer_wholesale_price’ , $produto[“wholesale”]);

(Also for variable products -> update_post_meta( $variationID , ‘wholesale_customer_wholesale_price’ , $produto[“wholesale”] ); //pre?o de revenda)

This is the information given in the JSON file:
“wholesale”: “49,50406”,

As you can see the information in the JSON goes with 2+ decimals. In the WooCommerce backoffice the product with the correspondent SKU if you open the product information has exactly 49,50406 on the wholesale price.
In the full list of products, on the column for wholesale price it is displaying only 49,00 and also in the front-office it displays 49,00

I still can’t understand this, as for the regular or sale price, the process is exactly the same, only the with a different line of code, and this works!

I solved it. As the number is going by default with 5 decimals on the JSON (being goods with gold and silver) and the woocommerce being limited normally to 2 decimals it did not occur to me that the plugin would not just see 5 decimals and assume only the first 2. If I change this to 2 decimals on the JSON, it is already displaying the correct value.

Sorry for the trouble and thanks @fauzanade

I am sorry to re-open this thread but I noticed that my problem is actually not solved.

I am sending information via de JSON with 2 decimals. Lets say 67,50€
The product is saving the correct information of 67,50€ but is displaying 67,00€

Only after I enter manually on the WooCommerce and go to the product, open it and update something the correct price of 67,50€ starts displaying.

I need to understand why this is happening and need to fix it. If you can please help me I would be very thankful.

Hi @hgomesc,

Could you please send us the JSON file via wetransfer.com? You can send the link to our support channel here: https://wholesalesuiteplugin.com/support/support-request-form/

We’ll continue our discussion there.