How it works

Follow these 3 simple 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.

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.

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.
What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Are templates free?
Yes! Our entire library containing hundreds of templates are free to use and customize to your exact needs.

Related templates you'll love

Recommended workflows that pair well with this template

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

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Start with this template — It's free
7-day free trial • 4 min setup • Cancel anytime