LiveRock

After experimenting around, I changed a single line in advanced_search_result.php around line 282 original $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; to $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_quantity > 0 "; And it works!

Hi I wonder if anyone has this requirement: I do not want to list or display any products that has inventory level of zero or any number pre-determined number. Has anyone seen a contribution or a hack to do that? HELP!

HELP!!!!! I had PWA previously working on a web site and duplicate it for another new site. For some reasons, the new website doesn't work at all. When I click 'proceed to checkout without an account', it brings me to new user sign-up page.... WHY? Hope someone will point me out. I have racking my head for 2 days now.... on top of a strange SSL problem... When I enable SSL, I can't do checkout at all and when I click checkout, I am brought back to the login page and all cart contents are cleared!!! HELP!! Someone, HELP!!!

Hi For some reason, after I duplicate a new store with PWA previously installed, PWA wouldn't work... When I click check out without account, it brings me back to the same page and my shopping cart is zeroed!! What did I do wrong here?

Thanks but I tried that. It only works within the ADMIN. I need something at the storefront.... :-(

Hi I need to do search product by product models.. How to do it? I can't seem to find any topics regarding this matter for the past few hours... HELP!!!

Hi I am currently working on a project with one of the requirement as such: There are a couple of actual physical stores and a single central online store. Everytime a sale is made at the actual physical store, the sale staff would have to send a SMS to the online store to register the sale, update the stocks, etc. as if an online sale had occurred. I am able to build an in-between application that (a) validate the user's mobile phone as authorised (B) all the sales details like stockcode, quantity, sales amount, etc. I am also using my own sms gateway. How can I format the above information and integrate with oscomerce sales flow/process? Or, should I write a PHP module to touch the MySQL tables directly? I am afraid I might break any database integrity if I do that as I am not sure how the tables are related. HELP! Any comments/suggestions/etc will do!! Thanks a bunch!!!