Woocommerce Importer Error

Hi @mrk11114210

Thanks for reaching out.

I understand the products are not showing up although it said importing was successful.

As a first step please make sure you are using the correct format for the CSV. You can download a sample CSV file here: https://github.com/woocommerce/woocommerce/tree/master/sample-data

If you have products that work properly, the easiest way would be to export those existing products, replace the values, and import back into your store. That way you’ll have a CSV with the correct formatting to use as a template.

By Woo commerce exporter are you referring to a plugin that you are using? Or are you using the built-in product CSV Importer Exporter? Here’s its documentation for you to refer to: https://docs.woocommerce.com/document/product-csv-importer-exporter/

Should you need us to take a closer look, please share the following:
1. your CSV file (you can use Google Drive/Drobox or any online file-sharing service, and share the link here)
2. your site’s System Status

“If you have products that work properly, the easiest way would be to export those existing products, replace the values, and import back into your store. That way you’ll have a CSV with the correct formatting to use as a template.”
Yes I have done the same.

1. CSV File:
https://drive.google.com/file/d/1zz868jna0Faqrxcv5-3a1LSf0H61ZmLN/view?usp=sharing
2: System Stats
https://drive.google.com/file/d/1r8aVGFFsMsB00OAbOqizFXUIZWMbPeGj/view?usp=sharing

Sorry Attached the wrong csv i am using the below file

https://drive.google.com/file/d/10MtERn8YYyvKPFMzlhxT2UtKnC9Fb0Wm/view?usp=sharing

Also i am not using any plugin, I am using the built-in product CSV Importer Exporter

Hi there!

Were you able to confirm that it works as expected if you try importing using our sample data?

Also, I see that you shared an image of your status page. Could you share your current System Status Report? You can get it by navigating to WP Admin > WooCommerce > Status. Once there, click on the “Get system report” button and then copy it by clicking on the “Copy for support” button.

Well worked fine with the sample data
But please tell me the error in my uploaded file
https://drive.google.com/file/d/10MtERn8YYyvKPFMzlhxT2UtKnC9Fb0Wm/view?usp=sharing

Hi @mrk11114210,

It seems that your CSV file doesn’t have the correct format for variations.

This is your file where IDs and variation names are missing.

and below you can see my result of a test CSV export for the same variable product.

As mentioned earlier by @margaretwporg make sure you are following the correct format for your CSV. You can download a sample CSV file here and see how it’s set up.

https://github.com/woocommerce/woocommerce/tree/master/sample-data

For more information on how to correctly add a variable product in the admin product page please refer to this support guide.

https://woocommerce.com/document/variable-product/#adding-a-variable-product

Best regards.

Well actually I am little confused about ID I have thought that woo commerce will generate product ID so I left it blank.

Well I hae matched my file as the sample files corrected some errors too but it still not working

Here is the new file that I am uploading
https://drive.google.com/file/d/1JD2q_mcbvz7KWg4rCo1TcxK9AeNDb8nB/view?usp=sharing

My System Stats

### WordPress Environment ###

WordPress address (URL): https://localhost/lionjeans
Site address (URL): https://localhost/lionjeans
WC Version: 6.5.1
REST API Version: ? 6.5.1
WC Blocks Version: ? 7.4.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.53 (Win64) OpenSSL/1.1.1n PHP/8.1.6
PHP Version: 8.1.6
PHP Post Max Size: 40 MB
PHP Time Limit: 0
PHP Max Input Vars: 1000
cURL Version: 7.77.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 10.4.24-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: 6.5.1
WC Database Prefix: wp_
Total Database Size: 24.43MB
Database Data Size: 19.94MB
Database Index Size: 4.49MB
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.11MB + Index: 0.14MB + 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.08MB + Index: 0.03MB + Engine InnoDB
wp_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 8.02MB + Index: 0.08MB + Engine InnoDB
wp_postmeta: Data: 5.44MB + Index: 0.97MB + Engine InnoDB
wp_posts: Data: 1.50MB + Index: 0.09MB + 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.05MB + 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_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + 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_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_entry_fields: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpforms_entry_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 100
custom_css: 5
customize_changeset: 5
elementor_library: 2
mailpoet_page: 1
nav_menu_item: 13
page: 9
post: 2
product: 35
product_variation: 14
revision: 34
shop_coupon: 1
shop_order: 2
stocktend_object: 244
stocktend_tryst: 2
wpforms: 1

### Security ###

Secure connection (HTTPS): ?
					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ?

### Active Plugins (19) ###

Astra Pro: by Brainstorm Force – 3.6.8
Premium Starter Templates: by Brainstorm Force – 3.1.10
Elementor Pro: by Elementor.com – 3.7.1
Elementor: by Elementor.com – 3.6.5
Google Listings and Ads: by WooCommerce – 1.13.2
Elementor Header & Footer Builder: by Brainstorm Force
Nikhil Chavan – 1.6.11

Jetpack: by Automattic – 10.9.1
MailPoet 3 (New): by MailPoet – 3.89.3
Profitori: by Unity Business Technology Pty Ltd – 2.0.4.1
The Plus Addons for Elementor: by POSIMYTH – 5.0.9
The Plus Addons for Elementor - Pro: by POSIMYTH – 5.0.10
Ultimate Addons for Elementor: by Brainstorm Force – 1.36.6
WooCommerce Address Book: by Hall Internet Marketing – 2.1.2
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.17
Woo Custom and Sequential Order Number: by VJInfotech – 2.6.0
WooCommerce GST: by Stark Digital – 1.3
WooCommerce: by Automattic – 6.5.1
WPC AJAX Add to Cart for WooCommerce: by WPClever – 1.5.0
WPForms: by WPForms – 1.7.4

### Inactive Plugins (2) ###

WooCommerce Custom Product Addons (Free): by Acowebs – 2.6.3
WooCommerce Wholesale Discount: by Minerva Infotech – 1.3

### Settings ###

API Enabled: –
Force SSL: –
Currency: INR (?)
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: –
Enforce Approved Product Download Directories: ?

### WC Pages ###

Shop base: #401 - /shop/
Cart: #97 - /cart/
Checkout: #98 - /checkout/
My account: #99 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Astra
Version: 3.8.1
Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
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: 253
Oldest: 2022-05-25 09:09:11 +0000
Newest: 2022-05-27 04:49:04 +0000

Failed: 1
Oldest: 2022-05-26 08:44:53 +0000
Newest: 2022-05-26 08:44:53 +0000

Pending: 7
Oldest: 2022-05-27 09:09:48 +0000
Newest: 2022-06-01 09:09:11 +0000

### Status report information ###

Generated at: 2022-05-27 04:50:48 +00:00

Hey Everyone thanks for your support and replies. I have found where I am missing actually I have set the value “Variation” in type instead of “Variable” for the parent product too. That’s where I am missing. Thanks Everyone.

Glad to hear that the issue is resolved!

I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.

• This reply was modified 2 years, 6 months ago by Daniel N. (woo-hc).