Product Cost Option wanted

[Barstow]

Has anyone written a contrib or added product cost functionality to osc?

 

My problem is, we have over 7000 products listed in our online store, and we get a full product list from our manufacturers each week with our cost. We add the appropriate markup to our cost to come up with the customers price. OSC as of yet has no field in the products entry page for a "cost". It would be much easier for me if I could print a full list of our products cost and match it against the vendors pricelist to find the products that changed pricing for that week. I'm not a php guru or anything, but adding a field for this doesnt seem to be difficult for those that know how. Any one up for the challenge?

 

Seems it would be benificial to everyone to have this. Or if anyone has another solution for matching pricing with vendors to see whats gone up/down that week/month. Any suggestions or code is very much appriciated.

 

Thanks

Barstow

[MreSailor]

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.