CSV Importer stalls

  • Resolved emelieohara

    (@emelieohara)


    2 years, 8 months ago

    Can anyone help with a stuck importer? Every time I try to import using the WooCommerce product importer (including all troubleshooting attempts), the importer stalls to a stop at 30 of 100+ products. I changed the theme to Storefront and disabled all of my plugins and the installer still stalls. I updated the WooCommerce database and it still stalls. Any insight would be greatly appreciated, thanks in advance!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

  • @emelieohara

    I understand your importer is stalling.

    Could you please 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.

    Thread Starter emelieohara

    (@emelieohara)

    Thanks for having a look, Oyadeyi! Report as follows:

    
### WordPress Environment ###

WordPress address (URL): https://emeliesandbox.cachingdreams.com
Site address (URL): https://emeliesandbox.cachingdreams.com
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.33
PHP Post Max Size: 516 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.81.0
OpenSSL/1.1.1m

SUHOSIN Installed: –
MySQL Version: 5.6.41-84.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: 6.3.1
WC Database Prefix: wpt9_
Total Database Size: 9.16MB
Database Data Size: 6.39MB
Database Index Size: 2.77MB
wpt9_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpt9_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpt9_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpt9_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpt9_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_actionscheduler_actions: Data: 0.17MB + Index: 0.23MB + Engine InnoDB
wpt9_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_actionscheduler_logs: Data: 0.14MB + Index: 0.13MB + Engine InnoDB
wpt9_blc_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpt9_blc_instances: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpt9_blc_links: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpt9_blc_synch: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpt9_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_options: Data: 3.11MB + Index: 0.06MB + Engine InnoDB
wpt9_postmeta: Data: 1.52MB + Index: 0.66MB + Engine InnoDB
wpt9_posts: Data: 0.30MB + Index: 0.06MB + Engine InnoDB
wpt9_statistics_exclusions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_statistics_historical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpt9_statistics_pages: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpt9_statistics_search: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpt9_statistics_useronline: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpt9_statistics_visit: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_statistics_visitor: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpt9_statistics_visitor_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wpt9_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpt9_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpt9_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpt9_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpt9_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpt9_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpt9_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpt9_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpt9_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpt9_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 168
customize_changeset: 20
nav_menu_item: 87
page: 10
post: 2
product: 94
product_variation: 8
revision: 8
wp_global_styles: 1
wpforms: 1

### Security ###

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

### Active Plugins (17) ###

Admin Menu Editor: by Janis Elsts – 1.10
Advanced WordPress Reset: by Younes JFR. – 1.5
All-in-One WP Migration Unlimited Extension: by ServMask – 2.44
All-in-One WP Migration: by ServMask – 7.56
Broken Link Checker: by WPMU DEV – 1.11.16
Facebook for WooCommerce: by Facebook – 2.6.12
Jetpack: by Automattic – 10.7
Media Cleaner: by Jordy Meow – 6.3.1
Image optimization service by Optimole: by Optimole – 3.3.3
Really Simple SSL: by Really Simple Plugins – 5.3.0
WooCommerce Checkout Manager PRO: by QuadLayers – 1.3.6
Checkout Fields Manager for WooCommerce: by QuadLayers – 5.5.5
WooCommerce Payments: by Automattic – 3.8.2
WooCommerce Shipping & Tax: by WooCommerce – 1.25.24
WooCommerce: by Automattic – 6.3.1
WP Statistics: by VeronaLabs – 13.1.7
WPForms Lite: by WPForms – 1.7.3

### Inactive Plugins (1) ###

MainWP Child: by MainWP – 4.1.10

### Must Use Plugins (1) ###

Endurance Page Cache: by Mike Hansen – 2.2

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

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: #7 - /shop/
Cart: #8 - /cart/
Checkout: #9 - /checkout/
My account: #10 - /my-account/
Terms and conditions: #23 - /delivery-returns/

### Theme ###

Name: Almaira Pro
Version: 1.3.0
Author URL: https://www.themehunk.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 ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: –

### Subscriptions ###

WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://emeliesandbox.cachingdreams.com
Subscription Statuses: –
WooCommerce Account Connected: ? No

### Store Setup ###

Country / State: United States (US) — New Mexico

### Payment Gateway Support ###

### WooCommerce Payments ###

Version: 3.8.2
Connected to WPCOM: No
Blog ID: -
Account ID: -

### Action Scheduler ###

Complete: 518
Oldest: 2022-03-06 01:58:45 +0000
Newest: 2022-03-21 18:38:47 +0000

Pending: 3
Oldest: 2022-03-28 18:37:35 +0000
Newest: 2022-03-28 18:37:46 +0000

### Status report information ###

Generated at: 2022-03-21 18:45:06 +00:00
    Mirko P.

    (@rainfallnixfig)

    Hi @emelieohara,

    Thanks for sharing your system status report.

    PHP Version: 7.3.33

    We recommend a PHP version 7.4 or greater. Read more on our server requirements:

    https://woocommerce.com/document/server-requirements/#section-2

    Reach out to your host to change the PHP version. Make sure you have a backup in place before making the change.

    Let us know how it goes.

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    It’s been a while since we last heard back from you. I’m going to mark this thread as resolved.

    Hopefully, you were able to find a way forward with the issue – we’ll be here if and/or when you are ready to continue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘CSV Importer stalls’ is closed to new replies.