2

In which table Magento 1.9 stores shipping methods like free shipping ,flat rate ?

Please help to find it out.

  • What do you mean my stores shipping methods? – Sukumar Gorai Sep 27 '18 at 14:32
  • I want to know the table name where shipping methods and its corresponding codes are stored. I find the code in 'sales_flat_quote_shipping_rate' table but it is order related. – Magento Learner Sep 28 '18 at 7:48
0

You will get codes and names of sipping methods under core_config_data. Not for all but yes atleast settings will be there. You need to run the following sql query in your database:

SELECT * FROM core_config_data WHERE path LIKE '%carriers%';

You will get all shipping carrier related rows will come up like below;

carriers/flatrate/active
carriers/tablerate/title
carriers/freeshipping/active

and many more.

According to the default shipping methods available in magento 1.9.x

The codes of shipping methods should be middle one of the above text like flatrate, tablerate, freeshipping etc.

You can also find the codes from Model of Magento's default Shipping Module in below files:

app/code/core/Mage/Shipping/Model/Carrier/Freeshipping.php

app/code/core/Mage/Shipping/Model/Carrier/Flatrate.php

app/code/core/Mage/Shipping/Model/Carrier/Tablerate.php

Open these files you will get like below:

protected $_code = 'freeshipping';
protected $_code = 'flatrate';
protected $_code = 'tablerate';

These are shipping method codes.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.