VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: gldproducts on January 22, 2016, 17:36:37 PM

Title: Easiest way to export and import just price updates
Post by: gldproducts on January 22, 2016, 17:36:37 PM
All,

I hope you can help. I only need to do a price update on our items. There are over 600 if them, and I was hoping somebody might give me a good tip that would be easy to update the prices.
Title: Re: Easiest way to export and import just price updates
Post by: Constantino on January 25, 2016, 12:59:11 PM
Hello

Mass product updates are very easy with Store Manager. There is a built-in export/import wizard, so you can export necessary for updating details to .csv, change values and import from the file back to VirtueMart. Here is the tutorial on import - https://virtuemart-manager.com/useful-articles/product-management/virtuemart-product-import/ and free trial - https://virtuemart-manager.com/free-download/, so you can check the application without paying
Title: Re: Easiest way to export and import just price updates
Post by: AH on January 25, 2016, 13:33:34 PM
Use CSVI

Lots of assumptions in this next bit:

If you only have one price per shopper group

You could read them into a separate table within your database and do the SQL to update from this table to the prices table



Title: Re: Easiest way to export and import just price updates
Post by: gldproducts on January 26, 2016, 22:58:22 PM
Quote from: AH on January 25, 2016, 13:33:34 PM
Use CSVI

Lots of assumptions in this next bit:

If you only have one price per shopper group

You could read them into a separate table within your database and do the SQL to update from this table to the prices table

This?
http://extensions.joomla.org/extension/csvi-pro
Title: Re: Easiest way to export and import just price updates
Post by: GJC Web Design on January 27, 2016, 01:01:23 AM
Yes, it is more or less the standard VM importer
Title: Re: Easiest way to export and import just price updates
Post by: gldproducts on January 27, 2016, 18:06:10 PM
I currently have Joomla! 2.5.28 and Virtuemart and VirtueMart 2.6.16. Will that be okay?
Title: Re: Easiest way to export and import just price updates
Post by: GJC Web Design on January 27, 2016, 21:20:53 PM
QuoteVirtueMart 2.6.16
no

nothing to do with csvi but your version is way out of date:  2.6.22 is the latest

oN Joomla 2.5 the free version of csvi works fine..   https://www.csvimproved.com/downloads