Gallery Images

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
msandin
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 30
Joined: Tue Jul 15, 2014 11:29 pm

Gallery Images

Post by msandin » Tue Jul 14, 2015 4:11 am

Folks,

I have another question. We use AC Gold. Our back office processing is done using Visual FoxPro 9. We recently made changes to enable us to populate the AC database using the DATA>IMPORT>PRODUCTS (and also VARIANTS). Works great.

My question revolves around “Standard Images” and “Gallery Images” for a product. The actual images are stored in the folder “~/Assets/ProductImages” as jpg files.

In the “Product” table of the AC database there are fields with the URL name for each of the three standard images.

Where are the URL names for the “Gallery Images” stored? Can they be reached using the DATA>IMPORT and DATA>EXPORT functions?

Thanks for your help.

Miles

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Gallery Images

Post by AbleMods » Tue Jul 14, 2015 6:58 am

The additional images are stored in the ac_ProductImages table in the Able database. ProductId is the key field.

The data import/export feature does not include the additional images data. You'll have to write your own separate routine to pull that information.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Gallery Images

Post by Naveed » Tue Jul 14, 2015 7:20 am

Where are the URL names for the “Gallery Images” stored?
The URL's of the "Gallery Images" or additional images are stored in ac_ProductImages table. The image files are stored in ~/Assets/ProductImages” as jpg files.
Can they be reached using the DATA>IMPORT and DATA>EXPORT functions?
No, currently you can not export or import additional images. Only standard images are supported yet.

Post Reply