How can I enable “Allow Remote Assistance” for all existing customers in Magento 2?

To enable Allow Remote Assistance for all customers in your Magento 2 store, you can run an SQL query directly on your database.

Magento stores this preference in the table login_as_customer_assistance_allowed.

Each record links to a customer by their customer_id.

Here’s the SQL command to enable it for every existing customer:

INSERT IGNORE INTO login_as_customer_assistance_allowed (customer_id)
SELECT entity_id FROM customer_entity;

• INSERT IGNORE → Ensures duplicates are skipped if some customers already have the setting enabled.
• customer_entity → Contains all registered customers (entity_id is their unique ID).
• login_as_customer_assistance_allowed → The table where Magento stores the flag for allowing assistance.

This query inserts every customer’s ID into the table, effectively enabling Allow Remote Shopping Assistance for all of them.