Jump to content

GMSJohn

Members
  • Content count

    91
  • Joined

  • Last visited

  • Days Won

    1

GMSJohn last won the day on October 24 2011

GMSJohn had the most liked content!

1 Follower

Profile Information

  1. GMSJohn

    QBI Quickbooks Import

    Thanks Adam, My QBI export status is set to "Any" as it has always been. I went into the ORDERS table, and looked at the qbi_imported value. For the record that keeps exporting, the value is 2. It should really be a 1, correct (previous batch). My new orders that I wanted to export were a 1 (should be a zero). I reset the orders I wanted as new orders to a 0, and the last order that keeps exporting to a 1 in the database. I then exported all new orders. The numbers updated in the table - the previous batch went from 1 to 2, and the new batch went from 0 to 1. The exported file still contained the single record that used to be the previous batch. The Admin area updates to reflect what the table says. I just can't seem to get those records out. I am baffled! :'( Thank you for your patience in trying to help troubleshoot this problem. John
  2. GMSJohn

    QBI Quickbooks Import

    Hi Adam, Thanks for your suggestions. I was pretty sure about the files, but just decided to double check for sure. All order files exported contain only the one order (My Invoice 1316 from 12/18/2006). The New orders display is showing Zero orders right now. The "Previous Batch of Orders" is showing the last 4 orders (1317-1320, from 1/11/2007 to 1/21/2007), but those are the orders I never got to export. Exporting the previous batch again only shows the single invoice 1316. "All Previous Orders" is showing all the invoices UP TO and INCLUDING 1316. Exporting that file again results in just the single order invoice 1316 coming through. The orders are showing up in the order screen in Admin, so I am pretty sure they are still in the database :) . Could the "Previous Orders" counter be messed up or something? I appreciate any insight you may have on what to look for next. Thank you again for your help! John
  3. GMSJohn

    QBI Quickbooks Import

    Sorry, originally posted this question to the wrong forum: I just tried to export my latest 4 orders from QBI 2.10c using the "Export New Orders" button. When I attempted to import them into QB, I got a warning that "That invoice number exists". Upon opening the IIF file in notepad, sure enough, the one invoice that I imported last was the only one in the IIF file. No other orders were shown. I then tried to export "Previous Batch", and then "All Previous Orders", and each time the IIF file only has the single order (the last one I exported) in it. Any thoughts on what might be going on? I have not made any changes to my system recently, although my web host upgraded mySQL and PHP, but I can't recall if that happened before or after my last import. Everything else seems to be working fine. I do not get any type of error messages. Thanks for your help! John
  4. I just tried to export my latest 4 orders from QBI 2.10c using the "Export New Orders" button. When I attempted to import them into QB, I got a warning that "That invoice number exists". Upon opening the IIF file in notepad, sure enough, the one invoice that I imported last was the only one in the IIF file. No other orders were shown. I then tried to export "Previous Batch", and then "All Previous Orders", and each time the IIF file only has the single order (the last one I exported) in it. Any thoughts on what might be going on? I have not made any changes to my system recently, although my web host upgraded mySQL and PHP, but I can't recall if that happened before or after my last import. Everything else seems to be working fine. Thanks for your help! John
  5. GMSJohn

    Multi_Vendor_Shipping new thread

    Trying to get a "Low Order Fee" working with MVS, and can't seem to get it to add in. I am setting it via the Order Total Module, but it does not add it at checkout. Does this need to be done differntly in MVS, or do I need to look at something else going on? Thanks for any help you might be able to give! John
  6. I was browsing through my "Last ten visitors" today, and came across these entries: My question (and concern) is the landing pages in these examples. Obviously, it looks nothing like any page in my store, but when I see parts of it that say things like "chmod%20744%20gicumz;" it makes me worry that this is a hack attempt of some type. Does anyone have an idea of what might be going on here? Are thes legitimate URL's, or am I "UNDER ATTACK!" ?! Thanks for this awsome contribution! John
  7. I recently encountered what I believe to have been my first fraudulent order :x Luckily I hope to have corrected the situation, but I learned a valuable lesson in the process. The customer had entered an invalid shipping address. Everything must have matched for Authorize.net AVS to check (they only check the first 4 digits of the address, and the 5 zipcode digits), but when UPS attempted delivery, the address was bogus. Further research showed that the customer entered CA for the state, but the Zip was for Alabama! I now waste extra time and effort to manually verify addresses before shipping. Lesson Learned :blush: . Now to the heart of my question, has anyone written or used the UPS Address Validation tool on their setup? You can find it at http://www.ups.com/e_comm_access/laServ?lo...AddrValidateXML. Here is a snip from their text: It would be nice to see this integrated into the checkout process to catch bad addresses. It should work no matter which shipper you use, the person's address is still the same. I have some PHP skills, but absolutely no XML, let alone time to write this module. If there is anyone out there that has the skills to write this, I think it would be a tremendously valuable addition for the community! I would be glad to Beta test it for whoever can write it! John
  8. GMSJohn

    Multi_Vendor_Shipping new thread

    That is strange. I have both UPS and USPS set up under one of my vendors, and both are offered at checkout. Hmmm... John
  9. GMSJohn

    Multi_Vendor_Shipping new thread

    I had this issue also, and Craig was going to look into it. See post here at post #1121 I haven't been able to locate the problem yet, and I don't know if Craig has had a chance to dig into it yet. Did you recently install the Milestone update? I wonder if that is causing issues. Perhaps someone who hasn't installed the update yet could test this and see if they can duplicate it. That might narrow it down to the changes from that update. John
  10. GMSJohn

    Multi_Vendor_Shipping new thread

    In case anyone else uses the Quickbooks Import QBI contribution with MVS, I have posted a solution to import your vendor product cost and vendor names into QuickBooks on the QBI support thread here. Hope this helps others that may be trying to do the same. Regards, John
  11. GMSJohn

    QBI Quickbooks Import

    For anyone who is using the Multi-Vendor Shipping contribution, and wants to get your vendor cost and preffered vendor into Quickbooks using the QBI import function, here is the code to change in Admin/Includes/qbi_engine_prod.php: Change Line 38 from: $resultpd = tep_db_query("SELECT * FROM ".TABLE_PRODUCTS." AS p, ".TABLE_PRODUCTS_DESCRIPTION." AS pd WHERE p.products_id=pd.products_id AND language_id='$languages_id' AND qbi_imported='$qbimported' ".$whereclause."ORDER BY products_model"); To this: $resultpd = tep_db_query("SELECT * FROM ".TABLE_PRODUCTS." AS p, ".TABLE_PRODUCTS_DESCRIPTION." AS pd, ".TABLE_VENDORS." AS v WHERE p.products_id=pd.products_id AND v.vendors_id=p.vendors_id AND language_id='$languages_id' AND qbi_imported='$qbimported' ".$whereclause."ORDER BY products_model"); Find this section (Line 60): // Loop through each product do { $prod_id=$myrowpd["products_id"]; $prod_price=round($myrowpd["products_price"],2); $myrowpd["products_tax_class_id"]>0 ? $ptaxable="Y" : $ptaxable="N"; $prod_prefix=""; $prod_name=$myrowpd["products_model"]; $prod_desc=$myrowpd["products_name"]; $prod_quan=$myrowpd["products_quantity"]; And add below the "$prod_quan=$myrowpd["products_quantity"];": $prod_cost=$myrowpd["vendors_product_price"]; $vendor_name=$myrowpd["vendors_name"]; Now find this section (was Line 69, should be Line 71 after the last change): $prod_data.="INVITEM\t$prod_name\t$item_type\t$prod_desc\t$prod_desc\t".ITEM_ACCT."\t".ITEM_ASSET_ACCT."\t".ITEM_COG_ACCT."\t$prod_price\t0\t$ptaxable\t\t\t\t\t\t$prod_quan\t\n"; And change to this: $prod_data.="INVITEM\t$prod_name\t$item_type\t$prod_desc\t$prod_desc\t".ITEM_ACCT."\t".ITEM_ASSET_ACCT."\t".ITEM_COG_ACCT."\t$prod_price\t$prod_cost\t$ptaxable\t\t\t\t$vendor_name\t\t$prod_quan\t\n"; Now when you import the qbi_prod.iif file into Quickbooks, your vendor cost and preferred vendor will be populated! Hope this helps someone else. John
  12. GMSJohn

    QBI Quickbooks Import

    Thanks Adam. I totally understand the need to prioritize. I am glad you got this out for everyone to use, it sure has made my life easier so far! Any thoughts on the shipping tax status only being set by the checkbox in QBI versus handling it the way products are? I can work around it by manually changing it on each invoice in QB, but sure would be nice if it could come in with the status based on the customer's tax status. I continue to play with the query to pull the vendor name from the separate table, too. If you have any pointers on how to form that, I am all ears! Thanks again for a great product, and your great support! John
  13. GMSJohn

    QBI Quickbooks Import

    One more item while I'm at it. I am using the Multi-Vendor Shipping contribution, and as such, have my vendors associated with each product in the database. I need to rewrite the query for the qbi_engine_prod.php file, but can't seem to get it right. The vendor has an id in the PRODUCTS table (vendors_id) which is associated with the same field in the VENDORS table. I need to pull the vendors_name field from the VENDORS table for each product. Here is what I have for the query, but obviously it doesn't work. Any idea how tyo correct this? I am not the best query writer, so any help in pointing me in the right direction would be appreciated. You can see I have added the vendor's name to the product loop through and the add product line sections also. // Read product data (ITEM_ACTIVE==1) ? $whereclause="AND products_status='1' " : $whereclause=""; $resultpd = tep_db_query("SELECT p.*, v.vendors_id, v.vendors_name FROM ".TABLE_PRODUCTS." AS p, ".TABLE_PRODUCTS_DESCRIPTION." AS pd, ".TABLE_VENDORS." AS v WHERE p.products_id=pd.products_id AND v.vendors_id=p.vendors_id AND language_id='$languages_id' AND qbi_imported='$qbimported' ".$whereclause."ORDER BY products_model"); // Check for products if ($myrowpd=tep_db_fetch_array($resultpd)) { // Open output file $handle=fopen("qbi_output/qbi_prod.iif", "wb"); // Create iif header $prod_data="!INVITEM\tNAME\tINVITEMTYPE\tDESC\tPURCHASEDESC\tACCNT\tASSETACCNT\tCOGSACCNT\tPRICE\tCOST\tTAXABLE\tPAYMETH\tTAXVEND\tTAXDIST\tPREFVEND\tREORDERPOINT\tQNTY\tEXTRA\n"; // Set item type if (ITEM_IMPORT_TYPE==2) { $item_type="SERV"; } elseif (ITEM_IMPORT_TYPE==1) { $item_type="PART"; } else { $item_type="INVENTORY"; } // Loop through each product do { $prod_id=$myrowpd["products_id"]; $prod_price=round($myrowpd["products_price"],2); $myrowpd["products_tax_class_id"]>0 ? $ptaxable="Y" : $ptaxable="N"; $prod_prefix=""; $prod_name=$myrowpd["products_model"]; $prod_desc=$myrowpd["products_name"]; $prod_quan=$myrowpd["products_quantity"]; $prod_cost=$myrowpd["vendors_product_price"]; $vendor_name=$myprod["v.vendors_name"]; // Add product line without attributes $prod_data.="INVITEM\t$prod_name\t$item_type\t$prod_desc\t$prod_desc\t".ITEM_ACCT."\t".ITEM_ASSET_ACCT."\t".ITEM_COG_ACCT."\t$prod_price\t$prod_cost\t$ptaxable\t\t\t\t$vendor_name\t\t$prod_quan\t\n"; Thanks again, John
  14. GMSJohn

    QBI Quickbooks Import

    Well, I have finally gotten around to getting this contribution set up, and all seems to be going well. I have one (maybe two) minor problem so far, and trying to work the learning curve of Quickbooks and this, I haven't been able to figure it out yet. I have searched through the thread here and haven't seen an instance of this (although I might have missed it). Here is the situation: I have orders from both in state and out of state. In-state orders are charged sales tax on both merchandise AND shipping (Florida sales tax). This works fine on instate orders. However, when I have an out of state order, it is also coming in as shipping being taxed. This doesn't cause a problem with totals or anything, but when I pull my sales tax report, it is included in the taxable sales, which it should not. Products for out of state customers come in as non-taxable versus products for in state coming in as taxable, but I can't get shipping to do the same. When I set the checkbox in QBI to not tax shipping, then all orders are imported as non-tax. Is there a way to make the shipping work like the products? Did I miss something setting this up? Another issue, and I don't know if this is even possible, is the screwy way Florida does sales tax. They have a base rate of 6%, then each county has an additional tax of anywhere from 0.5% to 1.5%. I have these all set up in osC to calculate the tax correctly, but I only have the option to set one tax rate in QBI. Right now I haven't set up all the counties in QB, but if this is doable, I can set up QB with the county tax rates also. Is this something to look forward to in the next version? Thanks for your help, this is an awesome contribution! :lol: John
  15. Chris, et al, You guys are awesome! I have been wanting to add this contribution to my site for some time now, but with so many different versions and various issues needing resolved, I have been very hesitant to even attempt to install it on my modded store (70+ contribs) especially after reading through this thread. I have gained a great deal of PHP skills by installing all these contribs, but my skills are still somewhat limited and I don't think I would be much help here. I just wanted to say thank you for all your hard work as I patiently (albiet somewhat anxiously (w00t) ) await a stable (if that is possible in osCommerce) version. I realize it might be awhile, but totally understand. Thanks again to everyone who is trying to make this great contribution even better! :thumbsup: John
×