.png.022b5452a8f28f552bc9430097a16da2.png)
Search the Community
Showing results for tags 'sql manager'.
Found 9 results
-
Hello, could someone please give me some help on how to set a DB query in SQL Manager from BO? I am in need of something like: IF Voucher field is not empty THEN for Orders placed from (date) to (date) whose status is delivered (possibly), get Order ID,Voucher id,voucher name,Customer...
-
Hello, I want to enter a sql query in the back-office - advanced parameters - SQL Manager but impossible to save I have the error. Undefined "checkedFrom" error My query is good, I did verified it in phpmyadmin. If I put the query directly in the table and then use it in the ba...
-
Sziasztok, Nem tudom, volt-e már, de íme egy lekérdezés a kombinációkhoz: SELECT p.id_product, pa.reference, pl.name, GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ", ") as combination, p.price, pq.quantity FROM ps_product_attribute pa LEFT JOIN ps_product p ON (p.id_product = pa.id_product) LEF...
-
Hi I now know how to export nearly anything using SQL manager from my old shop. Except Features, Attributes and Tags. I got some SELECT code for thos but they don't work. If I use them I get no error on creating them, but in my csv file i downloaded I see: In BO: Your query no results If t... -
Hi, Trying to export all my validated orders with the SQL query below to import them into my contractor system. I need one product per line but for each line the total products quantity as shown below. order id total quantity product quantity 1 5...
-
Hi All, Im have a lot of fun with the SQL manager, it is so powerful. I am also familiar with T-SQL and creating SQL queries in MS Access but I cant for the life of me get my usual functions like format([datefield],'yyyy-mm-dd]) to work in sql manager. Two parts to this.. 1 does anyone know...
-
Hi, This is about best practice when you add a custom functionality to the back office. Many of us (I guess) use a fulfilment service/external company. We have to give separate information on how to prepare and to send the orders. There is nothing in the back office for that purpose. To co... -
Hi community... I sincerely hope that someone will help me this time. The lasts posts that I've written here didn't get much attention... Today I'm facing the inconsistent behavior of the SQL manager with the rest of the PS platform. More specifically: if I write a query the result isn't al...
-
Hey guys/gals! I just published a tip on how to export products without using third party stuff. You can check it out here: http://nemops.com/prestashop-export-products/ I hope it can be usefult to somebody! Cheers!-
- 1
-
-
- export products
- export
- (and 2 more)
