How to edit products database?

[Guest]

Hi all! :D

 

I've been messing around with OsCommerce MS2.2 for a while, I have the demo products running, I can add, delete, and almost everything I can think at the moment BUT... :unsure:

 

I want to load preexisting data into my database, I got to do it via MySQL and it works fine (2000 records), the point is that I would like to have more fields in my products database than the ones supplied by default by OsCommerce (products_id; products_quantity; products_model; products_image, etc) AND by the way, change the names of the supplied fields.

 

I have been diving into the forum, and look at about 30 pages of posts and found accurate questions and therefore, accurate answers to specific issues on import/export of data; on adding/changing certain existing field, but nothing similar to a step by step how-to add fields to the products database.

 

Is there any post, tutorial, web page, PDF, (or whatever) that shows how to change STEP BY STEP how to add fields to the products database, fields like: products_volume;Manufacturer_Reference; Our_Reference; Warranty; EAN_Barcode, etc... ??? Should I look somewhere else in the forum? Maybe something I haven't seen yet? Has anybody done it before so it could address me somewhere else to look for?

 

:huh:

 

Thanks in advance!

[♥Vger]

Go into your oscommerce admin, and go to 'Catalog', and choose 'product options/values'. You can add options and assign values there. Hope this helps - Vger

[Guest]

Thanks Vger, but if I did understood (still working on my english) the procedure you point to, would not add fields to the products database but instead would modify the attributes section of the database.

 

Am I right? Should I look somewhere else?

 

Thanks in advance.

[♥Vger]

Perhaps one of the osCommerce development team would be able to give you the definitive answer to your question. I have played around a little bit with altering the oscommerce database, and in my experience the following applies.

 

1. If you add options to osCommerce via the admin panel, thent those changes appear in the database.

 

2. If you make changes in the database directly, which are not part of osCommerce, they do not appear in osCommerce, only in the database. The exception is

 

3. If, for instance, a customer makes an order but the order does not appear in the admin panel - you can run a cheque only order yourself through osCommerce, then go into the database and alter the details of that cheque order to include the customers name, id, purchase etc. and this will then appear in the admin panel as an order made by that customer. This is just amending something that already exists.

 

Sorry I can't be more help on this one.

 

vger

[Guest]

there is a contribution named ezfields which will point you in the proper direction of creating additional database fields. what kinds of fields are you adding? most of the ones here are more than sufficient for a user, unless you are trying something specific. may be more worth your while to really sit back and look at what you are wanting to do and what is really necessary, as doing an upgrade down the road can be tough, if not designed properly.