Changeset 3162012

Timestamp:

10/03/2024 10:17:11 AM (17 months ago)

Author:

PurpleTurtlePro

Message:

fixed the error notification

Location:

exportfeed-for-woocommerce-product-to-etsy/trunk

Files:

• core/ajax/wp/dashboard-data.php (modified) (1 diff)
• exportfeed-for-etsy-product-feed.php (modified) (2 diffs)
• readme.txt (modified) (2 diffs)

exportfeed-for-woocommerce-product-to-etsy/trunk/core/ajax/wp/dashboard-data.php

@@ -51 +51 @@
     global $wpdb;
     $orders_table = $wpdb->prefix . 'etcpf_orders';
-    $sync_message = 'Order synced sucessfully';
-    // Prepare the SQL query.
+    $sync_messages = ['Order synced sucessfully', 'Order Synced successfully'];
+
+    // Prepare the SQL query to exclude both message variations.
+    $placeholders = implode(', ', array_fill(0, count($sync_messages), '%s'));
+
     $sql = $wpdb->prepare(
-        "SELECT COUNT(*) FROM {$orders_table} WHERE woo_error_message != %s",
-        $sync_message
+        "SELECT COUNT(*) FROM {$orders_table} WHERE woo_error_message NOT IN ($placeholders)",
+        ...$sync_messages
     );
+
     $unsynced_order_count = $wpdb->get_var( $sql );
     return absint( $unsynced_order_count );

exportfeed-for-woocommerce-product-to-etsy/trunk/exportfeed-for-etsy-product-feed.php

@@ -6 +6 @@
  * Description: Etsy Marketplace Integration for WooCommerce: sync products, orders, and inventory in real-time
  * Author: Digital Product Labs Inc.
- * Version: 6.3.4
+ * Version: 6.3.5
  * Author URI: https://dpl.company/woocommerce-etsy-integration/
  * License:  GPL2
@@ -721 +721 @@
     }
 
-    add_action( 'admin_notices', 'etcpf_display_order_error_message' );
-    function etcpf_display_order_error_message() {
-        global $wpdb;
-        $table_name = $wpdb->prefix . 'etcpf_orders';
-        if ( get_option( 'etcpf_current_db_version' ) >= '4.0' ) {
-            $table_exists = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table_name ) );
-            if ( $table_exists ) {
-                $error_check = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->prefix}etcpf_orders WHERE woo_error_message = %s", 'Product is out of stock.' ) );
-            }
-            if ( $error_check > 0 ) {
-                echo '<div class="notice notice-error is-dismissible"><p>Etsy Feed: One (or more) of the Etsy order has not been synced to WooCommerce.<a href="admin.php?page=etsy-export-feed-order">Click here</a> to see and fix them.</p></div>';
-            }
-        }
-    }
-
     add_action(
         'etcpf_product_update_event',

exportfeed-for-woocommerce-product-to-etsy/trunk/readme.txt

@@ -4 +4 @@
 Requires at least: 5.8.0
 Tested up to: 6.6.1
-Stable tag: 6.3.4
+Stable tag: 6.3.5
 Requires PHP: 5.4
 License: GPLv2 or later
@@ -111 +111 @@
 
 == Changelog ==
+= 6.3.5 2024/10/03 =
+* Fix: Order failed message on successful order
+
 = 6.3.4 2024/09/24 =
 * Fix: Fatal Error while uploading the product.