'Cost Price' relevance

[leehack]

That would be a good addition i agree, really like that idea. I think there was a hack recently detailed on the forum about how to do it automatically, but it should be a standard option ideally.

[cdicken]

Hi - when you create options in v9 using the 'Product Options' wizard you have the option to include the price of the option in the drop down list. You can enable this without using the Product Options wizard by selecting the 'Include Prices' checkbox in the 'Layout' tab of the component (you need to be using the 'Standard Component Layout' for this to work).

[davie_ne1]

Did note that in the order detail table the cost price is shown against each product, with a little query work, we can now run a report that shows us the profit per order, per week, etc.

Not perfect as it would be better to have a report like this built into Actinic but it does the job.

[bentleybloke]

Hi - when you create options in v9 using the 'Product Options' wizard you have the option to include the price of the option in the drop down list. You can enable this without using the Product Options wizard by selecting the 'Include Prices' checkbox in the 'Layout' tab of the component (you need to be using the 'Standard Component Layout' for this to work).

Seems to be greyed out if you have a product made up of only components with no attributes/choices.

[NormanRouxel]

While we're talking about Component pricing, I have a question.

If you have a Component that doesn't have any permutations, is there any way of getting at the Component price (the entry in the Price field on the Component details / Prices tab)?

I can see this as nValue2 in the database but cannot see any variable (or List as it's possibly dependent on price schedule) that gets at this.

If you associate a product with said Component and use associated prices, then it is possible to access the price via AssociatedProduct::ProductPriceRaw.

Reason I'm asking, is that I've just done an add-on that dynamically displays a products price and it's working for every type of variant except Components with simple pricing. You have to associate a product and use it's price if you want to have a simple checkbox.

[gabrielcrowe]

omg hax

<actinic:block php="true" >
$prodrefs = "<actinic:variable name="ProductID" />";
    $connect = odbc_pconnect("ActinicCatalog9","","", SQL_CUR_USE_ODBC);
        $query = "SELECT [nCostPrice] FROM [Product] WHERE [Product Reference]='".$prodrefs."'";
        $result = odbc_exec($connect, $query);
        while(odbc_fetch_row($result)){ $ThisCostPrice = odbc_result($result, 1); }
    odbc_close_all();  

$ProductCostPriceFormatted = "&pound;".number_format($ThisCostPrice/100, 2, '.', ',');
$ProductCostPriceRaw = number_format($ThisCostPrice/100, 2, '.', '');

//echo $ProductCostPriceRaw;
echo $ProductCostPriceFormatted;
</actinic:block> 

Until this gets fixed, this elegant hack will have to do.

Drop this into your template at the product level.

I made a template with it in and called it like this:

<strong><actinic:variable name="CroweCostPrice" /></strong>

Tut-tut Actinic towers, your coders need to talk to each other.

[bentleybloke]

Hi Norman,

An interesting sounding patch. Does it work for price schedule prices too? I have a feeling the actinic price grid doesn't. Components are somewhat annoying when they effect the price of the product and one can't get the total until the product is added to the basket.

[Richardpixel]

Hi all

The next maintenance release of Actinic will feature two new variables to use online:
ProductCostPriceFormatted - which will display the cost price with all currency symbols etc.
ProductCostPriceRaw - the unformatted price for use in calculations etc.

Hopefully these two will start to mean the cost price field is rather more useful than it is currently as it will basically work as a second price field.

(Cost Price is already in the flat file import btw, so you may want to shorten those odds)

Has a version been released or is on the horizon that will allow the 'Cost Price' field to be used in the site yet?

A new client wants to have original and sale prices on their site and was hoping to avoid using a custom variable for them.

[leehack]

I asked this a few days, happened to see Chris reading it, but no answer yet, I expect that no news is bad news.

http://community.actinic.com/showthread.php?t=38457

[TraceyHand]

I'm fairly sure CD has already confirmed that the CostPrice variable would be made available to the design, hasn't he?
I'm sure I have read it somewhere on the forum previously (don't think I dreamt it...my dreams aren't quite THAT square!)

[Richardpixel]

He did say that but it would be in the next release which I don't think we've had yet.

I tried to use the 'Cost Price' variable as he described in this thread but got script errors.

[leehack]

I'm fairly sure CD has already confirmed that the CostPrice variable would be made available to the design, hasn't he?
I'm sure I have read it somewhere on the forum previously (don't think I dreamt it...my dreams aren't quite THAT square!)

Pretty sure he said it too, with the delays though it might be far less important and forgotten about. My client's site has gone live now with a 'hope' now rather than a simple yes or no.

[TraceyG]

Hi,

I'm trying to find this information out for you but I have to say that it looks like it's only available to the MOTO form, but let me get that confirmed for you.

[TraceyG]

Hi,

I'm pleased to be able to confirm that it is available to the product layouts in 9.0.3

[leehack]

Woot, thanks Tracey, can you confirm the variable name also please?