Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Product Path Rate Topic   - - - - -

 
  • milo1981
  • Newbie
  • Trial users
  • Join Date: 07-Mar 16
  • 3 posts

Posted 03 April 2016 - 02:57 PM #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!



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21589 posts

Posted 04 April 2016 - 08:01 AM #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);

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)