How to Add SKU to WooCommerce Products

Wrong stock counts drain money from online stores every single day. On average, about 60% of retail SKUs are inaccurate, and that gap fuels overstocks and out-of-stocks that cost retailers roughly $1.77 trillion worldwide. 

A clean SKU on every product is your first line of defense. This guide shows you how to add SKU to WooCommerce products the right way, from a single item to your whole catalog. You will learn the manual method, the bulk method, how to fix the common “duplicate SKU” error, and how to show SKUs to your customers.

What Is a SKU in WooCommerce?

A SKU (Stock Keeping Unit) is a short, unique code you give each product. You create it yourself. It is not the same as a barcode.

You use SKUs to:

• Track stock levels
• Find products fast in your dashboard
• Fill orders without mix-ups
• Sync with shipping, accounting, and POS tools

WooCommerce does not add SKUs for you. Every new product starts with an empty SKU field. You add the code by hand or with a plugin.

Quick answer: To add a SKU in WooCommerce, go to Products, open a product, click the Inventory tab under Product data, type your code in the SKU field, and click Update.

How to Add a SKU to a WooCommerce Product

Here is the manual way for a simple product. It takes less than a minute.

1. Log in to your WordPress dashboard.
2. Go to Products > All Products.
3. Hover over a product and click Edit.
4. Scroll to the Product data box.
5. Click the Inventory tab on the left.
6. Type your code in the SKU field.
7. Click Update to save.

That is it. The SKU is now tied to that product.

You can use up to 255 letters, numbers, and special characters in the field. Keep it short and simple anyway. A code like TSHIRT-BLU-M is easier to read than a long string.

Good Read: How Many Products Can WooCommerce Handle

How to Add SKUs to Variable Products

A variable product has options, like size or color. Each option is called a variation. Each variation can have its own SKU.

Here is how to add them:

1. Open a variable product and go to Product data.
2. Set the product type to Variable product.
3. Click the Variations tab.
4. Expand a variation to open its settings.
5. Enter a unique SKU for that variation.
6. Repeat for each variation, then click Save changes.

Give each color and size its own code. For example, a blue medium shirt might be TSHIRT-BLU-M and a red large shirt might be TSHIRT-RED-L. This keeps stock counts correct for every option.

How to Add SKUs in Bulk

Adding codes one by one is slow for large stores. Use one of these two faster ways.

Option 1: Quick Edit

1. Go to Products > All Products.
2. Hover over a product and click Quick Edit.
3. Add the SKU in the SKU field.
4. Click Update.

Quick Edit is handy for fixing a handful of products without opening each one fully.

Option 2: CSV Import

For hundreds of products, use a spreadsheet.

1. Go to Products > All Products and click Export to download a CSV.
2. Open the file in Excel or Google Sheets.
3. Fill in the sku column for each product.
4. Save the file.
5. Go back and click Import, then upload your file.
6. Map the columns and finish the import.

Make sure every SKU in the file is unique before you import. Duplicates will fail.

Option 3: A SKU Generator Plugin

If you want codes created for you, use a SKU generator plugin. These tools build codes from product ID, category, or attributes. This saves time and keeps your format the same across the store.

Here are three free options from the WordPress.org plugin directory:

• Easy Auto SKU Generator for WooCommerce builds SKUs for new products and variations. You can set a prefix, suffix, length, and format. It also does bulk generation by category. It has more than 10,000 active installs.
• Product SKU Generator for WooCommerce (by SkyVerge/GoDaddy) creates codes from the product slug or ID. It can add variation attributes to each variation SKU and bulk-update your whole catalog.
• SKU Generator for WooCommerce (by WPWham) lets you set a custom format with prefix, suffix, number length, category, and tag. It can also regenerate SKUs for products that have none and add front-end search by SKU.

To install any of them, go to Plugins > Add New, search the plugin name, click Install Now, then Activate. Set your rules first, then run a small test batch before you generate SKUs for the full store.

Good Read: How to Set a Minimum Order Amount in WooCommerce

How to Create a Good SKU (Naming Rules)

Most guides skip this part. But a smart naming system saves hours later.

A good SKU is:

• Unique. No two products share a code.
• Short. Aim for 8 to 16 characters.
• Readable. A person should guess the product from the code.
• Consistent. Use the same pattern every time.

Build your code from parts that describe the product. Use a dash between parts.

Put them together: TSHIRT-BLU-M-001.

Avoid spaces. Avoid starting with a zero on its own, since spreadsheets may drop it. Do not use the same code twice, even for products that look alike.

Set your rules early. Renaming SKUs after customers have ordered under the old codes is a headache.

How to Show SKUs on the Product Page

Some themes show the SKU on the front end once you add it. Many do not.

To check, add a SKU, save the product, then view the page. If your theme supports it, the SKU shows in the product meta area near the price.

If it does not show, you have three choices:

• Switch to a theme that displays SKUs.
• Use a page builder to place the SKU field.
• Add a small PHP snippet that hooks into woocommerce_single_product_summary.

Showing the SKU helps buyers reference the exact item when they contact you or reorder.

How to Let Customers Search by SKU

WooCommerce lets you search by SKU inside the admin dashboard by default. Type the code in the product search box to find it fast.

Front-end search for shoppers is different. The default WooCommerce search may not match SKUs well. If you want customers to search by SKU on your storefront, add a product search plugin that supports SKU search. This helps wholesale and B2B buyers who order by code.

Common SKU Problems and Fixes

“Invalid or duplicated SKU” error

This is the most common SKU issue. It means the code is already used by another product.

To fix it:

1. Copy the SKU that caused the error.
2. Go to Products > All Products.
3. Paste the code in the search box and search.
4. Find the product that already uses it.
5. Change one of the two codes so each is unique.
6. Save and try again.

Also check your Draft and Trash products. A hidden draft can hold the same code. And check WooCommerce > Status > Tools, then run “Delete orphaned variations” if old variations are causing conflicts.

Duplicate SKU errors during CSV import

When you move products between two sites, the import can throw a false duplicate error. This often comes from the ID column in the export file.

To fix it, remove or unmap the ID column, then update your products by SKU instead of by ID. WooCommerce matches products by SKU across sites more reliably than by ID.

SKU field is missing

If you do not see the SKU field, SKUs may be turned off. Go to WooCommerce > Settings > Products > Inventory and turn on “Enable SKU field.”

Good Read: WooCommerce Related Products: Increase Revenue by 35%

Do SKUs Help SEO?

Yes. SKU is a recommended product schema property. Search engines use it to understand your product better. This can improve your chance of showing up as a rich result.

If a product is missing a SKU, Google Search Console may show a “Missing field ‘sku'” warning. SEO plugins like Yoast WooCommerce SEO can add the correct schema for you and flag products that have no SKU.

SKU Best Practices

• Give every product and variation a unique SKU.
• Keep one naming pattern across your whole store.
• Store your SKUs in a master spreadsheet for backup.
• Add SKUs before you launch, not after orders come in.
• Review your product list now and then for duplicates.

Frequently Asked Questions (FAQs)

Next Step

Start with your top sellers. Add a clear, unique SKU to each one today using the Inventory tab. Then set a simple naming rule and roll it out across your catalog. Clean SKUs mean fewer stock mistakes, faster orders, and happier customers.