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 2020T 2020V 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 2040T 24 Bundles = 24 x 6 x 2.5 = 360m Loose: 3 x 1200 = 3.6m Loose 2 x 2.5 = 5m Loose 5 x 1.5 = […]
20191218 As our hosting plan is somewhat restrictive, I don’t wanna fire off complex queries unnecessarily so maybe creation of like a mini DW snapshots Sample questions: Who bought product xyz Click on an order and see everything the customer has ever bought in a single view – different aggregations in case not registered: name […]