Author Topic: A button to copy/duplicate shipping rates.  (Read 9712 times)

NeroInferno

  • Beginner
  • *
  • Posts: 32
A button to copy/duplicate shipping rates.
« on: March 12, 2009, 09:35:27 am »
Could be great to create a button to copy/create shipping rates.

At least here where i live the international postal service is divided into 3 zones.

Imagine how much is terrible to select every time 50 or more countries holding CTRL for every kind of shipment and for every weight if you can't duplicate tables in the database.

Fabio
Joomla 1.5.9 + VM 1.1.3

jyaurig

  • Beginner
  • *
  • Posts: 12
    • Perfume Gallery
Re: A button to copy/duplicate shipping rates.
« Reply #1 on: March 18, 2009, 00:09:39 am »
I am looking for the same.
Any suggestions_
Joomla 1.7.3
Virtuemart 2.0

NeroInferno

  • Beginner
  • *
  • Posts: 32
Re: A button to copy/duplicate shipping rates.
« Reply #2 on: March 19, 2009, 07:59:05 am »
Editing manually the table jos_vm_shipping_rate (where jos is the suffix of the joomla tables)

You need to copy and paste new lines, remeber every line MUST finishes with a comma "," and the last line with a ";"

Export that table into you pc and editing it from there, then EMPTY the table and import it back into the DB.

If you aren't familiar with these make a total backup using JoomlaPack.
Joomla 1.5.9 + VM 1.1.3

quantum_leap

  • Beginner
  • *
  • Posts: 10
    • My CV
Re: A button to copy/duplicate shipping rates.
« Reply #3 on: December 24, 2009, 11:36:16 am »
When you say empty the table, you mean empty the existing table in the database and then import the one you just edited?
Joomla! 1.5.15, VirtueMart 1.1.4 stable

NeroInferno

  • Beginner
  • *
  • Posts: 32
Re: A button to copy/duplicate shipping rates.
« Reply #4 on: December 24, 2009, 20:18:18 pm »
When you say empty the table, you mean empty the existing table in the database and then import the one you just edited?

Yes exactly, empty the data into the jos_vm_shipping_rates and then import the rates you've just edited.

Merry Christmas!
Joomla 1.5.9 + VM 1.1.3

quantum_leap

  • Beginner
  • *
  • Posts: 10
    • My CV
Re: A button to copy/duplicate shipping rates.
« Reply #5 on: December 24, 2009, 21:09:04 pm »
Yeah, it worked, man, thanks, Merry Christmas to you, too!
Joomla! 1.5.15, VirtueMart 1.1.4 stable

NeroInferno

  • Beginner
  • *
  • Posts: 32
Re: A button to copy/duplicate shipping rates.
« Reply #6 on: December 25, 2009, 18:15:40 pm »
My pleasure mate! :)
Joomla 1.5.9 + VM 1.1.3

MarkMuller

  • Beginner
  • *
  • Posts: 2
Re: A button to copy/duplicate shipping rates.
« Reply #7 on: April 09, 2010, 01:33:47 am »
Hi guys,
This looks like the exact solution I need to copy shipping rate details which are very tedious to re-create with so many countries and weights.
But I'm new to virtuemart so can someone explain in newbie language how to perform the process described above?
It looks like you have to edit internal files or something and I am currently only familiar with the virtuemart interface inside joomla.
Hope you can help.

Thanks,
Mark.

NeroInferno

  • Beginner
  • *
  • Posts: 32
Re: A button to copy/duplicate shipping rates.
« Reply #8 on: April 09, 2010, 23:41:06 pm »
Hello Mark,
i don't use virtuemart from a lot so i cannot remember but you need to enter into the database with any tool like phpmyadmin and need to edit the table called jos_vm_shipping_rate (where jos is the suffix of the joomla tables)

You need to copy and paste new lines, remeber every line MUST finishes with a comma "," and the last line with a ";"

Export that table into you pc and editing it from there, then EMPTY the table and import it back into the DB.

Joomla 1.5.9 + VM 1.1.3

LeopardMan

  • Beginner
  • *
  • Posts: 17
Re: A button to copy/duplicate shipping rates.
« Reply #9 on: November 06, 2010, 17:09:47 pm »
Yes - this sounds just like one of the buttons Virtuemart now misses. gosh, what an incredible hassle it is to make four different shipping rates for three different regions...

Please add a copy/duplicate button to the shipping part!

:-)

marta87

  • Beginner
  • *
  • Posts: 1
Re: A button to copy/duplicate shipping rates.
« Reply #10 on: November 08, 2010, 17:47:03 pm »
Thanks everyone. Great request(s). I agree totally and will monitor this thread for future developments...

chocolatepudding

  • Jr. Member
  • **
  • Posts: 65
Re: A button to copy/duplicate shipping rates.
« Reply #11 on: December 15, 2011, 18:33:19 pm »
Hello,

Where do I access jos_vm_shipping_rate?

Thank you.