Architecture - 2.3 Websites, Stores, and Store Views

Question 1

What are the MySQL table names of Website, Store, and Store View called?

Answer 1

store_website, store_group, and store respectively.

Question 2

Whats is a website?

Answer 2

Represents a unique domain name. This is the “parent” of the whole system. It allows you to maintain different lists of customers and different product pricing. Products are assigned to a website.

• is the top-level container for sites, shipping methods, payment methods, and more. To create completely separate sites that do not share cart, shipping methods, or other you must create separate websites.
• Website customer accounts can be shared between multiple websites within a single Magento instance. A website contains at least one store. Catalog prices should be managed at the website level.

Question 3

Whats is a store?

Answer 3

• Represents groupings of store views. This is not used much in products or categories.
• stores share same customer accounts, currency and prices.
• stores can have different products assigned. (category roots)
• is contained by a website. In turn, a store contains at least one store view.
• Multiple stores can share cart, user sessions, payment gateways, and more, but they have separate catalog structures and Catalog price.
• Catalog Qty (inventory) can not be managed at the store level. Inventory is managed at Website or Global level only.
• Store views change the way pages are presented, and are typically used to display a store with different layouts or languages. You can manage different currencies per store view.

Question 4

What is a store view?

Answer 4

• Often a different language but could be a different store. This is used to configure pricing, attributes, and more for categories and products.
• have the same root category for all store views.

Question 5

Where do you find administration of websites, stores, and store views?

Answer 5

Stores -> All Stores

Question 6

Localization, taxes and pricing in websites, stores and store views

Answer 6

Again, these are customized in websites and store views (but not for a store).

Question 7

Product attribute scope

Answer 7

Applies to either global (everything) or a store view. If it is global, store view will not change the value. If the attribute’s scope is set to be store view, then it will be dependent on the store’s scope. If you look at the table, store_id is mapped to the store table.