Total Pageviews

Saturday, July 22, 2017



Prepare your shipping confirmation file

After you receive an order notification and ship the order, you must confirm shipment. You can use the Shipping Confirmation template to upload confirmation information for multiple orders in a single file. This template includes validation macros that will help you successfully complete the template. You can choose whether to turn these macros on or off. We suggest that you keep them on until you learn how to use the template.
Note: If you split an order into multiple shipments, the entire order is charged and assigned the status "Payment Complete" as soon as the first shipment for the order is confirmed, even if there are more shipments yet to be made.
To prepare your Shipping Confirmation file: 
  1. Download and save a copy of the Shipping Confirmation template.
  2. Open the file and review the Instructions and Data Definitions tab.
  3. On the ShippingConfirmation tab, enter your shipping information, referring to the Data Definitions tab when necessary, especially the Important Notesand formatting guidelines (Accepted Values).
    Note: Set all of the columns to Text format (including ship-date) to prevent Excel from removing any leading zeroes. Enter ship-date in the following format: yyyy-mm-dd.
  4. When updating previously existing shipping information, select from the following options based on the result you want:
    • Overwrite previously existing data: New data will overwrite or replace the existing data.
      Example: New data in the tracking-number field will overwrite the existing data in tracking-number.
    • Do not overwrite previously existing data: An empty (blank) field will not overwrite or nullify the existing data.
      Example:  Leave the tracking-number blank so the previously uploaded data will remain (will not be overwritten nor nullified).
    • Delete previously existing data: Enter "NULL" (without the quotation marks) or leave the field empty (blank), and the data in that field will be deleted.
      Example: Enter "NULL" into the tracking-field or leave it empty (blank) to delete and nullify the previously uploaded data.
    Note: If an order includes more than one product or more than one unit of a product, and you are splitting the order into more than one shipment, then you need to include the following fields for each of the shipping confirmation records:
    • order-id
    • order-item-id
    • quantity
    • ship-date
  5. When you are finished, click Save As and select Text (Tab-delimited) (*.txt) from the file type list.
    • If you see a warning that the selected file format does not support workbooks containing multiple worksheets, click Yes.

Upload your shipping confirmation file

Once you have finished adding shipping information, upload your file on the Upload Order Related Files page.
To upload your Shipping Confirmation file:

  1. On the Orders link, select Upload Order Related Files.
  2. Select Shipping Confirmation at the top of the page.
  3. Under Upload Your Shipping Confirmation File, click Browse to locate your tab-delimited text file.
  4. Select the file and click Upload now.

Shipping confirmation fields

Not all fields are required. However, it is in your best interest to provide as much information as possible.
Field NameDefinitionRequiredAccepted ValuesExample
order-idUnique identifying number for an order. This number is provided in your Orders report and the Manage Orders tool.YesAlpha-numeric text 3-7-7 format058-3563777-5518068
order-item-idUnique identifying number for an item in an order. This number is provided in your Orders Report and on the Order Details page in Manage Orders.
Note: This is not the same as the product ASIN. The
order-item-id differs from order to order.
NoAlpha-numeric text 14 characters05835637773451
quantityItem quantity included in this order if more than one unit of an item was ordered.
Note: If you split an order, you must include a quantity in the shipping confirmation for each shipment, so customers know how many items to expect in each package when it arrives.
NoA positive integer1
ship-dateDate that you shipped the order.YesFormat: yyyy-mm-dd2005-11-19
carrier-codeAmazon's code for the shipping carrier that delivered the order, chosen from a drop-down menu. Note: If you are using an unlisted carrier, select "Other" and then enter the carrier name in the carrier-name field.No
  • A-1 Online
  • Canada Post
  • DHL
  • DHL Global Mail
  • FedEx
  • FedEx Smartpost
  • Lasership
  • Newgistics
  • OnTrac
  • UPS
  • Urban Express
  • USPS
  • Other
carrier-nameShipping carrier that delivered the order. Use only if carrier-name is "Other."NoAlpha-numeric text 1 to 50 charactersRoadway Express
tracking-numberShipping carrier's tracking ID for the order.NoAlpha-numeric text 1 to 50 characters22344455
ship-methodShipping method used to deliver the order. Best practice is to include the carrier name to ensure clarity.NoAlpha-numeric text 1 to 50 charactersFirst Class - UPS FedEx Ground

Note: For Premium Shipping a valid tracking ID is required for most orders. Failure to meet the required tracking rate for Premium Shipping orders may affect your eligibility to offer Premium Shipping Options. If you sell in the Office Products or Shoes categories, you're required to provide valid tracking numbers for 95% of US shipments. For more information, see Requirements for Two-Day Shipping and Valid Tracking Rate.

No comments:

Post a Comment

Post your comments: