Hi
I need to add/update second price for products (price for wholesale shopper group). How do you do it? or which extensions is able to do it?
Thanks
I don't know, if you was contact me for vm be pro today,
but adding a column "old price" with the sku,npm or gtin and new price, you can batch import(and update) the prices with vm be pro.
If you include other column as discount or tax, this are updated too.
I would prefer a solution that does not require you to have to specify the current price when updating.
My approach is to Check these fields on an input file:-
virtuemart_product_id, virtuemart_shoppergroup_id, price_quantity_start, price_quantity_end, product_currency
Ensure virtuemart_product_id and shopper_group is on file
Update current price if these fields are equal
Add new if they are not
Note that these two entries are normally "0" ( price_quantity_start, price_quantity_end)
Quote from: AH on February 08, 2018, 17:26:35 PM
I would prefer a solution that does not require you to have to specify the current price when updating.
My approach is to Check these fields on an input file:-
virtuemart_product_id, virtuemart_shoppergroup_id, price_quantity_start, price_quantity_end, product_currency
Ensure virtuemart_product_id and shopper_group is on file
Update current price if these fields are equal
Add new if they are not
Note that these two entries are normally "0" ( price_quantity_start, price_quantity_end)
Of course, it prevent more bad updates, but you need to have or get all this values.
Most time, my customer have only old price+ SKU and want update to new price with a csv, they dont want to get from SQL the product prices.
It's why i added "old price" possibility and worked always for my cases.
Agreed
Often stores will have have multiple prices per product - one per shoppergroup - with multiple shoppergroups
Therefore matching on sku and shoppergroup_id - is enough
but these price are managed by employees who are not able to update by sql queries
virtuemart-manager has fantastic bulk update, but it doesnt have possibility to bulk update second price
Then maybe you need to get someone to build the component functionality for you
thats what I asked, if someone can recommend such extension :)
Apologies
Maybe this
https://csvimproved.com/extension (https://csvimproved.com/extension)
@Ah, i know and used myself CSVI many times, but you really mean that a casual user can use csvi without some knowledge?
Quotevirtuemart-manager has fantastic bulk update, but it doesnt have possibility to bulk update second price
Unless this exists or is being built then CSVI seems like thh only option
Knowledge is important when using this component