CSV Order Import

Overview

This article explains how to import orders into StoreFeeder using a CSV, XLS, or XLSX file. Use this feature to manually bulk-import orders from any source.

Setting up your import file

In some instances your columns may contain multiple data types. For example, your postcode column may contain UK postcodes (text) and foreign postcodes (numeric), or your SKU column may have a mix of purely numeric and alphanumeric values.

If this is the case you MUST:

• Format that column as Text in Excel.
• Save the spreadsheet as a .XLS or .XLSX file to preserve that formatting.

Failure to do this may result in data loss when orders import.

When importing dates via CSV, use the format DD/MM/YYYY HH:MM:SS.

Importing orders

1. Click on Orders in the top menu, then select CSV Order Import.
2. From the dropdown, select the channel you want to import orders to.
3. Click Select File and browse to your file. Supported file types are .XLS, .XLSX, and .CSV.
4. Once the file is uploaded, the mapping section appears. Map each column in your file to the corresponding StoreFeeder field using the dropdowns.

The fields are split into six sections:

• Order Information
• Billing Address
• Shipping Address
• Product Information
• Shipping Information
• Payment Information

To map a field, select the matching column name from the dropdown next to each StoreFeeder field. For example, if your file has a column called OrderNumber that you want to use as the Order Reference, select OrderNumber from the Order Reference dropdown.

Leaving a field at the default Please Select means it will not be mapped.

Required fields

The following fields must be mapped for orders to import successfully:

• Order Reference — must be unique; duplicate order references cannot be imported
• Customer First Name
• Customer Last Name
• Shipping Address First Line
• Shipping Address City
• Shipping Address Postcode
• Shipping Address Country
• Ordered SKU
• Ordered Quantity
• Ordered Product Price

If any required fields are missing, an error message identifies which fields need to be supplied.

Billing address information is optional. If you do not provide a separate billing address, the shipping address is used as the billing address.

Saving your mapping as a default

Once all mappings are set, click Confirm Mappings in the bottom right. If this is the first time mapping or you have changed fields, you are offered the option to save the mapping as a default:

• Save As Account Default — saves the mapping for all channels on your account.
• Save As Channel Default — saves the mapping for the selected channel only, allowing different default mappings per channel.

Saving a default means the mapping is automatically populated the next time you import a file.

Validating and confirming the import

At the bottom of the page, a grid shows all orders from your file along with their validation status. Orders that fail validation are highlighted with a warning icon — hover over the icon for details on why validation failed.

You cannot import orders until all errors are corrected or removed from your file.

If there are no errors, click Confirm Import to process the file and import the orders.

Note: The order import supports both single-line and multi-line orders.

An example CSV file is attached at the bottom of this article.