In the pasted code is my Product menu code. The problem is that, whenever i edit a product, even though there is akready a "Expiration Date" data under that product, it still require to input a espiration dta when im editing. Here is the code: prefix . 'products'; $category_table_name = 'categories'; // Adjust if you use prefixes: $wpdb->prefix . 'categories'; $inventory_history_table_name = 'inventory_history'; // Ensure upload directory exists $upload_dir_info = wp_upload_dir(); $upload_dir = $upload_dir_info['basedir'] . '/product_images/'; $upload_url = $upload_dir_info['baseurl'] . '/product_images/'; // Base URL for displaying images if (!file_exists($upload_dir)) { wp_mkdir_p($upload_dir); // Use wp_mkdir_p for recursive creation } $editing_product = null; // Initialize editing product variable $message = ''; // For success/error messages $message_type = ''; // 'success' or 'error' // Function to log inventory actions function log_inventory_action($action_type, $item_type, $item_name, $description) { global $wpdb; $history_table_name = 'inventory_history'; $username = wp_get_current_user()->user_login; $result = $wpdb->insert( $history_table_name, array( 'username' => $username, 'action_type' => $action_type, 'item_type' => $item_type, 'item_name' => $item_name, 'description' => $description, 'timestamp' => current_time('mysql') ), array('%s', '%s', '%s', '%s', '%s', '%s') ); return $result; } // --- Handle Delete Product Action --- if (isset($_GET['action']) && $_GET['action'] === 'delete_product' && isset($_GET['id']) && isset($_GET['_wpnonce']) && wp_verify_nonce($_GET['_wpnonce'], 'delete_product_' . absint($_GET['id']))) { $product_id_to_delete = absint($_GET['id']); if ($product_id_to_delete) { // Get product info before deletion for logging $product_to_delete = $wpdb->get_row( $wpdb->prepare("SELECT name FROM $product_table_name WHERE id = %d", $product_id_to_delete), ARRAY_A ); // Optional: Delete image file first $image_url_to_delete = $wpdb->get_var($wpdb->prepare("SELECT image_url FROM $product_table_name WHERE id = %d", $product_id_to_delete)); if ($image_url_to_delete) { $image_path = str_replace($upload_url, $upload_dir, $image_url_to_delete); if (file_exists($image_path)) { @unlink($image_path); } } // Delete product record $deleted = $wpdb->delete( $product_table_name, array('id' => $product_id_to_delete), array('%d') ); if ($deleted) { $message = 'Product deleted successfully!'; $message_type = 'success'; // Log the deletion action log_inventory_action( 'delete', 'product', $product_to_delete['name'], "Product {$product_to_delete['name']} was deleted from the system" ); // Redirect after delete to clear URL parameters wp_redirect(remove_query_arg(array('action', 'id', '_wpnonce'))); exit; } else { $message = 'Error deleting product.'; $message_type = 'error'; } } } // --- Handle Edit Product Action (Prepare form) --- if (isset($_GET['action']) && $_GET['action'] === 'edit_product' && isset($_GET['id'])) { $product_id_to_edit = absint($_GET['id']); if ($product_id_to_edit) { $editing_product = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $product_table_name WHERE id = %d", $product_id_to_edit), ARRAY_A ); if (!$editing_product) { $message = 'Product not found for editing.'; $message_type = 'error'; } } } // --- Handle Add/Update Product Form Submission --- if (isset($_POST['save_product']) && isset($_POST['_wpnonce_product_form']) && wp_verify_nonce($_POST['_wpnonce_product_form'], 'save_product_action')) { // Sanitize and validate input data $product_name = isset($_POST['product_name']) ? sanitize_text_field($_POST['product_name']) : ''; $product_category = isset($_POST['product_category']) ? sanitize_text_field($_POST['product_category']) : ''; $unit = isset($_POST['unit']) ? sanitize_text_field($_POST['unit']) : ''; $buying_price = isset($_POST['buying_price']) ? preg_replace('/[^0-9.]/', '', $_POST['buying_price']) : '0'; $selling_price = isset($_POST['selling_price']) ? preg_replace('/[^0-9.]/', '', $_POST['selling_price']) : '0'; $quantity_submitted = isset($_POST['quantity_input']) ? absint($_POST['quantity_input']) : 0; $expiration_date = sanitize_text_field($_POST['expiration_date']); $edit_product_id = isset($_POST['edit_product_id']) ? absint($_POST['edit_product_id']) : 0; $product_image_url = isset($_POST['old_image_url']) ? esc_url_raw($_POST['old_image_url']) : ''; // --- Image Upload Handling --- if (isset($_FILES['product_image']) && $_FILES['product_image']['error'] === UPLOAD_ERR_OK) { $file = $_FILES['product_image']; if (!function_exists('wp_handle_upload')) { require_once(ABSPATH . 'wp-admin/includes/file.php'); } $upload_overrides = array('test_form' => false); $movefile = wp_handle_upload($file, $upload_overrides, current_time('mysql')); if ($movefile && !isset($movefile['error'])) { $product_image_url = $movefile['url']; if ($edit_product_id && isset($_POST['old_image_url']) && $_POST['old_image_url'] !== $product_image_url) { $old_image_path = str_replace($upload_url, $upload_dir, esc_url_raw($_POST['old_image_url'])); if (file_exists($old_image_path)) { @unlink($old_image_path); } } } else { $message = 'Image upload error: ' . esc_html($movefile['error']); $message_type = 'error'; } } elseif (isset($_FILES['product_image']) && $_FILES['product_image']['error'] !== UPLOAD_ERR_NO_FILE) { $message = 'Image upload error code: ' . $_FILES['product_image']['error']; $message_type = 'error'; } // Proceed only if no upload error occurred or no file was uploaded if ($message_type !== 'error') { if (!empty($product_name) && !empty($product_category) && is_numeric($buying_price) && is_numeric($selling_price)) { $product_data = array( 'image_url' => $product_image_url, 'name' => $product_name, 'category' => $product_category, 'unit' => $unit, 'buying_price' => (float)$buying_price, 'selling_price' => (float)$selling_price, 'expiration_date' => $expiration_date, ); $data_format = array('%s', '%s', '%s', '%s', '%f', '%f', '%s'); if ($edit_product_id) { // --- UPDATE existing product --- $current_stock = $wpdb->get_var( $wpdb->prepare("SELECT in_stock FROM $product_table_name WHERE id = %d", $edit_product_id) ); if ($current_stock === null) { $message = 'Error: Could not find product to update stock.'; $message_type = 'error'; } else { $new_stock_value = absint($current_stock) + $quantity_submitted; $product_data['in_stock'] = $new_stock_value; $data_format[] = '%d'; $updated = $wpdb->update( $product_table_name, $product_data, array('id' => $edit_product_id), $data_format, array('%d') ); if ($updated !== false) { $message = 'Product updated successfully!'; $message_type = 'success'; // Log the update action log_inventory_action( 'update', 'product', $product_name, "Product {$product_name} was updated. Stock changed by {$quantity_submitted} (new total: {$new_stock_value})" ); $editing_product = null; } else { $message = 'Error updating product. ' . $wpdb->last_error; $message_type = 'error'; } } } else { // --- INSERT new product --- $product_data['in_stock'] = $quantity_submitted; $product_data['created_at'] = current_time('mysql'); $data_format[] = '%d'; $data_format[] = '%s'; $inserted = $wpdb->insert( $product_table_name, $product_data, $data_format ); if ($inserted) { $message = 'Product added successfully!'; $message_type = 'success'; // Log the add action log_inventory_action( 'add', 'product', $product_name, "Product {$product_name} was added with initial stock of {$quantity_submitted}" ); } else { $message = 'Error adding product. ' . $wpdb->last_error; $message_type = 'error'; } } } else { $message = 'Please fill in all required fields with valid data.'; $message_type = 'error'; } } } elseif (isset($_POST['save_product'])) { $message = 'Security check failed. Please try again.'; $message_type = 'error'; } // --- Fetch Products and Categories for Display --- $sql = "SELECT id, image_url, name, category, unit, in_stock, buying_price, selling_price, expiration_date,created_at, updated_at FROM $product_table_name"; $where = ''; $search_term = isset($_GET['product_search']) ? sanitize_text_field(wp_unslash($_GET['product_search'])) : ''; if (!empty($search_term)) { $search_like = '%' . $wpdb->esc_like($search_term) . '%'; $where = $wpdb->prepare( " WHERE name LIKE %s OR category LIKE %s OR unit LIKE %s", $search_like, $search_like, $search_like ); } $order_by = " ORDER BY name ASC"; $products_sql = $sql . $where . $order_by; $products = $wpdb->get_results($products_sql, ARRAY_A); $categories = $wpdb->get_results("SELECT name FROM $category_table_name ORDER BY name ASC", ARRAY_A); ?> Product Management

Products Management

Product Name: Category: Unit:

Product Image:

Current image shown. Upload a new file to replace it. Buying Price: Selling Price:

Current Stock: . Enter amount to add. Expiration Date:

Cancel Edit

Product List

'edit_product', 'id' => $product['id']], get_permalink()); $delete_url = add_query_arg([ 'action' => 'delete_product', 'id' => $product['id'], '_wpnonce' => wp_create_nonce('delete_product_' . $product['id']) ], get_permalink()); ?>

No.	Image	Product Name	Category	Unit	In-Stock	Buying Price	Selling Price	Expiration Date	Date Created	Date Updated	Action

	No Image										Edit Delete