Quote Originally Posted by 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