Sync Inventory Quantity

xcjy

I have ATUM pro and Our ERP system stores inventory data and integrates data from WordPress and Shopify sites. The total inventory quantity in ERP is accurate.
The problem is that when a sale occurs on a Shopify site, the ERP inventory decreases, but the ATUM inventory data in WordPress does not decrease.

The WordPress site uses the ATUM plugin, employing the Multi-Inventory mode
Each product has multiple variations, and each product variation has multiple warehouses in multiple countries, with each warehouse having different inventory quantities. Inventory quantities change frequently. Manually adjusting them one by one in the WordPress backend is too cumbersome.We have more than 600 products, each with inventory in 3 countries. Roughly speaking, there are 1800 inventory quantities that need to be modified. Manually modifying them would be way too much work.

Here are a couple of approaches:

Real-time updates via RESTful API and ERP platform require coding, which we are not capable of.
Using a plugin like WooCommerce Stock Sync with Google Sheets to synchronize, allowing editing in the spreadsheet without having to manually edit each item in the WordPress backend, saving a lot of time. However, we don't know if it's compatible. Do you know of any plugins that are confirmed to be compatible or other alternative solutions?

Additionally, there is another issue: each product variation needs to be set up with multiple shipping options for multiple countries. However, the WooCommerce shipping options are too basic. Therefore, we need another shipping calculation enhancement plugin. Some of these shipping enhancement plugins are incompatible with ATUM. Do you know of any that are compatible with ATUM?

Forum_Admin

Hi xcjy ,

Thank you very much for your post.

I understand your issue and I guess you are connected to WP or WooCommerce via some 3rd party or API of the 3rd party. However, Multi Inventory is most definitely not compatible with any solutions. Here is our API documentations, see if there is anything you can use to make this work.
I apologise, but this is out of the scope of our support or knowledge to be honest. How are you connected to WC?

Regarding shipping options, that is something we do not handle or ever wanted to handle. I can not recommend anything as I would just search the net same as you.

I apologise for such negative reply.

Pavel

xcjy

Forum_Admin I'm not sure if you misunderstood me. Not involving other API compatibility issues.To simplify the question, we have 600 products, each with inventory and quantity in 3 different locations. The inventory quantity needs to be adjusted frequently, which means there are 1800 inventory quantities that need to be adjusted manually. Is there a simpler way besides restful?

Forum_Admin

Hi,

I am sorry, I may well be missunderstanding. Lets get back to your first post. I will ask questions that may sound stupid, but I need to understand what and why?

Why do you have 2 stores - one is WooCommerce and the other Shopify. They have separate stocks becasue these stocks are in different countries. For example WooCommerce sells in America and Shopify in Europe?

Pavel

xcjy

Forum_Admin 🔤 英文: To be precise, we have 3 WordPress sites for the US, Europe, and South Korea, and one Shopify site in Japan. We manage our inventory in our ERP system, with stock located in multiple countries. We use your Multi-Inventory Pro plugin to manage inventory in WordPress. As previously mentioned, with 600 products and each product having inventory in three countries, we need to modify 1800 inventory levels. We are looking for a way to minimize our workload. We are wondering if your StockTakes plugin can facilitate easier modifications, or if there are other plugins that, even if they don’t synchronize, can reduce the difficulty of our modifications and updates. Something similar to plugins like stock-sync-for-woocommerce-with-google-sheet, which can synchronize inventory to Excel for modification and then sync back to WooCommerce, so we don’t have to manually modify inventory in each product’s backend.
Thank you！

Forum_Admin

Ok, thank you very much for your reply.

That is clear, but my question is if you have a different stock levels for these countries or you have one stock level and ship internationally?

For example there is a warehouse in Korea and when something sells in the US or in Korea the main stock needs to be adjusted as it ships all from one place. Is this the case?

Because if it is, the only way to do this would be possible using the Export Import premium addon. However, you would need to talk to our external developer company. It may need some additional work to setup so it is easier to update.

Pavel

xcjy

Forum_Admin yes ，I have a different stock levels for these countries ，not one stock level and ship internationally

xcjy

Forum_Admin I have a different stock levels for these countries
when something sells in the US or in Korea，the main stock don‘t needs to be adjusted

Salva

Hi xcjy

ATUM only works on a single site. If you need to sync stocks from elsewhere, there is no plugin that can do so that is compatible with Multi-Inventory.
Any plugin you try will only be able to sync the WooCommerce standard stock and not any of the custom inventories you can add with Multi-Inventory.
If you need to do so, you will need custom coding and to use the ATUM API:
https://stockmanagementlabs.github.io/atum-rest-api-docs/#introduction

I hope this helps.

Best Regards,
Salva.

xcjy

Salva I'd like to know if there's a more convenient way to adjust inventory without using RESTful. I'm no longer considering automatic inventory synchronization. Manually entering the backend to modify each item is too cumbersome. For example, can I export product information via ExportPro, modify the inventory information within, and then upload the file? This way, I wouldn't need to enter the backend to modify each item individually. Or are there other methods that allow me to modify inventory more easily? Can the StockTakes plugin achieve this?
thank you

Salva

xcjy

Yes, sure.
I mentioned the API because it would be the easiest way to integrate this and could work automatically.
But if you want to use the Export PRO to download all your stocks, update them manually, and import the file back, it would also work. In this way, you could update stocks in bulk, so it's less cumbersome than editing one by one...