Quickbooks Import QBI

MikeyG:

Okay I am really having a battle with this.

If I don't have a model number I can seem to export the product and so a the moment I only have product withg any model info (not many as I have not really been using this field.)
I don't know why Zen-Cart doesn't enforce mandatory use of this field. It is pretty much universal in inventory systems for every item to have a stock number or UPC. QuickBooks requires it -- that's the item 'Name'. If I didn't enforce this, and used the products_id instead, the item Name in QB would import as a meaningless integer.
I am also cconfused about how to get the product to list in the drop downs under the Match in order to do the mapping properly. I seem to be in a catch 22. Want to get the product into quick books (which is empty at moent) I have 6000+ combinations with attributes and don't want to retype but I can get them into quick books to then get them back out to map them for the purposes of stock control.
I think you are misunderstanding how QBI works. If you currently have no products in QB, then make an iif of all Products from the QBI Creat IIF page and import this into QB. Then no matching is required! And, all your attributes (up to 5 options and unlimited option values) will be imported as sub-items, with complete inventory control in QB.

Note that all items will import as zero stock, even though the iif contains stock quantities for products (not attributes, as this is a limitation of Zen-Cart). This is because QB can not create stock without knowing where the stock came from! In other words, you will need to do a stock adjustment in QB, or create PO's in QB to account for these items. Since it is an accounting system, if it imported stock but didn't know how it was purchased, that stock would have no value!

Once you set up the stock levels in QB, then even though Zen-Cart can not track attribute stock, you will have complete inventory control of each option value combination in QB!

Thanks,
Adam

audradh:

I'll have to do a little more testing to be sure what QBI does w/ single attributes.
Note that while matching currently only works with a limited number of attributes, if you don't need to use matching, you can import products and orders with up to 5 levels of attributes using QBI! I doubt that more than 5 levels is needed -- with 3 values each, that would be 243 versions of one product -- with 5 values each, 3125 versions!

• Adam

Tried to search for references to this program working with MYOB accounting software but did not find anything discussed. We sell music downloads and product and accept credit cards and paypal and need to get sales data from Zen Cart to MYOB.

Thanks for any info and sorry if it has been discussed.

drc2100:

Tried to search for references to this program working with MYOB accounting software but did not find anything discussed. We sell music downloads and product and accept credit cards and paypal and need to get sales data from Zen Cart to MYOB.

Thanks for any info and sorry if it has been discussed.
QBI only works with Quickbooks. Each accounting system has its own data format. I have a lot of features to add to QBI, including non-US support, so it is unlikely that I will add compatability with any other accounting system for quite some time, if at all. You might consider converting to Quickbooks!

Thanks,
Adam

Thanks for your prompt reply. We all work on Macs here and the accountants I work with prefer MYOB for many reasons and we are entrenched at this point. We were able to import easily form Pay Pal before we upgraded to our Zen Cart in April and added standard credit cards thru authorize.net. I am sure we wil eventually find a work around.

Given what we went through to make the music store sell individual track and album downloads this should be just a matter of time and effort.

Thanks again

drc2100:

Thanks for your prompt reply. We all work on Macs here and the accountants I work with prefer MYOB for many reasons and we are entrenched at this point. We were able to import easily form Pay Pal before we upgraded to our Zen Cart in April and added standard credit cards thru authorize.net. I am sure we wil eventually find a work around.

Given what we went through to make the music store sell individual track and album downloads this should be just a matter of time and effort.

Thanks again
It does look like MYOB will accept tab delimited files, like QB. The format has some differences. I took a look at their support site, and it provided some information but it wasn't complete. It doesn't show how the headers are set up, and how totals are listed on the sales order. If you are able to get a sample text file of a sales order and a customer record in the proper format for import into MYOB, please send it to me and I'll take a look.
Thanks,
Adam

Thanks for suggesting that possible solution. I will try to get the text forms and send them to you. It would be awesome if this worked and I am sure there are other MYOB fans out there that would appreciate it.

Thanks again -

Doug

I am trying to export my shopping cart and I am getting this error:

Fatal error: Call to undefined function: create_product_header() in /home/scouting/public_html/admin/includes/classes/qbi_classes_output.php on line 322

What can I do to fix this?

Mike

I figured out the issue with the error code. Now what is happening is that my client is using QB 2006 with Merchant Services. The way I understood QBI, is that the order, including the credit card info, will be downloaded into Quickbooks using the orders.iif file and then that order could be processed using Quickbooks and Quickbooks Merchant Services.

Well, the credit card info is not downloading. Did I misunderstand QBI? If so, what do I need to fix the issue?

Mike

mikecrane:

I figured out the issue with the error code. Now what is happening is that my client is using QB 2006 with Merchant Services. The way I understood QBI, is that the order, including the credit card info, will be downloaded into Quickbooks using the orders.iif file and then that order could be processed using Quickbooks and Quickbooks Merchant Services.

Well, the credit card info is not downloading. Did I misunderstand QBI? If so, what do I need to fix the issue?

Mike
Mike,
In the future, QBI will directly interface to QB in order to support additional features such as this, but right now using the iif file format it can not import credit card numbers. The iif format does not even have any fields for the credit card information. QBI works with merchant services that are integrated directly into the shopping cart, and for most people this is a much better solution anyway. When it is integrated into the cart in real time, you do not have to do any additional steps later to charge the card, and you do not have to waste time contacting the customer if it is declined, because the customer can make corrections or try another card immediately. Also, for customer security, it is best not to even store the numbers in QB, since they are not needed once the sale is completed.

I believe that there may be a contribution that allows you to link to the QB merchant services in real time from the cart. You may also consider using Authorize.net instead, which is quite popular and used by many people, and it works perfectly with QBI.

QBI does know that the card has been charged, and does import the payment as an invoice/payment, or as a sales receipt (preferrable configuration). Because the card has already been charged online, there is no need to import any credit card information.

Thanks,
Adam

Adam,

thanks for your advice so far. I have started again from scratch and taking your advice about creating an iif file for product. (and thanks for the my sql to get product id into model) However I get when trying to upload/creat the product iif:

Fatal error: Class 'output_file_iif_gb' not found in ...\admin\includes\classes\qbi_classes_output.php on line 299

have I missed something in the way of fixes earlier ion this thread.

many thanks

MG

MikeyG:

Adam,

thanks for your advice so far. I have started again from scratch and taking your advice about creating an iif file for product. (and thanks for the my sql to get product id into model) However I get when trying to upload/creat the product iif:

Fatal error: Class 'output_file_iif_gb' not found in ...\admin\includes\classes\qbi_classes_output.php on line 299

have I missed something in the way of fixes earlier ion this thread.

many thanks

MG
You have chosen a country version other than United States on the configuration page. There is a note next to this option noting that other countries are not yet supported.

Thanks,
Adam

Adam, thanks for your reply I did work this out eventually.

I have trouble getting the iif uploaded at the moment in order to map product to it.

Originally I only had two products showing one which was gift wrap and one that was carriage but now Icannot get any thing to map to.

Have I missed a trick

thanks

MG

MikeyG:

Adam, thanks for your reply I did work this out eventually.

I have trouble getting the iif uploaded at the moment in order to map product to it.

Originally I only had two products showing one which was gift wrap and one that was carriage but now Icannot get any thing to map to.

Have I missed a trick

thanks

MG
Check your configuration settings for Items | Match Types.

Thanks,
Adam

drc2100:

Thanks for suggesting that possible solution. I will try to get the text forms and send them to you. It would be awesome if this worked and I am sure there are other MYOB fans out there that would appreciate it.

Thanks again -

Doug

Count me in :)

Hello! Just checking, this mod won't work for me as I'm in Canada and using a Canadian version of QB, is that right?

I ordered a bunch of new products to replace items that I've sold and adjusted the inventory quanity in Quickbooks, and changed the sale price on a few things as well. Is there a way that I can upload the adjusted inventory quanity and prices from Quickbooks to Zen Cart or do I have to do that manually? I'm not adding new items to the store. Just adjusting inventory quanity and prices on existing items.

Hello! I am very new to ZenCart and have a question. I live in Canada, and am wondering if the Quickbooks Import QBI will work successfully with my Quickbooks Premier 2005 (Canada version). I have found different comments on this forum and am unclear if I will be able to successfully import my orders into my Quickbooks.

Please let me know the real answer. Thanks!:smile:

Okay...so this newbie found her own answer...and for any other Canadians that want to know if this module works on Canadian Quickbooks Program..the answer is NO.

So now I need some feedback from other Canadian Businesses. What have you done to effectively use ZenCart and Quickbooks without creating too much work for yourself? Do I just need to input each order manually into Quickbooks? Or is there a better way of managing inventory and tracking income that I am not thinking about?

I would love to hear how other Canadian Businesses have gotten around this.

Thanks! :smile:

https://www.babysigns.ca

Hi! I personally input each order manually and it's surprisingly not that bad. However, I don't input the customer info. What I did was create a customer called All Customers and just used that for each invoice, saves a ton of time! I use multi-currency, so I made an All Customers-CAD and an All Customers-USD so that the orders are in the correct currency.

There is also a feature in Quickbooks called a Sales Summary where you enter all sales on one order, daily, weekly, monthly, whatever. Just look up Sales Summary in your QB help and it will tell you more about it!

HTH!