Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


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

bleslie
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?

support
Administrator

4679 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.

Thanks
Cam

VPASP Support
Go to Top of Page

Agravane
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

ironhawker
VP-CART Super User

USA
260 Posts
Posted - September 20 2009 :  18:20:54  Show Profile  Visit ironhawker's Homepage  Reply with Quote
Split Database Setup Guide:
http://helpnotes.vpasp.com/shopexd.asp?id=392

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]
http://www.ironhawker.com
425-828-0738
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty