Export of orders not working, what am I missing...

The AbleCommerce data exchange is a useful feature for importing and updating data. The Data Exchange feature (just like the 7.0.x data port) is only supported via the forums or paid support.

*** BACKUP YOUR DATABASE BEFORE ATTEMPTING TO USE THESE TOOLS ***
Post Reply
frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

Export of orders not working, what am I missing...

Post by frankenstein897 » Sat Oct 05, 2013 10:54 am

Export of Orders is not working. Export of products works. a 1kb csv file gets created in the dataexchange\download folder but it is empty. Products are a zip file and work as expected. Doesn't seem that permissions are the problem since there is a file there and the products work. Any idea of anything else I can check to get orders to export?
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Export of orders not working, what am I missing...

Post by jmestep » Mon Oct 07, 2013 4:05 am

I ran into an issue with an R4 site where they weren't able to export orders. The problem there was that if the order search results were more than one page of results, they wouldn't export. I had to set the orders grid to show more results per page to get past it. It was in the Manage-->Orders . I had to set the PageSize greater

Code: Select all

 <cb:AbleGridView ID="OrderGrid" runat="server" SkinID="PagedList" Width="100%" AllowPaging="True" PageSize="20"
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

frankenstein897
Commander (CMDR)
Commander (CMDR)
Posts: 159
Joined: Wed Feb 16, 2011 11:51 am
Location: Indiana
Contact:

Re: Export of orders not working, what am I missing...

Post by frankenstein897 » Wed Nov 06, 2013 8:37 pm

Hmmm... I can change the drop down to show all which happens to almost 2000 orders. But when I select all orders and click export I get this error:

The length of the query string for this request exceeds the configured maxQueryStringLength value.

Seems like it might be configured somewhere, just can't find it.
Thanks,
Chris

http://www.networkcablesonline.com
Network Cables Online, LLC
Running AbleCommerce GOLD R6

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Export of orders not working, what am I missing...

Post by jmestep » Thu Nov 07, 2013 6:18 am

maxQueryStringLength can be changed in the web.config file.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply