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

Thanks for your reply. You're right that they will only see one ground/home delivery quote. But the problem is that shipping address for customers with company names is residential address. So they're charged for ground shipping but I will be charged for home delivery by Fedex. I just did a test. A shipment is quoted $11.03 for ground shipping and $13.38 for home shipping. So that's a quite hefty $$ burden on me. If I can't find a perfect solution to this problem, I may have to find out the percentage of these cases and then add some surcharge to all Fedex shipments to break even. I do remember though on some website they put an option there for customers to choose if the shipping address is residential or commercial. Then a corresponding shipping quote is displayed. Don't know if this can be added on this Fedex shipping mod. Anyway, thanks so much for your help. Wendy :( :( :(

The ground shipping rate is different from home delivery I think. It is indeed cheaper. This means we will lose money on shipment with ground delivery. :( Wendy

I know probably I should ask this question under the Fedex realtime quotes thread but I noticed that thread is not quite up to date. I know there are some experts here on this topic so I'm posting it here. We mainly ship to residential addresses so we just enabled Fedex home delivery option (disabled the ground). Some of my customers have home based business so they put their business name in the Company name field. But when there is a company name in a customer's profile, Fedex automatically sets the delivery option to ground which is disabled in our system. So these customers don't see this option at all. They have to choose UPS ground option which is more expensive than Fedex. Here is the dilemma. We want to keep the company field to better know our customers but we also want them to be able to choose Fedex home delivery option. I like to know if anyone here is having the same problem and what's the best way to solve this problem. My guess is that if the cart doesn't pass company name field to Fedex server then Fedex would treat the address a residential address and therefore show the home delivery option. But I'm not a programmer so I don't know where to change the code. Thanks in advance. Wendy

TheJackal, Thanks so much for your quick reply. In my case, there are usually multiple items in one order and we normally ship them together in one package. I meant to show the declared value in the optional field and also pass it to Fedex. For example, the total value for an order is $102. I like to see this in the optional fields with default of $102. If I want to, I can change it to another value, say $100 and I also like $100 to be passed to Fedex site. I guess it's like the weight. The default is the total weight calculated from the order. But you can also change it to a new weight. The new weight will be sent to Fedex. Thanks a lot. Wendy

Thanks so much for the timely update. Great job. :) I just upgraded from v1.03 to v1.07 and then today's v1.08. It went smoothly except for one thing -- the Number of packages. Somehow it adds quantities of all items in the order and use that number as Number of packages. Obviously it's not correct. I've tried to manually change the code to "1" for the number of packages. But in the long run, I like to find a better solution to this so that I don't have to change the code with every upgrade. Another question I have is the value of package. I see now there are Optional fields and I only use one of them. Is there any easy way to change one of the optional fields to the declared value of the package? The default could be the actual total of the order. But in some cases, it's good to have the option to change it easily. For my case, my total is always around $100. For the ones a little bit over $100, I only want to declare $100 so that I don't have to pay for the additional insurance. Thanks. Wendy

Oh, please delete my previous post. Right after I posted my message, I went back and took a look of the readme file again. It was such a stupid mistake. I should have read this that the USPS Label Shipping is to send package to shipping address! Well, I guess i paid my price for not reading it thoroughly. :( Sorry about that. I don't know how to delete the post. Wendy

This is a great contribution and it has saved me tons of time and mouse clicks. Recently something hit me really bad -- address issue. I noticed that the shiping address passed to USPS website is actually Customers address, but not their shipping address. In >90% cases, the Customers address = Shipping address. However, the longer you run the store, the more chances of customers moving. Then their addresses change. I found that my customers usually don't change their Customer's address after they move. They simply put the new address as Shipping Address. This is perfectly fine. However, when I used this contribution to generate labels, their old address was printed. I first noticed this problem (costed me to resend the whole order) and then thought probably I could just check the labels every time to make sure the right address is passed. Afterall in majority cases the address is the same. But I failed. I was in a hurry to get orders out this afternoon and printed labels without double check. I was then informed by a customer that in the email notice sent from USPS the address on the label is wrong. That's her old address. Arhh, another cost of sales. :angry: So I think it's better to fix this problem rather than relying on manual check of addresses. Has anyone here notice this problem or has a solution already? I know it should be quite easy, may just need to change a few things to get the address from Shipping Address not the Customers Address. But I don't know where to change. Your help is truely appreciated. Wendy

Hi, I'm still using v.1.03. I just noticed one little problem with the insurance. Our Fedex shipping orders usually value around $100, sometimes less sometime more. If it's more than $100, I just declare $100 value so that there is no additional insurance charge. With the automated fedex label contribution, the full value from the order is passed to Fedex so I always have to pay $1.2 extra for the declared value. Is there any way to alter it so that the maximum value doesn't exceed $100? Thanks. Wendy

Thanks so much for your help. I'm just curious what kind of email address never goes down, Yahoo, Hotmail, Gmail or the email address on your hosting company. I'm trying to figure out which one I should use. I'm now using the one on our hosting company server. Thanks. Wendy

I just noticed that some credit card transactions through Authorize.net got "General Error (unable to send notification)" message. And the worst part is that these orders are showing credit card payment received status. I generally don't check my Authorize.net website for each order. So I ended up sending orders without gettting the payment. I have to contact customers one by one to get their payments. I don't know how many will pay. Even they do pay, it's such an inconvenience to them. I did an search on this forum and saw similar problems posted back in August, 2004. There is no recent ones. So do people here still experience the same problem or this problem has been solved. If it has been solved, could someone point me to the right direction? Thanks so much.