Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to create file url from file name, order ID and product ID from WooCommerce?

A quick question for those of you who are more experienced with Zapier than I am! I am bringing order info into Zapier from WooCommerce, when I do so I end up with a data field that appears as follows:

1. Line Items Meta Data Upload
o_1fh1goor91fnf1a90a421i8g1je79.png, o_1fh1gr7nb1ngug7l13111tic20q9.jpeg

The filenames listed are files that a customer has uploaded during checkout. For some reason, the form I use only passes along the filename and not the full file URL. I need to create the full file URL as a new variable / data field to then use in another step afterwards.

The full URLs of the filenames listed above are as follows:
https://8gd.a71.myftpupload.com/wp-content/uploads/ppom_files/confirmed/5705/3093-o_1fh1goor91fnf1a90a421i8g1je79.png
https://8gd.a71.myftpupload.com/wp-content/uploads/ppom_files/confirmed/5705/2980-o_1fh1gr7nb1ngug7l13111tic20q9.jpeg

The number 5705 in the URL is the order number, and the prefixes 3093- and 2980- are Product ID’s that also get passed along to Zapier. I have a simple formula that allows me to take the Filename, Order ID, and Product IDs and end up with the full URL, which is as follows:

“https://8gd.a71.myftpupload.com/wp-content/uploads/ppom_files/confirmed/”/OrderID]/rProductID]-dFilename]

I know how I would do this for example using PHP, with which I am more experienced:

$fullURL = “https://8gd.a71.myftpupload.com/wp-content/uploads/ppom_files/confirmed/” . $OrderID . “/” . $ProductID . “-” . $Filename;

How can I do this with Zapier??

Well, now I feel stupid for asking, as talking it through in my head while making the post helped me realize what I needed to do.

Got it to work using Formatter > Transform > Spreadsheet-style Formula, with the formula being:

= "https://8gd.a71.myftpupload.com/wp-content/uploads/ppom_files/confirmed/" & "{{134055002__id}}/" & "{{134055002__line_itemss]product_id}}-" & "{{134055002__line_itemss]meta_data_upload}}"

 

Hi @IdleWilde Printing 

If you know coding such as JavaScript or Python, then you can use a Code step: https://zapier.com/apps/code/help

 

Otherwise, try using a Formatter step: https://zapier.com/help/doc/how-use-formatter-functions

Terms & Conditions