Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Help with Product Sort 1.2 contribution


Recommended Posts

Im trying to add this contribution to my OSC: http://www.oscommerce.com/community/contri...ons,911/page,13 . In the readme, it says


Insert a new field into TABLE_PRODUCTS, using this SQL command:

ALTER TABLE PRODUCTS ADD `products_sort_order` INT(3);


Insert a new entry into TABLE_CONFIGURATION, using this SQL command:

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (263, 'Display Product Sort Order', 'PRODUCT_SORT_ORDER', '0', 'Do you want to display the Product Sort Order column?', 8, 9, '2003-01-23 20:48:06', '2003-01-22 23:23:50', NULL, NULL);


Where do i change this part, the rest is easy to change, couldnt figure this out, nothing specified. TIA



Link to comment
Share on other sites

You will need to go into your database, preferably by using something like phpMyAdmin. If you have phpMyAdmin enter the database and in the main window click on the SQL tab, copy and paste the command into the window and hit the go button. It should return something saying you have successfully added the new fields.

Link to comment
Share on other sites


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

  • Create New...