Quickbooks Import QBI

Quote:

---

Originally Posted by djstern

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.

---

QBI currently can not upload QB inventory counts into Zen-Cart. However, this feature is planned for the future.

Thanks,
Adam

So, what files would I have to alter in order to have ONE header line and change the extension from IIF to XLS? I'm kind of reverse engineering here.

I'd think you'd have to have about 3 headers. v_product_id, v_products_price, and v_products_quantity if I remember the headers correctly. Not sure about that though.

Quote:

---

Originally Posted by hd28usa

So, what files would I have to alter in order to have ONE header line and change the extension from IIF to XLS? I'm kind of reverse engineering here.

---

I'm not sure what your intent is in doing this, but the only file that you'd need to alter would be qbi_output_iif.php In fact, you could make a new output class qbi_output_xls.php based on the iif output file, and add it to the output file types. QBI is completely modular and the code that formats the output is completely separated from the code that does everything else.

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

I'm not sure what your intent is in doing this, but the only file that you'd need to alter would be qbi_output_iif.php In fact, you could make a new output class qbi_output_xls.php based on the iif output file, and add it to the output file types. QBI is completely modular and the code that formats the output is completely separated from the code that does everything else.

Thanks,
Adam

---

Nice Adam. Actually, do mean qbi_classes_iif.php instead of qbi_output.php? The latter doesn't exist in the release I have. I was trying to modify the classes files. I'm customizing the output to work with AdvancePro from AdvanceWare. They require specific headers in correct order and import TXT, CSV, and XLS filetypes. After I import the orders to this software, the orders are passed to the accountant on her Quickbooks computer.

I basically have a "middle-man". Thanks for the quick reply!

Quote:

---

Originally Posted by hd28usa

Nice Adam. Actually, do mean qbi_classes_iif.php instead of qbi_output.php? The latter doesn't exist in the release I have. I was trying to modify the classes files. I'm customizing the output to work with AdvancePro from AdvanceWare. They require specific headers in correct order and import TXT, CSV, and XLS filetypes. After I import the orders to this software, the orders are passed to the accountant on her Quickbooks computer.

I basically have a "middle-man". Thanks for the quick reply!

---

Sorry, yes I meant qbi_classes_iif.php When you create the new xls class and add it to the dropdown list of output types, QBI will automatically use the xls file extension on the file name.

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

Sorry, yes I meant qbi_classes_iif.php When you create the new xls class and add it to the dropdown list of output types, QBI will automatically use the xls file extension on the file name.

Thanks,
Adam

---

Ok, so you pull the file extension from the class's file name? No need to reply. I get where you are going. I was in the right direction and tried copying the info from the IIF class file to the XML class file. I ran into a server error. I will try this again with the new XLS filetype.

Thanks..

Quote:

---

Originally Posted by hd28usa

Ok, so you pull the file extension from the class's file name? No need to reply. I get where you are going. I was in the right direction and tried copying the info from the IIF class file to the XML class file. I ran into a server error. I will try this again with the new XLS filetype.

Thanks..

---

You'll actually need to make a small change at the beginning of the create_files_orders class in the qbi_classes_output.php file for the output extension. Also, note that you need to modify both the output_file_iif and output_file_iif_us classes to be what you want. I'd suggest copying them to output_file_xml and output_file_xml_us since those are already set up, and then worry about the file extension later. You'll also need to include any new class files in qbi_app_top.php

- Adam

Quote:

---

Originally Posted by adam5532

You'll actually need to make a small change at the beginning of the create_files_orders class in the qbi_classes_output.php file for the output extension. Also, note that you need to modify both the output_file_iif and output_file_iif_us classes to be what you want. I'd suggest copying them to output_file_xml and output_file_xml_us since those are already set up, and then worry about the file extension later. You'll also need to include any new class files in qbi_app_top.php

- Adam

---

Thanks. Got the app to pull from qbi_classes_xml.php. But, the file extension change does not let me download a file when I change:

$format='xml'

to

$format='xls'

in the qbi_classes_output.php file. There are two places this comes up in this file.

I can, however, download an XML file now.

---------------------------
EDIT
---------------------------
I can download a file, but it is an IIF file (contents to be edited) with the correct file extension (XLS). I may actually end up doing a CSV file in the end BTW.

Quote:

---

Originally Posted by adam5532

QBI currently can not upload QB inventory counts into Zen-Cart. However, this feature is planned for the future.

Thanks,
Adam

---

Any idea when we might expect to see this feature? It would save a lot of time updating inventory count and prices in the store. I'm sure a lot of us would really appreciate that feature.