Printable View
Hi Adam, I posted this question a while back, just checking again to know if this feature has already been added.
I did a search only on this thread for "sales order" and for "sales orders", but the seach function in this forum kind of sucks and doesn't return accurate results.
Anyway, I would like to know if if orders can be imported as 'sales orders'. You mentioned this would be added, just checking if it has been added already so I can finally use this mod.
Thanks
Is there an .iff file I can import into quickbooks that will setup things to work with QBI? My accountant is versed in quickbooks but not in zencart.
I'm having a hard time getting the correct account types and names entered.
Tom
Rather than iff file I should have requested a sample store file. This would be a useful asset to help us quickbooks newbies
Tom
I have a problem with Quickbooks, and I wonder if I am also having a "tangle" with the way that QBI is importing my information due to my product.
I am a retailer and I sell sample sets of my products.Customers can choose 6 samples for their sample bag, and there are about 50 choices. My problem is that when my customer data is downloaded into Quickbooks each one of the sample bags is considered a unique new product, it is classified as a service, each of the samples become a subset of another sample and all of the samples become a subset of the sample pack. So the item list looks like this (the hyphens are there only to make sure that the indents work properly, in the real item list there are no extra hyphens):
Sample Pack Non Inventory Sales
-Product CR Service
--Product CG Service
---Product DP Service
----Product LB Service
-----Product NY Service
------Product UB Service
-Product GW Service
--Product MX Service
---Product O Service
----Product SC Service
-Product DP Service
--Product G Service
---Product P Service
----Product UB Service
-----Product WH Service
What I would want is for every time I sell a sample pack that it would be accounted for as a sample pack and not include what was in the sample pack and certainly not make a new set of items for every sample pack which is sold or whatever is the reasoning behind the proliferation of what looks like product groups.
This just keeps on growing and one day it will become a problem. Right now I am just saying to hide the extra items, just to keep the item list to a managable size.
This started happening sometime between October and December 2007, and I am not sure if it started happening when I got the upgrade to 3.70. I noticed that there was a section "include attribute in orders.iif" and I don't want to uncheck that because it sounds like I would not get the name of my products in my orders if I did that. Then again, that could have nothing to do with my problem at the moment.
I am using Zen Cart as my shopping cart, PayPal as my payment service, QBI (from Liberman Sound) to download the payment information into Quickbooks, and Quickbooks 2007 Pro.
I hope I have explained this well enough, if not, please say so and I will try to be more clear. I also hope that this has not been asked before. I don't think it has, and I do not mean to make more chatter if it has been.
[FONT=monospace]
There is one more small question I had...I used to be able to choose QBI from my drop down menu in admin in Zen Cart. Now I have to access it through a direct way (go to http://www.mywebsite.com/qbi). Is there some way to get QBI back to my drop down menu in Zen Cart? It was pretty convenient.
Thanks for your time on this. I am very much a big fan of QBI and it has made my life a lot easier.
[/FONT]
How is the current version of QBI working with ZenCart 1.3.8?
Thanks..
Works fine.Quote:
Originally Posted by ncjimgir
Thanks,
Adam
I just bought the commercial version of qbi and it appears to have made a mess of my database.
After installing qbi my attributes no longer work right. When adding an attribute to a product I get this error message:
1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '356', '82', '540', '1', '', '0', '0', '1', '+', '0', '0', '1', '', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I expect this is due to the additions to my products_attributes table which has these new entries
`products_attributes_products_id` int(11) NOT NULL default '0',
`products_attributes_products_quantity` smallint(6) NOT NULL default '0',
`products_attributes_type` tinyint(4) NOT NULL default '0',
Unfortunately this problem wasn't discovered until after the upgrade was placed on my live store. Any help is appreciated and needed urgently
Thanks
Tom
In case its needed here is a before and after
Here is the table before the upgrade
CREATE TABLE `products_attributes` (
`products_attributes_id` int(11) NOT NULL auto_increment,
`products_id` int(11) NOT NULL default '0',
`options_id` int(11) NOT NULL default '0',
`options_values_id` int(11) NOT NULL default '0',
`options_values_price` decimal(15,4) NOT NULL default '0.0000',
`price_prefix` char(1) NOT NULL default '',
`products_options_sort_order` int(11) NOT NULL default '0',
`product_attribute_is_free` tinyint(1) NOT NULL default '0',
`products_attributes_weight` float NOT NULL default '0',
`products_attributes_weight_prefix` char(1) NOT NULL default '',
`attributes_price_onetime` decimal(15,4) NOT NULL default '0.0000',
`attributes_display_only` tinyint(1) NOT NULL default '0',
`attributes_default` tinyint(1) NOT NULL default '0',
`attributes_qty_prices_onetime` text NOT NULL,
`attributes_price_words` decimal(15,4) NOT NULL default '0.0000',
`attributes_price_words_free` int(4) NOT NULL default '0',
`attributes_price_letters` decimal(15,4) NOT NULL default '0.0000',
`attributes_price_letters_free` int(4) NOT NULL default '0',
`attributes_required` tinyint(1) NOT NULL default '0',
`attributes_discounted` tinyint(1) NOT NULL default '1',
`attributes_image` varchar(64) NOT NULL default '',
`attributes_price_base_included` tinyint(1) NOT NULL default '1',
`attributes_price_factor` decimal(8,2) NOT NULL default '0.00',
`attributes_price_factor_offset` decimal(8,2) NOT NULL default '0.00',
`attributes_price_factor_onetime` decimal(15,4) NOT NULL default '0.0000',
`attributes_price_factor_onetime_offset` decimal(15,4) NOT NULL default '0.0000',
`attributes_qty_prices` text NOT NULL,
PRIMARY KEY (`products_attributes_id`),
KEY `idx_id_options_id_values_zen` (`products_id`,`options_id`,`options_values_id`),
KEY `idx_opt_sort_order_zen` (`products_options_sort_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=925 ;
Here it is afterwards
CREATE TABLE `products_attributes` (
`products_attributes_id` int(11) NOT NULL auto_increment,
`products_id` int(11) NOT NULL default '0',
`options_id` int(11) NOT NULL default '0',
`options_values_id` int(11) NOT NULL default '0',
`options_values_price` decimal(15,4) NOT NULL default '0.0000',
`price_prefix` char(1) NOT NULL default '',
`products_options_sort_order` int(11) NOT NULL default '0',
`product_attribute_is_free` tinyint(1) NOT NULL default '0',
`products_attributes_weight` float NOT NULL default '0',
`products_attributes_weight_prefix` char(1) NOT NULL default '',
`attributes_price_onetime` decimal(15,4) NOT NULL default '0.0000',
`attributes_display_only` tinyint(1) NOT NULL default '0',
`attributes_default` tinyint(1) NOT NULL default '0',
`attributes_qty_prices_onetime` text NOT NULL,
`attributes_price_words` decimal(15,4) NOT NULL default '0.0000',
`attributes_price_words_free` int(4) NOT NULL default '0',
`attributes_price_letters` decimal(15,4) NOT NULL default '0.0000',
`attributes_price_letters_free` int(4) NOT NULL default '0',
`attributes_required` tinyint(1) NOT NULL default '0',
`attributes_discounted` tinyint(1) NOT NULL default '1',
`attributes_image` varchar(64) NOT NULL default '',
`attributes_price_base_included` tinyint(1) NOT NULL default '1',
`attributes_price_factor` decimal(8,2) NOT NULL default '0.00',
`attributes_price_factor_offset` decimal(8,2) NOT NULL default '0.00',
`attributes_price_factor_onetime` decimal(15,4) NOT NULL default '0.0000',
`attributes_price_factor_onetime_offset` decimal(15,4) NOT NULL default '0.0000',
`attributes_qty_prices` text NOT NULL,
`products_attributes_products_id` int(11) NOT NULL default '0',
`products_attributes_products_quantity` smallint(6) NOT NULL default '0',
`products_attributes_type` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`products_attributes_id`),
KEY `idx_id_options_id_values_zen` (`products_id`,`options_id`,`options_values_id`),
KEY `idx_opt_sort_order_zen` (`products_options_sort_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=925 ;
Tom,
First, please no support requests for the paid version of QBI here. Use the support system at www.qbisoftware.com. There is a knowledgebase article to fix this issue. It is due to some poorly written code in ZenCart, that came over from osC.
Thanks,
Adam
Quote:
Originally Posted by tomarriola
Ooops, thats right. Thanks
Tom
I know that the Canadian version of QBI is not ready yet. In the mean time, what would happen if I tried to use the US version of QBI with Canadian Quickbooks? Would it still work but just with a few bugs? Just wondering if it's still a workable alternative until the 4.x version of QBI comes out?
I originally posted this message in the General Questions forum, but it was suggested I bring it here:
I was wondering which Quickbooks edition provides the best interoperability. I see that the QBI module does not support Quickbooks POS, seeming to leave Quickbooks Pro and Quickbooks Premier Edition.
Is one of these better than another? Are there any versions of either that should be avoided?
I installed this mod for a client, and he's now wanting me to find another solution because it doesn't output the following:
- credit card digits (or last 4)
- shipping method
- payment method
Can this mod be modified to handle these? Or is there another solution?
Thanks!
Adam,
Do we have an idea of when v 4.x will be available? We desperately need it to support UK versions although preferably also the simplestart version of QB rather than just pro and premier as pro costs £300 in the UK and simplestart is only £50.
J
Sales Orders are planned for 4.0. Sales Receipts are supported in 3.xQuote:
Originally Posted by tj1
Thanks,
Adam
QBI can not help you set up your accounting system. For that, Quickbooks has sample files and options when you create a QB company.Quote:
Originally Posted by tomarriola
QBI can export all your Zen Cart products into Quickbooks.
- Adam
It will not work with 3.x. The taxation system and iif file columns are different.Quote:
Originally Posted by dcrosbie
Thanks,
Adam
QB POS is a totally different thing. Support for it may be added to QBI 4.x.Quote:
Originally Posted by Mark Kidd
Choose QB Pro, Premier, or Enterprise according to your accounting needs, desired features, and budget. All work equally well with QBI.
- Adam
Hi,Quote:
Originally Posted by slowawake
Credit card is not transferred, as the iif format does not provide a field for this. It can be done however by a simple modification to the QBI iif template file.
Your client, however, might consider an online payment gateway like authorize.net. It is a vastly better solution, if you keep inventory and can normally ship within 24 hours, or your items are pre-paid special orders. See the various credit card merchant agreements for the exact rules. QBI works well with a gateway.
Shipping method is output. If it isn't on your Invoice or Sales Receipt, you probably haven't set it up properly in QBI. You need to do Setup and Match Shipping.
Payment method is output. If it isn't on your Invoice or Sales Receipt, you probably haven't set it up properly in QBI. You need to do Setup and Match Payments.
Sometimes a shipping or payment method may not work, and has to be manually put in the database. This is due to inconsistencies in the Zen Cart modules. For this reason, QBI 3.50+ pre-enters shipping and payment methods and no longer uses the auto-detection system.
Thanks,
Adam
Sorry, no eta on 4.0 yet. I'm not sure that Simplestart can be supported -- I don't think it supports iif, nor the more advanced connection methods that 4.0 will use.Quote:
Originally Posted by blackjm75
Thanks,
Adam
Ok Adam thanks for the update.
Joe
First off, thank you Adam for this functionality. The robustness of the features and the professionalism of the documentation is very impressive.
I've gone through my setup and the documentation several times and I'm now stuck on two things that are not working as I think they should:
1) I have two payment methods in Zen Cart, Credit Card via a linkpoint.api and Paypal where the user goes over to the Paypal system at the end of checkout to make their payment. My CC transactions are correctly being transmitted as Sales Receipts. The Paypal transaction is going over as an invoice. I have specified my Quickbooks Payment method of Paypal as 'Paid w/Paypal' on the setup screen. On the matching screen I've linked 'Paypal' to the shopping cart options: Purchase (paypal), Voiding Order Authorizations (paypalwpp), and Voiding Order Authorizations (paypaldp).
One thing I don't completely understand is why I can't setup the Quickbooks Payment method 'Paypal' as 'Paid online'? The documentation seems to make clear it should be set as 'Paid w/Paypal'.
2) I have several products that have single attributes. I have matched them with a single item in Quickbooks. The matching info seems to be ignored. The other non-attribute products that I'm matching are going through correctly. From reading the doc it seems like this should be OK, that only multiple attribute products have difficulties.
Thank you!
Kathy
I am confused I just installed the quickbooks import qbi and get all these errors with qbi_mysql.php. I have the latest version i believe which is 3.21 or so and my php on my servier is 5 point something. What am i doing wrong. I am tried to recopy the files to the admin directory and it made no difference. I haven't do anything with the sql tables because i read that it was supposed to have a setup to do all of that. I am going to throw this information out there just in case it has something to do with the problem. I have installed this before a few weeks ago but messed up and had to recopy the files back to it. So this could be causing some kind of issue not sure. I have all the permissions and when i go to the admin portion of zen cart and go to customer menu I get the setup tab and all the other stuff but lots of errors and no button to install. Please help thanks.
Hi,
You can do it either way. The Paid w/Paypal setting just lets you set a different status for PayPal orders. This is to assure that only orders that have completed the PayPal payment process are considered as paid.Quote:
Originally Posted by pinkchalkstudio
If you use the PayPal gateway directly, and customers do not have to go off your site to PayPal and return, then you can consider PayPal like any other gateway and don't need to use the special PayPal settings.
Don't know why you are having this problem without looking at it.Quote:
2) I have several products that have single attributes. I have matched them with a single item in Quickbooks. The matching info seems to be ignored. The other non-attribute products that I'm matching are going through correctly. From reading the doc it seems like this should be OK, that only multiple attribute products have difficulties.
Thank you!
Kathy
Thanks,
Adam
Hi,
3.21 is the latest free version. 3.74 is the latest paid version.Quote:
Originally Posted by welchyboy
I can't help you without you copying some the errors to your post so I can see what is happening.Quote:
when i go to the admin portion of zen cart and go to customer menu I get the setup tab and all the other stuff but lots of errors and no button to install. Please help thanks.
Thanks,
Adam
Sorry about that...When i log into the customer menu and go to the qbi option i get a page full of errors as follows;
Warning: Some products are missing the model name! Correct this issue before creating iif files!
Notice: 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 orders WHERE qbi_imported='0' AND orders_status='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Orders
Notice: 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 orders WHERE qbi_imported='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Orders
Notice: 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 orders WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Orders
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='0' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Products
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Products
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Products
All Customers
Quan: 1
No.: 1
This copy of QBI is not registered!
Please go to www.libermansound.com/qbi to register this copy, and then click the support tab on the QBI menu above to enter your registration into QBI.
Registration will facilitate technical support, and will allow you to receive notification of updates.
QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License
Somehow you did not install QBI correctly and the qbi_imported fields did not get added to your database.Quote:
Originally Posted by welchyboy
Make sure that you have copied over all the QBI files. Then, delete the table qbi_config and go back to QBI in the admin. This should reinstall the tables he first time you open QBI.
Thanks,
Adam
Adam,
Thank you for redirecting me to the forum page.
My original question for you was:
"I am trying to match discounts/fees... Quickbooks discounts/fees show in the drop-down menu but Shopping Cart discounts/fees that I set up under Gift Certificates/Coupons/Coupon Admin do not show in the list. Please help."
You replied that "the discount module will be listed in the match list, not each individual coupon that you have added."
Please explain. Thank you.
I don't actually have to install any databases do I? All i did was copy all the files within each folder to the same folder and path on the server. I have done this many times with other templates and addons to zen cart so i was sure i did that correctly. However the sql files and such i did nothing with because it didn't say to add them or anything like that. From what i understood it was supposed to do all that when i went into the admin portion of zen cart and clicked on the qbi tool under customers. How should i delete qbi from my server then readd it?
There should be one entry for each module, like ot_discount. You will not see the individual coupons that you set up. That doesn't really matter, because the name and discount amount will import properly with each order.Quote:
Originally Posted by mvs179
Thanks,
Adam
You need to copy all files, regardless of the extension. Since you didn't copy the SQL files, QBI had no way to install its database. The instructions do say to copy all files, not just .php files.Quote:
Originally Posted by welchyboy
Thanks,
Adam
I am sorry but i must be missing something. Please any more info you could give me. I am using zen cart 1.38 my server has all the up to date php and other requirements. I transferred the files with filezilla going going to each directory and transferring to the same directory on the server...including sql files. Every file in each folder. I have deleted every file and then readded them again but still the same issue. I followed the manual step by step. Changed the two folders to 777 (chmod). Please if anyone can help me with this issue.
Warning: Some products are missing the model name! Correct this issue before creating iif files!
Notice: 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 orders WHERE qbi_imported='0' AND orders_status='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Orders
Notice: 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 orders WHERE qbi_imported='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Orders
Notice: 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 orders WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Orders
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='0' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Products
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Products
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Products
All Customers
Quan: 1
No.: 1
This copy of QBI is not registered!
Please go to www.libermansound.com/qbi to register this copy, and then click the support tab on the QBI menu above to enter your registration into QBI.
Registration will facilitate technical support, and will allow you to receive notification of updates.
QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License
Run the following 6 SQL statements in phpMyAdmin to add the missing rows:Quote:
Originally Posted by welchyboy
ALTER TABLE `orders` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL
ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `orders` ADD INDEX (`qbi_imported`)
ALTER TABLE `products` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL
ALTER TABLE `products` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE `products` ADD INDEX (`qbi_imported`)
- Adam
OK I am not really familiar with myphpadmin but what i did was went to the website server went to myphpadmin and went to sql. I copied the code you sent to me and tried to run it and got this error. Not really sure how to do this so there is a huge chance i am doing something wrong. However if you can get me through this problem I will be so grateful. I have been working on this one portion of the site for way too long. Thanks in advance.
Error
SQL query:
ALTER TABLE `orders` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ALTER TABLE `orders` ADD INDEX ( `qbi_imported` ) ALTER TABLE `products` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL ALTER TABLE `products` CHANGE `qbi_imported` `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ALTER TABLE `products` ADD INDEX ( `qbi_imported` )
MySQL said: Documentation
#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 'ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DE' at line 3
Note in my message above there are 6 SQL statements. You need to run each one separately, not all of them at the same time. That is why it isn't working.Quote:
Originally Posted by welchyboy
Thanks,
Adam
All i did now was add this one piece of code that you sent and still an error. The last line Table 'stxmill_phplocator.orders' doesnt exist. The phplocator is an sql i have in my phpadmin. Is there something i need to add. Do i need to add a database for the quickbook? It doesnt look like it added anything. Sorry to be so much trouble.
Error
SQL query:
ALTER TABLE `orders` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL
MySQL said: Documentation
#1146 - Table 'stxmill_phplocator.orders' doesn't exist
If you don't have an orders table, then you must have added a prefix. In this case, change 'orders' to the name of your orders table. Or, maybe you are looking at the wrong database. You need to be in your Zen Cart database.Quote:
Originally Posted by welchyboy
Thanks,
Adam
OK I wasn't in the zen cart database when you said phpadmin i thought you were thinking with my site and not within zen cart. However I tried it individually on my sites server and in the zen cart database under install sql patch with this...
ALTER TABLE `orders` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL
and both times got errors. In zen cart the only error i get when trying to apply the patch is failed. I have no idea what my orders table is set too. I normally leave everything standard then start modifying once it works. But this hasn't worked yet. I have the stock plain jane qbi 3.21b or whatever. What do i need to do to check this out?
You need to be in phpMyAdmin, with the Zen Cart database selected before you try to run the SQL statements. If the QBI tables are installed properly, you'll see them in the database (prefixed by qbi_). I'm not sure why you are having trouble installing, as it is normally trouble-free - those SQL statements normally run automatically. I can't offer to look at your tables, as that's the level of support I give for the paid version of QBI, not the free one, nor can I spend time trying to instruct you how to use phpMyAdmin. In other words, I'd like to help you, but I'm not sure if I can do more through the forum.Quote:
Originally Posted by welchyboy
- Adam
I am sorry I followed the instructions to the "T"...The only thing i can think of is a bad install or an older qbi which was there before. I am not sure how to delete sql patches to start completely over. However I just downloaded the qbi 3.21b again from zen cart and followed the instructions step by step following the folder structure and chmod the two folders and everything. Still getting the same errors. So can it be something from a another installation. My problem is I have already done this a few months ago with another version but the client decided not to go through with it. Well they have changed their minds and I tried reinstalling it and I am not having issues. Before it worked just as you say...Perfectly and easily with no problems. So what could be the issue. Anyone. I don't mind deleting the sql keys and reinstalling qbi i just need to know if there are certain steps or how to even find if my prefixes have changed or my "orders". I am not sure about all of that. Like i said i normally do the default. Please can you help...Can anyone help who has had this issue. I can't be the only one with this problem or who has had this problem before. Please let me know if anyone has any suggestions and how to go about these suggestions. Thanks again for all your help Adam
Hi,
Please answer these questions about installing QBI:
I uploaded the catalog directory in the root directory but don't see QBI in admin under the customers tab
1. Do I need to create a new database in cpanel?
2. Do I need to register/purchase QBI for it to work with ZC?
Thanks for your time.
No check your install try refreshing the page it should be there under customer in your admin section. then you click that and it should create your database for you.Quote:
Originally Posted by vision2003
Thanks for taking the time to reply
I tried refreshing the page but QBI does not appear under customers tab.
If I enter http://www.sinkbiz.com/catalog/admin...bi_app_top.php in my browser I receive these errors:
Warning: main(DIR_FS_ADMINincludes/classes/qbi_mysql.php) [function.main]: failed to open stream: No such file or directory in /home/sinkbiz/public_html/catalog/admin/includes/qbi_app_top.php on line 54
Fatal error: main() [function.require]: Failed opening required 'DIR_FS_ADMINincludes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/sinkbiz/public_html/catalog/admin/includes/qbi_app_top.php on line 54
Any help would be much appreciated.
Thanks
I reinstalled QBI to see if i could reproduce the error but i could not the install went ok. Try installing again and use the word file for directions on the install.Quote:
Originally Posted by vision2003
Thanks for making time to check!
I reinstalled QBI but it did not appear.
Is it correct to place the catalog file in the root directory?
See attached screen shot below
Please advise..I'm stumped
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 sent you a email hope you get it.Quote:
Originally Posted by vision2003
Please tell me the solution if it is found. I am getting all kinds of errors as mentions in the previous messages by me. I have read the .doc file and followed it correctly all the way.
I am sending a link which you can click on and download a .doc file which has three screen shots of what I am experiencing. Please help me get through this issue. I have recopied ALL the files multiple times overwriting the files on the server to see if i could fix the problem. Nothing seems to work. I have QBI 3.21b and downloaded it from the zen cart site. I never get a chance to install the sql tables. According to the documentation after changing the chmod of the two folders and copying all the files to the server I should just log into the admin section and click on qbi under the customer menu which i do have and it is supposed to continue installing. But i get nothing but errors. Please if anyone has experienced this and has a solution I could really use your help. Thanks
You can download the .doc file from here
www.wpc-consulting.com/screenshots.doc
It looks like the sql files are not getting uploaded to me. Not saying you did, but you might have missed a step, after you uploaded all the file including all the sql files, and went in to your admin>customer did you do the install from there of your database tables Like it says on line 3 of the word file?Quote:
Originally Posted by welchyboy
You are missing two fields that did not get installed for some reason. The statements to do that I gave you back in post #734. I don't have time to help you with using PHPMyAdmin though.Quote:
Originally Posted by welchyboy
Thanks,
Adam
I'm not supposed to discuss that here. You can find that information on the qbisoftware website.Quote:
Originally Posted by vision2003
Thanks,
Adam
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.
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
Hi,
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.Quote:
Originally Posted by makenoiz
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
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
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.
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 :smile:
Audra
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)
Quote:
Originally Posted by bumba000
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
Quote:
Originally Posted by paul3648
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
The registration system was planned but I never completed it. You do not have to register it. Not being registered in no way affects its operation.Quote:
Originally Posted by bumba000
Thanks,
Adam
I exported the customers and orders and that worked fine but then I tried to export the products and it said:
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 457 bytes) in rollermangosport.com/admin/includes/classes/qbi_classes.php on line 535
any clues as to what is causing the error, we want to get this version running and upgrade to the new 3.75 if it does what I think it does, as I understand it the 3.75 version will export the Attributes of the order to quickbooks, like the price and description of the Attributes when someone orders something, so we can track the inventory of the attributes, that is what we really need and if 3.75 can do that then we are all for it
thanks very much for the great software :clap:
Hi,
You have a lot of products or product/attribute combinations. You need to increase the max memory for PHP above 8 MEG. There is a php.ini setting to do that.
QBI 3.75 can do what you say below, although it may get complicated if you have a lot of product options. I believe there is also a contribution which can do that. You'll need to determine which route is best for your situation.
Thanks,
Adam
Quote:
Originally Posted by stevenlee
I have installed QBI 3.21b now and have a downloaded file of all orders. I have set up a test account in Quick Books. I tried to import the .iif file following the PDF instruction manual and this is what I get.
"Quick Books has detected that one of your items does not have an account associated with it."
I have tried to open this file with excel and with notepad so that I can see all the headers but it is severely broken when viewing that way. How can I see what I need to create in QB for this file to import?
Thanks in advance,
John
Hi,
You probably have not configured QBI properly. All items in Red on the Configuration page must be filled out. Specifically, you are likely missing one of these:Quote:
Originally Posted by bumba000
COGS account:
Item income account:
Item asset account:
Associate .iif files with Excel. Then, double click on the file in Windows Explorer, instead of opening it inside of Excel. Then each field should line up in each column.Quote:
I have tried to open this file with excel and with notepad so that I can see all the headers but it is severely broken when viewing that way. How can I see what I need to create in QB for this file to import?
Thanks in advance,
John
Thanks,
Adam
When I tried importing the customers they all imported fine. When we try to import orders it just continuously gives the same error. We say okay and it goes to the next identical error. This will continue until the status indicator reaches 100% or until we cancel the import. Do we have to set up an account in quick books for each of these things? NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME
I don't do much with quick books and don't know how to do this. If I have a super blank quick books install what steps do I need to take to get these imports to work?
Thank you,
John
Okay. This imported my customers and my products. The orders file still gives me errors every couple of seconds. The error is: "Can't record invalid transaction". It gives me the row number that its having a problem with but that row in excel looks just like many other rows which seem to import just fine. In the end there are hundreds of errors. All the same error. I have added some name or generic text to every field in the configure. Things that I'm really not sure about I just typed in the title of that text box in the configure. Since I did this the errors now start at row 108 rather than 8.
I would greatly appreciate any advice you can give me here.
Thanks in advance,
John
John,
Well that tells me a lot! You CAN NOT do that and expect QBI to work. QBI MUST be configured completely before you try to use it. You can not just "test it out." It MUST be configured for your Quickbooks file, or you will get import errors. You can not just put random text in the configuration. Accounts MUST match what is in your Quickbooks company file. It may take you an hour or more to set up.Quote:
Originally Posted by bumba000
I suggest that first, you carefully set up your Quickbooks company the way you want it. Then, read the QBI manual from start to finish and set up each configuration option according to the instructions in the manual. Then, do Setup and Match in QBI, according to the instructions. Don't even try to use QBI until you have done this!
Thanks,
Adam
Hey, I'm new to the forum and QBI seems to be the solution to my objective. I want to be able to automatically import my sales into Endicia’s Dazzle Shipping Program to create the shipping labels. I know this has been discussed extensively on this forum, but the 70+ pages of replies are a bit daunting to wade through.
If it has been discussed on how to implement this, I would really appreciate a link to the correct page to save me the time of searching each page one by one.
I don't use Quick Books, so if there is a way to do this with out the use of quick books that would be preferable. If not I'm open to using it.
Like I said, all I want to do is easily import the correct data from zen cart sales to Endicia’s Dazzle Shipping Program to print off the shipping labels and postage. Any help?
Hi,
QBI can not be used to import into Dazzle.Quote:
Originally Posted by andrewmp
- Adam
Andrew,Quote:
Originally Posted by andrewmp
I believe you can do that using Zen Cart Order Manager, look for it in the downloads. That add can be used w/ or w/o QB. Last time I looked, though (which was a long time ago) it didn't appear to be supported any longer. If I remember correctly, people did have it working properly...check the support thread for that contribution.
HTH,
Audra
audradh,
I looked into Order Manager and it is definitely abandoned. I couldn't get it to work either.
I use "Export Shipping Information" VERSION: 1.2.2 to produce CSV files which I then import into my "Customer" address book in Endicia.
You can find the contribution here:
http://www.zen-cart.com/index.php?ma...roducts_id=604
Its not fully automated, but if you rename the default unique file name for the CSV file to a fixed name after download, Endicia Address Book will automatically use the fields as set up the first time for that file name.
Clive.
Hi All,
Great mod but I'm still having trouble getting the shipping part to import into Quickbooks. I'm using Region Tables mod (which is similar to zones) and I can't for the life of me figure out which text to add to the database. If I add first choice shipping title which is say National post...there are other variables that are under that title with different levels of shipping costs which include standard and express and are based on the weight of the parcel. It's probably not making much sense but I was hoping someone could help me out.
I've read all through the forum and the manual and I'm still stuck. Thanks!!
QBI gets the shipping information for each order from the ot_totals table. Find the ot_shipping entries for your latest orders, and then determine the text for the carrier and the method. For example, if it says "UPS Ground (1x 1.5 lb)" you can use "UPS" for the carrier and "Ground" for the method. After adding it to the database, you'll need to do Setup Shipping and Match Shipping.Quote:
Originally Posted by bx1
- Adam
Adam - I went to your website and read the information on your latest & greatest version of QBI.. sounds hopeful. It almost looked like the import/export routines were/are automated between the two, ZC/QBI ? Since I am hosting my own website(s), I have Quickbooks 2007 Pro also on the server, accessible from any PC in the facility, based on job function. I have two questions;
1. The current version seems to have some automated features, will I still have to attend to certain functions of it, or will all of processes still be manually I/O'd ?
2. QBP 2007 sets up it's on MSSQL server function when it is in the shared mode. Do you know if this has or will create any conflicts between MSSQL & MySQL ? Too bad all could not be shared on one DB for maintenance purposes and ease of conversation between them ? ..using the same database for both sides, like Microsoft's 'Retail Management Services' does.. ? Of course, that's probably why I didn't spend the $3500 in the first place ?
What file needs to be modified to remove the 'Nag' feature on your Contrib since you have not/did not setup your registration area on your new website ? I figure it's the least that you can do for us, since we cannot accomodate you ?
Hi,
Sorry, but I can't answer questions about the paid version of QBI here. You can post those in the forum on the QBI website.Quote:
Originally Posted by Twbeebe
I will get back to you on that -- either tell you how, or enable the registration system.Quote:
What file needs to be modified to remove the 'Nag' feature on your Contrib since you have not/did not setup your registration area on your new website ? I figure it's the least that you can do for us, since we cannot accomodate you ?
- Adam
Hi Adam,Quote:
Originally Posted by adam5532
Thanks for the reply. I think I have all the shipping part working now which is great! Everything imports from ZC fine, however I think my price break discount, coupons (and especially my reward points mod etc) do not import correctly into QB. The rewards one is tricky because it has a discount component and a rewards earned component which is just numbers. Just not sure as to what to set them up as. Thanks again!
ARRRGGGHHHH!!!!!!! I just tried to upload my inventory to Quick Books Premier from Quik Books Import and after the import rate hit about 52% I recieved the following message:
Do I need to increase the amount Quick Books store, or do I have too many products, 26500.Quote:
Cannot import. Not enough disk space or too many records exist
And if so can I just use customers and orders files.
OK... is their away to use qbi to remove listed items in Quick Books?
Before I install this, I wanted to make sure it is compatible with Zen Cart 1.3.8a and QB pro or premier?
Yeah it is, I am using Quick Books Premier.
Hey Adam I finally got some more time to mess around with QBI and I got it working!!! :clap:
I finally figured out where I needed to go in the phpmyadmin and found the databases labeled qbi and deleted them ALL. Then i reinstalled the new on 3.21b and it is working. I haven't tested it with Quickbooks yet but I know I am much further than before. Thanks again for the great mod!!
Hello Adam,
Things are rolling along relatively well UNTIL I went to update the 'Shipping' portion of the module. Though QB Pro 2007 has some real barbaric sections, shipping being one, I was able to add, at least, the 'Walkin' designator for 'Store Pickups'.. Imported the IIF updated file, but the pull down doesn't show it, to be able to match up with the changes ? I looked internally, at the IIF file, the changes are there ? While I was on the QB side, I changed their blase' descriptors for US Mail to USPS, Federal Express to FedEx, those are also there in the IIF, but not in the Pull Down ? It seems that there must be some Hard Coding in this section that is preventing any changes from occurring, because when I make any kind of changes to the Inventory section, the changes show up after the IIF re-upload ? Did I miss a Patch ?
Dang! if I can see where to fix this??? This one simple error has left me feeling like an idiot.
Did you click "Process iif file" on the Setup > Shipping page? Did you check Item List, Payment Method List, and Shipping Method list when you made the lists.iif file? Does your QB shipping method appear on the Setup > Shipping page? Then it should also appear in the drop-down box on the Match > Shipping page.Quote:
Originally Posted by ouxly40
- Adam
Hello Adam,Quote:
Originally Posted by Twbeebe
For whatever reason, the above items are now working on their own, without further encouragement ? When I sent a new IIF file to QBI, it automatically updated the previous naming conventions ? I continually get more impressed with you everyday :D
Now for the current issue.. I have scoured the forum before I brought it here, as you ARE a busy man !! But, since this is a feature within QBI and I couldn't find the answer elsewhere on my own, here it is.. I do not seem to be able to Export the Customers that I have in my offline server for testing import features in the QB Pro 2007 ? I have 4 customers that I am testing with. I looked at the IIF file and the header block is there, but not the Customers ? I cannot even proceed with modding the file for import, until I have something to mod ? Any suggestions ?
Hello Adam and all,
I need to ask if QBI works with the UK version on QuickBooks? I am doing rather well as far as orders, but it means putting their details in manually each time. Can anyone let me know.
Thanks,
Phil
I knew it was a stupid question! I did not check the box : Tax is on" in QBI. No more errors.
So, Do I need to download new products first and import them to QB or will it just make a new product? I have not manually entered products in QB (there is 2300 of them).
Hi All
I have just read on Adam's website that QBI doesn't work on non-US versions of Quickbooks,:(
Thanks,
Phil
You must already have the products in QB, or use the products export in QBI to add them to QB.Quote:
Originally Posted by ouxly40
If you do it on the fly, they will erroneously be added Services.
- Adam
QBI will only export customers who have placed orders.Quote:
Originally Posted by Twbeebe
Also, there is no reason to export customers, except for historical reasons. New customers will always be added when they place orders, and previous ones will be updated.
Thanks,
Adam
I have imported into QB all products (1613 of them). I have imported new customers (12 of them). When I try to import orders - QB always crashes. I have been tring some different setting in the config and it always causes a crash. I had to create 2 accounts ( undeposited funds, paypal), and still I just get a ncrash. There must be something simple I am overlooking. I have already made this work on my test store flawlessly.
First, if you are using QB on a Mac, it can be prone to crashing when importing files.Quote:
Originally Posted by ouxly40
Do some of the orders import? What's the order number of the last order that gets imported? That should tell you which order (probably the next one) may have a problem. Make sure you don't have any special characters in any product models, descriptions, or customer comments (symbols, quotes, etc) that could cause parsing problems for QB.
You can also split the iif file up to zero in on the order that is causing the problem. Make sure to only split between orders: They'll begin with !CUST and end with ENDTRANS.
- Adam
Yes, I am on Mac. I removed all but the first order and it still did. I set up QBI on a test ZenCart installation with a few products and 2 customers and it worked fine. Then I installed it on the real cart and now it crashes. I looked over the products, the customer info, checked that all accounts were entered exactly as in QB,,,
You may also have trouble uploading iif files into QBI. The paid version is able to parse Mac line returns, but this version doesn't.Quote:
Originally Posted by ouxly40
However, I'm not sure what the problem is importing iif files into QB Mac. It may also have to do with line return formatting. Where you able to import iif files of customers and products? Then the line returns would not be an issue.
Unfortunately, QB Mac seems to crash when it isn't happy, instead of giving an error message. Very few people use QB on the Mac, and I don't have one, so that has made tracking down crashing problems difficult.
Maybe try editing the iif so that you aren't including the first order. Also, make sure that all the detail lines add up to the inverse of the transaction total.
- Adam
Are you saying that if I buy the upgrade this issue will go away? Well, that makes it a no-brainer,,,,, Who wouldn't think it's worth that amount of money to save save an hour (or more) a day.
Unfortunately, that's not what I'm saying. The paid version does not have a problem uploading iif files made from QB Mac -- that's where you export an iif file from QB and import it into QBI so you can do matching.Quote:
Originally Posted by ouxly40
But creating iif files of orders with QBI and importing them into QB Mac can still sometimes cause crashes, even with the latest paid version. I'm not sure if there is something specific that is causing a problem for QB Mac, or if it is a common configuration or setup issue, and QB Mac just crashes instead of telling you what line caused the error.
We can discuss your options re the paid version outside of the Zen Cart forum.
Thanks,
Adam
I am using qb 2008 pro and 1.3.8a zc. I imported the customers without a problem but when trying to import the products or orders it keeps shutting qb down.
I have checked all of the red boxes are filled in in the config. section. What am I doing wrong? Oh and I'm not on a mac
Thanks!
Okay, I have gotten slightly farther but still can not get past 2% on my orders import. I have created discounts as such:
ot_shipping (for free shipping over $50) and ot_coupon for various coupons used. I have not put any amount or percent for the discount as each time it is different. Yet I know the order I am stuck on used both a discount coupon and received free shipping. Can someone tell me what I am doing wrong, please?
Thanks!