Price format correction

Hi there,

I understand why you’re considering using phpMyAdmin for this it can seem like a faster shortcut, especially with a large number of products. However, directly updating prices via phpMyAdmin is not recommended unless you’re very familiar with WooCommerce’s database structure.

WooCommerce stores product data across multiple tables (such as wp_posts, wp_postmeta, and for variations, additional relationships). Prices are saved in meta keys like _price, _regular_price, and _sale_price. Updating only one of these or missing variations can lead to inconsistent pricing, broken displays, or issues with caching and lookups.

Because of this, manual database edits can easily cause more problems than they solve.

A safer approach would be:

• Fix the CSV and re-import in smaller batches
• Or use a dedicated plugin like “Product CSV Import Suite for WooCommerce” or similar tools that handle updates more reliably.

Also, to assist you better, could you please clarify exactly what issue you’re currently facing with the import?

Have you tried re-importing in smaller batches? If yes, could you please provide more information about what issue or error you’re encountering?

Hi there,

Thank you for sharing the details that’s very helpful.

Since the import is stuck on “Your Products are now being Imported” for a long time, this usually indicates that the background processing is not completing correctly or is being blocked somewhere.

Could you please check the following: 1. Browser Console Errors

Open your browser console while the import is running:

• Press Ctrl + Shift + I
• Go to the Console tab
• Check if you see any errors or warnings during the import process

If you see any errors, please share them with us. 2. WooCommerce Logs

Please also check:
WooCommerce → Settings → Status → Logs

Look for any recent error logs related to product import or background processing and let us know if anything appears there. 3. Action Scheduler

Finally, please check if there are any stuck tasks:
WooCommerce → Status → Scheduled Actions

Look for any pending or failed actions related to product import or batch processing.

In the meantime, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

• System Status Report which you can find via WooCommerce > Status

Please use https://pastebin.com/ or https://gist.github.com/ and share a link to that paste in reply here. Once we have more information, we’ll be able to assist you further.

Hi there!

Thank you for sharing the errors. Those JavaScript errors indicate that some script on the WooCommerce product importer page is trying to interact with HTML elements that do not exist or are not loaded correctly.

The main error is this one:

Uncaught TypeError: can’t access property “parentNode”, afterTitle is null

This means a script expected an element called afterTitle to exist, but it returned null, so JavaScript failed when trying to access .parentNode.

Since this happens on:

/wp-admin/edit.php?post_type=product&page=product_importer

it is most likely related to:

• A plugin modifying the WooCommerce importer page
• Custom admin JavaScript
• An admin optimization/minification plugin
• A compatibility issue with WordPress 6.9.4 or WooCommerce version in use

The second error:

Uncaught TypeError: can’t access property “hasClass”, h is undefined

comes from:

/wp-includes/js/wp-auth-check.min.js

This is usually a secondary error caused by another script conflict or broken admin page DOM structure.

You also mentioned this scheduled action:

MailChimp_WooCommerce_Single_Product_Variation Pending

That itself is usually not fatal, but the Mailchimp for WooCommerce plugin has previously caused admin/importer conflicts on some sites, especially during product imports or large catalog syncs.

To assist you further, could you please run a conflict test by deactivating all plugins except WooCommerce, activating a default theme like Twenty Twenty-Five, and then trying to import the products again?

I would suggest running this test on a staging site so your live site remains unaffected. You can use your hosting provider’s built-in staging tool if available, or you can use the following plugin:

https://ww.wp.xz.cn/plugins/wp-staging/

For more details on how to run a conflict test, please refer to this guide:

https://woocommerce.com/document/how-to-test-for-conflicts/

Let us know what you find.