huggettm Posted June 9, 2016 Share Posted June 9, 2016 I cant see where in the DB to export the images associated with a product? We have a number of products which have the main image showing 4 or 5 times Quote Link to comment Share on other sites More sharing options...
bsmither Posted June 9, 2016 Share Posted June 9, 2016 There is a "glue" table that associates one or many products (product_id) to one or many images (filemanager_id). That glue table is CubeCart_image_index. To export, a query will need to be constructed that JOINs the Image Index table to the FileManager table based on the filemanager_id, for any given product_id. I suspect such products having the same image multiple times is the result of Catalogue Imports. Let us know if we can help with the query. Quote Link to comment Share on other sites More sharing options...
huggettm Posted June 10, 2016 Author Share Posted June 10, 2016 thank you, TBH I dont know how to construct that query or to remove the duplicates? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.