Clear Database

In ROBOTILL Back Office, go to Home > Database > Clear Database. You can bulk delete products in a department or category, reset sales and optionally products, or start with a completely new database.

Bulk Delete Products

Use this section to delete products in one department or category while keeping sales history. It uses the same soft delete as individual product deletion: products are marked as deleted, and their database records are retained. The department or category itself is kept.

1. Under Delete by, choose Department or Category.
2. Select the specific department or category in the next list.
3. Click Delete products in selected group….
4. Review the group name and the number of products in the confirmation. Choose Yes to delete them, or No to cancel.

Variants are included: variants of matching products are also deleted, even when assigned to another department or category. They are included in the confirmation count. Products already marked as deleted are not counted again.

When deletion finishes, the page shows how many products were marked as deleted. If the group has no active products, nothing is deleted. If the matching products change before deletion, ROBOTILL stops without deleting them; review the count and confirm again. You do not need to enable Remove all sales and sales related data to use bulk deletion.

Reset Database

This option will allow you to clear all sales (and sales related data) and optionally all products (and product related data) but keep all your set up, print designs, departments, suppliers, customers, etc. 

Note: This option is intended to clear some initial testing/training data or a small database. If you have a large database with several years of data, this option might fail. In that case, you will need to use the clean database instructions below.

The Reset Database section is below Bulk Delete Products. Unlike bulk product deletion, a reset removes sales history. Make a backup first if you may need this data later.

1. Set Remove all sales and sales related data to Yes. This reveals the remaining reset options. Removing sales is required for a reset.
2. You can optionally choose to also remove all products and product related data (see below).
3. Make sure all users are logged off on all computers and confirm by selecting 'yes'.
4. Click Clear Database to perform the reset.

If you choose sales and sales related data the following will be removed:

• All sales
• All payments
• Received stock
• Discarded stock
• Stock take adjustments
• Accounts entries (payments, credits, debits)
• Drawers (shift information)
• Refunds
• Layby payments and contracts
• Cash drops and withdrawals
• Customer loyalty points and purchase history
• Bookings and orders
• Supplier orders
• All stock quantities will be set to zero.

If you choose products and product related data the following will be removed:

• Everything in the list above for sale related data.
• Product setup, compound item setup and combo deals.
• Pending price changes