8. Finalizing the integration with the supplier file - currently, products appear in the system, but stock is not added for display on prom/rozetka/site.
1. Create a KSM warehouse (or simply rename the existing inactive Alex warehouse)
2. Set up automatic unloading of products from the supplier's price list (KSM) in the quantity of 5 units to the KSM warehouse if the product is transmitted via a file with the supplier attribute "In stock".
All this is subject to the fulfillment of 3 mandatory conditions
- when changing the status from "Moderation required" from "yes" to "no"
- when assigning categories to products from the KSM warehouse
- in the presence of the product article (if any of these points are not met for the product - issue a system notification in the OV about the absence of specific conditions for specific products, so we can correct it and understand where)
3. Sales, in case the product is available in both warehouses, should primarily be made from the KSM warehouse.
If the supplier's file with updates transmits the attribute "Out of stock" - change the product status in the "KSM" warehouse in the OV to the same, set the quantity to 0 in this warehouse and subtract the quantity added during automatic unloading from the total quantity available, which is displayed on all platforms.
Due to the fact that the priority warehouse for sales is KSM - when receiving the attribute from the supplier's file "Out of stock", it is necessary to subtract from the total quantity of the product in the warehouse exactly that quantity that remains in the KSM warehouse. That is, if there are 5 units in the Max warehouse, and another 5 units entered the KSM warehouse, totaling 10. If 2 units are sold and shipped from the KSM warehouse, accordingly, upon receiving the attribute from the supplier's file "Out of stock", the OV subtracts the remaining quantity, which was counted as 3, from the total quantity we see on the platforms, and the quantity should become 5 instead of 8.
4. Add a column for Warehouse on the orders page. When an order is received for a product that is available in the KSM warehouse or both warehouses, this column should display KSM; when the product is only available in the Max warehouse - Max.
5. Set synchronization and rounding of prices for both warehouses to whole 49 and 99 UAH.
If the product is already available in the system and matches the article - for such products, the price should be set as designated for the "Max" warehouse. This applies to Ugreen brand products, for which the article in the Max warehouse consists only of numbers, while the supplier has the same numbers, just preceded by "UGR-."
All prices need to be rounded up to the nearest fifty, meaning all prices starting from 00.00 and ending at 49.99 inclusive after multiplying by the markup coefficient should be rounded to 49 UAH, and all prices starting from 50.00 to 99.99 should be rounded to 99 UAH at the end.
For example, considering the markup, a price calculated as 978.6150 - the price should be set at 999 UAH
Price 123.98 - should be 149 UAH. Thus, all supplier prices should end in 49 or 99.
This arithmetic should apply to all prices, i.e., to the base price, after the multiplier for this supplier, then for other platforms that form the price with a multiplier from the base, i.e., hb, rz, lm, epicenter.
6. The system has a markup coefficient for products from KSM, but it is necessary to add a checkbox to the products, which, when checked, will set the price for this specific product manually and have priority over the general coefficient.
Example: the cost of a product in the KSM warehouse is 100 UAH, the selling price, considering the coefficient - 175 UAH, but we want to set this product's price to 350 UAH at a certain moment. In this case, we go to the product's short description, check the "Manual price" checkbox, set the price we deem necessary, and until we uncheck this box, the manually set price should remain in the system.
7. Adding products to all platforms should occur according to the following scheme:
* we filter products by necessary parameters
* we mass-select the required products
* we click the edit button, where the first field displayed is - Moderation required (with a dropdown list Yes/No) - we select No
* the second field - unloading to OpenCart (with a dropdown list Yes/No) - we select Yes
* we click Save
* at this moment, unloading/updating of products and quantities for all platforms is initiated
8. Create a chatbot for transmitting orders to the supplier in Telegram; we will ask the supplier's manager to subscribe to it so she can see our orders - strictly our article, vendor article, product name, and its quantity.
Accordingly, after receiving the order, the supplier confirms the reservation to us in personal messages or in the bot, we create the TTN and send it either with a quote to the previous message with the order composition or a new message along with the order composition and TTN. If there is an understanding of how to automate the process so that we can receive this confirmation directly through the chatbot in Telegram (response options +/-/* (where * means not all products are available) and the TTN is created automatically after receiving confirmation from the supplier and sent with the order composition automatically in the bot with the TTN for the supplier
It is necessary to understand how to instantly update the stock manually for products that, according to the supplier's message, are no longer available.
After all, there is no point in waiting for the next file update; for a specific product, we need to reset the stock in the KSM warehouse with one button if indicated by the supplier
9. For products with an article starting with UGR-, it is necessary to take its numerical part and write it in the Article field (while referring to point 5, which states that if the product is available, the price should be pulled from the "Max" warehouse)
10. Explain how two positions will simultaneously exist - the one created by us and the one transmitted by the supplier, if these are the same positions? How can we merge them into one with adjustments to the description and gallery (choose the best from the two, add, merge). Set the price of the "Max" warehouse
