Post by scanreg » Sat Dec 06, 2014 11:56 pm

i need to track cost/price by history so that exact numbers can be generated in a report

in other words, right now, if you enter a cost of $0.05 for a widget, but then later change that cost to $0.06, then all sales calculations are now based on $0.06, the sales generated when the cost was $0.05 are now no longer accurate

rather, it would be way more accurate if the system could track product costs and pricing by time and calculate reports as such. in other words:

from point A to point B, the cost was $0.05 and the price was $0.10

from point B to point C, the cost was $0.05 but the price was $0.11

from point C to point D, the cost was $0.06 and the price was $0.12

from point D to point E, the cost was $0.04 and the price was $0.08

...and so on

you could then generate a profit report, for example, from point A through point E and each cost and price would be accounted for

this would be outstanding

thanks

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by fido-x » Tue Dec 09, 2014 9:53 pm

Wrong approach.

What you need is a cost field in the product table to record the cost of the product. Another cost field is added to the order_product table. The cost of the product is then added to the order_product table at the time the order is placed along with the price of the product.

Reporting of product costs can then be retrieved from the order_product table, the same table that product sales information is retrieved from. Since the product cost is included at the time the order is placed, later changes in product costs will not impact historical data.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by scanreg » Wed Dec 17, 2014 2:02 am

i know whatchu mean, was thinking the same, but what if you had the following:

1. add 10,000 units to inventory at $0.05 each, sell half of them at $0.10 each, now 5,000 remaining

2. add another 10,000 units to inventory, but now cost $0.06 each, so change the cost in opencart to $0.06 each

but wouldn't the first 5,000 now be costed incorrectly at $0.06 each when they are finally sold, even though they originally cost $0.05 each?

now:
5,000 @ $0.05 ea
10,000 @ $0.06 ea

thanks

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by fido-x » Sat Dec 20, 2014 11:25 am

I understand what you're saying. But, an increase in cost usually reults in an increase in price and, while it may be "standard business practice" to update your inventory (and prices) when you update your stock on hand, it is not exactly "honest".

Sure, after a few price rises, you might have a sale with prices advertised as "below cost - while stocks last". All that means is the sale price is below the current cost of the product, which is not necessarily the cost at the time you purchased the stock. And the "while stock last" part only relates to the amount you had in stock at the time you increased your levels.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by scanreg » Mon Dec 22, 2014 10:16 pm

i'm trying to track all numbers so that all my reports are as exact as possible

people increase inventory cuz they are anticipating sales but the costs can vary widely

historical costing would be extremely helpful to all site admins

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by scanreg » Wed Apr 01, 2015 8:33 pm

just found an old old addon:

http://www.opencart.com/index.php?route ... rch=profit

maybe this could help

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am
Who is online

Users browsing this forum: No registered users and 30 guests