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 […]
Category: MForM Specific
https://www.willdesign.co.nz/car-van-signage
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 […]
Open in Gimp Shift C to crop, select, enter Colours -> Levels In dialog select ‘Pick white point’ eye dropper icon/button Select background click ok Export As (CTRL-SHIFT-E)
— 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 […]
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’;
20200512 Warning: This page is just a StreamOfConsciousness(tm) Issue: managing 1000 sku’s is hard work vProduct sales shows totals for %complete% orders we want to be able to set stock levels whilst picking orders we do not differentiate in woocommerce states orders that are picked vs unpicked.. BUT when picking, and stock checking, I want […]
Dimension Physical Storage 3030 4040 H 1 0.95 Per H: 30 22 L 3.65 3.65 CM W 1.8 1.7 5.89 W 1.7 1.6 5.55 W 1.6 1.5 5.20 W 1.5 1.4 4.85 W 1.4 1.3 4.51 Per W 42 31 W 1.3 1.2 4.16 Len 1260 682 Meters 4599 2489.3
Extrusion 2020V 20200331 89 Bundles = 89 x 12 x 2.5 = 2670m Loose 3 x 2.5 = 7.5m Loose 13 x 1.5 = 19.5 Total: 2697m 2020V 20210331 (8 x 6 -1) + 3 Bundles = 50 x 12 x 2.5 = 1500m Loose 7 x 2.5 = 17.5m Loose 4 x 1.5 = […]