cooliyev

Hi Nemo. You are the smartest here)) do you know how to get all image links of 1 product. I have this code concat( 'http://', ifnull( conf.value, 'marm.pl' ) , '/img/p/',mid(p.id_product,1,1),'/', if (length(p.id_product)>1,concat(mid(p.id_product,2,1),'/'),''), if (length(p.id_product)>2,concat(mid(p.id_product,3,1),'/'),''), if (length(p.id_product)>3,concat(mid(p.id_product,4,1),'/'),''), if (length(p.id_product)>4,concat(mid(p.id_product,5,1),'/'),''), p.id_product, '.jpg' ) AS url_image and it takes only main image. But how to get 2nd, 3rd image links?

Hi. If product has more than 1 pic. how to export in that case?

How to export paths of images?

Just delete ( SELECT id_lang FROM ps_lang ORDER BY id_lang ASC LIMIT 1 ) and write 1 for english

Me too

Where I can find aliases for all tables? Or I can write it by myself?

Hi I want to create SQL query for SQL Manager but I don't understand what does mean p., pl., g., o...etc.. inside of queries? Now I have 2 sql queries SELECT ps_attribute_lang.name FROM ps_attribute_lang LEFT JOIN ps_product_attribute_combination ON ps_product_attribute_combination.id_attribute = ps_attribute_lang.id_attribute WHERE ps_product_attribute_combination.id_product_attribute = "2061" AND ps_attribute_lang.id_lang="1" and SELECT d.id_order, d.product_reference, d.product_attribute_id, d.product_quantity, g.firstname, g.lastname, ai.address1, ai.address2, ai.postcode, ai.city, ai.other, ai.phone_mobile FROM ps_order_detail d LEFT JOIN ps_orders o ON ( d.id_order = o.id_order ) LEFT JOIN ps_customer g ON ( o.id_customer = g.id_customer ) LEFT JOIN ps_stock_available s ON (d.product_id = s.id_product) LEFT JOIN ps_address ad ON (o.id_address_delivery = ad.id_address) LEFT JOIN ps_address ai ON (o.id_address_invoice = ai.id_address) LEFT JOIN ps_group_lang gl ON ( g.id_default_group = gl.id_group ) LEFT JOIN ps_order_state_lang os ON ( o.current_state = os.id_order_state ) WHERE os.id_lang =1 GROUP BY d.id_order ORDER BY d.id_order DESC I want to combine these queries but don't know how. Please help

Hi, I need your help with SQL. This is my SQL SELECT d.id_order, d.product_reference, d.product_attribute_id, d.product_quantity, g.firstname, g.lastname, ai.address1, ai.address2, ai.postcode, ai.city, ai.other, ai.phone_mobile FROM ps_order_detail d LEFT JOIN ps_orders o ON ( d.id_order = o.id_order ) LEFT JOIN ps_customer g ON ( o.id_customer = g.id_customer ) LEFT JOIN ps_stock_available s ON (d.product_id = s.id_product) LEFT JOIN ps_address ad ON (o.id_address_delivery = ad.id_address) LEFT JOIN ps_address ai ON (o.id_address_invoice = ai.id_address) LEFT JOIN ps_group_lang gl ON ( g.id_default_group = gl.id_group ) LEFT JOIN ps_order_state_lang os ON ( o.current_state = os.id_order_state ) WHERE os.id_lang =1 GROUP BY d.id_order ORDER BY d.id_order DESC How to add here color and size of the product? This code is correct on phpmyadmin but i cannot and don't know how integrate this code to the upper code SELECT ps_attribute_lang.name FROM ps_attribute_lang LEFT JOIN ps_product_attribute_combination ON ps_product_attribute_combination.id_attribute = ps_attribute_lang.id_attribute WHERE ps_product_attribute_combination.id_product_attribute = "2061" AND ps_attribute_lang.id_lang="1"

This is for your charts in the dashboard

Spasibo pomoglo. 1.6.0.14

Maybe I have installed quick start with integrated design

The route is like default. I didn't change it. Yes only images on the header doesn't show and pictures of product.

Yes that's right and appears 2 errors: The route is not valid Route to modules : Incorrect value But I didn't change anything. I have tried to erase cache and changed chmod of htaccess to 604. But nothing help

It did not help me((( what else I can to do? main page goes linke in attached fime

Hi. Did you set product's weight? It's important. After, you have to set up weight diapasones.