Etsy's Handmade Blog
Tech Updates: Item Status and Shipping Address Added to Sales Data CSV Download

We have updated the data that is available in sellers' CSV download file, available on the "Sold Orders" page in Your Etsy.  This comma delimited file shows orders for your Etsy shop, and we have appended the following columns to the end of this file:

  • Ship Status: Shows the date the item was marked as shipped by the seller.  If this field is blank, the item has not yet been marked as shipped.
  • Paid Status: Shows the date the item was marked as paid, either by the seller or automatically after a notification through Paypal.  If this field is blank, the item has not yet been marked as paid.
  • The shipping address of the buyer provided during checkout, which includes:
    • Ship Name: The first and last name of the shipping recipient
    • Ship Address1
    • Ship Address2
    • Ship City
    • Ship State
    • Ship Zipcode
    • Ship Country

These updates will provide you better information on the status of orders and provide a means to export shipping addresses for bulk shipping.  Finally, we will continue to evaluate additional data that we can provide sellers to improve the order to ship process.

To learn more about our CSV download, read the previous article on downloading sales and billing data.



ps
If you want to get the breaking, vital Etsy news as it happens — delivered straight to your email inbox, then sign up for Etsy News Alerts emails. Read more about it hereExpect this as an Etsy Alert email in your inbox if you already subscribe to the list.

You can also get an RSS feed of all TechUpdates here.

Tags business, CSV file, data, ETSY NEWS, management, orders, organizing, selling, shipping, site features, spreadsheets, tools, Your Shop
All articles in Etsy News
Related Items
This article was reported by:
Etsy Admin
kutty

TechUpdates

26 comments     Login to add your own!

Jan. 8, 2009 at 6:26 p.m. MikeRowe

More useful information, thanks guys!!

Jan. 8, 2009 at 7:09 p.m. 4TheSparrowsNest

The owl popsicle!! LOL!! Thanks again Etsy for all your hard work making this venue an even more excellent place.

Jan. 8, 2009 at 7:15 p.m. BeadBead

THANK YOU!!
I just checked the CSV file, and it seems that there is a TON more information, since the last time I checked, this is awesome! Now I can automate a comparison with my PayPal data and GRAB THE ETSY USER NAME very easily to autofill my field in my file, THANK YOU so much, this is huge for me, I was entering the "Etsy World User Name" by hand. Really. tons of thank you's for doing this update. xoxoxo

Jan. 8, 2009 at 7:21 p.m. GoldtoneDesigns

Thank YOU!!!!!!!!!!!!!!

Jan. 8, 2009 at 7:35 p.m. wiredoriginals

sweet!

Jan. 8, 2009 at 7:52 p.m. lulidesigns

Fantastic! That info will be so useful to have added as I use to add all that info manually! Thanks

Jan. 8, 2009 at 7:59 p.m. TwinDreamCreations

great news!!!!!

Jan. 8, 2009 at 8 p.m. shellieartist

great info and really useful update! Thanks admin (and thanks for putting one of my pieces in here :) hee hee

Jan. 8, 2009 at 8:28 p.m. RaeGun

very interesting...thanks

Jan. 8, 2009 at 8:52 p.m. DeNovoStyle

Thanks Etsy team! I can't wait to put this to good use!

Jan. 8, 2009 at 8:55 p.m. AlloverArt

Very cool! Gracias!

Jan. 8, 2009 at 9:34 p.m. worksandfinds

Thanks you hard working guys. You are awesome.

Jan. 8, 2009 at 9:57 p.m. rkdsign88

Wow..love this CSV file, it is automatically do it for us & has more information. Thank you very much!

Jan. 9, 2009 at 2:51 a.m. TheChainmailleLady

Thank you so much for the update, makes it easier to make mailing labels!

Jan. 9, 2009 at 3:50 a.m. Sinta

Great! Thanks so much ^_^ This is going to come in handy!

Jan. 9, 2009 at 7:58 a.m. AutumnLeavesJewelry

Awesome updates! Thank you!

Jan. 9, 2009 at 8:21 a.m. magpieknits

Good Update! Thanks.

Jan. 9, 2009 at 9:42 a.m. Melindamilkshake

Very nice. Etsy is becoming more and more streamlined all the time.

Jan. 9, 2009 at 9:55 a.m. threepeats

Thanks! You guys certainly are on top of things!

Jan. 9, 2009 at 10:45 a.m. MiaRae

Thank for the updates!

Jan. 9, 2009 at 11:21 a.m. BluCille

Neat bird pullover!

Jan. 9, 2009 at 12:45 p.m. LaireMarie

The FlufferNutter Looks AWESOME!!!!

Jan. 9, 2009 at 2:33 p.m. nfall2rt

Thanks, very useful updates!

Jan. 11, 2009 at 3:31 p.m. truLuxe

I'll check it out!!!!

Jan. 12, 2009 at 7:55 a.m. XOHandworks

This will save me a lot of typing -- THANKS!!

Jan. 28, 2009 at 12:41 p.m. artis3letters

whoa ho ho! That's my painting used as an illustration for the story. That's awesome. Thanks for the add, kutty!

Previous Page | Next Page