• Resolved PIW

    (@dbaldan)


    Hello there.
    I always used the import/export feature with no troubles.
    But now something is not working fine anymore: When I try to import a CSV file, the importer reachs this screen (the last before the FINISH) and doesn’t shows the last screen
    https://imgur.com/a/x6cHpX2

    When I see the product list, I can see the new product there. But since I can’t see the finish screen, I lost the ability to see what gone wrong.

    I’m using WordPress 5.1.1 with Enfold theme.

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hello @dbaldan,

    Sorry to hear about the trouble you’ve run into with the CSV importer recently. You may find some clues as to what’s wrong in the logs. Go to WooCommerce > Status and click on the Logs tab. There is a drop-down at the top where you can select any available logs. Look for fatal error logs from around the date/time when the import was run.

    See if it has any information about what went wrong around the time of the import. Also when the import screen gets stuck, try looking in the JavaScript console to see if there any errors that are reported there. You can find that by going to View > Developer > JavaScript Console in your browser’s menu.

    If you still have trouble, could you please send me 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, you can paste it here.

    Let me know what you find out and we’ll go from there.

    Take care

    Thread Starter PIW

    (@dbaldan)

    Thanks for your reply, @3sonsdevelopment

    I was having an issue with the log folder and I finally fixed it. But the log has no information – it has 0 bytes.

    I had to use a plugin to import the new products, which is not the best idea. I can even export using that plugin, but the template is diffeerent from the one we use. If I try to export using the default export, it doesn’t export all the products (we have 710 and it exports around 50) then it stops, but I never saw the “finished” page.

    Here is the Status:

    
    ### WordPress Environment ###
    
    WordPress address (URL): http://www.primeinterway.com.br
    Site address (URL): http://www.primeinterway.com.br
    WC Version: 3.6.2
    Log Directory Writable: ✔
    WP Version: ❌ 5.1.1 - Há uma nova versão do WordPress disponível (5.2.2)
    WP Multisite: –
    WP Memory Limit: 64 MB
    WP Debug Mode: –
    WP Cron: –
    Language: pt_BR
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.29 (Ubuntu)
    PHP Version: 7.2.19-0ubuntu0.18.04.2
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.58.0
    OpenSSL/1.1.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.27-0ubuntu0.18.04.1-log
    Max Upload Size: 2 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ❌ O seu servidor não possui a classe SoapClient ativada - alguns métodos de pagamento que usam SOAP podem não funcionar como esperado.
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.6.2
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Tamanho total do banco de dados: 650.52MB
    Tamanho dos dados do banco de dados: 294.29MB
    Tamanho do índice do banco de dado: 356.23MB
    wp_woocommerce_sessions: Dados: 20.55MB + Índices: 0.23MB
    wp_woocommerce_api_keys: Dados: 0.02MB + Índices: 0.03MB
    wp_woocommerce_attribute_taxonomies: Dados: 0.02MB + Índices: 0.02MB
    wp_woocommerce_downloadable_product_permissions: Dados: 0.02MB + Índices: 0.06MB
    wp_woocommerce_order_items: Dados: 0.02MB + Índices: 0.02MB
    wp_woocommerce_order_itemmeta: Dados: 0.08MB + Índices: 0.09MB
    wp_woocommerce_tax_rates: Dados: 0.02MB + Índices: 0.06MB
    wp_woocommerce_tax_rate_locations: Dados: 0.02MB + Índices: 0.03MB
    wp_woocommerce_shipping_zones: Dados: 0.02MB + Índices: 0.00MB
    wp_woocommerce_shipping_zone_locations: Dados: 0.02MB + Índices: 0.03MB
    wp_woocommerce_shipping_zone_methods: Dados: 0.02MB + Índices: 0.00MB
    wp_woocommerce_payment_tokens: Dados: 0.02MB + Índices: 0.02MB
    wp_woocommerce_payment_tokenmeta: Dados: 0.02MB + Índices: 0.03MB
    wp_woocommerce_log: Dados: 0.02MB + Índices: 0.02MB
    wp_commentmeta: Dados: 0.02MB + Índices: 0.03MB
    wp_comments: Dados: 0.05MB + Índices: 0.09MB
    wp_icl_content_status: Dados: 0.02MB + Índices: 0.02MB
    wp_icl_core_status: Dados: 0.02MB + Índices: 0.02MB
    wp_icl_flags: Dados: 0.02MB + Índices: 0.02MB
    wp_icl_languages: Dados: 0.02MB + Índices: 0.03MB
    wp_icl_languages_translations: Dados: 0.20MB + Índices: 0.13MB
    wp_icl_locale_map: Dados: 0.02MB + Índices: 0.00MB
    wp_icl_message_status: Dados: 0.02MB + Índices: 0.03MB
    wp_icl_mo_files_domains: Dados: 0.02MB + Índices: 0.02MB
    wp_icl_node: Dados: 0.02MB + Índices: 0.00MB
    wp_icl_reminders: Dados: 0.02MB + Índices: 0.00MB
    wp_icl_strings: Dados: 5.52MB + Índices: 7.03MB
    wp_icl_string_packages: Dados: 0.02MB + Índices: 0.00MB
    wp_icl_string_pages: Dados: 247.80MB + Índices: 338.78MB
    wp_icl_string_positions: Dados: 0.20MB + Índices: 0.08MB
    wp_icl_string_status: Dados: 0.02MB + Índices: 0.02MB
    wp_icl_string_translations: Dados: 5.52MB + Índices: 2.52MB
    wp_icl_string_urls: Dados: 0.27MB + Índices: 0.31MB
    wp_icl_translate: Dados: 0.14MB + Índices: 0.02MB
    wp_icl_translate_job: Dados: 0.02MB + Índices: 0.02MB
    wp_icl_translations: Dados: 0.25MB + Índices: 0.63MB
    wp_icl_translation_batches: Dados: 0.02MB + Índices: 0.00MB
    wp_icl_translation_status: Dados: 0.19MB + Índices: 0.02MB
    wp_layerslider: Dados: 0.02MB + Índices: 0.00MB
    wp_layerslider_revisions: Dados: 0.02MB + Índices: 0.00MB
    wp_links: Dados: 0.02MB + Índices: 0.02MB
    wp_options: Dados: 3.28MB + Índices: 0.20MB
    wp_pmxi_files: Dados: 0.02MB + Índices: 0.00MB
    wp_pmxi_history: Dados: 0.02MB + Índices: 0.00MB
    wp_pmxi_images: Dados: 0.06MB + Índices: 0.00MB
    wp_pmxi_imports: Dados: 0.02MB + Índices: 0.00MB
    wp_pmxi_posts: Dados: 0.02MB + Índices: 0.00MB
    wp_pmxi_templates: Dados: 0.02MB + Índices: 0.00MB
    wp_postmeta: Dados: 6.45MB + Índices: 4.48MB
    wp_posts: Dados: 2.52MB + Índices: 0.50MB
    wp_termmeta: Dados: 0.08MB + Índices: 0.09MB
    wp_terms: Dados: 0.08MB + Índices: 0.09MB
    wp_term_relationships: Dados: 0.13MB + Índices: 0.08MB
    wp_term_taxonomy: Dados: 0.08MB + Índices: 0.09MB
    wp_usermeta: Dados: 0.05MB + Índices: 0.03MB
    wp_users: Dados: 0.02MB + Índices: 0.05MB
    wp_wc_download_log: Dados: 0.02MB + Índices: 0.03MB
    wp_wc_product_meta_lookup: Dados: 0.05MB + Índices: 0.09MB
    wp_wc_webhooks: Dados: 0.02MB + Índices: 0.02MB
    
    ### Post Type Counts ###
    
    attachment: 1244
    avia_framework_post: 32
    customize_changeset: 3
    nav_menu_item: 70
    page: 31
    post: 11
    product: 710
    rdcf7_integrations: 1
    revision: 130
    scheduled-action: 1
    shop_order: 50
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Sua loja não está usando HTTPS. Saiba mais sobre HTTPS e certificados SSL.
    Hide errors from visitors: ✔
    
    ### Active Plugins (25) ###
    
    WPML Multilingual CMS: por OnTheGoSystems – 4.2.7.1
    All in One SEO Pack: por Michael Torbert – 3.1.1
    Click to Chat for WhatsApp: por HoliThemes – 1.6
    Contact Form 7: por Takayuki Miyoshi – 5.1.3
    Development Mode for Jetpack: por Leland Fiegel – 1.0.1
    Jetpack por WordPress.com: por Automattic – 7.2.1
    Kadence WooCommerce Email Designer: por Kadence Themes – 1.2.0
    Tradução (Loco): por Tim Whitlock – 2.2.2
    Perfect WooCommerce Brands: por Alberto de Vera Sevilla – 1.7.6
    Product CSV Import Export (BASIC): por WebToffee – 1.6.5
    SMTP Mailer: por naa986 – 1.0.7
    Checkout Field Editor for WooCommerce: por ThemeHiGH – 1.3.2
    WooCommerce Product Attachment: por Thedotstore – 1.2.2 – Não testado com a versão ativa do WooCommerce
    Product Slider and Carousel with Category for WooCommerce: por WP OnlineSupport – 1.4
    Woo Products Slider Pro: por Sajjad Hossain Sagor – 1.0 – Não testado com a versão ativa do WooCommerce
    Booster for WooCommerce: por Algoritmika Ltd – 4.3.1
    WooCommerce Multilingual: por OnTheGoSystems – 4.6.5
    WooCommerce - Product Importer: por Visser Labs – 1.3.1
    WP All Import - WooCommerce Add-On: por Soflyy – 1.4.2
    WooCommerce: por Automattic – 3.6.2
    WP All Import: por Soflyy – 3.5.1
    Contact Form 7 - reCaptcha v2: por IQComputing – 1.1.9
    WPML String Translation: por OnTheGoSystems – 2.10.5.1
    WPML Translation Management: por OnTheGoSystems – 2.8.6.1
    YITH WooCommerce Request A Quote Premium: por YITH – 2.1.8
    
    ### Inactive Plugins (3) ###
    
    Akismet Anti-Spam: por Automattic – 4.1.1
    FTP Access: por Danial Hatami – 1.0
    Integração RD Station: por RD Station – 4.0.4
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: BRL (R$)
    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 ###
    
    Base da loja: #511 - /shop/
    Carrinho: #512 - /cart/
    Finalizar compra: #28 - /checkout/
    Minha conta: #29 - /my-account/
    Termos e condições: ❌ Página não definida
    
    ### Theme ###
    
    Name: Enfold
    Version: 4.5.6
    Author URL: https://kriesi.at
    Child Theme: ❌ – Recomendamos você utilizar um tema filho no caso de você estiver personalizando o WooCommerce em um tema ascendente. Veja como criar um tema filho
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 0
    Oldest: –
    Newest: –
    
    Pending: 1
    Oldest: 2019-08-29 10:41:38 -0300
    Newest: 2019-08-29 10:41:38 -0300
    
    Canceled: 0
    Oldest: –
    Newest: –
    
    In-progress: 0
    Oldest: –
    Newest: –
    
    Failed: 0
    Oldest: –
    Newest: –
    
    
    Thread Starter PIW

    (@dbaldan)

    An extra information: looks like all ajax functions are having the same issue.
    For example, if I search for a plugin, the working icon never stops and I see no restult – I have to hit F5 to show the results.

    Thanks for looking into that further. Here are a couple of things I would do if this was my site.

    • Look at increasing the memory. It’s possible that with 64mb of memory, the system is running out while processing the import. Your web host can likely help you with that.
    • Set up a staging site. This is a copy of your live site for testing. Once it is set up, try a CSV import and see if it works. If it doesn’t then temporarily disable all plugins except for WooCommerce and use one of the default themes. Try again. If it works, then we’ll know it’s a code conflict.

    Let me know what you uncover and we’ll go from there.

    Cheers

    Plugin Support slash1andy

    (@slash1andy)

    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, you can start a new thread.

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

The topic ‘CSV Import doesn’t finished’ is closed to new replies.