• Resolved davidki

    (@davidki)


    Hi, I read one comment in reviews section of this plugin, that say “If you use WooCommerce and import products with the same name as ones you previously deleted, either through CSV or manually, their names won’t show up in the products. That’s because they are still in the database as orphans with the status of being deleted.”

    What do I need to set in the plugin, if I want delete the records of the pages in database that I’ve already removed?

    https://ww.wp.xz.cn/plugins/rvg-optimize-database/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor cageehv

    (@cageehv)

    Hey David,

    Not 100% sure what you mean…

    What’s the ‘status of being deleted’? Records are deleted or not… The plugin doesn’t mark them as status=’deleted’ (or something like that)

    So, can you be more specific?

    Thanks!
    Rolf

    Plugin Contributor cageehv

    (@cageehv)

    I also cannot find the WooCommerce ticket you are talking about…

    Maybe I’m overlooking it.

    Rolf

    Thread Starter davidki

    (@davidki)

    Here is the post about woocommerce https://ww.wp.xz.cn/support/topic/better-than-others-for-woocommerce-product-orphans?replies=1#post-

    Ok, I try to describe my question better.

    I tried to install plugins for bulk page creating. During testing these plugins I created and delete several times same pages – for example page “SPORT” and page “FITNESS”. I read on the internet that whenever I create and then delete a page with the same name, these pages are still stored in the database, although I also removed them from trash. So, I do not know how to properly configure your plugin, that those previously created pages (“SPORT” and “FITNESS”) have been deleted from database.

    After what I’ve done to optimize database, It showed me that nothing was deleted.

    Plugin Contributor cageehv

    (@cageehv)

    Hey David,

    What’s the post_status of these posts in the wp posts table?

    If WOOCommerce makes up some weird custom post_status my plugin will leave these posts alone.

    peace,
    Rolf

    Thread Starter davidki

    (@davidki)

    I can not find “post_status”, but when I do optimization, in the “engine” column for row “posts” table is written “InnoDB” and it the “optimization result” column is written “InnoDB table: skipped…”

    Plugin Contributor cageehv

    (@cageehv)

    Hey David,

    True…
    InnoDB tables are skipped from optimization by the latest versions of my plugin…

    But optimizing tables has nothing to do with cleaning the database (=removing redundant records), which is your issue.

    My question was about looking in the database (using PHPMyAdmin for instance) and see what the post_status of these (SPORT/FITNESS) posts is.

    peace,
    Rolf

    Thread Starter davidki

    (@davidki)

    ok, I found post_status in database, but pages SPORT/FITNESS are not here. I deleted these pages from Trash. When I don’t see the pages in the database, probably it will not be any problem if I re-create pages with the same name FITNESS or SPORT. Am I right?

    Does this mean that when I delete page from trash in wordpress, this page will no longer be stored in the database?

    Sorry for my strange questions, but this stuff is kind new for me.

    David

    Plugin Contributor cageehv

    (@cageehv)

    Hey David,

    The only problem while deleting these pages is that is that the permanent link will be in use… so if you create a new SPORT page the link will be SPORT-2 or something.

    My plugin gets rid of that…

    And yes, if you clear your trash the pages will be gone… (or just use my plugin for that ;-))

    Good luck!

    peace,
    Rolf

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

The topic ‘How to setup the plugin properly?’ is closed to new replies.