• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

How to connect two or more magento sites?

I have a Magento eCommerce site.
I have two clients who have two separate Magento eCommerce sites.
So, three sites in total.

I would like to dislpay products from their sites on my site.

Naturally the stocks are shared so if an item gets sold on my site and let's say it was the last item in stock, immediately my client should not be able to sell the same product on his site. It should show up as "OUT OF STOCK".

Is this even possible without manully exporting CSV product lists from my clients' sites and importing them to my site? That would not be an ideal scenario as there is no control over stocks etc. in that method.

Please assist.
Thanks in advance
  • 2
1 Solution
Julian HansenCommented:
I imagine it is possible to create a plugin that intercepts stock changes and pushes those changes to other systems - either through a transaction log that is periodically uploaded or via a web service call or a combination.

Personally I have not attempted this.

The other option is to create a trigger on the stock tables and then update the other tables on change. Apparently the Federated engine (MySQL 5.4) can do remote updates in triggers - again - have not explored this option myself.
badwolfffAuthor Commented:
Is there an extension that does any of this was my question.
I am not able to program what you mention above myself.
Julian HansenCommented:
This forum has a discussion on this which might be useful.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now