• Resolved AdmiralRob

    (@admiralrob)


    I have a fresh install of wordpress on my bluehost account, and i’ve installed woocommerce and deactivated every other plugin. Unfortunately, when I go to upload my rather small csv (600+ products, 750kb) it hangs and doesn’t upload anything. I’ve literally let it sit overnight just to see if it was taking a long time, but nothing uploaded.


    ### WordPress Environment ###

    WordPress address (URL): https://new.alaskabooksandcalendars.com
    Site address (URL): https://new.alaskabooksandcalendars.com
    WC Version: 7.0.0
    REST API Version: ? 7.0.0
    WC Blocks Version: ? 8.5.1
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.4.28
    PHP Post Max Size: 516 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 1000
    cURL Version: 7.81.0
    OpenSSL/1.1.1n

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

    ### Database ###

    WC Database Version: 7.0.0
    WC Database Prefix: wp22_
    Total Database Size: 10.31MB
    Database Data Size: 7.39MB
    Database Index Size: 2.92MB
    wp22_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp22_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp22_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_actionscheduler_actions: Data: 0.27MB + Index: 0.19MB + Engine InnoDB
    wp22_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_actionscheduler_logs: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
    wp22_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp22_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wp22_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp22_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp22_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp22_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp22_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp22_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp22_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wp22_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_options: Data: 2.44MB + Index: 0.08MB + Engine InnoDB
    wp22_postmeta: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
    wp22_posts: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp22_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp22_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp22_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp22_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp22_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp22_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp22_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp22_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp22_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 38
    mailpoet_page: 1
    page: 7
    post: 2
    product: 54

    ### Security ###

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

    ### Active Plugins (1) ###

    WooCommerce: by Automattic – 7.0.0

    ### Inactive Plugins (9) ###

    Bluehost: by Bluehost – 2.12.9
    Facebook for WooCommerce: by Facebook – 2.6.25
    Google Listings and Ads: by WooCommerce – 2.1.4
    Jetpack: by Automattic – 11.4
    MailPoet: by MailPoet – 3.100.2
    WooCommerce Payments: by Automattic – 4.8.1
    WooCommerce PayPal Payments: by WooCommerce – 1.9.4
    WooCommerce Shipping & Tax: by WooCommerce – 1.26.3
    WPForms Lite: by WPForms – 1.7.7.2

    ### 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: –
    Enforce Approved Product Download Directories: ?

    ### 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: Boutique
    Version: 2.0.17
    Author URL: https://woocommerce.com
    Child Theme: ?
    Parent Theme Name: Storefront
    Parent Theme Version: 4.1.3
    Parent Theme Author URL: https://woocommerce.com/
    WooCommerce Support: ?

    ### Templates ###

    Overrides: –

    ### Admin ###

    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page

    Disabled Features: minified-js
    new-product-management-experience
    settings

    Daily Cron: ? Next scheduled: 2022-10-12 23:22:38 +00:00
    Options: ?
    Notes: 38
    Onboarding: completed

    ### Action Scheduler ###

    Complete: 609
    Oldest: 2022-10-11 23:02:02 +0000
    Newest: 2022-10-12 17:47:53 +0000

    Pending: 1
    Oldest: 2022-10-12 23:22:41 +0000
    Newest: 2022-10-12 23:22:41 +0000

    ### Status report information ###

    Generated at: 2022-10-12 18:05:36 +00:00
    `

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter AdmiralRob

    (@admiralrob)

    Alright, More info on it now:

    It’s the images somehow. the images in my import are listed as simple url. When I tell it not to import that column, it comes through just fine. But if I tell it to use the images, that’s when it stalls out. I’ve got the images in a folder on the same server. like this:

    https://new.alaskabooksandcalendars.com/import/1607894945.jpg

    Any ideas on this?

    Hello,

    I was checking into this, I copied that image from the link you shared, please forgive me for doing that without your permission ??

    Then I added that image to my site media.

    I executed an import and voilà! That worked. You can add the image name to the images CSV column, screenshot example below:


    Link to image: https://snipboard.io/hQdFSW.jpg


    Link to image: https://snipboard.io/yBIDve.jpg

    Hope this helps. Let us know if there are any questions.

    • This reply was modified 2 years, 1 month ago by Igor H.
    • This reply was modified 2 years, 1 month ago by Igor H.
    Thread Starter AdmiralRob

    (@admiralrob)

    Alright, I solved it. The issue was that some of the images were greater than 512kb which was the php limit on the server. So although my list was well below that, SOME of the images were too high and therefore I had to remove those ones before reimporting. Than it all worked.

    Saif

    (@babylon1999)

    Hello @admiralrob,

    Alright, I solved it. The issue was that some of the images were greater than 512kb which was the php limit on the server. So although my list was well below that, SOME of the images were too high and therefore I had to remove those ones before reimporting. Than it all worked.

    Thank you for sharing the solution, this will help whoever lands on the thread in the future. ??

    If you have a few minutes, we’d love it if you could leave us a review: https://www.ads-software.com/support/plugin/woocommerce/reviews/

    Cheers!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import CSV hangs and doesn’t upload anything’ is closed to new replies.