Combinations and Tax

[Jamesloker]

Hi All,
I can't seemed to find information on the following...issue....

When in combinations for a product, you have wholesale price and impact on price.

The impact on price requires the tax included price. Next year our VAT rate is due to change, wouldnt it have made more sense to put the price in there of excluding tax and then at the cart work out the tax rate otherwise, when the tax rate goes up, people are gonna have to redo all of the prices for their combinations and products. Just a thought.

My example is as follows. I sell Poster Frames. They are in A1 A2 A3 and A4 sizes. I have product, 25mm Mitred Frames, and combinations setup for each of the sizes with the wholesale price of them and the increase entered. Nothing is entered on the info tab for prices. Lets say i sell an A1 for £20, in the increase box i must put £23.50 (price + VAT) even though on the site it reads £20 excl vat.

When the VAT changes next year, i will have to alter every price for products and combinations. Is it me or does it seem daft when there is a taxes section that has the VAT rate, would it not be better to put the increase amount in excluding VAT or is that possible now and im missing something?


BTW im on version 1.3.0 (havent gone up to 1.3.1)

[tomerg3]

Hi,

I have a Mod that lets you display the tax on a separate line, and also change the attribute price to exclude tax.

You can find it on my shop (address in my signature).

[Jamesloker]

Im talking about on the Back end when creating/editing products in the catalogue.
Thanks for info on your module but it is not relevant

[DutchCoding]

I would say just add your prices in the attributes tab exluding and run a SQL query on the attribute prices to add the tax!

[Jamesloker]

Thanks Dutch,
Could you possibly assist me with the SQL query?

Update ps_attribute_impact.price
ps_attribute_impact.price = ps_attribute_impact.price * 1.175

Im not too good with SQL.

[DutchCoding]

looking at that sql the i already see an error,

the syntax of the UPDATE statement =

UPDATE `table` SET `table.column` = `value`

I dont have alot of time to check it out. but i wil update you as soon as i can.

greets,
DutchCoding

[DutchCoding]

UPDATE `ps_product_attribute` SET ps_product_attribute.price =(ps_product_attribute.price*1.175)

There you go! suppose to work.

Greetings,
DutchCoding

[Eck!]

Dont think this will work on combinations that have already been generated. I tried this hack before and it didnt work for me. There is a "price" field in "ps_product_attribute" as well as a "price" field in "ps_attribute_impact", so Im not entirely sure how this works.

----------------------------------------
Edit: Looking at both tables I would say ps_attribute_impact is the one to go for:

UPDATE `ps_attribute_impact` SET `price`=`price` * 1.175

In January, you are going to have to remove the VAT and re-add it at 20%

UPDATE `ps_attribute_impact` SET `price`=`price` / 1.175;
UPDATE `ps_attribute_impact` SET `price`=`price` * 1.2;

[Jamesloker]

To put it bluntley DutchCoding....YOUR A LEGEND!!!!!!

Thanks, that works...

Love this forum...

If i can be of any service to anyone...please let me know!