dashCommerce

Hi Cris,

 I'm interested to contribute dashCommerce 3.0 adding Spanish Tax and programming it.

Tt's very easy to understand. Spanish Tax, called IVA (or VAT in English), is a % that is added to the product's price. There are 3 kind of IVA:

Superreduced: 4%  applied to some basic food (like bread, milch, ...), books and magazines, medicines ...

Reduced: 7% applied to rest of food, dentist, cinema and theatre tickets, hotels, medical machines, ...

Normal: 16% applied to the rest of products and services.

There are a lot of ways to do this, and I think other contries in Europe has similar kind of VAT with differents %.

How we can do this? What about database structure? What about new tables? I've got some ideas.

Thanks again.

Hi, tell me your ideas..

 Im going to make a similar thing for the Dutch taxes (0%, 6% and 19%) and all other European countries ofcourse.
I haven't worked on DC3 yet but im going to start with it on the 18th, so maybe we can setup something together.

Hi 

I am interested in helping with the above topic. From your comments it appears that the spanish/ dutch tax system is the same as the UK VAT apart from the percentages. I gues then other euro countries are very similar so if a few of us get together on this we could come up with a euro tax provider where by you select you country and check the percentage rates etc. 

 What does everyone think about this?

Hi there

 Are you  talking about DC3.0 or DC2.2.0?

If this is about DC2.2.0, I have a almost finished VAT module.
I got the original code from a italian guy who made it for DC2.0.
If you are in a hurry you can get it here:
http://www.mansoft.it/mario

 I have patched my DC2.2.0 with that code manually, cause of differences of DC2.0 with DC2.2.0.
I have tested it and its working properly on the catalog, product, additemresult and basket pages.
It is also included in the admin pages -> Tax Configuration, so you can choose it as a tax provider. You can add/edit/delete your own tax rates: 4%, 7%, 16%, whatever you want.
Then you can apply any of these rates to every product.

The only page I havent tested it fully is the Checkout page. I gave the code to another guy from the old forum to test at the checkout page. He will test it this weekend so we can expect some answer from him in the next week.

I wrote about all this in the old forum, but its gone now.
So I'm writing it again so that people can know.

Even if you want VAT Tax provider for DC3.0, I think that this code help a lot. 

Sorry should of said the version DC3.0.

If the payment provider has been written for 2.xx then as you say we should be able to migrate it to fit in with the DC3.0 architecture.

 I havent researched through the DB table structure for DC3.0, but the table structure for VAT in DC2.2.0 was very simple, yet fully satisfying and working.

 Maybe the only changes in the tables would be at the admin side. I dont know the structure of the new providers.

The same applies to the code. Every page untill the checkout was pretty easy to patch/change. The checkout - I'm waiting for it  

Hi every boydy,

I think we can do it together and we can get ideas from Mario code.

Here is a first approach with some ideas and requirements:

1) Create a table dashCommerce_Store_Vat with fields like: Code, Desc, Percent

2) Add Field something like VatApplied to dashCommerce_Store_Product table.

3) Modify Edit Product pages to add Vat field.

I think to assign VAT by product It's the simplest way to perform this functionality.

The jonnymaboy's idea he said in his post about selecting country to configure VAT is intresting, I like it, but more complex.
Probably is enought to add manually % VAT in table in every store created, but not elegant.

4) Change checkout to identify diferent % VAT applied to selected products and show it.

5) Make site configurable in TAX configuration to select % VAT provider

6) Make site configurable in Site Settings to enable/disable show prices in catalog with VAT included or excluded and show / hide a message beside the price informing it.

Regards,
Albert

well after Understanding the Spanish tax model, i think all european tax systems are exactly the same, so one well made european Tax provider will serve everybody, actually its not that diffirent from the US tax systems, like every state specifies its own Taxes and there can be some changes for interstate shippings, its almost the same here, every european land has its own Tax amounts, but when we ship to another country in europe, we pay no tax at all, thas it so far

 CVitang ...Do you have news about your testing ?? I'm converting the code to VB but I'0ve seen a problem : Inside Modules folder, there is a file called Minicart.ascx...and it should have a codefile called minicart.ascx.cs associated....but it's not on the folder...any idea about this ?? ?

Thankx in advance...

frank. From BARCELONA also (Albert)!! 

Great, Frank!

Nice to meet you.

Am having some snags getting it all working correctly, I will start from scratch this week and will be intouch with this thread with my results, please give me the week, I only get evenings.

Albert,

 Your approach seems fine to me. Shall we wait a week or so until surfluds has finished testing the VAT for 2.xx As once that is done we can re-use the code an import into 3.

It would be good if we can get the euro tax provider built into the next release of dc 3.x including like the current one RegionCodeTaxProvider. This will obviously be a big advantage to all euro users due to them not needing to run sql scripts and edit aspx pages, instead just select the tax provider from the list.

Therefore when we code we need to make 100% sure that the code for euro tax provider is only used if it has been selected as a tax provider (im sure we all know that anyway just thought i would make a note of it).

I suggest we hang on until surfluds has finished about a week he thinks (fits in with me perfect as im away for about a week).

Then use Alberts approach to design and code. Anybody agree/ disagree.

I agree!

 @ magefesa What code are you talking about? Where did you get it? I gave my code to surfluds. I also pointed to Mario's code.

If you are refering to Mario's code, its a patch, so it contains only the files that are different from the ones in the original version.

 Excuseme cvitnag...I'm still translating the Mario's code to vb....and i thought 1 file was missing...I' ll pass to VB and when some tests done, i'll notice you about all.... thanks again...very interesting post this one....