Calculation method and SKU generating

Shopify Discussion
, ,

Topic summary

Seeking a Shopify app (preferably free) that can compute complex pricing and generate SKUs while hiding internal values from customers. SKU = stock-keeping unit.

Requirements:

  • Pricing model: Product > Subproduct (base price in €) > Variation (multiplier or %) > Add-ons (fixed €) > Quantity discounts (e.g., 10 pcs = 5%, 20 pcs = 7%).
  • Scale: ~20 defined Subproducts; ~50 Variations grouped into 10 price-factor ranges; variation values must not be visible to customers.
  • SKU format required: Prod_Variat_Subprod_Add1_Add2_Quant.

Illustrative examples:

  • Subproduct 10 base 5.00 € → Variation factor 0.4 = 2.00 €, 0.8 = 4.00 €, 1.0 = 5.00 €; Subproduct 12 identical pricing to Subproduct 10.
  • Subproduct 14 base 8.00 € → Variation factor 0.2 = 1.60 €, 0.6 = 4.80 €, 1.0 = 8.00 €.

Status and outcomes:

  • No app recommendations or solutions provided yet; the poster followed up requesting help.
  • Discussion remains open and unresolved; key question is which specific app can implement this calculation and SKU-generation workflow.
Summarized with AI on January 30. AI used: gpt-5.
1

Hello,

we have a large number of calculations in our SKU product.

Definition of functions and price creation:

  • Product (SKU)

  • Subproduct (start price in €)

  • Variation (corrector as multiplication factor or %)

  • Add-ons (fixed in €)

  • Quantity as Discount (at 10 pcs 5%, at 20 pcs 7% etc.)

We want to generate a final price of about 20 certain Subproducts depending on about 50 specific Variations (Variations are ranked into 10 price ranges with a simple multiplication factor).

Example:

Subproduct 10 have a start price 5,00 €, in next step buyer select in dropdown menu certain …

Variation C or D or any other from 0,4 factor price range = 2,00 € (end price of SKU)

or Variation G or H or any other from 0,8 factor price range = 4,00 € (end price of SKU)

or Variation I or J or any other from 1,0 factor price range = 5,00 € (end price of SKU)

etc.
Subproduct 12 have identical price to Subproduct 10 .

Subproduct 14 have a start price 8,00 €, in next step buyer select in dropdown menu certain …

Variation A or B or any other from 0,2 factor price range = 1,60 € (end price of SKU)

or Variation E or F or any other from 0,6 factor price range = 4,80 € (end price of SKU)

or Variation I or J or any other from 1,0 factor price range = 8,00 € (end price of SKU)

etc.

etc. for Subproducts 16, 20, 30, 32, 40, 50, 60, 70, 80.

Value of the Variations should not be visible to the customer.
Exactly which app (preferably “Free”) is capable of processing this calculation method and SKU generating like this: Prod_Variat_Subprod_Add1_Add2_Quant ?

Thank you very much for your help.

2

anyone, please?