ACE99

It appears that MasterCard debit cards are not passing the cc_validation.php script in our store, however our credit card processor accepts them just fine. This really worries me that some newer credit cards may be rejected by osC when they are actually valid. I only know about the MC problem, but other cards may be rejected as well. Does anyone know if there is an update for the cc_validation.php file or are there any new card numbers that we should be aware of? We use authorize.net.

I added package insurance to my checkout, and the problem is that it's not downloading correctly into Quickbooks using the QBI import. The problem I think is that QBI is trying to treat the package insurance cost as a discount, when in fact it isn't. How can I make it so that something like package insurance is downloaded correctly?

Hey everyone, I found an error when importing sales receipts. Apparently, the 2nd address line is not being imported if you do sales receipts, but it does import if you use invoices. Has anyone else found this to be true? Any ideas on how to fix it? Also, all of my products have attributes, but I have modified my store so that each attribute has it's own unique price, weight, cost, inventory amt, etc. The reason I did this is because I sell for example a liquid product, and it comes in a pint size, quart size, gallon size, etc, and all of those I consider comletely different products. So it's almost as if I've created a system where there is one "MASTER product" and then "slave products" under the master one. What I'm wondering is if these will input just fine into Quicbooks as items and subitems? Each product has several attributes (or "sub-products") but I think it only goes one level deep.

I appreciate your reply on how to set a declined order as "declined" in the db. However, I was wondering, is there any way to prevent authorize.net consolidated from even recording a declined order in the first place?? I know this is the QBI forum, but you seem to know a little about this.

Adam, I also tried that fix that you posted that supposedly fixes the rounding error. It doesn't seem to be working for me either. I'm using the latest version of QBI. I'm wondering though, why don't you just copy the total for the order straight from the database? If we know that osc is totalling the order correctly, then why not just copy that number straight over into the QBI import file? Then we'd never have balance errors again. I thinks it's a mess having QBI try to do calculations when we already have all of the correct #'s. Or am I wrong? One other request --> when doing invoices and payments, is there anyway that you can have QBI automatically check the invoice as PAID? I'm getting QBI to record the payments, but then I have to go into the "customer payments" screen in QB and check off each invoice record individually (you actually click with the mouse and add a check mark to mark the invoice as paid). It would be awesome to have that option. One less thing for me to do! BTW, this program is amazing and I really appreciate your efforts to help and support your users. We really appreciate it.

Adam, 1. I just added your fix that you posted a few pages back that is supposed to remedy the out of balance errors when sales taxes are charged. Hopefully that will fix our problems. Thanks for helping us all out so much! 2. I'm using Authorize.net consolidated for Aim and I'd like the payment card type to be imported into quickbooks. For example, if someone uses a visa card, then the payment type will be imported into QB as "VISA". Then, when we reconcile, it will be so much easier because the invoices will be batched by cc type. Can you help me with this? Also, Authorize.net Consolidated has a problem in that is logs orders in the orders table even though the card has been declined. You mentioned a few posts back that you can create a "declined" status and then tell Authorize to mark declined transactions as "declined". How do I do that? I know how to create new statuses, but how do I tell authorize.net to mark it's declined transactions as "declined"? Thanks everyone!

When I try to click on a subcategory or try and search for a faq, I keep getting the following error (this happens on the catalog side): 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 'limit 0, 20' at line 1 select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.products_id, pd.products_info, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '60' order by limit 0, 20 What could be wrong?

Hey everyone, I just installed the newest version of USEO Urls (I was running 2.0), and it seems to be slower than the last version. I'm figuring this is because there are now mod rewrites for articles and other pages. I find my store significantly slower. Anyone else?

Update - Ok, about the tax being off 1 cent... It appears that it is always off 1 cent, even if the customer chooses free shipping. If tax is charged, the .iif file is showing it as 1 cent below what it should be. So on the checkout confirmation screen it may say that tax is .60. But the .iif file will show the tax as .59. Thanks!

Adam, One other problem--> How do I import the customer name as just "Last Name, First Name" ? I know that isn't the best way to do things, but I need to because I have 1500 customers in quickbooks in that format already, and now QBI keeps creating new customers every time I import.

Adam, I'm gettting a out of balance error when I try and import as a sales receipt into QB, and after looking at the .iif file in Excel, I've determined that it is because the sales tax is always 1 cent off, and I think it only happens whenever the customer chooses a shipping method besides free shipping (which is of course $0.00). How could this be? Why is the tax off only 1 cent? If I can get this error licked, I'll be set!! Thanks!

FIX: Add an attribute's actual weight to the cart for checkout and shipping To xtech and others who are trying to set a weight for an attribute: The only problem with this contribution is that it doesn't account for weights. So I came up with this fix. What this does is allow you to assign specific weights to each attribute. When you select an attribute product for purchase, that attribute's weight is added to cart (for shipping calculations) WITHOUT BEING ADDED TO THE PRODUCT'S ORIGINAL WEIGHT!!! The product's base weight is replaced with the weight of the attribute! Before proceeding make sure you already have the Actual Attribute Price mod correctly installed, as this edits one of it's lines of code. STEP 1: Install the contribution: "Add Weight To Product Attributes v0.2" STEP 2: In catalog/classes/shopping_cart.php: Find this line: $this->weight += ($qty * $attribute_price['options_values_weight']); And replace it with this line: $this->weight += ($qty * $attribute_price['options_values_weight'])-($qty * $products_weight); That's it!! I've tested this in every scenario possible, but there is still a possibility for error.

STS FIX FOR SEF AND Ultimate SEO URLs I just uploaded a fix to the contributions section that fixes a little problem I've been having when using Ultimate SEO URLs + STS. Hope it helps!

Im having a problem using this contribution with the Simple Template System (STS). I set up everything and it's working the urls are being rewritten. However, if I try to jump to a sub-category then it gives me a page not found error. For those of you that are familiar with STS, if I use a variable such as $urlcat_1_21 for a subcat, then Ultimate SEO URLS rewrites the url like this: http://www.mysite.com/clothes-c-21.html_37 How do I get it to display like this: http://www.mysite.com/clothes-c-21_37.html Please help.

Ok I need some really good STS/PHP programmars to help me with this little dilemma: I want to create several sts variables similar to the $content variable that will allow me to put the products from several different sub-category pages all on the main category page. For example, suppose I had a main category called clothes, and under that I had sub-categories called shirts, shoes, and pants. How can I make variables like $content_shirts, $content_shoes, $content_pants, that will take their respective subcategory products and put them in a product list on the main page clothes? It doesn't seem like this would be too complicated. I've already hacked the dickens out of STS like you guys wouldn't believe, but this one kind of stumps me. Please help! :)

Ok, update. My invoices are being imported, but with balance errors. I have a tax account called "Out of State" and it isn't set to any tax% at all, it is just left blank. The only problem is, if you leave the tax% field blank in the QBI config, it just puts a 0 in the IIF file. I don't know if that might be cuasing a problem. Also, the "VIA" pulldown menu on the invoice says "Method not set", but it should say FedEx. I matched up the shipping using the match shipping in QBI. On my store, we only offer FedEx. So if someone chooses anything else besides free shipping (they have to spend over $25 to get free shipping) then it should say FedEx. unfortunately, it just says "method not set". Also, I would like the Shipping Description to say "Shipping and Handling" And finally, when I check the "import as sales receipt" option, and then I look at the output in Excel, the IIF file still is creating invoices and putting them in the Accounts Receivable account. I'm confused as to why the "sales receipt" option isnt working. Wish me luck, and thanks for any help!

I can't see how everyone is getting this program to work but me!! I'm still getting balance errors. I'll just have to wait until a more complete user guide comes out. Adam, I was wondering if you could update the guide sometime and put very clear explanations of where to find all of the accounts, names, classes, etc, for every field in the configuration. And also explain if the fields can be left blank, etc. I think that would really help me. I did manage to get some invoices to import (even with errors), but the sales receipt option doesn't work at all for me.

Adam - Thanks for the reply. Actually, I didn't put the "%" sign in the tax field. I just put it in the post that way by accident (sorry)! Well, I've tried importing the orders into QB with the tax option checked and unchecked, and both ways it fails. I think the problem must be that my tax name, agency, and class don't exactly match. Could you please tell me where exactly in QB to find this info? And where in QB do I find the item account, item class, etc? I know a few of these fields, but I had a QB accountant help me set up everything months ago and so I've forgotten a few of these things or don't know exactly where to find the details in QB. Thanks!!! PS- So I'm wondering, does QBI create a new IIF file on the fly everytime you download new/previous orders? IOW, if I make changes to the configuration, and then go into the utilities section and download the "previous" orders, will it apply the new configurations settings when it creates the IIF file again?

Are there any settings that need to be set in QuickBooks for this contribution to import correctly? Perhaps I'm getting errors because of an incorrect setting? Such as class tracking, etc? I'm going to look at my IIF file in Excel and see if I can figure out the problem. Adam, I will give you a nice donation for creating this contribution. Once I get this thing working it will be a tremendous time saver for our business.

Ok, I tried importing (QBPro 2004) and Im getting the following errors in QuickBooks: "The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form" The this scree pops up: "Error on line 14: cannot record invalid transaction" The the progress bar finishes, as if the orders were still imported, but I cant find them anywhere. The iif file consisted of 2 orders: 1 credit card order from a customer and 1 check/money order that I created to practice. I have the option set to import as sales receipts, so the first order should come in as a receipt and the 2nd order as an invoice. Relevant settings in my config screen are as follows: Delete credit card number: [not checked] Product rows dispayed: Customer type: [WEB] Use state codes: [checked] Include local country: [not checked] Invoices: Invoice account: [Accounts receivable] Sales Receipt account: [undeposited funds] Invoice to print: [checked] Use Sales Receipts for paid orders: [checked] Invoice terms: [Credit Card] Invoice rep: ? -- what is this?? Invoice fob: [MyFOB point *not shown here] Include customer comments: [checked] Customer message: [Thanks for business!] Invoice memo: *left blank* Items: Item account: [sales: Merchandise] Item asset account: *left blank* Item class: [inventory Part] COG account: [Cost of Goods Sold] Description language: [Customer's] *what is this? Shipping: *I'm positive the shipping fields are correct Taxes: Tax turned on: [checked] Tax name: [GA] Tax agency: [GA Sales Tax] Tax class: [sales Tax Item] Tax rate: [7%] Payments: Import payments with invoice: [checked] Payment memo: [online cc payment] -------------------------------------------------- Thanks for your help!

Adam, Thanks so much for this contribution. It looks awesome. I just finished matching my products up and the whole system is so much better then the older module. I did have a problem though. I did my first import and QB2004 had a problem with the taxes. I think I didn't configure the fields right for that. I wasn't sure what to do because the instruction manual doesn't say much about it. I also want to make sure that I have my item classes and other item info correct. Also, there is a little error in the instruction manual. It refers to the input and output folders as "import" and "export" folders, and even tells you to set them up as qb_import and qb_export. However, the contrib only recognizes the qb_input and qb_output. Just a little change in the manual is needed. Great job and thanks again!

Ok, I tried this out again and here is the problem. If I use the links in the category box to jump to a subcategory page, than everything works fine. However, if I have a link on the subcategory page like "$urlcat_25" then that link will not work. STS doesn't read the link/output it correctly and it messes up. Try it on your own site! This is a bug in STS!! Any know a way to fix this? Diamond Sea?

RECONCILING ACCOUNTS AND CREDIT CARDS PAYMENTS TO INVOICES A HEADACHE! Any Ideas? This isn't directly related to this contribution (though it may be), but I wanted to ask all of you how you reconcile (or whatever you call it) your invoices to the credit card payments you receive. This is becoming a real headache for me. My site accepts Visa, MC, Amex, Discover and PayPal. I'm using Authorize.net as the payment gateway, and I get the credit card payments from customers deposited in batches daily into my company checking account. I'm using the QuickBooks contribution to download orders into QuickBooks 2004. So bascially, I get several orders a day, and being that the QuickBooks Contribution downloads the orders as Invoices, each one must be marked as paid. I have to go into my bank statement and get the latest batch of cc deposits, then go to Authorize.Net to see what actual cc payments correspond to which batch, then go to QuickBooks and match each cc transaction to it's invoice to mark as paid. Then I have to reconcile the whole batch to the bank statement so it all works out nicely. What a pain! Then we have the merchant account and payment gateway fees that are taken out which makes the whole process even more difficult. The batch don't exactly add up sometimes because you don't know all the fees that were taken out. How do you guys get around this problem? Can you have your merchant account and gateway take out the fees later, in one lump sum? Is there software that you use to reconcile automatically? If this new contribution can import the orders as sales receipts instead of invoices, then I think that would solve half this problem. Also Adam, I think you'd have to make it so that if the customer orders using check or money order then it will come in as an invoice, otherwise it will come in as a sales receipt (because it's paid immediately using a cc). However, there is still a problem with the merchant fees being taken out of each batch, which is a big pain. Any ideas in speeding up this whole process would be much appreciated. I'm assuming most OSC stores don't even worry about this because I've never heard anyone talk about it in the forums. As for our company, we want the books to be right.

STS DOES NOT SEEM TO WORK WITH SUB-CATEGORY PAGES! I cannot get STS to work with subcategory template pages. You can jump between the main categories just fine without any problems. However, if you try and jump to a subcategory page, the page will display fine but all the links on the page will be messed up, and from then on the whole site will be messed up because you will be following bad hyperlinks. STS seems to have a problem with subcategories because of the double # system: http://www.mysite.com/index.php/cPath/XX_XX. Has anyone else experienced this problem??? Try it for yourself and see! Any ideas for fixing this?

This is so great that someone is finally making a new QuickBooks module!! Any ideas on when it might be finished? I'm using the older QuickBooks contribution with Tax, and our company is running into the problem of matching the credit card payments with the order invoices. It takes so much time. I found a program called ChargeBooks that is supposed to speed up the process. What I'm wondering is if this new contribution will allow you to import the orders as sales receipts instead of invoices. Wouldn't that be a little bit faster? Is it recommended that invoices be used? Also, will this contribution import the payment method used such as Visa, Mastercard, etc? Would this contribution work with QuickBooks Online version? Thanks!