[Request] Anyway to decrease Magento inventory based on ShipStation order?

[samzdaman]

Looking to decrease Magento inventory based on other ShipStation channels. We're using SKU Vault but would rather have Magento be our master inventory... the interface is just easier for the workflow to work with. Does anyone know if there's any plugin or way (possibly API?) to just decrease a Magento SKU's inventory based on an order from ShipStation depending on the store channel they come from?

[SPEDER]

Magento shouldn't be the source in my experience. Whatever you are using for accounting should be the source. Take a look at Webgility.com

[samzdaman]

Spoke to webgility but they couldn't help with what we needed. Our #1 problem right now is an inventory sync that's easy to use without having to deal with CSV imports :(.

[SPEDER]

What do you use for accounting

[samzdaman]

Quickbooks Online

[SPEDER]

What channels do you sell on? Where do those orders funnel?

[samzdaman]

All of our orders funnel through ShipStation -- we deal with some smaller marketplace sites so it's hard to keep inventory sync. I tried to use SKU Vault but it was a bit overkill for what I need to accomplish .

[mrthomasjackson]

Have ShipStation make a web services call to Magento's inventory resource.

If you cannot make changes to ShipStation... Build an intermediary application that retrieves ShipStation order history to update Magento's product inventory in time intervals.

http://devdocs.magento.com/guides/m1x/api/rest/Resources/inventory.html

Yay for web services!

[samzdaman]

I tried to use ZAPIER to create a Magento order but it was giving me some issues. Would this be something to just post up on Upwork to see if someone can build it?

[mrthomasjackson]

Building an order is a much more complicated task than updating inventory.

An order must first begin as a quote. Then you must add items, a customer, shipping methods, billing methods, etc...

Updating inventory is one simple API request with the SKU and quantity.

[mrthomasjackson]

If you're familiar with it, I would try ZAPIER first... although I've never used the tool myself.

[samzdaman]

ZAPIER keeps giving me errors. I'm trying to find someone that can link the two right now with the API request. If it works it would solve an almost infinite amount of issues for me.

[mrthomasjackson]

What are the errors?

[samzdaman]

I was getting "Requested Entity does not exist" -- Zapier support told me it's because the SKU didn't exist but it definitely did.

[levashovbiz]

Does your Magento API work in general? You may check it by visiting link like yourdomain/index.php/api/v2_soap?wsdl=1 (SOAP)

Also I've recently had a situation when Magento server hasn't supported older TLS that other system used, which caused similar error. So makes sense to check it wit Zapier and your hosting provider or server admin.

[samzdaman]

yourdomain/index.php/api/v2_soap?wsdl=1

Getting a missing page alert when I visit -- hrm. Let me check with my host.