VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Get pricing from different database?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - September 03 2009 :  12:08:33  Show Profile  Reply with Quote
rather than having to maintain our sales/manufactuing database (pricing for 1000's of items) and then update the VPASP database when prices change, can VPASP read the prices from another database, SQL or ACCESS?


4286 Posts

Posted - September 03 2009 :  19:19:31  Show Profile  Visit support's Homepage  Reply with Quote
Hi there

You would need to do quite a few code changes but this could certainly be done. VPASp is open source so you can make pretty much whatever changes you like to achieve what you need.


VPASP Support
Go to Top of Page

Starting Member

34 Posts

Posted - September 10 2009 :  21:08:08  Show Profile  Reply with Quote
Are both sql databases? Do they share a common identfier ie. same product id or name? if so, this would not be that hard.
Go to Top of Page

VP-ASP Super User

260 Posts

Posted - September 20 2009 :  18:20:54  Show Profile  Visit ironhawker's Homepage  Reply with Quote
Split Database Setup Guide:

here is Step 4 (you have to do the other 3)
Step 4.
Once you have split your databases, you need to let VPASP know where to look for the tables.

Log into your shop administration pages, and click on the Set-Up tab. (Note: your page formatting may look a little strange at first, but will be resolved once you tell VPASP where to look for the databases)

In the field name search box type db and click search.

Enter the names of the databases (without the .mdb extension) into their corresponding configuration setting - eg. xprojectdb = projects

Randy "RC" Corn
Institute for Higher Learning
[email protected]
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000