Import Supplier Product Feeds Into Shopify From FTP
Suppliers and distributors often share their catalog as a CSV on an FTP server, and copying new items, prices and stock into Shopify by hand falls behind fast. This workflow reads each row of the supplier's CSV, creates a draft Shopify product for any SKU you don't carry yet, and updates price and inventory for the SKUs you already sell.
How it works
6 steps to keep Shopify in step with your supplier's product feed
FTP Fetch CSV File Row Created (Trigger)
FTP Fetch CSV File Row Created (Trigger)
Shopify Retrieve Product Variant Details from SKU
Shopify Retrieve Product Variant Details from SKU
Logic
Logic
Shopify Create Product
Shopify Create Product
Shopify Update Product Variant
Shopify Update Product Variant
Shopify Set Inventory Level By Variant
Shopify Set Inventory Level By Variant
Ready to keep Shopify in step with your supplier's product feed
Get setup in 6 minutes.
FAQs
Will new products go live right away?
No. New products are created as drafts, so you can add images, check the copy and publish them when they're ready.
What if the supplier replaces the whole file each day?
Point the trigger at the file pattern the supplier uses. The workflow matches rows by SKU, so a row for a product you already carry updates it rather than creating a duplicate.
Can I mark up the supplier's cost?
Yes. Add a transform step that multiplies the cost column by your markup before the price is set.
Personalize this template
Customize this workflow even further:
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."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
keep Shopify in step with your supplier's product feed
6 min setup • Fully supported if you need help