Sell same product of different sizes and each of different price

Shopify Discussion

Topic summary

A merchant needs to sell custom-sized products with prices calculated by a formula from their spreadsheet. They initially encountered Shopify’s 100-variant limit per product, which seemed restrictive for their needs.

Suggested Solutions:

  • Third-party apps like Infinite Options, Dynamic Product Options, or Bold Product Options can bypass the variant limit by creating custom fields where customers input dimensions and prices adjust dynamically
  • Line item properties allow size input while keeping products simple
  • Custom scripts (Shopify Plus) or custom apps can automate complex pricing formulas

Resolution:
The merchant simplified their approach by setting uniform pricing across all sizes and using variants to display size options as a matrix. After reviewing their product catalog, they confirmed staying within the 100-variant limit per product, making the native Shopify variant system sufficient without requiring additional apps.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
1

I plan to sell products that are on my store. These products are manufactured in custom sizes, that are sold based on their size.

I have a spreadsheet with the list of all the products, their sizes. Based on their size I need to set the price, I have a formula in excel based on which the sale price is automatically calculated. How do I put this information up on the website.

I have created variants and tried, but seems there is a limitation of 100 variants per product. I don’t see I can do this. Any advise?

2

Hi @ArjunDev ,

There are apps which can help you overcome this limitation, refer Infinite Options, Dynamic Product Options and Bold Product Options

You can search for them in the Shopify apps store at apps.shopify.com

Hope this helps.

3

Since Shopify has a 100-variant limit per product, you can handle custom-size pricing using a third-party app like Infinite Options, Dynamic Product Options, or Bold Product Options. These apps let you create custom fields where customers enter dimensions, and the price adjusts dynamically based on your formula. Another option is using Shopify’s line item properties, which allow customers to input size details while keeping the product simple. If your pricing formula is complex, a Shopify custom script (Shopify Plus) or a custom app could automate the calculation.

4

Thanks Richard. I think I can modify my approach to simplify this. I can fix the pricing for all the products with different sizes to the same rate. I guess I just need to show the customers what size of the product they are choosing like a matrix when they choose the product variant. Can it be done?

5

Hi @ArjunDev

Please find the steps below:

How to Set Up a Size Matrix Using Variants1. Go to Shopify Admin > Products.

  1. Select a Product you want to apply this to.
  2. Scroll to Variants and click Add Variant.
  3. In the Option Name, enter “Size”.
  4. Add sizes as Options (e.g., Small, Medium, Large, XL, etc.).
  5. Keep the same price for all variants.
  6. Click Save.

Another approach can be to use an app:

Use a Shopify App (Easiest)

Apps like Variant Option Product Options in the Shopify apps store:

  • Display size options as a table/matrix.
  • Customize how options are selected (buttons instead of dropdowns).
  • Make the UI more user-friendly and visually appealing

You can use one of the 2 solutions, please like and accept as a solution if it worked for you.

6

I like the size option very much. Appreciate the timely response. Let me
work on it and get back to you.

7

I checked again in detail. When I segregate the products based on sizes, I don’t think I am going beyond 100 variants per product. So I am pretty much using the 100 variant limit and going with this feature.