Order Tracking and Estimates 0

[JRTownsend]

First basically everyone wants to know all the time when their grading will be completed and where their collectibles are. The current methods for estimating anything are completely arbitrary since everything is dependent upon current volume or "Work In Process."  For example saying my items are at "Scheduled For Grading" means literally nothing if you don't know how many items are in that pool and where yours falls in that "First In First Out" line. 

If you have a database where all items are given a number and if each "operation" has an ID (Received, Scheduled for Grading, Grading, Quality Check, Shipping, etc) then wouldn't it make more sense to incorporate an SQL query to pull in an orders item number, operation and Count of items ahead of you in that operation and plug that into the website? It could be all automated and update on a schedule or as people check their order status. Most likely for bandwidth the best idea would be to update the query like once a day.

I mean if I looked at my order and saw Item Number 1 is at Grading with 300 items ahead of it and then later checked and it said 200 items ahead of it... I wouldn't bother asking where my item is. I would just keep checking to see if it had moved closer. 

This would require each item being 'moved in' and 'moved out' of each operation as they are completed. Queries could be written to give you a lot of metrics based on that information. 

[Jennifer F.]

Hello,

Thank you for your suggestion!  We are always working on finding more efficient processing methods.  However, we are limited to what we can do with our current system.  But, hopefully, sometime in the near future we will be getting a new system that should allow for a lot of positive changes.  

Thank you!

[Dageaux38]

How can I check on the status of a submission older than 8 months? I have 4-25 book submissions out and 2 are no longer listed. Thanks!

[Scoobydiesel]

Oh man this would be such a nice update…. I really hope something is coming soon.

[JRTownsend]

It's basically what I do all every day at work. If you have a database (IBMDB2, Oracle, TSQL, etc) a query could be written fairly easily to do just this and that can be incorporated into HTML via several different methods. We use Python to create database websites that are user adjustable in the sense that they can enter a lot ID and search for it and pull up all the relevant data. Any IT type should be able to create something.