Autofill Names & Addresses

How to preload names & addresses into Pirate Ship for auto-fill

Updated over a week ago

When creating a single label, you can save time using auto-fill suggestions. Sometimes it might even be helpful to preload a list of names with addresses into your cache so autofill is even more helpful. That way you can start typing a name and autofill will have the rest of the associated information.

Preloading your cache is kind of a work-around, so make sure you follow these instructions and don’t click the Buy button! 

You can preload your cache by uploading any CSV, Excel, or OpenOffice file, and the data can be formatted in any way, it just needs to be in separate columns with header-titles.

A screenshot of an address spreadsheet. The data is separated into columns for 'Name,' 'Company,' 'Address,' 'Address Line 2,' 'City,' and the remaining parts of an address.

Generally, whatever your ecommerce or order management platform exports by default should work. However, if you're creating your own spreadsheet, the only required data is: name, street address, city, state, and zipcode. 

A screenshot showing an address spreadsheet with columns for 'Name,' 'Street Address,' 'City,' 'State,' and 'Zipcode.'

On the Ship page, click and browse for the spreadsheet file or just drag’n’drop! 

A screenshot of the top of the Ship Page on Pirate Ship. A mouse cursor is dragging a .xls file towards the 'Upload Spreadsheets' button in the top center of the page, to automatically upload the file.

Pirate Ship will remember how you’ve mapped your spreadsheets before based on your header-titles, but you can always double-check and make any adjustments you need.

A screenshot showing the Field Mapping page that appears after a spreadsheet is uploaded. The different column headers on your spreadsheet are listed towards the left, and drop down menus to map this data appears on the right.

Next we need to provide dummy package details. These details are not important because you are not creating a real batch, so for now just use 8 x 8 x 8, 1 pound, 1 ounce—and if your spreadsheet contains an international address you’ll have to fill out the customs form—quantity 1, any description, declared value $1, and 1 ounce. 

A screenshot showing the Create a Shipping Label page. Here, you'll need to fill out the package information to be able to click the Get Rates button at the bottom right corner of the page.

Now just click the Get Rates button, and voila, your names and addresses are now loaded!

Be sure to click Cancel & Delete Labels so you don’t accidentally buy a batch of labels!

A screenshot showing the bottom of the Rates page. At the bottom left hand corner, click 'Cancel and Delete Labels.' Do not click the green 'Buy Labels' button at the bottom right corner.

Now if you head to the ship page to create a single label, you can start typing a name to see that Pirate Ship has catalogued your list of names, and the associated addresses.

A screenshot showing the Create a Shipping Label form. If you start typing the name of one of your recipients on the spreadsheet, the rest of their information should automatically populate if you click their name on the drop down menu that appears below.

Pirate Ship will save these uploaded addresses for 3 months, and will re-save that information every time you ship to that recipient.

Note that this is a work around, and Pirate Ship will have a better way to do this in months to come ;)

Did this answer your question?