Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

arbocenc

Archived
  • Posts

    55
  • Joined

  • Last visited

Everything posted by arbocenc

  1. Fixed. The problem was the mysql syntax (my skills in mysql are near zero :-( Solution: with a parethesis () The right query is SELECT products.products_id, categories_name, products_name, products_price, manufacturers_name, products_weight FROM products, products_description, categories_description, products_to_categories, manufacturers WHERE products.products_id = products_to_categories.products_id AND products_to_categories.categories_id = categories_description.categories_id AND products.products_id = products_description.products_id AND products.manufacturers_id = manufacturers.manufacturers_id AND products_status='1' AND products_description.language_id='4' AND categories_description.language_id='4' AND (categories_description.categories_id='64' OR categories_description.categories_id='65') See you later :-) Joan
  2. Hi, I've got a query to list and print all the items in my shop, but now I want list only those from two categories. I add the two last lines to the query, and it crashes. It seems there are two many items to list, and I think mysql is making combination with all the items in category 65 with the rest of the query (because if I delete the last line all runs fine) Any suggestions? Thanks, Arbocenc SELECT products.products_id, categories_name, products_name, products_price, manufacturers_name, products_weight FROM products, products_description, categories_description, products_to_categories, manufacturers WHERE products.products_id = products_to_categories.products_id AND products_to_categories.categories_id = categories_description.categories_id AND products.products_id = products_description.products_id AND products.manufacturers_id = manufacturers.manufacturers_id AND products_status='1' AND products_description.language_id='4' AND categories_description.language_id='4' AND categories_description.categories_id='64' [b]OR categories_description.categories_id='65'[/b] [/b]
  3. Could you alert us when the quickstockandprice update will be on line? Thanks a lot, Joan
  4. Hello, Do you know if it's easy to adapt your contribution/idea for updating prices instead stock? Or maybe two or three fields (for exaple, stock, prices and description...) See you later! Joan
  5. Yes, I've check it. Last step in checkout http://www.unlockgsm.com/test_checkout/cat...out_process.php has failed (white screen in the browser) I think it will be good for my needs (not product discounts, only global discounts). I'm fear of update all files your addon need, but there is no option! By the way, my adress is [email protected] and my name is Joan Cervan Thanks a lot Elari, Joan
  6. Hi Elari, Tell me if thet is true: "If I set a 50% max disacount for all my products, then a customer with a 10% of discount can see ALL products with this discount?" --- Can I access to the Admin part? Or is there any file with abilities of your addon? By the way, is specials discount added to your discounts? Thanks a lot, Joan
  7. Hi Elari, Can customer_status add on make a discount for all products without introduce it product by product? And, what prices are displayed? Normal or with the discount? (I'm interested in normal prices that, al last, in check out, are replaced by discount ones (but cusatomers can see old prices, for taking advice that the discount is running...). Thanks a lot, Joan
  8. Hello, I'm finding a contribution that let me update my prices quickly but I need select products by categories. C-PRICE let me select products by categories (QUICK PRODUCTS UPDATE do not) but it only shows me product names and prices. I need another column with manufactures information because my shop will have some products with the same name (for example, rice, tofu burger, etc.) and I only can diferenciate between them with manufacturer name. Do anyone know a contribution suiteble for that? Thanks very much, Joan Cervan i Andreu
×
×
  • Create New...