VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: slutsker on April 02, 2012, 22:31:57 PM

Title: Edit all prices in one table
Post by: slutsker on April 02, 2012, 22:31:57 PM
Hello
i am using joomla 2.5.4 and VM 2.0.2
i want to edit all prices in one table
also it would be very nice to edit other products parametrs in one table

how can i do it?
maybe there is some extension?
Title: Re: Edit all prices in one table
Post by: slutsker on April 03, 2012, 10:47:49 AM
Unfortunately i found nothing
Title: Re: Edit all prices in one table
Post by: jenkinhill on April 03, 2012, 11:05:51 AM
That was spam....

A good way to be able to edit all prices is to use CSVI (there is a free and a paid version) to export your products as a list. I open the lists in openoffice calc and then edit the prices etc before uploading the file back to the site.
Title: Re: Edit all prices in one table
Post by: slutsker on April 04, 2012, 22:54:17 PM
how can i get free version from http://www.csvimproved.com?
Title: Re: Edit all prices in one table
Post by: jenkinhill on April 04, 2012, 23:24:25 PM
Register and go to the download page.
Title: Re: Edit all prices in one table
Post by: slutsker on April 05, 2012, 09:42:51 AM
interesting site - i had to contact administrator to register
there is a big button Subscripe now and little "register" in top of window
i will try csvi

thank you
Title: Re: Edit all prices in one table
Post by: slutsker on April 11, 2012, 21:52:27 PM
i tried CSVI - it is not to interesting for me because you need to import and export files

i can't belive that so many people use VM and there is no way to change prices in one table - how can it be?
Title: Re: Edit all prices in one table
Post by: Merry on April 11, 2012, 23:05:09 PM
What you are asking for is not a common feature. It is rare for an administrator to change all prices at one time, and if they do, typically exporting to Excel is the standard way to do it.

If you have database experience you can use phpMyAdmin to update the prices directly.

Merry
Title: Re: Edit all prices in one table
Post by: slutsker on April 12, 2012, 08:18:47 AM
it can be rare for admins i would be glad to see such solution for anyone
in my eshop all prices can be changed 2 times during the day so product manager should change all prices
Title: Re: Edit all prices in one table
Post by: Merry on April 14, 2012, 03:57:50 AM
Slutsker,

Magnetic One is working on a Store Manager for VirtueMart 2, but it is not ready yet:

http://www.magneticone.com/store/VirtueMart.Modules/Store.Manager.for.VirtueMart

This allows you to work on VirtueMart on your desktop as if it were a Windows program. Their most powerful feature is the batch upload of prices.

When this comes out it will be the best you can do... or you will have to switch to another ecommerce program that has this feature built-in. The only one I know of with it built-in is Loaded Commerce 6.5 B2B, which is quite expensive tho open source. The feature is so powerful - can crash your whole store easily if you sort before saving, then make price edits  - that I actually don't recommend it.

Merry
Title: Re: Edit all prices in one table
Post by: lipes on April 14, 2012, 05:02:22 AM
In VM1 we can edit/update the Product Price directly from the Product Table Columns (it open a popup with "Price Information")...
I've also talked here ( http://forum.virtuemart.net/index.php?topic=99052.msg335382#msg335382 ) about the #3 point... but no answers/evolution from anyone (Developers)!!!   :'(

Some good things we have lost from the VM1 and its worst in VM2 ..
1) like the Automatic Price Update in BE Product Area Vm1 vs VM2
Demo: http://demo.virtuemart.net/administrator/index.php
http://demo.virtuemart.net/administrator/index.php?page=product.product_form&limitstart=0&keyword=&product_id=36&product_parent_id=&option=com_virtuemart
Everyone can put the price and VM1 automaticaly calculate the Product Price (Net) or the Product Price (Gross)... very fast!

2) like the Script that detect if we'll click in "Upload a File" > "Image Action"  any image/file from our Disk and change automaticaly from the "None" (default position) to "Upload" Position...   (This is the same like we have in Virtuemart 1.1x)

3) like the Terms of Service link in Registration Area ..
we got that in VM1: http://demo.virtuemart.net/index.php?option=com_virtuemart&page=shop.registration&vmcchk=1&Itemid=2  (I agree to the Terms of Service (Terms of Service) *)
and in VM2 people CANT read what they agree.. It's insane!!  ???
http://virtuemart.cloudaccess.net/my-account
People must click (or not) without a link to read TOS....

...
Title: Re: Edit all prices in one table
Post by: slutsker on April 26, 2012, 12:25:21 PM
i don't understand why this function (edit/update the Product Price directly from the Product Table Columns) dissapeared in VM 2.0

why? :(