Importing Orders Using the CSV Order Import
Posted by Jack Liptrott on 30 Dec 2014 15:40
Last Modified by Adam Roberts on 27 Jan 2017 16:11
Where sales channels are not integrated with the StoreFeeder software yet, you now have the ability to import orders via a CSV import in bulk, rather than individually order by order. Most sales channels will offer the option of exporting a CSV file of orders but they all have a unique export format. StoreFeeder have recognised this and allowed you to import this order file into the system regardless of format.
We have created a typical .CSV order export file to use in the Knowledgebase and this can be downloaded for reference by clicking the link at the bottom of this page. The order import can handle orders for multiple items. Providing the 'Order ID' is the same on both lines of the CSB file, StoreFeeder will recognise these as 2 lines on the same order. You will see on our example CSV file that lines 3 and 4 are for the same person, John Smith, and he has ordered 2 separate items.
Importing orders from a CSV file
To access the CSV Order Import function within StoreFeeder, hover over the 'Orders' tab and click 'CSV Order Import' in the drop down menu.
Then, select the channel to import the orders to. These will be similar to phone orders in that they are channels that are not integrated to StoreFeeder.
Once this is selected, you now need to import your CSV file. Click the 'Select File…' button and select your saved CSV file.
A successful import will bring up the 'Column Mapping' section.
Here you can map the columns on your CSV file to the preset fields in StoreFeeder.
To map a column, simply click the drop down box next to the field and this will bring up all columns on your CSV file. Simply select the correct column and this will map to the StoreFeeder field.
In our example, the 'Order Reference' is in the CSV column called 'Order Number'
Complete this for the fields that you wish to import in the order. You will see the finished Mapping section for our sample order import below:
Once you are happy, click the 'Confirm Mappings' button.
If all the mappings are successful, you are then shown the final section. Here you have the choice to save the Column Mapping format you have just completed as the default.
So if you know your order import CSV file will have the same format every time, you can click 'Save As Account Default' and this format will appear every time you import a new file.
If the format will alter from Sales Channel, i.e. the export format for Not on the High Street is different to that of Etsy, then you can save this format for just that sales channel.
You will now also see a confirmation of the orders to be imported.
You will see here that the order for John Smith from our sample file is showing the 2 lines that were ordered.
If all orders have green ticks, you are ready to import. If there are any issues, the screen will advise and these should be amended before you import the orders.
If all is OK, click the 'Confirm Import' button.
You will see an 'Orders imported successfully' message when the process is complete and you can then view your orders on the orders screen.
By hovering over the 'SKU' on the order for John Smith we can see that the order has imported the correct number of lines and the correct quantities of items.
These orders can now be processed as normal.