Title: Problem setting SKU
Last modified: January 24, 2022

---

# Problem setting SKU

 *  Resolved [James Maiden](https://wordpress.org/support/users/reallygreenjames/)
 * (@reallygreenjames)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/problem-setting-sku/)
 * Hi there,
 * I’m having this odd problem where I can’t set an SKU for a product. I’ve tested
   this with a default WP theme and with all other plugins deactivated.
 * Actually, it is that I can set an SKU, but not the one I want it to be. I can
   only assume from all this that the system thinks my attempt to set the SKU I 
   want is a duplicate.
 * I have checked thoroughly. There are no products with the same SKU, not published,
   draft or deleted.
 * I’ve had a search in the database but am not sure where SKU data is stored.
 * Can you offer any suggestions?
 * Thanks,
    James

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/problem-setting-sku/#post-15284526)
 * Hello James [@reallygreenjames](https://wordpress.org/support/users/reallygreenjames/),
 * You may want to clear the product/shop transients cache under WooCommerce > Status
   > Tools.
 * ![](https://i0.wp.com/i.imgur.com/W7kwrOh.png?ssl=1)
 * The SKU location in the database is in the `wp_postmeta` table where `meta_key
   = '_sku'`.
 * Hope this helps.
 *  Thread Starter [James Maiden](https://wordpress.org/support/users/reallygreenjames/)
 * (@reallygreenjames)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/problem-setting-sku/#post-15284764)
 * Thanks for the advice.
 * I found out that there was a product variation using the SKU that I needed. Pilot
   error!
 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/problem-setting-sku/#post-15284832)
 * Great! Glad to know that the issue is resolved now. You did a good job finding
   the culprit and fixing the issue by yourself.
 * Now that the issue is resolved, feel free to create a new topic if you need assistance
   with anything else.
 * Cheers.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Problem setting SKU’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [sku](https://wordpress.org/support/topic-tag/sku/)

 * 3 replies
 * 2 participants
 * Last reply from: [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/problem-setting-sku/#post-15284832)
 * Status: resolved