News:

Support the VirtueMart project and become a member

Main Menu

Best Bulk Prices Method Quantity

Started by creatifpresence, September 23, 2016, 15:41:31 PM

Previous topic - Next topic

creatifpresence

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.


GJC Web Design

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
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

creatifpresence

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

GJC Web Design

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
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