WooCommerce Order Dates: Display Payment Date, Not Cart Creation Date

Ensuring Accuracy: Displaying the Correct Order Date in WooCommerce Customer Communications

In the fast-paced world of e-commerce, every detail in customer communication contributes to trust and a seamless experience. For WooCommerce store owners, a subtle yet significant discrepancy can sometimes arise: the date displayed in order confirmations and the WooCommerce mobile app might reflect when a customer first added an item to their cart, rather than the actual date of purchase and payment. This article explains why this happens and provides actionable solutions to ensure your customer communications consistently display the payment date, enhancing clarity and professionalism.

The Discrepancy: Order Creation vs. Payment Date

WooCommerce, by default, often records the "order created" date as the timestamp when the customer's cart was first initiated or when the order object was first generated in the system. This can precede the actual payment by hours or even days, especially for customers who use their cart as a wishlist or take time to finalize their purchase. The "order paid" date, conversely, is the precise moment the transaction was successfully processed.

When customer-facing emails (like order confirmations, processing notifications, or completed order alerts) and the WooCommerce mobile app pull the order.date_created variable, they present this initial timestamp. This can lead to confusion, as customers naturally expect their confirmation to reflect when they actually paid for their goods.

Why Consistent Date Display Matters

When customers receive an order confirmation, they expect it to reflect the precise moment of their purchase. A mismatch between the displayed date and their payment date can lead to confusion, erode trust, and generate unnecessary customer service inquiries. Beyond customer perception, accurate date display is crucial for internal record-keeping, invoicing, and potential dispute resolution, ensuring all parties have a clear, consistent timeline of the transaction.

Solution 1: Customizing Email Templates for Targeted Display (Recommended)

The most straightforward and recommended approach is to modify your WooCommerce email templates to specifically display the "order paid" date. This method is less invasive as it only changes what is shown to the customer without altering the core order creation timestamp in your database, which might be relied upon by other plugins or reporting tools.

Step-by-Step Instructions:

  1. Identify Relevant Email Templates: The primary templates to modify are typically:
    • customer-processing-order.php
    • customer-completed-order.php
    • customer-on-hold-order.php
    • customer-invoice.php (if applicable)
    • admin-new-order.php (if you want internal notifications to also reflect the paid date)
    These files are located in wp-content/plugins/woocommerce/templates/emails/.
  2. Copy Templates to Your Child Theme: Never edit plugin files directly. To safely customize, copy the relevant template files into your child theme's WooCommerce email directory. For example, if you want to customize customer-processing-order.php, copy it to your-child-theme/woocommerce/emails/customer-processing-order.php. If you don't have a child theme, create one or use a plugin like "Loco Translate" or "Code Snippets" for safer modifications, though direct template overrides are best handled via child themes.
  3. Locate and Replace the Date Variable: Open the copied template file(s) in a text editor. Search for the code snippet responsible for displaying the order date. It commonly looks like this:
    get_date_created()->date_i18n( wc_date_format() ); ?>
    Replace this line with the following to display the paid date:
    get_date_paid()->date_i18n( wc_date_format() ); ?>
    Note: Ensure you are replacing the correct instance, as some templates might display multiple dates. Test thoroughly after making changes.
  4. Save and Test: Save the modified files and upload them to your child theme. Place a test order through your store to verify that the order confirmation emails now correctly display the payment date.

Solution 2: Modifying the Order Creation Date via Custom Code (Advanced)

An alternative, more impactful solution involves programmatically updating the order's date_created field to match the date_paid once the order transitions to a 'processing' status. This changes the underlying data for the order object itself, not just its display in emails.

While this achieves the desired outcome of consistent dates, it's a more fundamental alteration. Store owners should consider the potential implications for other plugins, custom reports, or integrations that might rely on the original date_created timestamp. This method is generally recommended only if you have a specific need for the core order creation date to always match the payment date across all system functions, and you are confident in its impact on your specific setup.

Implementation (Use with Caution):

Add the following PHP snippet to your child theme's functions.php file or via a code snippets plugin:

/**
 * Set the order creation date to the payment date when an order becomes Processing.
 *
 * @param int    $order_id   Order ID.
 * @param string $old_status Previous order status.
 * @param string $new_status New order status.
 */
add_action( 'woocommerce_order_status_changed', 'sync_order_creation_to_payment_date', 99, 3 );
function sync_order_creation_to_payment_date( $order_id, $old_status, $new_status ) {
    // Only proceed if the new status is 'processing'
    if ( 'processing' !== $new_status ) {
        return;
    }

    $order = wc_get_order( $order_id );

    // Ensure the order object is valid
    if ( ! $order ) {
        return;
    }

    $date_paid = $order->get_date_paid();

    // If a paid date exists, update the order's creation date
    if ( $date_paid ) {
        $order->set_date_created( $date_paid->getTimestamp() );
        $order->save(); // Save the changes to the order
    }
}

Important Considerations: Always back up your website before adding custom code. Use a child theme or a code snippets plugin; never edit core plugin or parent theme files directly. If you are unsure about implementing custom code, consult with a WooCommerce developer.

Choosing the Right Approach for Your Store

For most WooCommerce store owners, the goal is simply to ensure customer communications display the correct payment date without altering core system data. In this scenario, customizing the email templates (Solution 1) is the preferred and safer method. It provides precise control over what your customers see while maintaining the integrity of your backend data. The custom code solution, while effective, should be approached with a clear understanding of its broader implications for your store's data architecture.

Conclusion

Ensuring consistency in your WooCommerce order dates—displaying the actual payment date—is a small change that yields significant benefits in customer satisfaction and operational clarity. By implementing the recommended email template customization, you can refine your customer communication, build stronger trust, and streamline your e-commerce processes. Prioritize clarity and accuracy to enhance your store's professionalism and customer experience.

View original discussion
Share: