Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Bruce Crawford
  1. Just installed the new USPS 5.2.X on my OSC 2.2 site and it works fine and order editor work fine until then also. here is the error http://mysite.com/admin/edit_orders.php?oID=1943 Fatal error: Call to undefined function: tep_round_up() in /home/content/b/c/s/bcspadmin/html/includes/modules/shipping/usps.php on line 343 function does exist in includes/functions/general.php or my USPS module would not work. This was a minimal change over all to my site and ? Help
  2. bgc42169

    Official PayPal IPN Support Thread

    IPtrap 2.1 does not work with Paypal IPN,
  3. Hi all, Just spent the last few day integrating Margin Report 3.0A Actual Attribute Price 1.6 Detailed Monthly Reports 1.0a Paypal_IPN to work will all . Issue i had is that I need to account for the added cost that the Attributes added when selected. Margin Reports only work with Product cost. So i added more database fields to calculate the final_cost analogous to the final_price field. I like How Margin Reports added the cost in, but hated there report scheme. I like Detaild Monthly Reports 1.0a and integrated the cost, Shipping cost, and Paypal and Authorize.net cost into the report. I also like the functionality of Actual Atribute Price 1.6 but moded it to add the costs also. It is a extensive mode but works well but you need to be careful on the Atribute Prefix setting to get the prices just right. All this works with PayPal_IPN also to save the product_cost and final_cost I need to document it to make a Contribution. Just need to see if there is any interest. Bruce
  4. Damn, My eyes are really started to not work. Thanks. Bruce
  5. This is the part of the programing: $o[] = $orders['orders_id']; for($i=0;$i<sizeof($o);$i++) { $price = 0; $cost = 0; $items_sold = 0; $prods_query = mysql_query("select op.products_id, op.products_price, op.final_price, op.products_quantity, p.products_cost, op.final_cost from orders_products op, products p where op.orders_id = '" . $o[$i] . "' and op.products_id = p.products_id"); while ($prods = mysql_fetch_array($prods_query)) { //Changes for Margins Reports 3.1b change product_price, Product_cost to final_price and final_cost // $p[] = array($prods['products_id'], $prods['products_price'], $prods['products_cost'], $prods['final_price'], $prods['final_cost'], $prods['products_quantity']); // $p[] = array($prods['products_id'], $prods['products_price'], $prods['products_cost'], $prods['products_quantity']); if ($prods['final_cost'] == 0.000)( $cost = $cost + ($prods['products_cost'] * $prods['products_quantity']); //THIS IS LINE 87 in the code. $price = $price + ($prods['products_price'] * $prods['products_quantity']); $total_price = $total_price + ($prods['products_price'] * $prods['products_quantity']); $total_cost = $total_cost + ($prods['products_cost'] * $prods['products_quantity']); ) else ( $cost = $cost + ($prods['final_cost'] * $prods['products_quantity']); $price = $price + ($prods['final_price'] * $prods['products_quantity']); $total_price = $total_price + ($prods['final_price'] * $prods['products_quantity']); $total_cost = $total_cost + ($prods['final_cost'] * $prods['products_quantity']); ) $items_sold = $items_sold + $prods['products_quantity']; $total_items_sold = $total_items_sold + $prods['products_quantity']; } } I get a parse error at line 87 Unexpected ";" When i remove the if Else statement no problems. But i need this if statement. Can anyone help me ??? BRuce
  6. I have everything updating everything for the product_cost and final_cost fields. I even fixed an issue I found with PAYPAL_IPN to make it compatible. Only issue now when the product_cost and final_cost fields move from Product_attributes to order_products database, i getting an additional $0.40 added to the order. Check and i am not adding any tax to the costs. Anyone have any Ideas???????? Bruce
  7. Well i have update the database with the fields i need and added the code to the php i need to to calculate the final_costs for the attributes and original items. Now get an issue in the catalog/shopping_cart.php line 92 $attribute_values = tep_db_fetch_array($attributes); get error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/b/c/s/bcspadmin/html/includes/functions/database.php on line 99 Line 83 is redone to added one of my fields pa.options_values_cost, to the tep_db_query as the following: $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.options_values_cost, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $products[$i]['id'] . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); This field existed and is set in the admin/products_attributes.php Can anyone help me with this???????? Bruce
  8. Well, i have it saving the added cost of the Attribute to the database so admin\product_attributes.php admin\includes\languages\english\products_attributes.pho and database add attribute_cost to the database. Now i am having issues getting shopping cart and order.php to calculate the new item cost based on the new attribute Bruce
  9. Steve, Thanks, but dont you still need to have a database field for he added cost to the Attribute? Bruce
  10. I currently using Margin Reports 3.0a and working well but i need help integrating ATTRIBUTES cost on dfferent Items that have these options for the products i sell. If i can be guided in the right direction i can probably do it my self, just not a PHP programmer by trade.
  11. And if you read my post, i tried version 1.4- with the edits given in 3.33 DCC and the post about using aggregate. I did everything and tried 3 Versions of IPN and tried mimicking the checkout_process.php mods for DCC in IPN and still no go. I need help from anyone who has successfully go these two packages to work together. And i tried emailing the IPN author with no go and which do i do with DCC since it has morphed over the years????? Bruce
  12. Well, I have posted all i can for some help with DCC 3.3 and IPN 1.4- I have tried every combination and item and aggregate and nothing works. reviewed every post and contribution list saying anything about these two packages and can not get the discount to pass to the fields for IPN. HELP Please. Bruce
  13. Has anyone been able to get DCC to work with Paypal IPN 2.3? I tried the fix for 1.4 and it does not work for my version still only passes the full amount. Works fine with my Authorize.net AIM module. Or has anyone tried to get DCC to work with Paypal EC? Please any help would be appreciated. Bruce
  14. has anyone go DCC working with multiple coupons in the field? Bruce
  15. bgc42169

    Margin Report v2.10

    Is anyone doing any updates or adding features? I would but i not a PHP programmer to figure out all the database calls. I would like to see added Shipping costs ( entered per order after enter true shipping costs) Total shipping Shipping Margin Also add options to get 1st, 2nd, 3rd, 4th quarter results. Also output date of the order I have looked into what variables are where, i just cant figure out how to program it in. Bruce