Author Topic: bulk price update for virtuemart 2.0  (Read 8744 times)

widcater

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 31
  • 15 years php developer , focus in eccommerce
    • vm2x
  • Skype Name: widcater
  • VirtueMart Version: VM3
bulk price update for virtuemart 2.0
« on: July 27, 2012, 05:10:45 am »
I just released a new extension for vm2.0 about bulk price update, you can download it in my website here :bulk price update for virtuemart 2.0 .


How to install it?
there are two steps as following :
1. unzip the zip file, and upload the files to the joomla root path.
2. excute the sql file - priceupdate.sql with the host tool - phpmyadmin.



How to use it ?
1.vm backend - tools- priceUpdate
2.Input the percent value that you want to update the price into the textbox, then click the submit button.bulkPriceUpdate will finish the update immediately.



www.vm2x.com
Pinterest Rich Pin Plugin Extension For VM3
Adyen Card payment plugin for VM3
Facebook Commerce Catalog CSV Creator For VM3
Saferpay Payment Plugin for VM3

fastpat27

  • Jr. Member
  • **
  • Posts: 107
Re: bulk price update for virtuemart 2.0
« Reply #1 on: September 28, 2013, 14:01:52 pm »
Hi Widcater

The instructions with your extension talks about increasing prices by percentage, so I was wondering can it be used to increase the prices individually, e.g. product 1 is £5 (new price £5.99), product 2 £6 (new price £6.55). Basically not fixed amount to rise all are varied.

Also if you had any demos or screenshots on how this works where could I see this?

Thank you
FP

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3234
  • VirtueMart Version: 3.8.4
Re: bulk price update for virtuemart 2.0
« Reply #2 on: September 29, 2013, 15:08:24 pm »
fastpat

Use CSVI for this type of item editing, you can alos use it for lots of other export/import functions

http://www.csvimproved.com/downloads/csvi-free

The free version is a great place to start to practice and get an idea of the vast range of possibilities!

I highly recommend you give it a try.  And NO I am not anything to do with the product and do not get any funds for recommending it!
regards
A

Joomla 3.9.19
php 7.3

fastpat27

  • Jr. Member
  • **
  • Posts: 107
Re: bulk price update for virtuemart 2.0
« Reply #3 on: October 05, 2013, 18:02:23 pm »
Hi Hutson

Thanks for the suggestion and this may come in handy in the future.  8)

In this instance I'm not the end user and it may be a bit technical for my client to use but appreciate your help.

Thanks
FP

Cholent MT

  • Beginner
  • *
  • Posts: 19
Re: bulk price update for virtuemart 2.0
« Reply #4 on: March 06, 2014, 06:01:29 am »
I get a error when I import the sql file.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id, module_id, parent_id, name, link, depends, icon_class, ' at line 2

ivacademyru

  • Beginner
  • *
  • Posts: 37
  • ConsultingOnline Life & Business www.ivacademy.net
    • Love Academy ♥ Академия Любви - Life coach, Marriage counseling and Business consulting Live Chat Call Now www.ivacademy.net Проблемы в Отношениях, Жизни или Бизнеса? Звоните!
  • VirtueMart Version: vm3
Re: bulk price update for virtuemart 2.0
« Reply #5 on: May 21, 2015, 19:11:58 pm »
Hi very nice extention for VM 2 work ok but dont work in VM3 could somebody advice me if is there something similar for vm3?
Web site design, eCommerce design, you own first Online Business Order Now and Get - 10% off  at IT IVAcademy lab just contact us, click www.ivacademy.net

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4341
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: bulk price update for virtuemart 2.0
« Reply #6 on: June 12, 2015, 01:07:08 am »
Hi ivacademyru,
For virtuemart 3 (and vm2) you can use VM BE PRO.
You can see the tutorial at youtube : https://www.youtube.com/watch?v=JFFKv2u4meY&list=PLYQ9rB_F7nGO3gNplLRDZl7jvfdcxO0tH
Moreinfo at : http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm.
It work for Joomla 2.5 and Joomla 3. Can mass update prices with operator -,+,* eg. -10 or *1.2
But works for all product fields and languages

I'm the developper of this tool.
Greets,
Patrick

fastpat27

  • Jr. Member
  • **
  • Posts: 107
Re: bulk price update for virtuemart 2.0
« Reply #7 on: June 15, 2015, 17:29:41 pm »
Nice little extension here depending on what you want it to do. Works well for a few of my sites on both WM2.6.14 and 3.0.9

http://extensions.joomla.org/profile/extension/extension-specific/virtuemart-extensions/product-excel-like-manager-for-virtuemart

Well worth the few dollars :)

FP

ivacademyru

  • Beginner
  • *
  • Posts: 37
  • ConsultingOnline Life & Business www.ivacademy.net
    • Love Academy ♥ Академия Любви - Life coach, Marriage counseling and Business consulting Live Chat Call Now www.ivacademy.net Проблемы в Отношениях, Жизни или Бизнеса? Звоните!
  • VirtueMart Version: vm3
Re: bulk price update for virtuemart 2.0
« Reply #8 on: June 17, 2015, 15:01:27 pm »
Could I use this extention fot Joomla 3 and virtuemart 3
Web site design, eCommerce design, you own first Online Business Order Now and Get - 10% off  at IT IVAcademy lab just contact us, click www.ivacademy.net

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4341
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: bulk price update for virtuemart 2.0
« Reply #9 on: June 17, 2015, 15:20:13 pm »
Hi,
My extention VM BE PRO http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm
is tested with virtuemart 3 and joomla 3.4 and virtuemart 2.6.6 and joomla 2.5.10
If you have any problem, you can send me a message here or in the shop or post in the forum.

ivacademyru

  • Beginner
  • *
  • Posts: 37
  • ConsultingOnline Life & Business www.ivacademy.net
    • Love Academy ♥ Академия Любви - Life coach, Marriage counseling and Business consulting Live Chat Call Now www.ivacademy.net Проблемы в Отношениях, Жизни или Бизнеса? Звоните!
  • VirtueMart Version: vm3
Re: bulk price update for virtuemart 2.0
« Reply #10 on: July 08, 2015, 16:16:20 pm »
Hi is there some free version of this kind of plugin for j 3 and vm3?
Web site design, eCommerce design, you own first Online Business Order Now and Get - 10% off  at IT IVAcademy lab just contact us, click www.ivacademy.net