Archiving the oldest orders

jeremyn

Hi everyone,

If you have been looking at the Service thread last week, you may have noticed that we performed a website maintenance on Wednesday night. The purpose of this maintenance was to archive some of the data which was used on the "My Recruits" page.

We had already limited the display of data on this page to two Payback periods (the current period, and the last complete period), what we did last week was to archive some of the data which was too old to be displayed.

We have been working on archiving data on this page for two reasons:

to improve performance: If there are a lot of data to go through, the page takes much longer to load and slows down the whole website. We are also looking at other clever database tricks to improve the performance.
to free some valuable storage space: Archiving unused data helps us stay lean

Archiving the data on the "My Recruits" page is only one step of the work we are doing to improve the reliability and performance of the website.

We are now looking ahead and are planning to do a similar operation on the "My orders" page. The current plan is to archive the data which is older than the 01/11/2013. We are looking at doing this on the night of the 25/02 but we may adjust this date as we refine the details.

This will allow us to archive a significant amount of data, while keeping a lot of orders available to the members.

To help you measure the impact of this change, only 11% of members coming to this page are looking further than the last 5 transactions, much less to anything which is more than a few months old. Keeping more than one year of data available would cover this need.

If you like to keep a very tight record of your operations, we advise to make a copy of your oldest orders ahead of the 25/02.

Records of older top-ups, goodybag purchases and payback payments will still be available to the agents after the orders have been archived. Please make sure to communicate the date and the details of the order you are asking for so they can find it for you.

I think we found the right balance between performance and accessibility of the information but I'd like to hear from you if you think that we missed something.

Thank you for your help,

Jeremy

w69d

while you're doing the my recruits page is there anychance in bringing back the username of the recruited member , in the recruits email .........please

brulaw

@jeremyn ,

Thanks for the update / information ...... keeping things uncluttered is a good idea .

saarahibrahim

Thanks for the update!

natty88

i agree with @w69d on that one 🙂

i_am_sy

Great seems planed for my Birthday lol

jeremyn

Good morning @w69d ,

It's on the to-do list 😉

We had an issue with this message because the email was using data from the recruiter instead of the recruit. This is being looked into but it can still take some time before we crack it.

ma2013

Great idea to free up some space. Now to improve data speeds (part 2). ☺

mark1101b

Thanks for the Info, Jeremy.....any chance of adding a few recruits to my list lol .....

w69d

@w69d ,

It's on the to-do list

We had an issue with this message because the email was using data from the recruiter instead of the recruit. This is being looked into but it can still take some time before we crack it.

But it seems you've removed the (correct) recruit info and left behind the (wrong) recruiter mobile number information

Wouldn't it have been easier to just take away the wrong piece of information than the correct part ???

philbond

@jeremyn when you mention the "my orders" page, are you referring to the "My Order History" page?

jeremyn

Hi @w69d, I have not been checking this particular email myself so I can't really comment but I'll forward your feedback for when this email is corrected.

@philbond, yes that's the one

w69d

@philbond wrote:

when you mention the "my orders" page, are you referring to the "My Order History" page?

Well that's one less way to find out when you activated your giffgaff simcard (if it's before 1/11/13 ) , looks like everything recently has the same affects , less information

philbond

@jeremyn thanks 🙂

also, if the activation email is being looked at:-

1. Can you include "sim in a box" as we don't get notified when one of these is activated at present?

2. Could the activation code be included too? the username isn't always known to us and the name of the activator doesn't always match the name of the person who ordered the sim but the activation code helps us identify which sim has been activated.

thanks

Phil

gordie10

This sounds sensible enough to me.

But I know a fair few members have been unhappy at the changes to the availability of "My recruits" information, because with any SIM card orders that are activated a significant amount of time after they were initially ordered (as many are), it's now impossible to link the activation to the order if the order preceded the last full payback period. This means recruiting members are entirely reliant on receiving an e-mail to confirm that they're due 500 payback points for the SIM card order, so that they can be certain of the amount of recruitment payback they should expect to receive each month. Not ideal.

navvy

The number of ordered sims could be archived, so far as I am concerned. Mine shows all the sims I have ever ordered, even though some are so old that they aren't 4G and can't be used for sim swap. I'm very unlikely to use them, especially that batch of hybrids that fall apart too easily in some old phones.

jeremyn

Good morning and thank you for all your comments.

I hear interesting things here about how recruiters would like to be able to track their recruits better.

Archiving the orders is a balancing act between convenience and performance, but ultimately it's not possible to keep all the orders on the website. This being said, it should not stop us from looking at solutions to help the recruiters which would have less impact on the performance of the website.

This is not something I can address as part of this project, but iIf someone is interested in gathering their needs from the recruiters and raise an idea about it, it would help understand their need better.

[Oups... I had posted this one from a test account originally - #morningmistakes]

philbond

@bluemoonbaz before submitting them.

sim in a box email notifications (activation) was one of them.
queued goodybags counting for topup bonuses was another.
relaxing the parameters (30-60 days and 60-90 days) for qualifying topups was another (early goodybag purchases makes these parameters restrictive). I suggested 2 topups in 90 days should count.
sim swaps showing in recruits list and being identified as sim swaps was another.

there were other suggestions too.

If you want me to forward them to you by PM, let me know.

Phil

bmw4175

That reminds me. I posted an idea about getting emails from the sim in a box activations and some time ago gg was meant to sort that out.

Let me look for the idea and I'll paste it here

bmw4175

@bmw4175 wrote:
That reminds me. I posted an idea about getting emails from the sim in a box activations and some time ago gg was meant to sort that out.
Let me look for the idea and I'll paste it here

http://community.giffgaff.com/t5/Submit-Great-giffgaff-Ideas/sim-in-a-box-email-notification-of-a-activation/idi-p/11539201