Jump to content

Supply Order based on needed quantiy


Recommended Posts

I really apologize if this is not the right place for posting this thread. 


I need some help figuring out a proper Supply/Purchase order method. Following is the scenario:

We buy in bulk format from our supplier. We offer to our customer both bulk and individual product. Apple for example. From our supplier we buy case of 118 apple. We offer our customer 2 combinations of 1 Apple and a case of 118 apple. 

We want our purchase department to place order cases of apples from our supplier based on number of apples order we got. I have created 2 combinations of 2 different package format right now. But when we want to create supply order how do i make the system auto pick cases of apple based on number of apples ordered by customers? I hope this make sense.


Link to comment
Share on other sites

Hi Symmcom,


Due to my weak understanding of english, I am not sure but I try.


You want place an order to your supplier for each customer order, or for all orders of the day ?  Or for a certain period.


As it is all about mechanic describe some cases, like :

- 1 customer ordered ... then we placed the supplier order ...

- 2 customer ordered ... then we placed the supplier order ...


Best regards

Link to comment
Share on other sites

Thank you so muc for your reply!


Yes, i want to create a supplier order based on all orders from customers of the day or week. I am aware of the option available in Prestashop to Supply Order module where i can enter a quantity to preload products in supply order. But this does not seem to be option right in my scenario. There is no such option as ordered product aggregation. If there is any way i can combine all ordered product together and create supply order based on that, that will work great.

Link to comment
Share on other sites

Ok Symmcom,


As manager I would like up to date status in my BO  like ' there are supplier order to place for ....'

Then it will also include all sunday, beyond working hours and very late night customer orders.




of the day or week

Day  :  0:00 AM to 11:59 PM including all specials days like Christmas for example ?

Week : then you need more a detailed report  from 'day begin' to 'day end' ?


Anyway I do not think there is a ready module for this but it is technicaly possible to make it.



Edited by math_php (see edit history)
Link to comment
Share on other sites

Thats it! Thats exactly what i am looking for. Even if i can create a report or export CSV file with aggregated products ordered by customers will help me greatly. For example one customer ordered 5 apples and another customer ordered 4 apples. An exported CSV file should show i have to place a supply order for 9 apples. Is there any way i can extract Customer Orders ?

Link to comment
Share on other sites

Yes you can,


Go in the sql manager and build request the execution will provide you csv.


You need at least tables orders, order_detail,product_lang ....


I also made a module 'rawSqlTool', wich is in Free Module section, you could adapt for your needs

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...