Product Import / Update Not Working

Hi Andy ??

That’s strange. I can see that you mention that you are using the same .CSV file schema for the past 18 months and this is the first time that it failed, so it sounds like there is a conflict or an internal issue happening on your site.

As a first step, please share the following WooCommerce logs in order to troubleshoot this issue further:

• System Status: found under WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
• Error log: found under WooCommerce > System Status > Logs

Thank you ??

### WordPress Environment ###

WordPress address (URL): https://www.hvac-sanitary.co.uk
Site address (URL): https://www.hvac-sanitary.co.uk
WC Version: 5.4.1
REST API Version: ? 5.4.1
WC Blocks Version: ? 5.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.3.1
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 4 GB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.19
PHP Post Max Size: 128 MB
PHP Time Limit: 30
PHP Max Input Vars: 3000
cURL Version: 7.77.0
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.30-MariaDB
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.4.1
WC Database Prefix: wp_
Total Database Size: 1971.88MB
Database Data Size: 1297.98MB
Database Index Size: 673.90MB
wp_woocommerce_sessions: Data: 3.93MB + Index: 0.08MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.09MB + Index: 0.05MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.57MB + Index: 0.40MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wolseley_categories: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wolseley_manufacturers: Data: 0.08MB + Index: 0.10MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.06MB + Index: 0.04MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine MyISAM
wp_aws_cache: Data: 0.89MB + Index: 0.00MB + Engine MyISAM
wp_aws_index: Data: 567.24MB + Index: 282.72MB + Engine MyISAM
wp_check_email_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wp_comments: Data: 0.50MB + Index: 0.21MB + Engine MyISAM
wp_csp3_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 42.16MB + Index: 5.50MB + Engine MyISAM
wp_postmeta: Data: 389.11MB + Index: 244.51MB + Engine MyISAM
wp_posts: Data: 166.32MB + Index: 43.13MB + Engine MyISAM
wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_terms: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
wp_term_relationships: Data: 14.91MB + Index: 32.51MB + Engine MyISAM
wp_term_taxonomy: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wp_usermeta: Data: 0.46MB + Index: 0.02MB + Engine MyISAM
wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.04MB + Index: 0.04MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
wp_wc_order_stats: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 24.02MB + Index: 37.28MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wdp_orders: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wp_wdp_order_items: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_wdp_product_collections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wdp_rules: Data: 0.17MB + Index: 0.01MB + Engine MyISAM
wp_yoast_indexable: Data: 85.42MB + Index: 25.52MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wp_yoast_seo_meta: Data: 1.62MB + Index: 1.40MB + Engine MyISAM

### Post Type Counts ###

attachment: 14552
nav_menu_item: 14
page: 45
product: 345315
revision: 62
seedprod: 2
shop_order: 547
shop_order_refund: 143

### Security ###

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

### Active Plugins (13) ###

Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 3.2.5
Advanced Woo Search: by ILLID – 2.30
The SEO Framework: by The SEO Framework Team – 4.1.3
Autoptimize: by Frank Goossens (futtta) – 2.8.4
Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: by SeedProd – 6.2.5
Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.1.2
GA Google Analytics: by Jeff Starr – 20210211
Really Simple SSL: by Really Simple Plugins – 4.0.15
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.16.58.25

WooCommerce Brands: by WooCommerce – 1.6.25
WooCommerce PayPal Pro Hosted: by WooCommerce – 1.0.23
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.41
WooCommerce: by Automattic – 5.4.1

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
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)
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/
Basket: #7 - /basket/
Checkout: #8 - /checkout/
My account: ? Page visibility should be public
Terms and conditions: #68 - /about-us/terms-and-conditions/

### Theme ###

Name: HVAC
Version: 1.0
Author URL: 
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 3.7.0
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: hvac/woocommerce/single-product/product-image.php

### Action Scheduler ###

Complete: 247
Oldest: 2021-06-01 18:41:51 +0100
Newest: 2021-07-02 12:54:53 +0100

### Status report information ###

Generated at: 2021-07-02 14:37:56 +01:00

Thank you!

As you are using the WooCommerce Product CSV Import Suite plugin (Premium Extension), please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Cheers ??

This is all I can find:

2021-07-01T11:54:01+00:00 CRITICAL Maximum execution time of 30 seconds exceeded in /home/hvacsanitaryco/public_html/wp-content/plugins/advanced-dynamic-pricing-for-woocommerce/BaseVersion/Includes/External/WC/WcProductCustomAttributesCache.php on line 82

2021-07-01T19:18:14+00:00 CRITICAL Maximum execution time of 30 seconds exceeded in /home/hvacsanitaryco/public_html/wp-content/plugins/advanced-dynamic-pricing-for-woocommerce/BaseVersion/Includes/External/WC/WcProductCustomAttributesCache.php on line 82

2021-07-01T23:44:48+00:00 CRITICAL Maximum execution time of 30 seconds exceeded in /home/hvacsanitaryco/public_html/wp-content/plugins/advanced-dynamic-pricing-for-woocommerce/BaseVersion/Includes/External/WC/WcProductCustomAttributesCache.php on line 82

Disabling the ADP plugin and a batch of 10 completes. I believe both Woo and ADP have been updated in the last month so I don’t know how to trace the problem.

Thanks in advance for your help.

Cheers,

Andy

I can never find my way back to the support threads on your site.

Here is the request reference that I first mention the problem:

Your request (3706728) has been updated.

Most of the thread is in relation to the bug in the CSV Import Suite that spawns Scheduled Actions crippling the site.

It may also mention the bug in the CSV Import Suite that fails to update the Last_Modified and Last_Modified_GMT fields when a product is updated.

Cheers,

Andy

Thank you for the error log, Andy!

2021-07-01T11:54:01+00:00 CRITICAL Maximum execution time of 30 seconds exceeded in /home/hvacsanitaryco/public_html/wp-content/plugins/advanced-dynamic-pricing-for-woocommerce/BaseVersion/Includes/External/WC/WcProductCustomAttributesCache.php on line 82

Basically, what this error means is that your site requires more time to execute processes than the default execution time provided by your server.

To solve this, you will need to ask your web hosting provider to increase the max_execution_time PHP value for you.

Also, you can follow the steps from the guide below in order to fix that issue:

https://kinsta.com/blog/wordpress-max-execution-time/

Let me know how it goes ?? !

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Hi,

Yes, nothing to do with the server.

Problem is with a recently updated plugin. The author is working on rolling out a fix.

Cheers for looking into this.

FYI, there is an issue with the Import/Update routine in that it will finish but miss the last few lines.

For instance:

Update 5,000 prices and it will skip the last 80.

Update 10,000 prices and it will the last 160 or so lines.

Nothing wrong with the lines the run through separately.

I have reported this but it’s been ignored.

Run the same 10,000 records through the csv import suite and it finishes fine. That is except for the import suite bug that spawns 10,000 scheduled actions crippling the site for 6 days.

Hey ho. One day…

??

Cheers,

Andy

Hey Andy! ??

Thank you very much for the heads up!

Oh wow, what an issue, but no worries, hopefully, the developer will patch it really soon! ??

Please, if you have any other questions related to the WooCommerce Core plugin, please feel free to open a new topic about it. We’ll be more than happy to help you out!

Have a great weekend!