Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Search the Community

Showing results for tags 'tax'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
  • osCommerce v4.x
    • General Support
    • Migration from old osCommerce
    • Design and Templates
    • Apps / Add-ons
    • Translations
    • API and import/export
    • Marketplace integration
    • Manuals and How-to
    • Blog's discussion
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Commercial Support Inquiries
    • Developer Feedback

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 7 results

  1. Advanced Statistics Rev1 for osCommerce 2.3 - Compatible Without mysqlnd - - Support thread - Having made another module for handling products/categories which utilize DataTables, I realized that my store needed a new reporting "engine" to produce statistics/sales data for me so that I don't have to make a new spreadsheet every time I want some statistics. As of Revision 1 there's still a lot to work on but the the module has come to a point of being useful so I thought I share it with the rest of the osC community as an Add-On. If you think you have a good idea on new features/stats that could be useful, please share them here on the support forum. DataTables DataTables requests the sales data from your server with Ajax and then builds you a table with a action bar and selectable rows. You can Drag & Drop Column Headers to reorder the table the way you like it. It’s also possible to toggle column visibility. Clicking on the columns will sort the column ascending/descending. Clicking on the leftmost plus (+) sign will expand the column to detailed day-by-day per month sales & tax data. Performance The former Reporting Add-On I used was very slow, it queried each row in table orders_products and the amount of queries done to calculate sales & tax for a period was massive! Data will be loaded from JSON source which also helps improve Performance, especially on slow connections. Make very sure if you are going to use this Add-On that it calculates your data correctly! You have to both double and triple check the reports with another reporting system so you know for sure that everything works. This is how the Advanced Statistics Add-On calculates your sales data, it’s quite simple: If you have a tax rate set to 20% and the summary for this tax for 1 day is $200 then it will calculate generated sales with 20% tax this way: [Total Tax] / [Tax Rate] * 100 = Sold Goods with 20% Tax 200 / 20 * 100 = 1000. So Sales 20% will be $1000. As of Rev1, order_totals classes that will be counted are ot_total, ot_tax & ot_shipping. TableTools The TableTools Extension comes with a swf (flash) file which helps e.g. to copy table data to clipboard. Unfortunately, flash is the only way to do this right now.. Copying Data and then Pasting it in your spreadsheet editor is a neat way to quickly create custom reports. TableTools also comes with buttons to automatically create CSV files. You might need to configure the CSV field separator in advanced_statistics.js. Search for the sFieldSeperator option and set correct separator if you can’t get the CSV to import correctly. Print View Using a CSS with media="print”, a print view is automatically created when you select to print the page. If you have selected to filter orders by status, then there will be an added heading with Status Information, as of Rev1 however, you need to reload the page to get it to display. I’ll fix this later.. You can also use the TableTools ”Print” Button which essentially makes the same thing. You can also have TableTools create a PDF for you, but it looks like sh*t if you ask me. Check DataTables homepage on how to configure the layout for this PDF, I will not work on this as I don’t need it (will use CMD/CTRL + P instead..). Note also that some of the themes probably needs some CSS styling fixes if you want to print e.g. background colors of header. Make sure to add these to advanced_statistics_print_view.css. Menus & Navigation I always wanted one of those Slide-In menus so I finally got one; jQuery mmenu. It’s still rather empty, but should fill up with more filtering options and other knobs, buttons & of course whistles soon enough. To open it; click on the top left icon on the top navigation, it will randomly pick one out of 37 icons on each load but shouldn’t be hard to find as long as you’re not completely ”challenged” by the world around you… :P There’s a couple of more buttons in the Bootstrap top navigation which will toggle the admin menu and header and also a button to clear all currently applied filters. To the right on the top navigation you’ll have two dropdowns which will switch theme and filter by orders status. Theming jQuery DataTables comes with some options to implement themes, so I fixed support for five different layouts: jTable - Looks a bit like the Advanced Order Handler and uses Bootstrap buttons for the seven leftmost buttons. Original - DataTables as it comes out of the box (more or less) Bootstrap - Like Original but with the DataTables Bootstrap css & js jQuery UI - Will adapt to your jQuery-UI Admin Theme (default is Redmond) jQuery UI Smoothness - Uses Smoothness theme instead of Redmond Screenshots of all Themes can be found at the bottom of the ReadMe file in the package. Theme-creator https://www.datatables.net/manual/styling/theme-creator Internationalization Both amCharts and DataTables comes with many language definitions which is included and should automatically load the same language as the one you have set in your admin (assuming the definition exist). amCharts I plan to make a lot of use of amCharts to get easy to interpret charts from store sales etc.. As of Revision 1, you can get a line, area, column, bar, step line, smoothed line, candlestick and OHLC graph for each of the visible columns and for either the specific rows that you have selected (OS style selection, shift/control/CMD click to select multiple rows) or for the entire table(s). The chart modal is movable (only one move per page load) and also resizable. Click on the Graph Names at the bottom of the modal to hide/show different line graphs. Security & Compatability All querying with parameters/input variables to your database will be made with MySQLi Prepared Statements. Preferably you should use the MySQL Native Driver (mysqlnd), but I have added support and tested the Add-On without mysqlnd and everything should work. Prepared Statements removes the threat of MySQL Injections. Not that it matters that much on the admin side of the shop since only authorized users have access, but you can never be too secure, right? ;) For simple installation I have not messed with more native osC files than necessary and instead included necessary functions in general_functions.php. If you have any of my previous Add-Ons installed then you might run into a problem under certain conditions when the mysqli_prepared_query and tep_db_fetch_all functions will fail. If so, then try with replacing the current database functions that you have in ./admin/includes/functions/database.php with the ones that you find in general_functions.php from this Add-on. Features for Revision 1 Sales/Tax Statistics/Report Generator for osC 2.3.x Only tested on osC 2.3.4 but should work on any version Simple five step Installation - Only three files needs to be modified! Automatically creates HTML table and loads orders from server using AJAX. Export Options: CSV, Copy/Paste, XLS, PDF "Automatic" Print View amCharts Graphs over sales & taxes Very Fast Operation, a shop with 30 000 orders loads in under 2 seconds. jQuery DataTables - https://datatables.net/ Drag & Drop Columns Automatic Column Sorting Toggle Column Visibility Detailed day-to-day sales Slide-In Menu with mmenu - http://mmenu.frebsite.nl/ Fixed Bootstrap Top Navigation Themes jTable Original Bootstrap jQuery UI jQuery UI Smoothness DataTables Internationalization - 63 Language Definitions Included amCharts Internationalization - 29 Language Definitions Included 100% MySQLi Prepared Statements Bootstrap Tooltips Toggleable Visibility of both your store header and Admin menu using CSS3 classes OS style selection, shift/control/CMD click to select multiple rows - Plenty of screenshots in package! -
  2. I set up TAX EU and TAX TAIWAN in TAX ZONE. TAX EU includes the Czech Republic, and TAX Taiwan includes Taiwan. The tax rates are 20% and 5% respectively However, when trying to calculate the fees for different countries in the shopping cart, the corresponding tax rates cannot be displayed. Can you tell me how to set it up correctly? THX.
  3. I have a strange problem happening. In using paypal on my site. when anyone adds a product to the cart and then uses pay with paypal the cart ADDS the 7% sales tax. Now it does this even though the person is NOT even logged in. It should only be collecting sales tax form people in our home state South Carolina, But it shows the 7% sales tax to anybody that chooses to check out with paypal. Now once they sign in to their paypal account... if they are NOT in South Carolina the 7% sales tax goes away as it should. BUT it never should have been there in the first place. Seen this error before, or got any clues how I can fix this? This is my site, it is a 2.3.4 site: http://www.ministryhelps.com/ Thanks Leon
  4. I added raiwas @@raiwa paypal invoice fix for PayPal standard. http://addons.oscommerce.com/info/8491 somehow the tax calculation doesn't seem to be right on the PayPal payment site. I ship domestic and international. International customers don't have to pay VAT here in my country so my shop and the PayPal module show everything correctly during the checkout and payment process. The problem starts when a domestic customer pays with PayPal. Here is the Layout in my Shop (checkout_confirmation.php page) Item 1 -> 1620 Yen Item 2 -> 1080 Yen ------------------------------ Sub-Total: 2700 Yen + Shipping 810 Yen ------------------------------ Total: 3510 Yen (incl. 8% VAT, 260 Yen) As you can see all prices are incl. 8% VAT the items, the shipping cost and at the end inside the brackets you see how much VAT is included in the total amount. Now PayPal shows me this Layout: Item 1 -> 1500 Yen Item 2 -> 1000 Yen ------------------------------ Sub-Total: 2500 Yen Tax: 260 Yen Shipping: 810 Yen ------------------------------ Total: 3570 Yen PayPal shows the item prices without VAT (which i don't mind) but later after the subtotal he adds 260 Yen VAT and additional shipping of 810 Yen (which includes 8% VAT again) So PP charges the VAT for the shipping cost twice that's why the 60 Yen price difference. He pulls the VAT of the total amount and the shipping cost. How to prevent this? I could turn of tax for the shipping cost in my shop but then the shop calculation would not be right. This following code is raiwas invoice fix (btw. thanks for that @@raiwa! :thumbsup: ) $parameters = array('cmd' => '_cart', 'upload' => '1', 'handling_cart' => $this->format_raw($order->info['shipping_cost']), 'shopping_url' => STORE_URL.'/'.FILENAME_STORE, 'tax_cart' => $this->format_raw($order->info['tax']), 'business' => MODULE_PAYMENT_PAYPAL_STANDARD_ID, 'currency_code' => $currency, 'invoice' => substr($cart_PayPal_Standard_ID, strpos($cart_PayPal_Standard_ID, '-')+1), 'custom' => $customer_id, 'no_note' => '1', 'notify_url' => tep_href_link('ext/modules/payment/paypal/standard_ipn.php', '', 'SSL', false, false), 'return' => tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL'), 'cancel_return' => tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'), 'bn' => 'osCommerce22_Default_ST', 'paymentaction' => ((MODULE_PAYMENT_PAYPAL_STANDARD_TRANSACTION_METHOD == 'Sale') ? 'sale' : 'authorization')); for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { $j = $i + 1; $attributes_description = ''; if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) { for ($j2=0, $n2=sizeof($order->products[$i]['attributes']); $j2<$n2; $j2++) { $attributes_description = $attributes_description . " (" . $order->products[$i]['attributes'][$j2]['option'] . ': ' . $order->products[$i]['attributes'][$j2]['value'] . ")"; } } $parameters['item_name_'.$j] = $order->products[$i]['name'] . $attributes_description; $parameters['amount_'.$j] = $this->format_raw($order->products[$i]['final_price']); $parameters['quantity_'.$j] = $order->products[$i]['qty']; } and how can i change the Layout in the PayPal site? I would like to have the Tax part shown AFTER the shipping cost. Item Item ------------- Sub-total +shipping +tax ------------ Total Something like that. Kind regards Tsimi
  5. Hi everyone. I have spent about a week trying to sort this out to no avail. I'm in Australia and need to charge GST on shipping costs from my store. I have set up table rate shipping and linked tax class to Taxable Goods (set up in my store to be 10% for GST). The tax calculation works fine and in order totals at checkout the amount is correct. Problem is it is just a lump sum of shipping plus tax. I need to show the amounts seperate, just as it appears for products with tax. No matter what combination of order I use for the modules in Order Total, I ALWAYS end up with output like this: Items cost (ex tax) Subtotal (ex tax) Tax amount (only on items) Shipping (inc tax) TOTAL (inc tax) I need: Items cost (ex tax) Shipping (ex tax) Subtotal (ex tax) Tax amount (items and shipping) TOTAL (inc tax) Does anyone have some advice on where to start trying to fix this? Order of modules within Order Total has had no impact. Thanks in advance John
  6. Hi everyone, hoping someone can help me figure this out. I recently installed the County Sales Tax by Zip Code mod (http://addons.oscommerce.com/info/1856) found in the contributions section, into my 2.3.1 store. Everything was easy to follow and I was able to update the zip codes to reflect the NY zip codes that I need with no problem. The mod, for what it's purpose is (to apply different tax rate to different zip codes), works great. There is one thing that I need help figuring out, and I'm hoping someone more knowledgeable in PHP can point me in the right direction. My store sells apparel, and in NY State, the current laws require you to charge tax only on clothing that's over $110. Any items under that amount are tax-free. From what I understand (and I could be wrong) this modification seems to apply taxes to ALL purchases that are being delivered to a NY address. I want to figure out the best way to tweak it so that it only charges tax on items that are over $110. I know that you can assign tax classes to products, which will tell OSC what tax rate to apply to each item at checkout, but even when using different classes, they are ALL still being charged tax. If I wanted to add a condition to this coding (something like "IF item price is over $110", or "IF tax class is XYZ"), how would I write it, and where would I be able to insert it? Or if you know a better way to do this, please let me know. I've looked at other tax by zip contributions available, and after trying, this one was the best one for my needs, which was to charge different taxes to different zip codes in NY. Any help would be much appreciated! Chacha
  7. California has added an assessment on a client's product. It is 1% on all sales, but has to be listed separately from the sales tax. I added a tax class and tax rate for the item, but it neither lists nor adds to the tax total. I still get only the 8% CA Sales Tax rate. I can choose to edit each individual product and change the tax from teh CA Sales Tax to the CA Lumber Assessment, but can't choose both. Ideally, I'd like to be able to bulk-edit the products (Everything sold is taxable with both line items) but even if I have to update every item by hand I still need to display each tax separately. I can't find anything except someone's module for canadian taxes... anyone have a simple solution to this?
  • Create New...