Link a guest order to an existing customer account in magento

Link a guest order to an existing customer account in magento

July 23, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Link a guest order to an existing customer account in magento

Linking Guest Orders to Existing Customer Accounts in Magento

When running an e-commerce business on Magento, you may occasionally receive orders from guests who then decide to create customer accounts after the fact. In such cases, you’ll want to link these guest orders to the newly created or existing customer account for better record-keeping and improved customer service.

Understanding the Data Flow

Before diving into the database manipulation, let’s understand how Magento handles guest and registered customers:

  1. Guest Orders: Guest orders are stored in the sales_flat_order table.
  2. Customer Accounts: Customer accounts are stored in the customer_entity table (for basic customer data) and customer_address_entity for shipping addresses.

Linking Guest Orders to Existing Customers

To link a guest order to an existing customer account, you’ll need to update the sales_flat_order table. Specifically, you want to set the customer_id field to match the ID of the desired customer.

Here’s a step-by-step process:

  1. Identify the Customer ID: First, find the customer_id in the customer_entity table using the guest’s email or other identifying information.

    SELECT entity_id FROM customer_entity WHERE email = 'guest@example.com';
    
  2. Update the sales_flat_order Table: With the customer_id at hand, update the sales_flat_order table to link the order to the customer account.

    UPDATE sales_flat_order SET customer_id = <customer_id> WHERE increment_id = '00000001';
    

Remember to replace <customer_id> with the actual ID from step 1 and increment_id with your guest order’s unique identifier.

A More Efficient Approach

While manual database updates can work, Magento provides a more efficient way through its API and SOAP services. By using the API, you can update customer orders programmatically without having to touch the database directly.

Here are the key steps:

  1. Get Customer ID via API: Use the customerCustomerRepositoryV1 service to fetch the desired customer’s ID by email.

    $customer = $customerRepository->getCollection()
        ->addAttributeToFilter('email', 'guest@example.com')
        ->getFirstItem();
    
    $customerId = $customer->getEntityId();
    
  2. Update Customer ID via API: Once you have the customer_id, use the orderRepositoryV1 service to update the order.

    $order = $orderRepository->get($orderIncrementId);
    $order->setCustomerId($customerId);
    $orderRepository->save($order);
    

This approach ensures that your data remains consistent and minimizes the risk of errors compared to direct database manipulation.

Conclusion

Linking guest orders to existing customer accounts in Magento is a straightforward process once you understand the underlying tables. Whether you choose the manual database update method or opt for the more efficient API approach, always ensure you have a backup before making changes to your production environment.

For further reading on Magento’s API and services, I recommend checking out our comprehensive guide at https://laravelcompany.com/magento-api-guide. This resource provides a detailed overview of the Magento 2 API and its various endpoints, helping you to leverage the platform’s full capabilities.

Happy coding!

Database Email Orders Customers

Our network