ProSKU Orders handle (old)
The purpose of this document is to give good understanding how our ProSku custom scripts need to be automated using Hemi UI.
There are two main scripts which we need to be able to setup and automate via Hemi UI.
Order File Mover
The File mover simply transfer order export files from client FTP to the ProSKU FTP this way with one export both systems will receive the order file. The reason for doing this is ProSKU system constantly check for files on the FTP and might pick a file which is not completed thus we export the files to the client FTP and then once the file is completely exported we move it to the ProSKU FTP. Once the files are successfully moved from the FTP we delete them.
Shipping File Grouper
ProSKU generate the shipping files and each file always contains a single order which may result in delays for us because we can process one file every 5 minutes thus we will need to group the files into one single file with only one header containing all files data from the ProSKU FTP and move the to the clients FTP. The file extension is .csv only with comma delimiter. Once all files are grouped we delete them and create the new file with the new name on the selected FTP.
In order to have standard way of setting this up we will use FTP Credential and FTP Paths tables where the FTPs will be setup. The FTP Paths labels will be one for the Mover “ProSku Order Mover“ and one for the Grouper “ProSku Shipping Grouper“. If we have FTP Credential selected for Order File Mover but the FTP Patch is set for “ProSku Shipping Grouper“ we do nothing and skip it. Then in a completely separate table ProSKU FTP Mapping we will be able make the correct mapping for the client. We should be able to add new records in the table.
ProSKU FTP Mapping table fields
| Hemi Field | Field Type | Required | Comment |
|---|---|---|---|
| Active | checkbox | Yes | Indicates if this should be active or not |
| Name | varchar | No | Free text just for reference |
| From FTP | Dropdown | Yes | Dropdown list with all available FTP Credential records. |
In the dropdown we display the FTP Credential > Type. Please note one FTP Credential > Type can be selected more than once | | To FTP | Dropdown | Yes | In the dropdown we display the FTP Credential > Type. Please note one FTP Credential > Type can be selected more than once | | Type | Radio button | Yes | Two options: Order File MoverShipping File Grouper | | Seller Code | varchar | No | This field should be visible only when the type is shipping file grouper. | | File Name | varchar | Yes | This field should be visible only when the type is shipping file grouper.
we need to be able to specify the new file name like Orders-{YYYY}{MM}{DD}_{HH}:{MI}:{SS} (please add description on the field as an example) {YYYY} - current year (will be replaced with 4 digits) {MM} - current month (will be replaced with 2 digits) {DD} - current day (will be replaced with 2 digits) {HH} - current hour (will be replaced with 2 digits) {MI} - current minutes (will be replaced with 2 digits) {SS} - current seconds (will be replaced with 2 digits) Everything different will remain untouched | | Error | LongText | No | If during the connection we receive any error we store the errors here for better traceability. |
For the grouper we will be able to set the Grouper Seller Code in an additional field. The seller code will be used as a file name prefix e.g. “AZR1028_1657633569944.csv“ and if we have set any ProSKU FTP Mapping >Seller Code we will need to group only files with that prefix. If the Seller Code is empty we group everything.