Groupon Order Import and Shipping Notification Export

Overview

Khaos Control now supports importing Groupon .csv order files, including exporting a shipping notification back to Groupon.

Specification

In the Channel Setup tab, you can now create a new Groupon channel type. To do this;

1. Open a Channels 2.0 screen; (See How To: Open a Channels screen);
2. Press Ctrl+N or click . (This is found in the Menu Bar at the top of the screen);
3. Select Groupon from the drop-down menu and press OK.
4. Enter the Channel name, and set the import options accordingly.
5. Press Ctrl+S or click to save.

• Additional options will be implemented into the [ System Data | Channel Courier Mapping ] area to allow entries to map courier codes for exports.
• Orders will be imported using [Sales Orders | Other Actions | Import / Export | Import | Channels | Groupon Orders]; choosing this option will present a dialog which will allow the user to select a .csv file to import.
• Shipping Notifications will be exported using an option available from [Sales Invoice | Other Actions | Import / Export | Export | Groupon Shipping] .
  

Notes:

• Only one item per order is allowed; if more than one item is specified for the same order, those lines will be skipped;
• A unique 'fulfilment_line _item_id' is required for each line for a successful import.

Configuration

Prior to use a hidden System Values option needs to be enabled. To have this enabled please speak to Support.

1. Create a Groupon channel (needs only Sales Order setup, no credentials are necessary).
   Note: Caution should be exercised in setting an ''Ass Ref Prefix'', as this could affect the fulfillment_line_item_id being sent back to Groupon.
2. Go to [ System Data | Channel Courier Mapping ] and map the Courier to Channel Orders.
3. It is recommended a custom Bank Account is set for this channel, as with other channels.
4. Additionally, KSS Options (Ini settings) should be set as appropriate. The number specified next to the value is the default value, with the recommended value to its right in brackets;

• ImportPricesCalcMethod=GROSS (GROSS is the recommended value)
• UseGenericGrouponCustomer=-1 (0 is the recommended value)
• MarkPrePaid=0 (-1 is the recommended value)
• PaymentType=3 (2 is the recommended value)

Note: the values available for selection for the PaymentType shown above are:

• 0 = Cash
• 1 = Cheque
• 2 = Card (recommended)
• 3 = Account

Usage

Order Import:

A specimen Import file has been included in the Update email. (Data may not be correct with values in Khaos Control.)

1. Import a csv file using [Sales Orders | OA menu | Import / Export | Import | Channels | Groupon Orders] .
2. Select the csv file to import. (The csv import file will be converted into a .cmp file at the end of the process. )

Export shipping notification:

1. Move the Invoice to the [Shipping] stage of Invoice Manager.
2. Confirm the Shipment (at this stage add a consignment reference and confirm the courier being used.)
3. Assign to Courier, as necessary.
4. Issue the order.
5. Select the invoice line in the Current stage and export Shipping Notifications using [Sales Invoice Manager| OA menu | Import / Export | Export | Groupon Shipping ]. Select the Groupon channel from the dropdown.
6. Save the file.
7. The Export file will have values in 4 fields:

• Associated ref of the order (fulfillment_line_item_id)
• Channel courier (Carrier)
• Consignment reference (tracking_1)
• Shipping date (inventory_decrement_date)

Notes/Caveats:

• If no Invoice Address has been specified in the Groupon Import File, Khaos Control will use the Delivery Address as the Invoice Address.
• Only one item per order is allowed, if more than one item specified for same order those lines will be skipped.
• A unique 'fulfilment_line _item_id' is required for each line for successful import.