magento2 – Magento 2: None of the discount code is working

I’m tried of sorting out the discount code issue in our magento 2 website (Magento 2.4.1) .
Below is my rule description. I have tried with auto generation as well as manual code. None of them are working.

None of the coupons in our website is working as well.

I always get The Coupon Code get20off is not valid . If you look at the code all I have is one condition based on shipping method. My coupon code is not working in cart/checkout page.

I was trying for a very long time and not sure what I’m missing. If someone can go through the rule and let me know what’s missing or what to do, that will be really helpful.

I also checked in database and everything looks good. It will be great if you can guide me how to troubleshoot this scenario.

enter image description here

linear programming – Minimize total cost of shopping cart with discount rules

Here is the problem I am trying to solve, given 2 items to purchase from 2 stores with a discount for Store 1, what is the cheapest way to purchase the items?

Discount for Store 1, 50% off with minimum spend of $15 capped at $6.

Item 1 Store 1 = $5
Item 1 Store 2 = $10
Item 2 Store 1 = $10
Item 2 Store 2 = $5

The obvious answer would be to purchase both items from Store 1, at a cost of $10 + $5 - $6 = $9

Here is my formulation, which I got stuck when the discount amount is less than $6 not calculating correctly.

Item 1 Store 1 = x1 = $5
Item 1 Store 2 = x2 = $10
Item 2 Store 1 = x3 = $10
Item 2 Store 2 = x4 = $5
Min Spend Discount Binary = x6
Max Spend Discount Binary = x7

Minimize
 obj: 5 x1 + 10 x2 + 10 x3 + 5 x4 - 6 x6 
+ ( - 5 x1*x5 + 5 x1*x6 - 10 x3*x5 + 10 x3*x6 ) / 2 # apply discount and compensate amount if exceeds capped discount

Subject To
 c1: x1 + x2 = 1 // need to purchase item 1 from either store
 c2: x3 + x4 = 1 // need to purchase item 2 from either store
 c3: 5 x1 + 10 x3 - 12 x5 >= 0 // min spend for item 1 and item 2 from store 1 needs to exceed $12
 c4: x5 - x6 = 0 // this is the part that I got stuck, this works when the total cost exceeds the discount cap but doesn't work when it's below the cap

Bounds
 0 <= x1 <= 1
 0 <= x2 <= 1
 0 <= x3 <= 1
 0 <= x4 <= 1
 0 <= x5 <= 1
 0 <= x6 <= 1

Binaries
 x1 x2 x3 x4 x5 x6
End 

I’m sure I’m missing something with the fourth constraint (c4), any ideas on how this problem should be formulated?

25% Discount – High-end Managed Cloud VPS | SSD | cPanel | Softaculous | 99.9% Uptime – VernalWeb | NewProxyLists

VernalWeb is offering 25% discount on the first invoice (Up to 12 months) for all Managed VPS Hosting plans. For a limited time only, new customers can receive 25% DISCOUNT on any of our Managed SSD Cloud VPS hosting plans.

Coupon Code: FlyHigh

Apply coupon code during checkout.

Included with all Managed VPS hosting accounts:
* WHM Control Panel
* cPanel Control Panel
* Softaculous Script Auto-installer (300+ one-click install scripts!)
* SNI Supported
* KVM Virtualization
* High-Redundancy RAID 10 Arrays
* WordPress Optimized
* Developer Friendly Atmosphere
* E-commerce Ready!
* Secure IMAP & POP3
* Apache Handlers
* Fully Managed Service
* FREE Website Migrations (We will migrate your current website, free of charge!)

Data Center Locations:

  • New York, United States
  • London, United Kingdom
  • Toronto, Canada
  • Singapore, SG
  • Amsterdam, Netherlands
  • Bangalore, India

Blazing Fast Server Hardware, Premium Bandwidth:
We SPARE NO EXPENSE for our offer! Our newest managed virtual servers are purpose-built for performance using enterprise components, including RAID-10 SSDs for all storage.

Fully Managed VPS Plans

Minimal Plan
4 GB RAM
2 CPU Cores
80 GB SSD Storage
4 TB Data Transfer
1 IP Address
cPanel/WHM Control Panel
Softaculous Script Installer
Fully Managed Service

Order Now!

Monster Plan
8 GB RAM
4 CPU Cores
160 GB SSD Storage
5 TB Data Transfer
1 IP Address
cPanel/WHM Control Panel
Softaculous Script Installer
Fully Managed Service

Order Now!

Extreme Plan
16 GB RAM
6 CPU Cores
320 GB SSD Storage
6 TB Data Transfer
1 IP Address
cPanel/WHM Control Panel
Softaculous Script Installer
Fully Managed Service

Order Now!

If you need any further information or help please feel free to contact us at Help Desk

Get in touch with us:
Facebook | Twitter | Pinterest | LinkedIn

 

ProximCloud: Exclusive Discount on London Shared Hosting! (from $1.13/mo!)

Ben from ProximCloud stopped by to kick off 2021 with some nice shared hosting offers from England!

  • Use promo code LEB2021NY for 25% off package!

ProximCloud is coming up on three years in business and is doing very well.  We’ve had them on for Christmas, for Thanksgiving, and back in September.  Their first post here was in April 2020 so they’ve been with us for a while, with good reviews.

They host out of London, so if you’re looking for UK shared hosting, check them out.  Even if you’re not in the UK, shared hosting works from a lot longer range because visitors aren’t expecting same snappy response. If you think of the entire web experience (click on a link, request transmits to host, host processes, host sends response, browser parses, etc.) a few hundreds milliseconds added to a 2-4 second experience is insignificant.

ProximCloud features cPanel on pure SSD, 24×7 support, and the usual trimmings – including 20Gbpx of DDoS protection.  They’ve accumulated many positive reviews on TrustPilot.  Here’s a little more about them in their own words:

“ProximCloud is a small website hosting business, which has been in operation for over two years (since 28th Feb 2018), which has striven based on the reliability and low-cost factors of our services. ProximCloud always puts the customer first, and has ensured to provide our customers with many support-methods to ensure they can reach us when they need it, and when it suits them.”

Their WHOIS is public.  Please review their TOS before signing up.  They accept PayPal.  If you decide to give them a go, please before to comment below and let us know how it goes!

Now read more to see the offers!

LowEndBox
Essential Package
London, UK

  • 25GB SSD Storage
  • 250GB Monthly Bandwidth
  • Unlimited FTP Accounts
  • Unlimited Email Accounts
  • Unlimited MySQL Databases
  • Unlimited Subdomains
  • 10 Addon Domains
  • Automatic Daily Backups
  • FREE SSL Certificate
  • SSH Access
  • $1.50/month normally…
  • But take 25% off with code 
    LEB2021NY!
  • $1.13/month
  • (ORDER)

LowEndBox
Deluxe Package
London, UK

  • 50GB SSD Storage
  • Unmetered Monthly Bandwidth
  • Unlimited FTP Accounts
  • Unlimited Email Accounts
  • Unlimited MySQL Databases
  • Unlimited Subdomains
  • Unlimited Addon Domains
  • Automatic Daily Backups
  • FREE SSL Certificate
  • SSH Access
  • $2.99/month
  • But take 25% off with code 
    LEB2021NY!
  • $2.25/month
  • (ORDER)

HOST NODE SPECIFICATIONS

Please let us know if you have any questions/comments and enjoy!

raindog308

I’m Andrew, techno polymath and long-time LowEndTalk community Moderator. My technical interests include all things Unix, perl, python, shell scripting, and relational database systems. I enjoy writing technical articles here on LowEndBox to help people get more out of their VPSes.

budget – Getting a YHA discount on Greyhound Australia’s website?

To get the discount, as Drat (above) said, you just show them the card at boarding. However, it’s pretty common for places like Greyhound to not check the discount despite them saying that they will check at concession.

Specifically for the ISIC discount…(From http://maphappy.org/2014/12/the-hard-real-truth-about-isic-card-benefits/)

I bought five separate STA tickets over the course of 2010 to 2012 without an ISIC card. I only got asked for the card maybe once, from Air Canada, I believe it was. My response? I pretended I forgot it at home and asked if I could show my student card instead. The check-in agent waved me through.

Hopefully this helped! 🙂

Vitamin C Powder (ascorbic Acid) Available For Sell At 10% Discount!

Are you looking to buy Vitamin C Powder (Ascorbic Acid)? Then visit https://www.blackburndistributions.com/vita…orbic-acid.html to purchase with 10% discount available via using the code “VITC-10-OFF”

Reasons to purchase from Blackburn Distribution:

1. Our Vitamin C is sourced from the EU and passes through multiple quality control processes ensuring that our ascorbic acid is of the highest quality meeting pharmaceutical standards

2. Shipped within 1 working day subject to stock

3. 10% discount available

https://www.blackburndistributions.com/vita…orbic-acid.html

SSD VPS – 30% Recurring Discount (US – Los Angeles) Additional IPs 1$/mo – Paypal, CC, Bitcoins | NewProxyLists

Host Mayo offers SSD KVM VPS with advance features like instant upgrades, DDOS protection, Gigabit Uplink and 24/7 Support. We have been in business since 2015. Over the span of last few years we have expanded our products range to cover simple web hosting to enterprise level VPS & dedicated servers. We offer exceptional customer support and guarantee 99% uptime. Today we bring exclusive vps plans with 30$ recurring discount using coupon “coco”.

☁ 1GM RAM VPS – 5$/mo or 60$/year 3.5$/mo or 42$/year

  • 20 GB SSD Disk Space
  • 1 TB Bandwidth
  • 1 GB RAM
  • 512MB Swap
  • 1 CPU Core
  • 1 IPV4
  • More Info | Order Now

☁ 2GM RAM – 10$/mo or 120$/year 7$/mo or 84$/year

  • 40 GB SSD Disk Space
  • 2 TB Bandwidth
  • 2 GB RAM
  • 1GB Swap
  • 2 CPU Core
  • 1 IPV4
  • More Info | Order Now

☁ 3GM RAM VPS – 15$/mo or 180$/year 10.5$/mo or 126$/year

  • 60 GB SSD Disk Space
  • 3 TB Bandwidth
  • 3 GB RAM
  • 1.5 GB Swap
  • 2 CPU Core
  • 1 IPV4
  • More Info | Order Now

☁ 4GM RAM VPS – 20$/mo or 240$/year 14$/mo or 168$/year

  • 80 GB SSD Disk Space
  • 4 TB Bandwidth
  • 4 GB RAM
  • 2 GB Swap
  • 4 CPU Core
  • 1 IPV4
  • More Info | Order Now

☁ 8GM RAM VPS- 35$/mo or 420$/year 24.5$/mo or 294$/year

  • 100 GB SSD Disk Space
  • 8 TB Bandwidth
  • 8 GB RAM
  • 4 GB Swap
  • 4 CPU Core
  • 1 IPV4
  • More Info | Order Now

Payment Methods
We accept PayPal, Credit Card, BitCoins, LTC, BCH & ETH other cryptocurrencies.

Frequently Asked Questions
1. Is RDNS Supported? Yes
2. Custom ISO Allowed? Yes
3. Unlimited Reboot and Installations? Yes
4. Additional IP Allowed? Yes 1$ per additional ip.

Server Features

  • Intel Xeon CPU
  • All Ports Open
  • DDOS Protected
  • Pure SSD storage
  • KVM Virtualization
  • Test IP NL: 5.253.86.28
  • Test IP USA: 162.223.31.39
  • Unlimited OS reinstall
  • Virtualizor Control Panel
  • VPS Looking Glass: lg.hostmayo.com
  • Additional IPv4 available for 1$ per month
  • Popular Operating System Choices including Centos 8, Ubuntu 20 & Debian 10

Reviews & Awards
Hosting Reviews: https://hostmayo.com/reviews-awards

Connect with US
If you have any questions, please feel free to contact us at admin@hostmayo.com || Skype @hostmayo|| Tweeter @hostmayo|| Facebook HostMayoServers

magento2 – How to allow user to apply a special discount base on quantity , three times

I have created from Cart Price Rules a new Rule.

The rule says: if the user buys 3 of these products ( based on SKU ) will get 5$ off

it’s possible to allow the user if buy these products two times ( 6 products) will get 10$ off, three times (9 products) will get 15$ off with the same rule?

This is my rule

If ANY  of these conditions are TRUE :
If total quantity  is  3  for a subselection of items in cart matching ALL  
of these conditions: 
SKU is one of  10593,10597,10595,PR/...  

Here is the action

enter image description here

$10/year – 50% Recurring Discount – Double SSD Diskspace & Bandwidth – Unlimited Domains – LiteSpeed – cPanel | NewProxyLists

WebHostGlobe.com specialises in providing top-notch web hosting services to customers around the globe. We ensure customers receive a high quality of service and customer satisfaction is maintained. We use the best in-class and latest hardware infrastructure and servers to meet our customers’ hosting needs and requirements. Our engineers have the relevant technical expertise to troubleshoot issues and resolve them promptly to ensure network stability. In a nutshell, we strive to help our customers succeed.

All our hosting plans come loaded with following features:
– Latest cPanel Control Panel
– 24/7 Technical Support
– Money Back Guarantee
– 99.9% Uptime Guarantee
– Softaculous Auto Installer with 100+ apps
– Server Level Protection
– Unlimited Sub-Domains
– Unlimited MySQL Databases
– Unlimited Email Accounts
– Unlimited FTP Accounts
– …and many more!

NewProxyLists Web Hosting Special Offers!

Upsized Packages with Double Diskspace & Bandwidth at 50% OFF Recurring Discounts on the following plans!

HOSTING PLANS
Bronze

Disk Space: 5GB SSD (usual: 1GB)
Premium Bandwidth: 50GB (usual: 10GB)
Host 1 Website
Unlimited Sub-Domains
Unlimited MySQL Databases
Unlimited Email Accounts
Unlimited FTP Accounts
Free cPanel Control Panel
Free Softaculous One-Click Installer
Free Setup & Activation
99.9% Uptime Guarantee
Cloud Hosting Enabled
Free 24/7/365 Technical Support
Money Back Guarantee
Only $20/year
Discounted Price: Now $10/year with coupon code “WJ10”
Order Now

Silver
Disk Space: 10GB SSD (usual: 2GB)
Premium Bandwidth: 100GB (usual: 20GB)
Unlimited Addon Domains
Unlimited Sub-Domains
Unlimited MySQL Databases
Unlimited Email Accounts
Unlimited FTP Accounts
Free cPanel Control Panel
Free Softaculous One-Click Installer
Free Setup & Activation
99.9% Uptime Guarantee
Cloud Hosting Enabled
Free 24/7/365 Technical Support
Money Back Guarantee
Only $30/year
Discounted Price: Now $15/year with coupon code “WJ15”
Order Now

Gold
Disk Space: 15GB SSD (usual: 5GB)
Premium Bandwidth: 150GB (usual: 50GB)
Unlimited Addon Domains
Unlimited Sub-Domains
Unlimited MySQL Databases
Unlimited Email Accounts
Unlimited FTP Accounts
Free cPanel Control Panel
Free Softaculous One-Click Installer
Free Setup & Activation
99.9% Uptime Guarantee
Cloud Hosting Enabled
Free 24/7/365 Technical Support
Money Back Guarantee
Only $40/year
Discounted Price: Now $20/year with coupon code “WJ20”
Order Now

Platinum
Disk Space: 20GB SSD (usual: 10GB)
Premium Bandwidth: 200GB (usual: 100GB)
Unlimited Addon Domains
Unlimited Sub-Domains
Unlimited MySQL Databases
Unlimited Email Accounts
Unlimited FTP Accounts
Free cPanel Control Panel
Free Softaculous One-Click Installer
Free Setup & Activation
99.9% Uptime Guarantee
Cloud Hosting Enabled
Free 24/7/365 Technical Support
Money Back Guarantee
Only $50/year
Discounted Price: Now $25/year with coupon code “WJ25”
Order Now

Need more details? Visit us now at: http://webhostglobe.com/hosting

 

I want to exclude (minus) 7% from a column in a table, like an discount. How can I do that in SQL language? [migrated]

Select Price(Example) from Products and then? I was wondering if I can use something like Price-7% update Price, or something along those lines…