ACSD-66311: Companies grid loads slowly for admin users with restricted website access

Categories

B2B

Components

magento/module-company

Origin

adobe-commerce-support

Since QPT

1.1.69

Issue

Companies grid loads slowly for admin users with restricted website access.

Steps to reproduce

1. Install Adobe Commerce with B2B features. 1. Create 2 extra websites (in addition to Main website) with stores/views: * Main Website (created during installation) * Website 2 → Store 2 → StoreView 2 * Website 3 → Store 3 → StoreView 3 1. Create the Admins in Scope user role: * Scope: only two stores: Main Website + Website 3/Store 3. * Resources: only Dashboard + Companies. 1. Create an admin user with a role Admins in Scope, for example, adminscope. 1. Generate specific distributed customer and company data: 1. Customers assigned to websites | Website ID | Number of customers | |------------|---------------------| | 1 | 600,000 | | 2 | 1,500 | | 3 | 500 | 1. Run the following query to verify the distribution: SELECT website_id, COUNT(*) FROM customer_entity GROUP BY website_id; 1. Customers assigned to companies | Number of customers | Number of companies | |---------------------|---------------------| | 1 | 4,500 | | 2 | ~1,000 | | ~595k | 1 | 1. Run the following query to verify the distribution: SELECT customer_count, COUNT(*) AS number_of_companies FROM ( SELECT company_id, COUNT(customer_id) AS customer_count FROM company_advanced_customer_entity GROUP BY company_id ) AS subquery GROUP BY customer_count ORDER BY customer_count; 1. Reindex all data to generate entries in the customer_grid_flat. 1. Log in as adminscope. 1. Go to Customers > Companies.

Adobe's page lists 2.4.7-p4 - 2.4.8-p1 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.9.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-66311. On Cloud, add ACSD-66311 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-66311/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-66311
• JSON API: /api/v1/patches/ACSD-66311