Txt-import plug-in (EN)

 

Plug-in for Rackbeat WMS to support import of sales files from Magasin.
The plug-in will allow user to import txt-files with product lines to Rackbeat creating a new sales order.
 

  • For now the plug-in is not a public integration and will have to be installed for each case.
  • Magasin identifies all products by barcode – and in this case barcode is not equal to item_id, so a conversion of barcode to Rackbeat item_id is done as first part of the import.
  • For all products not matched by barcode, the plug-in will use item_id = “diverse”
  • Rackbeat does not support a “fixed” discount value, so product_line_price is calculated from “Price” minus “Discount”. “Price”, “Discount” and “Bon nr.” can be imported to Rackbeat as “custom_field”
  • The integration has an implementation cost of DKK 10.000 excluding vat. Contact Rackbeat Support for onboarding info.



TXT-FILE DESCRIPTION/HEADINGS

EXAMPLE OF IMPORT-DATA FROM ABOVE DESCRIPTION


MAPPING OF COLOUMS TO RACKBEAT

Txt name

Rackbeat field

Sales date

Order_date (y-m-d)

Store

Line(location_id)

Barcode

Line(item_id)

Qty

Line(Quantity)

Price

Line(line_price) {Always converted to positive amount due to Minus x Minus = Plus. Divided by 100 and multiplied with 0,8 for “removing” VAT}

Discount

Line(line_price) {Used for calculating line_price. Divided by 100}

Bon nr.

Optional – can be imported to “custom field”



The flow is as follows:

  • An initial config is done by client or Custom Success Manager in “import-tab”. Settings from last import will always be saved.

  • Client browses PC to find Magasin txt-file -> Click “Import order to Rackbeat” -> Plug-in is processing, converting barcodes and creating new sales order visible in “Sales” -> “Orders”.

Supportscreen tag
da_DKDanish
%d bloggers like this: