New Features
Stock validity check
Issue 16
Till now it was not checked if a product chosen is available on the stock or not. Now we will insert this information into the calculator.
From now on we will deal with two excel files. The one that we have now will be called the Price List. The other one that we introduce will be called the Stock List. The Price List will contain two more columns from now on:
- Sleeve Article Number - article number of a sleeve
- Partial Sleeve Article Number - article number of a partial sleeve.
Either one or both of these numbers will be filled for each of the product (line) in the
Price List.
The Stock List will contain the columns:
- Article number (for sleeve or/and partial sleeve.
- Quantity ( number of meters or millimeters (for partial sleeve) or number of pieces (for sleeve and other product types - Oleostatic), this depend on the price list ).
So when the user is choosing the type Sleeve for a product on the web page then we compare the quantity given on the page with the quantity in the Stock List. The key of the connection will be the Sleeve Article Number in the Price List and Article Number in the Stock List.
When the user is choosing belt as type on the page. We will add the total width for the sleeves and partial sleeves for the given product. This will be total_width = sleeve_size sleeve_quantity + partial_sleeve_size. The sleeve_size comes from the Price List, the sleeve_quantity and partial_sleeve_size comes from the Stock List from the Quantity column.
Some other rules:
- If the Stock List doesn't contain Article Number for a given product, then we can assume that is is zero.
- The Quantity column in the Stock List doesn't take into account the orders "under processing". Maybe we should as Navaxa to change this.
- The Quantity column doesn't take into account the future purchases from Italy. So maybe the Stock List should contain the list of purchases. This would be a list of Quantity and Date pairs (ex.10 pcs of something will arrive to stock on a certain date)
- We do not decrease the number of pieces on stock when an order is issued on the page.
The Stock List will be generated automatically every hour by Navision. This file will be uploaded to the server of Megadyne Calculator and it will be converted to the php format. When a user logs in it will use this file to check stock validity. If the file is not available or there's an error during upload and reformat procedure, then the old file is used.
On the page the number of available pieces (or length - ex. m, mm,rib ) will be shown in the result row. The order/inquiry will be accepted even if the quantity is higher then what is available on stock. The result table will show with different colors the state of the availability. It will be red if the product is not available on stock, it will be green if it is, and it will be yellow if it is partially available. Also the result of the check should be sent in email as well. The words "available on stock", "not available on stock", "partially available on stock" will tell to the partner about the situation.
Comments for items
Issue 79
For each item an optional comment can be added. The comment appears as an edit box for each config type and it is added to the result table and to the csv file as well.
Improvements
Free text items in orders
Issue 75
There should be a new button for the non-standard bells so that we can add as order. Till now only inquiries were possible to add.
Clearing the items afters sending the order/inquiry
After the user have sent an order/inquiry the content of the result table should be cleared.
As we spoke about I will add the modification reqs for the specification description: - we have to add Roll Article Number and Partial Roll Article number to the description to be proper (Sleeeve or Roll article number/partial sleeve or partial roll article number) - for the rules: for now we don't want to show the purchases from Italy. In a further version we would like to show what is available in our "external warehouses" (alltogether in Italy, Germany, Spain, etc.) Let's have our stock to be integrated first and work reliable, and than we can move on further. - the qty shown calculation method should be the total width for the sleeves + (partial sleeves - 10% rounded integer) for the given product ( total_width = sleeve_size sleeve_quantity + [partial_sleeve_size-10% - rounded integer] - "The Stock List will be generated automatically every hour by Navision." The frequency of uploads must be modifiable. - there is one more additional feature which should be added to the description: when submitting the order / inq. the user should be able to send it to multiple email adresses separated by comma (if he wants to send it to his colleague or anyone else). We don't want to generate another row for an another email adress, but the ability to enter one more (or many more) email adresses into the existing field separated by comma (or semi comma). - Issue 79 has been comented among the issues - Issue 77 has been commented among the issues (it has been closed).
"The frequency of uploads must be modifiable". This feature can be done by Navaxa. It's not my program that initiates the stock list generation, but it is inside Navision.