Category: MForM Specific

M4M Stocktake notes 20210331

Check for Grouped / variable published products where have stock quantities or manage stock = yes Check for any set to out of stock as well.. Consider: any published Grouped products should be accounted for in manual stock on hand Check for Simple Published products where stock management not set correctly, should all be Manage […]

Relocation

Handy: largest tail lift truck , 189 per day midweek special -10% Large truck internal they say is 4.36L x 2.07W x 1.95H: can take 24 x 3 drawer cabs in theory with aluminum on top Load 1:00 Up 4:00 Unload 1:00 Down 4:00 Total 10:00 3 Trips in 2 days rental, 250km x 6 […]

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’;