Import / Upload Order File (CSV Spreadsheet)

You can manually key in order data directly on Mintsoft using an easy to use shopping cart style process

Overview

It is possible to upload a CSV spreadsheet of orders using either one of our standard templates in the system - or by mapping & creating your own template.

Upload CSV Spreadsheet

To upload an order onto the system from a spreadsheet navigate to Orders > Upload New Order

You will then need to choose the format of the spreadsheet type:

Screenshot of an online spreadsheet upload interface with a dropdown menu labeled 'SpreadSheet Type' set to 'MultiLineOrderTemplate' and a green 'Select' button at the bottom right.

The two main templates used in the system are called:
 

  1. Single Order Per Line

    Each additional product for an order is kept on the same row (line) on the spreadsheet, going horizontally accross)

Excel spreadsheet titled 'SingleOrderPerLineTemplate (1).csv' with column headers including OrderNumber, Company, Customer, Address1, Address2, Town, PostCode, Country, Telephone, Email, Shipping, Courier, Comment, Product1, Quantity1, Product2, Quantity2. A black arrow points to the 'Quantity2' column.

Multi Order per Line

Each new product for an order is placed on an additional row (line) on the spreadsheet, going vertically down.

The system will link each line based on the Order ID column and auto-merge together.

You only have to populate address details on the first line of data for each order.
 

Excel spreadsheet named 'MultiLineOrderTemplate.csv' with a simplified order form containing columns for order number, company, customer details, address, town, postcode, country, telephone, email, product, quantity, comment, and shipping method. The form includes sample data for two orders, with an arrow pointing to the 'Product' column.

You can download the templates by going to orders > upload orders > (select template name)

A web form titled 'Upload Order - Spreadsheet Type: MultiLineOrderTemplate' with a green 'Download Template' button at the top, fields for client, warehouse, courier service, country, channel, and a file upload option.

Upload Results

 

Please check the results of the upload you may receive product or courier errors:

A computer screen displaying a message that a product named 'Testsku' could not be found in a database or system.
Screenshot of an online data upload interface showing one entry with order number 'test123' and status 'NEW'.

Please go back and amend the spreadsheet and re-upload once done if successful you will receive an order status for each order imported:

Hands typing on a silver laptop keyboard on a white desk.

mintsoft training

Click here to access some additional Mintsoft training to help you make the most of our advanced IT software

LEARN