https://www.willdesign.co.nz/car-van-signage
Demo traders $29 4mm Poplar Core Okoume Veneer Plywood
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 […]
Todo: GPU Sag Water cool GPU (Kraken G12 + Kraken ??) 20200729 Software Chrome + Firefox NZXT CAM Oculus Tools 20200729 Initial setup Tidied PSU cable routing Tidied some other cable routing Put back in GTX 1080 Removed SSD & put in a new Crucial MX500 1000GB SATA M.2 2280 SSD (CT1000MX500SSD4) Win 10 Home […]
select * from vOrderItemMetaDataV3 where order_id = 7509; insert into wp1_woocommerce_order_itemmeta (order_item_id, meta_key, meta_value) values (29897, ‘length’, ‘1000’) ; select * from wp1_woocommerce_order_itemmeta where order_item_id = 29897;
Qty What Notes Addons 1 PCDuino V1 RJ45 jack fell off 1 Raspberry Pi 2011.12 Model A Revision 2.0 (256MB or 512MB)PCB says: “Raspberry Pi (c)2011.12” Adafruit Pi T CobblerNicegear Pi IO Board 1 MXCHIP EMWE-3165-AV1.0 EMW3185 Dev Board ( Seedstudio ) STLink V2.0 1 Beaglebone Rev A6a 2 BeagleBone Black Rev A5C Adafruit Beaglebone project cape
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 […]