[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Empty Order Manager and Databases after correct Checkout
Hi All
My VS does not save transactions in the transactions.txt or orderline.txt
databases. When I go to the Order Manager in the Back-Office no Order
appears. However the e-mail receipt is sent. I have the following relevant
lines in catalog.cfg and checkout.html.
Thank You in advance
Paul
Inteliware.net - Lisbon Portugal
Catalog.cfg
*********************************************************
Database locale locale.txt TAB
Database 2ndDayAir 2ndDayAir.csv CSV
Database Ground Ground.csv CSV
Database NextDayAir NextDayAir.csv CSV
AsciiTrack logs/tracking.asc
Onfly onfly
OrderCounter etc/order.number
OrderLineLimit 25
RouteDatabase route
SpecialPage report ../etc/report
UpsZoneFile products/450.csv
Database country country.txt TAB
Database mv_shipping shipping.asc TAB
Database products products.txt TAB
Database userdb userdb.txt TAB
Database access access.asc TAB
Database mv_metadata mv_metadata.asc TAB
Database orderline orderline.txt TAB
Database transactions transactions.txt TAB
Database variable variable.txt TAB
ProductFiles products
VariableDatabase variable
# E-Mail que recebera as encomendas
MailOrderTo interchange@192.168.48.3
SpecialPage order basket
SpecialPage flypage flypage
SpecialPage checkout checkout
SpecialPage receipt receipt
SpecialPage catalog index
OrderProfile etc/profiles.order etc/profiles.login etc/profiles.misc
SpecialPage search results
Locale pt_PT
#Locale pt_PT currency_symbol PTE
#Locale pt_PT p_cs_precedes 0
#Locale pt_PT mon_thousands_sep .
#Locale pt_PT mon_decimal_point .
Variable CONTACT_EMAIL bleuline@mail.pt
Variable DISPLAYDATE [tag time]%R %A, %d de %B de %Y[/tag]
Variable TOP [include config/top]
Variable LEFT [include config/left]
Variable BOTTOM [include config/bottom]
Variable MENUBAR [include config/menubar]
DescriptionField descricaoproduto
checkout.html
*********************************************************
__TOP__
__MENUBAR__
__LEFT__
<b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Encomenda</font></b>
<hr>
<table width="494" cellspacing="0" cellpadding="0" height="274">
<tr>
<!-- Coluna de espaco -->
<td width="12" height="274"></td>
<td valign="top">
[if session failure]
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="#ff0033"><b>[data session failure]</b><br><br></font>
[data base=session field=failure value=""]
[/if]
[if session ship_message]
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"
color="#ff0033"><b>[data session ship_message] [data session
failure]</b><br><br></font>
[data base=session field=ship_message value=""]
[data base=session field=failure value=""]
[/if]
<form method=post action="[process-target]">
<input type=hidden name=mv_todo value=submit>
<input type=hidden name=mv_order_profile value=order_profile>
<input type=hidden name=mv_cyber_mode value=minivend_test>
<!-- <INPUT TYPE=hidden NAME=mv_order_route VALUE=""> -->
<INPUT TYPE=hidden NAME=mv_order_route VALUE="log main copy_user">
<INPUT type=hidden NAME=mv_username VALUE="[value mv_username]">
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Empresa:</b><br>
<input type="text" name="company" size="10" value="[value
company]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Nome:</b><br>
<input type="text" name="fname" size="10" value="[value
fname]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Apelido:<br></b>
<input type="text" name="lname" size="10" value="[value
lname]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Endereco:<br></b>
<input type="text" name="address1" size="10" value="[value
address1]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Localidade:<br></b>
<input type="text" name="city" size="10" value="[value
city]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Código
Postal:<br></b>
<input type="text" name="zip" size="10" value="[value
zip]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>País:<br></b>
<input type="text" name="country" size="10" value="[value
country]"><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Contribuinte:<br></b>
<input type="text" name="contribuinte" size="10" value="[value
contribuinte]"><br><br></font>
<input type=hidden name=mv_check value="Save_database">
[set Save_database]
[userdb save]
[tag export userdb][/tag]
[/set] -->
<SELECT onChange="this.form.submit()" NAME=mv_shipmode>
[shipping
label=1
mode=|[data table=country key='[default country US]' sf=selector
col=shipmodes]|
]
</SELECT>
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"><b>Numero
Cartao de Credito:<br></b>
<input type=text name=mv_credit_card_number value=""
size=20><br><br></font>
<font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><b>Validade:<br></b>
<select name=mv_credit_card_exp_month>
[loop
lr=1
option=mv_credit_card_exp_month
list="
1 Janeiro
2 Fevereiro
3 Marco
4 Abril
5 Maio
6 Junho
7 Julho
8 Agosto
9 Setembro
10 Outubro
11 Novembro
12 Dezembro"]
<option value="[loop-code]">[loop-pos 1]
[/loop]
</select>
<select name=mv_credit_card_exp_year>
[comment]
This should always return the current year as the first, then
7 more years.
[/comment]
[loop option=mv_credit_card_exp_year lr=1 list=`
my $year = $Tag->time( '', { format => '%Y' }, '%Y' );
my $out = '';
for ($year .. $year + 7) {
/\d\d(\d\d)/;
$last_two = $1;
$out .= "$last_two\t$_\n";
}
return $out;
`]
<option value="[loop-code]"> [loop-pos 1]
[/loop]
</select>
<br>
<hr>
<INPUT TYPE=radio NAME=email_copy [checked name=email_copy value=1
default=1] VALUE="1">Yes
<INPUT TYPE=radio NAME=email_copy [checked name=email_copy value=0]
VALUE="0">No
<INPUT TYPE=radio NAME=mail_list [checked mail_list 1] VALUE="1">Yes
<INPUT TYPE=radio NAME=mail_list [checked name=mail_list value=0
default=1] VALUE="0">No
[if items]
<TABLE WIDTH=450>
<TR><TD COLSPAN=4 __HEADERBG__>
<FONT SIZE="+2" COLOR="__HEADERTEXT__">Review order details</FONT>
</TD>
</TR>
[item-list]
<TR>
<TD VALIGN=TOP MARGINWIDTH=12 MARGINHEIGHT=12>
<FONT SIZE="-2"><INPUT TYPE=checkbox NAME="[quantity-name]"
VALUE=0 onClick="this.form.submit()"> remove</FONT>
<INPUT TYPE=hidden NAME="[quantity-name]" value="[item-quantity]">
</TD>
<TD VALIGN=TOP MARGINWIDTH=12 MARGINHEIGHT=12>
[item-description]</A>
</TD>
<TD VALIGN=TOP>[item-quantity] @ [item-price]</TD>
<TD VALIGN=TOP ALIGN=RIGHT>[item-subtotal]</TD>
</TR>
[/item-list]
<TR>
<TD COLSPAN=2><A HREF="[area basket]">Back to cart</A><BR></TD>
<TD>Subtotal</TD>
<TD ALIGN=RIGHT>[subtotal]</TD>
</TR>
<TR>
<TD COLSPAN=2></TD>
<TD>Sales Tax</TD>
<TD ALIGN=RIGHT>[salestax]</TD>
</TR>
<TR>
<TD COLSPAN=2></TD>
<TD>Shipping</TD>
<TD ALIGN=RIGHT>[shipping]</TD>
</TR>
<TR>
<TD COLSPAN=2></TD>
<TD>TOTAL</TD>
<TD ALIGN=RIGHT>[total-cost]</TD>
</TR>
</TABLE>
[/if]
<input type=submit name=submit value="Finalize!">
</form>
</td>
</tr>
</table>
__BOTTOM__
Paulo Moniz Inteliware.net
Phone : +351.21.4527104/5 Av. São Miguel
Fax : +351.21.4527106 Lote 80, Escritório 71
paulo.moniz@@inteliware.net São Miguel das Encostas
www.inteliware.net 2775-751 Carcavelos