Inventory - Sync between Magento front end store and erpnext

[Kumar AM]

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 ?

[Rahul Limaye]

Hi Kumar,

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 ?

Looking forward to your response,

Thanks and best regards,

...Rahul

-- 
Rahul Limaye|rah...@indictranstech.com
New Indictrans Technologies Pvt. Ltd.
+91 98222 44347
Skype: rahul.limaye

On 5/20/2013 12:06 PM, Kumar AM 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/f78961ef-b0ce-4e27-a3b2-008760c65c61%40googlegroups.com?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Rushabh Mehta]

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.

best,

Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 20-May-2013, at 12:06 PM, Kumar AM <kumar...@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 ?

[Kumar AM]

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.

--
You received this message because you are subscribed to a topic in the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/MswCCD2qN30/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to erpnext-developer...@googlegroups.com.

To post to this group, send email to erpnext-dev...@googlegroups.com.

[Rushabh Mehta]

On 20-May-2013, at 3:24 PM, Kumar AM <kumar...@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.

[Anil Bhandary]

Hi Kumar,

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 <rme...@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.

best,

Rushabh

W: https://erpnext.com
T: @rushabh_mehta

On 20-May-2013, at 12:06 PM, Kumar AM <kumar...@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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/f78961ef-b0ce-4e27-a3b2-008760c65c61%40googlegroups.com?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to a topic in the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/MswCCD2qN30/unsubscribe?hl=en.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+unsub...@googlegroups.com.