ProductDatabase History (phpmyadmin)

  • Resolved fenzar

    (@fenzar)


    2 years, 4 months ago

    Hello.
    I made a stupid mistake to change entire products available without database backup.
    Anyway.. by mistake I changed all products to: In Stock .. but I have a lot of products which are Out Of Stock and now I need to change them manually again ( 1500+ products )
    My hosting didnt provide me any backups so I need to find some other options.

    Is there any chance to found History log for the products and their Status in PhpMyAdmin ?
    I mean something which I can see Product X is changed from OutOfStock to InStock ( or similar but to know which products is changed )

    thank you in advance
    P.S I dont have any installed plugins for history.

    Thank you in advance,
    regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter fenzar

    (@fenzar)

    If you know better way to track the history without SQL .. will be great.

    thanks

    Hello,

    Sorry to hear that, without a backup, it is difficult to say. I’d recommend exporting all your products using the default Importer/Exporter, i.e. WP-Admin > WooCommerce > Products > All Products > export.

    You’ll get a CSV file that you can open using a spreadsheet editor, the file will contain a column In stock? you can put it 1 or 0, depending on if the product is in stock or not. This is a work-around, I understand this is still a manual process.

    More information that you can check is below:
    https://woocommerce.com/document/product-csv-importer-exporter/

    I hope this helps.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘ProductDatabase History (phpmyadmin)’ is closed to new replies.