Import Error in localhost

Error image from WP Backend

Please find the image attached for error.

Hi @aishwaryataneja85,

We will check the issue and get back to you.

Is it possible to get a solution for the same?

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.

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

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

Same error with your file.

Please check the screenshot.

View post on imgur.com

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

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.

### WordPress Environment ###

WordPress address (URL): https://localhost/vipnumber
Site address (URL): https://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

Hello.

Can we expect solution for the same?

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.