VirtueMart Forum

VirtueMart 2 + 3 => Product pricing => Topic started by: MKI-Miro on February 08, 2018, 09:36:12 am

Title: Which extension to use for bulk wholeasle price update
Post by: MKI-Miro on February 08, 2018, 09:36:12 am
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
Title: Re: Which extension to use for bulk wholeasle price update
Post by: Studio 42 on February 08, 2018, 16:24:13 pm
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.
Title: Re: Which extension to use for bulk wholeasle price update
Post by: 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)
Title: Re: Which extension to use for bulk wholeasle price update
Post by: Studio 42 on February 08, 2018, 17:44:37 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.
Title: Re: Which extension to use for bulk wholeasle price update
Post by: AH on February 08, 2018, 18:13:38 pm
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
Title: Re: Which extension to use for bulk wholeasle price update
Post by: MKI-Miro on February 08, 2018, 18:30:40 pm
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
Title: Re: Which extension to use for bulk wholeasle price update
Post by: AH on February 08, 2018, 19:08:52 pm
Then maybe you need to get someone to build the component functionality for you
Title: Re: Which extension to use for bulk wholeasle price update
Post by: MKI-Miro on February 08, 2018, 19:22:47 pm
thats what I asked, if someone can recommend such extension :)
Title: Re: Which extension to use for bulk wholeasle price update
Post by: AH on February 08, 2018, 19:28:19 pm
Apologies

Maybe this
https://csvimproved.com/extension (https://csvimproved.com/extension)
Title: Re: Which extension to use for bulk wholeasle price update
Post by: Studio 42 on February 08, 2018, 21:42:04 pm
@Ah, i know and used myself CSVI many times, but you really mean that a casual user can use csvi without some knowledge?
Title: Re: Which extension to use for bulk wholeasle price update
Post by: AH on February 09, 2018, 16:01:12 pm
Quote
virtuemart-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