Zedonkopedia

Sales Orders - Order Import

You can upload single or multiple sales orders directly into Zedonk by using the Order Import template

The customer 'Type' will dictate the order 'Type' when imported. 

From Sales Orders dropdown menu select [Order Import]

OR

Select [Download Template] to download .csv template file

This will download a CSV file with the correct headers for you to populate - see below

1.  ORDER REFERENCE : Optional. This field goes to Order Ref on Sales Order in Zedonk.

You can create two separate orders for the same customer on one upload: you MUST give each order a different Order Reference.

2.  CUSTOMER NAME or ACCOUNT CODE: You choose to populate ONE field only to identify the customer.

The data entered in either field needs to MATCH exactly what exists in Zedonk. The empty field will be ignored.

3.  STYLE, FABRIC, COLOUR, SIZE or BARCODE: You choose to populate one (set of 4 fields; STYLE, FABRIC, COLOUR, SIZE) or the other (BARCODE) to identify the sku.

The data entered in either field needs to MATCH exactly what exists in Zedonk. The empty field will be ignored.

4.  SALES ORDER QUANTITY: input the sales order quantity for each sku.

 

Here an example for a file ready for import -This example shows use of CUSTOMER NAME and STYLE, FABRIC, COLOUR, SIZE as identifiers

...or...This example shows Ac NUM and BARCODE as identifiers

...or any other combination of the two.

Once complete, Drag and Drop .csv file to import data back it into Zedonk

Choose your Settings according to your file

CUSTOMER LOOKUP: select from the dropdown Customer Name or Account Code

PRODUCT LOOKUP: select from the dropdown Style, Fabric, Colour, Size or Barcode

Select [Import] to upload the file

The pop-up screen will show you the file is being processed.

This will Auto-Refresh every 30 seconds, or you can click the grey button at the bottom to refresh manually.

The import will take from a few seconds to a few minutes, depending on the number of rows in your file.

You don't have to stay on this screen. You can click OK, work in a different area of Zedonk, and come back later.

If you have left that screen and now you are back, click on 'View Last Import Log' to re-display the pop-up

This will show you the result of your IMPORT.

Lines imported successfully are in GREEN

Lines that failed are in RED (Possibly due to a typo on the file or a record that does not exist in Zedonk)

In Sales Orders, the orders have now been created
Previous Article Sales Orders - Export Multiple Customer Documents to PDF - Individual PDFs
Next Article Sales Orders - Email Multiple Customer Documents