Quickbooks Import QBI

[tj1]

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

[tomarriola]

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

[tomarriola]

Rather than iff file I should have requested a sample store file. This would be a useful asset to help us quickbooks newbies

Tom

[fabienne]

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]

[ncjimgir]

How is the current version of QBI working with ZenCart 1.3.8?

Thanks..

[adam5532]

How is the current version of QBI working with ZenCart 1.3.8?

Thanks..

Works fine.

Thanks,
Adam

[tomarriola]

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

[tomarriola]

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 ;

[adam5532]

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

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

[tomarriola]

Ooops, thats right. Thanks
Tom