Downloading order database

General ShopSite user discussion

Downloading order database

Postby kiltym » Wed Aug 09, 2017 11:37 am

Running 12 sp2.

Trying to download a full order database to excel.

I access Utilities->Database->Download.

Select "All orders".

The file that I get is only a fraction of them, like the first 200 or so......

If I put in a year date range, same thing, only get like the first 200 for that year.....??

Why is this not actually giving me "all orders" when I select that option?

Thank you!
Posts: 29
Joined: Tue Dec 08, 2009 12:00 pm
Location: MA

Re: Downloading order database

Postby cyoung » Thu Aug 10, 2017 1:06 pm

You are running an older version 12 of ShopSite. The first thing to try should be to upgrade to a newer version.

Note: if you are using any 3rd-party services in ShopSite, like payment gateways, paypal, real-time shipping quotes, Avatax, Doba, Constant Contact, etc, you will need to upgrade soon for TLS 1.2 compatibility anyway.

Posts: 11
Joined: Wed Nov 09, 2016 11:01 am

Re: Downloading order database

Postby kiltym » Fri Aug 11, 2017 7:45 am

According to these:

12 sp2 has TLS 1.2....

The functions in sp3 we don't need, so have not upgraded.

Anyone else know why the database download is not working? Could it be some constraint on our MySQL limiting the max rows?
Posts: 29
Joined: Tue Dec 08, 2009 12:00 pm
Location: MA

Re: Downloading order database

Postby robm » Fri Aug 11, 2017 10:29 am

Is it always the same number of orders? Or is it around the same? If it's not exact, your web host may be limiting the CPU and/or memory used to download the data.

Another option is to try it in a different browser like Firefox or Chrome, to rule out your browser terminating the connection. Do you have access the web error logs? Those may shed some light on the issue.

You should reach out to your web host, as they can help troubleshoot this issue.

Posts: 459
Joined: Fri Aug 04, 2006 5:46 pm
Location: Connecticut

Return to User Forum

Who is online

Users browsing this forum: No registered users and 1 guest