Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  1. Thanks a lot for your time and support... Roberto
  2. Hi Chris, thanks for your reply. Problem solved. I logged off and logged in again in admin and now it works... To integrate Parcelforce, would it be sufficient repeating the same steps I did for Royal Mail? ...this time I will backup ;-) Thanks again, Roberto
  3. Hi Chris, I installed the RM contribution, really nice but it seems that the link (to check the RM status) on the admin side doesn't work (everything's fine on the customer side). I also looked at the parcelforce contribution and I hoped it was adding up, but it seems it is replacing it :-( Last time I tried to modify myself a contribution I ended up reinstalling everything from scratch ;-) Any idea on how to implement them both? I'd like to use RM for small and light packets and PF for heavier parcels. Thanks again, Roberto
  4. I am just having a look at you contribution and I may say... it is great. I can't test it properly now because my site is not live yet... I am still selling through ebay at the moment. One question, though: I usually buy the shipping service (DHL or Parceline) from guys who have a contract and have great discounts... I am still a small seller and I dispach only 3 to 5 parcel a day (I send the small packet by RM, cheaper for me). What can you suggest about Parcelforce? I haven't found anyone yet that re-sells at a good price their Parcelforce service. Thanks in advance for your advices, Roberto
  5. Monteverde


    Well, check again... Royal Mail is VAT exempt, you are not. So you are still obliged to charge VAT on your customers. Hard to believe but it is true.
  6. Hi all, I was implementing this contribution but at halfway I realized it may be not what I was looking for. Instead of having different images in my product info page I'd like to have only one but changing by selecting the relative attribute(by colour for example). I couldn't find anything appropriate on the forum (that, by the way, is quite difficult to have a decent search result). The result I am aiming is something like this website, where I spent all afternoon, not trying to understand the code (I don't know nothing about JS), but because of the content :-) http://www.glamoutlet.com/Outlet/servlet/c...lorValueID=0002 If you already came across a contribution that can give this solution or have alternative solutions, please let me know. Thanks, Roberto
  7. <?php require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="menuboxheading" align="center"><?php echo strftime(DATE_FORMAT_LONG); ?></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="formAreaTitle"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td class="formAreaTitle"><?php echo TABLE_HEADING_MODEL; ?></td> <td class="formAreaTitle"><?php echo TABLE_HEADING_QUANTITY; ?></td> <td class="formAreaTitle" align="right"><?php echo TABLE_HEADING_PRICE; ?> </td> </tr> <tr> <td colspan="4"><hr></td> </tr> <?php $products_query_raw = "select p.products_id, pd.products_name, p.products_model, p.products_quantity,p.products_price, l.name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_LANGUAGES . " l where p.products_id = pd.products_id and p.products_id = pd.products_id and l.languages_id = pd.language_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name ASC"; $products_query = tep_db_query($products_query_raw); while ($products = tep_db_fetch_array($products_query)) { $products_id = $products['products_id']; // check for product or attributes below reorder level $products_stock_query=tep_db_query("SELECT products_stock_attributes, products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id=" . $products['products_id'] ." ORDER BY products_stock_attributes"); $products_stock_rows=tep_db_num_rows($products_stock_query); // Highlight products with low stock if ($products['products_quantity'] > STOCK_REORDER_LEVEL){ $trclass="dataTableRow"; } else { $trclass="OutofStock"; } if (($products['products_quantity'] > (-1)) || ($products_stock_rows > 0)) { $products_quantity=($products_stock_rows > 0) ? ' ' : $products['products_quantity']; $products_price=($products_stock_rows > 0) ? ' ' : $currencies->format($products['products_price']); ?> <?php ///////////////// Add Attributes if ($products_stock_rows > 0) { $products_options_name_query = tep_db_query("SELECT distinct popt.products_options_id, popt.products_options_name FROM " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib WHERE patrib.products_id='" . $products['products_id'] . "' AND patrib.options_id = popt.products_options_id AND popt.products_options_track_stock = '1' AND popt.language_id = '" . (int)$languages_id . "' ORDER BY popt.products_options_id"); ?> <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1.2'); ?></td> <tr class="dataTableRow"> <td class="dataTableContent" cellpadding="2"><?php echo '<a href="' . tep_href_link(FILENAME_STOCK, 'product_id=' . $products['products_id']) . '">' . $products['products_name'] .'</a>'; ?> </td> <td class="dataTableContent" cellpadding="2"><?php echo $products['products_model']; ?></td> <td class="dataTableContent" cellpadding="2"><?php echo $products_quantity; ?></td> <td class="dataTableContent" align="right" cellpadding="2"><?php echo $products_price; ?> </td> <td><BR></td> </tr> <tr class="dataTableRow"> <td class="main"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableRowSelected"> <?php // build headng line with option names while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { echo " <td class=\"smalltext\"> <u>" . $products_options_name['products_options_name'] . "</u></td>\n"; } ?> </tr> <?php // buld array of attributes price delta $attributes_price = array(); $products_attributes_query = tep_db_query("SELECT pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa WHERE pa.products_id = '" . $products['products_id'] . "'"); while ($products_attributes_values = tep_db_fetch_array($products_attributes_query)) { $option_price = $products_attributes_values['options_values_price']; if ($products_attributes_values['price_prefix'] == "-") $option_price= -1*$option_price; $attributes_price[$products_attributes_values['options_id']][$products_attributes_values['options_values_id']] = $option_price; } // now display the attribute value names, table the html for quantity & price to get everything // to line up right $model_html_table=" <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n"; $model_html_table.=" <tr class=\"dataTableRowSelected\"><td class=\"smalltext\" colspan=\"" . sizeof($products_options_array) . "\"> </td></tr>\n"; $quantity_html_table=" <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n"; $quantity_html_table.=" <tr class=\"dataTableRowSelected\"><td class=\"smalltext\" colspan=\"" . sizeof($products_options_array) . "\"> </td></tr>\n"; $price_html_table=" <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n"; $price_html_table.=" <tr class=\"dataTableRowSelected\"><td class=\"smalltext\" colspan=\"" . sizeof($products_options_array) . "\"> </td></tr>\n"; while($products_stock_values=tep_db_fetch_array($products_stock_query)) { $attributes=explode(",",$products_stock_values['products_stock_attributes']); echo " <tr class=\"dataTableRowSelected\">\n"; $model_html_table.=" <tr class=\"dataTableRowSelected\">\n"; $quantity_html_table.=" <tr class=\"dataTableRowSelected\">\n"; $price_html_table.=" <tr class=\"dataTableRowSelected\">\n"; $total_price=$products['products_price']; // Highlight products out of stock if (($products_stock_values['products_stock_quantity']) > STOCK_REORDER_LEVEL){ $trclassstock="dataTableContent"; } else { $trclassstock="OutofStockAttrib"; } foreach($attributes as $attribute) { $attr=explode("-",$attribute); echo "<td class=\" " . $trclassstock . " \" > ".tep_values_name($attr[1])."</td>\n"; $total_price+=$attributes_price[$attr[0]][$attr[1]]; } $total_price=$currencies->format($total_price); echo " </tr>\n"; $model_html_table.="<td class=\"" . $trclassstock . " \"> </td>\n"; $model_html_table.="</tr>\n"; $quantity_html_table.="<td class=\"" . $trclassstock . " \">" . $products_stock_values['products_stock_quantity'] . "</td>\n"; $quantity_html_table.=" </tr>\n"; $price_html_table.="<td align=\"right\" class=\" " . $trclassstock . " \">" . $total_price . " </td>\n"; $price_html_table.=" </tr>\n"; } echo " </table>\n"; echo " </td>\n"; $model_html_table.=" </table>\n"; $quantity_html_table.=" </table>\n"; $price_html_table.=" </table>\n"; echo " <td class=smalltext>" . $model_html_table . "</td>\n"; echo " <td class=smalltext>" . $quantity_html_table . "</td>\n"; echo " <td class=smalltext>" . $price_html_table . "</td>\n"; echo " </tr>\n"; } else { ?> <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1.2'); ?></td> <tr class="<?php echo $trclass; ?>"> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_STOCK, 'product_id=' . $products['products_id']) . '">' . $products['products_name'] .'</a>'; ?> </td> <td class="dataTableContent"><?php echo $products['products_model']; ?></td> <td class="dataTableContent"><?php echo $products_quantity; ?></td> <td class="dataTableContent" align="right"><?php echo $products_price; ?> </td> <td><BR></td> </tr> <?php } } ////////////////////////// End Attributes } ?> <tr> <td colspan="4"><?php echo tep_draw_separator(); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <font color="#FFCACB"> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> I have also copied the stats_low_stock_attrib.php over my previous one (forgot to backup) and now it doesn't show (and highlight) me when the stock is 0 (zero)... like in the photo uploaded by skimanic23. If anyone is able to display the stock = 0 ... please have a look at my code and compare it to yours. I might have cancel something by mistake. Thanks again, Roberto
  8. Hi all, I followed the topic for a while and it really helped me to tune the QT pro on my shop. I am still having the problem with google checkout IPN implemented (did it before). If cash or check is selected as method of payment the quantity per attribute is updated, if paid with google... the total quantity is updated but not the attribute quantity. I tried to search the forum and read some posts here, but I couldn't find any answers; sorry, maybe someone already did, if so point me right there ;-) - I use only 1 attribute (colour) - Qt pro 4.25 installed - Google checkout IPN (doesn't update attribute quantity) - Cash on delivery (works fine) - Cheque? Money order (works fine) If anyone solved already this problem pls let me know. Thanks in advance, Roberto
  9. Monteverde


    Hi Ski, thanks for finding the time and give us all your support. I haven't made any modifications to the google.php, apart from the one that you suggested above. I don't know why it takes from the shopping cart the item price with tax excluded and the shipping with tax included. Anyway if in the future you will find a solution let me know. Temporarely I have put the shipping tax (false) so it won't be taxed again in google. Thanks, Roberto
  10. Monteverde


    Hi Ski, I have already posted the same question at the end of the pages, but I don't know if it went through. Here I add an example with numbers, hoping it would be clearer. I should have your same output (tax and shipping) but I don't :-( and I can't get it to work. First, on my order confirmation page I have this: Sub-Total Excl.VAT: £17.01 ... I added a contribution to show a subtotal excluding taxes (UK mainland): £5.99 ....it should be £5.10(excl.VAT) but it comes up already with VAT incl. TAX 17.5%: £3.87 .... this is VAT on the item and on the shipping Total: £25.98 .... total is fine WhenI click CONFIRM ORDER and I go to google checkout I have this: Price £19.99 ... price including VAT Shipping: £7.04 ... £5.99 (was the shipping cost with VAT alredy included) and here google add another VAT again?? Total: £27.03 ... total must be £25.98 (includes VAT £4.03) I hope it is all clear and I believe that it can be solved showing the shipping cost excl VAT on my order... but how? Thanks in advance to anyone who will helm me on this ;-) Roberto
  11. Hi Becki, I was using this contribution as well but realized that also the shipping must be taxed (VAT) even if sent from the Post office. Anyway, have you managed to get the shipping ex VAT as well?? Forgot to say, I tried to integrate the ot_shipping.php with the contribution ot_subtotal_ex.php but it didn't work :-( Thanks in advance, Roberto
  12. Hi Becki, I was using this contribution as well but realized that also the shipping must be taxed (VAT) even if sent from the Post office. Anyway, have you managed to get the shipping ex VAT as well?? Thanks in advance, Roberto
  13. Monteverde


    Hi, I've tried to search the forum but with no results so far. If this has been already asked so many times, pls forgive me. I followed the instructions given by ski to mangotree about the VAT in UK. It works fine but, ..since I have all the prices VAT included I got this problem. Before I go to the checkout the order total is showing fine: item= VAT included shipping=VAt included On google (sandbox) everything is fine except the shipping where VAT is added to the already VAT included price. Of course if I put the shipping as not taxable I would resolve the probelm, but it wouldn't be nice ;-) Anyone could help? Thanks, Roberto
  14. Monteverde


    Hi Mango & Ski, pls keep me updated about any news on this UK issue. Thanks, Roberto