Mailing List Archive

On 17 Jan, Company InterNet Services wrote:
> I have a large site, 500,000+ book store
> In Germany we have two sales taxes (Like PA in the usa)
> 7% for books, food and everything else 16%
> I can make a new colum in the ascii DB, for the tax
> but how would I get IC to read it properly. and on the reciept it needs to show the two taxes.
>
> Sub Total= $50
> Tax1 items (7%)= $5
> Tax2 items (16%)= $11
> Total= $66

I´ve

--------snip from my checkout.html---------
<TD ALIGN=RIGHT>
<B>[L]Sales Tax[/L]</B></FONT></FONT><BR>
</TD>
<TD NOWRAP>
<B>
[currency][compute_vat][/currency]
</B></FONT></TD>
--------snip from my checkout.html---------

and an UserTag like

######## 7 oder 16 % VAT
#
#
#


UserTag compute_vat Routine <<EOF
sub {
package Vend::Interpolate;
my $vat;
my $a;
my $cart;
$cart = $Vend::Items;
my $item;
my $outprice;
my $outmenge;
my $vatkz;
my $out;
foreach my $item (@$cart){
my $item_dummy = '';
my $item_price = '';
$outprice = tag_data('products','price', $item->{code});
$vatkz = tag_data('products','dummy', $item->{code});
$outmenge = $item->{quantity};
if($vatkz =~ /MWSTKZ2/){
$a = ($outprice * $outmenge)/116*16;
$vat = $vat + $a;
} else {
$a = ($outprice * $outmenge)/107*7;
$vat = $vat + $a;
}
}
return $vat;
}
EOF

(Works with MV 3.14 and MV4.04a)

In most common case, you have 7%! If there are some items with 16%, you
have an entry "MWSTKZ2" in the field "dummy". This works with the whole
p rice(netto + VAT = "Bruttopreis").


> Also the construct site has 4 colums: sku, description, price, category
> Is there a way to add another description (like the images colum) so when the item is in a list it only shows the short
> "description", and when viewed a page shown the long detailed "description2" with an image

If the viewed page is "flypage.html", you can use

[item-field description2]

or what is the problem?

Joachim

--
Hans-Joachim Leidinger
buch online jojo@buchonline.net
Munscheidstr. 14 FAX: +49 209 1671441
45886 Gelsenkirchen FAX: 0209 1671441

"Company InterNet Services" <info@4co.De> writes:

> Also the construct site has 4 colums: sku, description, price,
> category Is there a way to add another description (like the images
> colum) so when the item is in a list it only shows the short
> "description", and when viewed a page shown the long detailed
> "description2" with an image

Isn't that what the "comment" field is for? Actually, I think there
are three fields for describing an item: title, description, and
comment. I don't think 'title' is actually used anywhere by default
in 'construct'. Since you are a book store, maybe this will work well
for you. The 'description' field is a short description of the item
and the 'comment' field is a long description. In fact, on the UI it
is even labeled as "long description".

I guess I'm a little confused by your question here. I thought that
'construct' worked this way be default.
--
(__) Doug Alcorn (mailto:doug@lathi.net http://www.lathi.net)
oo / PGP 02B3 1E26 BCF2 9AAF 93F1 61D7 450C B264 3E63 D543
|_/ If you're a capitalist and you have the best goods and they're
free, you don't have to proselytize, you just have to wait.

Quoting Doug Alcorn (doug@lathi.net):
> "Company InterNet Services" <info@4co.De> writes:
>
> > Also the construct site has 4 colums: sku, description, price,
> > category Is there a way to add another description (like the images
> > colum) so when the item is in a list it only shows the short
> > "description", and when viewed a page shown the long detailed
> > "description2" with an image
>
> Isn't that what the "comment" field is for? Actually, I think there
> are three fields for describing an item: title, description, and
> comment. I don't think 'title' is actually used anywhere by default
> in 'construct'. Since you are a book store, maybe this will work well
> for you. The 'description' field is a short description of the item
> and the 'comment' field is a long description. In fact, on the UI it
> is even labeled as "long description".
>

In addition, you can add fields and tables at any time. 8-)

--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Nature, to be commanded, must be obeyed. -- Francis Bacon