I need my Drupal Commerce site to synchronize with an external stock management application and to get the stock values for some products from there. Could you give me an advice on how to do that? I've been thinking about using Feeds and Feeds SQL to read from an external resource. If there any "recommended" way to do this?
Hi David,
I held off answering this to see what else appeared, but nothing has so I can tell you how we did it recently.
We had a CSV feed from a POS with a SKU, title, price & a few other things in it.
We started with Feeds but ended up with a custom module using entity wrappers. We needed to update stock levels if the SKU existed in Drupal and create variants & nodes if it didn't. It ended up being 172 lines including comments and whitespace.
I don't know if that's any help to you but maybe someone will jump in screaming 'NOOOOO' and provide something better...
Hi Andy,
Can you give more details about your custom module? or share your code to solve this question?
David, what was your best solution?
Right now I have the same goal, and I would like to get in touch with you to solve it.
Best regards.
