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.

Set this up in 4 minutes →

Fetch CSV File

Loop

Update Product Variant

Trusted by 1,000+ Shopify merchants — from solo operators to scaling brands.

How it works

3 steps to update your product prices from CSV files on your FTP server

App connector: FTP • 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.

App connector: Loop • 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.

App connector: Shopify • 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.

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

Get setup in 4 minutes.

Try this template →

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

Set up filters to only update prices that meet certain criteria, like increasing prices by more than 10% or updating specific product categories.

Include inventory updates

Extend the workflow to also update stock levels by adding inventory quantity columns to your CSV and connecting to Shopify's inventory endpoints.

Send confirmation notifications

Add email or Slack notifications after each batch of price updates completes, including a summary of how many products were successfully updated.

Archive processed files

Move completed CSV files to a "processed" folder on your FTP server to keep your file structure organized and prevent duplicate processing.

"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!"

Rothy's

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

7-day free trial • 4 min setup • Cancel anytime

Start with this template — It's free

Need help? Our automation experts will help you personalize this workflow for free. Contact support