Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Location
    Perth, Western Australia, Australia
    Posts
    781
    Plugin Contributions
    0

    help question 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/pro...ct_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


  2. #2
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,252
    Plugin Contributions
    59

    Default 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.
    PRO-Webs, Inc. since 2003 :: Zen Cart Hosting :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are not conducive to a helpful community.

  3. #3
    Join Date
    Jan 2015
    Posts
    728
    Plugin Contributions
    1

    Default 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

 

 

Similar Threads

  1. v139h Can't Export Product URLs
    By BrooklynArtist in forum General Questions
    Replies: 0
    Last Post: 16 Feb 2012, 05:12 PM
  2. custom image popup script only work for main image, not for additional images
    By gems14k in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 4 Oct 2006, 05:19 AM
  3. How to move additional images to the right of main product image
    By davale in forum Templates, Stylesheets, Page Layout
    Replies: 12
    Last Post: 20 Sep 2006, 02:27 PM
  4. Additional images UNDER main image - how?
    By cosmocanuck in forum Templates, Stylesheets, Page Layout
    Replies: 7
    Last Post: 1 Sep 2006, 05:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg