Forums / General Questions / How to Export All Product Image URLs (Main + Additional) for Chosen Products?

How to Export All Product Image URLs (Main + Additional) for Chosen Products?

Views: 38,049

Results 1 to 3 of 3
26 May 2025, 1:16 PM
#1
dealbyethan_com avatar

dealbyethan_com

Totally Zenned

Join Date:
Dec 2005
Location:
Perth, Western Australia, Australia
Posts:
782
Plugin Contributions:
0

How to Export All Product Image URLs (Main + Additional) for Chosen Products?

Hello everyone,
We're looking for the most efficient way to export a complete list of image URLs from our Zen Cart store, but only for a specific subset of products, not the entire catalog.
Specifically, for a chosen group of products (e.g., a specific category, products based on a list of IDs, or manually selected), we need to export:

  1. The URL for the main product image.
  2. The URLs for all associated "additional images" (also known as extra images).
    We need these as actual URLs (e.g., http://www.yourdomain.com/images/products/product_image_1.jpg) so we can use them for external purposes.
    Is there a recommended method for this in Zen Cart? Are there:
  • Any built-in export features that include all image URLs for selected products?
  • A specific SQL query that can pull this data from the database (including paths for additional images)?
  • Any community-contributed modules that specialize in this type of granular image URL export?
    Any advice, query examples, or pointers would be greatly appreciated!
    Thanks in advance for your help.

**The Team Behind DealByEthan.com | **Curating unique finds for a discerning community. Committed to a seamless and inspiring shopping experience. *Connect with us: *https://linktr.ee/dealbyethan

27 May 2025, 4:27 PM
#2
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,304
Plugin Contributions:
39

Re: How to Export All Product Image URLs (Main + Additional) for Chosen Products?

The straight up easiest way to do this is to export the products table to a CSV. Trim the products you don't need by sorting columns, then use text replace to add the domain.com/images/ to the beginning of each filename.

27 May 2025, 5:24 PM
#3
chadlly2003 avatar

chadlly2003

Totally Zenned

Join Date:
Jan 2015
Posts:
815
Plugin Contributions:
0

Re: How to Export All Product Image URLs (Main + Additional) for Chosen Products?

this will be your best option. It is built for zencart great add on called Database I/O Manager (DbIo)

https://www.zen-cart.com/downloads.php?do=file&id=2091