Cost of item vs sales price

Zen Cart currently assigns a price to an item... to which we can add discounts and price breaks. We can view a report of our sales. Great!

But what if we are not the products' manufacturer. We have a cost per product. It would be nice if products were initially set with a base 'cost' value as opposed to price. Each item would then have a default group pricing (markup).

This would allow for a much more complete report of sales and make catalog pricing more flexible.

In a perfect world, each product would also have an 'override' feature. So if the default markup was 100%, an individual item could be adjusted to be say... only 90%.

Nicely, this feature does not need to impact current stores and their databases. If stores are listing items by price then the default markup would be $0.

Thoughts?

BTW. Zen Cart rocks! Your work is much appreciated.

You should read through the Quick Updates thread. I believe there is something with that program by which you can input cost and determine your margins. I'm not sure it will allow for everything you're wanting but it is at least related.

Thanks, but I've already played with quickupdates. It is great for viewing and adjusting large quantities of products.

But it is not cost based either. It adjusts the price completely without maintaining the original cost.

My only real option, if this isn't already in the works by someone else, is to add a new 'products_cost' table linked to the 'products' table. I could then add a column to quickupdates for manually inputing specific product cost values. The last part is to add a function to globally adjust prices based on a global margin $ or % increase. The 'products_cost' table is needed to not only record the margin but also whether it is a global or specific value.

Continued from previous post...

QuickUpdates does offer integration with wholesaling pricing. But prices still are determined based on the wholesale price. As far as I can see they are simply two independent prices for one item.

There is a mod that begins to address this in Downloads :: Admin Tools :: Products Profit/Margin Calculator + Report.

Last Updated: Sep 06 2006
Author: GetYourGamesHere.com
This contribution is a combination of the following:

Profit Margin Calculator v1.12 by Farrukh
Products Profit and Cost Report v1 by Farrukh

Basically, all I did was combine the two contributions together, and updated it to work with 1.3.5. The SQL file included in this package inserts data for both contributions in one run.

===WHAT DOES THIS CONTRIBUTION DO?===
Well, in short, it allows you to add a cost field to your products and allow you to track your profit. Its not a perfect contribution, but its on its way there. A report under Admin-_Reports will show you what your profit is :)

This might be a good springboard for creating the actual price-setting mod you want. Or it might not - I don't have any personal knowledge about the mod. Have fun!