Can I track profit/loss in CS-Cart?

Hello All



I just wondered if there was anyway to track profit/loss in CS-Cart.



I guess I’m wondering if there is a place to enter the wholesale price I pay and then have that data exported with my orders.



All help most appreciated as this will save me a few hours each month.



Cheers

this is not built into CS but is fairly easy to do…

Thanks for letting me know.



Any idea how?



Would I create a product option for wholesale price and then edit the code to have this data exported with the order items report.



Or do you (or anyone else) have any other ideas?



Cheers

it takes a little bit of custom coding, I can explain how to do it however I just don’t have the time to do that right now…

No problem Snorocket.



I’ll not have the time to try to implement this for a couple of weeks anyway but if you feel inspired to provide some guidance during this time then it will be most appreciated.



Cheers

I would be interested in this as well.

Me to!



It’s very troublesome that you don’t have the option to fill in the wholesale price for the product.

And that is automatic calculates the profit per product.



Now I have to search through my invoices to find the wholesale prices and then calculate the profit myself for each order.



Hope CS-Cart will implement this in the next update or develop custom plugin for this.



Would be nice to have a “balance sheet” on the homepage in the admin area.

Where you can see how much profit you’ve made last week, month or year!

Jobosales said this to me:



“You can add your product cost using Product Features which will allow you to specify that a feature is hidden (not displayed in the front-end). This will allow you to import and export the value using the Feature column.



Unfortunately, this column will contain all features assigned to a product which means that you will need to parse the column to derive the value you want in Excel.

You should be able to write a formula to use the derived value from the feature column to calculate the margin.



It would be handy to have a dedicated product cost field for quick review and margin calculation.”

I did this by adding a column in the cscart_product_prices table



Call it cost, then perform a markup calculation based on the manufacturer / list price.



Then just select all products sold from daily sales (this is the tricky bit - requires a left join or nested sql pulls), minus the cost from the selling price.



I can post the code if anyone wants it.

[quote name=‘AWSOM50’]I did this by adding a column in the cscart_product_prices table



Call it cost, then perform a markup calculation based on the manufacturer / list price.



Then just select all products sold from daily sales (this is the tricky bit - requires a left join or nested sql pulls), minus the cost from the selling price.



I can post the code if anyone wants it.[/QUOTE]



Just do post it! Great mod!

[quote name=‘adders’]Hello All



I just wondered if there was anyway to track profit/loss in CS-Cart.



I guess I’m wondering if there is a place to enter the wholesale price I pay and then have that data exported with my orders.



All help most appreciated as this will save me a few hours each month.



Cheers[/QUOTE]



MOD released



[url]http://www.topcoderpro.com/profit-and-loss-tracking-mod.html[/url]

your site like to mod doesnt work and your site doesnt appear to exist except standard apache site page…please advise, id rather get it from you then just waste my time coding it…

topcoder’s site is out of business…

Shame, this would be a good mod.



Sno?..

You might want to voice in on the following feature request:

[url]http://forum.cs-cart.com/vbugs.php?do=view&vbug_id=1286[/url]



Bob

I can't seem to contact snorocket anymore or purchase from his website (since it's not working correctly). Does anybody want's to share this addon? thanks in advace

[quote name='studio-web' timestamp='1431717347' post='214547']

I can't seem to contact snorocket anymore or purchase from his website (since it's not working correctly). Does anybody want's to share this addon? thanks in advace

[/quote]



If you want, we can create such module for you from scratch according to your requirements. Feel free to contact us.

You really should be able to add optional product fields, such as cost. I'm floored this thread basically went no where and apparently any sort of cost tracking feature is still missing?

Please see our post in the related inquiry in: http://forum.cs-cart.com/topic/35056-add-product-cost-price-field-in-backend/?view=findpost&p=252183for details about our "EZ Cost Basis" addon.

Or in the marketplace.: http://marketplace.cs-cart.com/add-ons/site-management/ez-cost-based-pricing.html

This will do the job:

http://marketplace.cs-cart.com/add-ons/site-management/cost-price.html