Ubercart

Hi, ubercart sucesfully instaled, everything ok, but after enabled VAT module, i have an error:

user warning: Unknown column 'rate' in 'field list' query: select rate from uc_vat where nid=1 and vid=1 in /data/web/du-sk.com/web/includes/database.mysql.inc on line 172.

I am not very good in php, but i think the path "/data/web/du-sk.com/web/includes/database.mysql.inc" can be wrong... it should be "/data/web/du-sk.com/includes/database.mysql.inc"
how can i fix it?

Hey Ali.

Problem is, that there's missing the row 'rate' in the mysql-table uc_vat.
You can fix that with the SQL-statement "ALTER TABLE `uc_vat` ADD `rate` INT( 11 ) NOT NULL ;"

Then the error isn't displayed anymore. But, after a first look, it seems, that the module still don't work correctly.

Any help welcome.

Edit: Sorry, it works fine after altering the table with the row "rate" (see sql-statement above).
Thanks a lot for that module!

thanks, i did it before 5 minutes
VAT is displayed, after you add an item, and click on "checkout".

there is a pane displayed:
VAT contained in order
19,0% VAT $478.99

but i think it would be nice to have VAT also in Order total preview

Something like this:
Subtotal: $2,521.01
19,0% VAT: $478.99
Order total: $3,000.00

And, for better funcionality of this module, shop admin have to be able to see amout without tax and with tax also when he add a product.

I looked in olav's install file, and he had provided that query in an update function but forgot to tweak the install function. I've changed this and re-uploaded the file.

The formula for calculating the VAT [price * qty * rate / (100 + rate)] is wrong, isn't it?

You must replace the line
+= $item->price * $item->qty * $rate / (100 + $rate);
with
+= $item->price * $item->qty * $rate / (100);

I will also try to add some more features to the Module in the next few days. But I'm just a silly noob in programming drupal modules, so please be patient (and hope the weather will be bad, so that I have the time to read those drupalbooks)

And before I start coding: Is this the only module for displaying VAT? I don't want to do needless work.

greetings from germany!

EDIT: Sorry, that was wrong... Calculation is right, cause you calculate the vat IN the price.

Thanks for this useful module, here is my suggestion :
i saw you try to add "hook_line_item" but doesn't seems to work, but it would be a better integration than make a pane, here is my code (update, better way and show on bill):

it works, but sometimes, on checkout page, need some refresh to get good line, saw post about this, i'll look tomorow.

i am not sure how to add or replace this code in module...

You can place it line 130 (there is coment line of hook_line_item), and so you can remove (or just coment) hook pane function, line 174 to 221.

Hey Mog.

Seems to be good. Thanks for the work.
But the code has one problem: It doesn't consider the shipping cost and other generic line-items.
Maybe you can try to change this.

Just a hint:
Instead of:

use something like this:

It's dirty. But it works (just tested on the checkout-review page).

greetings mic

I have installed module ans french translation.
No probleme with tables, I have created VAT rates without problem.
After editing some products, I have the word "TTC" (french abriviation for "with taxes") added before the SKU, without space.
How can I change this display, I think it should be better near price.

Frederic

I tested the module, it is very usefull for european shop. Thanks

If I can suggest a new feature, it coule be really great to add a role and a country selection to apply a VAT. Why ?

Because, in the case of a shop that sell to personal and professionnal people all over the world, the following rules apply :

In my example, the shop is based in an European Union country...

• If you sell products to personal people all over the world, you have to include the VAT, so, actually, the module works well for this case.
• However, if you sell to professionnal people, the rules are more complex :
  • If the professionnal is in the country of the shop, you apply the VAT
  • If the professionnal is not in the country of the shop, you don't apply the VAT

That's why it could be great to provide a role and a country selection to be able to configure the VAT without hacking the module.

As I say in this post, in Europe, company have an unique VAT number that have to figure on all invoices.

I'm working on the modification of the VAT module to allow 2 things :

• Store the store VAT number and create a [store-vat] token to allow the display of this number on the invoice template system
• To ask the customer VAT number on the checkout billing information pane (because if you sell products to another professionnal, both VAT number (your store and his store) have to figure on the invoice)

Edit : The first step is pretty finished.

Edit 2 : For the second step, I think it could be great to provide in the administration page the possibility to check or uncheck if you want to see the VAT number field on the checkout billing pane. I don't know if my developpers skill will allow that. See this post to provide your suggestions, help etc...

Mog, does your work on the hook_line_item progress ?

I'm improving VAT module and I would like to implement your possibility. I pass a couple of hours to try to find why, sometimes, you need to refresh page to get good lines.

I don't find PHP problem, it seems to come from set_line_item javascript function...

It seams that the module does not work with alpha7d

Fatal error: Call to undefined function uc_cart_checkout_new_pane() in /var/www/html/drupal/sites/all/modules/uc_vat/uc_vat.module on line 196

Any update?

PS. It seams that module is not in any repository?!

You can see on the related thread how to make it compatible with newest version of Ubercart.

I think I will not support this module anymore for several reasons discuted in several others thread about the VAT :

• My deadlines is very close and I need to put 100% of my brain on others module I need
• The Taxe do a similar job to the VAT module, you can set different tax for different product classes etc... The only things that the VAT module do is to show VAT on checkout pane

The VAT module need a big changement to allow to manage and put product prices without VAT on your shop to have "not wrong" google analytic reports etc...

Instead of working on VAT module, I will work on a module that allow to put price with VAT when you put your sell price without VAT. But I think it will be another module that the VAT module.

Updated for newer Ubercart.

I have a unique problem handling taxes that I posted here: http://www.ubercart.org/forum/support/6603/sales_tax_ma_only_part_produc...

Since taxes for certain of my products have to happen on a product-basis rather an an order-basis, I was wondering if this module might be better suited to attack it. Thoughts? Any help greatly appreciated!

deleted comment!

This module does work with drupal 5.12 and ubercart 1.6 - however does not utilise the existing tax module (based on workflow) for calculating costs.

You are required to supply a tax amount and then your pages say "includes x% tax". A seperate (and confusing) block is added to the checkout page containing the taxable amount.

Finally - existing produts must be edited to have the tax applied.

It is essential that we keep the price supplied to our stores tax free - and tax is applied to the user. This allows us to display prices including tax or excluding tax (or both). When our tax changes (how topical) our store will automatically update all our prices.

For most countries there are multiple taxable products. In the uk, for example, shoes are not a taxable item, but fuel is taxed at nearly 75%.
This means that tax can be applied at a seperate rate to each product. The ideal solution requires an update to the core tax module allowing each product to have its own tax "band", and then the option to display prices with or without tax (or both).

A simple report would then show the amount of tax paid/payable a month.

Helllo i use this module, im really happy with it,
it saves my life...
i'd like to know if there is a way to make it works with price_per_role
http://drupal.org/project/uc_price_per_role
the price i enter for special roles do not include VAT, i have to make the math to mak it ok on checkout

thanks to all