WooCommerce Products Listed as $619,645,220.00

  • Resolved nathandonnelly

    (@nathandonnelly)


    2 years, 10 months ago

    Hello,

    I’ve recently come across something strange.

    I have setup a few WooCommerce stores and imported some products using both the default importer and WP All Import. Occasionally on importing, or at least once I go in and manually update a product, the product once updated shows a price of $619,645,220.00.

    If I view the product’s admin page or in quick edit, it shows the correct price, but in the dashboard for all products and on the front end it shows 619MM as the price.

    I’ve tried this on a couple fresh local instances of WordPress. I’ve deactivated all plugins. It keeps happening.

    The plugins currently on my live site include:
    – ACF REST Query
    – Advanced Custom Fields
    – Custom Post Type UI
    – Easy Woo3D
    – Material Design
    – Max Mega Menu
    – NinjaFirewall
    – Password Protected
    – WooCommerce
    – WP All Import
    – WP All Import – WooCommerce Add-On
    – WP API REST Filter Parameter

    But this error occurred after deactivation of all plugins except Advanced Custom Fields and WooCommerce.

    Curious if there’s a known bug, or why this bug could possibly be affecting the site after plugins have been deactivated. Regular price appears properly if I hit the WooCommerce API, but price appears as 619645220.

    
        "sku": "5c190ed977c0a3389891c349",
        "price": "619645220",
        "regular_price": "84.75",
        "sale_price": "",

    Thanks

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

  • @nathandonnelly

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

    Thread Starter nathandonnelly

    (@nathandonnelly)

    
### WordPress Environment ###

WordPress address (URL): I'd prefer not to share this.
Site address (URL): I'd prefer not to share this.
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.8.3 - There is a newer version of WordPress available (5.9)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4
PHP Version: 7.4.13
PHP Post Max Size: 10 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.64.0
OpenSSL/1.1.1g

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.41-MariaDB-0+deb10u2
Max Upload Size: 10 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: 23.30MB
Database Data Size: 14.32MB
Database Index Size: 8.98MB
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.05MB + 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: 3.30MB + Index: 0.23MB + 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.25MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 6.52MB + Index: 6.03MB + Engine InnoDB
wp_posts: Data: 2.52MB + Index: 0.58MB + 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.23MB + Index: 0.20MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + 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.02MB + Index: 0.03MB + 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.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_meta_lookup: Data: 0.41MB + Index: 0.77MB + 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 ###

acf-field: 10
acf-field-group: 2
attachment: 1292
custom_css: 1
customize_changeset: 40
nav_menu_item: 28
page: 15
post: 6
product: 1277
revision: 82

### Security ###

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

### Active Plugins (11) ###

ACF REST Query: by Scott Smith – 1.0
Advanced Custom Fields: by Delicious Brains – 5.11.4
Custom Post Type UI: by WebDevStudios – 1.10.1
Material Design: by Material Design – 0.5.1
Max Mega Menu: by megamenu.com – 2.9.5
NinjaFirewall (WP Edition): by The Ninja Technologies Network – 4.4.3
Password Protected: by Ben Huson – 2.5
WP REST API filter parameter: by WP REST API Team – 0.1
White Label CMS: by www.videousermanuals.com – 2.2.6
GLB Support: by Sergey Burkov
Customized by Cadsoft. – 1.5.7.9

WooCommerce: by Automattic – 6.1.1

### Inactive Plugins (2) ###

WP All Import: by Soflyy – 3.6.5
WP All Import - WooCommerce Add-On: by Soflyy – 1.5.1

### Must Use Plugins (1) ###

0-ninjafirewall.php: by The Ninja Technologies Network – 1.0

### Settings ###

API Enabled: ?
Force SSL: –
Currency: CAD ($)
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 ###

Shop base: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #3 - /privacy-policy/

### Theme ###

Name: The Demo Store
Version: 1.0.0
Author URL: https://cadsoft.com
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 3.9.1
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: thedemostore/woocommerce/archive-product.php
thedemostore/woocommerce/content-single-product.php

### Action Scheduler ###

Complete: 67
Oldest: 2022-01-20 10:51:51 -0500
Newest: 2022-01-25 15:01:22 -0500

### Status report information ###

Generated at: 2022-01-25 16:46:01 -05:00
    Thread Starter nathandonnelly

    (@nathandonnelly)

    Here is another for one of the local sites.

    
### WordPress Environment ###

WordPress address (URL): https://tds.local
Site address (URL): https://tds.local
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.8.3 - There is a newer version of WordPress available (5.9)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.43 (Win32)
PHP Version: 8.0.0
PHP Post Max Size: 1,000 MB
PHP Time Limit: 1200
PHP Max Input Vars: 4000
cURL Version: 7.73.0
OpenSSL/1.1.1h

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.10-MariaDB
Max Upload Size: 300 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: 6.33MB
Database Data Size: 4.64MB
Database Index Size: 1.69MB
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.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.06MB + 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_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_postid: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 2.05MB + Index: 0.06MB + 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: 0.31MB + Index: 0.23MB + Engine InnoDB
wp_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_smackcsv_file_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smackuci_events: Data: 0.02MB + Index: 0.00MB + 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_ultimate_csv_importer_acf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_mappingtemplate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_shortcode_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_post_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 1.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + 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.02MB + Index: 0.03MB + 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.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_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 ###

acf-field: 9
acf-field-group: 2
attachment: 61
page: 7
post: 2
product: 60
revision: 1

### Security ###

Secure connection (HTTPS): ?
					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ?

### Active Plugins (7) ###

ACF to REST API: by Aires Gon?alves – 3.3.2
Advanced Custom Fields: by Delicious Brains – 5.11.4
Custom Post Type UI: by WebDevStudios – 1.10.1
WP All Import - WooCommerce Add-On: by Soflyy – 1.5.1
WooCommerce: by Automattic – 6.1.1
WP All Import: by Soflyy – 3.6.5
WP All Import - ACF Add-On: by Soflyy – 3.3.6

### Inactive Plugins (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: –

### 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: The Demo Store
Version: 1.0.0
Author URL: https://nathandonnelly.com
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 3.9.1
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 9
Oldest: 2022-01-21 17:20:20 +0000
Newest: 2022-01-25 21:50:07 +0000

### Status report information ###

Generated at: 2022-01-25 21:52:14 +00:00

    Hi there,

    Thanks for sharing the System Status Report.

    WP Version: ? 5.8.3 – There is a newer version of WordPress available (5.9)

    As a first step please update your WordPress version. Then please try again to check if the issue persists.

    Regarding the price of $619,645,220.00 this is pretty strange, may I ask was the data imported from another website that was using a different decimal separator? What was the real price of the item before the issue was present?

    Please let us know.

    Thread Starter nathandonnelly

    (@nathandonnelly)

    The real price of this item is listed in the previous comment in the regular price field in the API response. The regular prices however listed do not affect the price showing up. All prices show up as the same number. This is the case for over 1000 products that were imported with different prices.

    Also, this update of WordPress was literally pushed a few hours ago so I doubt it’s a flag for concern… but I did update and nothing changed.

    The items were imported from a local csv. I’ve tried formatting as regular text, formatting as currency, using only whole numbers without the decimal, etc. I’ve also done a “preview” of the import on both methods which have shown the price listed appropriately. The price always gets updated to 619MM.

    Hi there,

    All prices show up as the same number…
    …The items were imported from a local csv

    Is possible the CSV was not formatted correctly?

    Can you please provide a copy or link to the file (only having “One” item) so that we can test it? (Of course, you can edit any sensitive info before submitting).

    Let us know, thanks.

    Thread Starter nathandonnelly

    (@nathandonnelly)

    I thought of that and tried multiple different formatting options. Like I said, the preview window showed up perfectly every time.

    Attached are some samples though, and if you could please let me know for future reference what formatting method is preferred. All the prices were generated with the equivalent of Math.floor(Math.random * 980 + 10).toFixed(2) in an excel sheet then exported to csv where I confirmed the cells were actually populated with floating point numbers at two decimals and not the formula.

    Example One

    Example Two

    Example Three

    Example Four

    Luminus Alabi

    (@luminus)

    Automattic Happiness Engineer

    Hi @nathandonnelly,

    I can’t access any of these links.

    I’d recommend putting the files in Dropbox or Google Drive and sending those links over.

    Thread Starter nathandonnelly

    (@nathandonnelly)

    Hmm. They’re download links so they should’ve just automatically downloaded – but if you’re using something like HTTPS Everywhere, then yeah, there would’ve been some warnings.

    Anyway, I’ve uploaded the files here

    Hello,

    I’ve re-read, and I could download the CSV using another browser, thanks for sharing this information.


    Link to image: https://snipboard.io/iyKhJE.jpg

    I could import all files, also the prices are showing correctly on my testing site, except for the second example which did not have a price.

    Please be sure you are not using MS Excel (if it is the case, is possible it is changing the format) use Google Suite instead. Paste the data in Google Suite, export it as a CSV, then import that file into WooCommerce.

    Let us know how it goes ??

    Thread Starter nathandonnelly

    (@nathandonnelly)

    Which CSV did you use?

    I’ve tried overwriting products with imports twice now with exported copies from Google Sheets and the Price field has not updated.

    Price field is formatted in Google sheets as “Accounting.”

    For the import to overwrite product data, I just matched SKU and Price, so no other data on the products changed.

    Image attached here, and you can see the formatting of the price in the top bar. Again, prices come in ok, but then once I hit update, the prices change – and in this case, my assumption that the 6MM price would be overwritten with the price specified in the import field, but it was not.

    Thanks

    Hi there,

    Which CSV did you use?

    All of them, the 4 you linked in a previous response, one by one each time. And without any specific format for the price.

    You can perform a conflict test just in case there is a conflict with another plugin affecting the importing process. Please do the following actions:

    * Temporarily switch your theme to Storefront

    * You can find a more detailed explanation on how to do a conflict test here.

    I hope this leads you in the right direction.

    Thread Starter nathandonnelly

    (@nathandonnelly)

    Hi @ihereira

    I don’t know if I mentioned it earlier but I already did a conflict test, but I have just completed a more in-depth one. Here are the results.

    I was previously using the official child theme of Storefront (downloaded from recommended repository on GitHub) with only one function added to bump up the API response limit. I still changed my theme to Storefront though.

    I deactivated all plugins besides WooCommerce. I even deactivated and reactivated WooCommerce after deactivating everything.

    In between every deactivation of the plugins one-by-one, I updated a product just to see if the price would be overwritten with the correct value. Nothing.

    So I had Storefront as the active theme with no plugins besides WooCommerce active and products are still listed as $619,645,220.00 while the regular price listed remains intact.

    So I started reactivating plugins, and updating product in between.

    It appears that the issue is with the plugin Advanced Custom Fields.

    It’s strange though that after the plugin was deactivated, if I updated a product that had the price listed as $619,645,220.00, it wouldn’t go back to it’s regular price.

    I had a feeling that this was occurring because I had “price” specified as a custom field, so I spun up a brand new instance of WordPress, installed and activated WooCommerce, imported a product from the sample CSV, installed ACF, added one custom field for price to show on products, navigated to the product, added the price equal to the value of regular price listed during the product import of the csv file, updated, and the price was now showing on the front end as “$6,181,006,387.00.”

    I then deleted that field and the product, re-uploaded the product with a separate custom field labeled ID (which I’m using to hold the value of the product SKU – just to double check if it is a major bug in the plugin), no problems there.

    So I recreated the price field as “catalog_price”, entered in a price, updated, and no problems. So I changed the field label to “price”, while keeping the name of the field “catalog_price”, again no problems. So I switched it, making the field label “catalog_price” and the name “price”, went back and updated the product, and the listed price became “$6,181,366,289.00”.

    Deleted the product, change the field value of price from a number to text. Re-imported the product. Updated the product with the ACF field price to the value of the regular price of the product, and the listed price again became “$6,181,366,289.00.”

    Then I thought, okay, since it doesn’t matter if it’s a number or text, maybe it’s not ACF. Maybe it’s all meta boxes with the field name “price.”

    So I deleted that whole instance of WordPress, and spun up a new one. Installed and activated WooCommerce and the plugin Meta Box. That didn’t appear in the dashboard so there’s maybe a bigger issue with that plugin – not worth my time right now though so I deleted that and installed Pods.

    Created the same custom field or “pod”, with the name price, value of a number, etc., imported the product, updated the pod field “price” with the value of the item and there appears to be no conflict.

    So we have our bug. You can’t create an ACF field with the field name equal to “price” associated with a WooCommerce product.

    I can work around this, and I’ll refer the developers of the plugin to this thread so that they can work it out on their end.

    Mirko P.

    (@rainfallnixfig)

    Hi @nathandonnelly,

    I can work around this, and I’ll refer the developers of the plugin to this thread so that they can work it out on their end.

    Thank you for sharing with us the steps you’ve taken and all information about your tests. It appears to be something related to your ACF plugin and its developers are best placed to check the issue further and provide a solution for you.

    I’m going to close this thread now as the issue is not specifically related to WooCommerce core itself. Feel free to start a new thread if you have any more questions.

    Cheers.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘WooCommerce Products Listed as $619,645,220.00’ is closed to new replies.