Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

manual new product field adding help


Recommended Posts

Hi- can someone help me with this portion of the manual install? of newfeilds4

 

i manually added the field i wanted into the products table...

 

First using PhpMyAdmin click on the products table on the left. Add a new field called products_whatyouwant, set the type to varchar(45), Null to null and default to NULL.

 

now it tells me to do this, but i'm not that great of a code writer and figured i'd ask for help first.

 

Using PhpMyAdmin there are 2 tables we need to play with: ‘configuration_group’; and configuration.

 

 

These columns are in Configuration_group table:

 

configuration_group_id

configuration_group_title

configuration_group_description

sort_order

 

These columns are in the configuration table:

 

configuration_key = PRODUCT_LIST_ARTIST

configuration_title = Display Artist

sort_order = max + 1 (this is the order it displays in the admin suite)

configuration_group_id = 8

configuration_value = 2 (this is the order it displays in the product_listing.php file.. setting it to zero means it will not be displayed)

 

Look in the configuration_group table to find the configuration_group_id for Product Listing,

 

Then insert new rows to the configuration table, using the configuration_group_id you found in the configuration_group table.

 

I have found it difficult to use the admin suite to configure new columns, so if you wish to hide a column or make a hidden column visible it is advisable to just alter the configuration_value in the database.

 

in other contributions i have seen sql commands do this, but when i tried writing one i got an error...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...