Bulk Operations

Perform bulk bill payments, MAC binding, and customer updates efficiently in ISPBills.

Bulk operations allow administrators to apply changes to many customer accounts simultaneously, saving significant time compared to editing records one by one. ISPBills supports bulk bill payment, bulk MAC binding, and bulk customer profile updates.

Bulk operations are irreversible once executed. Always verify your selection and review the preview before confirming.

Overview

Three controllers handle the different bulk operation types:

Controller Purpose
BulkCustomerBillPaidController Mark multiple customer bills as paid in a single action
BulkMacBindController Assign or update MAC addresses for multiple customers at once
BulkUpdateUsersController Update profile fields across multiple customer records simultaneously

Bulk Bill Payment

Use bulk bill payment to mark outstanding invoices as paid for multiple customers at once — useful when processing offline payments collected by field agents.

Steps:

  1. Navigate to the bulk bill payment section.
  2. Filter customers by zone, package, or status to narrow down the list.
  3. Select the customers whose bills you want to mark as paid.
  4. Choose the billing period and payment method.
  5. Review the summary showing total amount and affected accounts.
  6. Confirm the operation.

Ensure the corresponding payments have actually been received before marking bills as paid. This operation updates financial records.

Bulk MAC Binding

MAC binding ties a customer's account to a specific network device, preventing unauthorized access. Bulk MAC binding streamlines this process during initial deployment or hardware replacement cycles.

Steps:

  1. Navigate to the bulk MAC binding section.
  2. Upload a file or manually enter customer-MAC address pairs.
  3. The system validates each MAC address format and checks for duplicates.
  4. Review the mapping preview.
  5. Confirm to apply the bindings.
Format Example
Accepted MAC formats AA:BB:CC:DD:EE:FF, AA-BB-CC-DD-EE-FF, AABBCCDDEEFF

If a customer already has a MAC address bound, the bulk operation will overwrite it with the new value. The previous binding is recorded in the audit log.

Bulk Customer Update

Update shared fields across multiple customer accounts — such as changing the assigned zone, package, or status for a group of customers.

Steps:

  1. Navigate to the bulk customer update section.
  2. Select the target customers using filters or manual selection.
  3. Choose which fields to update and provide the new values.
  4. Preview the changes showing current versus new values.
  5. Execute the update.

Commonly updated fields include:

  • Assigned package or plan
  • Zone or area assignment
  • Account status (active, suspended, etc.)
  • Expiration date adjustments

Best Practices

Follow these guidelines to avoid errors during bulk operations.

  • Back up data before running large bulk operations.
  • Use filters to precisely target the intended customer group — avoid selecting all customers unless necessary.
  • Start small — test with a handful of accounts before processing hundreds.
  • Review the preview carefully. Pay attention to the affected account count.
  • Check the audit log after the operation to confirm all changes were applied correctly.
  • Schedule bulk operations during off-peak hours to minimize system load impact.