glovaci
Forum Replies Created
-
@kimmyx I understand that, but it makes no sense to show “popup is unpublished” where the enabled/disabled toggle lives. It’s a bad idea and doesn’t match how WordPress posts and pages work. Unpublished should mean unpublished.
@mimosabarkstore make sure you delete the previously added CA tax rows in your woocommerce > settings > tax > standard rates table. use the “remove selected rows” button at the very bottom of that page.
/wp-admin/admin.php?page=wc-settings&tab=tax§ion=standard
We’re seeing the same issue. NY-based store, But CA ship-to is coming back from taxjar with has_nexus = 1. To fix this we modified
/plugins/woocommerce-services/classes/class-wc-connect-taxjar-integration.phpat line 982// Decode Response $taxjar_response = json_decode( $response['body'] ); $taxjar_response = $taxjar_response->tax; //Override Taxjar if (strtoupper($body['to_state']) !== 'NY'){ $taxjar_response = (object)[ 'amount_to_collect' => 0, 'freight_taxable' => $taxjar_response->freight_taxable, 'has_nexus' => 0, 'order_total_amount' => $taxjar_response->order_total_amount, 'rate' => 0, 'shipping' => $taxjar_response->shipping, 'tax_source' => null, 'taxable_amount' => 0 ]; }@aurovrata yes, I understand that. That’s why I’m telling you to either use a unique, group by, or filter the results to ensure there are no duplicates. Because as you can see from the issues… “corrupt data” is possible
@aurovrata ORDER BY will not return unique values. Are you confusing GROUP BY?
@aurovrata i don’t have an issue. My reply was telling you how to fix your plugin and the error this thread is about.
@aurovrata the issue is the initial query in
Reorder_Post_Within_Categories_Admin->_get_order()is returning duplicates.either use UNIQUE on the post_id or filter dupes with php afterwards.
SELECT rpwc_pm.post_id FROM wp_postmeta as rpwc_pm, wp_posts as rpwc_p WHERE rpwc_pm.meta_key ='_rpwc2' AND rpwc_pm.meta_value=9 AND rpwc_pm.post_id=rpwc_p.ID AND rpwc_p.post_type='article' ORDER BY rpwc_pm.meta_id;