ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - Syncronize Products between 2 stores
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Syncronize Products between 2 stores
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
hometownworks View Drop Down
Newbie
Newbie


Joined: 17-April-2007
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hometownworks Quote  Post ReplyReply Direct Link To This Post Topic: Syncronize Products between 2 stores
    Posted: 24-August-2009 at 1:32pm
I need some serious technical advise here.  I have 2 product cart stores, and I need to be able to mirror the product in store #2 so that they match store #1.  When store #1 products get added or removed, the change needs to be reflected in store #2.
 
I've talked to a couple of database experts, and it appears that doing the data exchange in MS SQL may be difficult as I'm using shared hosting for my stores, and the databases are on different machines.
 
The other option would be to use XML.  Does anyone have any expierence doing this?  Any thoughts on MS SQL method vs. using an XML method?
 
Glen
Hometown Works Website Development
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 1:38pm
Glen - contact Mark Shipp mark@cognecy.com he already did this for another merchant.
Back to Top
hometownworks View Drop Down
Newbie
Newbie


Joined: 17-April-2007
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hometownworks Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 2:04pm
I spoke with Mark about this already, but unfortunately he was unable to help.
Hometown Works Website Development
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 8:05pm
Hi Glenn,

Does this need to happen in real time? For example, if there is inventory control? Or could it be batched periodically?

Also, the db's on different servers . . . . are they are least within the same data center (same host)?
Back to Top
hometownworks View Drop Down
Newbie
Newbie


Joined: 17-April-2007
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hometownworks Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 10:24pm
The data sync could be batched, I was thinking 4 times a day, but depending on server load, possibly once a day. Also, the databases are with the same hosting company, and I could possibly get them to put them all on the same machine, maybe.
Hometown Works Website Development
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 11:00pm
If the sites and databases are all served by the same host, then all of that should be networked together (that is, best practice is to host the SQL db separate from the sites anyways, and then it would make no difference if Site A is on a different shared server than Site B) -- so long as everything is within the same network, than there is no issue I can see.

What's more, batching makes things easier too -- 4 times a day, shouldn't be a problem unless you have a huge catalog; if it could wait until the wee hours once a day, that would be ideal, but not necessary.

What's more, if this could be limited to a small set of fields to be synchronized, all the better.

Please elucidate further exactly what data needs to be synchronized, and fee free to break it up into things (such as inventory levels) which may need to be synchronized more frequently (maybe several time a day, esp. at peak traffic) and things that would rarely need to be synchronized (such as product desctiptions, image locations, pricing, etc.).

The more detail you provide here, the more options folks here will be able to suggest for you.
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 11:26pm
Sean, I think the OP said what he wants:
 
When store #1 products get added or removed, the change needs to be reflected in store #2.
Back to Top
hometownworks View Drop Down
Newbie
Newbie


Joined: 17-April-2007
Location: United States
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hometownworks Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 11:26pm
In terms of synchronization, for the stores we're talking about, if we had Active / Inactive synched 2 times a day, and any new product information (all the details of a new product when its added) once a day would probably suffice. We don't track inventory, we just make items inactive when they are no longer going to be available.

Also, it would be great to be able to "trigger" the sync when needed. For example, it they update store #1 with 10 new items, it would be nice to sync them to stores #2-#4 with a few clicks of a button, or perhaps entering a URL which executes an .asp script?

Hometown Works Website Development
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 24-August-2009 at 11:37pm
Originally posted by hometownworks hometownworks wrote:


Also, it would be great to be able to "trigger" the sync when needed. For example, it they update store #1 with 10 new items, it would be nice to sync them to stores #2-#4 with a few clicks of a button, or perhaps entering a URL which executes an .asp script?
Yeah, I'm thinking along those lines -- a script-based mod that is both scheduled (possibly with various aspects scheduled at various periodicities) that could also be hit directly at will -- such as you suggest here.
 
Does your host's control panel provide a scheduled task?
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.