Seeking Guidance: Implementing Variable Product Pricing Based on Company Tiers

Need help Database
1

Hello fellow forum members,

I hope this message finds you all well. I’m currently working on a project and could really use some expert advice and insights. I am in the process of developing an e-commerce platform where products need to display different prices based on the user’s associated company and their respective price tier (1, 2, or 3). Additionally, some companies have custom prices for specific products, adding an extra layer of complexity to the pricing structure.

Here’s a bit more detail about my situation:

  1. Price Tiers: Each user belongs to a company, and each company is assigned a price tier (1, 2, or 3). Different price tiers have predefined discounts, affecting the product prices accordingly.

  2. Custom Prices: Some companies require custom pricing for certain products, regardless of their designated tier. This means that for specific products, a company’s custom price should override the default tier-based price.

Considering these requirements, I’m wondering how I can effectively implement this pricing structure within my e-commerce platform. I’ve pondered a few approaches:

Thank you in advance for taking the time to read my post. Your expertise would be immensely valuable in helping me navigate this challenge and design a robust solution.

Best regards,
Jayden

2

There are probably better ways to go about this but off the top of my head, you could probably do this:

Assign / create a certain discount percentage for each tier e.g.

tier 1: 5% (change them to decimal = 0.05)
tier 2: 10% (change them to decimal = 0.10)
tier 3: 20% (change them to decimal = 0.20)

Assuming there is a product page, you’d have to create a workflow to automatically change the product’s price based on the user’s tier

Example: The product’s original price is $100 but since this user is tier 3, you’d have to change the price to $80 ($100 x 0.20)

For this, you could probably have a boolean state where if product has custom price, you won’t add a discount and change the product’s price based on the custom price

Hope this helps!

Best,
Nino