Magento Extensions

Mass Stock Update

Mass Stock Update allows you to update your Magento inventory in one go through any csv files. This extension also allows you to export all your stock into a csv file. This extension includes a task scheduler that automates the stocks update.

  /  2 Reviews

License from

50

1 domain license - €50

  • 1 domain license - €50
  • 2 domains license - €95
  • 3 domains license - €135
  • 4 domains license - €170
  • 10 domains license - €250
  • 1 domain + install - €80
You may also be interested in...

Estimated Delivery Date

Display on the Magento product pages and in the customer cart the estimated delivery date for the available products and for the backorders with a completely customizable message.

License from

€65

1 domain license - €65

  • 1 domain license - €65
  • 2 domains license - €125
  • 3 domains license - €175
  • 4 domains license - €220
  • 10 domains license - €325
  • 1 domain + install - €95

How to use Mass Stock Update?

Mass Stock Update is an extension for Magento that allows you to update your Magento inventory in one go through any csv files and to export all your stock into a csv file. This extension also includes a task scheduler that automates the stocks update whenever you decide to.

Mass Stock Update can also be used as a stock feed system. Indeed, thanks to the csv files that your suppliers are sending you, you can automatically update your stocks.

To use Mass Stock Update, go to System > Import/Export > Mass Stock Update.

How to create a new backup of your complete stock?

To create a backup, you just need to click on Create a store backup. A notification will appear to notify that the operation has been a success as well as to indicate the path to the file.

Each time a profile is run, a backup will be generated.

How to create a new profile?

To create a new profile, click on Create a new profile and follow the three steps.

Profile Setting

To start, you must complete a certain number of fields. First of all, give a name to the profile and fill in the path to the csv file. Choose the type of separator you are using in your file (« ; », « , », « | » or « \tab »). Then, choose the field enclosure (« none », « ‘’ » or « ‘ »).

Define the column in which you want the SKU to be. By default, the SKU will be on 1 - that is to say in the first column.

Then calculate the total stock of each product according to two methods:

  • Either set on one specific column
  • Or by adding every specified columns

Define the stock status update method of each product:

  • Either on one specified column
  • Or automatically (if the value is less than 0, the product isn’t in stock and if the value is higher than 0, the product is in stock).

Finally, with Mass Stock Update it is possible to use custom rules. For that, in Use Custom Rules, choose Yes.

You can now create your own custom rules and manage to do many things such as updating stocks but also other attributes like ‘Color’. 

Here are 4 examples. Our settings are:

  • Column 0: Sku (By default)
  • Column 1: France Paris Store
  • Column 2: Spain Barcelona Store
  • Column 3: Total Stock
  • Column 4: Stock Status
  • Column 5: Global Stock

Example 1

As an easy example, you can get the sum of two columns. For that, write in the Rules field:

$C[3] = $C[1] + $C[2];

Go back in File mapping to see the changes:



Example 2

Imagine you want to make your products out of stock when the total stock is less than 900, you can write:

if ($C[3] < "900") $C[4]="0";

Example 3

Now let’s say all your products are in stock but you want to set only one product out of stock. Its sku is ‘1114’.
To change the status of that product, you’ll need to use the stock id. You have to know that 1 is for in stock and 0 is for out of stock. Knowing that, in the Rules field, you should write:

if ($C[0] == "1114") $C[4] = "0";

It means that if in the first column the sku is ‘1114’ then in the 4th column which is where we choose to display the stock status, the value 0 (out of stock) will be retrieved.

Example 4

Finally, it is possible to define several rules in the Custom Rules field. For example:

$C[3] = $C[1] + $C[2];
if ($C[3] < "300") $C[4]="0";

It will produce:

File mapping

Select Stock Total in the column where is your products quantity and Stock Status for the column which defines if the product is in stock or not. The last column will display the total amount of units as well as the availability of the product, if it is in stock or not.  

Scheduled tasks

You can also schedule your tasks in the Scheduled Tasks tab. For example, on the following screenshot, tasks are scheduled every day at 1 AM.

Save all your data by clicking on Save.  

How to run the profile?

Click on Run profile now to run the profile. A message is displayed to mention that the profile has been successfully run.

The tasks scheduling is another method to run a profile automatically. 

And that's it!

General questions Installation questions
General questions

Is there any limitation in the number of products that can be updated with Mass Stock Update?

The Mass stock update module has no known limitation. Some users update until 80 000 products.

What to do so that an order is assigned to a store?

In a general point of view and the smooth functionning of assignations, each stock must have:

  • One or more store views
  • One or more customer groups
  • Assignations rules based on shipping address (* meaning all destinations).


The assignation is then taken into account according the following settings:

  • Priority of the stock (priority field)
  • Store view of the order
  • Customer group
  • Shipping address
  • Availability of the items in the stock

Why when I click on "Create a backup now" nothing happens?

You can run stocks backup only when debug mode is not enabled in system > configuration > wyomind > mass stock update.

Installation questions

I didn't receive my payment confirmation for Mass Stock Update

1. The payment confirmation email should only take a few minutes, rarely more than one hour
2. Check your spam filter
3. Contact us: we will try again to send it

If I want to test an extension first on a staging server, do I have to buy 2 licenses for 2 domains ?

When installing a module on a new environment, you should see a screen as below offering to update the license, just click on the link Request a free license update in your admin, and your request should be approved within one hour.

How do I install Mass Stock Update?

1. To complete the setup of your extension in the best way, you first need to disable the compiler in your Magento admin. For that, go to System > Tools > Compilation.

If the compiler is activated, you must disable it by clicking on Disable.

2. Then, you need to refresh caches in System > Cache Management.

 

3. Now you can download the zipped extension from your Wyomind account > My downloads. Choose the one you just purchased and click on the grey arrow.

4. Click on the orange link (example: 3. 1.0 available) to download your extension.

5. Once you have downloaded it, unzip the folder content.

6. Copy the folder content (app,skin and lib directories) and paste all files and directories into your Magento web site root directory.

7. Once your installation is complete, don’t forget to enable the Compiler if it was activated before the installation and to Run Compilation Process.

8. Clean the cache and log in again.  

Well done, your Wyomind extension installation is all set! Have a look at our next FAQ on how to activate your license.


I'm asking to overwrite /lib/Varien/Data/Form/Element/link.php, should I carry on?

You can skip this file, it's only for magento < 1.4.

How do I activate Mass Stock Update ?

Now you must activate your license.

1. Copy the activation key (example: ACTKEY-ABCD)
2. Go to System > Configuration > Wyomind and choose the Wyomind extension you have installed.
3. Paste the activation key (that you previously copied from your Wyomind account) in the Activation key field.
4. Save your data.
5. Choose an activation method between Automatic (Yes) and Manual (No) .
Automatic (Yes): you allow a connection to Wyomind's license server
Manual (No): you must log in with your browser to Wyomind's license server

6. A notification appears at the top of your admin: Activate it now! Click on it.
7. Copy and paste the license code in the License code field of your admin or click on Activate now!.
8. You must log out and clean the caches so that the installation is complete. And that's all!

How do I uninstall Mass Stock Update?

In order to uninstall Mass Stock Update, you must remove all the following files and directories:

  • app/etc/modules/Wyomind_massstockupdate.xml
  • app/code/local/Wyomindmassstockupdate
  • design/adminhtml/default/default/layout/massstockupdate.xml
  • design/adminhtml/default/default/template/massstockupdate
  • skin/adminhtml/default/default/massstockupdate
  • app/locale/lang_LANG/Wyomind_massstockupdate.csv

 

Clean the cache and re-launch the compiler (if you use it).

I get an error "err_connection_reset".

It can happen on localhost environments because of rights on session files stored locally.
You have to rename app/code/local/wyomind/massstockupdate/sql/massstockupdate_setup to something different: for example massstockupdate_setup_XX.

I get a 404 error instead of the configuration page in the admin panel

Most of the time log-out/log-in may solve this issue.

How do I fix the issues with scheduled tasks?

Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your magento installation.

Mass Stock Update 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.

I get an error saying "Base table or view not found".

This issue may be due to a problem during the installation process.

You can fix it by following these steps :

  • Access your database via your control panel (cPanel for example)
  • Delete the entry massstockupdate_setup from the table core_resource
  • Logout from your Magento admin
  • Log into your Magento admin

I get a fatal error concerning Mage_Core_Model_Resource_Setup.php

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 234

It probably comes from installing an extension while the compiler is still enabled.

Important note:
• If the compilation is enabled on your website (System > Tools > Compilation). Disable it first before installing any extension. After installation re-run the compilation process and re-enable the compiler.
• Before installing any extension, it's advisable to backup your Magento installation.

Here is the way to disable the magento compiler:
Edit the following file: includes/config.php and add a # before the 2 following lines:

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');

Then go back to your website admin and re-run the compilation process.

Mass Stock Update Features
  • Create update profile in 3 simple steps
  • Update through any type of csv files
  • Create your own custom rules
  • Automatically calculate the stock sum from several columns (option)
  • Automatically calculate the stock availability (option)
  • Real time preview while creating your mapping
  • Create easily scheduled tasks by selecting the days and the hours
  • Create a stock backup in one click
  • Powerful debug mode for developper
Mass Stock Update Screenshots
User's reviews

Leave your review on Magento Connect and get 6 additional months of free upgrade

Great extension, great support
I have nothing but great thing to say about this company. I asked about 15 pre-sale questions and they answered on time with patience. After i bought this extension, they even customized this extension to fit my needs for free within 1 hour. thanks again Paul

dearsimon

2014-07-17

Fantasic solution! Great Extension! Superb Support!
Hopefully my title has summed this one up. I use all of Wyomind's extensions, and this one compares perfectly to the flawless experience I've had with the others.
The extension provides an exceptionally easy to use interface, and provides functionality that I've been waiting for for a long time.
What makes it stand out from the crowd though, is the impeccable support offered. All one my questions have been answered almost immediately, and any issues (not that there were any I may add!) are quickly resolved.
The ability to easily set up a schedule for stock updates is an absolute lifesaver, meaning your store can run like clockwork without all of the manual input.
Get this extension, and you really won't be disappointed!
Thanks

james_allwood

2013-05-04

logo of PayPal


We are proud to be
magento partner

Support or enquiries by email 7/7 . answer under 24h.

15 days money back guarantee

Free Lifetime Support

3 months free updates