Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by xcomm

  1. Dear community, Just using shipping by zones modul and having no tax definded there. In all my orders within European Union I have a wrong shipping_tax of 16% set instead of 19%. Any idea where the 16% for shipping is defined? (The normal tax for the items is done fine with 19%.) Thank you in advance! xcomm
  2. xcomm

    Where is shipping_tax defined?

    Hi Community, I've come over the reason for the issue on my setup. I had this MySQL default values set: ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '16.000' NOT NULL ; This was done from an mysql -p oscommerce < order_editor.txt due auction.LISTER with Order Editor install. So I will have to change this default value in the Database as our tax rate here hase changed. Best regards, xcomm
  3. xcomm

    Where is shipping_tax defined?

    Dear FWR Media, Thanks for your fast reply. I'm only using: ./includes/modules/shipping/zones.php I looked into it to see some tax set there but found nothing. In the admin panel I have set the zones shipping module to `NO VAT`. The issue is that the calculated VAT on the invoice it wrong shown as created with a VAT of 16% instead 19% for shipping. The shipping_tax 16.0000 is written into the DB on each checkout for a EU order. Best regards, xcomm
  4. xcomm

    Sort Products By Dropdown

    Hi community. sorry, was the same issue as above described from zippie76. There is a error in the readme, which is missing this order by in index.php: case 'PRODUCT_LIST_30SALES': $listing_sql .= "p.products_recent_sales desc, pd.products_name desc"; break; to case 'PRODUCT_LIST_30SALES': $listing_sql .= "order by p.products_recent_sales desc, pd.products_name desc"; break; ^^^^^^
  5. xcomm

    Sort Products By Dropdown

    Hi homewetbar, hi community, Great contribution and very good readme! On issue I have - I can switch sorting nicely, but can not go back to Best Selling: 0 - select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '90'p.products_recent_sales desc, pd.products_name desc [TEP STOP] Any ideas? Best regards, xcomm My settings are as posted in the image above http://img480.imageshack.us/img480/9140/settings6dm.gif
  6. Hi Forum, Greetings, I'm relative new to osCommerce. After a short time I have began to like its logic structure but here I'm stuck with a issue beyond my grasp at the moment. I installed Ultimate SEO URLs - by Chemo before 3 days which is really great! But now I have the two external links for the manufacturers broken aka redirected to the shop itself. 1) Manufacturers Box Homepage link. This does not work anyway. http://foobar.de/redirect.php/action/manuf...ufacturers_id/4 http://foobar.de/redirect.php?action=url&a...ufacturers_id=4 -> http://foobar.de/index.php 2) Product manufacturers Homepage link at product page bottom. a) http://foobar.de/redirect.php/action/url/g...h.de%2FC_11.htm -> Not Found The requested URL /redirect.php/action/url/goto/www.sirch.de/C_07.htm was not found on this server. (Real Target URL: www.sirch.de/C_07.htm) B) This works when disabling search engine friendly URLs in configuration, but worked before SEO. http://foobar.de/redirect.php?action=url&a...h.de%2FC_11.htm http://foobar.de/redirect.php/action/url/g...h.de%2FC_07.htm # Ultimate SEO URLs BEGIN Options +FollowSymLinks RewriteEngine On RewriteBase / RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-([0-9]+).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-([0-9]+).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-([0-9]+).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-([0-9]+).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pr-([0-9]+).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pri-([0-9]+).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-([0-9]+).html$ information.php?info_id=$2&%{QUERY_STRING} # Ultimate SEO URLs END Any help appreciated! Regards, xcomm