Author Topic: Which extension to use for bulk wholeasle price update  (Read 505 times)

MKI-Miro

  • Jr. Member
  • **
  • Posts: 145
Which extension to use for bulk wholeasle price update
« 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

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3241
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Which extension to use for bulk wholeasle price update
« Reply #1 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.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2768
  • VirtueMart Version: 3.2.15
Re: Which extension to use for bulk wholeasle price update
« Reply #2 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)
regards
A

Joomla 3.8.8
php 7.0

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3241
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Which extension to use for bulk wholeasle price update
« Reply #3 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.

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2768
  • VirtueMart Version: 3.2.15
Re: Which extension to use for bulk wholeasle price update
« Reply #4 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
regards
A

Joomla 3.8.8
php 7.0

MKI-Miro

  • Jr. Member
  • **
  • Posts: 145
Re: Which extension to use for bulk wholeasle price update
« Reply #5 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

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2768
  • VirtueMart Version: 3.2.15
Re: Which extension to use for bulk wholeasle price update
« Reply #6 on: February 08, 2018, 19:08:52 pm »
Then maybe you need to get someone to build the component functionality for you
regards
A

Joomla 3.8.8
php 7.0

MKI-Miro

  • Jr. Member
  • **
  • Posts: 145
Re: Which extension to use for bulk wholeasle price update
« Reply #7 on: February 08, 2018, 19:22:47 pm »
thats what I asked, if someone can recommend such extension :)

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2768
  • VirtueMart Version: 3.2.15
Re: Which extension to use for bulk wholeasle price update
« Reply #8 on: February 08, 2018, 19:28:19 pm »
regards
A

Joomla 3.8.8
php 7.0

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3241
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Which extension to use for bulk wholeasle price update
« Reply #9 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?

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2768
  • VirtueMart Version: 3.2.15
Re: Which extension to use for bulk wholeasle price update
« Reply #10 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
regards
A

Joomla 3.8.8
php 7.0