Update Shopify Product Prices from CSV File On Your FTP Server

4 min setup

No coding required

Runs automatically

Streamline pricing management for large inventories with automated updates from a CSV file on an FTP server. This MESA workflow template pulls pricing data on a set schedule, ensuring Shopify product prices stay accurate and current without manual intervention. Perfect for businesses with frequent price adjustments, this automation saves time, reduces errors, and keeps your store’s pricing reliable.

How it works

Fetch CSV File

App connector: [FTP](/content/apps/ftp/integrate "View FTP integration page"/index.html)• Time to complete: 2 minutes

Why this matters: This trigger monitors your FTP server for CSV files containing updated product pricing data and kicks off the entire workflow when new files are detected.

You'll configure the file path on your FTP server where MESA should look for price update files. Enter the exact filename or use wildcards to match multiple files (like "product-prices-*.csv"). The CSV must include columns for Product ID, Variant ID, and Variant Price - these are required for the workflow to function. MESA checks your FTP server hourly by default and processes any matching CSV files it finds.

Loop

App connector: [Loop](/content/apps/loop/integrate "View Loop integration page"/index.html)• Time to complete: 0 minutes (Auto-configured)

Why this matters: This step processes each row in your CSV file individually, ensuring every product price gets updated even if your file contains hundreds of products.

The loop automatically iterates through each row of data from your CSV file. It takes the Product ID, Variant ID, and Variant Price from each row and makes them available for the next step. Without this loop, only the first row of your CSV would be processed, leaving the rest of your price updates incomplete.

Update Product Variant

App connector: [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html)• Time to complete: 0 minutes (Auto-configured)

Why this matters: This action applies the new price from your CSV to the corresponding product variant in your Shopify store, completing the price update process.

For each row processed by the loop, this step finds the specific product variant in Shopify using the Variant ID from your CSV and updates its price with the new value. The step handles the Shopify API connection and ensures each price change is properly saved to your store. If a Variant ID doesn't exist in your store, that particular update will be skipped while others continue processing.

Frequently asked questions

What happens if my CSV has the wrong column names?

The workflow requires exact column names: "Product ID", "Variant ID", and "Variant Price". If your CSV uses different headers like "SKU" or "Price", the workflow won't be able to map the data correctly and updates will fail. Check your CSV headers before uploading.

Can I update prices for products that don't exist in my store yet?

No, the workflow only updates existing product variants. If a Variant ID in your CSV doesn't match any variant in your Shopify store, that row will be skipped. Make sure all variants exist in Shopify before including them in your price update file.

Will partial CSV files cause problems if my FTP upload is interrupted?

Yes, if MESA processes an incomplete CSV file, it will only update the products it can read from the partial file. To avoid this, consider uploading your CSV with a temporary filename first, then renaming it to the target filename once the upload is complete.

Make this template your own!

Customize this workflow even further:

• Add conditional price rules
• Include inventory updates
• Send confirmation notifications
• Archive processed files

You're in good company

Avg. App Store rating 4.9/5

Merchant reviews 157

Avg. time saved per week 3.5 hrs

MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful.

PetFriendly

It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed.

Zailys

The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!

Ready to update your product prices from CSV files on your FTP server?

Get setup in 4 minutes.