News:

Looking for documentation? Take a look on our wiki

Main Menu

Easiest way to export and import just price updates

Started by gldproducts, January 22, 2016, 17:36:37 PM

Previous topic - Next topic

gldproducts

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.

Constantino

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

AH

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



Regards
A

Joomla 4.4.5
php 8.1

gldproducts

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

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

gldproducts

I currently have Joomla! 2.5.28 and Virtuemart and VirtueMart 2.6.16. Will that be okay?

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation