Change item "cost" based on options?

[T3rry]

Just wondering if this is possible? for example i sell an item with lots of different options, 4 different sets of options, one of the sets of options does have a sell price variable entered in so i am selling the item for as an example $2 more, but i would like to be able to also adjust my cost for the item so i get accurate reporting (using the advanced reporting extension)

right now i can only set one cost for the item, and its really not practical for me to split it in to 3 separate items for each option

example

option 1 cost is $2 sell is $5

option 2 cost is $2.35 sell is $6

option 3 cost is $2.50 sell is $7 

but i can only enter one cost, so i cant get accurate profit reporting for each item sold.

 

sorry if this is really confusing, still on my first coffee.

[Noodleman]

This will do what you want:

https://www.cubecart.com/extensions/plugins/stock-values-matrix-cost-price-live-analysis-of-your-inventory-values

 

 

[T3rry]

12 minutes ago, Noodleman said:

This will do what you want:

https://www.cubecart.com/extensions/plugins/stock-values-matrix-cost-price-live-analysis-of-your-inventory-values

thanks i'll take a look at that, i wish it was built in to your advanced reports tool because that's what i am demoing right now and trying to get accurate reporting on

[Noodleman]

I can certainly add a report to the Advanced reports module that will use the data added by the Stock Values plugin. If you find you need specific reports which are not available, simply let me know what ones you need and I will do my best to add them

[T3rry]

Yeah currently the advanced reports doesn't use the stock values plugin's values so its still not really helpful, are you going to add this functionality?

[Noodleman]

I can certainly add a report to the Advanced reports module to meet your criteria,  which will only be visible if the stock levels module is installed.

Currently it only gives you on hand stock values based on quantity in stock and cost.

I just need to know what columns you would want to see in the report.

[T3rry]

i think if it just showed all the options in the existing report it'd be sufficient, at least for now

 

i think it'd be easier to just have an option on the advanced reports config to toggle on and off integration with the stock levels module (just so the option is there if someone doesn't want to use the sock levels module pricing), and then just have the main report show the stock levels version instead of the basic version.

 

Not related to this, i'd love to see a page for each item (both a consolidated item view and a view for each individual option in the matrix) with the advanced reporting, specifically each order showing quantity, cost, sell, profit, margin, and totals, filterable by date range.

 

Also it'd be nice if i could change the date range shown on the dashboard through a dropdown or something instead of having to go to the settings and change it.