Professional display of prices?

[aalabels]

Hi:

Does anyone know that how can I show the following prices in table form:

4 or fewer items £9.99 (£8.50 excluding VAT @ 17.5%)
5 to 9 items £9.49 (£8.02 excluding VAT @ 17.5%)
9 to 24 items £8.99 (£7.63 excluding VAT @ 17.5%)

I want them to display as following, it doesn't take as many line as above:

1+          5+       10+
£9.99    £9.49    £8.99

Any idea: how can I set my code into <table> tags.

I am using Standard Tax Inclusive and Exclusive Price layout.

Thanks in advance:

Assad Gilani
AALabels
www.aalabels.com

[aalabels]

Product Groups and discounts

I would appriciate if someone has done that or similar to that thing.

Assad

[leehack]

You will need to embed the html yourself as actinic will not automatically do things like that. Alternatively just include the text explaining the situation into the product description.

[aalabels]

Hi Lee:

thanks for your response.

Could you please help me fitting <table> tags into following code, because I have been unable to do this so far.

<actinic:block if="%3cactinic%3avariable%20name%%22PriceIsEnabled%%%2f%3e">
<actinic:variable name="ProductPriceDescription" />
<br>
 <actinic:block if="%3cactinic%3avariable%20name%%22IsFirstQuantityBreak%%%2f%3e">
  <actinic:block if="%3cactinic%3avariable%20Name%%22QuantityDescMax%%2f%3e%20%3d%3d%201">
   (<actinic:variable Name="QuantityDescMax"/> item)
  </actinic:block>
  <actinic:block if="%3cactinic%3avariable%20Name%%22QuantityDescMax%%2f%3e%%3e%201">
   (<actinic:variable Name="QuantityDescMax"/> or fewer items) 
  </actinic:block>
 </actinic:block>
 <actinic:block if="%3cactinic%3avariable%20name%%22IsMiddleQuantityBreak%%%2f%3e">
  (<actinic:variable Name="QuantityDescMin"/> to <actinic:variable Name="QuantityDescMax"/> items)
 </actinic:block>
 <actinic:block if="%3cactinic%3avariable%20name%%22IsLastQuantityBreak%%%2f%3e">
  (<Actinic:Variable Name="QuantityDescMin"/> or more items)
 </actinic:block>
 <actinic:variable name="PreFormattedPrice" value="Product Price Excluding Tax" />
 <actinic:block if="%3cactinic%3avariable%20name%%22IsTaxMessageShown%%%2f%3e">
 <span class="actxxsmall">
  (<actinic:variable name="PreFormattedPrice" value="Product Price Including Tax" /> Including <actinic:block if="%3cactinic%3avariable%20name%%22IsTax1Used%%%2f%3e"><actinic:variable name="TaxName1"/> at <actinic:variable name="TaxRate1"/>%</actinic:block><actinic:block if="%3cactinic%3avariable%20name%%22IsTax1AndTax2Used%%%2f%3e"> and </actinic:block><actinic:block if="%3cactinic%3avariable%20name%%22IsTax2Used%%%2f%3e"><actinic:variable name="TaxName2"/> at <actinic:variable Name="TaxRate2"/>%</actinic:block>)
 </span>
 </actinic:block>
</actinic:block>

Hope you will help me solving this problem, as happened in past.

Assad

[leehack]

Unless you do actually want this table in every product layout, you cannot do it there, it needs to be in the product description. If you add things to a layout, they will appear on every use of that layout. Your requirements sound like they are product specific so need to go in at product level.

[Orchid]

weird - I've just spent the morning doing just this

you need to set the quantity dependent pricing then build your tables both within the layout and also the list layout settings.

You will need two layouts to avoid the problem pointed out above:
A product list layout
A product layout

aim for each row of product to be one of main table rather than a sub table

Remember each product and fragment is now own row in the table so you'll need to set fragment colspan.

Use javascript to display heading on on the first product by setting the doTableHead variable to true at head of page and then false within product layout. You'll also need to set it to true in fragment layout incase you include a fragment between products.

Javascript table heading code

<script language="javascript" type="text/javascript">
if(doTableHead==true)
document.write("<tr><td colspan=6>&nbsp;</td></tr><tr><td><b>Order Code</b></td><td><b>Description</b></td><td><b>1+</b></td><td><b>5+</b></td><td><b>10+</b></td><td><b>QTY</b></td></tr>");
		 doTableHead=false;
		</script>

Which should be contained in the Product List Layout as below:

<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForCustomerGroupID%22%20%2f%3e%20%21%3d%20%22%22%20AND%20%3cactinic%3avariable%20name%3d%22IsProductVisible%22%20%2f%3e" >
	<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForRetailCustomers%22%20%2f%3e" >
		<Actinic:ShowForPriceSchedule Schedules="<actinic:variable name="VisibleForCustomerGroupID" />">
			<actinic:variable name="ProductLayout" />
		</Actinic:ShowForPriceSchedule>
	</actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForRetailCustomers%22%20%2f%3e%20%3d%3d%20False" >
		<Actinic:ShowForPriceSchedule Schedules="<actinic:variable name="VisibleForCustomerGroupID" />" HTML='<actinic:variable name="ProductLayout" encoding="html"/>' />
	</actinic:block>	
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForCustomerGroupID%22%20%2f%3e%20%3d%3d%20%22%22%20AND%20%3cactinic%3avariable%20name%3d%22IsProductVisible%22%20%2f%3e" >
		<script language="javascript" type="text/javascript">
		if(doTableHead==true)
		 document.write("<tr><td colspan=6>&nbsp;</td></tr><tr><td><b>Order Code</b></td><td><b>Description</b></td><td><b>10+</b></td><td><b>100+</b></td><td><b>500+</b></td><td><b>QTY</b></td></tr>");
		 doTableHead=false;
		</script>	
	<actinic:variable name="ProductLayout" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForCustomerGroupID%22%20%2f%3e%20%21%3d%20%22%22%20AND%20%3cactinic%3avariable%20name%3d%22IsFragmentVisible%22%20%2f%3e" >
	<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForRetailCustomers%22%20%2f%3e" >
		<Actinic:ShowForPriceSchedule Schedules="<actinic:variable name="VisibleForCustomerGroupID" />">			
		<actinic:variable name="FragmentLayout" />
		</Actinic:ShowForPriceSchedule>
	</actinic:block>
	<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForRetailCustomers%22%20%2f%3e%20%3d%3d%20False" >
		<Actinic:ShowForPriceSchedule Schedules="<actinic:variable name="VisibleForCustomerGroupID" />" HTML='<actinic:variable name="FragmentLayout" encoding="html"/>' />
	</actinic:block>	
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22VisibleForCustomerGroupID%22%20%2f%3e%20%3d%3d%20%22%22%20AND%20%3cactinic%3avariable%20name%3d%22IsFragmentVisible%22%20%2f%3e" >
	<actinic:variable name="FragmentLayout" />
</actinic:block>

Product Layout:

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
      <form method="post" action="<actinic:variable name="OnlineScriptURL" value="Shopping Cart Script URL" />"> 
         <input type="hidden" name="SID" value="<Actinic:Variable Name="SectionID"/>" />
         <input type="hidden" name="PAGE" value="PRODUCT" />           
         <input type="hidden" name="PAGEFILENAME" value="<actinic:variable name="SectionPageName" />" />
         <Actinic:SECTION BLOB='<Actinic:Variable Name="SectionCatFile"/>'/>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsHostMode%22%20%2f%3e">
            <!-- Hidden field when in trial mode -->
            <input type="hidden" name="SHOP" value="<Actinic:Variable Name="HiddenFields"/>" />
         </actinic:block>
</actinic:block>

         <tr><td><a name="<Actinic:Variable Name="EncodedProductAnchor"/>"></a><Actinic:Variable Name="ProductName"/></td><td><actinic:variable name="ProductDescription" /></td><actinic:variable name="DiscountList" value="Standard Discount List" /><td><input type="text" name="Q_<Actinic:Variable Name="ProductReference"/>" size="4" value="<Actinic:Variable Name="DefaultQuantity"/>" /></td></tr>         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsAddToCartButtonShown%22%20%2f%3e%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22NumberAttributesInPushButtonGrid%22%20%2f%3e%20%3d%3d%200%29" >
            <actinic:variable name="AddToCartButton" />
         </actinic:block>



<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
      </form>
</actinic:block>

Set the javascript variable to false in fragment as below

<script language="javascript" type="text/javascript">
		var doTableHead = true;
		</script>

VOILA

http://www.cablelogicuk.com/acatalog...adeCables.html

username: testing
Psswrd: Da1mat1an5

[bentleybloke]

Very clever and looks smart too!

What settings did you use for the List Layout Settings on the product list layout?

[leehack]

I like that alot, especially the discount information in the cart. However, it doesn't seem to be working properly. If i buy 9 at £3.07 it tells me to add one more to get them at £3.07, which is what i am getting them for anyway. If i then increase it to 10, it gives me a 90% reduction on the total price. i.e. total order of 10 = £30.70, yet it gives me a -£27.63 credit.

[Orchid]

List layout settings

set the colspan to 6 on each <td> to account for the colspan of the product table.

I've since edited the code that I pasted above to close the rows because I'd erroneously left them open... I'll try and get round to editing the code above at somepoint tommorrow when I've got Actinic open.

I like that alot, especially the discount information in the cart. However, it doesn't seem to be working properly. If i buy 9 at £3.07 it tells me to add one more to get them at £3.07, which is what i am getting them for anyway. If i then increase it to 10, it gives me a 90% reduction on the total price. i.e. total order of 10 = £30.70, yet it gives me a -£27.63 credit.

More testing tomorrow then

[leehack]

Another approach i was just thinking about would be to "block if" a table in the product layout and create 3 variables - (4 price, 5-9 price and 10+ price). These 3 variables could be available on each product and if they have something included, the table lays out and puts the figures included into the variable, into the table. If nothing included in the variables, then the table does not get included.

[Orchid]

Another approach i was just thinking about would be to "block if" a table layout in the product layout and create 3 variables - (4 price, 5-9 price and 10+ price). These 3 variables could be available on each product and if they have something included, the table lays out and puts the figures included into the variable, into the table. If nothing included in the variables, then the table does not get included.

I considered this - however it would mean the client setting the price twice - once in discounts, and one in the variables - where as the solution I went for means that the client only has to set it the discounts.

Though he will have to chose if he is going to give 3 choice dependent prices or four etc. and I'll need to do different layouts for these - with your solution this would not perhaps be the case as one could set a set of cascading ifs to see how many discounts had been set.

perhaps I could combine the best of both solutions by putting the discounts into a table within a td of the product but have a variable set for howmany discounts to have across.

my head's beginning to hurt...

[leehack]

It certainly looks very close to something very useful, best addon to actinic i've seen posted in the forum for quite sometime.

If you had 3 standard quantity based discounts across the store on everything. For example:

1-4 = full price
5-9 = 10% off
10+ = 20% off

Could we then get a table included by way of an if statement which fired if it was told to include the table by way of a checkbox or alike. The clever thing could then be to grab the full price and apply these generic discounts to that figure and populate the table with the figures automatically.

To then illustrate discounts on these products via a table, all that is done is a checkbox is selected and the table auto populates.

Example (using above generic discounts):

Base product price = £10.00

Select checkbox or flag to show the discount table and populate it, where it would show:

1-4 = £10.00 each
5-9 = £9.00 each
10+ = £8.00 each


Variable calculations needed would be:

Variable1-4 = price * 1
Variable5-9 = price * 0.9
Variable10+ = price * 0.8

[Orchid]

If you had 3 standard quantity based discounts across the store on everything. For example:

1-4 = full price
5-9 = 10% off
10+ = 20% off

I think that the client would need to be able to use the discounts and the product groups built into Actinic - otherwise we are removing functionality, especially as different products would have different profit levels and therefore would need to be set individually.

However I do think that we are onto something - if there are a set of variables:

firstDiscountLevel
secondDiscountLevel
thirdDiscountLevel
fouthDiscountLevel
fifthDiscountLevel
sixthDiscountLevel

and then the client set these to match the quatity dependent pricing in the dicounts and groups

firstDiscountLevel = 10+
secondDiscountLevel = 100+
thirdDiscountLevel = 500+
fouthDiscountLevel
fifthDiscountLevel
sixthDiscountLevel

we have one final actnic variable for the product

discountLevels = 3

now we know that we are going to have three columns in discounts list so we need three columns in our heading.

Therefore we set our javascript heading using the titles saved in the actinic variables and we loop through the amount of times stipulated in discountLevels.

few... !!! think that will work.

FINALLY - if we set allow-parent - then this could still be set store wide if this is what the shop owner wanted.

[leehack]

It would certainly be good to apply something globally if required. Retail generally works on 33% profit, so a lot of times the discounts applied can be pretty generic across all products. If not wanted, then the client chooses whether to offer any at all, if they want to but not the generic figures, they override the variable values which are set to take parent values if not altered.

[Orchid]

Got it working and with only one variable

ok got it working - and it behaves as expected and with only one variable

IncludeVDCHeadingRow.

Completely different method than outlined above Make a table in a copy of the "Retail price list" and another one in a copy of the product layout "No Image No Description Laid out in single line" so that the Retail Price List sits within a table sell.

Retail price list copy:

<actinic:block if="%3cactinic%3avariable%20name%3d%22PriceIsEnabled%22%20%2f%3e">
	<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >
		<div>*<b><Actinic:Variable Name="QuantityDescMin"/> +</b></div>
	</actinic:block>
	<div><actinic:variable name="PreFormattedPrice" value="Product Price Including Tax" /></div>
</actinic:block>

No Image No Description Laid out in single line:

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
      <form method="post" action="<actinic:variable name="OnlineScriptURL" value="Shopping Cart Script URL" />"> 
         <input type="hidden" name="SID" value="<Actinic:Variable Name="SectionID"/>" />
         <input type="hidden" name="PAGE" value="PRODUCT" />           
         <input type="hidden" name="PAGEFILENAME" value="<actinic:variable name="SectionPageName" />" />
         <Actinic:SECTION BLOB='<Actinic:Variable Name="SectionCatFile"/>'/>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsHostMode%22%20%2f%3e">
            <!-- Hidden field when in trial mode -->
            <input type="hidden" name="SHOP" value="<Actinic:Variable Name="HiddenFields"/>" />
         </actinic:block>
</actinic:block>

<table width="570" cellspacing="0" cellpadding="0" border="0">
   <tr>
		<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >
				<td width="18%" align="left" valign="top">
			</actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20false" >
				<td width="18%" align="left" valign="middle">
			</actinic:block>
         <a name="<Actinic:Variable Name="EncodedProductAnchor"/>"></a>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >
	         <b>Order Code</b><br> 
         </actinic:block>
				<Actinic:Variable Name="ProductName"/> <actinic:variable name="ExtendedInformationLinks" />
			</td>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >
				<td width="30%" valign="top">
			</actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20false" >
				<td width="30%" valign="middle">
			</actinic:block>	
			<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >	
			<b>Description</b><br>
         </actinic:block><actinic:variable name="ProductDescription" /></td>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductReferenceVisible%22%20%2f%3e" >
            Ref: <actinic:variable name="ProductReference" />
         </actinic:block>
         
         
         <actinic:block if="%3cactinic%3avariable%20name%3d%22FileURLNotEmpty%22%20%2f%3e">
           
            <a href="<Actinic:Variable Name="ProductLinkInfo"/>">
               <Actinic:Variable Name="ProductLinkText"/>
            </a>
         </actinic:block>
         
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsCustomerMessageUsed%22%20%2f%3e">
            
            <Actinic:Variable Name="RetailCustomerMessage"/>
         </actinic:block>
         </td>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >
				<td valign="top">
			</actinic:block>
			<actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20false" >
				<td valign="middle">
			</actinic:block>			
         <actinic:block if="%3cactinic%3avariable%20name%3d%22PriceIsEnabled%22%20%2f%3e">
				<Actinic:PRICES PROD_REF="<actinic:variable name="ProductReference" />" RETAIL_PRICE_PROMPT="<Actinic:Variable Name="ProductPriceDescription"/>">
            <actinic:variable name="PriceListRetail" />
            </Actinic:PRICES>
         </actinic:block>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22ProductPriceIsEnabled%22%20%2f%3e%20%3d%3d%20False">
	         <Actinic:NOTINB2B><actinic:variable name="ProductPriceNotEnabledMessage" /></Actinic:NOTINB2B>
         </actinic:block>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsCustomerMessageUsed%22%20%2f%3e">
           
            <Actinic:PRICE_EXPLANATION PROD_REF="<actinic:variable name="ProductReference" />" COMPONENTID=-1><Actinic:Variable Name="RetailCustomerMessage"/></Actinic:PRICE_EXPLANATION>
         </actinic:block>
         
         <actinic:block if="%3cactinic%3avariable%20name%3d%22DiscountDescriptionIsShownForProducts%22%20%2f%3e">      
            <actinic:variable name="DiscountList" value="Standard Discount List" />
         </actinic:block>
         
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsOtherInfoPromptShown%22%20%2f%3e">
            
            <span class="actrequired"><Actinic:Variable Name="OtherInfoPrompt"/></span><br />
            <input type="text" name="O_<Actinic:Variable Name="ProductReference"/>" size="40" maxlength="1000" value="" />
         </actinic:block>
         
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsDatePromptShown%22%20%2f%3e">
           
            <span class="actrequired"><actinic:variable name="DatePrompt"/></span><br />
            <actinic:variable name="DayList" /><actinic:variable name="MonthList" /><actinic:variable name="YearList" />
         </actinic:block>
         
         <actinic:variable name="ProductAlsoBoughtList" />
         
         <actinic:variable name="ProductRelatedProductsList" />
      </td>
      <td align="right" width="70">
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsQuantityPromptShown%22%20%2f%3e">
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IncludeVDCHeadingRow%22%20%2f%3e%20%3d%3d%20true" >
	         <b><Actinic:Variable Name="QuantityPrompt"/></b><br/>
         </actinic:block>
            <input type="text" name="Q_<Actinic:Variable Name="ProductReference"/>" size="4" value="<Actinic:Variable Name="DefaultQuantity"/>" />
         </actinic:block>
         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsQuantityPromptHidden%22%20%2f%3e">
            <input type="hidden" name="Q_<actinic:variable name="ProductReference"/>"  value="<actinic:variable name="DefaultQuantity"/>" />
         </actinic:block>

         <actinic:variable name="AttributeList" />
         <actinic:variable name="ComponentList" />

         <actinic:variable name="CartError" />

         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsAddToCartButtonShown%22%20%2f%3e%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22NumberAttributesInPushButtonGrid%22%20%2f%3e%20%3d%3d%200%29" >
           <actinic:variable name="AddToCartButton" />
         </actinic:block>

         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsOutOfStockShown%22%20%2f%3e">
           <strong><span class="actrequired"><br /><Actinic:Variable Name="OutOfStock"/></span></strong>
         </actinic:block>

         <actinic:block if="%3cactinic%3avariable%20name%3d%22IsCatalogSuspendedShown%22%20%2f%3e">
            <strong><span class="actrequired"><Actinic:Variable Name="CatalogSuspended"/></span></strong>
         </actinic:block>
         
      </td>
   </tr>
</table>



<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductFormUsed%22%20%2f%3e">
      </form>
</actinic:block>

VOILA http://www.cablelogicuk.com/acatalog...adeCables.html

Username: testing
Password: Da1mat1an5