Product Path

General General Questions
1

Hello,

What SQL query can I use to get in a single column the product path.

I've looked through all the tables but I can't find the location where this information is stored.

Can someone help?

Also it would be usefull to know the main image path for every product.

Thanks!

2

Hello,

What SQL query can I use to get in a single column the product path.

I've looked through all the tables but I can't find the location where this information is stored.

Can someone help?

Also it would be usefull to know the main image path for every product.

Thanks!

If you mean image path, please use the following code:

$product_main_pair = fn_get_image_pairs($product_id, 'product', 'M', true, true);

// show content of the received array

fn_print_r($product_main_pair);