To import the Wowcher orders do the following:
Select the Import Orders dialog (Down arrow icon or File->Import and Export->Import Orders menu option).
1 Click on the Add button to create a new OSOP import type (select the Other Shopping Carts, CSV format (OSOP Format) choice)
2 Select the CSV order file exported from Wowcher
3 Change the Date Format (in the OSOP options) to YYYY-MM-DD THH:MM:SS+HH:MM
4 Tick Use OSOP compatible header for order import file
5 Copy (and Paste) the following header line into the header box
SKU,Order date,Order ID,Item title,Invoice Customer,NA,Invoice Address line 1,Invoice Address line 2,Invoice Address line 3,Invoice County,Invoice Postcode,Invoice Email,Invoice Telephone,Item Field1,Custom:Entered val. 10,NA,Item title2,Item title3
6 Tick Mark all imported orders as Paid
7 Click OK
8 Import the orders.
NOTE: Wowcher does not have a unique order number for each order so the Wowcher code is mapped to the Order ID. Wowcher does not have any monetary values in the order information so these will be have a value of 0. The order information should be used as a Packing Slip or the information used to create courier labels.