homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Gold Sponsor 2015!
Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

Order Processing From Multiple Locations Using 1 Database?

5+ Year Member

Msg#: 4432089 posted 2:47 pm on Mar 22, 2012 (gmt 0)


Is it possible to set up in admin the ability to process orders from multiple locations but still be using 1 central database?

One way I was thinking of doing this is to use the PC's IP address to determine the warehouse location. Then when an employee logs into the system to process orders it will just filter the order processing pages to show orders only from that location. This way they don't see orders from all locations and get confused about what orders they need to process.

Would this be possible to do? Is this how it normally works with websites that have multiple locations and still use 1 central database?

Thank you,




10+ Year Member

Msg#: 4432089 posted 3:46 pm on Mar 22, 2012 (gmt 0)

Or just link it to a users login details?


WebmasterWorld Administrator lorax us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

Msg#: 4432089 posted 7:45 pm on Mar 22, 2012 (gmt 0)

It can be done in different ways but there are pros and cons. Remote access to a database on another domain or server can be a security risk. If the sites are all on one server, then you should be able to access them more securely.

If this is a new site, you may want to consider using an offsite cart setup (monthly fee) where the service provider handles the cart and all of the PCI compliance issues and gives you a standardized suite of payment processors and shipping agents to choose from. Then you can have multiple stores feeding into one common back end. Secure, less headaches, and flexibility.


5+ Year Member

Msg#: 4432089 posted 8:03 pm on Mar 22, 2012 (gmt 0)

Thanks for the replies!

The way I have it setup currently is I use 1 dedicated server through a hosting company. So the database/backend will be in one central location, and different locations users would just log in to the backend by using the website admin login page.

So what I'm struggling with now is since users will be logging in to the same website admin from different warehouse locations; how do I separate my "order processing" pages to just show the users orders from that location only?

Because I don't think it will be a good idea to show users who are processing orders; orders from both warehouses because then I can see running into issues with 1 user trying to process an order that belongs to the other warehouse.

haggul, that's a good idea; I didn't think about taking that approach.

Thank you, again!



10+ Year Member

Msg#: 4432089 posted 8:37 pm on Mar 22, 2012 (gmt 0)

Yeah just link a user profile with a warehouse profile then use that as a filter - should be straight forward enough. A master or super user could be linked to all warehouses and see all activity.

I've done similar with running multiple front end brands from one back end database.


Msg#: 4432089 posted 9:56 pm on Mar 22, 2012 (gmt 0)

Are all of your orders coming into one centralized database from the various channels you sell in (assuming you sell in different channels)?

Are you basically trying to make it so your different warehouses/dropshippers can log in every day and see what orders are theirs? (opposed to you having to sort through them and manually send them to each fulfillment center)


Msg#: 4432089 posted 2:31 am on Mar 23, 2012 (gmt 0)

That might work if they have static IP addresses and not dynamic.

I'm a senior .net developer and do stuff like this all of the time.

You could have a users table...
more columns...

You could have a locations table

Then you could have a cross reference table

The cross reference table would map the user to the location.

After the user has been authenticated to your web site, you would pull their location and display appropriate content.

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved