![Syde [formerly Wyomind]](http://www.syde.shop/cdn/shop/files/logo_noir.svg?v=1790605670&width=118){kind=logo}
![Syde [formerly Wyomind]](http://www.syde.shop/cdn/shop/files/logo.svg?v=1790605675&width=118){kind=logo}
MSI Suite
Mass Stock Update allows you to update all your product stocks in Magento in no time thanks to CSV and XML files available from your website's server, from remote servers through FTP, HTTP or a Webservice.
To configure Mass Stock Update in a general way, you have to go in:
Stores › SETTINGS › Configuration › WYOMIND › Mass STOCK UPDATE
Mass Stock Update includes a reporting tool that notifies you each time a profile runs, and so if an error happens.
By default, cron tasks can be scheduled for each period of 30 minutes.
If you need a more precise hour, you can change that interval in the Cron interval field.
To update Magento stocks, you can edit a sample profile or create a new one by clicking on Create a new profile from:
System › Data Transfer › Mass Stock Update
The black-box is a tool that will help you configure your mapping seamlessly. It is composed of 3 major features.
In this section, you will be able to define the source of the data.
XML_sample.sql
var/sample
e.g: 2,4,6,8,10
means lines 2,4,6,8,10 will be imported
e.g: 8-10
means lines 8,9,10 will be imported
e.g: 4+
means all lines from line 4 will be imported
2,6-10,15+
This section allows you to specify where the source data file is stored and what is the file path. Note that you won't be able to save the source file path if the path is invalid.
You have several options:
/directory1/directory2/file.csv
The file path is the URL of the file.
http://www.website.com/Inventory/AvailableInventory
If you are using HTTP authentication, you must add the login and the password before the URL in the below format:
If you are using a specific port, you can use the below format:http://login:password@www.website.com/Inventory/AvailableInventory
http://login:password@www.website.com:port/Inventory/AvailableInventory
parameter1=value1¶meter2=value2¶meter3=value3
The file path is the URL of the dropbox service.
For the URL and Web service locations, the extension checks the SSL certificate of the server of an https address, and that it matches the name of the server, before downloading the file. The option is set to Yes by default, including for the profiles created before version 15.3.0.
Allows you to specify the file type used for the update, XML, JSON, or CSV.
For CSV files, define:
For XML and JSON files, define:
catalog_url
catalog_product_price
From the Stock Settings, you can define:
In this section, you can map each column of the file with one of the stock attributes.
SKU
id
yes
QUICK OVERVIEW OF THE INTERFACE
You can schedule the profile to be executed for all days of the week and with a minimum interval of 30 minutes between each execution.
You have the possibility to change the cron task interval from the General Settings tab.
In the Action History tab, you can find a history of your previous generation and configurations.
You'll find:
To run the profile from the grid, you just need to click on RUN PROFILE in the action menu on the right column. Then the status will be updated with a progress bar.
Open the profile and then click on RUN PROFILE NOW. Once the update process has ended, a message appears with details about how many products have been updated and how many products have been ignored.
When the scheduled tasks are configured for the profile, then the profile will be automatically run at the day and the time selected.
For a good working of the scheduled tasks in Mass Stock Update, the main cron task in Magento must be configured properly.
For more details about how to configure the cron tasks in Magento, look at the official Magento user guide: http://devdocs.magento.com/guides/v2.0/config-guide/cli/config-cli-subcommands-cron.html
You will receive an email each time the cron task is run if you have enabled the reporting in:
Stores SETTINGS › configuration › WYOMIND › Mass Stock Update
Have a look at our documentation to configure the reporting.
Mass Stock Update includes command lines available from any shell console.
To run the profile:
bin/magento wyomind:massstockupdate:run [-p|--profile_ids[="..."]]For example, for profile 2, run:
bin/magento wyomind:massstockupdate:run -p 2To execute the SQL requests that generate when the profile is set to use the SQL mode:
bin/magento wyomind:massstockupdate:sql [-p|--profile_ids[="..."]]For example,, for profile 4, run:
bin/magento wyomind:massstockupdate:sql --profile_ids=4Updating stocks massively may keep your server busy for a while, especially when the update includes numerous products and/or many attributes.
For better performances Mass Stock Update splits the process into two distinct steps:
If you prefer to generate a SQL file without executing it, you must enable the option in the profile settings.
By default: MassStockUpdate.sql
By default: var/tmp/
Example: xml_sample.sql
Then run the profile by clicking on RUN PROFILE NOW.
Once the file is generated in the working directory (see Settings), you only need to update the database with the generated file from the command line as follows:
mysql -h host -p DbPassword -u DbLogin DatabaseName < path/to/mysql/file.sqlIn Mass Stock Update, several events are triggered:
The events can be used in your custom observers.
The argument passed is an instance of Wyomind/MassStockUpdate/Model/Profile.
Below are some examples of use in an observer:
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/Event/etc/events.xsd">
<!-- Standard checkout -->
<event name="massupdateimport_success">
<observer name="editor_module_massupdateimport_success" instance="Editor\Module\Observer\LassUpdateImportSuccess" />
</event>
</config><?php
namespace Editor\Module\Observer;
class LassUpdateImportSuccess implements \Magento\Framework\Event\ObserverInterface
{
public function execute(\Magento\Framework\Event\Observer $observer){
$profile= $observer->getEvent()->getProfile();
// TODO: Implement your own logic.
}
}Mass Stock Update allows you to update all your stock attributes as well as the Advanced Inventory or Advanced MSI attributes.
You can update all the stocks attributes that you can retrieve in the product page from the Advanced Inventory section in:
Catalog › Inventory › Products
All these attributes must be updated with numeric values or boolean values.
Manage stock for products.
yes
Use the default configuration for Manage stock.
yes
Automatically change the stock status depending on the quantity.
yes
The quantity for the product.
13
The minimum quantity for the product.
0
Use the default configuration for the Minimum quantity for the product.
yes
The minimum quantity allowed in the shopping cart.
1
Use the default configuration for the Minimum quantity allowed in the shopping cart.
yes
The maximum quantity allowed in the shopping cart.
10000
Use the default configuration for the Maximum quantity allowed in the shopping cart.
yes
Define if the quantity uses decimals.
no
Allow multiple boxes for shipping.
no
The backorders for the product.
disabled
Use the default configuration for the Backorders.
yes
Notify for quantity below.
1
Use the default configuration to Notify for quantity below.
yes
Enable quantity increments.
false
Use the default configuration for Enable quantity increments.
yes
Quantity increments.
1
Use the default configuration for Quantity increments.
no
The stock status for the product.
In stock
Enable multi stock management with Advanced Inventory.
enabled
All attributes related to the stock management in Advanced Inventory are available in this section.
All these attributes must be updated with numeric values or boolean values.
The stock for the source.
2
Decide to manage stocks for the source.
enabled
The backorders for the source.
disabled
Decide to use the configuration settings for the source.
no
Mass Stock Update allows you to update all attributes related to the Magento Multi-Source Inventory Management (MSI).
All these attributes must be updated with numeric or Boolean values and mapped as follow.
9
1
true
true
Mass Stock Update also allows you to update all attributes coming with the Advanced MSI extension, that you can retrieve in the stocks grid from:
Catalog › Stocks
Allow Qty below 0
2020-03-25
50
Mass Stock Update allows you to fully customize and control the data output by using PHP scripts in different ways.
For each line in the Mapping & Rules tab of your profile, you can add your own custom script based on a PHP syntax.
To add your custom script, click on </> at the end of the line you want to edit. You can then update on the file the value of each column.
Note that the </> button may be hidden by the black box.
<?php
/* Your custom script */
return $self;
return
Any value that you want to output in your profile, must be returned with the return instruction.
$this->skip() or return false (boolean false)
To ignore the pending line (all the columns of the line).
$this->skipRow() or $this->skip() or return false;
To ignore the pending cell as well as all the following cells.
$this->skipCell() or return true;
To ignore the pending cell.
You can call any column of the source file using $cell. It is an array that indexes each column numerically (1,2,3,...) and with a key corresponding to the name of the column header ("name","description","price"...).
$cell["name of the column"] or $cell[INDEX]
For example:
return $cell["description"]. " ".$cell["name"]$self
to retrieve the current value of the column and manipulate the data:
<?php return $self;For example:
<?php return strtolower($self);Below are some examples of use with the PHP API.
Transform a number with a floating value separated with a dot instead of a comma.
For example:
<?php return ucwords(strtolower($self)); ?>Change a text in lowercase and add a capital letter as the first letter of each word.
For example:
<?php return array_pop(explode(",",$self)); ?>
Retrieve only one image from a list of images.
For example:
<?php return array_pop(explode(",",$self)); ?>Put together several columns to create a description.
For example:
<?php return $self." ".$cell["product_name"].", starting at $".$cell["price"]; ?>Define the visibility of a product depending on the type column.
For example:
<?php
switch($self){
case "parent":
return "Catalog, Search";
break;
default:
return "Not visible individually";
}
?>Map values to other ones.
For example:
<?php
if($self=="something"){
return "something else";
}
else if($self=="foo"){
return "bar";
}
else{
return "default value";
}
?>This extension works with Magento Community Edition and also Magento Enterprise Edition. To know if Mass Stock Update is compatible with your Magento version, please check the Compatibility tab.
Magento offers three variations of its product.
As their names have changed over the past few years, here is a recap:
| Mass Stock Update | Mass Product Import & Update | |
|---|---|---|
| Stocks update Update your products stocks from CSV/XML files |
||
| Products update Update your products from CSV/XML files according to multiple attributes groups:
|
||
| Products creation Create products from CSV/XML files |
||
| Preview Get a real-time preview of the output data |
||
| Custom scripts Use custom scripts to improve the updated data |
||
| Schedule Automate the update process using the cron tasks |
||
| Access to a CLI Trigger the import process via your CLI |
A license is valid for an unlimited period of time on one single installation
You can pre-register your live domain to your license in advance.
Thanks to this option, you'll be able to get the module ready to use on your domain before it goes live.
To pre-register your production domain:
One license is valid for an unlimited period of time on one installation only. However, it is possible to extend or transfer your license in 2 cases:
To be able to use Mass Stock Update on both your production and testing environments, follow the instructions below:
In order to download Mass Stock Update, log into your Wyomind account:
A new window opens.
Only the latest extension version released within your Support & Upgrade period is available. In order to get the very latest extension version make sure your Support & Upgrade plan is up to date.
When purchasing a module from wyomind.com, you benefit from 12 months of upgrade. Within this period you can at any time download the latest version of the module directly from your account.
To upgrade Mass Stock Update, follow the steps below:
You can install Mass Stock Update manually.
bin/magento setup:upgrade If you are using a production mode, execute also:
bin/magento setup:static-content:deploy bin/magento setup:di:compile You can install Mass Stock Update using Composer software in two cases:
composer config repositories.wyomind composer https://repo.wyomind.com composer require wyomind/massstockupdatebin/magento setup:upgrade bin/magento setup:static-content:deploy bin/magento setup:di:compileTo uninstall Mass Stock Update, start with disabling the extension running the following command:
bin/magento module:disable Wyomind_MassStockUpdateThen, you have 2 ways to uninstall the extension depending on how the extension has been previously installed:
Run the massstockupdate-uninstall.sh file (you can find it in the extension zip folder) from your Magento root directory:
sh massstockupdate-uninstall.shRun the below command line:
composer remove wyomind/massstockupdateOnce the uninstallation is over, refresh your cache and enable the compiler back again (if you use it).
You can install Mass Stock Update via Web Setup Wizard if you purchased it from Magento Marketplace only.
To know how to proceed, all steps are described in the link below:
http://docs.magento.com/m2/ce/user_guide/system/component-manager.html
Next step is to activate your license:
Extension activation
Once Mass Stock Update is installed, you have to activate the license. For previous versions, you can activate the license from your back-office:
<?php
return array(
'backend' => array(
'frontName' => 'admin'
),
'crypt' => array(
'key' => '1e8f3c6772b7a6a6689c3c8cefa4ccf0'
),
/* ... */
)
?>
Add another domain to your license
To activate the license on another domain (test, staging...):
Note that the order in which you activate your license on your domains does not matter. You can start with your staging/dev/local environment or with your live domain, the process will be the same.
Also, if you have loads of staging domains, or if you are an agency managing load of domains for your customers, please contact us so that we can automatically whitelist these domains.Once Mass Stock Update is installed, you have to activate the license.
For this, you can use the below command line (change the Activation key with the corresponding value):
bin/magento wyomind:license:activate Wyomind_MassStockUpdate <YOUR_ACTIVATION_KEY>To retrieve the list of all the available modules as well as the licenses status, please use:
bin/magento wyomind:license:statusAmong the different status, you can find:
To activate several licenses at the same time, use:
bin/magento wyomind:license:activate \
Wyomind_Extension1,Wyomind_Extension2 \
ACTIVATION_KEY_1,ACTIVATION_KEY_2or:
bin/magento wyomind:license:activate \
Extension1,Extension2 \
ACTIVATION_KEY_1,ACTIVATION_KEY_2For your profile to be executed automatically, you need to define the days of the week and the time of execution directly from your profile configuration in:
System › Data Transfer › Mass Stock Update
By default, cron tasks can be scheduled each period of 30 minutes.
If you need a more precise hour, you can change that interval from:
STores › Settings › Configuration › Wyomind › Mass Stock Update › Settings
Below is an example with an interval of 20 minutes:
For a good working of the scheduled tasks, the main cron task in Magento must be properly configured. Check how cron tasks work.
To define the path to products, you must determine the path to the node where the products are stored.
For example, if your XML source file looks like the one below:
<products>
<item>
<name><![CDATA[Amazing product]]></name>
<images>
<img url="https://www.example.com/path/to/product/image/1.jpg" />
<img url="https://www.example.com/path/to/product/image/2.jpg" />
</images>
<categories>
<category><![CDATA[Category A]]></category>
<category><![CDATA[Category B]]></category>
<category><![CDATA[Category C]]></category>
</categories>
<description><![CDATA[Amazing product description]]></description>
</item>
</products>Then, the path that targets the products is:
/products/item
To define the path to products, you must determine the path to the node where the products are stored.
For example, if your JSON source file looks like the one below:
{"Productlist":[{
"ITEMID":"0123456789",
"ITEMNAME":"Item Name",
"ITEMGROUPID":"4500",
"BRAND":"BRAND",
"YEAR":"0",
"ORIGINCOUNTRYREGIONID":"FR",
"PICTURE":"http://www.domain.com/pub/image.jpg",
"STATUS":"1",
"PRODUCTQTY":"0",
"CURRENT_STOCK":"0",
}]}Then, the path that targets the products is:
$.Productlist
When the structure of your XML file is quite complex, the info may be dispatched in deep nodes and sometimes in tag attributes such as:
url="something"
Then, you can define your own file structure.
Below is an example of a complex XML file where you need a predefined structure:
<products>
<item>
<sku><![CDATA[XYZ]]></sku>
<qty value="150"/>
<options>
<option name="backorders">2</option>
<option name="minimal_in_cart">10</option>
</options>
</item>
</products>The predefined structure you need to use is:
{
"sku":"sku",
"qty":"qty/@value",
"backorders":"option[@name='backorders']",
"minimal_qty":"option[@name='minimal_in_cart']"
}
When the structure of your JSON file is quite complex, the info may be dispatched in deep nodes and sometimes in tag attributes such as:
url="something"
Then, you can define your own file structure.
Below is an example of JSON file where you need a predefined structure:
{"Productlist":[{
"ITEMID":"0123456",
"ITEMNAME":"Product 0123456",
"BRAND":"Best Brand",
"BARCODE":"0123456-ABC",
"CURRENT_STOCK":"0"
}]}The predefined structure you need to use is:
{
"ITEMID":"$.ITEMID",
"ITEMNAME":"$.ITEMNAME",
"BRAND":"$.BRAND",
"BARCODE":"$.BARCODE",
"CURRENT_STOCK":"$.CURRENT_STOCK"
}
This issue may be due to a problem during the installation process.
You will be able to fix it by following these steps:
Be careful, that entry depends on your extension. For example, if you have the extension called Simple Google Shopping, you should delete Wyomind_SimpleGoogleShopping.
Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your magento 2 installation.
The extension includes reporting and debug tools for the scheduled tasks available in:
Stores › Settings › Configuration › Wyomind › Mass Stock Update
For more information on the configuration of cron tasks in Magento 2, you can check their documentation.
You should check that the var/flag and var/tmp folders exist in the Magento root directory. If not, create them with the writing permissions.
PHP features are disabled by default in Mass Stock Update.
In order to use custom rules, you simply need to follow the instructions and to modify the below file at line 144:
magento/app/code/Wyomind/MassStockUpdate/Helper/Data.php
Replace:
// comment this line to use custom rules
return false;
// uncomment below lines to use custom rules
// eval($script);
// return true;with:
// comment this line to use custom rules
// return false;
// uncomment below lines to use custom rules
eval($script);
return true;You should get something as below:
David
Hi, This extension mass stock update from Wyomind is second to none. it works perfectly and it is without doubt the best module on the market if you want to update your stock accurately, easily and the most important, QUICKLY. I used a module from a different vendor previously but it didn't work as efficiently as this one. I strongly recommend to chose Wyomind's stock update. Txs
Area Verde
We have chosen this plugin to import products and update stocks on our site from our management program. We are very satisfied with this application, it interfaces perfectly and is very easy to set up. Plus the support provided by wyomind is EXCELLENT
Proauto
Great extension and support from this company. We've been using a few of their extensions on a number of shops and we've never had any problems with any of them. The support is second to none and always happy to help. We feel like they are part of our team and very professional.
BILL
I am using Wyomind extensions for 4 years now. Since 2018 and i am tottaly satisfied. Especially i use the Wyomind_Massproductimport and it makes our life much easier. Before we have to upload products manually. This is not possible nowadays, and the extension makes our life much easier. You have a lot of control and you can assign almost every possible parameter to import the products as you wish. The most important is after sale support. You will recieve answer within 24 hours. Professional team, knows exactly how to solve problems, and treat a customer. Definitely top star for the extension and the team! Thank you.
Web a delica Support
Easy to install & set up, and very flexible - has a wide range of options available in the Magento 2 Admin System section for configuring your Stock & Product (Items) imports just how you need them to be configured, or you can use the profiles samples if you just need a standard import.
Bob
Was looking for an easy mass stock updater and found this one. We have several suppliers that offer us either csv or other type of files showing their stock. From one supplier we can just use their url which makes it easy to download an updated file. Please let your supplier know to keep the filename the same so that always the latest version is imported. Another supplier uploads their file to our ftp server and in the mass stock updater this is also an option, to download from your own or any ftp server. Files can be csv or xml you can set , or ; any character to separate us or eu versions. Files can also be taken from any magento directory or drop box account.
andy c
Wyomind mass stock management extension for magento 2 looks to be what we are looking for we had a few issue that wyomind are quick to help us out and find the small bug which was stopping us from showing active stock level for our customers.
EricJan
We are very happy with this product!
Nima
works reliably allowing to use php formulas to alter the source content. Perfect if your suppliers have stock lists that you cant use the way the are and need to be changed on the import.
Hendrikus Nijhof
Very powerful php scripting possibilities. Also the retrieval of files from another server is a time saver!
CasaGoda
Great extension and support from this company. We've been using a few of their extensions on a number of shops and we've never had any problems with any of them. The support is second to none and always happy to help. We feel like they are part of our team and very professional.
Rahil
Its really helpfull to sync our ERP with Magento and update stocks on fixed interval of time.
Shoes
This module is a time-saver. You create a profile once, then at a click of a button, the hard work is done by this module. Thank you Wyomind.
Jarda Prochazka
After an few days we needed some support - without any problem quickly together solved, Great - can recommend these guys - nice working with them! Jarda
Max
We use this to sync our inventory from our Back-end sales system to magento. Works great and lets us focus on running our business instead of constantly updating our inventory manually. By setting up rules its a setup and forget type of deal. It just works .
hassan
i was looking to able to update stock periodically , i came across extension which does what i was looking for , this is probably only extension i came across which periodically does stock update and does it when i want how i want. with flexibility to consider weekdays/weekends which was very important
Ron
This module is a time-saver to update our online inventory. The setup process is a breeze. The technical support is very responsive. The documentation is clear to understand. There are many ways to use this module in terms of updating your online records. The easy column mapping works great. You can configure the import profile to automatically update the stock status of the updated products. Pierre, Paul and Aurelie are very patient. This module and the guarantee is best summed ups as follows: ------------------------ The module process in steps: 1 - collect and prepare the queries 2 - update the database As a consequence the resources required to update the database increase with the number of products to update. 1- memory limit 2- mysql server resource The module is updated for free for any bug or critical issue, other updates (new features) are charged 50% of the base price within the 3 months after the purchase. Support is free. Money back guarantee applies without conditions (even if we may ask what is the issue for our records) ------------ It is worth implementing this module whether your online store is small or big. This is an investment that definitely will save money in the end by saving a lot of hours updating the online records. Thank you Wyomind.
Matt W
This is great module and it has helped sync our inventory between our retail locations and our e-commerce website. Hands down the best solution out there! Thank you Wyomind for an amazing module!
zmart
Used lots of times for clients, and the code is really clear and the support is always in a good mood. Thank you
Ivonne
This extension simply made our stock update a kids' game. It is allowing us to manage completely our stock on an automated basis, we barely touch the module code, all are made easily through the admin, and we can get the stock data from any source, from a DB, JSON to CSV. No other extension option was adjusting to our needs. It's an amazing option, simply the best.
Initial release for the master version
Initial release for the legacy version
..
Constants in the helper/data.php file can now be overridden by third-party modules
Refactoring
Specific needs or any ideas of enhancements and new features to add to the extension? Tell us more, we'll get back to you shortly!