Jump to content

cmkelly29

Members
  • Content count

    28
  • Joined

  • Last visited

  1. cmkelly29

    EZ QuickBooks Integration Contribution

    Hello, I am having one huge problem with this. I ran the query, set all the files into their homes, and followed the modifications to the T. The problem I'm having though.. It's not showing up in my main admin page. There's no Quickbooks option anywhere. I can access the .php's by manually typing in the URL, but that's it. I run MindSparx Admin, is that a problem? If anyone has any ideas, I would really appreciate it. Thanks guys.
  2. cmkelly29

    New UPS XML Shipping Module available

    Ahh thank you! I was using cost-actions, and I'm pretty sure that is what flubbed me up. Many thanks, Berta.
  3. cmkelly29

    New UPS XML Shipping Module available

    Quick query: Lets say I have an item that is (11 x 11 x 7). I can fit 6 of these items into my largest box (23x22x22). If a 7th item is ordered, it will send it into a separate box, which is what I want. The problem is that it's trying to fit it into another LARGE (23x22x22) box, when it really only needs to be in a (12 x 12 x 8) box. If this makes any sense, how can I fix this?
  4. cmkelly29

    New UPS XML Shipping Module available

    Jan, what I had meant was that I would enter the LWH into the listing. I would then save the listing and exit. When I would go back to look at the same listing, the L, W, and H fields would be blank again. However, I've figured out that the dimensions have actually been saved. They just aren't appearing in the fields. I don't know if that makes any more sense.
  5. cmkelly29

    New UPS XML Shipping Module available

    Nevermind! I figured it out :)
  6. cmkelly29

    New UPS XML Shipping Module available

    I'm using the full dimensional support, but the dimensions are not being saved in the listings. How can I fix this?
  7. cmkelly29

    [Contribution] Mindsparx admin

    Hello, I'm trying to add a dropdown menu to the header (fot my Quickbooks Integration contrib). When I add the menu to the header, it pushes the language selection to the very top of the page and off of the blue header. Any ideas?
  8. cmkelly29

    EZ QuickBooks Integration Contribution

    Bog, thanks for the help. I actually managed to fix the problem. I removed and reloaded the sql and voila!
  9. cmkelly29

    EZ QuickBooks Integration Contribution

    Actually, I'm ok there now. I've having 2 different problems now, if anyone would be so kind as to help out. Once I've imported my item.iff file, I get this: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'H X 20'W 2MIL BAG'' at line 1 select products_id, products_model, products_quantity from products where products_model ='24'H X 20'W 2MIL BAG' and when I try to export from oscommerce I get this: 1054 - Unknown column 'is_exported' in 'where clause' SELECT orders_id FROM orders where is_exported = 0 [TEP STOP] Any help would be appreciated. Thank you.
  10. cmkelly29

    EZ QuickBooks Integration Contribution

    Hello, I've just downloaded this contribution and I'm trying to import my .iff file to oscommerce through "update products." However, when I try to import the file, it's giving me this: Error: Destination not writeable. I'm new to osCommerce and Quickbooks, so any help would be GREATLY appreciated. Thank you!
  11. cmkelly29

    I don't have an install folder...

    Hey I fixed it! I just went through all the changes I had made, cleaned them out, and started fresh. Thanks for the help.
  12. cmkelly29

    Official PayPal IPN Support Thread

    I've uploaded all files properly to my knowledge, yet PayPal IPN is not showing up in my admin>modules>payment area.
  13. cmkelly29

    I don't have an install folder...

    back to top Installing the PayPal IPN If you already have a version of this PayPal IPN module installed, then you will need to remove the IPN from your admin area first (by clicking "remove") before following the steps below. Copy the files in the directory structure set in the contribution download file to your osCommerce installation directory inc. the new /ext/ folder. Make any changes you need to the language level files. In catalog\includes\functions\general.php Find the ENDING: ?> Insert this BEFORE: // START DELETE TEMP PAYPAL IPN ORDER // This is used in shopping_cart.php when a temporary order needs to be deleted // after it was cancelled by customer on paypal site. function tep_remove_order($order_id, $restock = false) { if ($restock == 'on') { $order_query = tep_db_query("select products_id, products_quantity from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($order = tep_db_fetch_array($order_query)) { tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = products_quantity + " . $order['products_quantity'] . ", products_ordered = products_ordered - " . $order['products_quantity'] . " where products_id = '" . (int)$order['products_id'] . "'"); } } tep_db_query("delete from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); tep_db_query("delete from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); tep_db_query("delete from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "'"); tep_db_query("delete from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$order_id . "'"); tep_db_query("delete from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "'"); } // END DELETE TEMP PAYPAL IPN ORDER In catalog\shopping_cart.php Find this: $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SHOPPING_CART)); Insert this AFTER: // START DELETE PAYPAL TEMP ORDER // Check to see if customer has cancelled a paypal_ipn process if ( $HTTP_GET_VARS['ipn']== 'cancel_ipn' && tep_not_null($HTTP_GET_VARS['order']) ) { // Make sure that this order is THIS customers' order // We don't want anybody to pass order numbers to here and delete other people's orders!!!! $delete_order_query = tep_db_query("SELECT customers_id FROM " . TABLE_ORDERS . " WHERE `orders_id`='" . (int)$HTTP_GET_VARS['order'] . "'"); $delete_order = tep_db_fetch_array($delete_order_query); //echo "DEBUG - delete_order=".$delete_order['customers_id']."<br />"; //echo "DEBUG - customer id in session=".$customer_id."<br />"; if ( $delete_order['customers_id']==$customer_id ) { // Delete the order //echo "DEBUG - about to delete order!!!<br />"; tep_remove_order($HTTP_GET_VARS['order'], ''); } } // END DELETE PAYPAL TEMP ORDER Go to the Administration Tool->Modules->Payment section at your osCommerce Administration Tool. Install the PayPal IPN module and configure its parameters. Note: The module is disabled by default so configuration can occur during the operation of a live store.
  14. cmkelly29

    I don't have an install folder...

    I've figured out the whole "public_http" being my "catalog" I've uploaded all of the neccesary files to their respective folders. I've added the codes that came in the instructions. PayPal IPN is not showing up as an option in my Admin>Modules>Payments list. I don't know where I've gone wrong.
  15. cmkelly29

    I don't have an install folder...

    I've done the install properly (I had to create the ext folder, is that ok???) It's still not showing up in my modules. I'm sorry for the "noobness."
×