WooCommerce – Add SKU or Title to Product URLs – Generate thousands of Permalinks

Hey there!

We know that sometimes you want to customize everything in your WooCommerce store, and it may include your product permalinks. For example, you may want your permalinks to look like this: www.website.com/ wordpress/ product/ postname-sku. Or maybe you want them to look like this: www.mywebsite.com/ wordpress/ product/ postname-title. In that case, you would have to edit thousands of your product URLs. That, of course, could take you many hours, especially if you have some 5,000 products to edit.

So in this short article, we’ll show you how easy it is to:

  • Add SKUs to product URLs
  • Add Titles to product URLs
  • and Add both SKUs and Titles to your products URLs.

For this we’ll use the WP Sheet Editor Products Spreadsheet plugin.

Install WP Sheet Editor

*You can skip this step if you have the plugin installed and activated.

You can download the plugin here:

- or - Read more about it

This plugin helps you easily manage your WooCommerce products because it displays them all in a beautiful spreadsheet where you can edit freely. It also contains a powerful Bulk Edit tool that allows you to edit thousands of products at once.

To add SKUs to your product URLs, you need to follow some easy steps:

a) Open the Bulk Edit tool

This tool will help you apply changes on hundreds or thousands of products at once. You’ll find it on the toolbar, so just click it.

b) Hit the Select rows button (Optional)

This button will open a search tool in which you’ll be able to filter your products in different ways.

In the search tool you’ll find these fields:

  • Contains keyword – Use this field if you want to look for all products containing a specific keyword.
  • Status – Here you can select between published and draft products.
  • NOT contains keyword – Here you can select a keyword and the search tool will look for all products except the ones containing that keyword.
  • Date range – In these fields, you can search for products created during a time range.
  • Enable advanced filters – This checkbox opens advanced filters to search for your products.
  • Run search – This button is to filter your products according to the terms of the search you’ve selected.

After setting the search terms, just hit the Run search button, which will filter your products and take you back to the Bulk Edit tool.

c) Copy from the SKU column to the URL column

In the Bulk Edit fields, you need to set these values in order to add SKUs to the product URLs:

  • Check the I understand it will update the posts from my search checkbox.
  • Select the URL slug column as the field you’ll edit.
  • Select Copy from other columns as the type of edit you’ll apply.
  • Select $_sku$ (SKU) in the Copy from this column field.
  • Hit the “Execute now” button.

After that, your product URLs will be modified.

These are the simple steps you need to follow to add your product titles to URLs:

a) Open the Bulk Edit tool

This tool will help you apply changes on hundreds or thousands of products at once. You’ll find it on the toolbar, so just click it.

b) Hit the Select rows button (Optional)

This button will open a search tool in which you’ll be able to filter your products in different ways.

In the search tool you’ll find these fields:

  • Contains keyword – Use this field if you want to look for all products containing a specific keyword.
  • Status – Here you can select between published and draft products.
  • NOT contains keyword – Here you can select a keyword and the search tool will look for all products except the ones containing that keyword.
  • Date range – In these fields, you can search for products created during a time range.
  • Enable advanced filters – This checkbox opens advanced filters to search for your products.
  • Run search – This button is to filter your coupons according to the terms of the search you’ve selected.

After setting the search terms, just hit the Run search button, which will filter your products and take you back to the Bulk Edit tool.

c) Copy from the Title column to the URL column

In the Bulk Edit fields, you need to set these values in order to add your product titles to their URLs.

  • Check the I understand it will update the posts from my search checkbox.
  • Select the URL slug column as the field you’ll edit.
  • Select Copy from other columns as the type of edit you’ll apply.
  • Select $post_title$ (Title) in the Copy from this column field.
  • Hit the “Execute now” button.

After that, your product URLs will be modified.

To add both SKUs and titles to your product URLs, you simply need to follow these easy steps:

    a) Open the Bulk Edit tool

    This tool will help you apply changes on hundreds or thousands of products at once. You’ll find it on the toolbar, so just click it.

    b) Hit the Select rows button (Optional)

    This button will open a search tool in which you’ll be able to filter your products in different ways.

    In the search tool you’ll find these fields:

    • Contains keyword – Use this field if you want to look for all products containing a specific keyword.
    • Status – Here you can select between published and draft products.
    • NOT contains keyword – Here you can select a keyword and the search tool will look for all products except the ones containing that keyword.
    • Date range – In these fields, you can search for products created during a time range.
    • Enable advanced filters – This checkbox opens advanced filters to search for your products.
    • Run search – This button is to filter your coupons according to the terms of the search you’ve selected.

    After setting the search terms, just hit the Run search button, which will filter your products and take you back to the Bulk Edit tool.

    c) Copy from both the SKU  and the Title columns to the URL column

    In the Bulk Edit fields, you need to set these values in order to add both SKUs and titles to the product URLs:

    • Check the I understand it will update the posts from my search checkbox.
    • Select the URL slug column as the field you’ll edit.
    • Select Copy from other columns as the type of edit you’ll apply.
    • Select $post_title-$_sku$ in the Copy from multiple columns field.
    • Hit the “Execute now” button.

    After that, your product URLs will be modified.

    Done!

    As you can see, adding SKU or title to your products URLs is really simple with the WP Sheet Editor Products Spreadsheet plugin.

    You can download the plugin here:

    - or - Read more about it

    Close Menu