1

I'm trying to merge Magento orders between two different stores and I'm tracking down all of the relationships. The one I'm currently trying to figure out is the customer_entity table and the sales_* tables. I don't see a foreign key or entity_id that would line the two up.

How does Magento associate customer tables with sales?

Improve this question
2
  • 2
    See sales_flat_order.customer_id Since customer can check out as guest, then customer_id is either null for quest or contain the customer id for register member
    – MagePal Extensions
    Commented Nov 4, 2014 at 18:43
  • Thanks! That's the one. You should post it as the answer.
    – sparecycle
    Commented Nov 4, 2014 at 18:45

1 Answer 1

Reset to default
3

See sales_flat_order.customer_id

Since customer can check out as guest, then customer_id is either null for quest or contain the customer id for register member

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.