Do you’re employed on an enterprise ecommerce website? In that case, chances are high you need to optimize huge quantities of product pages utilizing a product data 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 information
I’ll use some dummy PIM information for instance of my course of. Relying on what you employ to accommodate your product information, you’ll have roughly product information necessities (columns), however the general technique behind the method must be the identical.
For my in-house place, I do that primarily based 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.
Your small business might have a unique technique to go about this, however once more, the technique is identical and you start with a bulk listing of product SKUs to optimize.
To begin this course of, obtain the required information out of your PIM to optimize your listing of SKUs in Excel. Let’s begin with some of the necessary on-page search engine optimisation components: the title tag.
One of the best ways to formulate product web page title tags is to make use of the product identify adopted by the enterprise identify or model on the finish. For ecommerce, you may additionally need to embrace shade and measurement (though most of those pages must be blocked from serps).
We’re not aiming for fancy key phrases or advertising and marketing experiments to check efficiency hypotheses for bulk product optimization. We merely have to craft a related product title tag.
For those who exported your information proper, you’ll have already got a title tag column that’s empty. To begin creating your product title tags, kind =(reference the cell with the product identify)
. Pull the formulation for this cell all the best way right down to the underside of your SKU listing.
Subsequent, add what you are promoting’s model identify 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.
![Title tag - Excel 2](https://searchengineland.com/wp-content/seloads/2024/03/Title-tag-Excel-2.png)
Lastly, add a 3rd column to mix the 2 cells collectively by typing =(product identify cell)&(enterprise identify cell)
and hit enter. You’ll now have them mixed into one cell.
![Title tag - Excel 3](https://searchengineland.com/wp-content/seloads/2024/03/Title-tag-Excel-3.png.webp)
The necessary subsequent step right here is to tug the formulation all the best way down after which be certain that to repeat the cells and paste them as a price (right-click and “paste as worth”) so that you just not have a formulation powering the cell, however precise textual content.
![Title tag - Excel 4](https://searchengineland.com/wp-content/seloads/2024/03/Title-tag-Excel-4.png)
![Title tag - Excel 5](https://searchengineland.com/wp-content/seloads/2024/03/Title-tag-Excel-5.png.webp)
Now you can delete the opposite two columns. Simply be certain that your new column has the cell’s title tag column identify.
![Title tag - Excel 6](https://searchengineland.com/wp-content/seloads/2024/03/Title-tag-Excel-6.png)
That’s it! Have a look at these good title tags!
Dig deeper: How to write title tags for SEO with ChatGPT
Get the every day publication search entrepreneurs depend on.
Product copy
For product copy, our purpose is to verify the grammar appears good and discover alternatives to enhance with extra key phrases that your model/advertising and marketing of us want your help with.
The purpose 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 device I exploit for this course of is named Grammarly. They’ve a pleasant Chrome extension that I exploit. To begin, dump your product copy into Grammarly.
After reviewing your copy for a couple of seconds, it can present grammar and spelling recommendations. Make sure you hit Settle for for the grammar or spelling change to replace your copy.
![Product copy - Grammarly 1](https://searchengineland.com/wp-content/seloads/2024/03/Product-copy-Grammarly-1.png.webp)
Be aware that I’m solely utilizing the free model of Grammarly. With the premium model, you’ll be able to entry options like figuring out passive voice and “wordy” sentences, which can be worthwhile for you.
Now that you’ve got grammatically right sentences, you’ll be able to copy and paste this again into your Excel file. Sadly, there is no such thing as a quick technique to get this performed for every SKU in order that a part of the method will most likely take you the longest. After you have gone by your complete SKU listing and up to date the error-free product copy, you’ll be able to take a step again to work in your key phrases.
For those who’re like me, you might have a few product copy variations: one in your website and one or a number of extra for distributor websites. You need to attempt to make every model of the copy barely totally 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 may very well be tough. Along with that, chances are you’ll be restricted on what information you need to share with ChatGPT or different options attributable to information privateness on merchandise that haven’t launched.
![Product copy - Grammarly 2](https://searchengineland.com/wp-content/seloads/2024/03/Product-copy-Grammarly-2.png)
Dig deeper: How to use ChatGPT to generate product descriptions at scale
I like meta descriptions as a result of I get pleasure from seeing what ChatGPT creates. Its capability 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, take into account coaching an search engine optimisation assistant GPT on writing meta descriptions.
To do that, I exploit 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 principle product and its distinctive promoting proposition?”
I do know meta descriptions are primarily based on pixel width, however this will get the job performed. Ideally, we need to be nearer to 155 characters or much less.
After the preliminary immediate, I’d add the product copy in quotations and press enter.
This has labored surprisingly nicely, and I exploit about 85-95% of what ChatGPT generates. Whereas I would reword some elements, it typically captures the model voice successfully. You possibly can 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 would tweak that final sentence because it appears just a little awkward.
![Meta descriptions - ChatGPT](https://searchengineland.com/wp-content/seloads/2024/03/Meta-descriptions-ChatGPT.png)
Much like advertising and marketing copy, I haven’t discovered a bulk technique that works for me. My course of includes dealing with them individually.
In case you have comparable merchandise, which is possible, you’ll be able to 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 realized in regards to the LEN Excel formulation for counting a cell’s characters. So, for many who won’t learn about it, you simply kind =LEN(cell you need to rely)
and hit enter.
You now have the character rely of the referenced cell. Recreation-changing!
Additionally, be sure you don’t neglect to delete any cells with these formulation, as your PIM will most likely reject your file for add.
Over to you
After ending the method and reviewing it, you’re able to add it. It’s smart to double-check that your adjustments had been up to date as supposed.
My intention 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 reinforce your personal strategies or ignite new concepts.
Whereas I’m not an AI or Excel skilled (is anybody?), I’m open to studying higher or quicker strategies from others. Share your insights with me and the group! 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 writer and never essentially Search Engine Land. Workers authors are listed here.