• Resolved Aishwarya Taneja

    (@aishwaryataneja85)


    Hello,
    I am trying to upload products in localhost and end up with the following error.

    Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\vipnumber\wp-content\plugins\product-import-export-for-woo\includes\importer\views\html-wf-import-options.php on line 53

    Can any one help me with the error.

Viewing 12 replies - 1 through 12 (of 12 total)
  • Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    Error image from WP Backend

    Please find the image attached for error.

    Plugin Author WebToffee

    (@webtoffee)

    Hi @aishwaryataneja85,

    We will check the issue and get back to you.

    Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    Is it possible to get a solution for the same?

    Plugin Author WebToffee

    (@webtoffee)

    Hi @aishwaryataneja85,

    It seems like the issue you are facing is because your CSV file is not opening during import. Could you please share your CSV file by uploading it to Google drive or any other similar services and share us the link. Or else you may please share it via support.

    Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    If its issue with CSV file then didn’t we have any msg showing error in CSV file so that the user can know that.

    We also need to provide a CSV file sample so that user can have it and easily proceed with the work.

    Here is the sample file I used for import.

    https://drive.google.com/open?id=1xkXse-A_6R3xAQxPM2JpM351Svzl7G5A

    Plugin Author WebToffee

    (@webtoffee)

    Hi @aishwaryataneja85,

    We tried importing your CSV file in our test environment and were unable to reproduce the issue. Could you please try importing our sample CSV file on your site and tell us whether the issue persists or not. Here is the link to the sample CSV file:https://www.webtoffee.com/wp-content/uploads/2017/05/Product_WooCommerce_Sample_CSV.csv

    Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    Same error with your file.

    Please check the screenshot.

    View post on imgur.com

    Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    I would like to add a thing that this is an issue in the localhost only (xampp).
    so please help me for the same.

    Plugin Author WebToffee

    (@webtoffee)

    Hi @aishwaryataneja85,

    Could you please share with us the System status report(WooCommerce > Status>Get system report). Also please mention the version of Woocommerce, Product import-export plugin, and WordPress installed on your site so that we can set up the same with XAMPP.

    Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    
    ### WordPress Environment ###
    
    WordPress address (URL): http://localhost/vipnumber
    Site address (URL): http://localhost/vipnumber
    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 - There is a newer version of WordPress available (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: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.3.11
    PHP Version: 7.3.11
    PHP Post Max Size: 40 MB
    PHP Time Limit: 3600
    PHP Max Input Vars: 1000
    cURL Version: 7.64.0
    OpenSSL/1.1.1c
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.4.8-MariaDB
    Max Upload Size: 40 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 4.0.1
    WC Database Prefix: wp_
    Total Database Size: 20.50MB
    Database Data Size: 17.73MB
    Database Index Size: 2.77MB
    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_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_itsec_logs: Data: 1.52MB + Index: 0.09MB + Engine InnoDB
    wp_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_itsec_temp: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 2.09MB + Index: 0.06MB + Engine InnoDB
    wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 9.52MB + Index: 0.16MB + Engine InnoDB
    wp_posts: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
    wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_sc_analytics: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_simple_history: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
    wp_simple_history_contexts: Data: 1.52MB + Index: 0.53MB + 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: 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.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_wpie_export_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmagic_org_ypq_contacts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wpmagic_org_ypq_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpmagic_org_ypq_events: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    wp_wpmagic_org_ypq_public_ids: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 76
    custom_css: 1
    customize_changeset: 1
    elementor_library: 3
    nav_menu_item: 7
    page: 11
    product: 15
    revision: 173
    shop_coupon: 1
    shop_order: 1
    wp_block: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (13) ###
    
    Accelerated Mobile Pages: by Ahmed Kaludi
    Mohammed Kaludi – 1.0.39
    
    Classic Editor: by WordPress Contributors – 1.5
    CommerceGurus Commercekit: by CommerceGurus – 1.0.0
    Elementor Pro: by Elementor.com – 2.9.2
    Elementor: by Elementor.com – 2.9.7
    Kirki Customizer Framework: by Ari Stathopoulos (@aristath) – 3.1.1
    Product CSV Import Export (BASIC): by WebToffee – 1.7.7 – Not tested with the active version of WooCommerce
    Rank Math SEO: by Rank Math – 1.0.41.2
    Simple History: by Pär Thernström – 2.33.2
    Site Magic: by WPgeeks.org – 0.5.3 – Not tested with the active version of WooCommerce
    Smart WooCommerce Search: by YummyWP – 1.5.14 – Not tested with the active version of WooCommerce
    Razorpay for WooCommerce: by Team Razorpay – 2.4.1 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 4.0.1
    
    ### Inactive Plugins (2) ###
    
    WP All Import - WooCommerce Add-On: by Soflyy – 1.4.4 – Not tested with the active version of WooCommerce
    YITH WooCommerce Bulk Product Editing Premium: by YITH – 1.2.21 – Not tested with the active version of WooCommerce
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: INR (₹)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 0
    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: #6543 - /vip-numbers/
    Cart: #6544 - /cart/
    Checkout: #6545 - /checkout/
    My account: #6546 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Shoptimizer
    Version: 2.0.0
    Author URL: https://www.commercegurus.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 ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 3
    Oldest: 2020-04-13 12:13:41 +0000
    Newest: 2020-04-17 07:39:46 +0000
    
    

    Woocommerce – Version 4.0.1
    Product Import – Export – Version 1.7.7
    WordPress – Version 5.4

    Thread Starter Aishwarya Taneja

    (@aishwaryataneja85)

    Hello.

    Can we expect solution for the same?

    Plugin Author WebToffee

    (@webtoffee)

    Hi @aishwaryataneja85,

    We are able to import products in XAMPP with WordPress 5.4.2 and Woocommerce 4.2. Please try updating the plugin to the latest version and try importing.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Import Error in localhost’ is closed to new replies.