Import products to your WooCommerce store using CSV

Last updated on May 8, 2023

WooCommerce Product Import Export Plugin helps to import the products and its related data stored in a CSV format. We can import thousands of products using a single file in an efficient manner.

To begin, download, install and activate the plugin.

Steps to import

It is advised to use the Sample Product CSV.

From the WordPress admin panel, navigate to the menu: WebToffee Import Export (Pro).
Click on Import and specify the post type as Product.
Select your import method and Import from location.
Click to upload or simply drag and drop your CSV file.
Note: One can only upload the supported CSV or XML file formats. All other file formats will appear as disabled.
Click on Step3 and follow the steps in How to import products to finish.

Simple Product

The simple product – Samsung Galaxy Ace Duos is imported to WooCommerce as specified in the CSV.

Variable Product

The variable product – Men’s Cotton T-Shirt is imported to WooCommerce with two variations – blue and red as specified in the CSV.
Variation_Product1

Know more about other features of the plugin.

Was this article helpful?
Yes, thanks!Not really

This article posted in Documentation, Import, Knowledge Base, Product Import Export Plugin for WooCommerce

Written by

WebToffee Team

WebToffee Team is a group of WordPress and WooCommerce enthusiasts consisting of expert developers, testing engineers, technical support engineers, and SMEs.

Comments (4)

Ellen Manjati

December 9, 2021

https://batteryhero.co.za/pre/?s=Deltec612&post_type=product – when i import them all tag headers shows on the post_title how to fix this

Reply
- Alan
  
  December 14, 2021
  
  Hi,
  Please make sure that you provide the data in the correct columns and is mapped to the corresponding fields. If you are still having any issues then please share the file via support.
  
  Reply
Susan Wilkinson

November 12, 2019

I can’t seem to get the following to import:
269,EW-OSF-0000010882-NATURL-2000,10882,NATURL,10882 NATURAL 3 1/4 20 SQFT , , ,8286915-16 ,1100,0,1100,Y,1,OVERSTOCK FLOORZ , ,P,SQFT, ,”10882 NATURAL 3 1/4 20 SQFT \n\n[advanced_iframe securitykey=””undefined”” src=””http://205.144.221.180/osf/showdetails.php%3Fitem=EW&style=10882&color=NATURL width=100%”” height=””600″”]”””,ENGINEERED WOOD > 10882

I have a feeling that the problem is in the html link, but I have to be able to import that into my short description field in order to include information stored on another server.
Tha file should be encoded correctly.
Can someone help me find the problem in the data?

Reply
- Mark
  
  November 12, 2019
  
  Hi,
  
  Please submit a ticket via support link above with the CSV file attached.
  
  Reply

Cookie	Description
__cfruid	Cloudflare sets this cookie to identify trusted web traffic.
__stripe_mid	Stripe sets this cookie cookie to process payments.
__stripe_sid	Stripe sets this cookie cookie to process payments.
cookielawinfo-checkbox-advertisement	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analytics	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Analytics" category .
cookielawinfo-checkbox-necessary	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Necessary" category .
cookielawinfo-checkbox-preferences	This cookie is set by the GDPR Cookie Consent plugin to check if the user has given consent to use cookies under the "Preferences" category.
CookieLawInfoConsent	Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
PHPSESSID	This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policy	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.

Cookie	Description
_ga	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_ga_BQH8MSKD4M	This cookie is installed by Google Analytics.
_gat_gtag	Identification code of website for tracking visits.
_gid	This cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjAbsoluteSessionInProgress	Hotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.
_hjFirstSeen	Hotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.
_hjid	Hotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInPageviewSample	Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.
_hjIncludedInSample	This cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
_hjIncludedInSessionSample	Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.
_hjTLDTest	To determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.
CONSENT	YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
has_recent_activity	This cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_ai	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lr	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_or	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qs	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
VISITOR_INFO1_LIVE	A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSC	YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devices	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-id	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.

Cookie	Duration	Description
_hjSession_1376571	30 minutes	No description
_hjSessionUser_1376571	1 year	No description
_octo	1 year	No description available.
_zendesk_authenticated	past	No description
_zendesk_session	session	No description available.
_zendesk_shared_session	session	No description available.
edd_wp_session	12 hours	No description available.
logged_in	1 year	No description available.
m	2 years	No description available.

Import products to your WooCommerce store using CSV

Steps to import

Simple Product

Variable Product

Written by

Comments (4)

Got any query? Please leave a comment or reach out to our support
Cancel reply

Got any query? Please leave a comment or reach out to our support

Our plugins

Import products to your WooCommerce store using CSV

Steps to import

Simple Product

Variable Product

Written by

Comments (4)

Got any query? Please leave a comment or reach out to our support Cancel reply

Got any query? Please leave a comment or reach out to our support

Got any query? Please leave a comment or reach out to our support
Cancel reply