Jump to content


  • Posts

  • Joined

  • Last visited

dave204's Achievements


Newbie (1/14)



  1. Hi again! I've just tried "re-categorizing" one of the products back out of Mobile Phone Accessories, into its own Category (ie one of the cameras), without checking HOME category, and the database was updated immediately, but when I tried the same thing, WITH the HOME category checked, it timed out. So definitely something has happened to the HOME category, I think. The change to category PHP statement you gave wasn't at fault - that worked brilliantly - it was the first UPDATE which seems to have caused the problem. Can that statement be reversed at all? Thanks, David
  2. So you think the timing out is just a co-incidence? I know it can happen, of course, on servers!! As I said, all I was trying to do was update the products now in mobile phone accessories, by checking/unchecking their Category appearance (there is only about 12 products to do this with), but I'm getting timed-out each time, so I just wondered if the first operation I did had changed Home Category to "88", instead of "1" (the second operation worked perfectly), so any "checking" on the Home just sent the product around in a circle, if you see what I mean, and hence the time-out? Thanks! David
  3. Just one last thing - should I not "alter back" the previous statement, otherwise won't the database "see" the new "Home" category as being "88", instead of "1"? I ask this, as I'm getting timed out when I try to send back the handful of products I wanted to keep in the "Home" category, and I think its related to the previous Update? Thanks, David
  4. Wow! That's worked! Thanks very much for your help! You've saved me an enormous amount of leg-work!! Now all I have to do is transfer back the handful of products which I want in Home category (Featured)! Great bit of PHP/MySQL coding! Thanks once again!! David ps I'll have a look at your store..
  5. Does anyone else know of a method to change the category of a large number of products at one go? I've tried the method given above, but it had no effect. In fact, I don't know what its done,but it certainly didn't do what it was supposed to, even though no error occurred. Does anyone know of any 3rd party module out there which could make the job easier, instead of changing all the records individually?
  6. Strange - it came back with 2379 records updated - yet in the shop nothing has changed!! Puzzled..! David
  7. So just to be absolutely sure, I query using the full string (except for the "x", of course!) UPDATE ps_product SET id_category_default = ‘x’ where id_category_default = 1 or in my case, UPDATE ps_product SET id_category_default = ‘88’ where id_category_default = 1 Do I use the comma's around the value 88, or just 88?? Thanks very much! David
  8. Hi again! I think you intended to write something about "id_category_default", but didn't complete the sentence??
  9. Thanks for reply - and I won't use PM with you again - but what's the difference? The 2 statements look identical.. Or did you intend to write something else for the "X" value? David
  10. Thanks for the information. However, I just want to move all the products in the "Home" Category to the "mobile phone accessories" Category - will this method work for that, or will it put EVERY product (ie from all other Categories) into the mobile one? As I've said, I just want all the products in the Home Category to move.. I don't want to make the SQL query UNTIL I've clarified this point, as you will appreciate!! Awaiting your reply, David Fergus www.electronicsshopdirect.com
  11. Hi there! I have imported an Excel file with 2,500 products. Everything has gone where it should - except the all the products are in the Home Category, whereas I wanted them in "mobile phone accessories". I've moved a few hundred manually, buts its a long, laborious task - does anyone know a quick method to move all of them more easily? Is there maybe a module out there which lets me tick all the boxes at one go, such as a complete list of products in excel style? Any help would be much appreciated! David Fergus www.electronicsshopdirect.com
  12. I have recently added the Western Union module to my online shop. Upon configuration, I notice there is a section for CIF/NF/DNI - what is it?! And also, if someone sends money by this method, (Western Union), how am I notified within Prestashop, as there is no email configuration within the module. Does it pick this up from Prestashop automatically?
  13. Thanks for that. But I un-installed and then re-installed it within the Modules back office - and it worked!! Strange things happen sometime..!
  14. I've installed the latest version of Google Base, 0.6.3 OK, but when I go to generate a feed, it says "The output location is invalid. Cannot write to /googlebase.xml (I created a xml file of the same name in the root folder). What has gone wrong? Completely at a loss on this one! Any help would be much appreciated!! David Fergus
  15. Here is my online shop, www.electronicsshopdirect.com I've added some interesting modules etc., and a lot of products - BUT how do I get more visitors? I've registered with lots of online directories, but its still hard-going. Would it be a good idea to perhaps advertise one or two products on eBay, with a link to my shop? Any suggestions from successful owners of online shops would be much appreciated! And nany thanks to prestashop visitors who have given me valuable feedback already on the layout! David Fergus
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More