Product import stuck

Hi,

I’ve read some threads about that but it seems that there are several reasons for the product import process to not finished.

I’ve notices that when trying to import a large list of products, Woocommerce can not finished.

What I’m doing is that I split my CSV file into several and import each ones. It works fine.

Now, I’d like to find a solution to maximize the number of products to import (also save time and minimize possibilities of errors).

And also, I’d like to continue using the native import functionality rather than a paid one.

Here is an example of CSV file that I usually import (from Hiboutik): https://kdrive.schema-studio.ch/app/share/506400/455eb06c-24cb-46d3-ace2-06f5108fbaa7

Here is below the system status details.

Feel free to ask more informations that could be useful.

Best regards,

Micha?l

<br>### WordPress Environment ###<br><br>WordPress address (URL): https://www.pepecassius.ch<br>Site address (URL): https://www.pepecassius.ch<br>WC Version: 9.3.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.1<br>Log Directory Writable: ?<br>WP Version: 6.6.2<br>WP Multisite: –<br>WP Memory Limit: 600 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: fr_FR<br>External object cache: –<br><br>### Server Environment ###<br><br>Server Info: Apache<br>PHP Version: 8.2.20<br>PHP Post Max Size: 300 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 10000<br>cURL Version: 7.74.0<br>OpenSSL/1.1.1k<br><br>SUHOSIN Installed: –<br>MySQL Version: 5.7.32-log<br>Max Upload Size: 300 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>WC Database Version: 9.3.3<br>WC Database Prefix: wp_611594_<br>Total Database Size: 573.00MB<br>Database Data Size: 415.20MB<br>Database Index Size: 157.80MB<br>wp_611594_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_woocommerce_order_items: Data: 0.11MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.84MB + Engine InnoDB<br>wp_611594_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_611594_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_actionscheduler_actions: Data: 13.44MB + Index: 16.02MB + Engine InnoDB<br>wp_611594_actionscheduler_claims: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_611594_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_actionscheduler_logs: Data: 9.45MB + Index: 7.97MB + Engine InnoDB<br>wp_611594_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_comments: Data: 0.31MB + Index: 0.34MB + Engine InnoDB<br>wp_611594_ee_products_sync_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ee_product_sync_profile: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ee_prouct_pre_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_eum_logs: Data: 72.52MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_611594_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_611594_e_submissions: Data: 2.52MB + Index: 2.81MB + Engine InnoDB<br>wp_611594_e_submissions_actions_log: Data: 0.38MB + Index: 0.78MB + Engine InnoDB<br>wp_611594_e_submissions_values: Data: 4.52MB + Index: 0.63MB + Engine InnoDB<br>wp_611594_hfcm_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_import_postID: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_options: Data: 10.47MB + Index: 1.45MB + Engine InnoDB<br>wp_611594_pmxe_exports: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxe_posts: Data: 0.19MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_geocoding: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_images: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_imports: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_postmeta: Data: 82.63MB + Index: 53.17MB + Engine InnoDB<br>wp_611594_posts: Data: 125.58MB + Index: 9.06MB + Engine InnoDB<br>wp_611594_simple_history: Data: 8.48MB + Index: 4.03MB + Engine InnoDB<br>wp_611594_simple_history_contexts: Data: 57.50MB + Index: 36.00MB + Engine InnoDB<br>wp_611594_smackcsv_file_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_smackuci_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_termmeta: Data: 0.17MB + Index: 0.19MB + Engine InnoDB<br>wp_611594_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_term_relationships: Data: 4.52MB + Index: 2.52MB + Engine InnoDB<br>wp_611594_term_taxonomy: Data: 0.09MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_ultimate_csv_importer_acf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ultimate_csv_importer_mappingtemplate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ultimate_csv_importer_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ultimate_csv_importer_shortcode_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_ultimate_post_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_usermeta: Data: 4.52MB + Index: 0.56MB + Engine InnoDB<br>wp_611594_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>wp_611594_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wc_customer_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_611594_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_611594_wc_order_tax_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wc_product_attributes_lookup: Data: 1.52MB + Index: 1.52MB + Engine InnoDB<br>wp_611594_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wc_product_meta_lookup: Data: 1.52MB + Index: 4.61MB + Engine InnoDB<br>wp_611594_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_filters: Data: 0.23MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wpf_meta_data: Data: 4.50MB + Index: 9.19MB + Engine InnoDB<br>wp_611594_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wpf_statistics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_statistics_det: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_statistics_sum: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_statistics_val: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_wpmelon_advbedit_temp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_611594_wpr_above_the_fold: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_wpr_lazy_render_content: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_611594_wpr_rocket_cache: Data: 1.52MB + Index: 2.95MB + Engine InnoDB<br>wp_611594_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_611594_yoast_indexable: Data: 2.47MB + Index: 0.81MB + Engine InnoDB<br>wp_611594_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.20MB + Engine InnoDB<br>wp_611594_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_611594_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_611594_yoast_prominent_words: Data: 0.11MB + Index: 0.19MB + Engine InnoDB<br>wp_611594_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br><br>### Post Type Counts ###<br><br>acf-field: 81<br>acf-field-group: 13<br>acf-options-page: 1<br>attachment: 7939<br>br_product_filter: 3<br>custom_css: 1<br>elementor_font: 1<br>elementor_library: 27<br>elementskit_content: 2<br>marques_produits: 4<br>nav_menu_item: 30<br>oembed_cache: 38<br>page: 14<br>plus-mega-menu: 2<br>post: 2<br>product: 2512<br>product_variation: 8860<br>revision: 234<br>shop_coupon: 1<br>shop_order: 299<br>slider_header: 7<br>valeurs: 4<br>wp_global_styles: 1<br>wp-rest-api-log: 17626<br>wpf_post_it: 3<br><br>### Security ###<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ?<br><br>### Active Plugins (50) ###<br><br>ACF Content Analysis for Yoast SEO: by Thomas Kr?ftner<br>ViktorFroberg<br>marol87<br>pekz0r<br>angrycreative<br>Team Yoast – 3.1<br><br>Adminimize: by WP Media – 1.11.11<br>Advanced Custom Fields: Font Awesome: by Matt Keys – 4.1.1<br>Advanced Custom Fields PRO: by WP Engine – 6.3.10<br>Auto Image Attributes From Filename With Bulk Updater: by Arun Basil Lal – 4.4<br>Better Admin Bar: by David Vongries – 4.1.1<br>Custom Post Type UI: by WebDevStudios – 1.17.1<br>Delete All Products for WooCommerce: by ThemeDyno – 1.3.0<br>Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5<br>Dynamic.ooo - Dynamic Content for Elementor: by Dynamic.ooo – 3.1.2<br>Elementor Pro: by Elementor.com – 3.25.2<br>Elementor: by Elementor.com – 3.25.4<br>ElementsKit Lite: by Wpmet – 3.3.1<br>Enable Media Replace: by ShortPixel – 4.1.5<br>Facebook for WooCommerce: by Facebook – 3.2.10<br>Favicon by RealFaviconGenerator: by Philippe Bernard – 1.3.36<br>Flexible Shipping: by Octolize – 5.0.3<br>Folders: by Premio – 3.0.6<br>Site Kit by Google: by Google – 1.139.0<br>Header Footer Code Manager: by DraftPress – 1.1.39<br>Health Check & Troubleshooting: by The www.ads-software.com community – 1.7.1<br>Instant Images: by Darren Cooney – 6.1.2<br>My Custom Functions: by Space X-Chimp – 4.51<br>ACF Options Page Admin: by John A. Huebner II – 3.10.0<br>Perfect Brands WooCommerce: by QuadLayers – 3.4.4<br>WP All Export - WooCommerce Product Export Add-On: by Soflyy – 1.0.3<br>Really Simple Security: by Really Simple Security – 9.1.0<br>Show Net Revenue from WooCommerce Stripe Gateway: by Matt Rose – 1.1.0<br>Simple Custom Post Order: by Colorlib – 2.5.8<br>Simple History: by P?r Thernstr?m – 5.0.4<br>Easy Updates Manager: by Easy Updates Manager Team – 9.0.18<br>SVG Support: by Benbodhi – 2.5.8<br>The Plus Addons for Elementor: by POSIMYTH – 6.0.3<br>The Plus Addons for Elementor - Pro: by POSIMYTH – 6.0.4<br>UpdraftPlus - Backup/Restore: by TeamUpdraft<br>DavidAnderson – 2.24.7.1<br><br>User Role Editor: by Vladimir Garagulya – 4.64.2<br>Converter for Media: by matt plugins - Optimize images by convert WebP & AVIF – 6.1.2<br>Product Feed ELITE for WooCommerce: by AdTribes.io – 3.2.9<br>Product Filter by WBW: by WBW – 2.4.5<br>WooCommerce Advanced Bulk Edit: by George Iron & Yas G. – 5.4.4.6<br>WooCommerce Stripe Gateway: by Stripe – 8.8.1<br>PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.9.0<br>WooCommerce: by Automattic – 9.3.3<br>WBW Product Filter PRO: by WBW – 2.3.4<br>Yoast SEO: by Team Yoast – 23.7<br>WP All Export: by Soflyy – 1.4.8<br>WP All Import Pro: by Soflyy – 4.9.3<br>WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 4.0.0<br>WPCore Plugin Manager: by Stuart Starr – 1.9.2<br>WPDash Notes: by WPFormation<br>NicolasKulka<br>WPServeur – 1.3.5<br><br><br>### Inactive Plugins (1) ###<br><br>WP Rocket: by WP Media – 3.17.2<br><br>### Dropin Plugins () ###<br><br>advanced-cache.php: advanced-cache.php<br><br>### Must Use Plugins (1) ###<br><br>Health Check Troubleshooting Mode: by  – 1.8.0<br><br>### Settings ###<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: CHF (CHF)<br>Currency Position: left_space<br>Thousand Separator: '<br>Decimal Separator: .<br>Number of Decimals: 2<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 days<br>Level threshold: –<br>Log directory size: 32 KB<br><br>### WC Pages ###<br><br>Shop base: #8 - /shop<br>Cart: #9 - /mon-panier -  Contains the [woocommerce_cart] shortcode<br>Checkout: #10 - /ma-commande -  Contains the [woocommerce_checkout] shortcode<br>My account: #11 - /mon-compte<br>Terms and conditions: #45 - /conditions-generales-de-vente<br><br>### Theme ###<br><br>Name: Hello Elementor Child<br>Version: 1.0.1<br>Author URL: https://elementor.com/<br>Child Theme: ?<br>Parent Theme Name: Hello Elementor<br>Parent Theme Version: 3.1.1<br>Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash<br>WooCommerce Support: ?<br><br>### Templates ###<br><br>Overrides: /home/clients/adf1f238ff0c89cdf93e0fcce1b4e5d3/web/wp-content/plugins/theplus_elementor_addon/modules/widgets-styles/woo-thankyou/thankyou.php version 3.7.0 is out of date. The core version is 8.1.0<br>Outdated Templates: ?<br>					<br>					<br>						Learn how to update					 |<br>					<br>						<br>					<br>					<br>						Clear system status theme info cache<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>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<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>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br><br>Daily Cron: ? Next scheduled: 2024-11-11 11:11:21 +01:00<br>Options: ?<br>Notes: 83<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 42,869<br>Oldest: 2024-10-10 20:33:48 +0200<br>Newest: 2024-11-10 18:51:03 +0100<br><br>Failed: 1<br>Oldest: –<br>Newest: –<br><br>Pending: 2<br>Oldest: 2024-11-11 02:54:44 +0100<br>Newest: 2024-12-05 02:47:48 +0100<br><br><br>### Status report information ###<br><br>Generated at: 2024-11-10 19:02:36 +01:00<br>