Jump to content


  • Content count

  • Joined

  • Last visited


Profile Information

  • Real Name
  • Location
  • Website
  1. 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.
  2. ACE99

    QBI Quickbooks Import

    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?
  3. ACE99

    QBI Quickbooks Import

    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.
  4. ACE99

    QBI Quickbooks Import

    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.
  5. ACE99

    QBI Quickbooks Import

    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.
  6. ACE99

    QBI Quickbooks Import

    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!
  7. ACE99

    FAQDesk v1.01.0 Support

    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?
  8. 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?
  9. ACE99

    QBI Quickbooks Import

    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!
  10. ACE99

    QBI Quickbooks Import

    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.
  11. ACE99

    QBI Quickbooks 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!
  12. ACE99

    Actual Attribute Price V1.0

    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.
  13. 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!
  14. 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.
  15. 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! :)