Exporting Image URLs and Product Variants

Overview

You may need to extract links to images for all product variants in Symphony.

Solution

Submit a request to Symphony Support, describing the required fields and specifying if you need image URLs for all product variants or only for published ones (excluding archived and unlisted).
Note: If you want to have all the product images exported and uploaded on a shared drive, please reach out to your Account Manager.

<supportagent>

Image URLs can be exported following the steps below.

If the brand wants to pull all image files, they need to contact their AM - such requests should be handled by the PS team as downloading images from AWS may require a significant amount of time.

1. Connect to the database and run the following query.
   Adjust the query by adding more fields if requested by the brand; also, remove the 'and pc.archived = 0 and pc.unlist = 0' section if the brand wants to include images for archived and unlisted variants.
   
   

   SELECT pc.id as Product, p.id as variant, p.name as Name, p.vendorSKUId as SKU, i.large, distribution 
   FROM Product p 
   JOIN ProductCluster pc on p.productClusterId = pc.id
   JOIN Image i on i.entityId = pc.id
   WHERE pc.site = '<brand>' and pc.archived = 0 and pc.unlist = 0
   GROUP BY p.id, i.large
   ORDER BY pc.id, p.id;

   Note: Make sure to remove the output limit to extract all available images.
   
   
   
   
2. Export the data as a CSV file.
3. Add https:// to the G column (if you used the default query).
4. Copy the following formula to the H2 field and expand it to generate proper image links in the H column.
   =CONCAT(G2,F2,E2)
   
   
   
   
5. Test that newly generated links from the column H are working.
6. Copy the content of the column H (with the links to images) and paste the content to the next column using Ctrl+ALT+V and selecting Values.
   
   
   
   
7. Remove the unnecessary columns (E, F ,G, H), save the file, and send it to the requester.

</supportagent>