Search:

Type: Posts; User: marcopolo

Page 1 of 8 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    170

    Re: Custom minimum values based on country

    That worked! Thank you!
  2. Replies
    2
    Views
    170

    Custom minimum values based on country

    I would like to have a set of minimum values for USA and a different set of minimum values of all other countries. I would like to set USA postal code minimum value to 5 and state to 2 but doing this...
  3. Re: Sharing reviews with multiple product id's

    It works :) Thank you!
  4. Re: Sharing reviews with multiple product id's

    The error is below:

    [18-Mar-2021 20:31:20 America/New_York] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the...
  5. Re: Sharing reviews with multiple product id's

    Yeah I saw that and corrected it before I tried it :smile: There is still an issue. It's generating an error because it is trying to reference the additionalSelectSql which is the review id in the...
  6. Re: Sharing reviews with multiple product id's

    Ok not working but I belive I know why.


    The original function works for a review based on the product id being viewed. What it needs to do is based on the product id being viewed reference the...
  7. Re: Sharing reviews with multiple product id's

    Carlwhat if not to much trouble can you look at the below function and let me know how to get it to use the custom review id I have for each product like you did in the other function above?

    This...
  8. Re: Propduct calculation total based on order status and catoegories

    Got it thank you DrByte!
  9. Re: Propduct calculation total based on order status and catoegories

    That did the job, thank you again for your help!

    Here is the code that works if anyone else wants to do something like this:


    $test_sql1 = "SELECT SUM(op.products_quantity) * 12 as test1
    ...
  10. Re: Propduct calculation total based on order status and catoegories

    This is how I'm calling it:


    <div class="header">Production Info</div>
    <?php
    echo '<div class="row"><span class="left">FRESH CUPS</span><span class="rigth"> ' . $test_total2 . '</span></div>';...
  11. Re: Propduct calculation total based on order status and catoegories

    Thank you DrByte. Following the instructions on that page I changed the code to:


    $test_sql = "SELECT SUM(op.products_quantity) * 12
    FROM orders_products op
    INNER JOIN orders o
    ...
  12. Re: Propduct calculation total based on order status and catoegories

    Thank you lat9 the query works if I run it directly from MySQL. I was trying to get it to work from the admin changed the code to:


    $test_total = $db->Execute('SELECT SUM(op.products_quantity) *...
  13. Propduct calculation total based on order status and catoegories

    Trying to calculate my production of a certain product based on orders in processing.

    So for example need to know out of all the orders in processing that are from a certain category what is the...
  14. Re: Sharing reviews with multiple product id's

    Got it code works! I really appreciate your help on this.

    I changed the original code part as well from


    WHERE rv.status = 1 AND rv.products_review_id = ' . $review_id);

    to
  15. Re: Sharing reviews with multiple product id's

    Ok the above error was just the code missed the part where you said "you will still need the '$review_id' var that we established above..."
    So adding that to code still generates an error but it is...
  16. Re: Sharing reviews with multiple product id's

    Ok that generates the following error:

    [17-Feb-2021 13:35:42 America/New_York] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server...
  17. Re: Sharing reviews with multiple product id's

    Thank you for the code it works but the code below needs to be changed. It's not displaying the reviews with matching product_review_id since now the above code referenced the products table. Which...
  18. Re: Sharing reviews with multiple product id's

    Almost have this working the displaying of reviews based on the custom product define products_review_id is working.

    I have products_review_id in TABLE products and in TABLE reviews. I imported my...
  19. Re: Sharing reviews with multiple product id's

    Thank you that's the section of code I was trying to modify and for whatever reason could not get it to work. I will try again I'm not much of a coder so I most likely did something wrong. I'm on...
  20. Sharing reviews with multiple product id's

    I have the same product listed in multiple categories which the category defines how it is packed. So for example:

    Category 1 - Product A (for example this product has a product_id of 1)...
  21. Re: How to write a piece of code for a product id total?

    Ok that made it work, which is fine since this is a new item there is no sales history so I do not need the date portion of the code anyways. Thanks again for taking the time to help me complete this...
  22. Re: How to write a piece of code for a product id total?

    It is returning 0
    no errors even after removing // from the troubleshooting line. I did have to change:

    $start_datetime = '2020-03-20 05:00:00";

    to


    $start_datetime = '2020-03-20 05:00:00';
  23. Re: How to write a piece of code for a product id total?

    Is it possible for you to do the code for the stock way, I'm stuck like I said it's returning 0.00 so it's not working or giving me any errors to see why.

    The fundraiser has started and I would...
  24. Re: How to write a piece of code for a product id total?

    Ok I was able to add your code to the module yesterday without and errors being generated but it is returning 0.00 does not seem to work that is why I suggested going the stock route. It will be a...
  25. Re: How to write a piece of code for a product id total?

    Thinking about this more I see a better way of doing it. We created a product for this fundraiser and the entered a stock qty of 1000. I see Zen cart has a function that can check stock. How can the...
  26. Re: How to write a piece of code for a product id total?

    Ok trying to get this to work but it's causing the side box to not display. I'm thinking it's because I have to create a function file maybe? I do not know where to put the code :blink:

    Here is...
  27. Re: How to write a piece of code for a product id total?

    Thank you! I will test later this evening and report back. Thanks again really appreciate it!
  28. Re: How to write a piece of code for a product id total?

    Function just needs to check qty sold of a single item in this case product_id 1200 then multiple qty sold by $12. Help anybody?
  29. How to write a piece of code for a product id total?

    Running a fundraiser and would like to display total funds collected. We will be selling a product for example $22 dollars which $12 dollars of the sale will be donated. I created a side banner with...
  30. Re: PHP Fatal error when accessing: Admin/Modules/Shipping

    Thanks mc12345678 for the response, I checked and it is declared. There is no more error message than what I posted. Also for whatever reason it is working now I did not do anything it is very...
  31. PHP Fatal error when accessing: Admin/Modules/Shipping

    Getting the following error when try to access Admin/Modules/Shipping

    PHP Fatal error: Call to a member function get_decimal_places() on null in /zencart/includes/classes/shopping_cart.php on...
  32. Replies
    6
    Views
    1,828

    v155 Re: Authorize.net MD5 Hash Phased out

    I just received the same email with there be an update to address this?
  33. v151 Re: Twitch Restrict Categories by Customer or Group

    Ok I was able to figure it out myself but if there are any coders that verify my code that would be appreciated.

    I modified the following file to get it to work with module "CSS Flyout Menu"...
  34. v151 Re: Twitch Restrict Categories by Customer or Group

    Has anyone gotten this to work with drop down menus? If you did can you please post the before and after code you used to filter out the restricted categories?
  35. Replies
    3
    Views
    317

    Re: Custom product for a customer

    Thanks, I saw this one took a second look and it seems it will work out with a little modifying.
  36. Replies
    3
    Views
    317

    Custom product for a customer

    Does anyone know of a module paid or free available that will allow for a product to be added to zencart that will only be viewable and available to purchase by a single customer. Basically looking...
  37. Replies
    1
    Views
    225

    STORE_SESSIONS setting for v1.5.5e

    I was looking over my configure.php file and noticed STORE_SESSIONS is no longer defined. I checked the default file for a v1.5.5e install and it is not there as well. It is listed here as an option...
  38. Replies
    0
    Views
    158

    One button click for primary address

    Looking to make it easier for a customer to change an address to the "primary address". Right now you have to edit an address then click on a radio box to mark it primary then save the address. It...
  39. Re: Display master category name for a product id

    Thanks for all the help below is the final code that is giving me the output I need:


    <?php
    $count = 0;
    $ordersProducts = $db->Execute('SELECT * FROM ' ....
  40. Re: Display master category name for a product id

    Is there a function to return the partent_id for a categories_id?
  41. Re: Display master category name for a product id

    Ok much simpler I have to remember about those build in functions :)

    This is returning the category name but I want the "MASTER" category name, is there a way to do that?

    Here is my current...
  42. Display master category name for a product id

    Not sure how to write the code but I'm looking to display the master category name based off the product id from the orders_product table

    in the orders_product table the column for the product id...
  43. Replies
    8
    Views
    244

    Re: Switch Statement

    cartwhat that did it! working perfect now, thank you!
  44. Replies
    8
    Views
    244

    Re: Switch Statement

    Design75 thank you that fixed the error 500 but logically it is not doing what I'm trying to get it to do, no matter if there is a 1 or a 0 in the TEST_order table field it is returning case 0. I'm...
  45. Replies
    8
    Views
    244

    Re: Switch Statement

    I also tried this which sorta works but having issues with he else that is not working:


    <?php If ($orders->fields['TEST_order'] = true) { ?>
    <td class="dataTableContent"><?php...
  46. Replies
    8
    Views
    244

    Re: Switch Statement

    I may be going about it all worng basically this is what I'm trying to do:

    In the admin orders screen IF a field in the orders table in this case: TEST_order = 1 I want to use the following in...
  47. Replies
    8
    Views
    244

    Re: Switch Statement

    I'm using Zencart v1.5.5e it is not generating a log for whatever reason usually I get them but for this specific issue it's not generating one. My server is generating the following in apache error...
  48. Replies
    8
    Views
    244

    Switch Statement

    I can use some help on the below code. It is giving me error 500 right now which I believe is because of the code in red. I know it is properly missing something I'm not sure how to do it so anyone...
  49. Replies
    1,722
    Views
    157,203

    v150 Re: Edit Orders v4.0 Support Thread

    Nevermind it worked
  50. Replies
    1,722
    Views
    157,203

    v150 Re: Edit Orders v4.0 Support Thread

    Nevermind it worked!
Results 1 to 50 of 395
Page 1 of 8 1 2 3 4
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR