@superduperfly Use Line Item Properties(LIP's), if the "variants"
- do not affect price
- customer selected values are not used for third party integrations(dropshipping,marketplaces,ERP,etc)
Just use LIP's https://help.shopify.com/en/themes/customization/products/features/get-customization-information-for...
Tool https://ui-elements-generator.myshopify.com/pages/line-item-property
There are also plenty of LIP apps that let you apply templates of values to products.
Example code you will need to tailor to your theme, some themes have javascript that may need to be updated as well.
<select required class="required" id="size" name="properties[Size]">
{%- assign sizes = "4,4.25,4.5,4.75,5,5.25,5.5,5.75,6,6.25,6.5,6.75,7,7.25,7.5,7.75,8,8.25,8.5,8.75,9,9.25,9.5,9.75,10" | split:"," -%}
{%- for size in sizes %}
<option value="{{size}}">{{size}}</option>
{%- endfor -%}
</select>
<select required class="required" id="size" name="properties[Color]">
{%- assign sizes = "White Gold,Yellow Gold,Rose Gold" | split:"," -%}
{% for color in colors -%}
<option value="{{color }}">{{color }}</option>
{%- endfor -%}
</select>
The problem is adding variants in the spreadsheet is way too time-consuming and was poorly designed without efficiency in mind if you have hundreds or thousands of products. Why was there no app for this, or an app with this function?
This is workflow problem, there are a million shopify merchants and not everyone has this specific problem, the more common workflows produce this data at the start before shopify is even considered for stuff like data entry or import/export. That said there are loads of bulk product editing apps, especially LIP based apps, but their workflow may not be how you expect it to work with your information architecture.
- Try the shopify bulk editor for your use case
- Create 1 product first with all the unchanging variant values then use that in an export to do the formula work or merging in a spreadsheet for the individual product details but you really need to be comforatable in spreadsheets for that or just use fiverr.
- Alternative process hack, use the liquid templating language itself, or javascript, to generate the CSV values using an unpublished theme to render the information of the products then import that back into to shopify (using code similar to above to insert the values)
Problem Solved? ✔️Accept and ? Like the solution so you can help others.
Buy me a coffee ☕ paypal.me/paulnewton or donate to eff.org
Confused? Busy? Buy a custom solution paull.newton+shopifyforum@gmail.com
