WooCommerce import removes leading zeros from SKUs

  • Resolved Fhoke

    (@fhoke)


    3 years, 5 months ago

    I have a client who has all their product SKUs start with 0, for example 08020.

    The issue is that when I run the WooCommerce import it strips the leading zero from the SKU so it becomes 8020.

    This is causing issues with my client and how they process orders because now the SKU don’t match up with what’s in their internal system.

    Is there any way to get around or fix this?

    Thanks!

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

  • Hi @fhoke,

    One way is editing each product manually.

    And another way is, creating a function that removes only 0 from the SKU of each product. It is a topic of development or customization.

    Thank You

    Thread Starter Fhoke

    (@fhoke)

    Hi @zworthkey12vaibhav,

    Thanks for the reply.

    Unfortunately my client has 700+ products, so editing each one manually isn’t a viable option.

    Do you know of any tools which can automate this? I’m more than happy to make a bulk action to do this, but would rather not if there’s already something else which can do the job.

    • This reply was modified 3 years, 5 months ago by Fhoke.
    Mirko P.

    (@rainfallnixfig)

    Hi @fhoke,

    If you’re using Excel you can select the SKU column and format it as “Text”. That way, when you run the CSV import the leading zero will be kept.


    Link to image: https://i.imgur.com/lhrC03Q.png

    Hope this helps.

    Thread Starter Fhoke

    (@fhoke)

    Hi @rainfallnixfig,

    Perfect, that’s exactly what I needed!

    Thanks for the info!

    Plugin Support abwaita a11n

    (@abwaita)

    Glad to hear it – thanks for letting us know!

    I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WooCommerce import removes leading zeros from SKUs’ is closed to new replies.

Tags