Product Title change to SKU

  • Resolved naniptt

    (@naniptt)


    3 years, 7 months ago

    HI,

    Recently I have had a problem which is the product title display its SKU rather than the name. Only some products are affected and not sure how and why.

    Example,

    Title product: Canvas Belt
    SKU: 098JHG87687

    When published, the product title show: Canvas Belt
    But a few weeks/months later, the product title will change to: 098JHG87687 instead of Canvas Belt. So the customer sees the SKU and when they search “Belt” in the search bar, the product doesn’t come out. And causing, the inventory can’t extract order too because the name is SKU instead of the product title.

    Question: How do we extract/detect which products are affected? Because checking all those 1500++ products in Woocommerce store will take some time. Can we do like “extract all products that contains title as SKU”?

    What I did when seeing this problem, I will manually change the name only when someone sees the issue. Sometimes the customers will be the ones who bug us about this. Currently, we might solve this, but eventually, it will happen again in the future.

    Thanks!

Viewing 1 replies (of 1 total)

  • Hi @naniptt,

    That is a really strange issue. The title is stored in the _posts table in the database. Next time you find one of these products, check the database and see what it shows for the product title. You can search this table. The product ID is the post_id for searching.

    If the SKU has been added here, then that indicates there is some code on the site that is doing this. It’s not something we’d expect to see. You could run a conflict test to see if you can find out what’s causing it but that may be difficult since this doesn’t seem to happen often.

    https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    Unfortunately, it’s probably going to be difficult to search for these short of looking through the product names. You could export the products into a CSV file and then open them up in a spreadsheet app. That would make it easier to scan the list of product titles. It would be a bit faster too.

    Let us know what you find out.

Viewing 1 replies (of 1 total)
  • The topic ‘Product Title change to SKU’ is closed to new replies.

Tags