We are contemplating to use erpnext for our eCommerce site, which is developed using Magento. All our warehouse and inventory will be maintained using erpnext and the available quantity for each product should be known to the front end store as well. Any idea how this can be implemented using erpnext without a Magento plugin ?
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Received your query from the group and possibly we can assist you
in the same. Can you please elaborate more on the exact
requirement? We are partners for ERPNext for implementation,
customization, consulting activities. We can even speak as
convenient as well. Have you purchased / using ERPNext currently ?
You need to write a script to pull data from ERPNext using web-services.
Or you can directly pull the balances from the database tables, by using a simple SQL based connector. Balances can be found form the "tabBin" table (filtered by Item and Warehouse) or from the "tabStock Ledger Entry" (filtered by Item Code, Warehouse, Date)
The balance in the Bin table also includes future entries (if any). If you want exact balance excluding future entries, you need to get it from the last Stock Ledger Entry for that Item, Warehouse combination on that particular date.
On 20-May-2013, at 12:06 PM, Kumar AM <ku...@gmail.com> wrote:
We are contemplating to use erpnext for our eCommerce site, which is developed using Magento. All our warehouse and inventory will be maintained using erpnext and the available quantity for each product should be known to the front end store as well. Any idea how this can be implemented using erpnext without a Magento plugin ?
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
Thanks Rushabh for letting me know. I am also looking for some implementation details and associated performance. Are you aware of any such implementation?
Hi Rahul, we are a lean start up without any funding. Thanks for your offer to help. I will keep this in mind.
On Mon, May 20, 2013 at 12:37 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Hi Kumar,
Welcome to the forum.
You need to write a script to pull data from ERPNext using web-services.
Or you can directly pull the balances from the database tables, by using a simple SQL based connector. Balances can be found form the "tabBin" table (filtered by Item and Warehouse) or from the "tabStock Ledger Entry" (filtered by Item Code, Warehouse, Date)
The balance in the Bin table also includes future entries (if any). If you want exact balance excluding future entries, you need to get it from the last Stock Ledger Entry for that Item, Warehouse combination on that particular date.
On 20-May-2013, at 12:06 PM, Kumar AM <ku...@gmail.com> wrote:
We are contemplating to use erpnext for our eCommerce site, which is developed using Magento. All our warehouse and inventory will be maintained using erpnext and the available quantity for each product should be known to the front end store as well. Any idea how this can be implemented using erpnext without a Magento plugin ?
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
On 20-May-2013, at 3:24 PM, Kumar AM <ku...@gmail.com> wrote:
Thanks Rushabh for letting me know. I am also looking for some implementation details and associated performance. Are you aware of any such implementation?
I know some people have managed to integrate this to their system, but its mostly using hacks. Your performance may depend on how many items you have and how frequently you want to update -- but it should not really be an issue. You may have to get your hands dirty in this one -- -depending on what strategy you use.
Hi Rahul, we are a lean start up without any funding. Thanks for your offer to help. I will keep this in mind.
On Mon, May 20, 2013 at 12:37 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Hi Kumar,
Welcome to the forum.
You need to write a script to pull data from ERPNext using web-services.
Or you can directly pull the balances from the database tables, by using a simple SQL based connector. Balances can be found form the "tabBin" table (filtered by Item and Warehouse) or from the "tabStock Ledger Entry" (filtered by Item Code, Warehouse, Date)
The balance in the Bin table also includes future entries (if any). If you want exact balance excluding future entries, you need to get it from the last Stock Ledger Entry for that Item, Warehouse combination on that particular date.
On 20-May-2013, at 12:06 PM, Kumar AM <ku...@gmail.com> wrote:
We are contemplating to use erpnext for our eCommerce site, which is developed using Magento. All our warehouse and inventory will be maintained using erpnext and the available quantity for each product should be known to the front end store as well. Any idea how this can be implemented using erpnext without a Magento plugin ?
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
We are looking to have a similar integration - ERPnext integrated with Magento. Were you guys able to get this done? If yes, can you give some more details?
Others, Is there a ready solution which we can buy?
On Monday, May 20, 2013 3:24:44 PM UTC+5:30, Kumar AM wrote:
Thanks Rushabh for letting me know. I am also looking for some implementation details and associated performance. Are you aware of any such implementation?
Hi Rahul, we are a lean start up without any funding. Thanks for your offer to help. I will keep this in mind.
On Mon, May 20, 2013 at 12:37 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Hi Kumar,
Welcome to the forum.
You need to write a script to pull data from ERPNext using web-services.
Or you can directly pull the balances from the database tables, by using a simple SQL based connector. Balances can be found form the "tabBin" table (filtered by Item and Warehouse) or from the "tabStock Ledger Entry" (filtered by Item Code, Warehouse, Date)
The balance in the Bin table also includes future entries (if any). If you want exact balance excluding future entries, you need to get it from the last Stock Ledger Entry for that Item, Warehouse combination on that particular date.
On 20-May-2013, at 12:06 PM, Kumar AM <ku...@gmail.com> wrote:
We are contemplating to use erpnext for our eCommerce site, which is developed using Magento. All our warehouse and inventory will be maintained using erpnext and the available quantity for each product should be known to the front end store as well. Any idea how this can be implemented using erpnext without a Magento plugin ?
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Hi @nathan_dole@anil20787,
We have implemented this functionality of syncing inventory between Magento and ERPNext. For more details you can contact me on Skype kanhaiya.kale or send email to kanhaiya@indictranstech.com