Post by laurabeth » Tue Mar 27, 2018 6:42 am

Hi, I'm sorry if this is a repeat question - I couldn't find a similar situation in the forums.

I have a product that is priced at $0.75. If a customer purchases 12 of that product, I would like to sell it for $8 total ($0.67 per item). Each additional item after 12 should be $0.75.

Currently, I have a discount set up for the product with the Quantity set to 12 and the Price set to $0.67. However, this applies to 12 or more products (not only the first 12 products) so if a customer buys 13 of the item, they pay $8.67, not $8.75 as I would like.

Any help would be very appreciated! Thank you!

Newbie

Posts

Joined
Sat Aug 26, 2017 3:52 pm

Post by straightlight » Tue Mar 27, 2018 8:35 pm

Hi. As a new forum user, please read the most recent forum rules. No OC version posted.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by Johnathan » Tue Mar 27, 2018 10:33 pm

If you want to use the Discount tab of the product data, you'd need to adjust the cost for every different quantity value, so it calculates the price you want. For example:

12 would be 0.6700 per item
13 would be 0.6731 per item (which is $8.75 / 13)
14 would be 0.6786 per item (which is $9.50 / 14)
etc.

If you don't want to do that, you could use Category & Product-Based Fee/Discount for this, though it would not change the actual product price. It's an Order Total extension, so it would add a line item to the order when the criteria are met. You could then set up a discount of $1.00 off when there are 12-23 items, $2.00 off when there are 24-35 items, etc. Here's what it would look like in the extension:

------------------------------------------------------------------------------
CHARGE #1
Title: 12-Pack Discount
Group: A
Charge Type: Quantity
Charge Field: 12-9999 = -1.00 / 12
------------------------------------------------------------------------------

Feel free to take a look at the screenshots and demo site, and if you're interested let me know at www.getclearthinking.com/contact if you have any further questions.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by laurabeth » Fri May 18, 2018 11:17 pm

Sorry for the late reply, but I just wanted to say thank you to Johnathan for the work-around! That's what I ended up doing.

Newbie

Posts

Joined
Sat Aug 26, 2017 3:52 pm

Post by Johnathan » Sat May 19, 2018 10:03 pm

No problem, glad I could help.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am

Who is online

Users browsing this forum: No registered users and 263 guests