Ghost products

  • Resolved mrjive

    (@mrjive)


    5 years, 6 months ago

    Hi
    I’ve got a weird situation with woocommerce products.
    I see this:
    All (103) | Published (66) | Drafts (10) | Trashed (141)

    which makes no sense since Published + Drafts is 76 and not 103

    Products are somewhere, hidden, since I get an error giving a SKU to some products: it says that the code is duplicated or invalid, no other wisible, products (even in trash) has this code.
    Is there a way to clean up those products?

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Missy a11n

    (@m155y5)

    Automattic Happiness Engineer

    5 years, 6 months ago

    Hi @mrjive –

    This sometimes happens when the column Published is not set in an imported CSV file.

    To correct this, you need to set one of these values in that column and re-import the file:
    Private – set to 0
    Draft – set to -1
    Published – set to 1

    After that you can re-import the same products and they should be available to edit in your products dashboard.

    Missy a11n

    (@m155y5)

    Automattic Happiness Engineer

    5 years, 6 months ago

    If you’re comfortable working in the database, you can also update the published column there directly.

    Thread Starter mrjive

    (@mrjive)

    5 years, 6 months ago

    Thanks for the reply!
    I’m comfortable with the DB, but cannot guess in which table the “Published” column is.
    Could you kindly give me a hint for that? Thanks!

    Missy a11n

    (@m155y5)

    Automattic Happiness Engineer

    5 years, 6 months ago

    Absolutely! You can find it as the post_status column in the wp_posts table.

    Note that if you’re updating it directly in the database, you’ll need to change the post_status to publish to make it appear in your list of products in your WordPress admin dashboard.

    It will likely look something like this: https://d.pr/i/vIedM4

    Thread Starter mrjive

    (@mrjive)

    5 years, 6 months ago

    OH great, thanks for the tip.
    I had 27 items with the status = ‘importing’.
    Now I get
    All (98) | Published (64) | Draft (34)
    which is OK!

    Thanks a lot!

    • This reply was modified 5 years, 6 months ago by mrjive.
Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Ghost products’ is closed to new replies.