Product CSV Import Hangs

When I try to import or update products using the importer, it just hangs. I have tried different spreadsheet programs, I’ve tried with one item, I’ve tried with just a few fields, I have downloaded the template, I have disabled ALL plugins except for Woocommerce and I have even tried different themes.

My hosting company even spent a ton of time trying to help me. Here is what they finally told me:

“I think at this point best you open a ticket at WooCommerce.com and ask them for some feedback, there are zero errors showing up in PHP and Nginx logs meaning it doesn’t seem connected (or recorded) by the server.”

I’d like to get this resolved, thank you.

Steve

### WordPress Environment ###

Home URL: https://www.its420somewhere.com
Site URL: https://www.its420somewhere.com
WC Version: 3.4.5
Log Directory Writable: ?
WP Version: 4.9.8
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: nginx/1.15.0
PHP Version: 7.2.7-0ubuntu0.18.04.2
PHP Post Max Size: 512 MB
PHP Time Limit: 60
PHP Max Input Vars: 5000
cURL Version: 7.58.0
OpenSSL/1.1.0g

SUHOSIN Installed: –
MySQL Version: 5.7.22-0ubuntu18.04.1
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.4.5
WC Database Prefix: wp_
Total Database Size: 172.75MB
Database Data Size: 126.50MB
Database Index Size: 46.25MB
wp_woocommerce_sessions: Data: 23.08MB + Index: 0.36MB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB
wp_woocommerce_order_itemmeta: Data: 0.31MB + Index: 0.20MB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
wp_addactionsandfilters_plugin_usercode: Data: 0.02MB + Index: 0.00MB
wp_ajaxsearchpro: Data: 0.02MB + Index: 0.00MB
wp_ajaxsearchpro_priorities: Data: 0.02MB + Index: 0.02MB
wp_ajaxsearchpro_statistics: Data: 0.02MB + Index: 0.00MB
wp_ariadminer_connections: Data: 0.02MB + Index: 0.00MB
wp_asp_index: Data: 3.52MB + Index: 5.03MB
wp_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB
wp_atum_order_items: Data: 0.02MB + Index: 0.02MB
wp_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB
wp_automatewoo_customers: Data: 0.02MB + Index: 0.09MB
wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB
wp_automatewoo_guests: Data: 0.02MB + Index: 0.06MB
wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB
wp_automatewoo_logs: Data: 0.02MB + Index: 0.05MB
wp_automatewoo_log_meta: Data: 0.09MB + Index: 0.09MB
wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB
wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB
wp_automatewoo_unsubscribes: Data: 0.02MB + Index: 0.05MB
wp_aws_index: Data: 1.52MB + Index: 0.00MB
wp_commentmeta: Data: 0.06MB + Index: 0.03MB
wp_comments: Data: 0.25MB + Index: 0.33MB
wp_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB
wp_duplicator_pro_packages: Data: 0.02MB + Index: 0.02MB
wp_ebay_accounts: Data: 0.02MB + Index: 0.00MB
wp_ebay_auctions: Data: 10.16MB + Index: 0.14MB
wp_ebay_categories: Data: 2.52MB + Index: 3.03MB
wp_ebay_jobs: Data: 0.27MB + Index: 0.00MB
wp_ebay_log: Data: 0.13MB + Index: 0.05MB
wp_ebay_messages: Data: 0.02MB + Index: 0.00MB
wp_ebay_orders: Data: 5.52MB + Index: 0.02MB
wp_ebay_payment: Data: 0.02MB + Index: 0.00MB
wp_ebay_profiles: Data: 0.02MB + Index: 0.00MB
wp_ebay_shipping: Data: 0.05MB + Index: 0.00MB
wp_ebay_sites: Data: 0.03MB + Index: 0.00MB
wp_ebay_store_categories: Data: 0.02MB + Index: 0.03MB
wp_ebay_transactions: Data: 4.52MB + Index: 0.05MB
wp_etcpf_etsy_configuration: Data: 0.02MB + Index: 0.00MB
wp_etcpf_feeds: Data: 0.02MB + Index: 0.00MB
wp_etcpf_listings: Data: 0.02MB + Index: 0.00MB
wp_etcpf_shipping_template: Data: 0.02MB + Index: 0.00MB
wp_ewwwio_images: Data: 11.52MB + Index: 15.17MB
wp_gonzales_disabled: Data: 0.02MB + Index: 0.00MB
wp_gonzales_enabled: Data: 0.02MB + Index: 0.00MB
wp_gonzales_p_disabled: Data: 0.02MB + Index: 0.00MB
wp_gonzales_p_enabled: Data: 0.02MB + Index: 0.00MB
wp_hustle_modules: Data: 0.02MB + Index: 0.03MB
wp_hustle_modules_meta: Data: 0.02MB + Index: 0.03MB
wp_itro_plugin_field: Data: 0.02MB + Index: 0.00MB
wp_itro_plugin_option: Data: 0.02MB + Index: 0.00MB
wp_links: Data: 0.02MB + Index: 0.02MB
wp_nxs_log: Data: 1.02MB + Index: 0.00MB
wp_nxs_query: Data: 0.02MB + Index: 0.00MB
wp_options: Data: 12.38MB + Index: 1.61MB
wp_postmeta: Data: 14.52MB + Index: 7.02MB
wp_posts: Data: 7.41MB + Index: 0.56MB
wp_po_plugins: Data: 1.52MB + Index: 0.25MB
wp_push_archive: Data: 0.16MB + Index: 0.00MB
wp_push_archive_reports: Data: 0.02MB + Index: 0.02MB
wp_push_autorss_data: Data: 0.00MB + Index: 0.00MB
wp_push_autorss_sources: Data: 0.00MB + Index: 0.00MB
wp_push_channels: Data: 0.00MB + Index: 0.00MB
wp_push_connection: Data: 0.00MB + Index: 0.00MB
wp_push_cron_queue: Data: 0.01MB + Index: 0.00MB
wp_push_desktop_messages: Data: 0.02MB + Index: 0.00MB
wp_push_events: Data: 0.00MB + Index: 0.00MB
wp_push_events_queue: Data: 1.08MB + Index: 0.00MB
wp_push_feedback: Data: 0.02MB + Index: 0.00MB
wp_push_history: Data: 0.02MB + Index: 0.00MB
wp_push_newsletter_templates: Data: 0.00MB + Index: 0.00MB
wp_push_newsletter_views: Data: 0.02MB + Index: 0.00MB
wp_push_queue: Data: 0.00MB + Index: 0.00MB
wp_push_relation: Data: 0.02MB + Index: 0.02MB
wp_push_statistics: Data: 0.05MB + Index: 0.00MB
wp_push_subscriptions: Data: 0.02MB + Index: 0.00MB
wp_push_tokens: Data: 0.02MB + Index: 0.02MB
wp_redirection_404: Data: 0.06MB + Index: 0.06MB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB
wp_redirection_items: Data: 0.02MB + Index: 0.08MB
wp_redirection_logs: Data: 0.02MB + Index: 0.08MB
wp_snippets: Data: 0.02MB + Index: 0.00MB
wp_tcb_api_error_log: Data: 0.09MB + Index: 0.00MB
wp_termmeta: Data: 0.05MB + Index: 0.03MB
wp_terms: Data: 0.13MB + Index: 0.16MB
wp_term_relationships: Data: 0.23MB + Index: 0.16MB
wp_term_taxonomy: Data: 0.13MB + Index: 0.16MB
wp_tve_leads_contacts: Data: 0.05MB + Index: 0.00MB
wp_tve_leads_contact_download: Data: 0.02MB + Index: 0.00MB
wp_tve_leads_event_log: Data: 3.52MB + Index: 4.03MB
wp_tve_leads_form_variations: Data: 0.13MB + Index: 0.06MB
wp_tve_leads_group_options: Data: 0.02MB + Index: 0.00MB
wp_tve_leads_saved_group_options: Data: 0.02MB + Index: 0.00MB
wp_tve_leads_split_test: Data: 0.02MB + Index: 0.00MB
wp_tve_leads_split_test_items: Data: 0.02MB + Index: 0.00MB
wp_usermeta: Data: 0.22MB + Index: 0.16MB
wp_users: Data: 0.02MB + Index: 0.05MB
wp_wctofb: Data: 0.05MB + Index: 0.00MB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB
wp_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.00MB
wp_woocommerce_recommendations: Data: 1.52MB + Index: 0.00MB
wp_woocommerce_session_activity: Data: 11.52MB + Index: 0.00MB
wp_wps_hit: Data: 0.02MB + Index: 0.14MB
wp_wps_index: Data: 3.52MB + Index: 5.55MB
wp_wps_key: Data: 0.20MB + Index: 0.16MB
wp_wps_object_type: Data: 0.02MB + Index: 0.08MB
wp_wps_query: Data: 0.02MB + Index: 0.02MB
wp_wps_uri: Data: 0.02MB + Index: 0.02MB
wp_wps_user_agent: Data: 0.02MB + Index: 0.02MB
wp_wrd_discounts: Data: 0.02MB + Index: 0.02MB
wp_wrd_sent_coupons: Data: 0.02MB + Index: 0.05MB
wp_yoast_seo_links: Data: 0.05MB + Index: 0.02MB
wp_yoast_seo_meta: Data: 0.19MB + Index: 0.00MB
wp_ywsfl_list: Data: 0.02MB + Index: 0.02MB
_mig_wpmdb_alter_statements: Data: 0.02MB + Index: 0.00MB

### Post Type Counts ###

acf: 1
attachment: 1892
atum_purchase_order: 1
aw_workflow: 8
customize_changeset: 14
custom_css: 3
divi_bars: 1
divi_overlay: 2
et_pb_layout: 34
nav_menu_item: 53
page: 29
post: 6
product: 450
product_tabpage: 1
revision: 333
shop_coupon: 19
shop_order: 115
shop_order_refund: 2
sp_wps_shortcodes: 3
tve_form_type: 3
tve_lead_1c_signup: 1
tve_lead_2s_lightbox: 1
tve_lead_group: 4
tve_lead_shortcode: 2
urp_review: 14
wcam: 16
wc_product_tab: 101
wphb_minify_group: 4
xlwcty_thankyou: 1
ywdpd_discount: 5

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (56) ###

CDN Linker: by W-Mark Kubacki – 1.4.2
Accept CryptoCurrency Payments on WooCommerce – TheBigCoin: by TheBigCoin – 1.0.2 – Not tested with the active version of WooCommerce
Advanced Custom Fields: by Elliot Condon – 4.4.12
Age Gate: by Phil Baker – 2.1.0
ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.4.13
AutomateWoo: by Prospress – 4.3.1
Checkout Address Autocomplete for WooCommerce: by eCreations – 2.0.2 – Not tested with the active version of WooCommerce
Classic Editor: by WordPress Contributors – 0.4
Code Snippets: by Shea Bunge – 2.11.0
Customer Reviews for WooCommerce: by ivole – 3.37
Disable Author Pages: by LittleBizzy – 1.0.5
Disable Cart Fragments: by LittleBizzy – 1.1.3
Divi Bars: by Divi Life — Tim Strifler – 1.4.1
Divi Overlays: by Divi Life — Tim Strifler – 2.2
Divi Extended Column Layouts: by Sean Barton – Tortoise IT – 2.0
DIVI ACF Module: by Sean Barton – Tortoise IT – 3.3
Woo Layout Injector: by Sean Barton – Tortoise IT – 4.6 – Not tested with the active version of WooCommerce
Elegant Tabs for WooCommerce: by InfiWebs – 2.3.0 – Not tested with the active version of WooCommerce
Force HTTPS: by LittleBizzy – 1.1.2
Heartbeat Control: by Jeff Matson – 1.2.5
CAOS for Analytics: by Daan van den Bergh – 1.86
Instagram Feed Pro Personal: by Smash Balloon – 3.0.1
WooBought Pro: by Maarten Belmans – 1.2.2
Monarch Plugin: by Elegant Themes – 1.4.3
MyWorks WooCommerce Shipment Tracking for Ordoro: by MyWorks Software – 1.2 – Not tested with the active version of WooCommerce
Redirection: by John Godley – 3.4
Sezzle Woocommerce Payment: by Sezzle Pay – 1.2.2 – Not tested with the active version of WooCommerce
Smart Notification WordPress Plugin: by Smart IO Labs – 7.7.7
Thrive Leads: by Thrive Themes – 2.0.47
WC Cat Shortcode: by Raihan Reza – 1.0.0
Estimated Delivery Plugin: by XAdapter – 1.5.7.5 – Not tested with the active version of WooCommerce
WooCommerce Reviews Manually Approved: by Tim Eckel – 1.1 – Not tested with the active version of WooCommerce
SKU search to direct product page: by Xaraar
firdousi – 1.5

Advanced Messages for WooCommerce: by Jeroen Sormani – 1.3.3
WooCommerce Extended Coupon Features PRO: by Soft79 – 2.6.4
WooCommerce AWeber Newsletter Subscription: by WooCommerce – 1.0.15
WooCommerce Checkout Field Editor: by WooCommerce – 1.5.13
WooCommerce Authorize.Net CIM Gateway: by SkyVerge – 2.10.1
WooCommerce PDF Invoice: by RightPress – 3.1.7 – Not tested with the active version of WooCommerce
WooCommerce Pretty Emails: by MB Création – 1.8.6 – Not tested with the active version of WooCommerce
WooCommerce Shipment Tracking: by WooCommerce – 1.6.11
WooCommerce Tab Manager: by SkyVerge – 1.9.1
WooCommerce: by Automattic – 3.4.5
Yoast SEO Premium: by Team Yoast – 8.1
WP Crontrol: by John Blackbourn & contributors – 1.6.2
WP-Lister Pro for eBay: by Matthias Krok – 2.0.17
WP Mail SMTP: by WPForms – 1.3.3
Yoast SEO: WooCommerce: by Team Yoast – 8.1 – Not tested with the active version of WooCommerce
YITH Custom ThankYou Page for Woocommerce Premium: by YITHEMES – 1.0.8
YITH WooCommerce Brands Add-on Premium: by Yithemes – 1.2.2
YITH WooCommerce Dynamic Pricing and Discounts Premium: by YITHEMES – 1.4.5
Yuspify Recommendation Engine: by Gravity Inc – 1.3.12

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
gift-card (gift-card)
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)

### WC Pages ###

Shop base: #43 – /shop/
Cart: #44 – /cart/
Checkout: #45 – /checkout/
My account: #46 – /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Divi
Version: 3.13.1
Author URL: https://www.elegantthemes.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: /var/www/html/wp-content/plugins/divi_woo_layout_injector/includes/empty.php version – is out of date. The core version is 3.1.0
/var/www/html/wp-content/plugins/divi_woo_layout_injector/includes/empty.php version – is out of date. The core version is 3.4.0
/var/www/html/wp-content/plugins/divi_woo_layout_injector/includes/empty.php version – is out of date. The core version is 2.3.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/admin-cancelled-order.php version 2.3.0 is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/admin-failed-order.php
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/admin-new-order.php version 2.0.0 is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-completed-order.php version 1.6.4 is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-invoice.php version 2.2.0 is out of date. The core version is 3.3.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-new-account.php
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-note.php version 1.6.4 is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-on-hold-order.php version – is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-processing-order.php version 1.6.4 is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-refunded-order.php version 2.4.0 is out of date. The core version is 2.5.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/customer-reset-password.php
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/email-addresses.php version 2.2.0 is out of date. The core version is 3.2.1
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/email-customer-details.php
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/email-footer.php version 2.0.0 is out of date. The core version is 2.3.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/email-header.php version 1.0 is out of date. The core version is 2.4.0
/var/www/html/wp-content/plugins/woocommerce-pretty-emails/emails/email-order-items.php version 2.1.2 is out of date. The core version is 3.4.0

Outdated Templates: ?

Learn how to update

### WooCommerce Google Product Feed fields ###

Availability: Defaults to “in stock”.
Brand: Pre-populates from “yith_product_brand taxonomy”.
Manufacturer Part Number (MPN): Pre-populates from “sku taxonomy”.
Product Type: Pre-populates from “product_cat taxonomy”.
Age Group: Defaults to “adult”.
Minimum handling time:
Maximum handling time: Defaults to “1”.

### WooCommerce Google Product Feed options ###

Include variations in feed: No
Send item_group_id: No

### Authorize.Net CIM ###

Environment: Production
Tokenization Enabled: ?
Debug Mode: Off
Webhooks Enabled: ?
No signature key configured