Latest News: (loading..)

yakseller

Members
  • Content count

    76
  • Joined

  • Last visited

2 Followers

About yakseller

Profile Information

  1. This was a problem with the individual shipping module. I apologize for posting here.
  2. 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.
  3. 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.
  4. 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.
  5. Just add the module to the products_info page above where those buttons are.
  6. 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.
  7. 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.
  8. 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
  9. 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.
  10. 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";
  11. Tonysoprano, Can you verify that these items do not appear in your xsell_products table multiple times?
  12. 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";
  13. It sounds like the module may not be included in the right place in index.php
  14. I will work on getting a demo shop up. It does looks good, and works as described.