AbleCommerce Shopping Cart Software

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

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.

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.