Remove All Items / Medicines

Deletes item masters, department prices, stock, pharmacy item transactions, and prescription medicine rows across the full system.

Back to Reset Tools
Danger: This permanently removes all items/medicines and related pharmacy item data from every branch.
Run Reset Destructive
  • medicine_generics (62 rows)
  • medicine_therapeutics (29 rows)
  • medicines (65 rows)
  • pharmacy_bills (0 rows)
  • pharmacy_department_medicine_prices (0 rows)
  • pharmacy_department_stock_batches (0 rows)
  • pharmacy_department_transfer_items (0 rows)
  • pharmacy_department_transfer_request_items (0 rows)
  • pharmacy_department_transfers (0 rows)
  • pharmacy_dispense_items (0 rows)
  • pharmacy_dispense_sequences (0 rows)
  • pharmacy_dispenses (0 rows)
  • pharmacy_grn_items (0 rows)
  • pharmacy_grn_returns (0 rows)
  • pharmacy_grns (0 rows)
  • pharmacy_open_stock_returns (0 rows)
  • pharmacy_po_items (0 rows)
  • pharmacy_price_adjustments (0 rows)
  • pharmacy_purchase_orders (0 rows)
  • pharmacy_sales_return_items (0 rows)
  • pharmacy_sales_returns (0 rows)
  • pharmacy_stock_adjustments (0 rows)
  • prescription_medicines (0 rows)