Shaun

I don't have the time and money to spend on SEO and a strong page rank. As a result, I'm selling or will consider a profit share for maintaining and strengthening the sites. Both have Facebook (with shop) and Twitter accounts. One has merchant processing in place. www.goldgalleon.com http://www.facebook.com/pages/GoldGalleoncom/118101871557465?ref=sgm http://twitter.com/GoldGalleon www.silverjewelrybargains.com http://www.facebook.com/profile.php?id=100001540814781 http://twitter.com/SilverJewelryB PM if interested.....

I was preparing screenshots to show you that I only have one default_category_id in my database when I think the light bulb went on (I attached them anyways). There is only one value for default_category_id which is "1" for all ps_products. I checked all 32 pages of this and it is always the same. So, I checked the BO and see that I must have cheque marked all the products "home" and then cheque marked what category the product belonged to, that is why "1" is the default category for all products. So, is there any way to target a category still and reduce the price, or is this a lost cause?

Mmmm...I guess I'm not sure where to find the "Default category ID" then. What table would this be contained in?

Don't know what I'm doing wrong, but it's not working. I looked in the "ps_category_lang" table to see what the id for earrings was, in this case it is "8". I then ran the "UPDATE `ps_product` SET `reduction_percent` = 10, `reduction_from` = '2010-10-01 00:00:00', `reduction_to` = '2010-10-31 23:59:59' WHERE `id_category_default` = 8 query under the SQL tab for "ps_product". The query looked like it ran fine, but said "O rows affected"?

Does anyone out there use a SQL script that can be used to put certain categories, or sub-categories on sale for a certain amount of time? For example, if I wanted to reduce the price of Earrings by 10% for the month of October, how would I go about this? Also, how to put it back to how it was? Please note, this is for price reduction, not "On Sale" as when the date has expired, the 'On Sale" box remains checked.

I've just switched my sites to MDD Hosting with Lightspeed and have never been happier. GZIP compression comes standard and accessing my sites through the back end is FAST! Check them out, do a little research. I use Prestashop ver 1.3.1 without any issue.

My shop was recently upgraded by a third party who did not finish the entire job and is quite the mess in some parts. Since the upgrade, my orders are still successfully recorded in that I'm getting the '"New Order" e-mail with every detail about the order. However, checking the BO and looking at an order, there is nothing where the product details are supposed to be, the browser seems to be hanging a little before allowing me to access the orders which makes me think it's getting hung up on an error somewhere (missing DB table or something). The drop down menu that allows me to change the status of an order is also missing and probably related. The third party added a number of paid modules like Authorize.net, One Page Checkout and Gift Voucher as part of the upgrade so it is difficult to even know where to look for the error. I tried using Firebug on the BO to see if I can see if anythings broken but did not see anything. My trouble shooting skills and experience are minimal at best, hence the post in this section....

Awesome, thank you!!!!!

Rocky, do you know how I can get rid off the "special characters allowed" pop-up? This is driving me crazy every time I go to enter text into one of these fields, i have to click again to actually enter anything. This box also is obscuring information in the text field below. Really dumb feature if you ask me...

I received an order today that I went to mark as 'In Preparation'. However, the drop down menu that has the statuses is no longer there (image "Order_1" and "Order_2". I then noticed that where the product image and description should be (image "Order"), there is nothing but some weird message under the product column. My shop was recently upgraded by a third party who did not finish the entire job, plus I added a number of paid modules like Authorize.net, One Page Checkout and Gift Voucher. So, i wouldn't even know where to look on how to solve this error. It's along shot, but anyone out there who may have an idea on what's wrong?

So, an FYI for all the users who did not know this. With ver 1.3.1, you are able to a specific "Select Image" for the thumbnails you wish to regenerate. For example, I wanted to regenerate my "Facebook New" size that I had assigned to my products and categories. I chose "products" from the "Select Image" drop down menu and hit Regenerate Thumbnails. When I received a server timeout error (most host providers will have a timeout limit for security reasons), I unchecked the "Erase Previous Images" box, and Regenerated Thumbnails again. I had to do this a few times before the operation was completed successfully, but it worked in the end.

@ Rocky, You're right, I tried this after I posted question, exploring various options. After the server first timeout, I unchecked the "Erase previous images”, it managed to complete after I specifically selected "Facebook New" from the drop down menu. This was specifically for the new Facebook image dimensions. I did not see any change immediately after checking my Facebook page (even after clearing the cache), but will troubleshoot step by step tomorrow and update accordingly.

Does anyone know if there is a way to regenerate thumbnails without doing it through the BO? My host provider is reluctant to extend the timeout past 2 minutes in a shared environment for security reasons.

I don't know HTML programming, hence this post. I can modify an existing mail template if it is robust enough. I'm looking for all my shop e-mails to be 'pimped' so that they are more robust and have more links back to the shop and have more advertising etc. (think Amazon e-mails). For example, if you look at the current "shipped" mail sent to customers, it is a couple of lines with a couple of links back to the shop. I would like this to be more informative and useful for the customer with colors and text that is shop specific. Please PM me with a quote if this is something you can do... Update: I discovered DreamWeaver and did it myself :-)

Well that was easy :-) I thought it was related to the gift voucher module after seeing references to it in the page source code, but could not work it out. Thanks Razaro!