Jump to content



Latest News: (loading..)

database structure


  • Please log in to reply
5 replies to this topic

#1   polarpos

polarpos
  • Members
  • 1 posts
  • Real Name:Polar POS

Posted 06 July 2012 - 01:09 AM

I got a point of sale software and we are trying ot integrate with Magento but we are looking for a the database diagram as to how how a default installation of osCommerce will setup the database and where is each aspect of the stored. I looked at the documentation but I didn't see it.

Not sure if integration would also require any extensions added to osCommerce as well to get this done?

Edited by Jan Zonjee, 07 July 2012 - 04:31 PM.
removed link (spam?)


#2   DunWeb

DunWeb

    The Censored One

  • Members
  • 12,819 posts
  • Real Name:Chris
  • Gender:Male
  • Location:Ontario, Canada

Posted 06 July 2012 - 01:18 AM

@polarpos

I suggest installing osCommerce so you can see the structure....or, download v2.3.1 and look at the SQL file to see the table structure.



Chris
:|: Was this post helpful ? Click the LIKE THIS button :|:

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

#3   kymation

kymation

    Believers

  • Community Sponsor
  • 6,759 posts
  • Real Name:Jim Keebaugh
  • Gender:Male
  • Location:Aberdeen WA USA

Posted 06 July 2012 - 03:17 AM

There's a database diagram in the osCommerce download package. Look in the Extras folder.

Regards
Jim
My Addons

Banners Box 2.3.x  Support
Categories Accordion Box 2.3.x  Support
Categories Images Box 2.2x  2.3.x  Support
Closest Shipper 2.2x  Support
Document Manager 2.2x  Support
Generic Box 2.3.x  Support
Get 1 Free 2.2x  Support
jQuery Banner Rotator 2.2x  2.3.x  Support
Modular Front Page 2.3.x  Support
Modular SEO Header Tags 2.3.x  Support
MVS 2.2x  Support
PDF Datasheet 2.3.x  Support
Price Updater 2.2x
Products Specifications 2.2x  2.3.x  Development Version  Support  Bugs/Suggestions
Request a Review 2.2x - 2.3.x  Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x  Support

#4   Praful Kamble

Praful Kamble
  • Members
  • 265 posts
  • Real Name:Praful
  • Gender:Male
  • Location:Pune, India

Posted 06 July 2012 - 05:17 AM

@polarpos

Go through this.
Like post..hit LIKE button.

osCommerce | Joomla | WordPress | Magento | SEO | CakePHP | CI

Guaranteed Website Speed Optimization!!

#5   DunWeb

DunWeb

    The Censored One

  • Members
  • 12,819 posts
  • Real Name:Chris
  • Gender:Male
  • Location:Ontario, Canada

Posted 06 July 2012 - 05:21 AM

@Praful Kamble

@polarpos

That link is for RC1.  v2.3.1 has a different structure.  Jim's suggestion is the best one. (I didn't know there was one in the /extras folder)




Chris
:|: Was this post helpful ? Click the LIKE THIS button :|:

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

#6   kymation

kymation

    Believers

  • Community Sponsor
  • 6,759 posts
  • Real Name:Jim Keebaugh
  • Gender:Male
  • Location:Aberdeen WA USA

Posted 06 July 2012 - 05:43 AM

The one in the Extras folder isn't up to date either. The products_images table is missing for one. I suspect it's vintage 2.2RC2a or earlier. It's still the best one I know of.

Regards
Jim
My Addons

Banners Box 2.3.x  Support
Categories Accordion Box 2.3.x  Support
Categories Images Box 2.2x  2.3.x  Support
Closest Shipper 2.2x  Support
Document Manager 2.2x  Support
Generic Box 2.3.x  Support
Get 1 Free 2.2x  Support
jQuery Banner Rotator 2.2x  2.3.x  Support
Modular Front Page 2.3.x  Support
Modular SEO Header Tags 2.3.x  Support
MVS 2.2x  Support
PDF Datasheet 2.3.x  Support
Price Updater 2.2x
Products Specifications 2.2x  2.3.x  Development Version  Support  Bugs/Suggestions
Request a Review 2.2x - 2.3.x  Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x  Support