puffdade

bnadauld you may remember me as I commented a few times on your previous experience, I used a relativly cheap external company to clean the two main domains on my server the company was called Astra they charge per domain its a yearly subscription and they cleaned the 2 shopping carts of everything thats naughty and monitor and block anything moving forward, a module is set up in the back office and they go to work cleaning up the server. I had to go down this route as all my backups were also trashed in the process I had somewhere around 700 infected files, as quick as I could delete and clean I was infected again its been a long road but my server is now 100% clean I think its cost around 300usd a year for 2 shops, you can talk to a human and they are quick responding it was the helping hand i needed at the time and have peace of mind now you can find them here https://www.getastra.com/prestashop-firewall

El Patron I was sober honest and yes im still cleaning remnents of a bad hack a few months back Those redirects in that file have been set up on my host as well something I never carried out, they all link to images that were removed after a back door module hack a few months ago, I cannot remove the redirects on the server and when I checked the htaccess file I see the same redirects so im confused. @Musicmaster I already renamed the file "old" and that above is the regenerated version, I was thinking if my code had been comprimised it would re write a clean version, so im guessing there is still something in my presta version that is still either comprimised or old code that needs removing, but not sure where to start, Any suggestions are welcomed with open arms at this stage as my cart is showing poor speeds on GTMetrix now when I was right up there at one point

is the HTACCESS file self generating ? Example if i deleted mine would it re write itself ? Im not liking the look of mine and don't understand it im wondering if it looks ok? the images sections dont look right to me # ~~start~~ Do not remove this comment, Prestashop will keep automatically the code outside this comment when .htaccess will be generated again # .htaccess automaticaly generated by PrestaShop e-commerce open-source solution # http://www.prestashop.com - http://www.prestashop.com/forums <IfModule mod_rewrite.c> <IfModule mod_env.c> SetEnv HTTP_MOD_REWRITE On </IfModule> RewriteEngine on #Domain: www.puffdade.com RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule . - [E=REWRITEBASE:/shop/] RewriteRule ^api$ api/ [L] RewriteRule ^api/(.*)$ %{ENV:REWRITEBASE}webservice/dispatcher.php?url=$1 [QSA,L] # Images RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$1$2$3.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$1$2$3$4.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$1$2$3$4$5.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$1$2$3$4$5$6.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$1$2$3$4$5$6$7.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$1$2$3$4$5$6$7$8.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$1$2$3$4$5$6$7$8$9.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$8/$1$2$3$4$5$6$7$8$9$10.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^c/([0-9]+)(\-[\.*_a-zA-Z0-9-]*)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2$3.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^c/([a-zA-Z_-]+)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2.jpg [L] # AlphaImageLoader for IE and fancybox RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^images_ie/?([^/]+)\.(jpe?g|png|gif)$ js/jquery/plugins/fancybox/images/$1.$2 [L] #Domain: www.puffdade.com RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule . - [E=REWRITEBASE:/shop/] RewriteRule ^api$ api/ [L] RewriteRule ^api/(.*)$ %{ENV:REWRITEBASE}webservice/dispatcher.php?url=$1 [QSA,L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^southgate$ /shop/southgate/ [L,R] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^southgate/(.*) /shop/$1 [L] # Images RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$1$2$3.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$1$2$3$4.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$1$2$3$4$5.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$1$2$3$4$5$6.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$1$2$3$4$5$6$7.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$1$2$3$4$5$6$7$8.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$1$2$3$4$5$6$7$8$9.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$8/$1$2$3$4$5$6$7$8$9$10.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^c/([0-9]+)(\-[\.*_a-zA-Z0-9-]*)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2$3.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^c/([a-zA-Z_-]+)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2.jpg [L] # AlphaImageLoader for IE and fancybox RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^images_ie/?([^/]+)\.(jpe?g|png|gif)$ js/jquery/plugins/fancybox/images/$1.$2 [L] #Domain: www.puffdade.com RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule . - [E=REWRITEBASE:/shop/] RewriteRule ^api$ api/ [L] RewriteRule ^api/(.*)$ %{ENV:REWRITEBASE}webservice/dispatcher.php?url=$1 [QSA,L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^southendonsea$ /shop/southendonsea/ [L,R] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^southendonsea/(.*) /shop/$1 [L] # Images RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$1$2$3.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$1$2$3$4.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$1$2$3$4$5.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$1$2$3$4$5$6.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$1$2$3$4$5$6$7.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$1$2$3$4$5$6$7$8.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$1$2$3$4$5$6$7$8$9.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$8/$1$2$3$4$5$6$7$8$9$10.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^c/([0-9]+)(\-[\.*_a-zA-Z0-9-]*)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2$3.jpg [L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^c/([a-zA-Z_-]+)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2.jpg [L] # AlphaImageLoader for IE and fancybox RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^images_ie/?([^/]+)\.(jpe?g|png|gif)$ js/jquery/plugins/fancybox/images/$1.$2 [L] # Dispatcher RewriteCond %{REQUEST_FILENAME} -s [OR] RewriteCond %{REQUEST_FILENAME} -l [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^.*$ - [NC,L] RewriteCond %{HTTP_HOST} ^www.puffdade.com$ RewriteRule ^.*$ %{ENV:REWRITEBASE}index.php [NC,L] </IfModule> AddType application/vnd.ms-fontobject .eot AddType font/ttf .ttf AddType font/otf .otf AddType font/woff2 .woff2 AddType application/x-font-woff .woff <IfModule mod_headers.c> <FilesMatch "\.(ttf|ttc|otf|eot|woff|woff2|svg)$"> Header set Access-Control-Allow-Origin "*" </FilesMatch> </IfModule> <IfModule mod_expires.c> ExpiresActive On ExpiresByType image/gif "access plus 1 month" ExpiresByType image/jpeg "access plus 1 month" ExpiresByType image/png "access plus 1 month" ExpiresByType text/css "access plus 1 week" ExpiresByType text/javascript "access plus 1 week" ExpiresByType application/javascript "access plus 1 week" ExpiresByType application/x-javascript "access plus 1 week" ExpiresByType image/x-icon "access plus 1 year" ExpiresByType image/svg+xml "access plus 1 year" ExpiresByType image/vnd.microsoft.icon "access plus 1 year" ExpiresByType application/font-woff "access plus 1 year" ExpiresByType application/x-font-woff "access plus 1 year" ExpiresByType font/woff2 "access plus 1 year" ExpiresByType application/vnd.ms-fontobject "access plus 1 year" ExpiresByType font/opentype "access plus 1 year" ExpiresByType font/ttf "access plus 1 year" ExpiresByType font/otf "access plus 1 year" ExpiresByType application/x-font-ttf "access plus 1 year" ExpiresByType application/x-font-otf "access plus 1 year" </IfModule> <IfModule mod_headers.c> Header unset Etag </IfModule> FileETag none <IfModule mod_deflate.c> <IfModule mod_filter.c> AddOutputFilterByType DEFLATE text/html text/css text/javascript application/javascript application/x-javascript font/ttf application/x-font-ttf font/otf application/x-font-otf font/opentype image/svg+xml </IfModule> </IfModule> #If rewrite mod isn't enabled ErrorDocument 404 /shop/index.php?controller=404 # ~~end~~ Do not remove this comment, Prestashop will keep automatically the code outside this comment when .htaccess will be generated again # start ~ module watermark section <IfModule mod_rewrite.c> Options +FollowSymLinks RewriteEngine On RewriteCond expr "! %{HTTP_REFERER} -strmatch '*://%{HTTP_HOST}*/admin123/*'" RewriteRule [0-9/]+/[0-9]+\.jpg$ - [F] </IfModule> # end ~ module watermark section # start ~ module watermark section <IfModule mod_rewrite.c> Options +FollowSymLinks RewriteEngine On RewriteCond expr "! %{HTTP_REFERER} -strmatch '*://%{HTTP_HOST}*/admin123/*'" RewriteRule [0-9/]+/[0-9]+\.jpg$ - [F] </IfModule> # end ~ module watermark section

As the retailer surely its up to you what you charge for a product and the VAT is calculated on the final price All my discounts are Base price minus discount plus vat im in UK not sure if it makes much difference but have recently had a vat inspection and came though it ok no issues. I beleive your 2nd example is correct not sure how the first can be correct when VAT stands for value added tax, the tax is based on or added to the value of the product

"UPDATE" Nice trick El Patron Database is under 500mb now nearly half its old size,

Daniel Thanks for all the help you Sir are a superstar 4you.software made me a module that I have been running over the last couple of days i still have a little more to do but its knocked 200+ mb off the size of my database so far its still work in progress for me as im so busy trying to keep the business fully operational which is difficult with our government forever changing the Covid rules ( our retail stores forced closed yet again from midnight last night) This module is just magic it happily runs along in the background and my 3 retails stores operate with no issues no speed constraints what so ever Daniel is a database guru during our shared screen I watched him just flow through proceedures and I learnt bundles just watching, so much so I have started reading up on SQL although at 55 yrs old I may be a bit late for that . simple things like database backup to see it done the right way made all the hairs stand up on the back of my neck (I have been doing it wrong for 7 years on Presta). I still cannot find any resources online regarding ps_smarty_cache_bkp the table hasnt had an entries since 13/8/20 and only has data from 2017 so im presuming module related and its now unused and possibly surplus to requirements so im thinking of removing that as thats another 15% saving comparison to image i posted at the start of the thread, as you can see its reduced drastically, Daniel thank you for the module your time and being on the end of a pc

This is something I would really like to do as I only need to keep 2 years of orders on the system and each year I could repeatedly remove the oldest year into an archive on my NAS, is this something you would be prepared to write for me im happy to pay your going rate the thought of me sitting here selecting small segments saving and archiving each segment gives me bad vibes I could easily mess up and thats something I don't want, Regards Paul

On this installation the number of orders is correct however we had some problems with a 1.5 version when i first started using PS and lost around 50k order history (my inexperience with cart software) and had to do a total rebuild in 2014, so this particular business has around 250k orders since end of 2012 im quite proud of it despite all the sticky tape holding the cart together and if im totally honest would have given up on PS if it wasnt for the help of you guys on this forum. i looked at ps-smarty-cache-bkp and considered if this was a backup entry in the database and after digging down into the entry there have been no additions to this table since 13-8-20 this also coincides with a major issue we had when we got hacked and we had to dig deep and do some major fixing of the site, I have added a snippet below sorted by date (newest entries at the top), im far from an expert hence my question here and if those entries are safe to delete thats 100mb saved.

I have truncated those and its made a small difference I have sorted the tables by size and have posted below, most of the large tables seem legit to me, Im wonderig if its a case of its just a big busy site can you see anything in this list that maybe shouldnt be there or I could do anything with to shrink it down Regards Paul

Thank you very much

Hi All The topic is slightly open I know as its very much dependant on so many factors but im concerned that mine is excessive and possibly leading to some slowing up of the shopping cart Im currently running 1.6.1.24 yes I know caveman addition but its running sweet its still relativly quick im getting reasonable GT Metrix scrores but like most of us we strive for more I started looking at the database an area I have no knowledge of other than without it the Cart wouldnt exist. My current stats are as follows 902mb seems excessive but to give you an idea of my current Cart setup and stats I currently have 2700 products around 1200 of those currently have combinations some quite heavily loaded with as many as 12 combinations I have plenty of pictures a minimum of 2 per product and in most cases a seperate image for each combination, I have around 1/4 of a million orders on the system so thats a 1/4 of a million invoices etc etc Around 18,000 Customers I regularly clear the logs, abandoned carts, old emails, customers with no address's etc. So my question is for anyone with database experience, Is there anything I can do to shrink that baby down and maybe get that little extra speed that we all dream of, does my DBase seem ok size wise given the amount of data im trying to store would I benefit from any future upgrades (database) not Presta Version Thanks for looking Paul

If Iam understanding this question Could you not make the item itself 0.25m and the customer chooses how many units he needs 4 unts = 1 metre and so on if you buy in 100m to sell you just add 400 units Example Description Plase note: this item ships in 0.25m units please choose how many units you require,

I had a very similar problem on 1.6 friday the problem was with the product selection I had products that were associated with both discount codes and the customers were getting double discount, a lot of head scratching and searching and I found it

I got right through to payment stage no issues

This PDF may help it lists all weights and prices for each type of parcel https://www.royalmail.com/sites/royalmail.com/files/2020-08/royal-mail-our-prices-01-september-2020.pdf