Adding Products to WooCommerce and Manufacturer’s Product Spreadsheet

A few months ago, I reached out to one of our manufacturers to get their products’ information in a spreadsheet form.

Our sales rep came through with the spreadsheet but there were a few caveats. He sent 2 spreadsheets with one having all the product data and another with the the product name and sku. The problem was that I need the sku to be with the product data so I can connect the information together and pull our customer pricing from our internal program that we use.

So after I looked at the spreadsheets, I see that the spreadsheets are from the media company that set up the website. I don’t know what website platform the site is one, but the products on both sheets share a Product ID that the website.

The Product ID on both spreadsheet is the only data that matches the SKU on one spreadsheet to the Product Information on the other Spreadsheet.

From our internal program, the SKU is the only product data that will match to the manufacturer’s products that need to put on our website.

This isn’t a problem.

The solution:

Use the Match and Vlookup formulas in Excel to match the SKU from one spreadsheet to the Product Information and pull the information into one spreadsheet. Then I’ll use the same formulas to match our customer pricing to the spreadsheet.

This will condense the original 3 spreadsheets into 1 spreadsheet.

From there I’ll take that spreadsheet and map the product information to the website import spreadsheet. Upload it and all of the products will be there.

This doesn’t include product pictures or additional information that I’ll upload later. For those, I’ll have a different process.

To make make changes to the product photos I’ll create a script to do it automatically in a program that’s similar to Photoshop. I don’t use Adobe Photoshop at work. (Don’t ask why, it’s complicated.) I use an open-source program that does what I need and then-some. Gimp is similar to Photoshop, the tools and functionality are the same, just the steps are a bit different and the tool are located in different places.

Entrepreneurship + Leadership = Intrapreneurship

Cathy Gray
Strategizing Print & Digital Marketing w/ Business Operations
(and always with coffee in hand)
About | Contact

Entrepreneurs and leaders have been around since the dawn of time. These types of people are the backbone of civilization, the Industrial Revolution and today’s startups.

What is an Intrapreneur?

There is a newer concept in business that focuses on the same principles as entrepreneurship. An intrapreneur is an entrepreneur within a business. An Intrapreneur uses the same skills, resources and ideology to tackle problems, but without the associated risks as an entrepreneur.

Intrapreneur was originally coined in the 1980’s by Gifford Pinchot. Companies at the time used intrapreneur when they needed new and groundbreaking ideas for their business. Now firms are creating a business culture of empowered employees.

Enabling employees allows problems to be solved with greater response time. It allows people to be proactive and the company less reactive to the market and customer needs.

Think of it this way. Google encourages the intrapreneur mentality. They expect their developers to take 20% of their time to work on outside projects.

Why? The 20% of work that is done by Google’s developers leads to more products for Google’s customers.

*I’m not encouraging businesses to take the same approach as Google into their operations. The principle of the 20% can still be instilled without disrupting operations.

When managers have an open policy to ideas brought to them, have dialogue and make change, it empowers employees, creating value in their work.

Cathy Gray

Cathy Gray

A Marketing & Operations Aficianodo

About | Contact


Latest Articles

Matthew McConaughy Motivational Speech

The other night, I came across a video clip of...

Innovation – What it is and What it isn’t

Cathy Gray
Strategizing Print & Digital Marketing w/ Business Operations
(and always with coffee in hand)
About | Contact

Innovation Isn’t

According to Albert Einstsin, not innovating is similar to insanity.

Insanity doing the same thing over and over and expecting different results. – Albert Einstein



Innovation Is

Drucker explains innovation the best according to business in mind. We wouldn’ expect anything else from him

If you want to do something new, you have to stop doing something old. – Peter F. Drucker

Making Sense of Innovation

Both Einstein and Drucker define innovation according to their scientific and business mentality.

Before we get started, I am not saying throw away tradition, disrupt the norm or a 180 degree change in processes.

What I am saying is keep the tradition, norms and processes, and build upon them. It’s about being proactive and not reactive.

A question that arises is why do we do it this way or simply why. Most of the time, the question isn’t asked outside, but asked in our heads. For most, the answer is because we have always done it that way.

It doesn’t matter what the answer is, we have to look at why the question is being asked.

Is it being asked because… is it over complicated is the way of doing it a workaround to a more efficient solution that wasn’t thought of the person just doesn’t understand we have always done it that way it isn’t broken, don’t try to fix it

These answers may sound familiar, but they do not get anyone anywhere.

Businesses do not stay ahead of the competition by staying strictly stuck on them. People do not grow without making improvements.

Let’s get away from what we are use to because we are afraid of a change, no matter how big or small.

We need to push through and innovate the old to come up with the new.

Cathy Gray

Cathy Gray

A Marketing & Operations Aficianodo

About | Contact


Latest Articles

Matthew McConaughy Motivational Speech

The other night, I came across a video clip of...

Improving Professional Marketing Skills

I started a course with Google this previous Monday called YouTube Creative Essentials.

I am about halfway through the course at the moment.

So far I’m liking and enjoying the material. Overall, the course is a good refresher and adds the latest best practices in digital marketing.

The goal is to have the YouTube Creative Essentials course completed this weekend. 

After passing the YouTube Creative Essentials Assesment:

  • Write a review on the YouTube Creative Essentials.
  • Taking the subject matter into the workplace.

There is also an additional eStudy that is highly specific on YouTube, video creation, video production etc that is next on the list.

Marketing and Youtube course from Google - CathyGray


After College Reflection and Professional Learning

After College and Now

After receiving a text from a past coworker, my mind started to reflect on my college experience as a non-traditional student. A non-traditional student is one that attends college after the normal years of late teens and early twenties. Let me tell you, as a non-traditional student, working and with a family, it certainly wasn’t easy.

This was my second degree. The first college that I attended, The Art Institute of Atlanta, was during traditional college age years.

Both are quite different college experiences, but I’m glad that I have the perspective of both.

One-Year After Graduation

Since graduating, there have been ups and downs, to say the least. Within this time frame, there have been quite a few changes on the home and work front. I’m not going to get into the details of each, but I am an advocate of learning from the past and using those experiences to move forward.

Decisions have been made with and without my direct choice. Either way, the end is the same, it’s how I personally manage the outcome and progress from them.

Even though I graduated, schooling has yet ceased to stop. In the past few months, I have been refreshing my knowledge in Google Analytics or GA for short through the Google Analytics Academy. The four provided courses covering fundamental and advanced GA, eCommerce and Tag Manager.

The overall goal is to obtain my Google Analytics Certification.

Overall, I never plan to stay stagnant in knowledge. As a marketer, I have to stay on top of the digital world from a technology standpoint.

Guiding Light

My philosophy is Absorb, Process, Conquer, Learn and Repeat.

My professional or career mission is finding the intersections, correlations, and cornerstones between businesses and their customers through technology usage.

Sounds pretty simple, eh?

It can be a bit complicated at times, but both the philosophy and professional objective are used as guiding points through life’s journey – with coffee in hand of course!