Preparing A CSV File Using XPS Ship | #1 Brilliant How-To Video | XPS Ship

YOUR SHIPPING INTEGRATION SOLUTION

Preparing A CSV File Using XPS Ship

Preparing Your CSV File

Preparing your CSV file is the first step to uploading a spreadsheet into XPS ship. Start by making sure that you have the minimum column requirements to upload your file. Fees are different for domestic versus international shipments.

Please know that you can have more columns in your spreadsheet than what is required. You don’t need to delete unnecessary columns as we can ignore them when we set up mapping within XPS ship. This means you will adjust your mapping to match your spreadsheet.

Domestic Requirements for CSV Upload

The required minimum columns for domestic shipments are:

  1. Order ID. This needs to be a unique number not repeated in shipments. Note, if you don’t have a column that would work for order ID, we can tell the system to create generic Order IDs when we do our mapping.
  2. Receivers name, this can be combined field with both first and last names, or the first and last name can be split into different columns;
  3. Receiver address line one,
  4. Receiver address line two,
  5. Receiver city,
  6. Receiver state,
  7. Receivers zip,
  8. Receiver country code,
  9. And receiver phone. Note, this is only required for shipping FedEx domestically.

In this example sheet, you will see the different columns and the header row. These are the required columns for domestic shipments. Remember that it isn’t important what order these columns are in just that they are on the spreadsheet.

International Requirements for CSV Upload

The columns that are required for international orders are:

  1. Order ID,
  2. Receivers name,
  3. Receiver address line one,
  4. Receiver address line two,
  5. Receiver city,
  6. Receiver state or province,
  7. Receiver zip or postal code,
  8. Receiver country code,
  9. Receiver number,
  10. Product title,
  11. Product price,
  12. Product quantity,
  13. Product weight.

Note, you can do one CSV mapping and upload for domestic and international shipments. You will just need to make sure you do the requirements for the international upload.

Now that you have the minimum requirements in your spreadsheet, you will need to save the file as a CSV.

The majority of spreadsheet files are:

To change the file type, you will need to go to File, Save As or Export, and change the file type to CSV. With your file ready, you can now map XPS ship for this specific CSV file.