在WooCommerce中存储每种送货方式的设置在哪里？

Question

I have two separate e-commerce platforms.

1. A large, old system that drives all the orders and dispatch.
2. An online store powered by WordPress / WooCommerce.

So far, we've managed to automate a lot of simple things like pulling orders from WP, and pushing updated stock levels to it.

One thing I cannot fathom, however, is when I create free_shipping method and set a minimum spend. Where is that stored in the DB?

Answer 1

You can ask to yourself: Where do Wordpress plugins store their settings?

The answer is simply the wp_options table.

If your "Free shipping" Shipping method ID is free_shipping:10 you can use:

$free_shipping = get_option( 'woocommerce_free_shipping_10_settings' ); 
$min_amount    = $free_shipping['min_amount'];

To retrieve the array of data, where woocommerce_free_shipping_10_settings is the option_name.

The following SQL search query will retrieve all your "Free shipping" methods settings:

SELECT * FROM `wp_options` WHERE `option_name` LIKE 'woocommerce_free_shipping%'