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:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

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) Filter your products (Optional)

To filter your products, select the I want to search rows to update option in the Select the rows that you want to update dropdown.

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.
  • Enter Tags – Use this field to search for categories, attributes, tags, shipping classes.
  • Enable advanced filters – This checkbox opens advanced filters to search for your products.
  • Search on variations – Use this checkbox to filter variations only.
  • 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:

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: URL Slug
  • Select type of edit: Copy from other columns
  • Copy from this column: $_sku$ (SKU)
  • Click on Execute now

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) Filter your products (Optional)

To filter your products, select the I want to search rows to update option in the Select the rows that you want to update dropdown.

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.
  • Enter Tags – Use this field to search for categories, attributes, tags, shipping classes.
  • Enable advanced filters – This checkbox opens advanced filters to search for your products.
  • Search on variations – Use this checkbox to filter variations only.
  • 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 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.

  • Select the rows that you want to update: I want to search rows to update
  • What field do you want to edit: URL Slug
  • Select type of edit: Copy from other columns
  • Copy from this column: $post_title$ (Title)
  • Click on Execute now

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) Filter your products (Optional)

    To filter your products, select the I want to search rows to update option in the Select the rows that you want to update dropdown.

    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.
    • Enter Tags – Use this field to search for categories, attributes, tags, shipping classes.
    • Enable advanced filters – This checkbox opens advanced filters to search for your products.
    • Search on variations – Use this checkbox to filter variations only.
    • 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 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:

    • Select the rows that you want to update: I want to search rows to update
    • What field do you want to edit: URL Slug
    • Select type of edit: Copy from other columns
    • Copy from multiple columns: $post_title$-$_sku$
    • Click on Execute now

    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:

    Download WooCommerce Products Spreadsheet Plugin - or - Read more

    Do you need help?

    You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

    Close Menu