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.

ftp icon
Fetch CSV File
Loop
Shopify logo icon
Update Product Variant

You're in good company

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

How it works

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

ftp icon

Fetch CSV File

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.

Loop

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.

Shopify logo icon

Update Product Variant

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 set this up? It only takes 4 minutes.

Our support team will even help you personalize this workflow for free.

Get started →

Make it 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.

Common questions

What happens if my CSV has the wrong column names?

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

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

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

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

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