Is There A Csv Template For Stamp Music Service?

Import order information directly from whatsoever ODBC data source (*.csv or *.txt), impress USPS shipping labels, then postal service the tracking numbers back to your source file.

Note: ODBC (Open Database Connectivity) is not for beginners, just rather for customers already using CSV and Text files for sales and inventory management. Since source files are not standardized, every source has different parameters. If you are new to ODBC please contact our Customer Care aircraft experts for assist in connecting and setting upwardly your ODBC data source with Orders.

one. Log in to Stamps.com and select Orders.

two. Click the Import icon.

three. The Import Orders window will open. Click Download sample file to download Orders SampleCSV file.

4. Open up the downloaded Orders Sample CSV file.

Apply this template to enter your order data.

Note: The only required field to download an social club is Social club ID. The Order ID must be unique; no two orders tin can share the same Order ID.

Important Notation: All partial values must exist entered in decimal grade, ie not 3/4 merely .75. This applies both to weights as well equally dimensions.

Row 1 contains the column headers. Practise not rename or rearrange these headers.

Rows 2 and three contain instance values for each column. Delete these rows earlier you complete importing your lodge information.

Row 5 contains special information for formatting orders. Delete before you complete importing your guild information.

5. Once you have finished entering your order information, Rename and Salvage the CSV file in an easy to retrieve location on your computer.

half dozen. To Import CSV file orders, Click the Import icon.

7. The Import Orders window volition open. Click Select CSV File.

8. Select and Open your saved CSV file.

ix. Click Import. Your orders will be imported into Orders.

10. A Status Report is displayed. Click OK.

NOTE: If whatever of your orders did not import correctly, details will be displayed.

Import club data directly from any ODBC data source (*.csv or *.txt), print USPS shipping labels, so postal service the tracking numbers back to your source file.

Notation: ODBC (Open Database Connectivity) is non for beginners, merely rather for customers already using CSV and Text files for sales and inventory management. Since the source files are not standardized, every source has different parameters. If yous are new to ODBC please contact our Client Care shipping experts for help in connecting and setting upwards your ODBC data source with Stamps.com Orders.

If y'all are familiar with ODBC protocol, please follow these steps:

If yous are using an older version of our software please apply a Legacy Tutorial.

Connecting your ODBC information source

In Orders, Click Manage Data Sources.
Click Add together New Source .
SelectCSV/Text Fileand click Next.
The New Profile Wizard will open. Enter a name for this profile and click Next.
Select Select an existing ODBC information source and click Adjacent.
Enter the name of your ODBC information source in the drop down menu, and if needed, enter a username and/or passowrd. And so click Next.
The Map Fields window volition open up. Please follow on screen prompts and map equally much data, inclusing shipping options, in our ODBC mapping wizard. There are a lot of options. Since no ii ODBC data souces are the same, choose to map the data that is best for your business.
When finished mapping and setting profile options, click Done.
Click Done to close the Manage Profiles window.
Your new ODBC profile volition announced in the Profile Tree in Orders.

Importing orders from your ODBC data source

To import new orders, open up the Orders tab and clickImport Orders.

When importing orders from a CSV or Text file for the first time, PC Software Orders will import orders up to ninety days quondam. After that, orders are imported regardless of age.
Only "Non Printed" orders volition be imported. We will not import orders with a condition of "Printed" or "Cancelled".
All fractional weight and dimensions values must exist entered in decimal form.

Posting Dorsum

If yous have configured a Post Back information source, shipping data you specified (eastward.thousand. tracking number) will be posted back as a new row in the data source.

Editing your ODBC Profile

An ODBC Profile can be edited at any fourth dimension:

Open the Manage Profiles dialog:

Click Manage Information Sources.
Select Edit Source .
Select the Profile to update and click the Edit button.
From the Edit Profile window select whatsoever of the links to alter profile proper noun, original data, or postback information. Each link volition brandish a different window. When finished making changes, click Side by side.
From the Profile Options window you can change any of the default values for your imported orders. When you are done click Done.

1. Log in to Endicia and select Orders.

2. Click the Import icon.

three. The Import Orders window will open. Click Download sample file to download Orders SampleCSV file.

4. Open the downloaded Orders Sample CSV file.

Use this template to enter your order information.

Notation: The only required field to download an guild is Social club ID. The Order ID must be unique; no two orders can share the same Order ID.

Important Notation: All fractional values must be entered in decimal form, ie non 3/4 merely .75. This applies both to weights every bit well as dimensions.

Row 1 contains the cavalcade headers. Do non rename or rearrange these headers.

Rows 2 and 3 comprise example values for each column. Delete these rows before y'all consummate importing your club data.

Row 5 contains special information for formatting orders. Delete earlier you complete importing your guild data.

5. Once y'all have finished entering your society information, Rename and Save the CSV file in an piece of cake to remember location on your figurer.