How to find out what my store ID is?

Question

How do I figure out what my store view ID's are?

This is required when modifying tables within database.

Why do you need this store id? If you really need it, get a look into the database in the table core_store. — Alexandre, Feb 21 '12 at 08:41
@Alexandre You need it for example when inserting products via the API. — feeela, Feb 28 '12 at 14:46
Related question: http://stackoverflow.com/questions/2713042/how-to-get-store-information-in-magento — Mukesh Chapagain, Aug 29 '13 at 10:37

score 21 · Accepted Answer · answered Feb 21 '12 at 12:01

21

Screenshot to illustrate Jevgeni Smirnov's answer:

enter image description here

As he said, you should go to System -> Manage Stores and click on needed store name in the right column.

answered Feb 21 '12 at 12:01

Dmytro Zavalkin

5,265
1
30
34

score 8 · Answer 2 · answered Feb 21 '12 at 06:10

When you click on the specific store in Manage stores in the URL bar there should be a parameter like store_id or something like that. This is your store id. Or when in Manage stores screen if you hover over store and the link might be displayed in the right(left) corner of your browser. In the url there is store_id param. This is the easiest I guess.

Or in database there is table: core_store.

score 7 · Answer 3 · edited Aug 02 '20 at 16:22

Pragmatically you can get the website id, website name, store id, store name and store code like this:

<?php
echo "Website ID: " . Mage::app()->getWebsite()->getId() . "<br/>"; 
echo "Website Name: " . Mage::app()->getWebsite()->getName() . "<br/>"; 
echo "Store ID: " . Mage::app()->getStore()->getId() . "<br/>"; 
echo "Store Name: ".Mage::app()->getStore()->getName(). "<br/>";
echo "Store code: ". Mage::app()->getStore()->getCode()."<br/>";
?>

Here is an example looping through all the websites and print all store id and store names you have set up in your Magento:

<?php
foreach (Mage::app()->getWebsites() as $website) {
    foreach ($website->getGroups() as $group) {
        $stores = $group->getStores();
        foreach ($stores as $store) {
            echo $store->getId() ." ".$store->getName()."<br/>";
        }
    }
}
?>

michelem · Answer 4 · 2015-11-20T18:46:58.197

6

To get store_id from store_code use:

echo Mage::app()->getStore('store_code')->getId();

edited Nov 20 '15 at 18:46

answered Mar 22 '13 at 17:40

michelem

14,430
5
50
66

score 5 · Answer 5 · edited Mar 27 '15 at 09:46

5

Look into the core_store table in the database.

edited Mar 27 '15 at 09:46

hakre

193,403
52
435
836

answered May 09 '14 at 19:03

Hubert Perron

3,022
5
34
28

That's for Magento 1. For Magento 2 look at `store` and `store_website` tables. – pevik Aug 02 '20 at 16:26

score 1 · Answer 6 · answered Feb 27 '13 at 07:37

1

you should go to "System -> Manage Stores" and click on needed store view name in the right column. click/hover on this and check url you find store id under url after /store_id/

same as ----- system_store/editStore/store_id/1/key/

answered Feb 27 '13 at 07:37

Kapil Gupta

194
5
21

How to find out what my store ID is?

6 Answers6

Linked