yakseller

This was a problem with the individual shipping module. I apologize for posting here.

After some more investigation, it appears that the tax rate is not showing up correctly on the order_confirmation page, but is being added correctly to the total, before being sent to our payment processor. However, this causes a problem, because the total that is displayed to the customer is actually greater then the actual total charged.

I just added this contribution, it does seem to improve speed. However, I am having one problem. It is including the shipping price in the amount taxed. This did not occur before installing this contribution. Is this a known issue? Thanks in advance.

Has anyone added to this script to automatically update order status? I want to avoid spending time on something that has already been done. Thanks.

Just add the module to the products_info page above where those buttons are.

open the file catalog/includes/modules/index_ads.php in your editor. Find the line that looks like (around line 46): </tr><tr><td height="10"> </td></tr> change it to: </tr> Also, find this (around line 53): <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> And remove it. If this doesn't do what you want it to, you will have to change where you inserted index_ads.php into index.php.

You need to add the language to the main sql query. I didn't add this in, because my shop is only in one language. $xsell_query_raw = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "' ORDER BY pd.products_name"; Add the same thing if you are using my XSELL CART.

This is the thread for the Products Purchased Report with Date Range. This contribution can be found at http://www.oscommerce.com/community/contributions,2568

You could try changing the $orders_products_query in admin/classes/order.php so that you sort by products_model every time an order is retrieved. To do this, just put "ORDER BY products_model" at the end of the query. So, it would read: $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "' order by products_model"); If you are going to mess with this, make sure you back up the file first. Also keep in mind, this will effect more then just this contribution.

No, I don't speak Spanish (atleast not well). Try chaning that SQL query to: $xsell_query_raw = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id ORDER BY pd.products_name";

Tonysoprano, Can you verify that these items do not appear in your xsell_products table multiple times?

This is the forum for this contribution: http://www.oscommerce.com/community/contri...ll/search,xsell To fix the manufacturers problem, change the query to this: $xsell_query_raw = "SELECT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id ORDER BY pd.products_name";

It sounds like the module may not be included in the right place in index.php

I will work on getting a demo shop up. It does looks good, and works as described.

Index Ads Contribution