Goal: Import and export unit prices for your Shopify product variants to comply with EU pricing regulations and display accurate per-unit pricing to customers.
Video walkthrough: Watch the 2-minute video
Prerequisites:
You have Altera installed on your Shopify store
Products already created in your Shopify store
Step 1 - Export Your Products with Unit Price Fields
In Altera, click New Export and select Products as the data type.
In the field selection, select the Unit price field group to include unit price fields. You may also want to include the General group to have product identifiers like ID and Handle. Click Start Export and download the file when ready.
Step 2 - Open and Review Your Spreadsheet
Open the exported file in your spreadsheet application. You will see columns including:
ID and Handle (to identify the product)
Variant ID and Variant SKU (to identify the variant)
Unit Price Total Measure (the quantity value, e.g.,
100)Unit Price Total Measure Unit (the unit, e.g.,
G)Unit Price Base Measure (the reference value, e.g.,
1)Unit Price Base Measure Unit (the reference unit, e.g.,
KG)
Step 3 - Update Unit Price Values
Edit the unit price values in your spreadsheet. For example, to set a product as 2 kg per unit priced per 1 kg:
Set Unit Price Total Measure to
2Set Unit Price Total Measure Unit to
KGSet Unit Price Base Measure to
1Set Unit Price Base Measure Unit to
KG
Valid units include: CL, CM, FLOZ, FT, FT2, G, GAL, IN, ITEM, KG, L, LB, M, M2, M3, MG, ML, MM, OZ, PT, QT, YD
Step 4 - Import the Updated File
Return to Altera and click Upload file on the home page. Select your modified spreadsheet.
The app will analyze the file and show which fields will be updated. Review the preview and click Start import to apply your changes.
Step 5 - Verify the Changes
After the import completes, click the product link in the results to open it directly in Shopify admin. Navigate to the variant and scroll to the Unit price section to confirm your changes were applied.
Outcome
Your product variants now display the updated unit pricing information. Customers will see the per-unit price calculation on product pages, helping them compare prices across different package sizes.
Removing Unit Prices
To remove unit pricing from a product, set either value to 0 in your spreadsheet:
Set Unit Price Total Measure to
0, orSet Unit Price Base Measure to
0
Import the file and the unit pricing will be cleared from the variant.
Example
ID | Variant SKU | Unit Price Total Measure | Unit Price Total Measure Unit | Unit Price Base Measure | Unit Price Base Measure Unit |
123456 | COFFEE-500G | 500 | G | 1 | KG |
789012 | JUICE-1L | 1 | L | 1 | L |
456789 | FABRIC-2M | 2 | M | 1 | M |