Note: No pricing changes here: select * from wp1_woocommerce_order_items where order_id = 7934; select * from wp1_woocommerce_order_itemmeta where order_item_id = 32168; update wp1_woocommerce_order_itemmetax set meta_value = ‘3373’ where meta_id = 237358 and meta_key = ‘_product_id’; update wp1_woocommerce_order_itemsx set order_item_name = ‘E3D Style Heat Break Throat M7-M6 / 22mm / 1.75mm / All Metal’ where order_item_id […]
Category: WooCommerce
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;
— 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 […]
Editing orders in Woocommerce 2.x.x: Paypal order: can’t be edited can do refunds Non Paypal orders: Can edit, in which is case is reflected on the invoice Can do refunds Refunds actioned through the Woocommerce orders view are a new separate post (so can probably have multiple refunds) posts table: post_type = ‘shop_order_refund’ post_parent = […]
Important Tip #1: Make the Group name as generic as Possible so it can be used across as many products as possible: Each different group is a separate meta_key in woocommerce_order_itemmeta so the more of these different options the more back end work Tip#2: If the same options are across multiple products be sure to […]
After PHP 7 upgrade Warning: A non-numeric value encountered in /home/mecha4ma/public_html/wp-content/plugins/woocommerce-shipping-flat-rate-boxes/includes/class-wc-shipping-flat-rate-boxes.php on line 344 Line 344: // add fee $cost += $this->get_fee( $this->fee, $package->value ); Change to: // add fee $cost += (float)$this->get_fee( $this->fee, $package->value );
Paypal orders are sorta locked xx — wp1_postmeta update wp1_postmeta set meta_value = ‘0.00’ where post_id = 3387 and meta_key = ‘_order_shipping’; update wp1_postmeta set meta_value = ‘0.00’ where post_id = 3387 and meta_key = ‘_order_shipping_tax’; update wp1_postmeta set meta_value = ‘10.36’ where post_id = 3387 and meta_key = ‘_order_total’; — wp1_woocommerce_order_itemmeta update wp1_woocommerce_order_itemmeta oim […]
Potential dashboard / tabular reports for Woocommerce product to sales analysis Top view = ‘Sales by product’ Product centric view Columns: General Meta: Sku Name Category count = how many categories product appears in Category, (1st lowest only) Sales Net $ total Net $ per prev 12 months Net $ per prev months 13-24 Net […]