Export/Import SKU Problem

  • Resolved loopforever

    (@loopforever)


    4 years, 3 months ago

    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

    (@loopforever)

    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 ?

    Hi there,


    Link to image: 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

    Here is an excerpt of the match fields during import:


    Link to image: https://d.pr/i/R8BK4F

    Please try the above and let us know how it goes.

    Thread Starter loopforever

    (@loopforever)

    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 4 years, 3 months ago by loopforever.
    Plugin Support EastOfWest a11n

    (@eastofwest)

    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.

    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.