5 replies to this topic

[polarpos]

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

[DunWeb]

@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

[kymation]

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

Regards
Jim

[Praful Kamble]

@polarpos

Go through this.

[DunWeb]

@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

[kymation]

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