Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Frustration, too much


bstone

Recommended Posts

Does anyone know of a contribution or something that will allow me to see more then just my products names in the admin section? I have about 5000 products and many of them with the same name but different year or manufacturer. I would love to be able to see the model and manufacturer fields as well. That way I can find individual products quickly if I need to modify it.

 

thanks

Link to comment
Share on other sites

I'd use this. it will show model and Manufacturer - also sorts.

quick_updates.gif

 

Works great for me.

 

I think this is the contribution. Quick Updates

 

But there are several in the contribution section and it has been a while.

 

Good luck.

 

TJ

 

P.s. many thanks to the author of Quick Updates!

Link to comment
Share on other sites

I can't figure out what to do with this part (below)... I did the rest just fine, I think. The only problem is that it doesn't look like it does below?

Now, if you want configure what you will be able to modify in Quick Updates, updates your database with that :

 

/****************** English *********************/

INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1');

 

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

(1001, 'Display the model.', 'DISPLAY_MODEL', 'true', 'Enable/Disable the model displaying', 300, 1, '2003-06-04 05:04:11', '2003-06-04 04:18:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1002, 'Modify the model.', 'MODIFY_MODEL', 'false', 'Allow/Disallow the model modification', 300, 2, '2003-06-04 05:04:07', '2003-06-04 04:25:57', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1003, 'Modify the name of the products.', 'MODIFY_NAME', 'false', 'Allow/Disallow the name modification?', 300, 3, '2003-06-04 05:04:01', '2003-06-04 04:30:31', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1004, 'Modify the statut of the products.', 'DISPLAY_STATUT', 'true', 'Allow/Disallow the Statut displaying and modification', 300, 4, '2003-06-04 05:07:11', '2003-06-04 05:00:58', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1005, 'Modify the weight of the products.', 'DISPLAY_WEIGHT', 'true', 'Allow/Disallow the Weight displaying and modification?', 300, 5, '2003-06-04 05:06:44', '2003-06-04 04:33:16', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1006, 'Modify the quantity of the products.', 'DISPLAY_QUANTITY', 'true', 'Allow/Disallow the quantity displaying and modification', 300, 6, '2003-06-04 05:06:48', '2003-06-04 04:34:34', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1007, 'Modify the image of the products.', 'DISPLAY_IMAGE', 'false', 'Allow/Disallow the Image displaying and modification', 300, 7, '2003-06-04 05:06:52', '2003-06-04 04:36:57', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1008, 'Modify the manufacturer of the products.', 'MODIFY_MANUFACTURER', 'false', 'Allow/Disallow the Manufacturer displaying and modification', 300, 8, '2003-06-04 05:06:57', '2003-06-04 04:37:40', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1009, 'Modify the class of tax of the products.', 'MODIFY_TAX', 'false', 'Allow/Disallow the Class of tax displaying and modification', 300, 9, '2003-06-04 05:06:40', '2003-06-04 04:31:53', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1010, 'Display price with all included of tax.', 'DISPLAY_TVA_OVER', 'true', 'Enable/Disable the displaying of the Price with all tax included when your mouse is over a product', 300, 10, '2003-06-04 05:07:02', '2003-06-04 04:38:45', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1011, 'Display price with all included of tax.', 'DISPLAY_TVA_UP', 'true', 'Enable/Disable the displaying of the Price with all tax included when you are typing the price?', 300, 11, '2003-06-04 05:07:06', '2003-06-04 04:40:12', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1012, 'Display the link towards the products information page.', 'DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link towards the products information page ', 300, 12, '2003-06-04 05:19:13', '2003-06-04 05:15:50', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1013, 'Display the link towards the page where you will be able to edit the product.', 'DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link towards the page where you will be able to edit the product', 300, 13, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1014, 'Display the manufacturer.', 'DISPLAY_MANUFACTURER', 'false', 'Do you want just display the manufacturer ?', 300, 7, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1015, 'Display the tax.', 'DISPLAY_TAX', 'true', 'Do you want just display the tax ?', 300, 8, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),

(1016, 'Activate or desactivate the commercial margin.', 'ACTIVATE_COMMERCIAL_MARGIN', 'true', 'Do you want taht the commercial margin be activate or not ?', 300, 14, '2003-06-04 05:19:08', '2003-06-04 05:17:05', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

Link to comment
Share on other sites

You need to run the SQL query in PHPMyAdmin or similar to update the database, or it will never work. Ask your provider where to log in, Or have him run this statement on your database.

 

That will create the added data fields for the contribution to work.

 

Good luck

 

T

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...