Post by jlg89 » Tue Aug 04, 2009 11:34 am

I'm working on some scripts to automate product entry and updates in OpenCart, and I need to know the relationships between the various product tables. I'm sure I can dig it out of the code, but is there a schema diagram available somewhere? That would make this task much easier.

New member

Posts

Joined
Tue Aug 04, 2009 11:32 am

Post by apeitup » Fri Jan 15, 2010 12:08 am

Did this ever get answered. I have to set up a link with access at work annd it would make it so much easier.

I figured that if I can manage to set up a good link with M$ Access it could be used to update the database with products. If it works I will make the template available to everyone.

Newbie

Posts

Joined
Sat Feb 07, 2009 7:47 pm

Post by mle » Fri Feb 25, 2011 8:30 pm

Does this still exist? I would love to get at least some kind of description how products are in db, would save a lot of reverse engineering :)

mle
Newbie

Posts

Joined
Thu Feb 17, 2011 8:25 pm

Post by chrisg42 » Thu Nov 24, 2011 9:50 am

These Database diagrams are for OpenCart 1.5.1.3.
http://www.colab-aktiv.com/?page_id=25

hope this helps

User avatar
Newbie

Posts

Joined
Sun Oct 30, 2011 2:06 pm


Post by jrr » Wed Jun 17, 2020 3:04 am

A few years back - OK, back in 2011 - someone asked the question about Database Schema for OpenCart. The only result was something based on OC 1.5 so it is a bit outdated...
Looking at the (2005) Database Schema for osCommerce https://apps.oscommerce.com/Dw3rD&ms2-d ... schema-pdfshows a robust visual diagram of how various parts of OSC worked together and related to each other and made it fairly easy to understand how the whole thing worked - particularly when trying to develop or troubleshoot the system. Harold Ponce later updated it in a blog (2009), but I can't find anything later so far... https://www.shinyredapples.com/post/995 ... n-keys#_=_
I have to assume the Database Schemas must have fallen out of favour, or no-one bothered to update the OC once which is a small tragedy to my mind. Here is a link to the editable OC 1.5.x Database Schema. https://creately.com/app/?tempID=huvdo5 ... type=demo#
I might come back to this topic later - if there is any interest shown!
Thanks,
John :-#)#

jrr
Active Member

Posts

Joined
Mon Nov 20, 2017 1:48 pm
Who is online

Users browsing this forum: No registered users and 255 guests