• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

jonm
#1 Posted : Monday, February 13, 2006 5:06:20 PM(UTC)
jonm

Rank: Member

Joined: 3/24/2005(UTC)
Posts: 311

I just installed OrderExport and upon doing an export of a single order that is Status - Paid (bvadmin page) it won't export into Quickbooks.

Looking at the log I get this information.

ttempting to Open QBFC4Lib Connection
QBFC4Lib Connection Opened
Using Company File Name: *edited*
QuickBooks Version = 4.0 - US
_orders Count = 1
Service Path = *Edited*
Starting BVC 2004 Order Download at: 2/10/2006 12:43:01 PM
Finished BVC 2004 Order Download at: 2/10/2006 12:43:01 PM

Exporting Order: 516840
Checking for Duplicates
Checking for existing order at: 2/10/2006 12:43:01 PM
Finished Checking for existing order at: 2/10/2006 12:43:44 PM
Order Skipped as UNPAID
Not Setting Last Order Number
Finished Export of Order 516840
Order Export Time: 00:00:42.7494528
Total Export Time: 00:01:01.5617120
Skipped Orders:

516840


For some reason it is thinking the order is unpaid when it clearly is not the case. Anyone have any ideas on what could be causing this?

BV Version: 2004.7
OrderExport version: 2004.6.1917.24219

Thanks
-Jonathan Moore
www.tvps.com
Nick Alberti
#2 Posted : Tuesday, February 14, 2006 5:13:48 PM(UTC)
Nick Alberti

Rank: Member

Joined: 9/27/2004(UTC)
Posts: 1,099

Is this happening on all orders or just this one?
jonm
#3 Posted : Tuesday, February 14, 2006 5:27:55 PM(UTC)
jonm

Rank: Member

Joined: 3/24/2005(UTC)
Posts: 311

I have only this one test order right now that I have tried. I will try another one and get back to you. But, let me point out that the order in question clearly is marked paid/unshipped and has a green icon associated with the order. If this is a problem then I would have a difficult time trusting any order that comes through the system and being exported by this product.
-Jonathan Moore
www.tvps.com
Nick Alberti
#4 Posted : Tuesday, February 14, 2006 7:43:50 PM(UTC)
Nick Alberti

Rank: Member

Joined: 9/27/2004(UTC)
Posts: 1,099

I suspect this incident is isolated to your store and this particular order.<SPAN style="mso-spacerun: yes"> Perhaps the order was edited in some way or some other action caused this?



I'm not aware of any issues importing orders.<SPAN style="mso-spacerun: yes"> I suspect if there was an outstanding issue with the Order Export tool and importing orders that many other customers would report such problems.



Are there any other customers having issues importing orders? Perhaps there are a set of actions that can be taken (that we're unaware of) that will prevent the Order Export tool from picking up the order.



The only other issue we're aware of with the tool is a problem with skipping orders that have already been exported into QB. BV will detect this order, yet it still prompts you each time versus skipping them. There is a work around for this issue so it shouldn't be a "show stopper".
jonm
#5 Posted : Thursday, February 16, 2006 11:14:23 AM(UTC)
jonm

Rank: Member

Joined: 3/24/2005(UTC)
Posts: 311

Hello Nick,

Running some more tests this is what I have found. It seems no matter what order paid order there is in our store it does not want to import the order. Here is the log of another order that I have done.

Attempting to Open QBFC4Lib Connection
QBFC4Lib Connection Opened
Using Company File Name: *edited*
QuickBooks Version = 4.0 - US
_orders Count = 1
Service Path = *edited*
Starting BVC 2004 Order Download at: 2/16/2006 8:10:30 AM
Finished BVC 2004 Order Download at: 2/16/2006 8:10:30 AM

Exporting Order: 516903
Checking for Duplicates
Checking for existing order at: 2/16/2006 8:10:30 AM
Finished Checking for existing order at: 2/16/2006 8:11:07 AM
Order Skipped as UNPAID
Not Setting Last Order Number
Finished Export of Order 516903
Order Export Time: 00:00:37.2998436
Total Export Time: 00:00:55.6373714
Skipped Orders:

516903


As you can see its the exact same problem as the other one.

So I ended up doing more tests on my side to see what I can do to import orders. I noticed an option to import all orders regardless of status. I choose that one and reran the import. To my surprise it imported the order. BUT!!! This means any ordere thats in our system will be imported into Quickbooks. This is something we DO NOT WANT. We only want to import the PAID orders.

I need to know why this is happening and what I can do to fix this problem?
-Jonathan Moore
www.tvps.com
Nick Alberti
#6 Posted : Thursday, February 16, 2006 12:18:28 PM(UTC)
Nick Alberti

Rank: Member

Joined: 9/27/2004(UTC)
Posts: 1,099

I believe the wording is a bit misleading in the Order Export tool. The order will need to be "Completed", not just "Paid" in order for the export tool to pick it up. Try completing the order and testing again. I've also updated your ticket. :)


Let us know if this works.
jonm
#7 Posted : Thursday, February 16, 2006 1:45:11 PM(UTC)
jonm

Rank: Member

Joined: 3/24/2005(UTC)
Posts: 311

Yep this works now if I go in and mark the order completed.

Do you think there might be a way to automate the mark completed process? Or is going to BVAdmin and manually marking orders completed the only way?

Thanks,
-Jonathan Moore
www.tvps.com
Nick Alberti
#8 Posted : Thursday, February 16, 2006 2:10:05 PM(UTC)
Nick Alberti

Rank: Member

Joined: 9/27/2004(UTC)
Posts: 1,099

When an order comes in, typically you'll complete the "Receive payment" and "Ship Item" screens. Of course this may vary, but if you completed these two screens, BV will automatically change the status to "Completed".


I believe your store is set up to process the credit card at the time of purchase, which should automatically mark the order as "Paid". The only screen you'll have to complete is the "Ship Items" screen.
jonm
#9 Posted : Thursday, February 16, 2006 2:16:13 PM(UTC)
jonm

Rank: Member

Joined: 3/24/2005(UTC)
Posts: 311

Ahh ok got ya. Silly me I didn't realize that.

Thanks
-Jonathan Moore
www.tvps.com
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012