How to set up prices in Shopify

You can update product prices in Shopify in two ways: using a CSV file or through Shopify’s built-in bulk editor.

Important: Do not change the Variant SKU when editing your products via CSV or bulk editor. The Airalo App relies on the SKU to correctly match and manage your products.

Option 1: Update Prices via CSV (Excel)

Go to your Shopify admin panel.

Navigate to Products.

Click Export (top right).

Choose All products, select CSV, and click Export products. Shopify will email you a download link when the file is ready.

Open the CSV file received via email in Excel.

Locate the following columns:

Title

Variant Price: Set your desired selling price.

Cost per item or Net price (product.metafields.airalo_esim_attributes.net_price): This is the net price in USD provided by the Airalo app.

Save the updated file.

Back in Shopify, click Import (also in the Products section).

Upload your edited CSV file and confirm the changes.

Option 2: Update Prices with Shopify’s Bulk Editor

In your Shopify admin panel, go to Products.

Check the box next to the top product to select all items on the page.

Click Select all products in your store (a banner appears if more exist).

Click Bulk edit (toolbar at the top).

In the bulk editor view, click Columns and add the following:

Price: Set your desired selling price.

Cost per item: The Airalo app sets this with the net USD price.

Sales channels: Add Online Store, Shop, or other channels. Screenshot 2025-04-11 at 13.21.30.png

Set prices and channel visibility as needed.

Click Save (top right) when you're done.

Option 1: Update Prices via CSV (Excel)#

Option 2: Update Prices with Shopify’s Bulk Editor#

Option 1: Update Prices via CSV (Excel)

Option 2: Update Prices with Shopify’s Bulk Editor