• Resolved cion3

    (@cion3)


    I’m trying to import my customers using the historical data tool but every time it’s stuck at finalizing. I have contacted my hosting they don’t see any error on my servers side, i have checked the woocommerce logs i don’t see anything there.

    It seems really strange besides the fact i don’t get any error the import process never completes.
    Any help will be really appreciated!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    Just to make sure: Have you checked that CRON is working as expected on your server? Are you seeing any failed/cancelled/pending actions under **WooCommerce > Status > Scheduled Actions**?

    If you can share a copy of your status report as found at **WooCommerce > Status**, that’d be great as well ??

    Thanks!

    Thread Starter cion3

    (@cion3)

    Thanks for your quick reply!
    I see this error on the scheduled actions

    https://prnt.sc/so5o0i

    System report

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://uberbracelets.com
    Site address (URL): https://uberbracelets.com
    WC Version: 4.1.1
    REST API Version: ? 1.0.7
    WC Blocks Version: ? 2.5.16
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 1.1.3
    Log Directory Writable: ?
    WP Version: 5.4.1
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.4
    PHP Post Max Size: 32 MB
    PHP Time Limit: 3000
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.44
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.4.12-MariaDB
    Max Upload Size: 32 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 4.2.0
    WC Database Prefix: wp_
    Total Database Size: 265.45MB
    Database Data Size: 150.99MB
    Database Index Size: 114.46MB
    wp_woocommerce_sessions: Data: 1.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: 2.52MB + Index: 0.47MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 8.52MB + Index: 8.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.06MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sib_model_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 12.52MB + Index: 12.59MB + 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: 8.52MB + Index: 7.03MB + Engine InnoDB
    wp_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aepc_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bwfan_abandonedcarts: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_bwfan_automationmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_bwfan_automations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_bwfan_contact_automations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_bwfan_logmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_bwfan_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_bwfan_message_unsubscribe: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_bwfan_syncrecords: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_bwfan_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_bwfan_tasks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_bwfan_task_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_bwf_actions: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_bwf_action_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_bwf_contact: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_bwf_contact_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bwf_wc_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 2.50MB + Index: 1.33MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mo2f_network_blocked_ips: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mo2f_network_email_sent_audit: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mo2f_network_transactions: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
    wp_mo2f_network_whitelisted_ips: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mo2f_user_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mo2f_user_login_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_field_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 2.22MB + Index: 0.08MB + Engine InnoDB
    wp_postmeta: Data: 63.59MB + Index: 25.03MB + Engine InnoDB
    wp_posts: Data: 2.52MB + Index: 2.44MB + Engine InnoDB
    wp_pprh_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_s2w_error_product_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_shipment_batch_process: 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.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 37.58MB + Index: 49.11MB + Engine InnoDB
    wp_users: Data: 3.52MB + Index: 4.55MB + 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: 2.52MB + Index: 1.16MB + Engine InnoDB
    wp_wc_order_stats: Data: 1.52MB + Index: 0.78MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + 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
    wp_wfco_connectormeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wfco_connectors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wfco_report_views: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfob_stats: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_wfocu_event: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfocu_event_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfocu_session: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woo_shippment_provider: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wpns_attack_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpns_backup_report: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpns_files_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpns_ip_rate_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpns_malware_hash_file: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpns_malware_scan_report: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpns_malware_scan_report_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpns_malware_skip_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 36
    custom_css: 2
    nav_menu_item: 9
    nf_sub: 1
    page: 14
    post: 3
    product: 22
    shop_coupon: 4
    shop_order: 9704
    wfacp_checkout: 5
    wfob_bump: 1
    wfocu_funnel: 2
    wfocu_offer: 2
    wpcf7_contact_form: 1
    xlwcty_thankyou: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (1) ###
    
    WooCommerce: by Automattic – 4.1.1
    
    ### Inactive Plugins (27) ###
    
    Advanced Shipment Tracking for WooCommerce: by zorem – 2.9.9.5
    AeroCheckout: Custom WooCommerce Checkout Pages: by WooFunnels – 2.0.5
    Autonami Marketing Automations For WordPress: by BuildWooFunnels – 1.1.1
    Coming Soon Page, Under Construction & Maintenance Mode by SeedProd: by SeedProd – 5.1.0
    Contact Form 7: by Takayuki Miyoshi – 5.1.9
    Disable Cart Fragments: by Optimocha – 1.21 – Installed version not tested with active version of WooCommerce 4.1.1
    Flying Scripts by WP Speed Matters: by Gijo Varghese – 1.1.7
    Free Shipping Bar for WooCommerce: by VillaTheme – 1.1.4.1 – Installed version not tested with active version of WooCommerce 4.1.1
    GA Google Analytics: by Jeff Starr – 20200325
    Hide Shipping Method For WooCommerce: by theDotstore – 1.0.1 – Installed version not tested with active version of WooCommerce 4.1.1
    Kadence WooCommerce Email Designer: by Kadence WP – 1.4.1 – Installed version not tested with active version of WooCommerce 4.1.1
    miniOrange 2 Factor Authentication: by miniOrange – 5.4.5
    Multi Currency for WooCommerce: by VillaTheme – 2.1.5.2
    NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.12.0 – Installed version not tested with active version of WooCommerce 4.1.1
    OrderBumps: WooCommerce Checkout Offers: by WooFunnels – 1.8.1 – Installed version not tested with active version of WooCommerce 4.1.1
    Pixel Caffeine: by AdEspresso – 2.1.2 – Installed version not tested with active version of WooCommerce 4.1.1
    Pre* Party Resource Hints: by Sam Perrow – 1.7.1
    Reamaze Helpdesk for WordPress: by The Reamaze Team – 1.1.0
    S2W - Import Shopify to WooCommerce Premium: by VillaTheme – 1.0.9.5
    Sequential Order Numbers for WooCommerce: by WebToffee – 1.2.1 – Installed version not tested with active version of WooCommerce 4.1.1
    ShortPixel Adaptive Images: by ShortPixel – 1.8.7
    Stripe Payment Gateway for WooCommerce: by WebToffee – 3.2.9 – Installed version not tested with active version of WooCommerce 4.1.1
    UpStroke: WooCommerce One Click Upsells: by buildwoofunnels – 2.1.7 – Installed version not tested with active version of WooCommerce 4.1.1
    WP Crontrol: by John Blackbourn & crontributors – 1.8.3
    WP Mail SMTP: by WPForms – 2.0.1
    WP Rocket: by WP Media – 3.5.5.1
    WP Rollback: by Impress.org – 1.7.0
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### 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)
    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: #8 - /shop/
    Cart: #9 - /cart/
    Checkout: #10 - /checkout/
    My account: #11 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ?
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.11.3
    Parent Theme Author URL: https://www.uxthemes.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-product_cat.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome/woocommerce/emails/customer-invoice.php
    flatsome/woocommerce/emails/customer-processing-order.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    
    ### Action Scheduler ###
    
    Complete: 42,280
    Oldest: 2020-05-16 14:11:13 +0000
    Newest: 2020-05-26 10:20:47 +0000
    
    Failed: 1
    Oldest: 2020-05-26 14:21:24 +0000
    Newest: 2020-05-26 14:21:24 +0000
    
    Pending: 1
    Oldest: 2020-05-31 15:33:00 +0000
    Newest: 2020-05-31 15:33:00 +0000

    `

    • This reply was modified 4 years, 6 months ago by cion3.
    • This reply was modified 4 years, 6 months ago by cion3.
    • This reply was modified 4 years, 6 months ago by Steven Stern (sterndata).
    jessepearson

    (@jessepearson)

    Automattic Happiness Engineer

    @cion3 Were you able to get this to work?

    In looking at the screenshot it looks like the action failed, which may have been due to a data migration. If you run the sync now does it complete?

    jessepearson

    (@jessepearson)

    Automattic Happiness Engineer

    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, a new thread can be opened.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import Historical Data stucked’ is closed to new replies.