POI system for opencart 2.3 / 3.0

Hello

For our opencart 2.3.0.2 store we're looking for an purchase order system.
So we can send out an pdf file or excel sheet to our supplier for new orders.
Also with this option we want to manage the stock in our store.
So we can see which items are already on order with the supplier.
An lot of orders only ships out partly from our supliers. We want to have the ability to tell which items have been delivered and which items are waiting for delivery.

We really need to get more control over our stock, common made mistakes at this moment are.

-Order two times at the supplier (not knowing it was already ordered, or on back order with the supplier)
-Forgotten products
-Products

Features:
-Create an purchase order invoice with the following items
--Supplier Name and address
--Our Name and address
--POI number
--Creation Date
--Product List with qty, costs, sku,
--Total costs
--Commentbox

-Page for creating the POI must contain
--Easy product look up by supplier (location is used at this time)
--Product filter on stock qty
--Show list of all products of this supplier
--Any outstanding delivery of products(and info with order date)

-Page for overview deliveries from suppliers
--Overview with outstanding orders
--Show % of order has been delivered and delivery date.

-Page for processing deliveries
--Confirm qty delivered (fill in field for numbers)
--Auto update stock when qty delivered is filled in and delivery is processed
--Filter products on SKU, Name or EAN.

Hope someone can help us out with this.

I think that full POI system is a bit heavy to integrate with your store. What if you started with some sort of "low inventory" system (extension) that would email or otherwise contact your POI system? It could even be a totally separate system that peeks into your store database, and updates store inventory when a purchase comes in. The POI and inventory management system would keep a database of outstanding purchase orders to suppliers (along with a tickler date to take action if the order is not completed by this date). If inventory falls critically low (e.g., unexpectedly high order rate) this could notify someone that the outstanding PO needs to be escalated in some manner. All the paperwork stuff would be on the POI system, rather than being glued on to the OC store. Just some thoughts, in the Unix tradition of simple tools to each do one thing and do it well...and if you ever move to another store system, this would only need minor updates to the store DB access routines. Hmm, I smell a lucrative product to sell, oh wait a minute, false alarm. I just stepped in something from the dog...

Hello,
Please check your PM and let me know if job is still open.
Looking forward to your reply.

Thanks,
Shivank Agrawal
skype: anaisys.technologies
email: md@anaisystechnologies.com

hello Phil,

Do you have more information on this?
At the moment we handle all our stock in opencart, we don't have an seperate warehouse managing tool running.
We try to keep the stock and work all at one place.

veenie wrote: ↑

Wed Aug 16, 2017 7:22 pm

Do you have more information on this?
At the moment we handle all our stock in opencart, we don't have an seperate warehouse managing tool running.
We try to keep the stock and work all at one place.

Well, I don't have direct experience with implementing such a thing. I'm just suggesting that trying to build all this new functionality into your store (cart system) is asking for trouble: adding a great deal of complexity to the store and risk of taking down the store itself if something breaks. I would find (or build) a separate program that only worries about maintaining inventory: checking stock levels (or listening for low stock alerts from the store), checking against outstanding PO's, generating appropriate documents to send to a supplier (do not send automatically -- just make it easy to give the OK, or print and mail them), keeping track of fully or partially filled PO's, generating ticklers if a PO is overdue, and updating the store stock (either directly against the database, or generating a CSV or other means of update). It can certainly run on the same system as your store (be sure to password protect it if it's publicly exposed on the Web), or it could be on a local PC at your office.

Likewise, a CRM (Customer Relationship Management) system might better be a standalone program that peeks at your database for customer order history and available products, and comes up with various email communications (follow-ups on orders, tracking problems and comments, tracking returns, sending out offers, etc.). Again, trying to tightly integrate it into a store's code is probably asking for problems. Keep the major components at arm's length from each other to avoid having one going down from taking the others down with it.

It will be difficult to find a PO system which fulfills all of our needs. Some kind of customization will be required if you need all features down to the last minor one. See the below extension if it will suit your needs

Complete Purchase Order Management and Dropshipping Solution

Hi Veenie,

Please check your pm and let's discuss.

Regards,
Manish