Import dont work
-
Hi,
Product import dont work anymore. It starting, but it stops when import 5-6 products.
I thought that it is a conflict with some plugins. I deactivate plugins, but the problem is still appearing.
And i get an error message: “Request Timeout
This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase ‘Connection Timeout’.” when i try to delete, or make private/hidden or to empty trash more than 5 products.I modified already max_input_time and max_execution_time to 60 (i dont know if is to much), but the same message appear.
I mention that i have already over 49000 products on my page https://alwaysintrend.ro .Pls help.
- This topic was modified 4 years, 5 months ago by hallerandrei.
The page I need help with: [log in to see the link]
-
I recommend that you increase the amount of memory allocated to PHP on your site, as it is often what causes such issues:
https://www.ads-software.com/support/article/editing-wp-config-php/#increasing-memory-allocated-to-phpYou can enable WordPress debugging on your site, to find out exactly what is causing the error and share the error_log.txt file in your site’s root directory with us in your response. More info on this here – https://gist.github.com/jeherve/e6acfc973c07cb500836804e1044d12a
If that doesn’t help, please share your system report with me. You can find it by going to WooCommerce > Status > Get system report and then click Copy for support to be able to paste it in your reply.
Hi,
Thx for help, but dont work. memory_limit 128M and i changed in 256M, and even in the maximum – 768M.
I have opened in the same tim a topic in here: https://www.ads-software.com/support/topic/yoast-and-request-timeout/#post-12985462
I dont know how to send u error_log.txt file; just copy/paste here? i put in a wetransfer link https://we.tl/t-lPQiJxxfxI
And sistem report:
### WordPress Environment ### WordPress address (URL): https://alwaysintrend.ro Site address (URL): https://alwaysintrend.ro WC Version: 4.2.0 REST API Version: ? 1.0.8 WC Blocks Version: ? 2.5.16 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 1.2.3 Log Directory Writable: ? WP Version: 5.4.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: ? WP Cron: ? Language: ro_RO External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.6 PHP Post Max Size: 8 MB PHP Time Limit: 300 PHP Max Input Vars: 1000 cURL Version: 7.62.0 OpenSSL/1.0.2k SUHOSIN Installed: – MySQL Version: 10.2.32-MariaDB-cll-lve Max Upload Size: 8 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: 4.2.0 WC Database Prefix: wp0l_ Total Database Size: 797.71MB Database Data Size: 646.13MB Database Index Size: 151.58MB 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: 13.91MB + Index: 5.33MB + Engine MyISAM wp0l_actionscheduler_claims: Data: 0.01MB + Index: 0.05MB + Engine MyISAM wp0l_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_actionscheduler_logs: Data: 7.37MB + Index: 5.48MB + Engine MyISAM wp0l_automated_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_commentmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp0l_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM 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_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.02MB + Index: 0.00MB + Engine InnoDB wp0l_newsletter: Data: 0.30MB + Index: 0.18MB + Engine MyISAM wp0l_newsletter_emails: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wp0l_newsletter_sent: Data: 0.07MB + Index: 0.13MB + 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: 40.25MB + Index: 6.02MB + Engine MyISAM wp0l_postmeta: Data: 291.08MB + Index: 58.64MB + Engine MyISAM wp0l_posts: Data: 112.29MB + Index: 23.84MB + Engine MyISAM wp0l_po_plugins: Data: 0.00MB + Index: 0.00MB + 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_internal_links: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp0l_rank_math_internal_meta: Data: 0.00MB + Index: 0.00MB + 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_rank_math_sc_analytics: Data: 2.35MB + Index: 1.30MB + Engine MyISAM wp0l_redirection_404: Data: 17.97MB + Index: 4.52MB + Engine MyISAM wp0l_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_redirection_items: Data: 1.39MB + Index: 0.87MB + Engine MyISAM wp0l_redirection_logs: Data: 0.28MB + Index: 0.07MB + Engine MyISAM wp0l_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_termmeta: Data: 0.07MB + Index: 0.05MB + Engine MyISAM wp0l_terms: Data: 0.05MB + Index: 0.11MB + Engine MyISAM wp0l_term_relationships: Data: 8.41MB + Index: 17.79MB + Engine MyISAM wp0l_term_taxonomy: Data: 0.11MB + Index: 0.05MB + 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.36MB + Index: 0.01MB + Engine MyISAM wp0l_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp0l_wc_admin_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp0l_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + 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.71MB + Index: 4.47MB + Engine MyISAM 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.01MB + 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: 1.12MB + Index: 0.11MB + Engine MyISAM wp0l_yoast_indexable: Data: 127.69MB + Index: 18.52MB + 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.68MB + Index: 1.65MB + Engine MyISAM wp0l_yoast_seo_meta: Data: 1.72MB + Index: 1.68MB + Engine MyISAM ### Post Type Counts ### amp_validated_url: 1 attachment: 76604 custom_css: 1 customize_changeset: 54 elementor_library: 1 everest_form: 1 jetpack_migration: 2 jp_img_sitemap: 39 jp_img_sitemap_index: 1 jp_sitemap: 1 jp_sitemap_master: 1 mc4wp-form: 1 nav_menu_item: 82 oembed_cache: 2 page: 7 popup_theme: 6 post: 1 product: 49150 revision: 89688 saswp: 2 saswp-collections: 1 wp_block: 3 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (20) ### Akismet Anti-Spam: by Automattic – 4.1.6 GDPR Cookie Consent: by WebToffee – 1.8.8 Elementor: by Elementor.com – 2.9.12 Jetpack by WordPress.com: by Automattic – 8.6.1 Mailchimp for WooCommerce: by Mailchimp – 2.4.0 – Installed version not tested with active version of WooCommerce 4.2.0 MC4WP: Mailchimp for WordPress: by ibericode – 4.7.8 Newsletter: by Stefano Lissa & The Newsletter Team – 6.7.2 Plugin Organizer: by Jeff Sterup – 10.1.3 Really Simple SSL: by Rogier Lankhorst Mark Wolters – 3.3.3 Redirection: by John Godley – 4.8 Resize Image After Upload: by ShortPixel – 1.8.6 Schema & Structured Data for WP & AMP: by Magazine3 – 1.9.41.1 WebP Express: by Bj?rn Rosell – 0.17.3 WOOF - WooCommerce Products Filter: by realmag777 – 1.2.4 – Installed version not tested with active version of WooCommerce 4.2.0 WooCommerce: by Automattic – 4.2.0 Yoast SEO: by Team Yoast – 14.3 Auto Affiliate Links: by Lucian Apostol – 5.9.1.1 WP Fastest Cache: by Emre Vona – 0.9.0.7 WP Global Site Tag: by Digital Apps – 1.0.4 WP Sitemap Page: by Tony Archambeau – 1.6.2 ### Inactive Plugins (1) ### Rank Math SEO: by Rank Math – 1.0.44 ### Must Use Plugins (1) ### Plugin Organizer MU: by Jeff Sterup – 10.1.3 ### 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: ? Page ID is set but the page does not exist Checkout: ? Page ID is set but the page does not exist My account: ? Page ID is set but the page does not exist Terms and conditions: ? Page not set ### Theme ### Name: Zakra Version: 1.4.4 Author URL: https://themegrill.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: 37,551 Oldest: 2020-06-15 23:01:01 +0300 Newest: 2020-06-16 21:29:06 +0300 Pending: 12,137 Oldest: 2020-06-15 23:17:12 +0300 Newest: 2020-06-16 18:58:13 +0300 Failed: 1,327 Oldest: 2019-11-01 13:15:01 +0200 Newest: 2020-06-16 00:09:33 +0300 Canceled: 3 Oldest: 2020-06-14 18:34:10 +0300 Newest: 2020-06-15 23:00:47 +0300
Thx
- This reply was modified 4 years, 5 months ago by hallerandrei.
Hi there,
With around 50,000 products this is likely to be caused by server side resource limits so I suggest talking to your host to see if they can find the cause of the timeouts.In the meantime I’d also suggest that you increase:
PHP Time Limit: 600
PHP Max Input Vars: 10000You may need to talk to your host about changing those settings on your site.
If you are on a shared hosting account it may simply be that your account does not have sufficient resources to manage that number of products.
You host will able to advise.
I hope that helps you to figure it out.
Feel free to get back to us if you have further questions.We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.
- The topic ‘Import dont work’ is closed to new replies.