Suppliers prices and mark ups flow¶

Flow: Suppliers (prices, mark ups, offers, availabilities)¶

In order to sell Products to the End Customer, it is necessary to include in database:

• References* made available by Suppliers (supplier's products),
• Products to be published in Frontend (created based on suppliers' references),
• Selling Price (manual setup or dynamically obtained, based on purchase prices and mark ups)
• Products' availability in internal stock or supplier's stock.

In order to acquire a * Selling price * there are 2 ways :

1. Fixed Selling Price (manual)¶

A fixed selling price can be set up, without taking into consideration the purchase price nor the mark ups.
In order to set a fixed price for an existant product on site, click Store > Prices.
Indication : the system considers Fixed prices as an exception therefore a notification pops up in Dashboard for all fixed prices products.

2. Dynamic Selling price (made up from Purchase price+ Mark up)¶

2.1. How to acquire a Purchase price¶

2.1.1. Go to Suppliers' references, taking into account:¶

• Supplier's discount
• Bill Formula Formula curs facturare
• Suppliers' Offers
• Global discounts in suppliers' references
• RRP

In order to acquire the final purchase price value you subtract supplier's discount, cumulated into global discounts set on supplier's references (brand, category, extra sql), plus invoice exchange rate formula, plus exchange rate and discount formula.
The purchase price of supplier's references is dynamically calculated in HOME CURENCY, in order to compare purchase prices.

Should RRP from the supplier be used, it will appear as a selling price, ignoring the purchase price and all mark up rules.

To see how to get suppliers' offers, go to chapter "Suppliers References".
To see how to manage suppliers' offers, go to chapter "Suppliers Offers".
To see how suppliers' availabilities are managed, go to chapter "Suppliers Availabilities".

2.1.2. Go to stock, taking into consideration:¶

• Purchase price
• Supplier RRP
• RRP -> EXIT

Selling price can be also acquired when taking purchase prices as a reference for the products in stock, instead of supplier's offer price.
Constant * STOCK_LOCK_DAYS * defines the number of days in stock of a product, after which the purchase price is taken as a reference instead of supplier's offer price.
Possible values examples:
0 = disable
1= in the same day
n= after n-1 day

How the system chooses between the supplier and the stock or between several suppliers

• If * the product is in stock , * STOCK LOCK DAYS> 0 * and * the old product in stock≥STOCK LOCK DAYS - 1 *, then it is chosen as the "supplier" of the STOCK. Daca *produsul este in stoc, STOCK LOCK DAYS>0 si vechimea produs in stoc≥STOCK LOCK DAYS – 1, atunci este ales ca „furnizor” STOCUL.
  If the product in stock was purchased from a supplier with a RRP active reference, the supplier's RRP will be used, even if the product is in stock.
  In choosing the mark up applied to the purchase cost from the stock, the global and special mark ups are taken into account, including the supplier from which the product was purchased.
• If * the product is not in stock and we have only 1 supplier *, it will take as a reference the supplier's cost, plus the applied mark ups.
• If * the product is not in stock and we have several suppliers * for the same product, the system chooses as follows: it looks for the supplier with * the lowest cost * AND * availability in stock *. If there is no supplier that has the product in stock, it chooses the one with the lowest cost, regardless of availability.
  The number of days for availability "On order" and "Ordered by supplier on XXX" is also calculated. Sunt calculate de asemenea, numarul de zile pentru disponibilitatea „La comanda” si „Comandat de furnizor la data de XXX”.

After choosing the automated supplier, according to the above criteria, the mark up rules for the supplier and product, or the RRP of the supplier are obtained and applied over the purchase cost.
h3. 2.2. How the Mark Up is obtained

2.2.1. Manually¶

This is a fixed type of mark up, applied to each product.
Please note: the system considers the fixed (manual) mark ups to be an exception, as a consequence we will be notified in the Dashboard for all the products that have applied fixed mark ups.

2.2.2. Automatically¶

This is a dynamic type of mark up, applied accordingly to certain criteria(brand, category etc.).

• global (applied to each category)
• special (overrides/limits global mark ups)

The platform offers the possibility of setting a * minimum mark up value * (constant definition * MINIMUM_MARKUP ), which will be used as a reference value and compared with the global or special product mark up: if a product has the applied mark up (global or special) ) less than the minimum mark up defined (constant MINIMUM_MARKUP) the final mark up chosen by the system will be at least equal to MINIMUM_MARKUP.
If the product is applied to fixed mark up (manually), the MINIMUM_MARKUP value does not override the manually applied mark up.
*Please note:
In the case of products that have applied fixed mark up:
*There will be a notification in Dashboard about all of the products with less than the value of MINIMUM_MARKUP.

• In addition, products in stock with a lower addition than MINIMUM_MARKUP ("Lost Products") are notified daily by email.
• In addition, daily stock products with a lower mark up than MINIMUM_MARKUP ("Lost Products") Produse care se vad in pierdere are notified by email.
• In Orders there will be a real time notification if a product is sold with a mark up lower than MINIMUM_MARKUP.

*If the products do not meet any criteria * (neither global nor special applied mark up) the minimum defined mark up (MINIMUM_MARKUP) is not set automatically, but the Dashboard will be notified that the products have 0 applied mark up.