Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Where can I find the database containing product info


Criz

Recommended Posts

Posted

Hello,

 

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.

 

Thanks!

 

Chris

 

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

Posted

perhaps?

installocation/admin/

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..

Posted

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?

 

Regards,

 

Chris

Posted

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.

 

HTH

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

Archived

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

×
×
  • Create New...