• Resolved hallerandrei

    (@hallerandrei)


    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]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Mirko P.

    (@rainfallnixfig)

    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.

    Thread Starter hallerandrei

    (@hallerandrei)

    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

    Thread Starter hallerandrei

    (@hallerandrei)

    Hi,

    I check also with a better/hitgher hosting package, but the same problem.

    Thx.

    Mirko P.

    (@rainfallnixfig)

    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.

    Thread Starter hallerandrei

    (@hallerandrei)

    Hi,

    Problem solved. My host made some changes ot php settings.

    Thx for help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Import Stuck after 10/20 products’ is closed to new replies.