Frogger34

i have now changed the netto to the sub_total_ex module but then the amount is shown incl vat in the first field, if i edit the order the field will change correctly but if if re-edit the order the first field is again shown incl. vat, database values are good, what am i missing ?

Taxes getting mest up in the Order Editor ? The total isn't wright, in this image the products cost 6.0924 excl tax shipping excl tax costs 3.25 netto total will be 9.34 Tax is 19% so will be 1.77 ( and not the 1.16 which is told in the editor) Total then will be 11.1146 ( almost good some ronding i supose the editor shows 11.12 ) Wat is happening with my tax caculations? i see more people are having trouble with the tax thing, so i have been looking in the forum, i have installed version 5.0.6.6 --- I have seen something, the tax for the shipping isn't in the tax total, that's what iam missing, can i include it somewhere so the total tax is complete ?

I have also have a modified shop and with the old version like ambishop told it's working and i can also mail out to the customers, now we have to test the new cronjob function. I can't see why the new version isn't working but the tip for version 2.23 worked out Thanks !

Hi all, Looks like a great contribution, i have installed it completly double checked it and made a abo. cart with a customer account. When i click tools/ recover_cart_sales.php after 1 day ( settings from the admin store ) i'am getting a blanc screen, no ab. cart. When i click the reports after clicking the tools section nothing is show, What is checked is the scart table, i have reinstalled it like someone else in this forum, but didn't work I'am also unable to see the buttons to email the customer, or are they only shown if a ab, cart is displayed in the report? What could be wrong, there are no errors displayed? Running on php 4.4.4 mysql 5.2 Thanks in advance

Hi all, same problem here, no deleting the database image name, if have searched and tested the something like this ( for the last image, to delete the row in the database but didn't work, any futher progress in the ALTER statement, because the link is in with the checkbox but no query is found in the categories.php or general.php , right ? $product_subimage6_query = tep_db_query("select products_subimage6 from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($product_id) . "'"); $product_subimage6 = tep_db_fetch_array($product_subimage6_query); $duplicate_subimage6_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " where products_subimage6 = '" . tep_db_input($product_subimage6['products_subimage6']) . "'"); $duplicate_subimage6 = tep_db_fetch_array($duplicate_subimage6_query); if ($duplicate_subimage6['total'] < 2) { if (file_exists(DIR_FS_CATALOG_IMAGES . $product_subimage6['products_subimage6'])) { @unlink(DIR_FS_CATALOG_IMAGES . $product_subimage6['products_subimage6']); } } tep_db_query("delete products_subimage6 from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");

Maybe it's an option to combine and make one Attribute or isn't that an option, so you have one attribute with 3.00 M, 15 -40 G +17 euro ? It seems you now have two options in one ? correct? or isn't it poossible to comibine because of the stock counting Greetz Frogger34

Hi all I became intrested in the Yofla Multi Image zoomer which can be found at the same site ( .com ), i would like to build this one out to the product_info page so visitors can zoom in on the products. It would be a nice contribution for us all, i have tested it with the OS version, and with the Contri automatic image shrink, so i have a small and a big image. The problem i ran into is to compile the temp. xml file which tells the flash to display the large image and then after showing deleting the temp. xml file, it also has to do something with a session id, so if a xml file is ceated it is linked to the session from the visitor. If any intrested ... we could make this new contri get to work together, If anyone has this already working i think we all want to know how Greetz Frogger 34

Hi ShaneHamelin Your missing the English Languages files of all payment contri's so check you files in /home/shineonl/public_html/store/languages/english/modules/payment/....... and install ( place ) the files in the folder Good luck Frogger34

I have used an older code which replaces the invoice.php in the admin folder, just create the code as invoice.php and replace the file ( attention ! backup you older invoice.php file ) My logo image is in a different spot, so if you want to replace the logo, search for logo in the code you have fpdf to be installed in the admin folder <?php /* $Id: create_pdf,v 1.4 2005/04/07 osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License Written by Neil Westlake ([email protected]) for www.Digiprintuk.com Version History: 1.1 Initial release 1.2 Corrected problem displaying PDF when from a HTTPS URL. 1.3 Modified item display to allow page continuation when more than 20 products are on one invoice. 1.4 Corrected problem with page continuation, now invoices will allow for an unlimited amount of products on one invoice */ define('FPDF_FONTPATH','fpdf/font/'); require('fpdf/fpdf.php'); require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ORDERS_INVOICE); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); include(DIR_WS_CLASSES . 'order.php'); while (list($key, $oID) = each($_GET)) { if ($key != "oID") break; $orders_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . $oID . "'"); $order = new order($oID); class PDF extends FPDF { //Page header function RoundedRect($x, $y, $w, $h,$r, $style = '') { $k = $this->k; $hp = $this->h; if($style=='F') $op='f'; elseif($style=='FD' or $style=='DF') $op='B'; else $op='S'; $MyArc = 4/3 * (sqrt(2) - 1); $this->_out(sprintf('%.2f %.2f m',($x+$r)*$k,($hp-$y)*$k )); $xc = $x+$w-$r ; $yc = $y+$r; $this->_out(sprintf('%.2f %.2f l', $xc*$k,($hp-$y)*$k )); $this->_Arc($xc + $r*$MyArc, $yc - $r, $xc + $r, $yc - $r*$MyArc, $xc + $r, $yc); $xc = $x+$w-$r ; $yc = $y+$h-$r; $this->_out(sprintf('%.2f %.2f l',($x+$w)*$k,($hp-$yc)*$k)); $this->_Arc($xc + $r, $yc + $r*$MyArc, $xc + $r*$MyArc, $yc + $r, $xc, $yc + $r); $xc = $x+$r ; $yc = $y+$h-$r; $this->_out(sprintf('%.2f %.2f l',$xc*$k,($hp-($y+$h))*$k)); $this->_Arc($xc - $r*$MyArc, $yc + $r, $xc - $r, $yc + $r*$MyArc, $xc - $r, $yc); $xc = $x+$r ; $yc = $y+$r; $this->_out(sprintf('%.2f %.2f l',($x)*$k,($hp-$yc)*$k )); $this->_Arc($xc - $r, $yc - $r*$MyArc, $xc - $r*$MyArc, $yc - $r, $xc, $yc - $r); $this->_out($op); } function _Arc($x1, $y1, $x2, $y2, $x3, $y3) { $h = $this->h; $this->_out(sprintf('%.2f %.2f %.2f %.2f %.2f %.2f c ', $x1*$this->k, ($h-$y1)*$this->k, $x2*$this->k, ($h-$y2)*$this->k, $x3*$this->k, ($h-$y3)*$this->k)); } function Header() { global $oID; $date = strftime('%A, %d %B %Y'); //Logo $this->Image('images/invoice_logo.jpg',5,5,0); // Invoice Number and date $this->SetFont('Arial','B',8); $this->SetTextColor(0); $this->SetY(37); $this->MultiCell(100,6, $date ,0,'L'); // Company Address $this->SetX(0); $this->SetY(5); $this->SetFont('Arial','B',8); $this->SetTextColor(0); $this->Ln(0); $this->Cell(149); $this->MultiCell(50, 3.5, STORE_NAME_ADDRESS,0,'L'); //email $this->SetX(0); $this->SetY(40); $this->SetFont('Arial','B',8); $this->SetTextColor(0); $this->Ln(0); $this->Cell(149); $this->MultiCell(50, 3.5, "E-mail: " . STORE_OWNER_EMAIL_ADDRESS,0,'L'); //website $this->SetX(0); $this->SetY(43); $this->SetFont('Arial','B',8); $this->SetTextColor(0); $this->Ln(0); $this->Cell(149); $this->MultiCell(50, 3.5, "Internet: " . HTTP_SERVER,0,'L'); } function Footer() { //Position at 1.5 cm from bottom $this->SetY(-17); //Arial italic 8 $this->SetFont('Arial','',10); $this->SetTextColor(158,11,14); $this->Cell(0,10, PRINT_INVOICE_TEXT, 0,0,'C'); //$this->SetY(-15); //$this->Cell(0,10, PRINT_INVOICE_URL, 0,0,'C'); //Page number //$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C'); } } //Instanciation of inherited class $pdf=new PDF(); // Set the Page Margins $pdf->SetMargins(6,2,6); // Add the first page $pdf->AddPage(); //Draw the top line with invoice text $pdf->Cell(50); $pdf->SetY(60); $pdf->SetDrawColor(153,153,153); $pdf->Cell(15,.1,'',1,1,'L',1); $pdf->SetFont('Arial','BI',15); $pdf->SetTextColor(153,153,153); $pdf->Text(22,61.5,'Invoice'); $pdf->SetY(60); $pdf->SetDrawColor(153,153,153); $pdf->Cell(38); $pdf->Cell(160,.1,'',1,1,'L',1); //Draw Box for Invoice Address $pdf->SetDrawColor(0); $pdf->SetLineWidth(0.2); $pdf->SetFillColor(245); $pdf->RoundedRect(6, 67, 90, 35, 2, 'DF'); //Draw the invoice address text $pdf->SetFont('Arial','B',8); $pdf->SetTextColor(0); $pdf->Text(11,77, ENTRY_SOLD_TO); $pdf->SetX(0); $pdf->SetY(80); //$pdf->SetFont('Arial','B',8); //$pdf->SetTextColor(0); $pdf->Cell(9); $pdf->MultiCell(70, 3.3, tep_address_format(1, $order->customer, '', '', "\n"),0,'L'); //Draw Box for Delivery Address $pdf->SetDrawColor(0); $pdf->SetLineWidth(0.2); $pdf->SetFillColor(255); $pdf->RoundedRect(108, 67, 90, 35, 2, 'DF'); //Draw the invoice delivery address text $pdf->SetFont('Arial','B',8); $pdf->SetTextColor(0); $pdf->Text(113,77,ENTRY_SHIP_TO); $pdf->SetX(0); $pdf->SetY(80); $pdf->Cell(111); $pdf->MultiCell(70, 3.3, tep_address_format(1, $order->delivery, '', '', "\n"),0,'L'); //Draw Box for Order Number, Date & Payment method $pdf->SetDrawColor(0); $pdf->SetLineWidth(0.2); $pdf->SetFillColor(245); $pdf->RoundedRect(6, 107, 192, 11, 2, 'DF'); //Draw Order Number Text $temp = substr ($order->billing['invoice_serial'].$order->billing['invoice_number'] , 0, 23); $pdf->Text(10,113,TEXT_INVOICE . ' ' . $temp); //Draw Payment Method Text $temp = substr ($order->info['payment_method'] , 0, 23); $pdf->Text(100,113,ENTRY_PAYMENT_METHOD . ' ' . $temp); //$pdf->Cell(198,29,ENTRY_PAYMENT_METHOD . ' ' . $temp, 0, 0, 'R'); //Fields Name position $Y_Fields_Name_position = 125; //Table position, under Fields Name $Y_Table_Position = 131; function output_table_heading($Y_Fields_Name_position){ global $pdf; //First create each Field Name //Gray color filling each Field Name box $pdf->SetFillColor(245); //Bold Font for Field Name $pdf->SetFont('Arial','B',8); $pdf->SetY($Y_Fields_Name_position); $pdf->SetX(6); $pdf->Cell(9,6,'Qty',1,0,'C',1); $pdf->SetX(15); $pdf->Cell(27,6,TABLE_HEADING_PRODUCTS_MODEL,1,0,'C',1); $pdf->SetX(40); $pdf->Cell(78,6,TABLE_HEADING_PRODUCTS,1,0,'C',1); //$pdf->SetX(105); //$pdf->Cell(15,6,TABLE_HEADING_TAX,1,0,'C',1); $pdf->SetX(118); $pdf->Cell(20,6,TABLE_HEADING_PRICE_EXCLUDING_TAX,1,0,'C',1); $pdf->SetX(138); $pdf->Cell(20,6,TABLE_HEADING_PRICE_INCLUDING_TAX,1,0,'C',1); $pdf->SetX(158); $pdf->Cell(20,6,TABLE_HEADING_TOTAL_EXCLUDING_TAX,1,0,'C',1); $pdf->SetX(178); $pdf->Cell(20,6,TABLE_HEADING_TOTAL_INCLUDING_TAX,1,0,'C',1); $pdf->Ln(); } output_table_heading($Y_Fields_Name_position); //Show the products information line by line for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { $pdf->SetFont('Arial','',8); $pdf->SetY($Y_Table_Position); $pdf->SetX(6); $pdf->MultiCell(9,6,$order->products[$i]['qty'],1,'C'); $pdf->SetY($Y_Table_Position); $pdf->SetX(40); if (strlen($order->products[$i]['name']) > 40 && strlen($order->products[$i]['name']) < 50){ $pdf->SetFont('Arial','',8); $pdf->MultiCell(78,6,$order->products[$i]['name'],1,'L'); } else if (strlen($order->products[$i]['name']) > 50){ $pdf->SetFont('Arial','',8); $pdf->MultiCell(78,6,substr($order->products[$i]['name'],0,50),1,'L'); } else{ $pdf->MultiCell(78,6,$order->products[$i]['name'],1,'L'); } $pdf->SetFont('Arial','',8); //$pdf->SetY($Y_Table_Position); //$pdf->SetX(95); //$pdf->MultiCell(15,6,tep_display_tax_value($order->products[$i]['tax']) . '%',1,'C'); $pdf->SetY($Y_Table_Position); $pdf->SetX(15); $pdf->SetFont('Arial','',8); $pdf->MultiCell(25,6,$order->products[$i]['model'],1,'C'); $pdf->SetY($Y_Table_Position); $pdf->SetX(118); $pdf->SetFont('Arial','',8); $pdf->MultiCell(20,6,$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']),1,'C'); $pdf->SetY($Y_Table_Position); $pdf->SetX(138); $pdf->MultiCell(20,6,$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']),1,'C'); $pdf->SetY($Y_Table_Position); $pdf->SetX(158); $pdf->MultiCell(20,6,$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']),1,'C'); $pdf->SetY($Y_Table_Position); $pdf->SetX(178); $pdf->MultiCell(20,6,$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']),1,'C'); $Y_Table_Position += 6; //Check for product line overflow $item_count++; if ((is_long($item_count / 32) && $i >= 20) || ($i == 20)){ $pdf->AddPage(); //Fields Name position $Y_Fields_Name_position = 125; //Table position, under Fields Name $Y_Table_Position = 70; output_table_heading($Y_Table_Position-6); if ($i == 20) $item_count = 1; } } for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { $pdf->SetY($Y_Table_Position + 5); $pdf->SetX(102); $temp = substr ($order->totals[$i]['text'],0 ,3); //if ($i == 3) $pdf->Text(10,10,$temp); if ($temp == '<b>') { $pdf->SetFont('Arial','B',8); $temp2 = substr($order->totals[$i]['text'], 3); $order->totals[$i]['text'] = substr($temp2, 0, strlen($temp2)-4); } $pdf->MultiCell(94,6,$order->totals[$i]['title'] . ' ' . $order->totals[$i]['text'],0,'R'); $Y_Table_Position += 5; } // Draw the shipping address for label //Draw the invoice delivery address text /* $pdf->SetFont('Arial','B',8); $pdf->SetTextColor(0); //$pdf->Text(117,61,ENTRY_SHIP_TO); //$pdf->SetX(0); $pdf->SetY(240); $pdf->Cell(20); $pdf->MultiCell(50, 4, strtoupper(tep_address_format(1, $order->delivery, '', '', "\n")),0,'L'); */ } // PDF's created now output the file $pdf->Output(); ?>

Isn't this what your looking for at the contributions site ? http://addons.oscommerce.com/info/4276 QTPro Visible Attributes Prices Regards, Frogger

i found something, it was a long road to go, but... in /includes/classes/pad_base.php you could change the filtering on line 319 Change : $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); To $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name ASC"); this will sort the products in alpb. sort order when you have one drowdown attributtes field, i'am using the Dropdown Seq. it works on the first field, not on the second, maybe it help someone who don't want to install the Sort order attributes in a running store Greetz Frogger

Hello I have installed the QTPRO 4.51 ( great contri! ), but is it possible without the Atributtes sort order module to filter on name in the product option Atributes displayed in the Product-info page ? i have tried to sort by sql statement, but the query is send to the product_options tables as i see, how to join the queary to products_atributtes table and then sort on name ? thanks Frogger

Can anyone tell me how to ADD tax to the following code in the Editor version 2.6.1, i know it's an old version but works for me, Line 420 - 426 File : edit-orders.php if (DISPLAY_PRICE_WITH_TAX != 'true') { //we don't add tax to the total here because it's already added to the subtotal $RunningTotal += $ot_value; } } else { $RunningTotal += $ot_value; }

Solved this one, had to do with the BOF SPPC in my store, changed the files and oke. The shop didn't know which costumer group was logged in. greetz :-"

Hi, I have installed the SPPC contribution which is working, maybe can someone tell me how to astablish the following: I have 2 customer group Retial - Show princing with tax - Tax Atem No Dealer1 - Show pricing without text - Tax atem. No Shop Config : Show tax = True Retail is working fine, Dealer 1, shows pricing without VAT in the shop which is oke, but on my invoice in the subtotal the pricing is without VAT, is it possible to calculate the VAT and show the pricing on the invoice including the VAT ? I can't seem to find it, i have search the forum, read a lot of SPPC stories but not this one, Thanx for your help