Support » Plugin: WooCommerce » Default CSV product import export limited

  • Resolved olcoil

    (@olcoil)


    We have roughly 4000 products and tried the default woocommerce CSV import/export feature. Export seems to work fine. However, when importing to a new site, it more or less just “freezes” (see attached). Refreshing the page then kicks me back to the Import screen. Then I find out I only had 400 products imported!

    Tested on two major themes and both failed w the WooCommerce feature. We have an enterprise level house w Kinsta so I don’t think server is the issue. What could it be? PHP versions?

    Here is our woocomm log:

    
    ### WordPress Environment ###
    
    WordPress address (URL): http://protheme1.kinsta.cloud
    Site address (URL): http://protheme1.kinsta.cloud
    WC Version: 4.0.1
    REST API Version: ✔ 1.0.7
    WC Blocks Version: ✔ 2.5.14
    Action Scheduler Version: ✔ 3.1.4
    WC Admin Version: ✔ 1.0.3
    Log Directory Writable: ✔
    WP Version: 5.4
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: nginx/1.17.10
    PHP Version: 7.3.16-1+ubuntu16.04.1+deb.sury.org+1
    PHP Post Max Size: 128 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.47.0
    OpenSSL/1.0.2g
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.4.12-MariaDB-1:10.4.12+maria~xenial-log
    Max Upload Size: 128 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 4.0.1
    WC Database Prefix: wp_
    Total Database Size: 19.74MB
    Database Data Size: 12.02MB
    Database Index Size: 7.72MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_categorymeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_member_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 3.02MB + Index: 0.06MB + Engine InnoDB
    wp_portfolio_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 5.08MB + Index: 6.03MB + Engine InnoDB
    wp_posts: Data: 2.47MB + Index: 0.31MB + Engine InnoDB
    wp_product_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.16MB + Index: 0.08MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 557
    block: 11
    customize_changeset: 1
    elementor_library: 2
    nav_menu_item: 115
    page: 57
    post: 7
    product: 525
    product_variation: 67
    revision: 26
    shop_order: 1
    wpcf7_contact_form: 6
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (23) ###
    
    Admin Menu Editor: by Janis Elsts – 1.9.5
    Pojo Device Widget: by Yakir Sitbon
    Ariel Klikstein – 1.1.0
    
    Classic Editor: by WordPress Contributors – 1.5
    Contact Form 7: by Takayuki Miyoshi – 5.1.7
    Webcraftic Disable Admin Notices Individually: by Webcraftic  – 1.1.1
    Duplicate Post: by Enrico Battocchi – 3.2.4
    Dynamic Featured Image: by Ankit Pokhrel – 3.7.0
    Elementor: by Elementor.com – 2.9.8
    FileBird Lite: by Ninja Team – 2.7.1
    Imsanity: by Exactly WWW – 2.6.0
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.1
    PNG to JPG: by KubiQ – 3.9
    Porto Theme - Functionality: by P-Themes – 1.6.0
    Redirect 404 Error Page to Homepage: by ProThoughts.com – 1.0
    Slider Revolution: by ThemePunch – 6.1.8
    Temporary Login Without Password: by StoreApps – 1.6.1
    Visual Composer: by visualcomposer.com – 26.0
    WooCommerce Order Navigation: by FullStack – 1.0.0 – Not tested with the active version of WooCommerce
    Woo Stickers by Webline: by Weblineindia – 1.1.2
    WooCommerce - ShipStation Integration: by WooCommerce – 4.1.35
    WooCommerce: by Automattic – 4.0.1
    WP Sitemap Page: by Tony Archambeau – 1.6.2
    WPS Hide Login: by WPServeur
    NicolasKulka
    tabrisrp – 1.5.6
    
    ### Inactive Plugins (0) ###
    
    ### Must Use Plugins (1) ###
    
    Kinsta Must-use Plugins: by Kinsta Team – 2.3.3
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: CAD ($)
    Currency Position: left
    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 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Porto Child
    Version: 1.1
    Author URL: https://www.portotheme.com/
    Child Theme: ✔
    Parent Theme Name: Porto
    Parent Theme Version: 5.3.0
    Parent Theme Author URL: http://www.portotheme.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: porto/woocommerce/archive-product.php
    porto/woocommerce/cart/cart-shipping.php
    porto/woocommerce/cart/cart-totals.php
    porto/woocommerce/cart/cart.php
    porto/woocommerce/cart/cross-sells.php
    porto/woocommerce/cart/mini-cart.php
    porto/woocommerce/cart/proceed-to-checkout-button.php
    porto/woocommerce/cart/shipping-calculator.php
    porto/woocommerce/checkout/form-billing.php
    porto/woocommerce/checkout/form-checkout.php
    porto/woocommerce/checkout/form-coupon.php
    porto/woocommerce/checkout/form-login.php
    porto/woocommerce/checkout/form-pay.php
    porto/woocommerce/checkout/payment.php
    porto/woocommerce/checkout/review-order.php
    porto/woocommerce/content-product.php
    porto/woocommerce/content-product_cat.php
    porto/woocommerce/content-single-product.php
    porto/woocommerce/content-widget-product.php
    porto/woocommerce/global/form-login.php
    porto/woocommerce/global/quantity-input.php
    porto/woocommerce/global/wrapper-start.php
    porto/woocommerce/loop/add-to-cart.php
    porto/woocommerce/loop/loop-end.php
    porto/woocommerce/loop/loop-start.php
    porto/woocommerce/loop/no-products-found.php
    porto/woocommerce/loop/orderby.php
    porto/woocommerce/loop/pagination.php
    porto/woocommerce/loop/rating.php
    porto/woocommerce/loop/sale-flash.php
    porto/woocommerce/myaccount/downloads.php
    porto/woocommerce/myaccount/form-add-payment-method.php
    porto/woocommerce/myaccount/form-edit-account.php
    porto/woocommerce/myaccount/form-edit-address.php
    porto/woocommerce/myaccount/form-login.php
    porto/woocommerce/myaccount/form-lost-password.php
    porto/woocommerce/myaccount/form-reset-password.php
    porto/woocommerce/myaccount/lost-password-confirmation.php
    porto/woocommerce/myaccount/my-account.php
    porto/woocommerce/myaccount/my-address.php
    porto/woocommerce/myaccount/my-downloads.php
    porto/woocommerce/myaccount/my-orders.php
    porto/woocommerce/myaccount/orders.php
    porto/woocommerce/myaccount/payment-methods.php
    porto/woocommerce/myaccount/view-order.php
    porto/woocommerce/order/form-tracking.php
    porto/woocommerce/order/tracking.php
    porto/woocommerce/single-product/add-to-cart/simple.php
    porto/woocommerce/single-product/add-to-cart/variable.php
    porto/woocommerce/single-product/meta.php
    porto/woocommerce/single-product/product-attributes.php
    porto/woocommerce/single-product/product-image.php
    porto/woocommerce/single-product/product-thumbnails.php
    porto/woocommerce/single-product/rating.php
    porto/woocommerce/single-product/related.php
    porto/woocommerce/single-product/review-meta.php
    porto/woocommerce/single-product/review-rating.php
    porto/woocommerce/single-product/review.php
    porto/woocommerce/single-product/sale-flash.php
    porto/woocommerce/single-product/short-description.php
    porto/woocommerce/single-product/tabs/tabs.php
    porto/woocommerce/single-product/title.php
    porto/woocommerce/single-product/up-sells.php
    porto/woocommerce/single-product-reviews.php
    
    ### Action Scheduler ###
    
    Complete: 8
    Oldest: 2020-04-22 22:28:29 +0000
    Newest: 2020-04-26 19:43:32 +0000
    
    
Viewing 3 replies - 1 through 3 (of 3 total)
  • olcoil

    (@olcoil)

    oh sorry, here is a screenshot of the freeze:
    https://www.dropbox.com/s/4en192qqs7klg26/Screen%20Shot%202020-04-26%20at%205.23.20%20PM.png?dl=0

    obviously look at others having this problem but it does not seem like they had the exact same issue.

    • This reply was modified 7 months ago by olcoil.
    Plugin Support Tseten D

    (@tibetanitech)

    Hi @olcoil,

    Thank you for sharing your system status report and screenshot along with your support request. That helps!

    I’ve had a look at your system status and there’s nothing in there that stands out as problematic.

    To better understand what’s happening, I’d like to take a look at your site’s logs.

    To find the generated logs:

    1. Go to WooCommerce > Status > Logs
    2. In the top right corner, open the drop-down and select the latest fatal error log, then click view to load it. Here’s what that looks like: https://d.pr/i/tCljQd
    3. Copy/paste the log into your response so we can take a look.

    If there are no fatal error logs, can you try to import products with only WooCommerce plugin and deactivate all the other plugins? Switch your theme to Storefront or Twenty Twenty theme as well. Let us know how it goes.

    Plugin Support dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @olcoil

    It is certainly possible that you have too much data to export in one go with your current server settings.

    Can you try exporting all products but only include the ID and Name? If you can export those without a problem, try adding a few more columns to the export. The more data to export, then the more “work” your site needs to handle.

    I’d recommend speaking to your webhost to increase these three PHP values:

    PHP post max size:
    PHP time limit:
    PHP max input vars:

    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.

    Thanks,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Default CSV product import export limited’ is closed to new replies.