Sell same product of different sizes and each of different price

Shopify Discussion
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.