Import product is slow

https://www.ads-software.com/support/topic/woocommerce-product-import-is-slow-how-to-speed-it-up/

I have seen this post from two years ago and I have already checked:

1. The format in which I am uploading the information is correct.
2. The columns meet the data requirements.
3. The maximum file size is not exceeded.
4. Here is a copy of my System Status.

System Status Report

<details><summary>System Status Report</summary>

<br>### WordPress Environment ###<br><br>WordPress address (URL): [Redacted]<br>Site address (URL): [Redacted]<br>WC Version: 9.1.2<br>Legacy REST API Package Version: El plugin Legacy REST API no está instalado en este sitio.<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.6.1<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: es_ES<br>External object cache: –<br><br>### Server Environment ###<br><br>Server Info: Apache<br>PHP Version: 7.4.33<br>PHP Post Max Size: 1 GB<br>PHP Time Limit: 180<br>PHP Max Input Vars: 5000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.6.18-MariaDB-cll-lve<br>Max Upload Size: 32 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ?<br><br>### Database ###<br><br>[REDACTED]<br><br>### Post Type Counts ###<br><br>attachment: 3958<br>custom_css: 1<br>nav_menu_item: 177<br>page: 15<br>post: 2<br>product: 3652<br>productsliderwoo: 2<br>revision: 1126<br>shop_order: 1246<br>shop_order_refund: 10<br>template: 1<br>testimonial: 3<br>vc4_templates: 2<br>wp_global_styles: 1<br>wp_navigation: 1<br>wpcf7_contact_form: 2<br><br>### Security ###<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ?<br><br>### Active Plugins (24) ###<br><br>LayerSlider: por Kreatura Media – 7.10.1<br>All in One SEO: por All in One SEO Team – 4.6.7.1<br>All-in-One WP Migration: por ServMask – 7.84<br>chat-me-now: por Frank Ortiz – 1.0.2<br>Editor clásico: por Colaboradores de WordPress – 1.6.4<br>Contact Form 7: por Takayuki Miyoshi – 5.9.8<br>Departamentos y ciudades de Colombia para WooCommerce: por Saul Morales Pacheco – 2.0.18<br>ePayco WooCommerce: por ePayco – 3.5.4<br>Flexible Checkout Fields: por WP Desk – 4.1.11<br>Force Regenerate Thumbnails: por Exactly WWW – 2.1.4<br>WPBakery Page Builder: por Michael M - WPBakery.com – 7.5<br>Loginizer: por Softaculous – 1.9.0<br>Max Mega Menu - Pro Addon: por megamenu.com – 2.1.1<br>Max Mega Menu: por megamenu.com – 3.3.2<br>Under Construction: por WebFactory Ltd – 4.01<br>Advanced Order Export For WooCommerce: por AlgolPlus – 3.5.3<br>WooCommerce Product Image Gallery Options: por Create and Code – 1.1.0<br>Customizer for WooCommerce: por SkyVerge – 2.8.0<br>WooCommerce Shipping & Tax: por WooCommerce – 2.7.0<br>WooCommerce: por Automattic – 9.1.2 (la actualización a la versión 9.1.4 está disponible)<br>'WooInstant - WooCommerce' Instantáneo / pago de una página: por BootPeople<br> – 2.0.19<br>WP Rollback: por WP Rollback – 2.0.7<br>WP Super Cache: por Automattic – 1.12.0<br>YITH WooCommerce Brands Add-on Premium: por YITH – 1.3.10<br><br>### Inactive Plugins (0) ###<br><br><br>### Dropin Plugins () ###<br><br>advanced-cache.php: advanced-cache.php<br>maintenance.php: maintenance.php<br><br>### Settings ###<br><br>API Enabled: –<br>Force SSL: –<br>Currency: COP ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 0<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: –<br><br>### Logging ###<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 días<br>Level threshold: –<br>Log directory size: 22 KB<br><br>### WC Pages ###<br><br>Base de la tienda: #6 - /tienda/<br>Carrito: #7 - /carrito/ -  Contiene el shortcode [woocommerce_cart]<br>Finalizar compra: #8 - /finalizar-compra/ -  Contiene el shortcode [woocommerce_checkout]<br>Mi cuenta: #9 - /mi-cuenta/<br>Términos y condiciones: #173 - /privacy-policy/<br><br>### Theme ###<br><br>Name: Betheme<br>Version: 27.3.9<br>Author URL: https://muffingroup.com/<br>Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente<br>te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo<br><br>WooCommerce Support: ?<br><br>### Templates ###<br><br>Archive Template: Tu tema tiene un archivo woocommerce.php<br>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.<br><br>Overrides: La  version 3.4.0 de betheme/woocommerce/archive-product.php está obsoleta. La versión del núcleo es la 8.6.0<br>betheme/woocommerce/cart/cart-totals.php<br>betheme/woocommerce/cart/cart.php<br>betheme/woocommerce/cart/cross-sells.php<br>betheme/woocommerce/cart/mini-cart.php<br>betheme/woocommerce/checkout/form-checkout.php<br>betheme/woocommerce/content-product.php<br>betheme/woocommerce/content-single-product.php<br>betheme/woocommerce/global/form-login.php<br>betheme/woocommerce/loop/loop-end.php<br>betheme/woocommerce/loop/loop-start.php<br>betheme/woocommerce/loop/no-products-found.php<br>betheme/woocommerce/loop/pagination.php<br>betheme/woocommerce/myaccount/downloads.php<br>betheme/woocommerce/notices/error.php<br>betheme/woocommerce/notices/success.php<br>betheme/woocommerce/single-product/add-to-cart/external.php<br>betheme/woocommerce/single-product/meta.php<br>La  version 7.8.0 de betheme/woocommerce/single-product/product-image.php está obsoleta. La versión del núcleo es la 9.0.0<br>betheme/woocommerce/single-product/product-thumbnails.php<br>betheme/woocommerce/single-product/related.php<br>betheme/woocommerce/single-product/sale-flash.php<br>betheme/woocommerce/single-product/tabs/description.php<br>betheme/woocommerce/single-product/tabs/tabs.php<br>betheme/woocommerce/single-product/title.php<br>betheme/woocommerce/single-product/up-sells.php<br>betheme/woocommerce/single-product-reviews.php<br><br>Outdated Templates: ?<br>					<br>					<br>						Aprende cómo actualizar<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>printful<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-07-29 23:22:14 -05:00<br>Options: ?<br>Notes: 215<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Completo: 3.518<br>Oldest: 2024-06-28 12:53:48 +0000<br>Newest: 2024-07-29 12:36:04 +0000<br><br>Fallida: 23<br>Oldest: 2021-09-30 21:48:11 +0000<br>Newest: 2024-02-23 11:10:57 +0000<br><br>Pendiente: 4<br>Oldest: 2024-07-29 12:36:34 +0000<br>Newest: 2024-08-04 14:27:20 +0000<br><br><br>### Status report information ###<br><br>Generated at: 2024-07-29 07:36:44 -05:00<br>
</details>

• This reply was modified 3 months, 3 weeks ago by jota101.

Hi @jota101

The decrease in performance could be due to various factors. One possibility is that there might be an increase in the number of users or processes using your server resources, which can slow down the import process. Another possibility is that there might be issues with your CSV file, such as incorrect formatting or data errors.

Here are a few recommendations that might help:

1. Check your server resources: Make sure your server has enough resources (CPU, RAM) to handle the import process. If other processes or users are using up resources, try to limit them during the import process.
2. Make sure your CSV file is correctly formatted and free of errors. Our CSV Import Suite plugin can help you format your CSV file correctly.
3. Increase your PHP memory limit. Sometimes, increasing your PHP memory limit can also help speed up the import process.
4. Consider using a dedicated import tool like WP All Import or Import Export Suite for WooCommerce. These plugins are designed to handle large imports more efficiently.

If you’re still experiencing issues after trying these steps, please don’t hesitate to get back to us. We’re here to help!

@jota101 I faced similar problem and the solutions is simple

when import running, woocommerce do 3 processes together, importing and writing products data to database, importing images from urls, and the most important that thmbnail generation also run after once image imported to your site, thumbnail generation consume server resources and slow dlown the whole import process

To fix it ..

1- add this code to your theme/child theme functions to disable thmbnail generation

add_filter( ‘woocommerce_background_image_regeneration’, ‘__return_false’ );

2- after import is finished, and supposed to be fast, install regenerate thmbnail plugin and run it, the plugin is very smooth and make the process witthout consuming all server resources, and the most important it you already have your products imported, just give it some time to finish processing thumbnails

https://www.ads-software.com/plugins/regenerate-thumbnails/

Hi @jota101

I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or open a new topic.

Thanks!