Quickbooks Import QBI

[adam5532]

Thanks dscott1966 for duplicating the installation.

If I send you FTP access could you install it for me?
I would be willing to pay you a small fee for your services (if install works)

Contact me at: info at isitebuild dot com

What's the diff between the free and paid versions?

Regards.

I'm not supposed to discuss that here. You can find that information on the qbisoftware website.

Thanks,
Adam

[welchyboy]

At first I followed the instructions in the document and didn't add anything to the sql because the document said that once logged in to the qbi section of the zc admin portion it would install the tables or at least walk you through the process. This never happened all i got was errors when i went to the qbi section. Then I have added various things to the sql database from adam and stuff like that but nothing seems to work. I am not sure how to check what sqls are installed on zc so if there is something wrong I could possibly remove it and try again but i am just not that familiar with it. I haven't had any trouble adding sql patches before. Normally the documentation would tell me after it installs to go zc and add a sql patch then i would copy it in there and all was well. Not this one. I can't figure out what I am doing wrong. If there is a way to fix this i could really use it. I will do whatever needs to get done. Do you have any ideas how i can get the sql patches installed correctly or uninstall the old ones and then try again or something? I thank you for trying to help out I really do appreciate it.

[makenoiz]

Adam, We just moved to a new server and are getting the good ol Query failed: Unknown column 'qbi_imported' in 'where clause' SQ errors.

Can you tell me what I need to check. I had the database moved over as well as all the files.

Thanks


Here is the complete list of errors.

otice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM zen_orders WHERE qbi_imported='0' AND orders_status='3' in /home/myaccount/public_html/shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/myaccount/public_html/shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myaccount/public_html/shop/admin/includes/classes/qbi_mysql.php on line 176

[adam5532]

Hi,

Adam, We just moved to a new server and are getting the good ol Query failed: Unknown column 'qbi_imported' in 'where clause' SQ errors.

Can you tell me what I need to check. I had the database moved over as well as all the files.

QBI's tables and fields are completely self contained, except for one field (qbi_imported) that gets added to the Zen Cart orders table and the products table.

To add these, see my post #734. Open PHPMyAdmin, select your Zen Cart database, click on the SQL tab at the top, and individually run the six statements in that post. This will add the fields.

- Adam

[bumba000]

I'm curious to know why I didn't see anywhere that I would have to pay $150 to use this mod. I installed it a year or so ago and don't remember having to pay $150. Now I installed it in my live store and cant use it. I guess I could if I were to pay $150 but I won't. I think I would feel much different about parting with the cash if I had been forewarned. I was not, now all I have to look forward to is weeding out all of these files.

What a bummer,
John

[paul3648]

I wish there was a simple way to set this up for first time users. I've been trying off and on for the past year to get this to work and had no success.

I don't have an existing Quickbooks setup, and don't really understand accounting terminology. I've been trying to use the default Quickbooks setup for retail businesses.

I've just spent the last two days (20 hours) trying to set this up - going over and over the instructions, trying different things

Just doesn't work for me.

Goodbye frustrating software.

[audradh]

Paul,
The simple way, if you are struggling w/ this, is to pay someone to set it up for you. I do mean that in all seriousness. If you have spent 20 non-productive hours on this, that you could have used on something productive for your business, then you need to consider what your time is worth. I'm guessing it is worth more than that. Given that you put so much effort into getting it going, I'm also guessing that you believe that using QB w/ QBI will be worthwhile for your business. So bite the bullet and just pay someone to get it going for you. The sooner you do it, the more worthwhile the $$ spent will be in time savings for you.

My thoughts
Audra

[adam5532]

John,

You are apparently misunderstanding something. All contributions downloaded from Zen Cart, including QBI, are free. QBI 3.75 is the paid version of QBI and does cost $150. However, you are welcome to download QBI 3.21 for free from Zen Cart if that serves your needs.

Thanks,
Adam (author of QBI)

I'm curious to know why I didn't see anywhere that I would have to pay $150 to use this mod. I installed it a year or so ago and don't remember having to pay $150. Now I installed it in my live store and cant use it. I guess I could if I were to pay $150 but I won't. I think I would feel much different about parting with the cash if I had been forewarned. I was not, now all I have to look forward to is weeding out all of these files.

What a bummer,
John

[adam5532]

Paul,

If you could be a little more specific about what problems you are having, I might be able to help you here on the forum.

If you need more support than that, then there is a commercial version of QBI that includes free personal support (but not free complete set-up). You need to decide what your time is worth and what level of support you need.

Thanks,
Adam

I wish there was a simple way to set this up for first time users. I've been trying off and on for the past year to get this to work and had no success.

I don't have an existing Quickbooks setup, and don't really understand accounting terminology. I've been trying to use the default Quickbooks setup for retail businesses.

I've just spent the last two days (20 hours) trying to set this up - going over and over the instructions, trying different things

Just doesn't work for me.

Goodbye frustrating software.

[bumba000]

I did download 3.21b from zencart. After installation every page of it says that I need to register my copy. I click the link it takes me to a site that says the site has moved click the next link and it asks for money. Where am I going wrong? I would love to reinstall this mod and use it.

Thank you,
John