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”.
