Help to display a square meter price and pack price on product cards

Store Design
, , , ,

Topic summary

Shopify flooring store needs to show both price per square meter and total box price on product cards. Products are sold only in full packs with varying coverage (e.g., 5 sqm, 2.44 sqm, 3.25 sqm), so the selling price equals box size × sqm price (example: £13.79/sqm, 5 sqm box = £68.95 per box).

Current setup: sqm price is manually written in each product description, which is time‑consuming to update across the catalog.

Requests:

  • Display the sqm price on collection product cards and within the product page card alongside the pack price.
  • Enable updating only the sqm price via spreadsheet/CSV (currently not present) and automatically calculate the box price based on box size.
  • Prefer a scalable method (e.g., fields/metafields) that avoids manual per‑product edits.

No solutions or code provided yet; the thread seeks guidance on theme customization and data structure (metafields/CSV import) to automate calculations and display. Status: open with unanswered implementation details.

Summarized with AI on January 6. AI used: gpt-5.
1

Hi,

I have set up a shopify store selling flooring products (carpet tiles, vinyl tiles, sheet vinyls etc).

As flooring products are generally priced by the square meter I am wanting to display this information on the product cards. However, the square meter price is not the selling price of the items as they are sold in full packs of varying quantity’s (e.g.. 5sqm, 2.44sqm, 3.25sqm) so the selling price is the price of a full box.

Example:

The square meter price of some carpet tiles is £13.79sqm with a box size of 5sqm bringing the total price to £68.95 per box.

I have added the square meter price to each individual product card within the description but this was a very laborious task and now I am needing to change the prices I will need to go through each product individually to change the information.

Is there a way I can add the square meter price to the product card within the collection and also have it displayed withing the product card itself?

Is it also possible to amend just the square meter price through the spreadsheet (currently not on the spreadsheet) which would automatically change the box price depending on the box size?

I hope all the above makes sense and any help with this would be greatly received.

Many thanks