• 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 2, 2020 5:06:32 PM(UTC)
GHanlon

Rank: Member

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

Thanks: 13 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 3, 2020 2:15:58 PM(UTC)
Aaron

Rank: Administration

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

Thanks: 6 times
Was thanked: 158 time(s) in 153 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.

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