ozfragrance

how about making that number hyperlink to the currier website same like what we have in the actual order page. this way we don't have to copy and paste from the order list page to the currier page, just click and takes us there. Thanks

Having the same issue. tried everything with no success. what I tried: reset and uninstall trends, gaols and most dash modules but not working. goals working only in Demo Mode but once turn demo off then it's not working again. presta v1.6.1.1 goals module v0.7.0 not saving data as all revert back to zero. is there any db table for this module so we could apply values directly in the db so it can work? by the way checked the permissions on the module folder and all seems to be alright! this drives me crazy guys!

what happened to this topic. is there such script we can use with crontab to change all status after certain days for any order? like a script look at the order list, whenever find (shipped) change that to (delivered) if past 15 days, and of course allow sending the correspondent email message for the (delivered Status)? Thanks in advance

login to you cPanel and edit database using PhpMyAdmin alter the table ps_order_state in your database. make sure there is a pdf_delivery column, if not then you have to create it. I had the same issue with pdf_delivery and pdf_invoice so I had to create those 2 columns manually in the database and all resolved. `pdf_delivery` tinyint(1) unsigned NOT NULL DEFAULT '0'; `pdf_invoice` tinyint(1) unsigned NOT NULL DEFAULT '0';

tested and working on v1.6.1.1 Thank you

sorry mate, I never used advanced stock management so I couldn't tell which one to update. but my understanding you are updating ps_product table and I think that will update the products everywhere in the shop we are not running this query against the ps_stock table.

hi guys, I need to put the following sql query into php file so I can run it from cron job, the query is: UPDATE ps_product_shop SET visibility="none" WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity=0); UPDATE ps_product_shop SET visibility="both" WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity>0); I have no clue where to start, if I run this query in PhpMyAdmin it works very well, but how to implement it into php so we can easily cron it?

UPDATE `ps_product` SET `quantity`='0' WHERE `active`='1'; it will set quantity to zero for all active products.