![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}
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 or HTTP.
To use Mass Stock Update, you have to go in:
System › Configuration › WyominD › Mass Stock Update
Mass Stock Update includes a reporting tool that notifies you each time a cron task runs, and so if any error happens.
For more details about the cron tasks, look at the below section:
Configure the cron tasks in a profile
For several email addresses, you must use the comma as a separator.
Mass Stock Update also includes a log file that you can enable.
The file is named Wyomind_MassStockUpdate.log.
To update all your stocks in Magento you can update or create a new profile by clicking on Create a new profile from:
System › Import/Export › Mass Stock Update
The black-box is a tool that will help you configure your mapping seamlessly. It is composed of 3 major features.
To get a preview of the input data, click on Input data.
Clicking on Output data will give you a preview of the data as they'll be updated.
The library allows you to check what values you can use for each attribute.
You will also find some examples to help you.
In this section, you will be able to define the source of the data.
If you activate SQL mode, you'll need to fill in several fields:
This section allows you to specify where the source data file is stored. You have many options:
For CSV files:
For XML files:
File sample
<Import>
<PRODUCTS>
<product>
<name>Product A</name>
<sku>001A</sku>
<qty>864</qty>
</product>
<product>
<name>Product B</name>
<sku>002B</sku>
<qty>594</qty>
</product>
</PRODUCTS>
</Import>The XPath that targets the products in the above file is /Import/PRODUCTS/product
Below is an example of a complex 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 XPath that targets the products in the above file is /products/item
The JSON syntax you need to use is:
{
"sku":"sku",
"qty":"qty/@value",
"backorders":"option[@name='backorders']",
"minimal_qty":"option[@name='minimal_in_cart']"
}
DIRECTIONS FOR USE IN THE PREDEFINED XML STRUCTURE FIELD
@price
[@name='ean']
category
child::item
You have the possibility to define an action after the file is processed, between:
e.g:
means all lines will be imported
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
Automatic stock status update
You can choose to automatically update the stock status (in stock / out of stock).
In this section, you can map each column of the file with one of the stock attributes.
QUICK OVERVIEW OF THE INTERFACE
You can schedule the profile to be executed each day of the week and with an interval of 30 minutes (by default) between each execution.
You can change the cron task interval from:
System › Configuration › Wyomind › Mass Stock Update › Settings
You have several ways to run your profiles.
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 by clicking on the edit option in the action menu in the right column of 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.
Look at the official Magento user guide for more details about how to configure the cron tasks in Magento:
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:
system configuration › Mass Stock Update
Mass Stock Update includes command lines available from the terminal.
php -f shell/wyomind_massstockupdate.php -- [options]The parameters to use are:
Updating stocks massively may keep your server busy for a while, especially when the update includes lot of data.
For better performances Mass Stock Update splits the process into two distinct steps:
If you prefer to generate the SQL file without executing it, you must enable the SQL mode in your profile configuration.
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.sqlYou can also use the command line:
php -f shell/wyomind_massstockupdate.php --sql id1The event "mass_update_success" is triggered when the profile is run and the data successfully updated or imported.
The event is dispatched when the profile is successfully run and can be used in your custom observers. The parameter given in the observer is the running profile.
Event dispatch:
Mage::dispatchEvent("mass_update_success", array("profile" => $this));Example of use in an observer:
class Editor_Module_Model_Observer
{
/**
* @param $observer
*/
public function execute($observer)
{
return var_dump($observer->getProfile()->getData());
}
}All these attributes must be updated with numeric values or boolean values.
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.
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 number_format(str_replace(",",".",$self),2,".",""); ?>Change a text in lowercase and add a capital letter as the first letter of each word.
For example:
<?php return ucwords(strtolower($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.
| 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 |
The Mass Stock Update extension has no known limitation. Some users update until 80 000 products.
We offer our customers who want to migrate their Magento 1 license to a Magento 2 license, the transfer at a reduced price.
You have the possibility to migrate your license directly from your Wyomind account in:
My account › Licenses & Downloads
Click on migrate to magento 2 in front of the extension and the domain you want to transfer.
Confirm you want to migrate your license to a Magento 2 license by clicking on Confirm and checkout .
An invoice will be automatically added to your account from:
My account › Invoices
The price of the transfer is equivalent to a 30% reduction compared to the price of the regular Magento 2 license.
You can proceed to the payment by clicking on PP .
Once the payment is done, you can go back to:
My account › Licenses & Downloads
There you will be able to download and install your license for Magento 2.
A license is valid for an unlimited period of time on one single Magento installation.
If you use more than one Magento installation, you will have to buy a separate license for each one.
If you run several domains on the same Magento installation, you will need only one license for all of them.
Although your license doesn’t have a limited period of validity, your support period does. By purchasing an extension, you’ll be granted a 6-month support period for free. Passed this period, you will have to renew your Support plan (see FAQ: How to extend my support period?).You can pre-register your live domain to your license in advance.
Thanks to this option, you'll be able to get the extension ready to use on your domain before it goes live.
To pre-register your production domain:
next to the extension you want your domain to pre-register on.
One license is valid for an unlimited period of time on one Magento installation only.
It is possible, however, 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:
Now that you can use Mass Stock Update on your production environment, repeat the same steps as above on your testing environments.
The only difference this time: a notification will appear in your Magento admin.
You will be given a choice between:
Click on Add this domain to my license.
A transfer request will then be sent to our team within an hour.
Once the request is taken care of, you will receive a confirmation email.
If your transfer request is accepted, you can use Mass Stock Update on both environments at the same time.
The order in which you activate your license on your domains does not matter.In order to download Mass Stock Update, log into your Wyomind account:
icon next to Mass Stock Update.
A new window opens.
Your download can start.
When purchasing an extension from wyomind.com, you benefit from a lifetime upgrade. You can at any time download the latest version of the extension directly from your account.
To upgrade Mass Stock Update, follow the steps below:
next to Mass Stock Update.
To uninstall Mass Stock Update, go on its zip folder and open it.
You will find a shell file (such as: yourextension-uninstall.sh) that you must execute on both your server and Magento root directory.
Once the uninstallation is over, refresh your cache and enable the compiler back again (if you use it).
Before installing Mass Stock Update, you’ll have to:
Now you can install Mass Stock Update:
Next step is to activate your license, to do so, click here: Extension activation
Once Mass Stock Update is installed, you have to activate the license:
configuration › advanced › advancedIf the message doesn't appear then you must check that:
Wyomind's License Manager has not been removed from your installation.
Wyomind's License Manager is enabled in: app/etc/modules/Wyomind_Licensemanager.xml
The HTML output for Wyomind_Licensemanager and/or Adminhtml_Notification are not disabled in your system under: system
To activate the license of an extension that includes other modules, you’ll have to repeat the steps described above for each extension, using the corresponding activation keys (each module has its own activation key).
For 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 › Import/Export › 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:
System › 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.
You can run stocks backups only when Debug mode is not enabled in:
System › Configuration › Wyomind › Mass Stock Update
If your site crashes and gives this error message after uploading all files to the correct folders:
Fatal error: Class 'Wyomind_Notificationmanager_Model_Resource_Setup' not found in includes/src/Mage_Core_Model_Resource_Setup.php on line 234It probably comes from installing an extension while the compiler is still enabled.
Important note:
Here is how to disable the Magento compiler:
define('COMPILER_INCLUDE_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'src');define('COMPILER_COLLECT_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'stat');to get:
#define('COMPILER_INCLUDE_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'src');#define('COMPILER_COLLECT_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'stat');If you're getting a white page using the extension, you should enable the error reporting in order to display the error. You can do that from index.php.
How do cron tasks work:
Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your Magento installation.
The extension includes reporting and debug tools for the scheduled tasks in:
system › configuration › Wyomind › Mass Stock Update
We also strongly advice to install the AOE Scheduler that will help you to monitor the Magento cron tasks.
This issue may be due to a problem during the installation process.
You can 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 simplegoogleshopping_setup.
If when saving your data feed configuration, you get:
Forbidden, You don't have permission to access /.../ on this server.
This is probably something regarding the hosting company that doesn't allow to post XML in the form.
The mod_security (security module) includes rules that stop all post/get requests including code.
In order to fix that issue, you should get in touch with your hosting company so that they can add some exceptions to the security rules.
If you're getting a weird layout from the Column mapping when the Miravist Core module is installed on your Magento instance, it is because Miravist defines a new rule for the tooltip class without taking into account that many elements could be affected by the class name.
Then, you must edit the file skin/adminhtml/default/default/massstockupdate/import.css and add:
.cell.tooltip{
position:relative!important;
}If when importing or updating data with cyrillic or arabic characters you are getting question marks, the database must be converted to the UTF8 character set.
Here is the request to execute in the database manager:
ALTER DATABASE `magento_db` CHARACTER SET utf8 COLLATE utf8_general_ci;Note you need to replace magento_db with your Magento database name in the above code.
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.
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
Refactoring
Patch:
Patch:
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!