Syncronize Products between 2 stores
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2976
Printed Date: 24-July-2025 at 8:43pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Syncronize Products between 2 stores
Posted By: hometownworks
Subject: Syncronize Products between 2 stores
Date 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 |
Replies:
Posted By: Greg Dinger
Date Posted: 24-August-2009 at 1:38pm
Posted By: hometownworks
Date 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 |
Posted By: Guests
Date 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)? |
Posted By: hometownworks
Date 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 |
Posted By: Guests
Date 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. |
Posted By: Greg Dinger
Date Posted: 24-August-2009 at 11:26pm
Posted By: hometownworks
Date 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 |
Posted By: Guests
Date Posted: 24-August-2009 at 11:37pm
Does your host's control panel provide a scheduled task?
|
hometownworks wrote: