Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Can I track profit/loss in CS-Cart? Rate Topic   - - - - -

 
  • adders
  • Member
  • Members
  • Join Date: 16-Nov 07
  • 78 posts

Posted 06 February 2008 - 12:26 PM #1

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

 
  • snorocket
  • Forum Janitor
  • Members
  • Join Date: 15-Mar 06
  • 2519 posts

Posted 06 February 2008 - 01:11 PM #2

this is not built into CS but is fairly easy to do...
SNOROCKET.COM, Now Accepting PRE-ORDERS:
Customer Service (Helpdesk) Addon for CS-Cart v4.3.1
Quote and Invoicing Addon for CS-Cart v4.3.1

 
  • adders
  • Member
  • Members
  • Join Date: 16-Nov 07
  • 78 posts

Posted 06 February 2008 - 03:03 PM #3

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

 
  • snorocket
  • Forum Janitor
  • Members
  • Join Date: 15-Mar 06
  • 2519 posts

Posted 06 February 2008 - 03:17 PM #4

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...
SNOROCKET.COM, Now Accepting PRE-ORDERS:
Customer Service (Helpdesk) Addon for CS-Cart v4.3.1
Quote and Invoicing Addon for CS-Cart v4.3.1

 
  • adders
  • Member
  • Members
  • Join Date: 16-Nov 07
  • 78 posts

Posted 06 February 2008 - 03:22 PM #5

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

 
  • EagleRose
  • Member
  • Members
  • Join Date: 21-Feb 07
  • 63 posts

Posted 06 February 2008 - 05:32 PM #6

I would be interested in this as well.
Eagle Rose Lingerie
"Bringing Spice to Your Life"
www.eagleroselingerie.com

1.34 sp2

 
  • Akuma
  • Junior Member
  • Members
  • Join Date: 05-Feb 08
  • 8 posts

Posted 12 March 2008 - 08:54 PM #7

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!

 
  • joshin
  • Member
  • Members
  • Join Date: 23-Jan 08
  • 146 posts

Posted 14 March 2008 - 08:09 AM #8

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."
Using 4.1.5

 
  • AWSOM50
  • Member
  • Members
  • Join Date: 22-Jun 07
  • 60 posts

Posted 15 March 2008 - 10:07 AM #9

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.

 
  • densky
  • Junior Member
  • Members
  • Join Date: 26-Jan 08
  • 20 posts

Posted 16 March 2008 - 06:47 PM #10

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.


Just do post it! Great mod!

 
  • coder
  • Senior Member
  • Members
  • Join Date: 19-Jun 07
  • 407 posts

Posted 16 June 2008 - 02:02 PM #11

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


MOD released

http://www.topcoderp...acking-mod.html

CS-CART: version 4.9.1


 
  • crackdaddy
  • Member
  • Members
  • Join Date: 10-Jun 08
  • 33 posts

Posted 17 January 2010 - 06:31 PM #12

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...

 
  • snorocket
  • Forum Janitor
  • Members
  • Join Date: 15-Mar 06
  • 2519 posts

Posted 17 January 2010 - 08:58 PM #13

topcoder's site is out of business...
SNOROCKET.COM, Now Accepting PRE-ORDERS:
Customer Service (Helpdesk) Addon for CS-Cart v4.3.1
Quote and Invoicing Addon for CS-Cart v4.3.1

 
  • mdj101
  • Senior Member
  • Members
  • Join Date: 20-Jan 10
  • 106 posts

Posted 26 January 2010 - 11:53 PM #14

Shame, this would be a good mod.

Sno?......
Regards.

Mark

 
  • jobosales
  • Senior Member
  • Members
  • Join Date: 04-Nov 06
  • 3114 posts

Posted 27 January 2010 - 12:02 AM #15

You might want to voice in on the following feature request:
http://forum.cs-cart...ew&vbug_id=1286

Bob
CS-Cart 2.0.14 (testing)

 
  • studio-web
  • Junior Member
  • Authorized Reseller
  • Join Date: 21-Feb 07
  • 26 posts

Posted 15 May 2015 - 07:15 PM #16

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

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20913 posts

Posted 18 May 2015 - 08:33 AM #17

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


If you want, we can create such module for you from scratch according to your requirements. Feel free to contact us.
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Consultant
  • Member
  • Members
  • Join Date: 15-May 10
  • 170 posts

Posted 03 June 2016 - 06:09 PM #18

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?



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11748 posts

Posted 03 June 2016 - 07:49 PM #19

Please see our post in the related inquiry in: http://forum.cs-cart...ndpost&p=252183for details about our "EZ Cost Basis" addon.

 

Or in the marketplace.: http://marketplace.c...ed-pricing.html


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • Onkel_Sid
  • Junior Member
  • Members
  • Join Date: 04-Sep 10
  • 301 posts

Posted 03 June 2016 - 07:50 PM #20

This will do the job:

 

http://marketplace.c...cost-price.html


Stop smoking start vaping: Dampskyen.no