Need help with uploading a csv file into woocommerce with product variations, lost..

Hello experts,

Have a csv with product variations, and having trouble uploading it.  Could you see the attached files, and advise the correct way to setup the csv file for bulk upload into woocommerce, using the product import suite?

Kind regards
Kasonde NeddyDesigner & DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Check if content of your column

should be e.g:

Attributes, relevant for product variations, support multiple items.
Separate these with a pipe “|” character.

According to WooCommerce documentation:
Create a product with all of the information you are going to use
Export this product (make sure you tick the hidden fields check box)
Open the exported CSV file and delete the product ID column

Now you have the perfect CSV file template for your shop

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kasonde NeddyDesigner & DeveloperAuthor Commented:
Pointed me in the right direction, thanks for this!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.