Quickbooks Import QBI

[adam5532]

There was 66 New Products and 16 of them had a lot of attributes. So I deleted those 16 products (so there are 50 products now) and I'm still getting the same error. I'm not sure what's wrong as it has always worked for the last year and a half.

You are exceeding the PHP memory limit.

You still may have a large number of products. It depends how many attributes and attribute values you have.

For example, if you have one product, and it has 3 attributes with 10 attribute values for each attribute, you'd have 1,000 products in QB. Multiply that by 50 base products, and that's 50,000 products!

This may be an extreme example, but you can see how it is possible to exceed PHP memory or execution time.

If this is what's happening, you'll either need to rethink your products, or increase the php.ini settings (if you are able to).

You can get a clue by looking at the qbi_products.iif file (using Excel) in the qbi_output directory on your server to see where it stopped. This is the file that you need to download, but it is likely that it is incomplete, because you are getting an error before QBI can finish adding everything and prompt you to download it.

Adam

[adam5532]

Where can I purchase the commercial version of this software?

Thanks!

http://www.qbisoftware.com

[Techiant]

We are trying version 3.21 and are having a problem with several issues. many of the problems we solved by customizing the script and the issues below remain:

We use three payment methods:
Check, Google Checkout, and WPP.

QBI config is set as:
Invoice terms paid online: GoogleCheckout
Invoice terms not prepaid: PayPal

This was the only way to get the payment terms making it in iif.
However, there don't seem to be the way to treat both WPP and GoogleCheckout payments as online payments. In addition, only GoogleCheckout payments result in PAYMENT lines in iif.

question is, how do we set up the three payment options so that:
Check payments are output as Check and don't get PAYMENT lines
WPP are output as PayPal and do get PAYMENT lines in iif
Google Checkout payments are output as they are now (e.g. only one that seems to be working correctly).

Thanks

[adam5532]

We use three payment methods:
Check, Google Checkout, and WPP.

QBI config is set as:
Invoice terms paid online: GoogleCheckout
Invoice terms not prepaid: PayPal

This was the only way to get the payment terms making it in iif.

The Payment Terms have no affect on anything else. It is just the text that goes in the Terms box on the Invoice or Sales Receipt.

However, there don't seem to be the way to treat both WPP and GoogleCheckout payments as online payments.

Yes, there is. You need to do Setup Payments and Match Payments. On the Setup Payments page, you can set to Not Prepaid, Paid Online, or Paid with PayPal for any payment method as you wish.

In addition, only GoogleCheckout payments result in PAYMENT lines in iif.

Then Payments aren't set up correctly. Also, you should be using Sales Receipts. There's no good reason to use Invoice and Payment.

Additional functionality for handling PayPal and Google Checkout is included in the commercial version of QBI (3.82).

Thanks,
Adam

[tbaquatics]

I am contemplating purchasing the commercial version but have a question.

Can it do something like:

Product A with Attribute X in zc maps to Product Z in quickbooks
Product A with Attribute Y in zc maps to Product G in quickbooks

[adam5532]

I am contemplating purchasing the commercial version but have a question.

Can it do something like:

Product A with Attribute X in zc maps to Product Z in quickbooks
Product A with Attribute Y in zc maps to Product G in quickbooks

Yes. In fact, you can do that in both the free version and the commercial version.

Thanks,
Adam

[helpme]

I actually had this working and suddenly the discount/fees set up is missing all the drop downs! Now when I go to matching it says that I need to set up the discount/fees, but I am not able to. They were there but have now disappeared. Any help would be great!
thanks!

[adam5532]

I actually had this working and suddenly the discount/fees set up is missing all the drop downs! Now when I go to matching it says that I need to set up the discount/fees, but I am not able to. They were there but have now disappeared. Any help would be great!
thanks!

You (not QBI) did something to your database. Upload the lists.iif file again.

Thanks,
Adam

[Xbox Memberships]

hey adam i got all of this module up and running but when i go to download orders it gives me the following message....

Fatal error: Class 'output_file_iif_gb' not found in /home/xboxmemb/public_html/admin/includes/classes/qbi_classes_output.php on line 134

any ideas what i have done wrong?

[adam5532]

hey adam i got all of this module up and running but when i go to download orders it gives me the following message....

Fatal error: Class 'output_file_iif_gb' not found in /home/xboxmemb/public_html/admin/includes/classes/qbi_classes_output.php on line 134

any ideas what i have done wrong?

You need to switch the country on the Configure page to US. The other countries are not active.

Adam