Title: Export/Import SKU Problem
Last modified: November 30, 2020

---

# Export/Import SKU Problem

 *  Resolved [loopforever](https://wordpress.org/support/users/loopforever/)
 * (@loopforever)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/)
 * Hello,
    I am working on a project. Bulk product should be uploaded. I try the
   following steps to test this. But there is a problem:
 * I export the product and delete the product from the website. The stock code (
   SKU) appears in the csv file. I change and save the stock code in the table. 
   Then I import the product. All data (including SKU) matches. The import process
   is successful. So far, no problem. However, when you enter the product edit page,
   it shows SKU 0. The matching value does not appear. Why could this be?

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

 *  Thread Starter [loopforever](https://wordpress.org/support/users/loopforever/)
 * (@loopforever)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/#post-13728242)
 * **Update:**
    I guess I found something. If ID is blank or not selected in match,
   SKU is defined as “0”. However, I want the ID to be empty. Because the system
   automatically identifies ID. What can I do for it ?
 *  [Siew](https://wordpress.org/support/users/kosiew/)
 * (@kosiew)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/#post-13728451)
 * Hi there,
 * 
    Link to image: [https://d.pr/i/3GL053](https://d.pr/i/3GL053)
 * I tested and managed to create new products with new SKU as seen above.
 * In my case, i deleted all IDs in the file and ensured that import will create
   new instead of updating existing rows:
 * 
    Link to image: [https://d.pr/i/80lzlo](https://d.pr/i/80lzlo)
 * Here is an excerpt of the match fields during import:
 * 
    Link to image: [https://d.pr/i/R8BK4F](https://d.pr/i/R8BK4F)
 * Please try the above and let us know how it goes.
 *  Thread Starter [loopforever](https://wordpress.org/support/users/loopforever/)
 * (@loopforever)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/#post-13729544)
 * Thank you very much for your answer. I think you got me wrong.
    My scenario is
   as follows: There are no products in my store. When adding a batch product, the“
   ID” value will remain blank. So it will not write a value in the ID column of
   the table. In such a scenario when loading the product, the SKU is defined as“-“.
   The problem is here.
 * (2) I am asking so as not to create a topic again. There is no brand in the table.
   I want to upload the brand. What can I do for it ? Is there a solution in Woocommerce?
   Or any other suggestion?
    -  This reply was modified 5 years, 5 months ago by [loopforever](https://wordpress.org/support/users/loopforever/).
 *  Plugin Support [EastOfWest a11n](https://wordpress.org/support/users/eastofwest/)
 * (@eastofwest)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/#post-13730006)
 * 1) If you’re importing new products, you can delete the ID column entirely, then
   IDs will be assigned automatically. Give it a go, and let us know if that solves
   the issue.
 * 2) This question was answered in [your other thread](https://wordpress.org/support/topic/brand-and-import-export/#post-13729938).
 *  [Siew](https://wordpress.org/support/users/kosiew/)
 * (@kosiew)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/#post-13762371)
 * Hi there,
 * This thread has been inactive for a while, so I’m going to mark this as resolved–
   if you have any further questions, you can start a new thread.

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

The topic ‘Export/Import SKU Problem’ 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

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 5 replies
 * 3 participants
 * Last reply from: [Siew](https://wordpress.org/support/users/kosiew/)
 * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/export-import-sku-problem/#post-13762371)
 * Status: resolved