Woocommerce DB checks

— DB Checks — select * from vProducts where 1 = 1 and product_type = ‘simple’ and pm_manage_stock != ‘no’ and (pm_stock_status != ‘instock’ and coalesce(pm_stock, 0) > 0); select count(*) as chk from wp1_posts where post_status not in (select post_status from m4m_refOrderStates) and post_type = ‘shop_order’; select id, pmd.post_title, pmd.pm_price, pm_regular_price from vProductMetaData pmd […]

Woocommerce price vs regular price fix

update wp1_postmeta pm join ( select id, pmd.post_title, pmd.pm_price, pm_regular_price from vProductMetaData pmd join vProducts vp on vp.wp_post_id = pmd.id where coalesce(pmd.pm_price,0 ) <> coalesce (pmd.pm_regular_price,0) and product_type = ‘simple’ ) t on t.id = pm.post_id set pm.meta_value = pm_price where pm.meta_key = ‘_regular_price’;

Workshop shuffle 20200401

Bay 3: 1100×500 x1800 2 x steel vertical cabs moved to Bay 1 3rd steel vertical cab moved upstairs for food storage Toilet wall: Cabs order left to right: Gun cab 100D cab remaining 2.5m: 4 x 3dr cabs (or 6 drawer equivakents) Mini Fridge Freezer last by toilet door On top of cabs/fridge: 1100mm […]

Bread maker

Bread Machine Recipe: How to make homemade white bread less densePrep Time10 minsCook Time3 hrs 15 minsTotal Time3 hrs 25 mins  I’ve tried many bread machine recipes, and this one works perfectly for me to make simple white bread.  The bread is tall, not dense, of perfect composition.  Basic recipe for a bread maker machine.  Course: Side DishCuisine: AmericanServings: 6 peopleCalories: 313 kcalAuthor: JuliaIngredients 1 cup and 3 tablespoons water 2 tablespoons vegetable […]