Extracting URL of media manager files for import into content manager

Ask the community
, ,
1

The problem is related to data migration to WIX when you decide to re-platform.

  • WIX allows you to bulk upload images. (Except if they have their own folder structure. Yep you have to recreate this by hand and import individual folders one by one?!?)
  • Wix allows you to bulk import items into the content manager by CSV import.

WIX does NOT easily let you extract the URL’s of the media manager files for referencing into your CSV for import so the images can be used.

Only post on the topic I found
https://www.wix.com/corvid/forum/community-discussion/getting-all-image-url-s-in-the-media-manager Mind you its 2020 now.

So the hack in the link works, tips: a) use a non pro grid and you can use this code instead of searching in the source.

 let imagesURL = $w("#gallery1").items;
 for (var i = 0; i < imagesURL.length; i++) {
 let src = imagesURL[i].src;
        console.log(src);
    }

My question is this: Is there a simpler 2020 way I’m overlooking?

2

its 2022 and issues still stands…!

3

Wix support told me to use a separate file provider with direct link access (allowing to do some Excel work to prepend the “constant” file provider URL to the filename > like the links are always fileprovider. com/files/file1 .pdf, fileprovider. com/files/file2. pdf, …). I’m not sure if they’re going to “fix” this which is more of a feature than a bug IMO (but a inconvenient feature for our cases).

4

This is infuriating. The time saved by being able to upload product data to the store is practically null because images have to be added one by one. I’m not a coder - so I had to create my own workaround. It takes time - but not nearly as long as before

  1. Before uploading images to Media Manager, rename them with a number and then a unique identifier for that group of images. Ex: 0001-DATE

  2. After uploading to Media Manager, create three fields in your collection (if they don’t already exist): a Gallery field, an Image field, and a Number field.

  3. In the Number column, enter onto each item the number used for that image.

  4. Add ALL of the images to the Gallery for a single item.

  5. Export the Collection

  6. Copy the one cell that has the gallery to cell A1 on a new sheet.

  7. Data > Text to Column

  8. Choose Delimited and select only the option for Colon.

  9. Select that entire row and copy.

  10. Select cell A2 and right-click. Select Paste Special > Transpose. Now all the split data is in a column.

  11. Select that column. For each special character and word, do a Find & Replace with a blank.

  12. You’ll eventually be left with two versions of the image URL: one is just the URL and the second is the URL plus image data such as name and size.

  13. These will be interspersed with blank rows.

  14. Highlight the column select Find & Select.

  15. Click to Go to Special and choose Blanks. Click OK and then all the blank rows/cells will be highlighted.

  16. Under the Cells section on the Home tab, click the dropdown next to Delete then select Delete Sheet Rows.

  17. Select the column and select Text to Column.

  18. Choose Delimited and select only the option for Other (entering / in the field). Finish.

  19. Delete the first column. This will remove the duplicate URLs. Now delete any other columns you don’t need. You want to keep the column with the image name (number and unique identifier) and the new column with the URL. Now you can identify what image is in each URL!

  20. Sort by the column with the file names. This is why we named them starting with a number.

  21. Copy the column with the URLs.

  22. Go back to the CSV file with the Collection export. Move the column with the Numbers to Column A then sort.

  23. Paste your URLs in the Image column.

Importing Store products requires the image URL - no special formatting. The Content Manager may require a different format for importing URL images.

2 Likes
5

Thanks a lot @deerheart27. I’m going to try this.
Have you found a different way to go about this since then?

6

I have not heard anything from Wix, not even why my Success Manager was fired. Nor was I notified … just ghosted. FYI … On an Enterprise level … these numbers are actually very low. Batching hundreds of url based photos hosted by a 3PL should be basic 101 for all customers.

2 Likes
7

Thank you deerheart27. I have a question, you wrote “In the Number column, enter onto each item the number used for that image”. I am a bit confused, I thought we are exporting all the images urls into one row of a single collection item. Is that correct? or in a single collection do we have an item (row) for each image?