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.
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!
Solved! Go to the solution
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.
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.
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?
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.