Database Maintenance (Full Cleanup)

At the beginning of a VTEX store operation, it is often necessary to test the platform functions and to get used to the tools, processes, and possible results. To revert the results of some of these operations, we provide the following URL to clean up the store database:

https://{AccountName}.myvtex.com/admin/Site/fullcleanup.aspx

On this page, you can clean up the catalog and restart the indexer, removing all products from your store.

For security reasons, only the Sponsor user has access to Database Maintenance operations. If any other user tries to access this page, a message informing the account manager's email address will be displayed, and all buttons will become inactive.

These are the operations available:

Re-register prices in SmartCheckout: When you re-register prices in SmartCheckout, the system overwrites the values with those added in the previous version.
Delete indexer products: If you delete products from the indexer, your store will no longer have any products to be displayed.

The following rules apply to the Delete Indexer Products button: ⚠️ You can perform this action only for stores with less than 10,000 products. For stores with a more extensive catalog, you must create a ticket for the VTEX support requesting an indexer cleanup and a database reindexing. ⚠️ When a user deletes products from the indexer, the account is blocked from performing this action for 24 hours. ⚠️ There is a queue to process the requests generated by the Delete Indexer Products button. After clicking the button, the estimated waiting time appears in a log at the bottom of the page. The queue is global and applies to all users to ensure the security of the VTEX platform. ⚠️

Delete products/SKUs and related items: With this operation, your products, SKUs, and related items will be permanently removed from your store.
Delete categories, brands, fields, and related items: By deleting Categories, Brands, Fields, and related items, they will be permanently removed from your store. Before performing this operation, you must delete your Products and SKUs.
Delete sellers and related items: By deleting Sellers and related items, they will be permanently removed from your store.
Schedule full reindexing: When you reindex the database, your products enter an indexing queue. The store’s products remain available for sale during the indexing process. They enter a queue for data updates and remain available for purchase on the website. Warning: After clicking on Reindex Database, the process starts automatically.

Please remember that you must Delete Indexer Products after performing any other operations on this page, except Schedule full reindexing. Otherwise, users may experience errors when accessing product, category, or search results pages.