Questions regarding the Purchases thirty bees module.

[the.rampage.rado]

1. Does it keep track of pack sales also? If I sell 10x of certain product but the product pack has no set supplier as it relies on products with set suppliers does it calculate those sales? If it does not track them what happens if the products in the pack come from different suppliers?

2. Could we have in future supplier MOQ and Minimal stock levels settings? Lets say we have a discount for full box of certain item and we wish to order only per said quantity but by piece for other items from that supplier. Minimal stock levels should be set by the merchant (per product/reference) and if the quantity on hand drops lower than the said number, the difference should be suggested always even if the calculation does not offer it.

3. Can you describe this setting? Why the default was only Canceled? And should we keep it that way?

4. I assume that all settings for costs in the module Settings take into account the default currency and not the supplier default currencies?

5. When adding a supplier and then supplier references could we automatically pick the currency based on the selected supplier default currency? Currently the drop down shows the default shop currency and we have to fix this every time if both are different.

6. What do Safe stock and Reorder point mean?

[datakick]

On 10/14/2023 at 4:38 PM, the.rampage.rado said:

1. Does it keep track of pack sales also? If I sell 10x of certain product but the product pack has no set supplier as it relies on products with set suppliers does it calculate those sales? If it does not track them what happens if the products in the pack come from different suppliers?

Yes, since thirty bees 1.4 (I think) we track pack items sales as well. This info is taken into account. So, if you sell product A separately 1 times, and as part of pack 9 times, purchases module will see 10 sales of this product.

On 10/14/2023 at 4:38 PM, the.rampage.rado said:

2. Could we have in future supplier MOQ and Minimal stock levels settings? Lets say we have a discount for full box of certain item and we wish to order only per said quantity but by piece for other items from that supplier. Minimal stock levels should be set by the merchant (per product/reference) and if the quantity on hand drops lower than the said number, the difference should be suggested always even if the calculation does not offer it.

Sure, let's add this to backlog.

For MOQ -- we already have something similar to this, but little bit more generic -- custom notes for products. So you will be able to notes for product A and Supplier S, for example "Always order whole box"

On 10/14/2023 at 4:38 PM, the.rampage.rado said:

3. Can you describe this setting? Why the default was only Canceled? And should we keep it that way?

This is settings for Export section. It's a remnant from first version of the module, we will probably remove the export functionality completely. Export was used before we had purchase orders to gather data for it.

On 10/14/2023 at 4:38 PM, the.rampage.rado said:

4. I assume that all settings for costs in the module Settings take into account the default currency and not the supplier default currencies?

Yes, shop default currency

On 10/14/2023 at 4:38 PM, the.rampage.rado said:

5. When adding a supplier and then supplier references could we automatically pick the currency based on the selected supplier default currency? Currently the drop down shows the default shop currency and we have to fix this every time if both are different.

Module already do this. If it doesn't work for you, please check javascript console -- maybe there is some error that blocks this js functionality.

On 10/14/2023 at 4:38 PM, the.rampage.rado said:

6. What do Safe stock and Reorder point mean?

Safety stock represents minimum quantity you should have on stock to be able to achieve expected service rate. It takes into account only demand and service rate settings.

Reorder point represents quantity on stock when you should reorder the product. This will never be less than safety stock, but it can be higher. It takes into account order placement costs, and stock ownership costs. This is what we use to suggest products to order.

[the.rampage.rado]

Could we have global price and currency option above the current ones that when populated fills all fields under it? It would be useful if we have lots combinations and the price is the same.

[datakick]

On 2/19/2024 at 7:17 PM, the.rampage.rado said:

Could we have global price and currency option above the current ones that when populated fills all fields under it? It would be useful if we have lots combinations and the price is the same.

these are fields from core, not module. Please file enhancement request issue in github.

[the.rampage.rado]

@datakick,

I have two more questions.

1. In the module we have 'Auto generate' button. What is it's functionality and how it decides which suppliers need an order?
2. Do we consider the best price for certain items when offering them for supply order? Let's say I have 3 suppliers A, B and C. They offer nearly the same range of products but prices might differ quite substantially (more than 5%, up to 30% on some items). We of course would like to order some items from the best possible place and some items that have the same (or nearly the same) price might be ordered from every supplier. 

Supplier A - main one - free shipping above XXXX
Supplier B - better prices for some items - cost for shipping XXX
Supplier C - very few items with better prices - cost of shipping XXX

Currently the module suggests the same products for all suppliers that it sees coverage for.

It would be nice enhancement if it could notify that there is better price somewhere else. Something similar to:


And a switch in Settings to adjust at what % level we want to show these suggestions - do we care for 5% difference, or 10%, or 20%. And if for 5% lower price per item at supplier C we should make an order with them, keeping in mind their shipping costs or it's still cheaper to order from Supplier A at 5% higher price but with free shipping.

[datakick]

7 hours ago, the.rampage.rado said:

@datakick,

I have two more questions.

1. In the module we have 'Auto generate' button. What is it's functionality and how it decides which suppliers need an order?

This functionality is based on Products to Order overview. 

That table shows list of all supplier products and calculates safety stock/reorder point for each supplier. To calculate this, it takes into account your sales history, supplier lead time, stock keeping costs, and some other factors.

You can check that table to figure out when you should order product from that particular supplier. For every supplier, the reorder point for that product can be different:

 

Now, the Auto generate button is very simple.

It looks into this table, but only for suppliers that are set as product default supplier. It current stock is below reorder point, the empty/blank/draft purchase order for that supplier is created. No product is added. It just exists so the back office employees knows what to check.

It's not perfect, and it's not for everyone, but it can help keep an eye on things.

 

7 hours ago, the.rampage.rado said:

2. Do we consider the best price for certain items when offering them for supply order? Let's say I have 3 suppliers A, B and C. They offer nearly the same range of products but prices might differ quite substantially (more than 5%, up to 30% on some items). We of course would like to order some items from the best possible place and some items that have the same (or nearly the same) price might be ordered from every supplier. 
 

No, the module currently does not do that. It's a good suggestion, I've added this enhancement request to the backlog.

We already have a similar ER to warn when the product is in another PO (draft or sent).

 

[the.rampage.rado]

Thank you!

 

Quote

We already have a similar ER to warn when the product is in another PO (draft or sent).

Yes, I was thinking of this too.