Bulk Upload In Shopify Using Images Stored in Local Directory (Hard Disk)

Shopify Discussion
1

We work with a lot of vendors who often don’t have Hotlinked Images to give to us.

It’s not even 1 or 2 products. It’s 100s of products per vendor which the team will than have to upload manually.

As per our current process:

  1. Vendors provide hi-res images usually in a different files and folders following our file naming convention.

  2. These files are often provided from GDRive, OneDrive or DropBox.

  3. Jodiabaazar.com team downloads these files.

  4. Creates a CSV from the PDFs provided by the merchant. Uploads a test image in place of img_src.

  5. Individually changes each image by going into product listing.

As you can imagine this is a very cumbersome process and exceptionally slow leading to weeks before we can fully market the vendor.

We have tried the following:

  1. Use the DropBox / OneDrive’s API to generate bulk hotlinks in excel. We used a VB code (using JSON) in excel but failed.

  2. Upload the CSV with the img_src referencing the Local Directory where images are stored instead of HTTP in the CSV. This fails as Shopify app doesn’t have this feature.

Does anyone have a better solution to:

  1. Generate hundreds of hotlinks in mass from images uploaded (pref. a recursing service so it gets into each folder individually) and which can generate the link in excel.

  2. Use the local directory to upload images into Shopify.