What we collect!

 

Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps
Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps
Stamporama Discussion Board Logo
For People Who Love To Talk About Stamps



What we collect!
14 visitors online
What we collect!
14 visitors online


Sales, Swaps, Auction & Approvals/Auction Disc. : Question About Bulk Upload Utility...

 

Author
Postings
PDougherty999
Members Picture


03 Feb 2013
03:30:00pm
So for the new year, I've spent the last two weeks retooling my Excel inventory spreadsheet that keeps track of items that I plan to sell so that I can easily copy and paste and make a CSV file that's compatible with the Auction Lot Upload Utility. I was planning on giving it a try this coming Friday.

When the Bulk Upload is done, do those lots automatically go live? Or can they be set to be on hold for a final review? Thanks.

---Pat
Like
Login to Like
this post
auldstampguy
Members Picture


Collector, Webmaster

03 Feb 2013
06:18:34pm
re: Question About Bulk Upload Utility...

Hi Pat,
Yes you have the option of placing them on hold. As you go the the upload process you'll see what I mean.

Regards ... Tim

Like
Login to Like
this post

mncancels.org
PDougherty999
Members Picture


03 Feb 2013
08:56:28pm
re: Question About Bulk Upload Utility...

Thanks Tim.

Like
Login to Like
this post
PDougherty999
Members Picture


04 Feb 2013
10:33:43pm
re: Question About Bulk Upload Utility...

So, I'd like to say that the Bulk Upload Utility is a very cool addition to the auction, especially if you're anal retentive about your inventory like me and keep it all documented by Excel spreadsheet. It worked very well for me and I couldn't be happier with this piece.

A couple of pointers that I'd like to make based on my own mistakes and rustiness with using a CSV file...

1) Avoid comas in any of your descriptive texts as it will just confuse the system which is based on Comma Separated Values (CSV).

2) Apparently, apostrophes are not recognized either so avoid them if you can. I'm now having to go through 100 some lots to correct the word "I've".

Thanks again to the Web wizards for implementing it.

---Pat

Like
Login to Like
this post
Rhinelander
Members Picture


Support the Hobby -- Join the American Philatelic Society

06 Feb 2013
05:26:26pm
re: Question About Bulk Upload Utility...

Just press CTRL + H (= replace) and change all "I've" with "I have" in one swoop.

Like
Login to Like
this post
        

 

Author/Postings
Members Picture
PDougherty999

03 Feb 2013
03:30:00pm

So for the new year, I've spent the last two weeks retooling my Excel inventory spreadsheet that keeps track of items that I plan to sell so that I can easily copy and paste and make a CSV file that's compatible with the Auction Lot Upload Utility. I was planning on giving it a try this coming Friday.

When the Bulk Upload is done, do those lots automatically go live? Or can they be set to be on hold for a final review? Thanks.

---Pat

Like
Login to Like
this post
Members Picture
auldstampguy

Collector, Webmaster
03 Feb 2013
06:18:34pm

re: Question About Bulk Upload Utility...

Hi Pat,
Yes you have the option of placing them on hold. As you go the the upload process you'll see what I mean.

Regards ... Tim

Like
Login to Like
this post

mncancels.org
Members Picture
PDougherty999

03 Feb 2013
08:56:28pm

re: Question About Bulk Upload Utility...

Thanks Tim.

Like
Login to Like
this post
Members Picture
PDougherty999

04 Feb 2013
10:33:43pm

re: Question About Bulk Upload Utility...

So, I'd like to say that the Bulk Upload Utility is a very cool addition to the auction, especially if you're anal retentive about your inventory like me and keep it all documented by Excel spreadsheet. It worked very well for me and I couldn't be happier with this piece.

A couple of pointers that I'd like to make based on my own mistakes and rustiness with using a CSV file...

1) Avoid comas in any of your descriptive texts as it will just confuse the system which is based on Comma Separated Values (CSV).

2) Apparently, apostrophes are not recognized either so avoid them if you can. I'm now having to go through 100 some lots to correct the word "I've".

Thanks again to the Web wizards for implementing it.

---Pat

Like
Login to Like
this post
Members Picture
Rhinelander

Support the Hobby -- Join the American Philatelic Society
06 Feb 2013
05:26:26pm

re: Question About Bulk Upload Utility...

Just press CTRL + H (= replace) and change all "I've" with "I have" in one swoop.

Like
Login to Like
this post
        

Contact Webmaster | Visitors Online | Unsubscribe Emails


User Agreement

Copyright © 2023 Stamporama.com