What we collect!
Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps


70 visitors online

Sales, Swaps, Auction & Approvals/Approvals Disc. : Adding a "Purchased by" to approval book items

AuthorPostings
cougar
Members Picture
09 Sep 2018
04:37:10pm

Auctions - Approvals
I went through old approval books that I listed months ago, trying to close them and release the remaining stamps to be used again.

The little problem I have is I still have some stamps that belong to someone's order, but I have no idea who bought them. I know the person did not buy enough to make me invoice him / her.

Is there a way to add the user id to the sold line appearing on the approval page beside the item number?

Thanks!
Like
Login to Like
this post
smauggie
Members Picture
09 Sep 2018
04:51:28pm
re: Adding a "Purchased by" to approval book items

Your sold lots should show up in the View Sold Lots option in the Sellers drop down menu.

Do note that the default time frame for this feature is 7 days but that can be changed to be up to 365 days back.


Like
Login to Like
this post

canalzonepostalhistory.wordpress.com
cougar
Members Picture
09 Sep 2018
11:20:19pm

Auctions - Approvals
re: Adding a "Purchased by" to approval book items

If I have to go back 365 days, this will be thousands of records that I will need to scroll through to find the one I need. If I miss it, I will have to go through them again. If I have more than 1 item I am trying to find, the process will need to be repeated N times.Happy

Just found a sold item that is not among the items waiting to be invoiced. I wanted to confirm I did not miss to ship it.

Like
Login to Like
this post
smauggie
Members Picture
10 Sep 2018
12:16:40am
re: Adding a "Purchased by" to approval book items

Did you know that you can search a webpage for a particular string (like a name) using the CTRL-F function?

Like 
1 Member
likes this post.
Login to Like.

canalzonepostalhistory.wordpress.com
michael78651
Members Picture
SOR Auctioneer
10 Sep 2018
01:41:46am
re: Adding a "Purchased by" to approval book items

The items sold list is compiled by buyer. You can look for items sold from 1 day up to 365 days, starting by days, then weeks, then months depending how far out you want to look.

A trick you can do to check for items that have been sold, but not paid for is to create invoices. This will be quicker than looking through thousands of item numbers, and you'll find out right away what hasn't been paid for. If you have no intention of billing for the stamps, then simply do not send the invoice to the buyer.

Like
Login to Like
this post

"My book, "The Whitechapel Fog" is available on Kindle!"

www.hipstamp.com/store/the-online-stamp-shop
cougar
Members Picture
11 Sep 2018
12:32:29am

Auctions - Approvals
re: Adding a "Purchased by" to approval book items

Smuggie, your idea is nice. It would have saved me time if I searched by the approval book number!

About 15 years ago I did use mySQL to write queries and pull out information from tables, create the appropriate reports, forms and all that is needed. It wasn't very time consuming. Create it once and it saves a ton of time.

A query looked something like "SELECT ALL FROM TABLE WHERE FIELD NAME-RECEIVED =False" etc.

I thought of this one because it will also be nice to be able to sort through the purchased lots (by me as a buyer) based on which ones were not received by me. Visibility there is only 120 days back though. It would be nice to have the same 365 day window. Just suggestions; hope something is useful.

Like
Login to Like
this post
michael78651
Members Picture
SOR Auctioneer
11 Sep 2018
09:30:50am
re: Adding a "Purchased by" to approval book items

Quote:

"it will also be nice to be able to sort through the purchased lots (by me as a buyer) based on which ones were not received by me. Visibility there is only 120 days back though. It would be nice to have the same 365 day window."



I agree with the 365 day consistency throughout the search time windows. Let's see what our Wizard says about it when he gets a chance to chime in.
Like
Login to Like
this post

"My book, "The Whitechapel Fog" is available on Kindle!"

www.hipstamp.com/store/the-online-stamp-shop
        
Please Note:
Postings that were loaded from the old Discussion Board cannot be edited.

Contact Webmaster | Visitors Online | Unsubscribe Emails


This site is provided by Roy Lingen at www.buckacover.com

User Agreement

Copyright © 2020 Stamporama.com