A merchant is asking you to organize a catalog of 9000 rings which come in six sizes, each with unique inventory. Additionally, the customers will have 1000 unique engravings to choose from for their ring. The engraving is made on the selected ring just before the order is shipped.
How do you organize such a catalog to achieve optimal store performance and ease of management?
You are working on a project where many catalog managers often change products in the admin panel.
The merchant is considering changing the indexers mode to "Update on Schedule" from "Update on Save" to achieve better performance. However, the merchant is concerned about data consistency and the probability of the scheduled updates being lost.
How does Magento store the IDs of updated products for reindex in "Update on Schedule" mode?
Your company asks you to create the option to disable RMA for the customer group named CustomerGroup1. How do you do it?
You are working on a project with a large database with many products, sales rules and CMS pages. The merchant is going to use Magento_Staging for scheduled updates, but they were told that use of Staging will modify all SQL queries and slow down website performance.
What modification does Magento_Staging make to existing SQL queries?
You are integrating an external system from which products and categories will be synchronized with Magento.
To keep the category tree synchronized, an identifier attribute needs to be added to the catalog_category entity. The identifier value is generated by the external system as an unsigned 3 byte integer and is global in scope. Your code will run many concurrent queries to select categories based on this ID in order to synchronize changes.
Keeping performance in mind, what attribute backend type do you choose when creating the EAV attribute?