wendys

I'm experiencing same problem. We don't offer first class letter option, only the parcel option. What happened to our shopping cart is that the customer can see the First Class Parcel cost. But when they select this option, and click Continue, they are given an error message -- there is an error occurred, please contact store owner. Can someone point out where exactly I need to make the change First-Class Mail to First-Class Mail Parcel? Thanks so much.

Tom, Could you please post what changes you have made to the usps.php file to get it work? I tried to replace all the First-Class Mail to First-Class Mail Parcel, but it did not work out (we don't offer letter option, so I didn't bother to change). Thanks so much.

I think we're having exactly the same problem. :angry: Our site was very unstable today so I contacted our hosting company. They informed me about this paypalipn_txn query and said that our site is using 200% of the CPU. I've no clue about the whole thing. Anyone has any idea? Wendy

Thanks for your suggestions. 1. Browser. I tried both IE 6 and IE7. Same problem. 2. I tried on different computers. Same problem. 3. I downloaded the latest USB driver from Fedex website. Still the same problem. I'm wondering what kind of label you're using, 4x6 or 4x6.75? I'm using 4x6 thermal labels and I set the page size to be 4x6. I read somewhere that Fedex sets the label to be 6.75 for customers to add notes/comments on the label. Did I remember it correct? Is that the cause then? Wendy

Thanks for this great contribution. I've used it for quite long and it really saved me lots of time. :thumbsup: I just upgraded to the most recently version that includes thermal printing capability. Everything works fine except for one little problem -- my Zebra thermal printer always print 2 pages for each label, one blank and one with the real label. I can see it under Print Preview as well. I've set Page Setup to 4x6 label size and with 0 margins on the borders. Has anyone experienced similar problem? Is there a solution to this? Thanks in advance.

Thanks so much Adam. It solved the problem. :thumbsup:

Hi Adam, My Qbi has been working perfectly till recently. I'm getting an error message saying 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 'oise' AND zone_country_id='73'' at line 1 SELECT * FROM zones WHERE zone_name='val d'oise' AND zone_country_id='73' I think it is orders shipped to France that caused the problem. I don't know if our hosting company has made any changes to SQL software. Please help me to fix the error. Thanks so much. Wendy

Adam, I haven't been here for a while (busy busy busy) and I'm so glad to hear that the next version is coming out soon. :thumbsup: :thumbsup: Thanks for your hard work. I don't know if anyone has mentioned about gift certificate payment yet. In QB, GC payment is considered a type of payment so it's not the same as discount. When I set up to match discounts/fees, the payment category doesn't show up so gift certificate payment can't be matched to the one in QB. I did manually added GC payment to database. But I'm still one step away from doing it right. The GC payment value has to be set to possible just as discounts do. This may involve some codes change I guess. If there is a solution to this problem, I sure like to know. :-) Thank you. Wendy

Ed, In file admin->qbi_products.php file, find: if (($iifitem["INVITEMTYPE"]=="INVENTORY" OR $iifitem["INVITEMTYPE"]=="SERV" OR $iifitem["INVITEMTYPE"]=="PART" OR $iifitem["INVITEMTYPE"]=="DISC" OR $iifitem["INVITEMTYPE"]=="OTHC") AND ($iifitem["HIDDEN"]=="N")) { in the first line add OR $iifitem["INVITEMTYPE"]=="ASSEMBLY" to make it look like: if (($iifitem["INVITEMTYPE"]=="INVENTORY" OR $iifitem["INVITEMTYPE"]=="ASSEMBLY" or $iifitem["INVITEMTYPE"]=="SERV" OR $iifitem["INVITEMTYPE"]=="PART" OR $iifitem["INVITEMTYPE"]=="DISC" OR $iifitem["INVITEMTYPE"]=="OTHC") AND ($iifitem["HIDDEN"]=="N")) { This will allow assembly item to be uploaded. But it's not done yet. You may take a look of your item.iif file on assembly items. For each regular inventory part item, there is just one line with all information included. But for assembly items, there are several lines. Among these lines, one line has identical structure as an inventory part. The current version of this contribution can only read one line so it doesn't work with multiple lines information. So I used Excel program to manually eliminate those extra lines and just leave one line (the one that's similar to an inventory part line) for each assembly item (an easier way is to sort assembly items by a certain column so that all the useful lines are together while the extra lines stay together for all assembly items). And save the file as item.iif and upload it to this contribution. This way the contribution is able to list assembly item and make it possible for you to match. I think it works the same as group item if you add group to the above code and manually change your iif file. This is definately not a smart way to do it. Adam is working on this. HTH Wendy

Adam, Thanks so much. It worked. :-) I was having time out problem with the order iif file so I put it in the order creation section and it worked. It can easily handle 500 orders at a time without any problem. I'm guessing order iif may be much larger than product iif. Since I have more than 1000 products, I found that when matching products it takes much less time if the listed products are sorted by product id rather than product model. I then found the merit of this contribution that if the product name is the same in OSC and Quickbooks, I don't have to match at all. I also took a look at the Assembly option. I think assembly is much easier to handle than Group. Assembly is basically an item you have to manually build in advance. Once you build it in Quickbooks, it has nothing to do with the components any more. So it actually is one item. In iif file, assembly has extra lines to include all the components. But the contribution can certainly just ignore those lines and take just one line which is the same as a regular item. This may not take much work. Too bad I don't have any programming knowlege other than copy/paste and comment out lines. :-( What I did in my situation is to alter the iif file manually to elimate those extra lines and make it look same as a regular item. I changed one place in the code to allow assembly type to be uploaded. Then assembly items were loaded properly and ready for match (I will PM you a file with assembly item a little later). The tricky part is the group item I think. Group is similar to assembly but it assembles on fly, that is when an group item is posted, it actually posts its components. I'm guessing you may have to add extra tables or at least extra columns to handle group items. Again, thank you for such a great contribution and your constant technical support. Wendy

Yes, that's in the Readme file. You need to create 2 folds under Admin, qbi_input and qbi_output and make them 777. HTH Wendy

I used ftp software such as WS_FTP or maybe smartftp (not sure about the name) to manually upload the list.iif file to the admin/import folder. I know that if your webhosting company has cpanel, you may upload it from File Manager as well. I don't know if this answers your questions. Wendy

Adam, Thanks for your quick reply. :-) Sure I can send you product iif file for testing. I'm using premier version and would love to test code for you. One suggestion for this contribution is that when create iif file for orders, is it possible to let the user decide for orders xxx to orders xxx. I have a couple of thousands of orders to export and haven't had a success yet since it takes too long and the admin section automatically logged off before it even completed. I'm switching from Peachtree to Quickbooks so I'm quite new to Quickbooks. Is it true that quickbooks can't export transactions? I didn't see transactions as an option under Export section. I was just trying to see how an assembly looks like in a transaction in iif file but seems like Quickbooks can't export transactions to iif file. Wendy

Adam, Thanks so much for this great contribution. I just installed the contribution and so far it works fine. I'm in the matching products stage. I have more than a thousand of items so it would be quite a while. One thing I noticed is that assembly is not uploaded. Does that mean this contribution doesn't support assembly? If so, do you have any plan on upgrade the contribution? Sorry for sounding pushy. I'm trying to decide what should I do with those assembly items. I have lots of them. Is there any way to work around it? TIA Wendy

djmonkey1, Thanks so much for your help. I finally took the plunge and bravely took a look of the fedex1.php file (I'm not a programmer). switch (substr($type,0,2)) { case 90: if ($order->delivery['company'] != '') { $skip = TRUE; } break; I commented $skip = TRUE; to ignore the company check and it worked. Now Fedex shipping can quote residential address even with company information filled. Wendy :P :lol: :lol: :lol: :P :P