RE: Product Cost Option wanted

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=183241#183241
----------------------------------------------------------------

I did this a while back, we've got a customer with 25,000 products updating quarterly.

I  modified the products table and add a products_cost field.

Then I chased through the EasyPopulate mod file easypopulate.php and add v_products_cost after v_products_price however it exists in the original file.  

example, you find:
set v_produces_price = 'xx', 
so then you add as the next line: 
set v_products_cost='xx',  
and so forth throughout the file.

Then you can edit the categories.php file in admin using the same method of finding references to products_price and adding in the products_cost code in the same fashion so it will display and you can edit the value.

As I remember you need to be very careful with the syntax, it's very easy to miss a comma here or quote there, so make sure you BACKUP your files and DB.

Sorry this solution isn't more detailed but we did this a long while ago, hope this helps you out.

I'm not doing price comparisons but it shouldn't be too hard to set something up to report the changes if they exist.