Please Note:

If you haven't yet done this, take your time to read and familiarise yourself with the rules and notes on how the .csv works here.

Accepted file formats:

Multiorders can import two files types .csv and .tsv: If you can choose we recommend you use the .tsv format. If you are importing using .csv we recommend that you either download the example sheet or better yet, export an existing .csv file from your Multiorders account and work with that. Since .tsv can only be used for import and not exporting, there is separate Save As guide for it bellow.

Guide to using .csv for Imports:

.CSV - is widely used sheet format, but it has one major drawback which is very hard to spot. There are several ways of how a .csv can be encoded and many .csv file editing softwares can reformat them in their own style whether you want to or not.

For example the Multiorders .csv structure goes like this - "Order Number","Invoice Number","Marketplace Name" as you can see each section is divided by "," various apps like excel could simply remove the "" part completely breaking the document and making it unusable for Imports. Because of this never close the edited document right after you save if you don't know the results yet, otherwise your data could be lost.

The best results often are when you export a sheet from Multiorders, open it, make your changes and simply press save. If you go for the Save As option it will most likely change the structure. To counter this issue we have enabled for the file to be saved as .tsv.

Guide to using .tsv for Imports:

.TSV - is a less commonly used sheet format. Unlike .csv that uses various combinations of "," .tsv simply uses Tabs, or to put more simply large identical spaces.

Using this format ensures that no matter which app you use to save the file you will have no issues, that is why we would recommend that for importing you use the .tsv format.

Depending on the app that you used to work with sheets your .tsv file preparation may differ slightly. Some apps may allow you to simply do a Save As and select a .tsv format. But certain apps like Excel might give you this option "Tab Delimited Text (.txt)" this will save the file in the exact structure that you need it to be in, the only issue that it will save it with the extension .txt, but if you simply rename the file and change the .txt ending to .tsv you will be able to import the file without any issues.

The order import has 3 main uses:

1. You can Create Local orders. This is most often used when you have an external marketplace that is not supported by Multiorders and want the order information to appear in the app. You can use our template and create those orders in Multiorders via .csv Import, but please be aware that during import both stock can be deducted and all orders are created under the Local marketplace only.
Full Guide: Here

2. You can Update orders. You can use the .csv import to update the information on both Sales channel orders as well as Local orders, but they have different rules. But first one common rule is you cannot update/change order items details or add new items or change Order Numbers. Local orders can have all of their information changed, except the previously mentioned order items and order numbers. Sales Channel orders are different in a way that, where you can change all of the same fields, but during the next oder sync the sales channel will overwrite those changes. The list of available fields will be provided in the guides bellow.

Full Guide: Here

3. You can Ship orders. Using the .csv Import you can ship all available orders. This is often used in situation where Multiorders does not support a certain carrier and you can export orders into a .csv, Import that .csv to the carrier system, then export updated information back into Multiorders to update the orders. If you follow the guide correctly orders marked as shipped will update all of the carrier information on your sales channels as well.

Full Guide: Here

Detailed instructions and guides on how to do these actions are written bellow.

Further Articles on this topic:

For general Import / Export rules read here.

On how to Export Orders read here.
How to Create Local Orders via .csv Import read here.

How to Update Local Orders via .csv Import read here.

How to Ship Local Orders via .csv Import read here.

Did this answer your question?