ÃÛ¶¹ÊÓƵ

Install ÃÛ¶¹ÊÓƵ Commerce with B2B features.

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

Create the Admins in Scope user role:

• Scope: only two stores: Main Website + Website 3/Store 3.
• Resources: only Dashboard + Companies.

Create an admin user with a role Admins in Scope, for example, adminscope.

Generate specific distributed customer and company data:

1. Customers assigned to websites

   table 0-row-2 1-row-2 2-row-2 3-row-2
   Website ID	Number of customers
   1	600,000
   2	1,500
   3	500

2. Run the following query to verify the distribution:

   code language-none
   SELECT website_id, COUNT(*) FROM customer_entity GROUP BY website_id;

3. Customers assigned to companies

   table 0-row-2 1-row-2 2-row-2 3-row-2
   Number of customers	Number of companies
   1	4,500
   2	~1,000
   ~595k	1

4. Run the following query to verify the distribution:

   code language-none
   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;

Reindex all data to generate entries in the customer_grid_flat.

Log in as adminscope.

Go to Customers > Companies.