Skip to content

Instantly share code, notes, and snippets.

@redesigned

redesigned/sqlfix

Created July 5, 2013 06:17
Show Gist options
  • Save redesigned/5932343 to your computer and use it in GitHub Desktop.
Save redesigned/5932343 to your computer and use it in GitHub Desktop.
Download ZIP
Fix for deleted shipping method, in this case matrix rate. This problem occurs as Magento is not very good at clearing out shipping methods when you delete them. The shipping method can be the name of any shipping extension you have deleted.
Raw
sqlfix
SELECT * FROM core_config_data WHERE path LIKE "carriers/matrixrate%";
-- If you are happy that the result set is that which you want to delete (should be around 15 rows) do following:
DELETE FROM core_config_data WHERE path LIKE "carriers/matrixrate%";
@Byivi01
Copy link

Byivi01 commented Oct 11, 2023

I'm working with Medusa and my shipping methods are always deleted. In my payment gateway, there are some options that add new line items, and I wouldn't want the shipping_options to be removed. Could you help me by explaining how I could do it? Or is it currently impossible?

I have tried to create a new variable with the previous fields, but it still does not work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment