Jump to content

Volume discount by quantity Module


xpert
 Share

Recommended Posts

we are looking for a Module to set "Volume discount by quantity"

 

I know in CC6,I can go and edit each product and set but problem is we have 330 products and no one in office is willing to edit 1 by 1!

is there a module or method to edit all of them quickly like a mass edit screen?

alternate ,can we give volume discounts by category ?

Link to comment
Share on other sites

Please give this some thought. You will be working with an external utility such as phpMyAdmin. You can also do this in admin, Maintenance, Query Editor, but there is no feedback when working here.

Have a list of the product_id values for the products you want to work with. In the database utility, prepare this statement:

INSERT INTO CubeCart_pricing_quantity (`product_id`, `quantity`, `price`) VALUES
(1, 5, 7.99),
(1,10,6.99),
(1,15,5.99)

This creates three records for product_id of 1. The first number is the product_id -- change that for each product_id that you execute this query. The second number is the quantity breakpoint, and the third is the volume price.

I am not aware of any mod that will offer a discount based on the category.

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...