Hi all,
This is a bit complex. We have retail prices on Shopsite. Over 1,000 products. I want to let my wholesalers buy online. Ideally, they would login to their account in my ShopSite store and would get the discount when adding items to cart or by entering a coupon code. Here is the tricky part. The discount will vary based on the cost of the product. For example under $200 would be 80%. A product over 200 up to 400 would be 60% off. (yes the discount is smaller as $ amount increases as the markup is less on more expensive items). Not the discounts are not cumulative they are PER product based on that product price. There are only 4 price brackets so I imagine I could do 4 coupons and assign the products to coupon based on the price. The challenge is the wholesaler has to possibly enter multiple codes. Adds some complexity. I don't really want to create a duplicate store either. Unfortunately, some wholesalers will order multiple items that will require multiple different discounts. Just wondering if there is a better solution.