20% OFF UNTIL THE END OF THE YEAR Use Code: OFF20 for 20% Off! (excluding customizations and support packages)
How to synchronize stock quantity from Odoo to external shop?

How to synchronize stock quantity from Odoo to external shop?

All our connectors (Magento 2, Shopify, Woocommerce, Prestashop) allow stock quantities synchronization from Odoo. That can be configured based on integration on the “Inventory“ tab.

The following settings can be adjusted for Inventory synchronization (see numbers on the screenshot above)

Point 1. Select here field name on the product from which we will be taking quantity that should be sent to external e-Commerce System. We support the following fields:

  • Free to Use Quantity (default) – Quantity On Hand minus Reserved Quantity

  • Quantity On Hand – items available in specific locations (defined in Point 4)

  • Forecasted Quantity – Quantity On Hand minus Quantities needed for confirmed sales orders (reserved + non-reserved) plus confirmed Purchase Orders and Manufacturing Orders

Point 2. If this setting is switched on, then whenever there is quantity changes happening to the product – we will send quantity update to the external e-Commerce System. Every update is sent to the separate async job. So if something wrong will happen you can easily see the error

Point 3. You can mass export actual inventory for every product at some specific time (for example every night). You can enable this functionality using this scheckbox

Warning! We noticed that on some large databases with large amount of products or large amount of inventory transactions process of calculating stock quantity can take significant amount of time. And can overload the server. So use this option with caution and in case of questions, please, send email to support@ventor.tech or directly create requests on our portal https://support.ventor.tech/

Point 4. Define here list of locations from which to synchronize stock quantities. If this list is empty, then quantities will be synchronized from all Physical Locations from all Warehouses for the current company.

You can select as many locations as you want in this list. Even belonging to different Warehouses in the same Company. That is needed in case you have 3 Warehouses, but you need to send stock quantity from Odoo to e-Commerce system only from 2 out of 3 Warehouses.

In case you have complex locations structure with lots of locations and sub-locations (e.g. “WH/Stock/Shelf 1”), and you want to synchronize stock quantity from location and all it’s sub-locations, it is enough to define in the list only parent location (e.g. “WH/Stock“)

You can ignore “External Locations” column for all our connectors except Shopify connector. For Shopify you might be interested to check this article for details related to synchronization of stock to specific Shopify Locations

Related Posts
Leave a Reply

Your email address will not be published.Required fields are marked *