VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: elainemarley on July 09, 2013, 18:22:30 PM

Title: Final Price not showing up correctly after migration
Post by: elainemarley on July 09, 2013, 18:22:30 PM
So I've made a migration to 2.5 and I had a bit of trouble but now everything works more or less as before except for one thing: prices!

This is what I see in my backend:

(http://i.imgur.com/zl4AIy3.png)

And this is my database:

(http://i.imgur.com/o1cdNSz.png)

You can see there the final price is 35, and that's what the backend and frontend should be showing, but instead they both pick the base price. I could see that the frontend was a mistake in my code, but how about the backend? If the database says final price is 35, why isn't it showing it there?
Title: Re: Final Price not showing up correctly after migration
Post by: elainemarley on July 10, 2013, 10:26:14 AM
Any advice? Anything else I could give to add to the information previously posted?
Title: Re: Final Price not showing up correctly after migration
Post by: jenkinhill on July 10, 2013, 11:38:35 AM
The table you show is Orders, not the product price.  The product price is stored in #_virtuemart_product_prices table, and only the cost price is stored unless you use a price override, in which case that is stored as well. The other prices such as final price are calculated on the fly accodring to your tax/calculation rules. In your case it looks like no rules are set.

BTW you have not stated what you upgradede from and what VM version you are using. http://forum.virtuemart.net/index.php?topic=79799.0
Title: Re: Final Price not showing up correctly after migration
Post by: elainemarley on July 10, 2013, 16:04:17 PM
Sorry I forgot that:
- Old Joomla Version: 1.5.23
- Current Joomla version: 2.5.11
- Old VM version: 1.1.7
- Current VM version: 2.0.2a

After the upgrade I had to use the script from someone in this forum to get the multiple images to show up but basically the rest was ok.

On the table you say I have 0 for all products on `override` and `product_override_price`, the other price is the base price.
Title: Re: Final Price not showing up correctly after migration
Post by: elainemarley on July 10, 2013, 17:27:27 PM
Also right now I'm working locally with mamp before everything is sorted and the site can go live so my php is 5.4.10
Title: Re: Final Price not showing up correctly after migration
Post by: jenkinhill on July 10, 2013, 18:49:22 PM
Did you chack your tax/calculation rules?
Title: Re: Final Price not showing up correctly after migration
Post by: elainemarley on July 11, 2013, 09:31:06 AM
I did not make this website originally, I am only in charge of the update of everything and migration so this is what I had originally:

(http://i.imgur.com/5hyL7Ol.png)

And this is what I got now.

(http://i.imgur.com/5J0huiQ.png)

It's the first time I ever use virtuemart (and joomla for that matter) so I'm probably missing something here since I don't see clearly how to set up the taxes on the new version of the plugin.

I went and look to the taxes & calculation rates and that was empty but I can't find that part in the old website. Do I have to add it there and it will work fine or should it have changed alone after migration but something else went wrong?
Title: Re: Final Price not showing up correctly after migration
Post by: elainemarley on July 11, 2013, 09:44:20 AM
Well yeah that was it, I added the vat in that section and now it's all fine and dandy, I wonder why that didn't go through in the migration...

I hope I'm not missing anything else like that for that matter!
Title: Re: Final Price not showing up correctly after migration
Post by: jenkinhill on July 11, 2013, 10:37:52 AM
Rules are not migrated as the way they are applied now is totally different and far more flexible than in previous VM versions.