Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    11
    Plugin Contributions
    0

    help question Meshing with existing inventory database

    I am bringing up zencart for the first time for our new website(s). We already have a full-fledged relational database full of all of the information we need on products. This brings up a couple issues, but what I'm dealing with right now is this:

    1. Displaying product
    I have already changed the configure.php file to point to a single external image directory. It displays broken images in the admin screen still, but it works in the cart.

    Where it really breaks down for me right now:
    Can I make zencart read off of our existing product database for all of the product detail, including quantity in stock, product attributes, etc.? Our database structure looks similar at a glance, but I have not been able to find any database information in the template sections. Would I have to go into the core code to do this? What are my options? I am looking for both fast dev time and also clean upkeep, but we want real-time inventory. The website is not the only thing touching our inventory.

    I have looked around a bit, but I haven't found any articles on this. If any exist, where can they be found? If not, how is the best way to handle this? Any ideas? I am working on a very tight deadline. Any input would be greatly appreciated.

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Meshing with existing inventory database

    You can look at the tables between the 2 and determine if the current data is structured correctly for Zen Cart. As the cart relies on the DB for so many things it would be best/fastest to bring the current data into the cart DB structured as the cart requires it. This of course depends on what type of interfacting is done with the current DB and what this is used for - bottomline need to use one DB for this and either change the cart code (which is extensive) or the existing code that is ??, to access a single DB structure

    I think thty there is a DB structure in the wiki

 

 

Similar Threads

  1. Integrating with an existing user and transaction database
    By MrMoo519 in forum Managing Customers and Orders
    Replies: 5
    Last Post: 19 Nov 2012, 06:22 PM
  2. integrate/map new Mysql database with existing zencart database
    By omerhanif in forum General Questions
    Replies: 0
    Last Post: 18 Jan 2010, 12:36 PM
  3. accessing existing product database with zencart
    By grossd in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 9 Feb 2009, 03:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg