Import Stuck after 10/20 products
-
Hi,
I have a problem importing WooCommerce products. After a few products – 10/20 products – the import is stucked.
I am trying to import large csv file – 3000 products. Later I tried only a file with 30 products. Likewise, it crashes after 5/10/20 products.
I tried all this with some of the plugins disabled or with almost all the plugins disabled (I left active only WooCommerce, WOOF – WooCommerce Products Filter, Redirection, Really Simple SSL, WP Global Site Tag).
Help!The page I need help with: [log in to see the link]
-
Hi @hallerandrei,
Kindly try to import products with all plugins (except WooCommerce) disabled and check if it’s working. I’d also suggest installing a plugin called Health Check & Troubleshooting. This is a plugin developed by the WordPress community and it allows you to disable plugins without affecting your current site visitors.
If you do not see an improvement, check
WooCommerce → Status → Logs
for any relevant error logs, such as memory exhaustion, and share them with us or your host.Also, 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.
Thanks.
Hi,
still stuck…
2021-10-30T02:32:08+00:00 CRITICAL Allowed memory size of 536870912 bytes exhausted (tried to allocate 925696 bytes) ?n /home/alwaysin/public_html/wp-includes/formatting.php pe linia 3169
memory_limit was 512MB, now 1024MB.
System Status:
### WordPress Environment ### WordPress address (URL): https://alwaysintrend.ro Site address (URL): https://alwaysintrend.ro WC Version: 5.8.0 REST API Version: ? 5.8.0 WC Blocks Version: ? 5.9.1 Action Scheduler Version: ? 3.3.0 WC Admin Version: ? 2.7.2 Log Directory Writable: ? WP Version: 5.8.1 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: ? WP Cron: ? Language: ro_RO External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.24 PHP Post Max Size: 256 MB PHP Time Limit: 600 PHP Max Input Vars: 10000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.3.31-MariaDB-cll-lve Max Upload Size: 128 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected. DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.8.0 WC Database Prefix: wp0l_ Total Database Size: 1274.05MB Database Data Size: 1084.03MB Database Index Size: 190.02MB wp0l_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_actionscheduler_actions: Data: 4.45MB + Index: 1.90MB + Engine MyISAM wp0l_actionscheduler_claims: Data: 0.02MB + Index: 0.03MB + Engine MyISAM wp0l_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_actionscheduler_logs: Data: 3.60MB + Index: 2.72MB + Engine MyISAM wp0l_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_commentmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp0l_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp0l_eafl_clicks: Data: 5.52MB + Index: 0.69MB + Engine InnoDB wp0l_eafl_relations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_evf_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_evf_entrymeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_evf_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_hustle_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_hustle_entries_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_hustle_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_hustle_modules_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp0l_hustle_tracking: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_ig_actions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp0l_ig_blocked_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_campaigns: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp0l_ig_contactmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_ig_contacts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp0l_ig_contacts_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_ig_contact_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_ig_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp0l_ig_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_lists_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_ig_mailing_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_ig_queue: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp0l_ig_sending_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_temp_import: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_unsubscribe_feedback: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_wc_cart: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp0l_ig_wc_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp0l_ig_workflows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_ig_workflows_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp0l_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_litespeed_img_optm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_litespeed_optimizer: Data: 0.06MB + Index: 0.01MB + Engine MyISAM wp0l_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_mailchimp_jobs: Data: 6.52MB + Index: 0.00MB + Engine InnoDB wp0l_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_newsletter: Data: 0.30MB + Index: 0.18MB + Engine MyISAM wp0l_newsletter_emails: Data: 0.04MB + Index: 0.00MB + Engine MyISAM wp0l_newsletter_sent: Data: 0.07MB + Index: 0.12MB + Engine MyISAM wp0l_newsletter_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_newsletter_user_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_options: Data: 88.39MB + Index: 3.59MB + Engine MyISAM wp0l_postmeta: Data: 550.43MB + Index: 73.74MB + Engine MyISAM wp0l_posts: Data: 162.93MB + Index: 24.64MB + Engine MyISAM wp0l_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_rank_math_analytics_gsc: Data: 3.02MB + Index: 2.61MB + Engine InnoDB wp0l_rank_math_analytics_objects: Data: 10.52MB + Index: 5.55MB + Engine InnoDB wp0l_rank_math_internal_links: Data: 0.53MB + Index: 0.08MB + Engine MyISAM wp0l_rank_math_internal_meta: Data: 1.16MB + Index: 0.96MB + Engine MyISAM wp0l_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_redirection_404: Data: 94.68MB + Index: 12.93MB + Engine MyISAM wp0l_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_redirection_items: Data: 1.64MB + Index: 1.04MB + Engine MyISAM wp0l_redirection_logs: Data: 5.82MB + Index: 0.81MB + Engine MyISAM wp0l_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_termmeta: Data: 0.16MB + Index: 0.11MB + Engine MyISAM wp0l_terms: Data: 0.09MB + Index: 0.15MB + Engine MyISAM wp0l_term_relationships: Data: 11.70MB + Index: 24.56MB + Engine MyISAM wp0l_term_taxonomy: Data: 0.14MB + Index: 0.11MB + Engine MyISAM wp0l_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_usermeta: Data: 0.11MB + Index: 0.01MB + Engine MyISAM wp0l_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp0l_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp0l_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_wc_customer_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_order_product_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_order_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_product_meta_lookup: Data: 2.89MB + Index: 4.68MB + Engine MyISAM wp0l_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfconfig: Data: 0.37MB + Index: 0.02MB + Engine MyISAM wp0l_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wffilemods: Data: 1.43MB + Index: 0.31MB + Engine MyISAM wp0l_wfhits: Data: 0.03MB + Index: 0.02MB + Engine MyISAM wp0l_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_wfknownfilelist: Data: 0.73MB + Index: 0.09MB + Engine MyISAM wp0l_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wflocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp0l_wflogins: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp0l_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wfstatus: Data: 0.08MB + Index: 0.04MB + Engine MyISAM wp0l_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woof_query_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woof_stat_buffer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_woof_stat_tmp: Data: 0.81MB + Index: 0.08MB + Engine MyISAM wp0l_woot_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_woot_tables_columns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_woot_tables_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_woot_vocabulary: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp0l_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_yoast_indexable: Data: 115.67MB + Index: 24.09MB + Engine InnoDB wp0l_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp0l_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp0l_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp0l_yoast_seo_links: Data: 7.39MB + Index: 1.23MB + Engine MyISAM wp0l_yoast_seo_meta: Data: 1.73MB + Index: 1.69MB + Engine MyISAM ### Post Type Counts ### amp_validated_url: 1 attachment: 122916 custom_css: 2 customize_changeset: 8 easy_affiliate_link: 49 elementor_library: 2 everest_form: 1 jetpack_migration: 2 jp_img_sitemap: 69 jp_img_sitemap_index: 2 jp_sitemap: 2 jp_sitemap_master: 2 jp_vid_sitemap: 2 mc4wp-form: 1 nav_menu_item: 80 oembed_cache: 19 page: 17 popup_theme: 6 post: 35 product: 54083 revision: 38971 saswp: 4 saswp-collections: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (1) ### WooCommerce: by Automattic – 5.8.0 ### Inactive Plugins (19) ### Akismet Anti-Spam: by Automattic – 4.2.1 Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.8.4 Easy Affiliate Links: by Bootstrapped Ventures – 3.5.0 Easy Table of Contents: by Steven A. Zahm – 2.0.17 Email Subscribers & Newsletters: by Icegram – 4.9.0 GDPR Cookie Consent: by WebToffee – 2.0.6 Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.5 Imagify: by WP Media – 1.10 Jetpack: by Automattic – 10.2.1 Mailchimp for WooCommerce: by Mailchimp – 2.5.3 MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6 Rank Math SEO: by Rank Math – 1.0.75 Really Simple SSL: by Really Simple Plugins – 5.1.2 Redirection: by John Godley – 5.1.3 Scripts-To-Footer: by Joshua David Nelson – 0.6.4.1 Store Toolkit for WooCommerce: by Visser Labs – 2.3.1 WOOF - WooCommerce Products Filter: by realmag777 – 1.2.5.6 WP Fastest Cache: by Emre Vona – 0.9.5 WP Global Site Tag: by Digital Apps – 1.0.6 ### Dropin Plugins (1) ### maintenance.php: maintenance.php ### Must Use Plugins (1) ### Health Check Troubleshooting Mode: by – 1.7.2 ### Settings ### API Enabled: – Force SSL: – Currency: RON (lei) Currency Position: right_space 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 - /imbracaminte-femei/ Cart: #453251 - /cos/ Checkout: #453252 - /finalizare/ My account: #453253 - /contul-meu/ Terms and conditions: ? Page not set ### Theme ### Name: Twenty Twenty Version: 1.8 Author URL: https://www.ads-software.com/ Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Complete: 5,217 Oldest: 2021-10-25 07:31:08 +0300 Newest: 2021-10-30 09:08:32 +0300 Failed: 1,328 Oldest: 2019-11-01 13:15:01 +0200 Newest: 2020-12-17 08:46:59 +0200 Pending: 2 Oldest: 2021-11-05 00:49:49 +0200 Newest: 2021-11-19 02:00:36 +0200 ### Status report information ### Generated at: 2021-10-30 11:20:25 +03:00
Thx
Hi,
I check also with a better/hitgher hosting package, but the same problem.
Thx.
Hi @hallerandrei,
Contact your host and have them check your server’s error log. They will be able to see exactly why your server is rejecting your import file.
If the CSV file you’re importing follows the general CSV formatting guidelines there isn’t much we can do here to help until your host has checked the error log and we know exactly what the issue is.
Thanks.
Hi,
Problem solved. My host made some changes ot php settings.
Thx for help.
- The topic ‘Import Stuck after 10/20 products’ is closed to new replies.