The Orders section defines general order information:

• Source: Identifies the sales channel/order source for the order.      
  When mapped, the Source and Number fields are used together to uniquely identify an order in Postsale.
• Number: The order number/ID of the order. Used to uniquely identify orders in Postsale.      
  If the Number field is unmapped or if no order number is imported, Postsale will auto generate sequential order numbers for you.
• Status: Identifies the status of the order. (shipped, not shipped, backordered, etc.)
• Requested Shipping: Identifies the shipping method requested by your customer.
• Date: The date the order was placed.     
  

The Ship To and Bill To addresses are mapped together by default. Check the Map Bill To and Ship To Separately option to map them independently. 

Use the Items category to map the details of the items on your orders. There are two line item strategies available.

• All items are on a single row in your source file
• Items are on multiple rows in your file

Follow the steps below for the strategy that matches how your file is configured. 

All Line items are on a Single Row

Select Single Row from the Item Strategy drop-down menu if all items for a single order are listed on a single row in your source file.     

Then, create the map for the maximum number of line items on a single order. 

For example: Using our scenario, we would map for 2 line items since we will be shipping a T-shirt and a bumper sticker with each order for STL Dog Saver. Here’s how: 

1. Click the Add button.    
      
    
2. Map the fields on the Item Map pop-up. Then, click Save.    
      
    
3. Repeat steps 1 and 2 for each line item.    
      
    

Line Items are on Separate Rows

Select Multiple from the Item Strategy drop-down menu if the order’s items are listed on separate rows of your source file.    

Then, map the fields in the Items category.    

Use the Charges section to map additional order charges, such as Tax, Shipping, Discount, Insurance, or Other charges. 

1. Click the Add button.    
   
    
2. Map the following fields:
   1. Description: Map to the field in your file that describes the additional charge on the order.
   2. Amount: The amount of the additional charge.     
       
3. Select the type of charge from the Type drop-down menu. 
4. Click Save.    
   

Add as many charges as needed for the orders in your file. 

Use the Payment section to map the payments for orders in your source file. 

1. Map the Name and Amount fields.
   1. Name: Map to the column in your file that contains the payment type. (PayPal, Credit Card, etc.)
   2. Amount: Map to the column containing the amount of the payments.    
         
       
2. Click the Add button to map additional payment details such as the last four digits of a credit card number, the credit card security code, etc.    
   

Use the Notes section to map to notes related to the orders in your source file. Add a map for each note associated to your orders.  

For example: If you have a thank you message to your customers and an internal note for each order, you will add two note mappings. 

1. Click the Add button.
2. Map the Date and Content fields.
   1. When the Date field is unmapped, Postsale assigns the current import date.
3. Click Save.    
   

The Shipment section gives you the ability to map the shipment details for each order in your source file to the appropriate shipment fields in Postsale so that a shipment is automatically created for each order when your file is imported.

This has several, powerful advantages:

• It saves time. You won't need to create a shipment for each order after the import is complete.
• You can preview and select rates for each shipment as soon as your file is imported.
• Imported orders can be batch processed right away since each order is already configured with valid shipment details.

 Real World Example

Using the example from the beginning of this article, let's assume that St. Louis Dog Saver specified the following shipment details for their Dog Saver T-shirt promotion: 

• Carrier: USPS
• Service: USPS Ground Advantage
• Package dimensions: 
  • Length 12"
  • Width 8"
  • Height 2"
• Weight: 1.25 pounds

We added this information to the CSV file so that a shipment with the specified shipment details will be created for each order when imported.

Available Shipment Fields