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

Notification

Icon
Error

GHanlon
#1 Posted : Monday, March 02, 2020 5:06:32 PM(UTC)
GHanlon

Rank: Member

Joined: 2/24/2016(UTC)
Posts: 75
United States

Thanks: 10 times
I'm trying out the Customer List report. Love it! I am, however, currently running into a couple issues:
1. I'm unable to run a report containing more than one product SKU at a time
2. There is a server error whenever I run a particular SKU. I'm theorizing this is due to the sheer amount of orders that contain this particular SKU

Is the report meant to be used for only one SKU per run?

Any recommendations regarding the second issue?
Aaron
#2 Posted : Tuesday, March 03, 2020 2:15:58 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,308
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 150 time(s) in 145 post(s)
The query that this report runs is very inefficient. For one, it runs over all time (i.e. all orders), so if you have a large number of orders you run a greater risk of timeouts. Ditto for user accounts--the more you have the slower it will run. Adding multiple SKUs just compounds the performance problems.

The Customers Who Purchased report is significantly faster and allows you to specify a date range, but it does not give you sale counts.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
 1 user thanked Aaron for this useful post.
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.

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