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.

Website AND SEO Audit with Screaming Frog and Excel

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

A Step by Step Website and SEO Audit with Screaming Frog and Excel

I’ll be using this website for this website and SEO audit. 

I’ve prerecorded a video that is on my YouTube Channel, but you can also watch it below without leaving the site. 

I am currently working on a transcript and instructions to follow along if you prefer to follow along at your own pace.

All right, we’ll be going in the step by step on a website audit using Screaming Frog and Excel. Let’s have some fun.

If you guys hear any walking around that’s my dog being a dog and if he barks it’ll scare the crap out of me, too. (Luckily my dog never barked, so I didn’t have to edit out a barking dog.)  

A Glimpse at the Final Audit

The following video is a short clip of what the final website and SEO audit should look like. The video pans to the right showing the content tabs, but does not scroll down to show all of the pages that are included.

Start with Screaming Frog

Let’s get started with Screaming Frog to crawl or scrap our website and export it to Excel where we’ll do some conditional formatting. With the conditional formatting, the report will tell us where we need to make our adjustments for SEO optimizations. It will help us prioritize.

Depending on your website goals, you can add other details to keep track of as well. 

In my case, I’ll have an additional tab for page layout updates, keyword mapping and other things as they come up.

What is Screaming Frog?

First and foremost, don’t let the strange name make you scratch your head. It’s simply a website crawler that gathers meta data or details about a website.

I used the free version because it suits my purposes for this website audit.

There is a paid version which allows you to crawl a website that has more than 500 pages. This is good for an eCommerce site or one that has many pages and articles.

If you need to download it, visit the makers of the software. https://www.screamingfrog.co.uk/seo-spider/ It’s available for Mac and PC. 

Let Screaming Frog Start Collecting From Your Site

Enter your site and hit start. The time it takes to crawl your site depends on your internet speed and the size of your site.

It isn’t like waiting for water to bowl, watch it or grab a cup of coffee then come back.

Close up of screaming frog before entering a website to crawl Closeup of Screaming Frog with a Website Crawl Complete

Closeup of Screaming Frog Export Button

Once it is complete, export the file.

In my example, I selected All from the drop down menu, but you can filter down if you would like.

For this website audit, this is all that we’ll be using Screaming Frog for. There are so many other things that it can be used for, but right now, it’s about getting prioritizing and setting up a list with what needs to be done.

Finishing Off with Microsoft Excel

In the first and original video, I used Microsoft Excel 2007. In the second video, I used the version of Excel that is connected with my hotmail account. It’s completely online, so the screenshots might be a different from the version that you may using. However it still works in the same way. The styling is the ony thing that will be different. (The Microsoft Office on my computer has been acting goofy today. I quite honestly haven’t had enough coffee today to correct the problem.)

Cathy Gray

Cathy Gray

A Marketing & Operations Aficianodo

About | Contact

 

Latest Articles

Why You Should Always Use a Child Theme in WordPress

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

What is a theme in WordPress?

A theme is simply a set of files that work together to present the content together. A theme sets the overall styling of your website.

Most WordPress websites have a theme, and it is very rare that one will not have one. I can’t think of why a website wouldn’t have a theme.

Let’s Compare WordPress to PowerPoint

WordPress and Microsoft PowerPoint are both the frameworks or software for the website or document. Each have their own theme for fonts, styling, colors and other design elements.

WordPress Themes

Here is a screenshot from dashboard of WordPress where themes are located. Here you can upload a theme that you have purchased or download a theme from the WordPress directory.

PowerPoint Themes

This is a screenshot from PowerPoint 2007 of the available default themes. Under the thumbnails, you can also browse and install other themes from Microsoft. This is a very similar process to WordPress themes.

What is a parent theme?

A parent theme in WordPress is any theme that is available on a marketplate, from a vendor or downloaded from WordPress.org.

When you are starting with a fresh WordPress install, it is comes with a few themes preinstalled. They are named by the year they are released, Twenty Seventeen theme was released in 2017 for example.

2017 WordPress default theme

What is a child theme in WordPress?

A child theme is a theme that is a similar version of the parent. The files pull information from the parent theme, but adds adds security if the parent theme is ever updated.

Why is a Child Theme Important?

If you make changes to a theme without using a child theme and the main or parent theme is updated, you can loose the styling and work that you have done to your site.

That is why it is best practice to use a child theme. I’ve been in the situation where the main theme had to be updated and and I didn’t use a child theme.

I made rookie mistake when I first started. I didn’t have a child theme and lost all of my customizations.

Latest Articles

Competing Sites for Cathy Gray and Competitive Website Landscape

Website Competition with AlatenightcoffeewithCathyGray.com

~ Last updated May 2017

A competition site is one that is higher in the SERPS than this website. I talk about keywords and keyword strategy as well.

  • The major competitor is an Australian artist, also named Cathy Gray. The site and Facebook page ranks first. As she is an artist she will naturally have a very large amount of backlinks to her site from art galleries, events and her Facebook account.

A few others sites worth mentioning:

  • The Realtor – Kathy Gray. This site is going to have a large number of backlinks as well from real estate listings. Cathy with a “k” shows at the bottom of the page for suggested search results. In my opinion, this comes from this site along with an alternate spelling for the name. From a search, all of the pages are spelled with a “c”. this site is the only with a “k”.
  • The Tech-Savvy High School Teacher with a class website – Cathy Gray. As a high school teacher, this site’s traffic is going to be direct, the time on page is going to be high and the bounce rate is going to be low.
  • Dr. Cathy Gray practicing psychiatry in Jacksonville, Florida.
  • Find Cathy Gray (White Pages, Spokeo and similar sites)

Competitive Website Analysis

For the time being, a detailed analysis will have to come at a later day.