Jump to content

Search the Community

Showing results for tags 'sql query'.

  • Search By Tags

    • sql query ×
    Type tags separated by commas.
  • Search By Author

Content Type



Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Found 20 results

  1. Hi everyone! Unless I have missed it, I don't think that my problem has been raised in previous post, so I hope someone will be able to help me or direct me to the right place. 😊 I am currently setting up a shop with Prestashop version 8 where I want to show in the Special block and Price...
  2. Hello ! I'm using prestashop 1.7.8.8, i tried to add a new customer in the database "manualy" without using BO but only name and lastname changed and then i want to try again but nothing happened. This is my code I hope i get some help.
  3. Hi,, anyone can help me with sql query? I have a query for export products with combination,, but I only get 1 images for 1 combination item. example if I have 1 products with 2 combination and 3 images in each combination,, this query only give me 2 images url. how can I get all images url? *sorr...
  4. Hello Prestas, we extended the specific price rules functionality with an option "show_discount_front". Now on the sales-page I want to show items only with "show_discount_front = 1". Inside the SpecificPrice.php I'm trying to update the function getProductIdByDate, which get's called...
  5. Hi I am trying to get a list of orders with products ordered and customer addresses and chosen carrier. I have managed to get this to work, but where customers have bought more than one product I am getting rows for each product bought like this! 62118 Preparation in progress 830-080...
  6. The best sales Stats module queries best sellers by date and returns results is there a way to include customer addresses and postcodes in the csv export?
  7. Hi I'm trying to export all products from Prestashop 1.4 with all product tags associated to a product with no luck, I don't understand too much about mysql, I just need the product number and tags associated with it. Shop is in two languages. Can somebody please help me? Just got a list o...
  8. Hello, could anyone please help me with performance tweaking of PS v 1.5 - we have couple of products with multiple combinations - approx 1300 - and it is known to me that this particular feature causes PS to load product listing slowly (when using 1000-3000comb´s)... I discovered that product l...
  9. Hello, How can i update the quantity for a list of products? I've selected the IDs that i'm interested in modifying their quantity and i have come up with this SQL query which i've run inside the ps_product table: UPDATE `ps_product` SET `quantity` =0 WHERE `id_product` IN ( 316, 317, 318...
  10. Hello, I need to import products descriptions into products meta descriptions, so i executed this query and it did work UPDATE ps_product_lang SET ps_product.meta_description=(SELECT ps_product_lang_description FROM ps_product_lang but i need to strip the descripti...
  11. Hello everyone, I have long been searching in google and the Presta forum for a SQL query of the Product URL for a CSV export. I'm not fit in SQL queries and spellings. Maybe someone can help me. In the back office the product URL is deffiniert from me. {category:/}{rewrite}{-:ean13}-{...
  12. Hello, I need to run sql query to round prices, around 5000 products its causing dismatch in google shopping and i have to fix this. example of current prices: 320.48 1189.90 56.19 Prestashop version 1.6.11 and i do have access to phpmyadmin so just need the que...
  13. Hello everyone. This may not be the right forum for this (let me know if its the case), but I desperately need some help in making an sql query and I dont know where else to go. I want a query made in myphpadmin, but I guess it would also work in prestashop. I wish I can make a selective query...
  14. I am not getting any result if i sort that query as "ORDER BY id_category_default ASC" but without sorting its working fine. Notice: Array to string conversion in /srv/website/classes/Product.php public static function getDefaultCategory_byid($id_user) { $default_category = Db::getInstanc...
  15. Hey Guys , I Am new to module development , and i am going through code of existing modules on prestashop available to download. What i am Trying to do - In Instant search Suggest - I have product combination 100gm , 1kg etc. of 1 Product When Person Searches - search results should sh...
  16. [sOLVED] Heya folks, I spent the last days trying to figure out a tricky issue... No way to set up an SQL query to retrieve my products by basing my query on the "id_category". At each try I keep getting more data than expected whereas in the back office I get the 6 wanted products. I have n...
  17. Hello after I have upgraded from 1.5.6.2 to 1.6.0.8 I can't access "BO -> CATALOG -> PRODUCTS" it hangs for about 45 sec. and then displays error (pic. attached): Bad SQL query MySQL server has gone away All other features seems works good after upgrade. Thanks in advance for your help!...
  18. Hej, er der nogen der kan hjælpe mig med at finde Resulsatet af SQL forespørgelsen på min hjemmeside? Jeg er blevet bedt om dette på engelsk Can you send me the result of a SQL query? Det skal bruges til noget opsætming af valuta, hvis det har noget at sige. Hilsen Steen
  19. Hi Team, I need a little SQL help please (or if there is an easier way feel free to fill me in). I need to export a list of all my clients including: first name, last name, phone number, email, last purchase, last purchase date. I have been digging around but having issues finding what t...
  20. Dear friends, Please help me with this issue as it is urgent. I have just upgraded my shop from v1.3.2 to latest version v1.4.8.2. As soon as the upgrading was completed, I got an error “Invalid loadTaxZones() SQL query!”. I have searched the issue on the forum and there is a similar top...
×
×
  • Create New...