Quickbooks Import QBI

[audradh]

I cannot figure out why my matched items are being added as new "service" type items. Any ideas?

[audradh]

For the record, I am having the same troubles that Landshark was having:

Paypal is not importing as Paid Online and items are being created during import despite matching.

I am guessing that the item creation is because most of my products have multiple attributes. What i attempted to do was to create a QB item for each manufacturer and then match each cart item to the correct manufacturer figuring that would at least give me some sales detail. I thought that if I used matching the attribute issue wouldn't interfere, but apparently for multiple attributes it does.

(BTW, is there any quick way to unmatch my 600+ products?)

As for Paypal:

I noticed that in QBI->Match->Payment the shopping cart payment methods include payment methods that are not installed in my cart, and Paypal is listed as "Paypal(paypal)". I do have it matched to "Paypal". In QBI->Setup->Payment "Paypal" is defined as "Paid online".

As an aside, given the impact of importing orders when things are not setup properly, it would be fabulous if QBI offered importing of just one order, or a date range, or order number range, or something other than just import new orders or the last batch.

Landshark, I have PM'd you to see whether you have gotten anywhere w/ this.

I apologize to those trying to skim this thread for my many posts.

Audra

[MikeyG]

adam

I have this error when trying to create / import an iif list file of product items file which I have exported from Quick books

Fatal error: Using $this when not in object context in ..\admin\qbi_products.php on line 51

any thoughts please.

Thanks

MG

[audradh]

adam

I have this error when trying to create / import an iif list file of product items file which I have exported from Quick books

Fatal error: Using $this when not in object context in ..\admin\qbi_products.php on line 51

any thoughts please.

Thanks

MG

MG,
Look up this thread 12 posts. You will find the answer there.
Audra

[MikeyG]

Thanks audrah

[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 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.

It has been a long day and I might be missing something. Sorry if I have missed the obvious.

Thanks

MG

[audradh]

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 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.

It has been a long day and I might be missing something. Sorry if I have missed the obvious.

Thanks

MG

Hey MG,
Adam states in the QBI manual that model# is necessary in order for QBI to work.
The manual also says that products with multiple attributes cannot be matched. I don't know whether you are using single or multiple attributes. I'll have to do a little more testing to be sure what QBI does w/ single attributes.

It all comes back to that great shortcoming in the stock Zen Cart, no support for attribute stock

Audra

[adam5532]

MG,

Adam,

thanks again for your reply.

If I do not use model field how can I populate the model field with the product id from the data base.

Run this statement in your MySQL interface:

UPDATE products SET products_model=products_id

- Adam

[adam5532]

I cannot figure out why my matched items are being added as new "service" type items. Any ideas?

Are you sure they are matched, and you clicked the button to save each match page after matching them? Items that aren't matched or don't exist in QB will import as services.

Thanks,
Adam

[adam5532]

For the record, I am having the same troubles that Landshark was having:

Paypal is not importing as Paid Online and items are being created during import despite matching.

PayPal is not well supported at the moment. I am going to fix this in v3.10, so you won't have any problems. Version 3.10 will be out shortly -- it is taking a little longer as I add additional things to it.

(BTW, is there any quick way to unmatch my 600+ products?)

Just empty the qbi_products_itemsqb table.

As an aside, given the impact of importing orders when things are not setup properly, it would be fabulous if QBI offered importing of just one order, or a date range, or order number range, or something other than just import new orders or the last batch.

I don't quite follow. QBI should be set up properly! You can't skip setting it up and expect it to work well!

Thanks,
Adam