VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: creatifpresence on September 23, 2016, 15:41:31 PM

Title: Best Bulk Prices Method Quantity
Post by: creatifpresence on September 23, 2016, 15:41:31 PM
Hello, I'm relatively new to vm, but completely new to bulk pricing. Looking for advice on the best method to set prices per quantity ordered. Looked into shopper groups but realised that's per type of group not quantity based, if I've understood correctly.

Need to set prices per product for 1,
2-7,
8-25,
26-49,
50+

Have CSVI Pro available to me and would like to create a csv with fields for this, but just don't know where to begin to start the process. Would someone be kind enough to suggest a tutorial or link to a tutorial. I would have asked in CSVI forum but thought it best for me to understand how vm does this before clarifying what fields would be used.

I found the following extensions which appear to do this but am not sure how this would play with any csv bulk pricing. I don't think it would.

http://extensions.joomla.org/extensions/extension/extension-specific/virtuemart-extensions/jms-quantity-related-price-for-virtuemart
http://extensions.joomla.org/extensions/extension/extension-specific/virtuemart-extensions/quantity-based-attributes-for-virtuemart

Many thanks for any advice your time is appreciated and valued.

Title: Re: Best Bulk Prices Method Quantity
Post by: GJC Web Design on September 23, 2016, 22:27:18 PM
look at the table #__virtuemart_product_prices

in each row of price to product id there are two fields

price_quantity_start
price_quantity_end

so the entry for your 2nd example would be

price_quantity_start = 2
price_quantity_end = 7

You need to set up csvi to do this
Title: Re: Best Bulk Prices Method Quantity
Post by: creatifpresence on September 26, 2016, 18:41:42 PM
Sorry, bear with me I'm not sure I understand.

Are you saying I setup a csv with 2 fields or columns titled "price_quantity_start" & "price_quantity_end".  For each product I then put the prices in? so eg 5 prices in this example for each product.

How is this then mapped to virtuemart and output? Do I need to add custom fields? price_quantity_start & price_quantity_end?

I have never done this before so am trying to grasp the concept.

Thank you
Title: Re: Best Bulk Prices Method Quantity
Post by: GJC Web Design on September 26, 2016, 18:47:06 PM
this is standard VM pricing  .. no customs needed

set up a product with quantity pricing in the admin then study the  table #__virtuemart_product_prices

will be obvious