Jump to content

jloyzaga

Members
  • Content count

    240
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Joe Loyzaga
  1. jloyzaga

    free shipping based on price and weight

    try here http://www.oscommerce.com/community/contributions,146/page,3
  2. jloyzaga

    freeamount 3.3

    how to make this the only option when it applies? Also, how to contact author Florian Straub? as he says to send him email with questions but I cant find him as a member
  3. jloyzaga

    ups - free until over 5 lbs

    just found this http://www.oscommerce.com/community/contri...arch,freeamount
  4. Client wants free shipping up to 5 lbs and over $100 , and then over 5lbs and there is shipping costs as per ups ground rate. How to configure?
  5. jloyzaga

    EZier New Fields

    I am using this contrib but it does not show decimal places but my other product displays do show decimal places - is there a setting I have not changed??? Thanks Joe
  6. Dont know the setup for this in US - can someone give me the codes and if they can tell me an example of price from a zip code - trying to do this for Us but I'm from AUS!!!
  7. jloyzaga

    free shipping for price and weight

    will it checlk against weight too?
  8. jloyzaga

    Table Rate Type of Shipping.

    So could these contribs allow me to ba able to charge free shipping on items greater than $100 but less than 5lbs in weight? Joe
  9. How do I only allow free shipping for orders over $100 AND 5lbs or under?
  10. jloyzaga

    USPS flat rate? possible

    I have a client - They want to see that the cart can do this : Orders tha total from 5.95 - $100.00 are UPS 2-5 BUSINESS DAYS.. AND orders that are more than $100.00 GET FREE SHIPPING up to 5lbs in weight. Now I thought of rebadging the Flat Rate or another method to SHOW USPS but actually calculate using the above formula. Questions. 1- Do I use USPS and try to modify it to work as above? 2- Do I use another Shipping method and how to configure it? 3- Do I NOT use either of above because there is a contrib? Any assistance is appreciated Thanks Joe
  11. This report is for a year's worth of sales figures. How do I make it for 18 months? Is there a way I can make that a parameter? or chosen by dropdown menu? Joe
  12. I have a site that allows 2 types of users and they use 2 different login buttons. What I need is to be able to give 1 user type (probably the one that uses the guest account contrib) their own set of products and prices then I need to give the franchisees their own login ids but all franchisees have another set of products and prices. the guest account users(the general public) cannot see the franchisees products or the prices. Is there a contrib or a suite of contribs that could do the job? bsb suite and guest accounts? Joe
  13. Below is the query that selects the orders I want to also select on specific manufacturer. This means I need to select the product table using the o.products_id =p.products_id link and then only select on p.manufacturer_id = 1. Can anyone show me the query mods for below?? $sales_query_raw = "select sum(ot.value) gross_sales, monthname(o.date_purchased) row_month, year(o.date_purchased) row_year, month(o.date_purchased) i_month, dayofmonth(o.date_purchased) row_day from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where "; if ($HTTP_GET_VARS['status']) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $sales_query_raw .= "o.orders_status =" . $status . " and "; }; $sales_query_raw .= "ot.class = " . $class_val_subtotal; if ($sel_month<>0) $sales_query_raw .= " and month(o.date_purchased) = " . $sel_month; $sales_query_raw .= " group by year(o.date_purchased), month(o.date_purchased)"; if ($sel_month<>0) $sales_query_raw .= ", o.date_purchased"; $sales_query_raw .= " order by o.date_purchased desc"; $sales_query = tep_db_query($sales_query_raw); $num_rows = tep_db_num_rows($sales_query); if ($num_rows==0) echo '<tr><td class="smalltext">' . TEXT_NOTHING_FOUND . '</td></tr>';
  14. trying to figure out how this works. Want to know where the code is that determines what is allowed in the admin area and how it gets the login id. Need to know this to make mods in my report that only allows orders to be displayed in the reports by the login id. I know what I'm doing - just can't find the code that does it. What I want to do is to link the group to a vendor's login. Then I will create an id in the product to indicate which vendor supplies this product. When any order reports are requested by that vendor by logging into the admin area - he will only see the reports because thats what his group allows. But the reports will also look at his login (thats why I need to know how to do above) and get the vendor code and only select order/sales details valid for his products. This gives me vendor reports that are available at call - I don't have to periodically run them and send them. Can ayone help with the above? Maybe the author of the contrib???
  15. trying to figure out how this works. Want to know where the code is that determines what is allowed in the admin area and how it gets the login id. Need to know this to make mods in my report that only allows orders to be displayed in the reports by the login id. I know what I'm doing - just can't find the code that does it. What I want to do is to link the group to a vendor's login. Then I will create an id in the product to indicate which vendor supplies this product. When any order reports are requested by that vendor by logging into the admin area - he will only see the reports because thats what his group allows. But the reports will also look at his login (thats why I need to know how to do above) and get the vendor code and only select order/sales details valid for his products. This gives me vendor reports that are available at call - I don't have to periodically run them and send them. Can ayone help with the above? Maybe the author of the contrib??? Joe
×