Solved

How to create a custom product with dynamic pricing

roman_10
Visitor
2 0 0

Hi Shopify Experts,

I'd like to sell a custom sized and priced product (blinds and curtains), which has it's width and height defined by the customer and has its price informed by a pricing table/matrix.

The pricing matrix has well over 100 price tiers for each product.

I use a custom front-end and a secure middleware server that connects to the Shopify Storefront and Admin API's. 

Possible solutions:

Question 1. Is it possible to store a pricing matrix ( basically a spreadsheet of prices) anywhere on the Shopify platform? 

Question 2. Alternatively, is it possible to dynamically calculate the price the product on my own middleware server and pass this into the Shopifys Storefront API ?

Thanks for helping if you can!

Accepted Solution (1)
Verdant-Spark
Shopify Partner
99 8 32

This is an accepted solution.

Alas, no. None of the APIs available have PUT events for Products, so nothing can be updated 'on the fly'. This was also be a Bad Idea, as it would do 2 things:

1) Change the Product price (for everyone), and
2) Would be open to abuse

You can't edit prices in the cart, as it's the product (actually the variant) which is passed around and goes from the cart to checkout. Prices, subtotals, discounts, and totals are all calculated server-side.

 

View solution in original post

Replies 9 (9)

Verdant-Spark
Shopify Partner
99 8 32

Short answer - no, there's no way to dynamically alter a product's price. The cleanest workaround would be that you can allow users to calculate what a price would be on your frontend, and they can pay a deposit for the product and you then invoice them for the final price less the deposit paid.

roman_10
Visitor
2 0 0

Thanks for your reply 🙂 

Do you know whether a custom integrated Shopify app could have the ability / power to dynamically alter a products price based on the users input?

 

Verdant-Spark
Shopify Partner
99 8 32

This is an accepted solution.

Alas, no. None of the APIs available have PUT events for Products, so nothing can be updated 'on the fly'. This was also be a Bad Idea, as it would do 2 things:

1) Change the Product price (for everyone), and
2) Would be open to abuse

You can't edit prices in the cart, as it's the product (actually the variant) which is passed around and goes from the cart to checkout. Prices, subtotals, discounts, and totals are all calculated server-side.

 

Monstar
Visitor
2 0 1

Hi there,

The price wouldn't be changed in the cart but on PDP for that particular user only. 

The scenario is the following: there is a "from price" showing on the PDP, this price is shown to everyone.

As the product is made to measure price varies based on the measurement you enter. (Price is calculated using a pricing grid.) Customer enters measurement on the PDP and there is a price calculator widget that shows what the exact price will be for the made to measure product. Customer adds item to basket, and checks out. Item in basket and checkout shows the exact price for that product not the "from price".

Is there a way Shopify can support this scenario?

Thank you

 

Verdant-Spark
Shopify Partner
99 8 32

Nope - as already described above.

jaxter
Shopify Partner
27 1 9

I think your problem is: "The pricing matrix has well over 100 price tiers for each product."

If you could get it down to 100, then you could set up your pricing matrix as 100 variants of the product, and when the user enters the custom dimensions, you select the appropriate variant in the background to pick up the correct price point.

However, if you have too many price points you are limited by the 100 variants limit per product.

Monstar
Visitor
2 0 1

Hi Jaxter,

 

Thanks so much for you advice. This is exactly what we will be doing simplifying our pricing matrix to fit into the max  100 variant limit on Shopify.

Thanks,

 

bryanb1
Visitor
2 0 0

I believe you can use the API to create new VARIANTS of products to accomodate dynamic prices like you're describing. I've noticed the Shopify app for Route.com does exactly that.

sagarkohli
Shopify Partner
14 0 4

Hi

You can allow products with custom prices based on inputs, selections, rate sheets using the Custom Price calculator app https://apps.shopify.com/custom-price-calculator.

The app allows you to create a calculator based on a formula and you can add it to your products. For your use case, you can use `DataLookup` element from the app store.

The app also has a bunch of pre-made templates that is pretty useful to get started.
Hope you and others find this useful

sagarkohli_0-1682287818645.png

 

https://apps.shopify.com/custom-price-calculator