Do you’re employed on an enterprise ecommerce website? In that case, likelihood is it’s a must to optimize large quantities of product pages utilizing a product info administration (PIM) system.
This text covers a step-by-step bulk product optimization course of for SEO, highlighting some Excel formulation and third-party instruments, together with ChatGPT and Grammarly, to assist make the method go quicker for title tags, meta descriptions and product copy optimization.
Managing and optimizing your ecommerce product knowledge
I’ll use some dummy PIM knowledge for instance of my course of. Relying on what you employ to accommodate your product knowledge, you’ll have kind of product knowledge necessities (columns), however the general technique behind the method ought to be the identical.
For my in-house place, I do that based mostly on the product launch schedule. As soon as I do know the SKUs for a product launch and the copy is loaded into our PIM, I can start my optimization course of.
What you are promoting could have a special strategy to go about this, however once more, the technique is similar and you start with a bulk listing of product SKUs to optimize.
To start out this course of, obtain the required knowledge out of your PIM to optimize your listing of SKUs in Excel. Let’s begin with one of the essential on-page search engine optimisation parts: the title tag.
One of the simplest ways to formulate product web page title tags is to make use of the product title adopted by the enterprise title or model on the finish. For ecommerce, you may additionally wish to embrace colour and measurement (though most of those pages ought to be blocked from engines like google).
We’re not aiming for fancy key phrases or advertising experiments to check efficiency hypotheses for bulk product optimization. We merely must craft a related product title tag.
For those who exported your knowledge proper, you’ll have already got a title tag column that’s empty. To start out creating your product title tags, sort =(reference the cell with the product title). Pull the system for this cell all the best way right down to the underside of your SKU listing.
Subsequent, add your online business’s model title to the title tag by creating a brand new column subsequent to the title tag column and add ” | Your Enterprise Title.” Pull that every one the best way down the SKU listing.
Lastly, add a 3rd column to mix the 2 cells collectively by typing =(product title cell)&(enterprise title cell) and hit enter. You’ll now have them mixed into one cell.
The essential subsequent step right here is to drag the system all the best way down after which ensure to repeat the cells and paste them as a price (right-click and “paste as worth”) so that you simply now not have a system powering the cell, however precise textual content.
Now you can delete the opposite two columns. Simply ensure your new column has the cell’s title tag column title.
That’s it! Take a look at these good title tags!
Dig deeper: How to write title tags for SEO with ChatGPT
Get the day by day e-newsletter search entrepreneurs depend on.
Product copy
For product copy, our objective is to ensure the grammar seems good and discover alternatives to enhance with further key phrases that your model/advertising people want your help with.
The objective right here is to carry out keyword research first to make use of key phrases your prospects use to explain the product. (You can even use ChatGPT to speed up your keyword research.)
The software I take advantage of for this course of known as Grammarly. They’ve a pleasant Chrome extension that I take advantage of. To start out, dump your product copy into Grammarly.
After reviewing your copy for a number of seconds, it can present grammar and spelling ideas. Make sure you hit Settle for for the grammar or spelling change to replace your copy.
Notice that I’m solely utilizing the free model of Grammarly. With the premium model, you may entry options like figuring out passive voice and “wordy” sentences, which can be worthwhile for you.
Now that you’ve grammatically right sentences, you may copy and paste this again into your Excel file. Sadly, there isn’t a quick strategy to get this carried out for every SKU in order that a part of the method will in all probability take you the longest. Upon getting gone via your total SKU listing and up to date the error-free product copy, you may take a step again to work in your key phrases.
For those who’re like me, you will have a few product copy variations: one on your website and one or a number of extra for distributor websites. You must attempt to make every model of the copy barely completely different, as we all know that Google doesn’t rank duplicate copy nicely.
Since working with model or copywriting on this may be difficult, your flexibility on altering this could possibly be tough. Along with that, it’s possible you’ll be restricted on what knowledge you wish to share with ChatGPT or different options on account of knowledge privateness on merchandise that haven’t launched.
Dig deeper: How to use ChatGPT to generate product descriptions at scale
I like meta descriptions as a result of I take pleasure in seeing what ChatGPT creates. Its potential to write down them has improved even with the GPT 3.5 mannequin. (I haven’t seen a major high quality distinction with the Plus model.)
If you wish to experiment, contemplate coaching an search engine optimisation assistant GPT on writing meta descriptions.
To do that, I take advantage of the next immediate:
- “Are you able to write me a meta description that’s lower than 165 characters from the next textual content highlighting the primary product and its distinctive promoting proposition?”
I do know meta descriptions are based mostly on pixel width, however this will get the job carried out. Ideally, we wish to be nearer to 155 characters or much less.
After the preliminary immediate, I might add the product copy in quotations and press enter.
This has labored surprisingly nicely, and I take advantage of about 85-95% of what ChatGPT generates. Whereas I’d reword some components, it usually captures the model voice successfully. You might additionally specify your preferences when writing your immediate.
Under is what ChatGPT got here up with for my “dummy” product copy. It ended up at 150 characters, which is nice. I’d tweak that final sentence because it appears slightly awkward.
Much like advertising copy, I haven’t discovered a bulk methodology that works for me. My course of includes dealing with them individually.
When you’ve got related merchandise, which is possible, you may expedite this by reusing the “bones” of the meta description for different merchandise within the group.
Facet word: It took me a number of years in my profession earlier than I discovered in regards to the LEN Excel system for counting a cell’s characters. So, for individuals who won’t find out about it, you simply sort =LEN(cell you wish to depend) and hit enter.
You now have the character depend of the referenced cell. Sport-changing!
Additionally, be sure to don’t overlook to delete any cells with these formulation, as your PIM will in all probability reject your file for add.
Over to you
After ending the method and reviewing it, you’re able to add it. It’s sensible to double-check that your modifications have been up to date as meant.
My purpose for this text is to be concise and sensible, providing a hands-on walkthrough of my course of. Hopefully, you’ll discover one thing to boost your individual strategies or ignite new concepts.
Whereas I’m not an AI or Excel professional (is anybody?), I’m open to studying higher or quicker strategies from others. Share your insights with me and the neighborhood! All of us profit from sharing and studying collectively.
Dig deeper: Why ecommerce brands must showcase authentic E-E-A-T
Opinions expressed on this article are these of the visitor creator and never essentially Search Engine Land. Employees authors are listed here.
