1

In Joomla 2.5, you have a program called CSV Improved, you can import/export products from virtuemart and also, edit for example the price of 500 products quickly. You don't have to change the price of each product one by one... So, my answer is if in Joomla 3.2.7, is there any program that supports Virtuemart, for working quickly and easily with a database. - Change features of many products - Import / Export products - Etc...

Any idea? P.D.: If I do it manually, it will take me many time... Prices of my online shop are changing "constantly"...

  • I suppose you could write a database query and import that query into PhpMyAdmin – Lodder Feb 19 '15 at 9:52
  • You mean, create a code in PHP to update the features I want massively? – Antonio Feb 19 '15 at 9:54
  • not, not PHP, just a standard SQL query to update the products prices in a specific table with some where clauses. If you could explain in a little more detail what you want to update exactly and based on what specs, maybe we could help a little more – Lodder Feb 19 '15 at 9:57
  • I want a free extension, in the last case, a paid extension, to import / export virtuemart products. And if I want to make them a change, like prices, do it massively. To upload a file and update the prices. I don't want to waste time changing features of each product one by one... Do you understand what I want? I just want a "CSV Improved" for Joomla 3.2.7 – Antonio Feb 19 '15 at 10:01
  • Have you tried the latest version of CSV Improved? Even though it says it's for Joomla 2.5, it might also work with Joomla 3.x. Please try it – Lodder Feb 19 '15 at 10:03
1

NoNumber DB replacer, is a great extension that allows performing changes massively directly in the content of the database.

There is a Free and a Paid version. With the Free version you can do search and replace in specific db tables up to 50 rows at time.

The Paid version supports Limiting your searches with where statements, using regular expressions, and replaces up to 1000 rows at time.

I would definitely go with the paid version.

Backup!!!

However you should be very cautious using the extension on a production site, changes you do on your db are irreversible. So you should be conscious about what you are going to replace, although the extension shows what it is going to be replaced on each row, but stay safe by keeping backups of your db.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.