Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Where can I find the database containing product info


Recommended Posts



Can anyone help me out and tell me where I can find the general dbase with all the product information of my store? I have no idea where to look, it must be very simple and must have overlooked it.






---- everyone needs to learn sometime :wink:

Link to comment
Share on other sites



i.e. the customer side is at /catalog/default.php

the admin side /admin/default.php


good luck!


i might recommend you visit www.oscdox.com too :)

Has basic instructions on using the store..

Link to comment
Share on other sites

Hamish, thanks for your quick reply. :D


I am able to locate oscommerce.sql but i do not find any file containing my product information etc. Could you please help me out?





Link to comment
Share on other sites

Take a look at the following file:


Version 2.1: /catalog/includes/application_top.php


Version 2.2-CVS: /catalog/includes/configure.php


In these files you will find settings related to the database server. They look like this:


define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'user');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'osc');


From these lines you can see the name of the database your products are stored in. Using something like PHPMyAdmin you can edit these tables directly. WARNING: Changing the database directly can cause serious problems.



You can't have everything. That's why trains have difficulty crossing oceans, and hippos did not adapt to fly. -- from the OpenBSD mailinglist.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...