Upload Product images from Dropbox to WooCommerce

[nicki]

Your Workflow URL

https://connect.pabbly.com/workflow/share/CEBVZwJVBGdfFQljVTAHIAsfAgYEXQVnABlURgcIAHhVG1EqVxZdN10RUnBTGFU0XhcIYg9QAGAJHQcDA1UFdlZMVHhTUFErBksEfwdSW2gIVlV9AmM#

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hello, I can't figure out how to set up a workflow to upload multiple images from Dropbox and update a WooCommerce product. I can get the Share link for a new file from dropbox if I select the New File Trigger. And, I have figured out how to update a product with that single image. But, if I try to get the list of files in the folder, I do not get the Share links required to add multiple images. My question is how do I get all of the images in a dropbox folder and update a woocommerce product to have all of the images.

 

[Preeti Paryani]

Hello @nicki,

Thanks for reaching out to us. Here's how you can set up your workflow to upload multiple images from Dropbox and update a WooCommerce product:

1. Trigger: Use the Scheduler trigger to run your workflow at a specific time.
2. List Dropbox Files: Add the Dropbox: List All Files/Subfolders in a Folder action to fetch all files from the required folder. Make sure to turn off the “Simple Response” toggle so you can capture the full response in advanced format.
3. Iterator: Add an Iterator step to process each file individually.
4. Get Product Info (Optional): If needed, fetch the product by any specific identifier (like SKU or product ID).
5. Update Product: Use the WooCommerce: Update Product action and map the images from the iterator to update the product gallery.

Following these steps should allow you to upload multiple images from Dropbox to your WooCommerce product.

Let us know if you encounter any issues while setting this up.

 

[nicki]

Hello,
Thank you for the reply! It seems like that should be easy enough but I am still having trouble getting it to work.
Right now I am using the trigger for when a new folder is uploaded to Dropbox (we will probably use a scheduler eventually if we can get this to work). I used the Dropbox: List All Files/Subfolders next and got the list of the 3 images in the folder, however the Share Link is not part of the information that is returned. I then added the Iterator to loop through the files in the folder. I tried the Dropbox : Get File Metadata to get the Share Link but it returns the Preview URL. I tried to update the WooCommerce product using the Preview URL and got an error from Woocommerce.

Also, I was wondering how to get a WooCommerce product by SKU. You mentioned above that I could get the Product info by SKU or ID but I don't see the SKU option (only ID, Name or Slug). My client would prefer to upload images into folders labeled by sku rather than id.
Thanks again!

 

[ArshilAhmad]

We have added a 'Create Shared Link' action event to your workflow, which will provide you with the shared link that can be used in the WooCommerce action step.

Also, I was wondering how to get a WooCommerce product by SKU. You mentioned above that I could get the Product info by SKU or ID but I don't see the SKU option (only ID, Name or Slug). My client would prefer to upload images into folders labeled by sku rather than id.
Thanks again!

Currently, we don’t have an action event in WooCommerce that can retrieve a product using the SKU. I’m afraid this particular use case is not possible at the moment.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[nicki]

Ok, we're getting closer. The Workflow just ran automatically. I had one new folder in Dropbox. Folder named 270756 has three images in it (270756_1.jpg, 270756_2.jpg, 270756_3.jpg). All three images are in the WordPress Media Library but only the last image was added to the product. It must be running three times and overwriting the product's "Product Image" instead of appending the images to the product's image gallery. For this to work for my client, I need all three images added to the product. Is there a way to concatenate the three image Share Links and only update the product once with all three images? Or do you have another solution that will add multiple images to one product?
I appreciate your help!

 

[Preeti Paryani]

Hello @nicki,

To accomplish this use case, we will need to restructure the workflow, which is only possible through the new UI. While attempting to recreate the workflow on our end to verify feasibility, we noticed that the folder you referenced does not currently exist.

Could you please create the required folder, add a few sample files inside it, and share the exact folder path with us? Once we have this information, we will proceed with testing and confirm whether the use case can be achieved.

 

[nicki]

Somehow the folder got renamed. The folder that should be checked for any new folders uploaded is /IGC Test. Inside that folder the newest folder uploaded is /IGC Test/270756 and there are three images in that folder. 270756 is the product ID where the images should be loaded.
Thanks!

 

[ArshilAhmad]

Please allow us some time. We will get back to you shortly.

 

[ArshilAhmad]

Please create a new Google Sheets spreadsheet with 'Shared Links' as the header.

Then create a new connection with your Google Sheets account in Pabbly Connect within this workflow. Once you have done so, let us know.

Pabbly

connect.pabbly.com

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[nicki]

Ok, I have the connection to the Google Sheet added now.

 

[Preeti Paryani]

Hey @nicki,

Thanks for confirming. Please allow us some time and we will get back to you soon.

 

[ArshilAhmad]

We have setup the Google Sheet and Loop related workaround to this workflow.

Pabbly Connect

connect.pabbly.com

You can now add the WooCommerce: Update Product action step to this workflow in the Main route and map the shared links from the Data Transformer (Pabbly) action step.

Then test your workflow by creating a new folder with multiple files in the folder named 'IGC Test'. It would take up to 24 hours for your workflow to trigger once you have created a new folder within 'IGC Test' folder.


Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[nicki]

I added the WooCommerce action step to update the product but there was an error.
{
"code": "woocommerce_product_image_upload_error",
"message": "Invalid image: Sorry, you are not allowed to upload this file type.",
"data > status": "400"
}

What did I do wrong?

 

[Hrishabh.pabbly]

Hello @nicki ,

The error was occurring because WooCommerce was rejecting the image URL you were sending — it wasn’t in a format WooCommerce can render or upload.

To fix this, we added an additional step “File Uploaded by Pabbly” in the workflow. This step converts the original image link into a proper publicly accessible image URL.

We then mapped the new URL from this step into your WooCommerce: Update Product action.

After running the workflow again, it is now working correctly.

Please test it once on your end and let us know if everything runs smoothly.