User guide

Mass Product Import & Update allows you to update or import massively products in Magento in a record time thanks to CSV and XML files available from your website's server, from remote servers through FTP or HTTP.

Mass Product Import & Update allows you to create and/or update the below product attributes for all store views or specific store views:

All system attributes (SKU, type, attribute set, visibility, status)
All product attributes created within Magento (input, dropdown, yes/no, multi-select, text...)
All product image attributes (image gallery, base image, thumbnail, small images... )
All stock attributes (qty, availability, backorder, manage stock, low stock notification…)
Categories associated with products
Prices, special prices, special price dates, tax class…

How to configure Mass Product Import & Update

Name: Mass Product Import & Update
Brand: Wyomind
SKU: MPUI
Price: 345 EUR
Availability: InStock
Rating: 5 (115 reviews)

Configure Mass Product Import & Update in a general way

General Settings

To configure Mass Product Import & Update in a general way, you have to go in:

StoresSETTINGSConfiguration WYOMIND Mass Product Import & Update

Log file

Enable log
Allows you to activate the log file available under the var/log directory. The file is named Wyomind_MassProductImportAndUpdate.log.

Note the log file will be written only if the primary log file is active in:
StoresSETTINGSConfiguration Advanced DeveloperLogs settings

M2E Pro update

Notify M2E Pro globally about some change in products

If enabled, updates are transferred to M2E Pro whatever the modification is.

If disabled, the module will only notify M2E Pro that there is an update if the price or the quantity changes.

This feature is only available when the M2E Pro module is installed and enabled.

Mapping preview

Number of rows in mapping preview
Allows you to define the number of rows returned in the browser data of the preview when editing a profile.

Cron job reporting

With Mass Product Import & Update, you have the possibility to enable cron job reporting.

Enable cron job reporting
Allows you to define whether you want to enable the reporting or not in order to get notified each time a profile runs and if an error happens. The more important is the number of rows, the more the load time increases. A good compromise could be 1000 rows.
Sender Email
Type the email of the sender.
Sender Name
Define the name of the sender.
Send the reports to
Specify the email addresses to which the report must be sent. Emails must be separated with a comma (,).
Report title
Define your own title for the report.

For more details about the cron tasks, take a look to know how to configure the cron tasks in a profile.

Cron interval

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.

Check our faq to see how to change the cron interval.

Create an import profile with Mass Product Import & Update

With Mass Product Import & Update, you can update Magento products or create new ones.

For this, edit one of the sample profile patterns or create a new profile by clicking CREATE A NEW PROFILE from:
SystemData TransferMass PRODUCT IMPORT & Update

Black Box

The black-box is a tool that will help you configure your mapping seamlessly. It is composed of 3 major features.

Input Data

To get a preview of the input data, click on INPUT DATA.

Library

The library allows you to check what are the values you can use for each attribute. You will also find some examples to help you.

Output Data

Clicking on OUTPUT DATA will give you a preview of the data as they'll be updated.

Settings

In this section, you will be able to define the source of the data.

Profile settings

Define the settings for your profile.

Enabled
You can enable/disable the profile.
Note that the profile is disabled by default when it results from a duplication.
Profile Name
Only alphabetic and number are allowed + hyphens (-) and underscores (_).
The profile's name must be unique.
SQL mode
When SQL mode is enabled, no data are updated. Running the profile will only produce a SQL file. This file could be executed directly in your database manager.
If you activate SQL mode, you'll need to fill in several fields:
SQL file name
Name of the SQL file to generate.
XML_sample.sql
SQL file path
Is the path where the SQL file will be generated (relative to Magento root folder).
var/sample
Profile method
You can choose the action that the profile will trigger:
Update products only
Import new products only
Update products and import new products
Filter lines
Leave empty to export all lines:
e.g:means all lines will be imported
Type the numbers of the lines you want to import, making sure to separate each line or range with a comma (,):
e.g: 2,4,6,8,10means lines 2,4,6,8,10 will be imported
Use a dash (-) to denote a range of lines:
e.g: 8-10means lines 8,9,10 will be imported
Use a plus (+) to import all lines from a line number:
e.g: 4+means all lines from line 4 will be imported
Use regular expressions surrounded by # to indicate a particular group of identifiers to import:
e.g: #ABC-[0-9]+#
means all lines with an identifier matching the regular expression will be imported

Note you can combine all those options. For example 2,6-10,15+ means line 2,6,7,8,9,10,15,16,17,... will be imported.

When the Profile method option is on Update products and import new products, in the Mapping & Rules tab, you can define for each Target attribute dropdown if the value applies to the new products, or/and to the existing products:

New products only
Existing products only
Both, new and existing products

You can then click Input data from the black box to see your source file

File Location

This section allows you to specify where the source data file is stored and what is the file path including the file name and the extension as it appears in the file system of the server. Note that you won't be able to save the source file path if the path is invalid.

You have several options:

Magento File System
The file is stored in the Magento root directory or a subdirectory of the Magento root directory.
File path relative to the Magento root folder.
See how to use regular expression in the file name.
FTP server
The file is stored on a remote server available from FTP or SFTP. Do not prefix the domain name or the IP with FTP://.
You'll be able to check if the FTP connexion is valid.
The file path is relative to the FTP user root folder.
You can also use regular expression in the file name when it is stored remotely via FTP.

You can also use FTPS (SSL over FTP) for downloading the import file.
URL
The file is stored on a remote server available from HTTP or HTTPS.

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:http://login:[email protected]/Inventory/AvailableInventory

If you are using a specific port, you can use the below format:
http://login:[email protected]:port/Inventory/AvailableInventory
Webservice
The file is available on a remote server accessible as web services.
The extension uses the CURL PHP library to connect the web service.
The file path is the URL of the web services.
You can provide the web service a login/password couple and any parameters formatted as URL parameters, as follows:
parameter1=value1&parameter2=value2&parameter3=value3
Dropbox
You can generate your token from your Dropbox account https://www.dropbox.com/developers/apps
The file path is the URL of the dropbox service.

Have a look at our faq to see How to configure a file available from your Dropbox.

Note you can drag and drop files from your desktop. Only TXT, CSV, or XML files are allowed.

File Type

Allows you to specify the file type used for the update, XML, JSON, or CSV.

File type
You have the choice between CSV, XML, and JSON files.

For CSV files, define:

Column separator
Define the column separator.
Text delimiter
Select the text delimiter.
The first line is a header
Specify when the first line is a header.
Magento export file
Magento default export files are made of empty rows with values related to main rows, activating this option will merge the values into the main rows.

For XML and JSON files, define:

Path to products
Fill in the path that targets the products. The path is case-sensitive.
See how to define the path to your products for XML or JSON files.
Data structure
You have two options: Automatic detection or Predefined structure
The automatic detection fits for simple files made of only one nesting level.
If you've selected the Predefined structure, see how to define your own file structure for XML or JSON source file.

Post Process Action

You have the possibility to define an action after the file is processed.

Action
Do Nothing
Delete the import file
Move import file
Move to folder
Define the file path where you want to move the import file, relative to your Magento root folder.

Note that this option is available only for update files locally hosted in your Magento File System.

Run indexers
You can choose to run the indexers after the import or not:
No: no indexer will run and you will have to reindex manually from the CLI
Only the required indexers: automatically decides which indexers must run
Only the selected indexers: let you decide which indexers to run

If the profile takes too much time to load, you can disable the indexers.
Indexer to run
Choose the indexers to run:
catalogrule_rule
catalogrule_product
catalog_product_price
cataloginventory_stock
inventory
catalog_product_attribute
catalog_url
catalogsearch_fulltext
catalog_category_product
catalog_product_category
Catalog_product_flat and catalog_category_flat are managed if the option is enabled in:
StoresSettingsConfiguration Catalog CatalogStoreFront

Advanced Settings

System Settings

In the System Settings, define the automatic action for missing products from the data file. You have several options:

Do Nothing
Disable the product
Delete permanently the product
Mark the product as out of stock
Mark the product as out of stock and set qty to 0

When using Advanced Inventory with Mass Product Import & Update, you will be able to Set qty to 0 and select the targeted points of sale.

When you decide to mark products that are missing from the data file as out of stock, you must select the targeted sources impacted by the action.

Great Lake Store

When a product is imported using Mass Product Import & Update, it is associated with the profile. If you've selected action for missing products, you'll need to choose the targeted products:

Only products related to current profile: products that are imported/updated with the same profile.
Only products not related to current profile: all the products that are not created/updated by the profile.
All products

Stock Settings

From the Stock Settings, you can define:

Automatic stock status update
You can choose to automatically update the stock status (in stock / out of stock).
Use relative quantity update
Quantity will be added/subtracted to/from the current quantity.

Image Settings

Indicates the path to the directory in which the images to import are stored.

Images location
Http server (URL)
Magento File System
Ftp server

Depending on what you've selected as the location of the images, you'll need to fill in several fields.

For the HTTP server:

Download the image again if it has changed: Yes or No

For the FTP server:

Use SFTP
Use SSL
Use active mode
Host
Port
Login
Password

For the FTP Server and the Magento file System:

Path to images directory

Category Settings

Mass Product Import & Update allows you to create categories on the fly.

Create categories on the fly
Yes or No.
New categories active by default
Yes or No.
New categories included in menu by default
Yes or No.
Category tree auto-detection
To automatically detect the category tree.
You need to use the complete path to the category. The category levels must be separated with slashes: A/B/C.
For example, instead of "Shirts", you should write:
Default Category/Men/Shirts
When the Category tree auto-detection is disabled, the category is added to the root category defined in New categories are children of.

New categories are children of
Choose the parent category.

When the categories associated with the products are updated, then all previous products and categories associations are deleted.
Take a look at our documentation for more details about the configuration of the category attribute.

Configurable Product Settings

Create parent of configurable products on the fly
You can also create/update a configurable product from the simple products available in the source file by enabling this option.

Enable that option only if the configurable products don't exist in the source file and if you want to create/update these products from the simple products information.

When that option is enabled, in the Mapping & Rules tab, you can find for each Target attribute dropdown an option for the configurable products to create on the fly. You have the choice to apply the settings on:

The current product only
The configurable product created on the fly only
Both, configurable product created on the fly and simple product associated

System attributes of the configurable products created on the fly must receive a value either by mapping a field from the source file for the simple product and the configurable product or for the configurable product only.

So that the configurable product and the simples variants are linked, the following attributes must be mapped:

the SKU of the parent product or the SKU of the children products
the configurable attributes

Note that if you want to update or import a product whether it is a configurable or not, you need to use standard attributes.

Mapping & Rules

In this section, you can map each column of the file with one of the stock attributes.

Note that you won't be able to save the mapping if the file path is invalid. See how to specify your file location.

Column Mapping

Each column can be mapped with one of the stock attributes. Note that at any time, you can preview the input and output data in the black box directly.

Target Attribute
Select the target attribute from the ones available in your system.
You can find all the attributes grouped by type in our documentation.
The first line is where you define the identifier of your products. The identifier must be unique,
SKU
Data source
In the Data source, you can define the attribute source that matches with the target attribute from your source file.
id
Default value
Sometimes, some columns can be missing. For example, when updating all stocks, the file does not necessarily include all stock attributes (backorders, minimum quantity in the cart...). In that case, you can choose custom value in the Data source and apply a default value.
yes

QUICK OVERVIEW OF THE INTERFACE

Add as many columns as you want by clicking on + ADD A NEW ROW. In many cases, the update file may contain more columns than necessary; you don't need to add these columns and match them.
DELETE a row easily.
Change the order of each row using the drag and drop.
Deactivate a line while conserving the settings by clicking on the LINK symbol.
Add your own custom script </>. These scripts can be previewed in the output. Note that when there is a script filled in, </> is underlined. See how to use the PHP API.
Add your own replacement rule by clicking on the b icon. These rules can be previewed in the output. Note that when there is a rule selected, a b is underlined. See how to create your replacement rules.
Apply the color of your choice to the row.
Apply a label to the row.
Define to which store view(s) you want to apply these settings by clicking APPLY TO DEFAULT VALUE.
Define to which product(s) you want to apply these settings by clicking APPLY TO THE CURRENT PRODUCT ONLY.
For this setting to appear, the Create parent of configurable products on the fly option must be activated.
Define to which product(s) you want to apply these settings by clicking Apply to Both, new and existing products.
For this setting to appear, the Profile method must be set on Update products and import new products.
Preview your file by clicking INPUT DATA.
Find all the attributes grouped by type in the LIBRARY.
Check the data as they'll be updated by clicking OUTPUT DATA.

Scheduled tasks

You can schedule the profile to be executed for all days of the week and with a default interval of 30 minutes between each execution.

You have the possibility to change the cron task interval from the General Settings tab.

For good working of scheduled tasks in Mass Product Import & Update, the main cron task in Magento must be configured properly.

Action History

In the Action History tab, you can find a history of your previous generation and configurations.

You'll find:

ID
It is the ID of the history line.
Version ID
It is the ID of the profile configuration version.
Origin
The origin of the action can be: Backend / Cron / CLI / API
Username
It is the name of the user behind the action.
Action
The available actions are: create / generate / update / delete
Details
If you click on More details, you can see the detail of the profile update from a grid.

If you click on a line of the above grid, you can check the differences of the updated field: red parts are the removed data and green parts are the inserted data.
Date
It is the date of the modification.

Export and import your profiles pattern

Mass Product Import & Update also allows you to import and export patterns into and from your Magento 2 admin.

Export

To export a profile, edit an existing feed from:
SystemData TransferMass Product Import & Update

Edit a profile and click on Export.

You should find the profile pattern in your Downloads folder.

Import

Before anything, to import a profile pattern, it must be a .conf file, which is specific to the Mass Product Import & Update extension.

Click on Import a Profile from:
SystemData TransferMass Product Import & Update

Browse the .conf file and click on Import.

The profile pattern should have been added to the list.

Note that exporting a profile pattern is different than running a profile. When you export a profile, only the template is saved, while when you run a profile, the products data are involved.

Run your Mass Product Import & Update profiles

From the profiles grid

To run the profile from the grid, you just need to click on RUN PROFILE from the action menu on the right column. Then the status will be updated with a progress bar.

From the profile page

Edit the profile and then click on RUN PROFILE NOW.

Once the import/update process has ended, a message appears with details about how many products have been updated/imported and how many products have been ignored.

With the cron tasks

When the scheduled tasks are configured for the profile, then the profile will be automatically run at the day and the time selected.

So that the scheduled tasks work well in Mass Product Import & 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 SETTINGSonfigurationWyomind Mass Product Import & Update

Have a look at our documentation to configure the reporting.

With the Command Lines Interface

Mass Product Import & Update includes command lines available from any shell console.

To run the profile:

bin/magento wyomind:massproductimport:run [-p|--profile_ids[="..."]]

For example, for profile 2, run:

bin/magento wyomind:massproductimport:run -p 2

To execute the SQL requests that generate when the profile is set to use the SQL mode:

bin/magento wyomind:massproductimport:sql [-p|--profile_ids[="..."]]

For example,, for profile 4, run:

bin/magento wyomind:massproductimport:sql --profile_ids=4

Use SQL option

Updating or importing products massively may keep your server busy some times, especially when the update or the import includes numerous products and/or many attributes.

For better performances Mass Product Import & Update splits the process into two distinct steps:

Source file analysis: the data are collected and the SQL queries for the update/import are built.
The SQL file execution: the database is updated with the new data.
This step may be executed asynchronously when the SQL option is enabled.

Generate the SQL file

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 NOW.

Execute the SQL file

Once the file is generated in the working directory, 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.sql

Advanced use

With Mass Product Import & Update, several events are triggered:

massupdateimport_start
Triggered when the update/import process starts.
massupdateimport_success
Triggered when the profile is run and the data successfully updated/imported.
massupdateimport_failure
Triggered when the profile is not run and the data are not updated/imported.

The events can be used in your custom observers.

The argument passed is an instance of Wyomind/MassProductImport/Model/Profile.

Below are some examples of use in an observer:

From etc/events.xml:

<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="EditorModuleObserverLassUpdateImportSuccess" />
</event>
</config>

From app/code/Editor/Module/Observer/MassUpdateImportSuccess.php:

<?php
namespace EditorModuleObserver;
class LassUpdateImportSuccess implements MagentoFrameworkEventObserverInterface
{
public function execute(MagentoFrameworkEventObserver $observer){
$profile= $observer->getEvent()->getProfile();
// TODO: Implement your own logic.
}
}

Attribute specifications to import or to update

Mass Product Import & Update allows you to import/update all attributes, even those with a custom model.

System attributes

The below attributes are required when importing new products.

If these attributes are not available in the mapping, then the imported products will be visible neither in the front-end or the back-end.

The system attributes have a global scope and cannot be updated/imported specifically for each store views.

Sku

The unique identifier of the product to update or to import.

sku1

Attribute set

The attribute set to apply to the product.

You can either use the attribute set name (case insensitive) or the attribute set ID.
bag

To know the attribute sets available in your system, go to:
StoresAttributesattributE Sets

Type

The product type.

You must use the product type name (case insensitive).

It can be:

simple
configurable
grouped
bundle
virtual
downloadable
custom product type

simple

Website

The website(s) to which belongs the product separated by a comma.

1,2

You can either use the website IDs or the website names (case insensitive).
Main Website Store

Main Website Store,Second Website Store

To know the names and the ids of the websites available in your system, go to:
StoresSettingsAll Stores

Tax Class

The product tax class.

You can either use the tax class name (case insensitive) or the tax class ID of the product.
Taxable Goods

To know the names and the ids of the tax classes available in your system, go to:
StoresSettingsConfigurationSalesTaxtax classes

Visibility

The product visibility.

You can either use the visibility name (case insensitive) or the numerical value associated.

Not visible Individually
Catalog
Search
Catalog & Search

Catalog,Search

Status

The status of the product: enabled or disabled.

You can use any of the below values:

enabled / disabled
enable / disable
true / false
yes / no
1 / 0

enabled

Products attributes

All attributes created in your stores and/or any attributes that are listed in another section are available in the product attributes section.

Note that all attributes are supported even those with a custom source model.

Text or textarea attribute

The text or textarea attributes accept any value without any restriction.
Your text

Yes/no attribute

The yes/no attributes can be updated with any of the below values:

enabled / disabled
enable / disable
true / false
yes / no
1 / 0

true

The drop-down attributes can be updated with:

the option id
4
the option label
red

The values of dropdown attributes can be translated to the different store view languages as below with the color attribute:
red[de=rot|fr=rouge|es=rojo]

For each store view language, you can choose to use the default value by using #empty#. Below, the DE translation will be empty and the default value red will be used (the default store is FR):
red[fr=rouge,de=#empty#]

If you want to use a fixed value, you can select one from the dropdown.

Find the store codes of your store views in:
Stores SettingsAll stores

Multi-select attributes

The multi-select attributes can be updated either with a list of option labels or a list of option ids separated with a comma.
Men, Boys

Note that all the multi-select options are now automatically populated and you can directly select multiple values:

To know the labels and ids of the drop-down and multi-select attributes, go to:
StoresAttributesProduct edit attribute Manager label / option

Date attributes

The date attributes must be formatted with the date and time GMT:
YYYY-MM-DD hh:mm:ss
2019-06-11 15:09:52

If the dates are misformatted in the update/import source file, then you can use your own script using the PHP API.

Prices attributes

Price

The price attribute can be a float number or an integer number.

It must be formatted with a dot as a decimal separator.
15.50

If the prices are misformatted in the update/import source file, then you can use your own script using the PHP API.

Special price

The special price attribute can be a float number or an integer number.

It must be formatted with a dot as a decimal separator.
10.50

If the prices are misformatted in the update/import source file, then you can use your own script using the PHP API.

Special price from/to date

The special price from/to date must be formatted with the date and the time GMT as below:
YYYY-MM-DD hh:mm:ss
2019-06-17 11:29:51

If the prices are misformatted in the update/import source file, then you can use your own script using the PHP API.

Tier price/Group price

You have two possibilities:

Add Tier price/Group price
Creates a new Tier price/Group price that is added to the existing ones.
Replace Tier price/Group price
Replaces all the existing Tier prices/Group prices with the new ones.

The list of tier prices must be separated by ~ as below:
[Group id 1]|[Qty 1]|[Price 1]~[Group Id 2]|[Qty 2]|[Price 2]~...

*|5|9.99~*|10|7.99~...

To import your tier prices as discounts, add % at the end of each price. Otherwise, your tier prices will be imported in cash.
*|5|10%~*|10|5%~...

Below is the list of the codes to use for the customer groups ids:

*: All groups
0: Not logged in
1: General
2: Wholesale
3: Retailer
4: VIP Member
5: Private Sales Member

If the prices are misformatted in the update/import source file, then you can use your own script using the PHP API.

Weee tax

The list of taxes must be separated by ~ as below:
country1|region1|tax1~country2|region2|tax2~...

Country code
It can be: FR, US, CA, NZ...
Region
Use * for all states
Tax
This is a fixed value

FR|*|13~UK|*|18

Stock attributes

All attributes related to the stock management in Magento are available in this section.

All these attributes must be updated with numeric values or boolean values.

Boolean values

Boolean values must be updated with one of the below values:

1 / 0
yes / no
true / false
enable / disable
enabled / disabled
in stock / out of stock

in stock

Numeric values

Numeric values must be updated with one of the below types:

Integer number (no white space)
Float number (decimal separated by a dot)

10.50

If the values are misformatted in the update/import source file, then you can use your own script using the PHP API.

MSI attributes

Mass Product Import & 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.

You can easily check if you are using the Magento MSI module from your back-office inStoresinventory. There, you should see the sources and stocks items.

Quantity

The stock for the source.

Notify Qty

Notify the quantity for the source.

Use default for notify Qty

Use default to notify the quantity for the source.

true

Stock Status

Stock status for the source.

true

MSI Backorders attributes

Mass Product Import & Update also allows you to update all attributes coming with the MSI Backorders extension, also available in the MSI Suite.

You can retrieve these attributes in the products pages from:
CatalogProducts

Backorders

Choose the status of the backorder among:

Allow Qty Below 0
Allow Qty Below 0 and Notify Customer
No Backorders

Allow Qty below 0

Backorders date

Backorders date in the following format:
YYYY-MM-DD hh:mm:ss

2020-03-25

Backordered qty

Backordered quantity.

Dynamic attributes

You have the possibility to create a dynamic mapping giving you more flexibility in the configuration of your profile. In your source file, for the same column, you can indicate the Magento attribute to map as well as the associated value.

Dynamic attribute

Code of the Magento attribute to map and the associated value.

The syntax to use is:
attribute_code=value

length=150

You can also use several dynamic attributes separated by a pipe in the same mapping row.

color=red|size=XL|description=description

See more about how to use different attributes and attribute values in the same column.

Media attributes

All attributes related to the media management are available in this section.

The image/video source directory must be defined in the Image Settings tab.

Media Gallery

The images to insert in the image gallery must be listed in the Image Gallery field as the relative path to the image source directory specified in the Image Settings tab for local storage or FTP storage and as an absolute path if hosted on a remote server.

Each image path must be separated by one of the below characters:

| (pipe)
, (comma)
; (semi-colon)

Attention, we strongly advise you not to use the pipe separator if you use the parameters below because the image separator must be different from the parameter separator.

You can use the below parameters:

media_type
image (default value)
external-video
disabled
Default value is 0.
You have the possibility to assign values by storeview by suffixing disabled with the store code.
label
Default value is empty.
You have the possibility to assign values by storeview by suffixing label with the store code.
position
Default value is 0.
You have the possibility to assign values by storeview by suffixing position with the store code.
destination
Default value is empty.
It is the name of the new image.

You can use additional parameters for external-video media type:

provider
Default value is empty.
url
Default value is empty.
title
Default value is empty.
description
Default value is empty.

path/to/video/preview.jpg[media_type=external-video|title=Video 1|url=https://vimeo.com/6370469]

In the case where you don't add the parameters in the syntax, the default values will be used.

Note that the gallery image row must stand before the base, thumbnail, and small image rows because Gallery Image erases all images.

Base Image, Small Image, Thumbnail

You can associate a specific image from the Image gallery to any image attribute.

By default the image attribute available in Magento are:

Base Image: image that appears on the product page
Small Image: image that appears on the category page
Thumbnail: image that appears on the cart, on the checkout, on the customer account...

If you have created your own image attributes in your stores, these attributes will be visible in this section.

When importing/updating the image attributes, Mass Product Import & Update will add the image to the image gallery automatically. The image source directory must be then specified in the Image Settings tab.

Swatch attributes

Swatch

You can import/update Swatch attributes using their label for the default store:
magenta

You can also use the below parameter:

color
You must add the hexadecimal code for the color in the below format:

label[color=#HEXACODE]

red[color=#FF0000]

Note that when the color property is not imported, the existing color is kept for the swatch.

The values can also be translated to the different store view languages as below:
label[storecode="translated label"|color=#HEXACODE]
red[fr="rouge"|de="rotte"|es="rojo"|color="#FF0000"]

To remove the existing color for the swatch, you can import the color property using the empty value.

indigo[color=empty]

Category attributes

The categories associated with the products can be imported/updated with new values.

You have the possibility to choose the action between:

Replace all categories with
Add to the categories
Remove from the categories

Category mapping

List your category names (case sensitive) or category ids separated with a comma:
category ID 1 [position],category ID 2 [position]...

You can use the below parameter to define the position of the products in the categories:

position
Default value is empty.

For example, to import your product in position 2 in the category ID 10 and in position 1 in the category ID 13, you can write:
10[2],13[1]

10[position=2],13[position=1]

The values will be translated into category paths according to the parameters you have defined in your profile configuration from:
Advanced SettingsCategory Settings

In the case where you don't add the parameter in the syntax, the default value will be used.

For example, to import products in the New Arrivals (ID: 10) and Dresses & Skirts (ID: 13) categories, from the Mapping & rules tab of your profile configuration, map the product attribute of your choice, for example, Add to the categories with a custom value.

In the following field, you can define:10,13

Note that you should set the Category tree auto-detection to NO if you're using categories IDs.

If you prefer using the category names, you could have written:
Default Category/Women/New Arrivals,Default Category/Women/Dresses & Skirts

Categories will be created/updated according to what you've defined in the Advanced Settings tab

Merchandising attributes

The related/up-sell/cross-sell products can be imported/updated with new values.

Note that if other types of relationships have been created, our module will be able to import them.

List of related product SKU's separated by commas.
SKU1,SKU2,SKU3...

For versions <v4.2.2, use | to separate each SKU.

Configurable product attributes

With Mass Stock Import & Update you can create configurable products on the fly and create relationships between children and parents.

Parent SKU

Specify the parent SKU.
skuparent

When updating/creating a simple product, you can add the configurable product reference so that the simple products will be automatically associated with the configurable product.

The child product must be updated/created with the configurable attributes required by the configurable product, example: color and size.

Children SKUs

List of the children SKUs separated by commas.
sku1,sku2,sku3

When updating/creating a configurable product, you can add the children references so that the simple products will be automatically associated to the configurable product.

Configurable attributes

Attribute code or attribute IDs separated by commas as below:
attribute code 1[position],attribute code 2[position]

You can use the below parameter to define the position of the configurable attributes:

position
Default value is empty.

size[1],color[2]...

In the case where you don't add the parameter in the syntax, the default value will be used.

When creating/updating a configurable product, the configurable attributes must be specified.

If you don't provide these attributes when creating a new configurable attributes, the product will not appear on the front-end

Downloadable product attributes

With Mass Stock Import & Update you can import or update downloadable products.

Links title

Title of the downloadable resource.
Downloadable file

Samples title

Title of the downloadable resource.
Downloadable sample

Link URLs

Link to the file (relative or absolute path) and optional file's name separated by a pipe (|).
Link | File name
http://www.example.com/filename.ext | My downloadable file

Sample URLs

Link to the file (relative or absolute path) and optional file's name separated by a pipe (|).
Link | File name
http://www.example.com/filename.ext | My downloadable sample

Grouped product attributes

With Mass Stock Import & Update you can create grouped products and create relationships between children and parents.

Parent SKUs

When updating/creating a grouped product, you can add the parent references so that they will be automatically associated with the grouped product.

List of related parent product SKU's separated by commas
parentsku

Children SKUs

When updating/creating a grouped product, you can add the children references so that they will be automatically associated to the grouped product.

List of related children product SKU's separated by commas

You can use the below parameter:

position
Default value is empty.

sku1[position=2],sku2[position=1]

Bundle product options

With Mass Stock Import & Update you can add/update or remove options from bundle products.

Add/update an option

You can use the below option parameters:

type
select / radio / checkbox / multi
Default value is select.
required
Default value is 1.
option_position
Default value is 1.

And you can use the below product parameters:

sku
SKU of the option's products
It is a required value.
selection_qty
Default value is 1.
is_default
Default value is 0.
selection_price_type
Default value is 0.
selection_price_value
Default value is 0.
selection_can_change_qty
Default value is 0.
position
Default value is 1.

The above example will create the following option:

In the case where you don't add the parameter in the syntax, the default value will be used.

You can add several products to an option, however, each option must be on a separate line.

Remove an option

Bundle items option title to remove
Accessoiries

The above example will remove the "Accessoiries" option.

You can only remove one option per line.

Custom options

With Mass Product Import & Update you can import or update your product custom options.

You can update the custom options according to the storeview. To be able to modify its value for a particular storeview, the custom option must exist in the default scope level.

You can use the below parameters:

is_require
If the custom option is a required field: is_require=1.
Default value is: is_require=0
title
Default value is empty.
sku
Default value is empty.
price
Note that the price can be a percentage or a fixed amount.
10 or 10%Default value is null.
sort_order
Default value is null.

In the case where you don't add the above parameters in the syntax, the default values will be used.

Text Field / Textarea

You can use the below parameters:

is_require
If the custom option is a required field: is_require=1.
Default value is: is_require=0
title
Default value is empty.
sku
Default value is empty.
price
Note that the price can be a percentage or a fixed amount.
10 or 10%Default value is null.
sort_order
Default value is null.
max_characters
Default value is null.

If no value is defined for the above parameters, the default values will be used.
Custom option Text [is_require=1|sku=txt|price=10.00|sort_order=1|max_characters=100]

File

You can use the below parameters:

is_require
If the custom option is a required field: is_require=1.
Default value is: is_require=0
title
Default value is empty.
sku
Default value is empty.
price
Note that the price can be a percentage or a fixed amount.
10 or 10%Default value is null.
sort_order
Default value is null.

file_extension
Default value is null.

If no value is defined for the above parameters, the default values will be used.
Custom option File [sku=upload|price=99.99|sort_order=2|file_extension=jpg,png,gif]

Replacement rules

Mass Product Import & Update allows you to control the data output by using replacement rules.

Create a replacement rule

You can create your own rule from:
SystemMass Product Import & UpdateReplacement Rules

Click on Create a new Rule.

Create a replacement rule manually

You can create your own rule manually.

Fill in a name and add the values you need to replace in the Input column with other values in the Output column.

For example, the below example shows how to replace each "Summer 2018" with "Summer 2019" and all the rest with "This season".

Note that you have the possibility to use regular expressions.

Import a rule set from a CSV file

You also have the possibility to import a rule set directly from a CSV file.

Click on Import a rule set from a CSV file and choose your CSV file. Click on Import.

The CSV file must be composed of 2 columns, the first one for the values to replace and the second one for the replacement values.

These values must be separated by commas and enclosed by quotation marks.

"Winter 2016","Winter 2019"
"Winter 2017","Winter 2019"
"Winter 2018","Winter 2019"
"Summer 2016","Summer 2019"
"Summer 2017","Summer 2019"
"Summer 2018","Summer 2019"

Once the lines have been imported, you receive a notification.

Use a replacement rule in your profile

Select a replacement rule

Once your rule is saved, you can use it in your profile from:
SystemMass Product Import & UpdateProfiles

For the attribute you want to edit, click on the ab icon.

A popup displays where you can select the rule you want to apply. Select the rule and click on Validate.

Output the replacement rule value

If you click on Output Data from the black box, you should see the replacement rule value in purple followed by the original value in grey.

PHP API for Mass Product Import & Update

Mass Product Import & Update allows you to fully customize and control the data output by using PHP scripts in different ways.

API coding standards

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.

Opening and closing tags

Every script must include the opening PHP tag <?php. Note that it is not necessary to use the closing tag.

<?php /* Your custom script */ return $self;

Outputting a value

return
Any value that you want to output in your profile, must be returned with the return instruction.

$this object

$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.

Variable $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"]

Note it is better to use associative keys. In that case, if the column order changes in the file, your scripts will still be valid.

Variable $self

$self
To retrieve the current value of the column and manipulate the data:

<?php return $self;

For example:

<?php return strtolower($self);

Examples of use

Below are some examples of use with the PHP API.

Change the separator

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 to lowercase or capital letters

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 images

Retrieve only one image from a list of images.

For example:

<?php return array_pop(explode(",",$self)); ?>

Group several columns

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

Define the visibility of a product depending on a column value.

For example:

<?php
switch($self){
case "parent":
return "Catalog, Search";
break;
default:
return "Not visible individually";
}
?>

Map value to other ones

Map values to other ones.

For example:

<?php
if($self=="something"){
return "something else";
}
else if($self=="foo"){
return "bar";
}
else{
return "default value";
}
?>

Retrieve values based on conditions

Output values based on different conditions.

For example:

<?php
if ($self > 200) return "0";
else return $self;
?>

Take your product catalog management experience to the next level!

Manage, automate, and monitor the mass import and update of your Magento^® 2 products with ease and efficiency from the Cloud.

Lifetime license
12 months support & upgrade
60 days money-back guarantee
Extensible source code
Unlimited test domains
Free composer access
Marketplace approved

Want to know more?

Import and update your products from any source

Update and create new products from CSV, XML, or JSON files available from your website's server or from remote servers using FTP or HTTP.

File Formats
CSV, XML, and JSON files

Sources
Magento^® files system, dropbox, FTP, HTTP

M2E Pro compatibility
Notify M2E Pro globally about any product updates

Automate the import/update tasks

Completely automate the import and update tasks and be notified in real-time of the progress of the process.

Cron task
Automate import and update profiles execution by scheduling them via cron tasks.

CLI
Fastly and efficiently trigger your import and update profiles with the command line interface.

Import incomplete or misformatted data without headaches

User-friendly interface
Enjoy a very easy-to-use interface and save considerable time.

Advanced mapping features
Simplify your import/update processes with advanced mapping.

Custom rules
Easily correct inconsistent, incomplete, and misformatted data.

Real-time preview
Visualize the output data before updating/importing your products.

PHP API
Use your own scripts to customize your import/update profiles as you want.

Replacement rules
Fully customize the output data thanks to the replacement rules.

Update or import all product attributes in only one process

Mass Product Import & Update allows you to create complex and dynamic mappings from a single data source without having to build multiple import profiles.

Images
Image gallery, base image, thumbnail, small images...

Prices
Prices, special prices, special price dates, tax class…

Store view
Product attributes for all or specific store views.

Categories
Categories associated with the products.

Configurable products
Required configurable product attributes.

Downloadable products
Necessary downloadable product attributes.

Save huge time creating your profiles

Start with the 4 included sample profiles and export/import profiles pattern.

Do you want to know more?

Play with our demo

Get in touch with us

Explore our user guide

Freqently Asked Questions

Pre-sales informations

Magento^® Open Source vs Magento^® Commerce vs Magento^® Commerce Cloud

Magento offers three variations of its product.

As their names have changed over the past few years, here is a recap:

Magento Open Source: previously Magento Community Edition (CE), is a free and non-hosted e-commerce platform.
Magento Commerce: previously Magento Enterprise (EE), is the paid version of Magento and offers support services.
Magento Commerce Cloud: is the paid version of Magento and offers support and hosting services.

Mass Stock Update Vs Mass Product Import & Update

	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: Image, Category, Merchandising (up sell, cross sell, related products), Price (Weee tax, group price, tier price, special price...), Downloadable products, Grouped products relation, Configurable products relation, Custom options, System attributes (website, sku...), Attributes defined by the user
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

License and domains

License validity

A license is valid for an unlimited period of time on one single installation

If you're using more than one installation, you will have to buy a separate license for each instance.
if you're running several domains on a same installation, you will need only one license for all of them.

Although your license doesn’t have a limited period of validity, your Support & Upgrade period does. By purchasing a module, you’ll be granted a 12-month support period for free. Passed this period, you will have to pay for a new one (see FAQ: Extend your Support period)

Domains pre-registration

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:

Go to:
mY accountLicenses & DOwnloads
Click on the Settings icon next to the module you want your domain to pre-register on.
Click on the link at the bottom of the page saying:
Do you want to pre-register your domain in order to be ready to go live?
Finally, enter your domain name and click on pre-register now .

Attention, this doesn't mean your license is activated. You'll still have to activate it on your new domain when the module is installed.

Testing environments

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:

If you would like to add your testing environments to your license.
In that case, it is possible to extend your license to an unlimited number of domains for free.
For mywebsite-staging.com or mywebsite-dev.com
If you want to transfer your license to another live domain.
In that case, the Support & Upgrade period for your license must still be active.

To be able to use Mass Product Import & Update on both your production and testing environments, follow the instructions below:

Download Mass Product Import & Update.
(see FAQ: Extensions download)
Install Mass Product Import & Update on your environment.
(see FAQ: Modules installation in Magento or in WooCommerce)
Activate the license.
(see FAQ: Licenses activation in Magento or in WooCommerce)

Also, if you are managing a large amount of domains, please contact us so that we can automatically whitelist these domains.

Modules versioning and download

Extensions download

In order to download Mass Product Import & Update, log into your Wyomind account:

Go to:
my accountLicenses & downloads
Click on the settings icon next to Mass Product Import & Update.

A new window opens.
Click on the download icon.

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.

Modules upgrade

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 Product Import & Update, follow the steps below:

Go to:
my accountLicenses & Downloads
Click on the settings icon next to Mass Product Import & Update.
Click on the download icon.
Install the new version of Mass Product Import & Update in your Magento admin or your WooCommerce back-office.

Modules Installation/Uninstallation

Extensions manual installation

You can install Mass Product Import & Update manually.

Download Mass Product Import & Update (zip file) on:
mY ACCOUNTLicenses & Downloads

Refer to the FAQ: Extensions download
Once Mass Product Import & Update is downloaded, open the folder and unzip it.
Copy the content of the unzipped folder and paste all files and directories in your Magento 2 root directory.

In your Command Line Interface, execute:

bin/magento setup:upgrade

If you are using a production mode, execute also:

bin/magento setup:static-content:deploy

bin/magento setup:di:compile

Extensions installation via Composer

You can install Mass Product Import & Update using Composer software in two cases:

if you purchased Mass Product Import & Update on Magento Marketplace.
if you purchased Mass Product Import & Update on Wyomind.com AND requested access to our repository:
repo.wyomind.com

Add to your composer configuration our repository:

composer config repositories.wyomind composer https://repo.wyomind.com

Execute Composer command:

composer require wyomind/massproductimport

Then go in your Command Line Interface and execute:
```
bin/magento setup:upgrade 
```

If you are using a production mode, also execute:

bin/magento setup:static-content:deploy

bin/magento setup:di:compile

Extensions uninstallation

To uninstall Mass Product Import & Update, start with disabling the extension running the following command:

bin/magento module:disable Wyomind_MassProductImport

Then, you have 2 ways to uninstall the extension depending on how the extension has been previously installed:

Manual installation

Run the massproductimport-uninstall.sh file (you can find it in the extension zip folder) from your Magento root directory:
```
sh massproductimport-uninstall.sh
```
Installation via Composer

Run the below command line:
```
composer remove wyomind/massproductimport
```

Once the uninstallation is over, refresh your cache and enable the compiler back again (if you use it).

Extensions installation via Web Setup Wizard

You can install Mass Product Import & 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

Modules activation

Extensions activation from the back-office of Magento^®

Once Mass Product Import & Update is installed, you have to activate the license. For previous versions, you can activate the license from your back-office:

Go to your Magento admin panel. A message pops up at the top of the page.
If the message doesn't appear then you must check that:

1. The Adminhtml_Notifications and Wyomind_Core modules are well enabled.
2. The HTML output of the Adminhtml_Notifications and Wyomind_Core modules are not disabled in:
storesconfigurationadvanced advanced
3. The encryption key well exists in app/etc/env.php:
```
<?php
 return array(
 'backend' => array(
 'frontName' => 'admin'
 ),
 'crypt' => array(
 'key' => '1e8f3c6772b7a6a6689c3c8cefa4ccf0'
 ),
 /* ... */
 )
?>
```
Copy your activation key in:
StoresConfigurationWyomind Your extension

You can find your activation key in 2 different places:
- In the confirmation email that you received after purchasing Mass Product Import & Update.
- In your Wyomind account:My account Licenses & downloads
Select Mass Product Import & Update and click on .

A new page opens where you'll find your activation key (see below).
In your Magento admin go to:
StoresConfigurationWyomind Your extension

Paste the activation key in the Activation Key field and choose between the automatic (yes) or the manual (no) activation method:
- By choosing Yes, the connection to Wyomind license server will be automatic.
- By choosing No, you will have to log on to Wyomind license server yourself.
Click on Save config .
A message appears at the top of your admin panel. Click on that link:
Activate it now!
Copy and paste the license code in the License code field from your admin or simply click on Activate now!
Finally, refresh your cache, log out and log in back straight after, to complete the installation.

When the extension includes other modules, repeat the steps described above for each one, using the corresponding activation keys (each module has its own activation key).

Add another domain to your license

To activate the license on another domain (test, staging...):

Once the extension is installed on the new domain, copy your activation key in:
StoresConfigurationWyomind Your extension
After having saved the configuration, a notification appears. 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 Product Import & Update on both environments at the same time.

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.

Extensions activation from the CLI

Once Mass Product Import & 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_MassProductImport <YOUR_ACTIVATION_KEY>

To retrieve the list of all the available modules as well as the licenses status, please use:

bin/magento wyomind:license:status

Among the different status, you can find:

registered = your license is registered
pending = you need to run the activation command line
invalidated = the license has been invalidated due to a wrong activation key or a license infringement

To activate several licenses at the same time, use:

bin/magento wyomind:license:activate \
Wyomind_Extension1,Wyomind_Extension2 \
ACTIVATION_KEY_1,ACTIVATION_KEY_2

or:

bin/magento wyomind:license:activate \
Extension1,Extension2 \
ACTIVATION_KEY_1,ACTIVATION_KEY_2

Check how to add another domain to your license.

Modules use

Run the index at the end of the import process

The indexes may need to be updated after importing data.

You can define the post process action in your profile settings from:
SystemData TransferMass PRODUCT IMPORT & Update

You can decide to run the indexers after the import or not:

No
No indexer will run. You will have to reindex manually from the CLI
Only the required indexers
Automatically decides which indexers must run
Only the selected indexers
You decide which indexers to run.
For example:
catalog_product_pricecataloginventory_stockcatalog_url

Use regular expression in the file names

If you want to use several files with the same structure to import your products without having to create several profiles (one for each file), then you can use regular expression in the file name.

Instead of a unique name in the file path, you can use a regular expression that will make the file dynamic.

For example:
products_update_[0-9].csv

That expression will take into account all files starting with "products_update_" followed by a number between 0 and 9 and ending with ".csv".

The profile will then run all the corresponding files one by one.

Cron task interval

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:
SystemData TransferMass Product Import & 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:
SToresSettingsConfigurationWyomindMass Product Import & UpdateSettings
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.

Replace values in an import profile

Mass Product Import & Update allows you to replace some values in the output data.

For example, in your source file, the manufacturer name is Wyomind but you need to have The Wyomind Company. Then you can easily replace it using the replacement rules such as in the below example.

See more about how to use replacement rules.

Use different attributes and attribute values in the same column

You want to import several products into your Magento back-office but in your source file, you're using different attributes and values in a same column.

For example: length and width.

You can use the dynamic attribute with the following syntax:
attribute_code=value

And then map the column with the dynamic attribute.

You also have the possibility to use PHP scripts to link values coming from different columns.

Define the path to the products of your XML source file

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

The paths to the nodes and values are based on XPath. For more information on the syntax to use, see the following documentation: https://www.w3schools.com/xml/xpath_syntax.asp

Define the path to the products of your JSON source file

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

We use the JSONPath syntax from the SoftCreateR project. For more information, see the next page: https://github.com/SoftCreatR/JSONPath

Define a predefined structure for your XML source files

When the structure of your XML file is quite complex, the info may be dispatched in deep nodes and sometimes in tag attributes.

Then, you can define your own file structure.

Below is an example of a complex XML file where you need a predefined structure:

<offers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1">
 <offer price="165.07" msrp="189.00" availability="3">
  <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>
  <attributes>
   <attibute name="sku"><![CDATA[XYZ]]></attibute>
   <attibute name="ean"><![CDATA[123456789]]></attibute>
   <attibute name="tax"><![CDATA[VAT 20%]]></attibute>
  </attributes>
 </offer>
</offers>

The predefined structure you need to use is:

{ 
 "sku":"attributes/attribute[@name='sku']",
 "ean":"attributes/attribute[@name='ean']",
 "price":"@price",
 "msrp":"@msrp",
 "tax":"attributes/attribute[@name='tax']",
 "name":"name",
 "description":"description",
 "category_1":"categories/category[1]",
 "category_2":"categories/category[2]",
 "category_3":"categories/category[3]",
 "image_1":"images/img[1]/@url",
 "image_2":"images/img[2]/@url"
}

The paths to the nodes and values are based on XPath. For more information on the syntax to use, see the following documentation: https://www.w3schools.com/xml/xpath_syntax.asp

Define a predefined structure for your JSON source files

When the structure of your JSON file is quite complex, the info may be dispatched in deep nodes and sometimes in tag attributes.

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"
}

We use the JSONPath syntax from the SoftCreateR project. For more information, see the next page: https://github.com/SoftCreatR/JSONPath

Configuration of a file stored in Dropbox

Mass Product Import & Update allows you to use files (for example XML or CSV) from your Dropbox.

Here is how to configure your profile for a file stored in your dropbox from the Settings part:

In File location, select Dropbox.
Fill the Path to file field with the file path relative to the root directory of your Dropbox container.

For example : /import/xml
Configure your Dropbox app to allow the Full Dropbox.

For example:

Multi-language data update and import

You can use the Mass Product Import & Update extension to import and/or update your data even if you're managing a multi-language Magento 2 store.

For example, to update the description of your products for your French store view, you can select only the corresponding store view from the Column Mapping section.

Note that you can add as many mapping row as there are languages. For example:

Troubleshooting

Base table or view not found

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

You will be able to fix it by following these steps:

Access your database via your control panel (Phpmyadmin for example).
From the setup_module table, delete the entry Wyomind_extension.
Be careful, that entry depends on your extension. For example, if you have the extension called Simple Google Shopping, you should delete Wyomind_SimpleGoogleShopping.
Logout from your Magento 2 admin.
Log into your Magento 2 admin.

Scheduled tasks don't work in Magento^® 2

How do cron tasks work?

The cron.php file (available in the pub directory of your Magento 2 root directory) is regularly launched from your server side (generally every 5 minutes).
The cron task for Mass Product Import & Update is targeted and evaluates if a data feed or a profile needs to be refreshed (depending on the timestamp stored in the database and on the schedule table for this specific profile).
If the above condition matches, then the data feed and the profile is re-generated.

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:
StoresSettingsConfigurationWyomindMass Product Import & Update

For more information on the configuration of cron tasks in Magento 2, you can check their documentation.

Unable to list current working directory

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.

Import process fails with "Asymmetric transaction commit"

Basically, an Asymmetric transaction commit means you're trying to execute a query in which a constraint based on a foreign key fails.

For example, if you're trying to add a related product that doesn't exist to another product, then the constraint will fail and the import will fail as well.

The best way to know which constraint fails is to run the import from the CLI and the SQL error will display.

Magento 2 Compatibility

Magento 2^® Open Source

2.0
2.0
2.0.1
2.0.1
2.0.2
2.0.2
2.0.3
2.0.3
2.0.4
2.0.4
2.0.5
2.0.5
2.0.6
2.0.6
2.0.7
2.0.7
2.0.8
2.0.8
2.0.9
2.0.9
2.0.10
2.0.10
2.0.11
2.0.11
2.0.12
2.0.12
2.0.13
2.0.13
2.0.14
2.0.14
2.0.15
2.0.15
2.0.16
2.0.16
2.0.17
2.0.17
2.0.18
2.0.18
2.1
2.1
2.1.1
2.1.1
2.1.2
2.1.2
2.1.3
2.1.3
2.1.4
2.1.4
2.1.5
2.1.5
2.1.6
2.1.6
2.1.7
2.1.7
2.1.8
2.1.8
2.1.9
2.1.9
2.1.10
2.1.10
2.1.11
2.1.11
2.1.12
2.1.12
2.1.13
2.1.13
2.1.14
2.1.14
2.1.15
2.1.15
2.1.16
2.1.16
2.1.17
2.1.17
2.1.18
2.1.18
2.2
2.2
2.2.1
2.2.1
2.2.2
2.2.2
2.2.3
2.2.3
2.2.4
2.2.4
2.2.5
2.2.5
2.2.6
2.2.6
2.2.7
2.2.7
2.2.8
2.2.8
2.2.9
2.2.9
2.2.10
2.2.10
2.2.11
2.2.11
2.3
2.3
2.3.1
2.3.1
2.3.2
2.3.2
2.3.3
2.3.3
2.3.4
2.3.4
2.3.5
2.3.5
2.3.6
2.3.6
2.3.7
2.3.7
2.4
2.4
2.4.1
2.4.1
2.4.2
2.4.2
2.4.3
2.4.3
2.4.4
2.4.4
2.4.5
2.4.6
2.4.7

Magento 2^® Adobe Commerce

2.0
2.0
2.0.1
2.0.1
2.0.2
2.0.2
2.0.3
2.0.3
2.0.4
2.0.4
2.0.5
2.0.5
2.0.6
2.0.6
2.0.7
2.0.7
2.0.8
2.0.8
2.0.9
2.0.9
2.0.10
2.0.10
2.0.11
2.0.11
2.0.12
2.0.12
2.0.13
2.0.13
2.0.14
2.0.14
2.0.15
2.0.15
2.0.16
2.0.16
2.0.17
2.0.17
2.0.18
2.0.18
2.1
2.1
2.1.1
2.1.1
2.1.2
2.1.2
2.1.3
2.1.3
2.1.4
2.1.4
2.1.5
2.1.5
2.1.6
2.1.6
2.1.7
2.1.7
2.1.8
2.1.8
2.1.9
2.1.9
2.1.10
2.1.10
2.1.11
2.1.11
2.1.12
2.1.12
2.1.13
2.1.13
2.1.14
2.1.14
2.1.15
2.1.15
2.1.16
2.1.16
2.1.17
2.1.17
2.1.18
2.1.18
2.2
2.2
2.2.1
2.2.1
2.2.2
2.2.2
2.2.3
2.2.3
2.2.4
2.2.4
2.2.5
2.2.5
2.2.6
2.2.6
2.2.7
2.2.7
2.2.8
2.2.8
2.2.9
2.2.9
2.2.10
2.2.10
2.2.11
2.2.11
2.3
2.3
2.3.1
2.3.1
2.3.2
2.3.2
2.3.3
2.3.3
2.3.4
2.3.4
2.3.5
2.3.5
2.3.6
2.3.6
2.3.7
2.3.7
2.4
2.4
2.4.1
2.4.1
2.4.2
2.4.2
2.4.3
2.4.3
2.4.4
2.4.4
2.4.5
2.4.6
2.4.7

User's reviews

Log into your account to leave your review and get up to 3 months of free Support & Upgrade.

16th July 2024

spectacular extension
I've been using it for several years and have always managed to do everything I needed from here
Niik - Merchant - User for more than 4 years |Magento 2https://www.niik.it

4th June 2024

Must Have!!
This is a must have for any business that runs automation with large or small feeds. So easy to use. We have run different ones in the past that did not work as good as this one. We were so happy when we found this extension. I would highly suggest the Mass product import & update for anyone that updates frequently.
JD Auto & Truck - Merchant - User for more than 3 years |Magento 2

15th April 2024

Pretty Happy
we are very happy with this extension. We have been using the extension for a number of years now and import our products as prizes. We have various imports, both small and large. I will recommend this extension to everyone!
Erik - Merchant - User for more than 6 years |Magento 2

25th September 2023

Very flexible and compatible with custom scripts
We are using Mass Product Import & Update for over 2 years now and it is very flexible when using custom scripts etc to import products from different profiles. It gives more opportunities to implement products with various pricing margins and categories to different stores (very helpful when using multi-stores).
Henri - Merchant - User for more than 3 years |Magento 2https://www.baumarket.ee/

17th April 2023

Best solution on the market
I was using Wyomind Mass Product Import & Update for few years and I can tell that this is a life saver when comes to import and update products at Magento!
Artur - Developer - User for more than 6 years |Magento 1|Magento 2

8th December 2022

Great flexible extension, with excellent support
We are using Wyomind Mass Product Import & Update for two years now, and we are very satisfied with the extension and the support. They help quickly, polite and with quality fixes. We would recommend Wyomind to anyone.
Rolf - Developer - User for more than 3 years |Magento 2

11th September 2022

Very useful application for store automation
I bought the Mass Product Import & Update extension as I needed to import products to my website daily from feeds provided by the various distributors. We work with about 60,000 products with various distributors this tool helped us to have updated stocks with few errors.
Armindo Soares - Merchant - User for more than 2 years |Magento 2http://www.micro-chip.pt

11th September 2022

Best Import App on the market
Best import app and supporting documentation on the market and very good support provided.
Tom - Ecommerce Agency - User for more than 3 years |Magento 2

30th August 2022

The Mass Product Import & Update is a MUST HAVE for any Magento website
we have been using the The Wyomind Mass Product Import & Update foe the past 9 months and must say that is saved us lots of time . we have 500000 sku and run update every day and no issues. support questions are answered quickly . The Mass Product Import & Update is a MUST HAVE for any Magento website !!!!!
Mike - Merchant - User for more than 3 years |Magento 2

22nd July 2022

MSI do the job, Importing process and mapping system
my experience is 2 website on same machine, the first website; 4.000 products (Configurable and Simple) second 110.000 products (Simple products) in any case, it can manage both. Time for sync proliant G8 dual Xeon 32gb ram dedicaded. 4.000 products: about 3 minutes. If you have already update images is a dream machine. 100.000 products: not easy to config, time to execute 4/5 hours. be carefull to Elasticsearch issues, if it fail the process looping and you have to work for let it run flawless. you need a good skill in Magento and Linux system, moving thry logs and fixes. the support is ok.
Snefru - Developer - User for more than 2 years |Magento 2https://www.ubby.it/

14th July 2022

Helpful and eficient extension
I bought the extension Mass Product Import & Update as I needed to import products to my website daily from a feed that a large distributor provides me. The support was impeccable and the extension does exactly what it sets out to do.
Fernando - Merchant - User for more than 3 years |Magento 2http://fernandoswinehouse.pt/

8th July 2022

simple - fast - flexible
We found evrything we want on this extension. we have about 30 xml from diffrenet vendors and about 150.000 products udated daily with out any problem Its real fast and flexible
dgiouz - Developer - User for more than 5 years |Magento 1|Magento 2https://pairno.gr/

18th June 2022

great extension that is used a lot on a daily basis
The extension is widely used here for daily stock import, but also for new items. However, the manual could have been a bit more extensive and especially the php api
Jur - Merchant - User for more than 6 years |Magento 2https://www.decofeelings.nl/

14th March 2022

Great tool to handle product imports
We were looking for a tool that could allow us to handle stock updates and new product imports, witout creating mess with the magento 2 installations. This tool from wyomind, although not super immediate to configure, has done the job, also thanks to the super assistance by their support team
Fabio - Merchant - User for more than 3 years |Magento 2https://50-ml.it/

16th January 2022

Simple and great
5 STARS on what they promise as it works 100% Excellent solution with many features.
Eva - Developer - User for more than 3 years |Magento 1

13th December 2021

great product to import live feeds from supplier
We needed an extension that we could import live feeds from our supplier so we could easily import the products in one go. Wyomind - Mass Product Import & Update does that. It imports categories and products from FTP, URL or Dropbox in CSV XML or JSON Formats.
ben - Merchant - User for more than 3 years |Magento 2https://magento-726363-2422618.cloudwaysapps.com/

28th October 2021

Le module ultime de Magento pour un Ecommerce
Je pense que le module Data feed Manager et celui ci sont les modules les plus important de Magento 2 ! On peut vraiment tout faire avec les 2 combinés. Merci à Wyomind pour ces modules exceptionnels
Nicolas - Ecommerce Agency - User for more than 6 years |Magento 1|Magento 2https://www.jouet-plus.com/

19th October 2021

Very helpful extension
Rich in features but a bit complicated. It is need some technical knowledge to deal with it. Very helpful customer service team (they even provide technical support and assistance after the end of the technical support period). Thank Wyomind Team
Muhammad - Merchant - User for more than 4 years |Magento 2https://pureherb.com/

8th September 2021

excellent product import export solution for Magento
By far the best solution we tried which is directly incorporated into magento. There is one other solution that is desktop based and is excellent aswell. But as far as this one goes it's really by far the most flexible one that allows to incorporate your own scripts into the process directly. No match out there. If you have this solution no need for anything else to keep your products and stock up to date.
100webseiten - Ecommerce Agency - User for more than 3 years |Magento 2https://100webseiten.ch/

30th August 2021

The most user friendly solution for automatically importing products
This module is perfect for us because we have multiple suppliers and Mass Product Update and Import allows us to easily duplicate an existing profile and make the necessary changes. The fact that you can use PHP to manipulate the data straight from the Admin Panel is absolutely amazing.
Qonnecto - Developer - User for more than 3 years |Magento 2https://qonnecto.nl/

6th July 2021

The best feed extension out there!
We're using this extension on every single Magento website we have and saves us a lot of time! The support is top notch and happy to assist every single time fast and efficiently! Would recommend with no hesitation!
The French Furniture Shop - Merchant - User for more than 5 years |Magento 2https://casagoda.com/

30th May 2021

Great extension with a great service and features
I have been using this extensions for more than 6 months and this extension is simply great and the features provided in the extension are very good. Support of the extension is great and team is highly responsive and always tends to provide the solution. I highly recommend this extension to everyone if they are looking forward to do a frequent product import. Extension is highly configurable and you can achieve almost all of your requirements by tweaking the settings in the admin panel
Ahmadi - Merchant - User for more than 4 years |Magento 2https://vitameen.shop/

15th April 2021

It's perfect as we wanted
Loved this extension , The extension offers number of options to execute your own demands. Like :- - Number of file support to import products. - Mapping of fields is really great , you organise in proper way if there there is so many fields to import. - Best thing s is you add your own script as well to for every field , like in my case I needed to store LxWxH in one custom attribute and it was possible only because of custom script option provided by extension.
Rahul Chhlotre - Developer - User for more than 4 years |Magento 2https://oldchevytrux.com/

24th March 2021

Saves a lot of time and great support!
The extension offers many possibilities to customize it as we like to suite our needs and when we need to something additional the support is very helpful and proactive. Great extension with awesome support.
Michal - Merchant - User for more than 4 years |Magento 2https://gear-up.me/

25th February 2021

Work as is, fast and stable
Everyting works as described. Easy to use, fast and stable. But the most of all worths support we get from wyomind for every question we got! Reply comes back faster than we ask! i sugest working with wyomind.
webo2 - Ecommerce Agency - User for more than 5 years |Magento 1|Magento 2https://pairno.gr/

23rd February 2021

Excellent basis for individual product import processes
We have been using this extension for several years and it runs absolutely flawlessly. We run our online store in several languages and for this the extension is perfectly suitable. The support was very quick to respond to our questions.
Roman - Ecommerce Agency - User for more than 3 years |Magento 1

19th February 2021

Mass Product Import & Update Works Great
We use this plugin to import products from a CSV file generated by our POS into our online store. We wouldn't have been able to do this without this plugin, thanks!
Stan - Developer - User for more than 5 years |Magento 2

10th February 2021

We're using Wyomind for all imports
This is the best and most advanced plugin to make custom imports in Magento 2. We're using it for a serval customers and almost nothing is impossible. We'll keep using it in future projects, we will recommend everyone who need to import products to use Wyomind
Laurens - Ecommerce Agency - User for more than 6 years |Magento 1|Magento 2https://www.carpartsonline.shop/

8th February 2021

Excellent
This is a good and steady module few issues and if there was a issue It was fixed quite quick. Will recommend this 5/5
Yohan - Merchant - User for more than 5 years |Magento 2

4th February 2021

Did recieve support and customization on the mass product import extention
Response time between question and time to develop the items was quick and professional. Also did result in an import of an XML-file correctly to a new magento site. Very happy with the result. Als now working on the second import and will depend on the same type of co-operation. Jarda Prochazka
Jarda Prochazka - Developer - User for more than 4 years |Magento 2

4th February 2021

Good and steady
This is a good and steady module few issues and if there was a issue It was fixed quite quick. Will recommend this 5/5
Roar - Developer - User for more than 5 months |Magento 2

1st February 2021

Great Extension and Support
The Mass Product Import & Update extension has been an absolute game changer for us. We are using it to connect to our PIM which means that our product info is able to be consistent across all of our systems. It allows us to run the export/import of data on a regular schedule as well as trigger it to run on our own when we need a quick update. This has made our site way easier for our non-technical team members to manage and saved us the time and money of creating a custom solution. The Wyomind team has been super responsive and supportive when we need help as well.
Val - Developer https://store.mipinc.info/

29th January 2021

Great extensión!!
The extension is very good, it is very easy to configure. Field mapping for import is very intuitive and requires no technical knowledge to do it. They should improve the management of licenses and the configuration of the different work environments from the web. Very satisfied with the extension.
Nico - Developer - User for more than 4 years |Magento 2

29th January 2021

Excellent support
The code and support are excellent!
Grow ecommerce - Ecommerce Agency |Magento 1|Magento 2https://www.growecommerce.uy/

11th January 2021

Great extension
wyomind doing great job for product imports. we have more than 60K products and we schedule both imports and updates with separate profiles... Now this module made life easier. No touch to system, but system making scheduled imports and updates... Both xml and csv imports are available and also configurable import PAIN finished for us. Thanks a alot for this great extension I highly recommend...
Svas - Developer - User for more than 4 years |Magento 2https://pricedeals24.com/

18th December 2020

Awesome
I'm verry happy with this product. It's verry Awesome
EricJan - Ecommerce Agency - User for more than 6 years |Magento 2

2nd December 2020

Great Data Feed Option
We used the Data Feed module to update our website from our EPOS system. It it hugely flexible and far easier to use than the standard Magento import/export routines. Would highly recommend for anybody who doesn't want to have to manually update their store stock levels.
Simon - Merchant - User for more than 6 years |Magento 2

18th November 2020

The best extension to import product
This is the best extension to import product. Easy, fast, with a good mapping scheme. Great works !!!
Antonello Rossi - Ecommerce Agency - User for more than 5 years |Magento 2

10th November 2020

Very easy to use
The import module is very easy to use and we have feeds that get updated daily...
John - Developer - User for more than 5 years |Magento 1|Magento 2

10th November 2020

Great extension and superb support
The extension works as described, but the support was truly outstanding. All questions and problems were usually solved within the hour. I needed a little help in the beginning, but now this extension is running smoothly without any problems at all.
Tolli Birgisson - Merchant - User for more than 4 years |Magento 2

5th November 2020

Great way to load tons of products, very flexible
I tried a number of modules to get our massive inventory loaded (400k skus). This one goes straight to SQL, so it is much faster than any that use the Magento objects to load them - I could load all 400k products in an hour when they were all simple products. It also handles a lot of variety - I can load simple products and have it create configurable parent products, have a separate profile to load relations for the products, etc. All of these options do slow it down, but it is still workable.
TravRay - Developer - User for more than 4 years |Magento 2

22nd October 2020

Great Extension and Awesome Support!!!
Great product work as expected easy to install. User friendly Interface to import and export CSV/XML file. Feature is great easy to map the columns . It is saving lot of time to update /Add records . Great and quick support!
Nirmal Singh - Developer - User for more than 5 years |Magento 2https://shop.schandpublishing.com/

22nd October 2020

Very usefull
Great extension . Very usefull.
Shadow - Developer - User for more than 5 years |Magento 2

21st October 2020

Great extension!
This extension helps a lot with the import and export, that is not easy at all to manage just with the standard Magento feature. Great works!
B. R. - Developer - User for more than 4 years |Magento 1https://ittweb.net/en

19th October 2020

Great extension that works as expected
This extension was easy to install and worked as expected out of the box. It has been a quick csv processing workhorse for us for 1+ years. Though rarely needed, Wyomind support is phenomenal. While many of the other extension providers tend to pass the buck and blame other extensions or your theme or play the language barrier game, Wyomind provides quick answers and solutions. Definitely recommended!
AlexJ - Merchant - User for more than 6 years |Magento 1|Magento 2https://www.three-rooker.com

14th October 2020

Streamlined our import
We have been using this extension on our site for a while now and its a much welcomed improvement to the default Magento import tool. We import a large number of products and this has dramatically reduced the amount of time spent manipulating CSVs. Would definitely recommend!
Tom - Developer - User for more than 5 years |Magento 2https://www.chevincycles.com/

8th September 2020

Great extension
We have been using this module for a long time on several magento versions, none of them had a problem. The extension solved many problems related to the import of products and their updating. We are able to quickly introduce the offer of other wholesalers to our store and update its stocks and prices without any problems. We update our product offer easily and quickly from our ERP system via XML file. Everything is simple and transparent.
Marema - Developer - User for more than 5 years |Magento 2

28th August 2020

Recommended
This Extension solved our problem for mas product Mapping of attributes
Kim - Ecommerce Agency - User for more than 5 years |Magento 2

10th August 2020

It's flexibility makes it a great time saver.
The module is very useful and the support is fast.
Filip - Developer - User for more than 4 years |Magento 2https://belotehna.co.rs/

29th July 2020

If you have any external source of data which you need to pull in and update your catalogue this plugin is must-have.
We have been using this plugin to pull data from our supplier and update catalogue, around 12.000 entries. After set up cron tasks are executed in the background so no manual action is required.
Wojciech - Developer - User for more than 6 years |Magento 2https://pimdesign.com/

21st July 2020

Fantastic and Super fast Import
I am so happy that I choose this extension over other Expensive competitors, since this Magen2 Bulk Import extensions makes my daily routine import a breeze. Easy to map and create a profile once, and then enjoy it. We have M2E Pro for selling on Multi Channels like Amazon and eBay and Walmart. Some other tools we tested were not compatible with them, however this Import from Wyomind is fully compatible and MSI - ready which makes the managing stocks as easy as it can be. Also just for statistics: For importing about 40,000 SKUs, it takes about - 5 minutes in our case, which has 15 attributes (price, dropdown, yes/no, etc...). Also for our secondary import profile we have 26,000 matching SKUs, out of import file that has about 150,000 product line (we skip non-relevant products), and this import profile runs about 2 mins. cannot be more excited to and use it every day. Great job, and for sure I recommend anyone using Magento 2!
Mark B. - User for more than 4 years |Magento 2

6th July 2020

Excellent module with great support
This module works out of the box to help you manage/update larger catalogs. Proactive support and the best update extension in the market.
Guru - Ecommerce Agency - User for more than 5 years |Magento 2https://berik.eu/

1st July 2020

Great and quick support
Wyomind has always been great at answering our questions and helping us pick the right module. Their support is great and they are very helpful with installing and keeping the the moduls running.
Alexander Paulusson - Merchant - User for more than 5 years |Magento 2http://www.dronarbutiken.se/

4th June 2020

Best Module out there!
Since I became aware of wyomind, I always try to use one of their modules first, if there is one for my current project. It started with google simple shopping. Then a long time passed and then I came across wyomind again when I needed modules for the article import and the order export. And the experiences I made then led to the fact that I now look here first to see if something is available for my current goal. The support is simply outstanding. I don't think I have ever waited longer than 1 hour for an answer. And even more important: No matter who answers you from the support team, everyone is obviously very competent in their extensions on a technical level. Up to now I always had the feeling to communicate with a technician and not with a sales person. For me this makes a big difference to other developer studios. If I may make a wish: Please develop a mega menu and a OneStepCheckout. I would change immediately! :D
matzeelis - Developer http://www.m-michaelis.de

5th May 2020

Works great out of the box
Great extension. The support reacted fast on questions from my side
Roman - Marketing Agency - User for more than 6 years |Magento 1

5th April 2020

Keep Up the Good Work!
Import-export extension it's just the best we win a lot of time we upload 3000 products in minutes with no problems we are steel using the extension for a lot of mass action work... The support as always was excellent with a very very fast reply Awesome extensions! the best support! highly recommended.... Thank you wyomind Keep Up the Good Work!
Mousas - Ecommerce Agency - User for more than 5 years |Magento 2https://www.mousasgallery.com/

11th March 2020

Great module to do easy mass changes to our catalog
We use this for all mass changes to our catalog as well as for new products. Sometimes a little tricky to get it right but most of the time it is very easy - even for me that is just a merchant. We also use it for updating stocks through CSV files from a third party ERP system. Importing new items is quite easy as we have done many mass imports with 2000+ sku's.
Roar Johansen - Merchant - User for more than 5 months |Magento 2https://takrails.no/

24th January 2020

Perfect module for larger webshop
We were looking for a module to handle large files with new products and product updates that I found here. After importing the module and testing the module on test environment, I was impressed with the import speed and how seamlessly it all ran. There have been no problems so far. It would be nice if the module could handle Json. :-)
Paheha - Merchant - User for more than 4 years |Magento 1https://www.konpap.dk/

3rd January 2020

Excellent module for synchronization with management software
I have been using this extension for more than 6 months, to communicate my management software with Magento. I must say it is an excellent product.
DS-Marco - User for more than 5 years |Magento 1

13th December 2019

Must have extension if running a bigger community shop
Its been 1 year using this extension in Magento V2 and highly satisfied with the extension so far. We have 100,000 of products that's been imported and updated daily and wyomind does a fantastic job here.
Sweta - Merchant - User for more than 5 years |Magento 2https://www.arlen-ness.eu

20th November 2019

Great Extension - Everything is fast
It makes uploading products very fast and in a consistent way.
Martino Marco Del Vecchio - Merchant - User for more than 6 years |Magento 2https://sportnetit.com/

20th November 2019

Great Extension Overall - Fast uploading products
We cut so much time and costs by using the product import and update. We can bulk upload many products in just a few minutes.
Armandod - Merchant - User for more than 6 years |Magento 2https://sportnetit.com/

13th November 2019

Extrêmement pratique pour mettre à jour les produits du catalogue en masse
Simple d'utilisation et facile à mettre à jour.
Charly - User for more than 6 years |Magento 1|Magento 2

11th November 2019

Get your product base done
The module Mass Product Import and Update from wyomind is very helpful. We have a tremendous number of products and the module helps to get fast on this organization. The simplicity of excel usage, gets super fast the update of products.
Henri - Merchant - User for more than 6 years |Magento 1https://www.seoze.com/

27th October 2019

Great tool for product imports with fuld custom options
We are using the Mass Product Import & Update extension for mass importing products from ftp server. This extension is a great relief for our staffs since we have more than 10000 SKUs. In addition a big plus is a reasonable price which does not depend on SKU counts. The team has offer very quick supports and setup services for our website serveral times and always solve the problems. Would highly recommend if you're using ftp.
Laura - User for more than 5 years |Magento 2

24th October 2019

Good extensions with the best support
We were looking for a secure, agile way to get an automated daily catalog update and a scheduled sales exportation. Wyomind got the job done with 2 affordable but full-fledged extensions that allow for thousands of updates in no time, as well as sending sells in a reliable way. Furthermore, Wyomind support helped us a lot to patiently address the typical early days issues.
Silvia Suria Torres - Ecommerce Agency - User for more than 6 years |Magento 1https://esencialsistemas.com/#

8th October 2019

Great extension for fast product imports
The Mass Product Import & Update extension offers great flexibility for importing products on mass. We've been building an e-commerce site that compiles multiple sites into one. This meant we needed to import data from multiple sites using multiple platforms. Mass Product Import & Update really streamlined the process of importing the huge range of products. Would highly recommend if you're looking to bring in products into Magento from other platforms.
LMD Design - User for more than 5 years

5th October 2019

Verry good and clear module
The module updates the stocks daily here. This is quick and well-arranged. However, when importing new products I ran into a bug. The module first updated and the bug was gone. Unfortunately a new bug has been added that now needs to be fixed. I can't adjusted the fields anymore in the latest version. Also the stock is not updated anymore.
Andre - Merchant - User for more than 6 years |Magento 2https://www.decofeelings.nl/

5th October 2019

It makes life easier t work and saves huge amount of time
This extension is a life saver for businesses need to update their stock or retrieve data from other websites. Highly recommended.
Amed - Merchant - User for more than 6 years |Magento 2https://www.glossyfashionista.com

6th August 2019

Mass Product Import
Beside the issue with images, they fix the problems quickly and efficiently. Program is efficient with updating products.
Brad - User for more than 5 years |Magento 2

2nd August 2019

Great plugin overall. Worked perfectly and simplified our uploads
Great plugin overall. Worked perfectly and simplified our uploads. Never contacted support in 1 year using it. Always good
Armando - Merchant - User for more than 6 years |Magento 2http://sportnetit.com

16th July 2019

Great module and very good support!
The module is perfect for importing product data. The best import solution for magento.
Artur - User for more than 6 years |Magento 1|Magento 2

27th June 2019

Easy to use - Awesome support
The tool was very easy to use, the PHP script functionality enables users to put in custom logic which makes the tool very flexible to use. Also, the Wyomind support team is awesome, Paul, Pierre and Laurie are very quick to respond and are super helpful.
Sim - User for more than 5 years |Magento 2

21st June 2019

Fantastic product with great support!
Our shop has nearly 50,000 products. The tool works very fast and reliable. The operation is very simple and well customizable. The support is awesome and highly professional. Thanks for all!
Josko - User for more than 5 years |Magento 2

16th June 2019

Long searched, finally found!
Actually, it seems an easy task to use csv files and Magento 2 to import the products. But if you want to do this automatically without the Enterprise Edition, you will quickly come up against limits. There are many providers for such a module, but none offers this quality and flexibility. Thanks for this module. :)
Daniel M. - Merchant - User for more than 5 years |Magento 2https://sachsersatzteile.de/

16th June 2019

Terriblement efficace!
Le module est extrêmement complet. Il faut passer un peu de temps pour découvrir les nombreuses fonctionnalités. En cas de difficulté, le support est toujours la pour donner un coup de main. Après avoir créé notre profil. Nous avons réussi à importer 13000 produits en un clic!!! Terriblement efficace!
Alexandre - Merchant - User for more than 5 years |Magento 1

15th June 2019

Great extension!
It is a great extension. Simple and flexible, it allows you to import large quantity of items quickly. With an excellent technical support, able to solve any problem or doubt that arises quickly and effectively. I definitely recommend it.
Federico Cassinelli - User for more than 6 years |Magento 2https://www.fcsistemas.com.ar/

23rd May 2019

great module!
It works fine and have great support!
altravista - User for more than 6 years |Magento 2

23rd May 2019

Certainly recommended
the module has several functions and allows you to import both csv and xml files. Support is fast and competent. Certainly recommended for those who need to import complex sources for catalogue products! You can also schedule import
virtus - Merchant - User for more than 6 years |Magento 2https://www.ristormarkt.it/

15th May 2019

Professional support and excelent component
As someone new to Magento development it was important that we find component for import that will be flexible for our various needs. Although we couldn't cover everything support team has gone above and beyond to guide us and help us achieve our goal. In the end as we learned more about component we can only say: Excellent work! One can see that you have thought of every little thing. To everyone who is looking for component to import products to Magento we highly recommend Wyomind :)
Ivan - Merchant - User for more than 5 years |Magento 2https://shop.mm-informatika.com/

9th May 2019

Excellent tool, has saved us lots of time and money and the best support of any magento extension ever
We were going to develop our own import type extension for our website and then I found this on Wyomind, we had already used the simple Google shopping which was excellent too. This extension is well worth the money, first of all it works which is brilliant :) but the the support speed is 2nd to none. You can pretty much guarantee an immediate response and it always end up with things being solved... FAST Thanks Wyomind for your hard work and great offerings
Rob Hepworth - Merchant - User for more than 6 years |Magento 2https://www.procurve.co.uk/

8th May 2019

Fantastic product - Amazing support!
We run several Magento websites, mixed across M1 and M2 and have been dealt with many extension developers over the years. Sadly, most will promise the world, then leave you high and dry when it comes to actual support - wasting days of your time with excuses and no real support until you give up. @ Wyomind, we found the complete opposite! These guys are on top of their game, solving complex issues on our end, usually within a few hours. Often replying outside of their published support hours. We plan on using Wyomind extensions to solve our needs whenever possible as they have offered the best support we have experienced by far...
Ajar - Ecommerce Agency - User for more than 6 years |Magento 1|Magento 2http://www.tieguys.com/

19th March 2019

great module to easily create configurable products
After some investigation it seems this module is the best way to create configurable products for our store. It is easy to setup with great functionality and great support, the module saved us a lot of time. All questions about the extension were answered promptly.
boxingroyale - Merchant - User for more than 5 years |Magento 2https://www.12game.com/en/

1st March 2019

Perfect support and communication
Paul, Pierre and Laurie give a excellent support en great communication, They helped to setup a difficult import configuration with great succes. Have ordered 3 times an extension. Thanks for the good support.
Mediameta - Merchant - User for more than 5 years |Magento 2https://www.klinkenbergschoenen.com/

25th February 2019

Easy tool for keeping my site updated
I have more than 7,000 dental products on my site, with Mass Product Import & Update I am able to update, prices, images and info in less than 5 minutes. This has really been a game changer for me. Highly recommended
Fernando - Merchant - User for more than 6 years |Magento 2https://www.midepositodental.com/

22nd February 2019

Rapport qualité prix imbattable
J'ai acheté le module Mass Product Import and Update de chez Wyomind pour les utiliser sur nos deux sites. Grâce au support efficace de l'équipe auprès de mes développeurs, nous disposons d'un outil ultra simple, rapide et fiable pour la mise à jour et les ajouts à faire à notre catalogue. Quel que soit le volume de produit à traiter, l'outil reste fiable.
Quentin Vignon - Merchant - User for more than 6 years |Magento 1|Magento 2https://www.petitbailly.com/

20th February 2019

A must have extension
This extension is essential for large stores and Wyomind is a trusted Magento 2 developer. There are more expensive alternatives but Wyomind Import Extension is delivering us the best result with the lowest cost.
Hossein - User for more than 6 years |Magento 2

6th February 2019

Amazing Company
I buy the Import Module, its an amazing module and when i ask for support they answer me in seconds with the things i need, and updates for the module. I recommend the modules and Wyomind 100%
Manuel Mattar - Merchant - User for more than 6 years |Magento 2http://wolfsellers.com/

21st January 2019

Excellent code
The code is very clear.
Javier - Developer |Magento 1|Magento 2

11th January 2019

Great Extension! Easy to setup and use!
This extension from Wyomind is great! It super easy to setup and get your automated imports going! The support from Wyomind is also just as exceptional! Top work guys!
Josh - User for more than 6 years |Magento 1

10th January 2019

Perfect service!
The guys know what they do and help you always!
GoSoSo - Merchant - User for more than 6 years |Magento 2http://www.gososo.nl/

7th January 2019

Wyomind Support is excellent!
We bought Mass Product Import & Update extension for almost 1.5 years, Wyomind still offers support to us. It's a very great support for merchants. Their extension adding many useful features that help us save much of time for updating our inventory. We think it’s a must extension for Magento store.
Perry - User for more than 7 years |Magento 2

11th December 2018

very nice and usefull extension
very nice and use full extension. It`s must have extension if you want to deal with feeds and many products. It can import different types of files, Dropbox and others. You can add a google drive possibility. I have 2 of my suppliers that use this google drive storage.
Vlad Luncanu - User for more than 6 years |Magento 1|Magento 2https://maiaoutdoor.ro/

16th November 2018

excellent support and quick responses
The extension works perfect, by integrate the products and stock between our physical store and the webshop.
Hans - User for more than 6 years |Magento 2

12th November 2018

Great Extension
Once this is set up you just leave it - it works very well. The schedule is one of the very useful features. If there is an improvement for future, i could suggest adding 15 minute time intervals on schedule instead of 30 min, but apart from that no complaints.
GTurner - User for more than 6 years |Magento 1|Magento 2

19th October 2018

Great product
Did the job for us, managing 4 different external stock systems at our website.
Morten - User for more than 7 years |Magento 1

17th October 2018

Changed our business overnight
This module has enabled our business to expand the range of products offered to customers. The module was really easy to configure and bring on new feeds. Having the ability to match different feeds on different product attributes is what makes this module stand out from other providers.
Sean Wade - User for more than 6 years |Magento 1https://www.wetsuitcentre.co.uk/

13th September 2018

Great extension - very flexible
Good support as well. The guys know what they are talking about.
GTurner - User for more than 6 years |Magento 1|Magento 2

10th September 2018

Brilliant and need assistance to set up
We have bought this module to synchronise prices and stocks of more than 30 stores and 15 000 products. Il works but need assistance to set up and support too. So I advise to get support for any upgrade or new processes to set up. It worth since support resolves issue very fast. Regards Laurent
Laurent

27th August 2018

Fastest on the market
Works perfect now. Needed some support. Issue was resolved really fast.
Robert - User for more than 6 years |Magento 1https://www.mountainwalkers.com/

20th August 2018

You have mass of product? This is a must.
The module Mass Product Import & Update for Magento 1 from wyomind it's really a very good tool for stores that carry several sku's. Helps a lot the inventory management and all updates of product at once. We carry more than 70.000 skus and adding 5.000 each month. The module Mass Product Import & Update for Magento 1 from wyomind it's a must for all kind of stores in the same situation. We are happy with the support. We had few issues in the begin, but the team was very good to fix all.
l3b0u - User for more than 6 years |Magento 1https://www.seoze.com/

16th August 2018

Magmi for Shop Owners
Very straight forward installation. Worked straight out of the box. As a store owner who plugs and plays extensions with very little programming experience this is a very easy module to use. We deal in office supplies, so we have a quite large product file - 20,000 products. I eventually got to grips with Magmi for Magento 1 but so far am finding this much easier to use.
S Doyle - User for more than 6 years |Magento 2https://www.paperweight.ie/

7th August 2018

Very good, excellent support
Pierre and Paul have been great with all my questions. To be honest there has been a few hitches, and you do have to explain exactly to the support guys so they understand, then are great at sorting out issues.
Gt - User for more than 6 years |Magento 1|Magento 2

29th June 2018

Great import extension which can import BMEcat and ETIM files
I was looking for an extension which can handle BMEcat/ETIM xml files and I landed here. After some mail contacts with the support I've created a sample file with some data and started my tests in the online demo. The support here is very kind and replies really fast. I was surprised how fast they answer. After some issues which I could solve with some help from the support my import profile was ready to run. My import file had more than 25.000 products and I thought I will have some trouble because of the high number of products in the xml file. 15 minutes later all work was done: All categories were correctly created, all products landed in the correct categories and the product images appeared in the products. I am perfectly satisfied with this extension and I recommend it to everyone, who works with big files with a high amount of products. We will use this extension in the future to import some other BMEcat/ETIM xml files. The configuration and mapping is really easy and if you need some special stuff in your mapping, you can use plain php code, which is very helpful. So, my 5 stars are well-deserved.
D.Bachmann - User for more than 6 years |Magento 2https://shop.auplan.de

28th June 2018

Une extension magique
J'avais déjà tester la première version de ce module et je lui trouvais quelques lacunes. Et depuis quelques jours j'ai installé la version 3.1 et là je suis resté scotché. La version à terriblement évolué et permet maintenant de faire tout ce que l'on veut. La possibilité d’exécuter un script php en regard de chaque champ ouvre des perspectives infinies. Et toujours une qualité de support dont beaucoup devraient s'inspirer. Je travaille souvent le weekend et j'obtient des réponses aussi rapide qu'en semaine, le plus souvent sous quelques minutes..... Je sais pas comment ils font mais chapeau à toute l'équipe !
Thierry - User for more than 7 years |Magento 2

21st June 2018

Fast import and great support
We use this extension to import products from multiple vendors and it is working great. We have had some small bugs but the support is great! Would recommend this extension for everyone who needs to import multiple feeds.
Bart - User for more than 7 years |Magento 1|Magento 2

18th June 2018

we are extremely satisfied with this extension
Our company is extremely satisfied with this good extension and other extensions and the great tech support services by the Wyomind team.
eric - User for more than 6 years |Magento 2

7th June 2018

Great products, great support
Mass Product Import & Update is the second extension we have purchased from Wyomind and as before we are extremely satisfied with the purchase. All their extensions are very professionally developed and provide all the features needed to get the job done well as advertised. Not to mention their fantastic support that not only responds quickly, but is also willing to help with any issues and add features that are beneficial to the extension. Highly recommended.
Jesse - User for more than 7 years |Magento 2http://www.bokstijn.nl/

25th May 2018

the best Product data *& stop importing extension for Magento
I checked many modules, but this is the only one that support HTTP import from CSV generated via php in URL. Importing is very configurable, you can edit everything with filters. You can make own conditionals that will help meet any requirement. I use it for importing stock and product prices from my Dropshipper. This is the best way you can get your inventory and prices up-to-date. Extension is robust, configuration is easy, work out of box. You will not find better tool to constant importing datas from 3rd party sources. 5 stars
Tomek79 - User for more than 7 years |Magento 1https://dzieckoimy.pl

2nd May 2018

super import extension
This is de best magento 2 product import extension I found
Erik - User for more than 6 years |Magento 2http://www.wijzijnuwspecialist.nl

19th April 2018

perfect importer
most versatile importer i have seen so far and superb support!
Danel - User for more than 6 years |Magento 1|Magento 2

8th April 2018

Seems pretty good. COnfiguration is taking some time though...
Seems a very versatile extension, especially with the custom rules. However, I am having a few issues with my input data, in terms of the XML format I am using. Support initially stated that the extension did not support the XML format I was using. However, They do say that they have sorted this, with an upgraded version (v5.2.0) which hopefully will sort my problem.
GARTH TURNER - User for more than 6 years |Magento 1|Magento 2

23rd March 2018

Fantastic product and outstanding customer support!
This is a fantastic easy to use extension that works perfectly and is a huge time saver with it’s ability to map spreadsheets and schedule imports. We are extremely happy with the product and the support team’s customer service is second to none. It’s a big thumbs up all round from us thank you Wyomind!
Dynomodels - User for more than 6 years |Magento 2http://www.dynomodels.co.uk

15th March 2018

Incredible support and respect for the user
It is, in fact, the best tool we found, as well as pioneering. I am very satisfied with this extension because it's very useful for my store. I did have an issue with the format of my XML file, they worked quickly to resolve the issue. I am very happy with the support. Already planning on purchasing more extensions from Wyomind.
pkmarkets - User for more than 6 years |Magento 2http://www.loveplace.pl

5th October 2017

Very reactive and competent support team
The system of import works perfectly. The support team helped me understand the functioning and was very reactive on my requests. I am very satisfied of this extension and I recommend it. I will not hesitate to buy other extensions considering the competence of the support team.
Productions Imagix - User for more than 7 years |Magento 2http://www.imagix.fr

Changelog

master v11.0.8 released on 07/11/2024

master v11.0.7 released on 01/11/2024

master v11.0.6 released on 03/10/2024

master v11.0.5 released on 27/08/2024

master v11.0.4 released on 02/08/2024

master v11.0.3 released on 17/11/2023

Improvement

Optimize some of the module's queries to avoid updating database table rows if there is no data change

master v11.0.2 released on 03/10/2023

Compatibility

Magento 2.4+ compatibility for the cache purge feature

master v11.0.0 released on 07/07/2023

Initial release for the master version

legacy v10.0.0 released on 07/07/2023

Initial release for the legacy version

master v9.0.4 released on 19/05/2023

Bug fix

The price view for the bundle products was not updatable/importable

master v9.0.3 released on 11/05/2023

Compatibility

Compatibility with PHP v8.2

master v9.0.2 released on 22/03/2023

Compatibility

Compatibility with Magento v2.4.6 + PHP v8.2

master v9.0.1 released on 15/03/2023

Compatibility

Compatibility with Magento v2.4.6 + PHP v8.2

master v9.0.0 released on 22/02/2023

Compatibility with Magento v2.4.6

Compatibility with Php v8.1

master v8.13.3 released on 23/02/2023

Improvement

Fix the warning triggered by the trim() function if the value is empty

master v8.13.2 released on 12/12/2022

Improvement

Compatibility with PHP v8.1

master v8.13.1 released on 14/10/2022

Fixes

Fix the import of the bundle product options with identical label

master v8.13.0 released on 13/10/2022

Improvement

Execution time optimization for images import

master v8.12.0 released on 07/10/2022

Improvement of the dynamic attribute feature: dynamic attributes can now be mapped at storeview level

master v8.11.8 released on 16/09/2022

Bug fix for the updates of created_at and updated_at product fields

master v8.11.7 released on 16/09/2022

Improvement of the image import: the same image can be renamed as different destination images

master v8.11.6 released on 15/09/2022

Bug fix that prevent gift cards from being overridden when the import process runs

master v8.11.5 released on 07/09/2022

Bug fix for label images in case of empty label

master v8.11.4 released on 02/09/2022

Rollback patches for install/upgradeData that conflicts with some third-party modules (should be fixed in a coming version)

master v8.11.3 released on 26/08/2022

Replacement rules are executed by order of position

master v8.11.2 released on 25/08/2022

Fix the bundle import for Adobe Commerce edition

master v8.11.1 released on 24/08/2022

Fix the bundle import for Adobe Commerce edition

master v8.11.0 released on 05/08/2022

Ability to update any static attributes
Fix the bundle import for Adobe Commerce edition

master v8.10.3 released on 29/07/2022

Optimization in the image processing: size is only calculated if the "Download the image again if it has changed" option is activated

master v8.10.2 released on 19/07/2022

Minor fix on code

master v8.10.1 released on 19/07/2022

db_schema.xml and db_schema_whitelist.json

master v8.10.0 released on 01/07/2022

Use of db_schema

master v8.9.1 released on 23/06/2022

Fix for multiple dynamic attributes

master v8.9.0 released on 17/05/2022

Enhancements

New option added to allow downloading an image via HTTP if it has changed
Dynamic attributes can now be defined within the same field: color=blue|size=XL

Bug Fix

Fix for the regular expression for status interpretation during the curl request to control the image to be imported

master v8.8.3 released on 16/05/2022

Compatibility

Compatibility with PHP 8.1

master v8.8.2 released on 02/05/2022

Compatibility

Compatibility with PHP 8.1

master v8.8.1 released on 11/04/2022

Fix for the import of custom options by storeviews

master v8.8.0 released on 30/03/2022

Enhancement

Possibility to update custom options by storeviews

master v8.7.1 released on 29/03/2022

prototype.js added in the require call of rules.phtml to avoid execution before the full loading of JS dependencies

master v8.7.0 released on 15/03/2022

Enhancement

Possibility to define the position of the children of the grouped/bundle products with the position parameter: [position=x]

master v8.6.8 released on 03/03/2022

Fix for a bug that caused duplication of attribute options (select/multiselect/swatch) when the attribute was only imported for configurable products created on the fly

master v8.6.7 released on 01/03/2022

Fix for a bug that prevented importing swatches with an apostrophe in their label

master v8.6.6 released on 16/02/2022

Fix for a bug preventing the module from working when the Magento instance contains unlabeled product relationship declarations

master v8.6.5 released on 14/02/2022

Fix for a bug when importing tier prices
Slightly optimized execution time

master v8.6.4 released on 14/02/2022

Fix for a bug that could occur when creating grouped products

master v8.6.3 released on 03/02/2022

Optimization of requests generation for import configurations by storeview

master v8.6.2 released on 21/01/2022

Possibility to import any relation type: cross-sell, upsell, and custom types

master v8.6.1 released on 21/01/2022

Control added to avoid execution errors with older versions of M2E Pro

master v8.6.0 released on 17/01/2022

Enhancements

Better support for M2E Pro update service
Possibility to notify M2E Pro globally about any product updates

master v8.5.0 released on 10/12/2021

Enhancements

Support of FTPS (SSL over FTP) for downloading the import file and importing images via FTP

master v8.4.7 released on 17/11/2021

Fix for the labels of configurable attributes

master v8.4.6 released on 16/11/2021

Fix for the labels of configurable attributes which name contains simple quotes

master v8.4.5 released on 18/10/2021

Fix for a bug that prevented keeping the existing position of products in categories when importing product/category associations

master v8.4.4 released on 29/09/2021

Fix for the image import: the path is prefixed with a slash

master v8.4.3 released on 22/09/2021

Fix for the attribute management with a source model

master v8.4.2 released on 22/09/2021

Fix for a JS error

master v8.4.1 released on 15/09/2021

Fix for a bug preventing the use of the module with attributes having non-standard source model

master v8.4.0 released on 10/09/2021

Deletion of url_rewrite when products are deleted following post-process deletion options

master v8.3.4 released on 31/08/2021

Fix for the image role deletion feature for Magento Enterprise

master v8.3.3 released on 17/08/2021

Fix for a bug preventing the creation of attribute options on the fly for select/multiselect/swatch attributes

master v8.3.2 released on 13/08/2021

Fix for a missing table prefix

master v8.3.1 released on 09/08/2021

Fix for a bug that could prevent retrieving the list of product attributes

master v8.3.0 released on 13/07/2021

Enhancement

Management of all attributes with specific source_model

master v8.2.4 released on 05/07/2021

Fix for a bug introduced in 8.2.2 preventing the import of attribute options by value

master v8.2.3 released on 02/07/2021

Fix on the profile's history for cron tasks

master v8.2.2 released on 29/06/2021

Modification of select/multi-select attributes to allow an import by key of all the attributes with a source model

master v8.2.1 released on 28/06/2021

Increase in the maximum size dedicated to the profile mapping

master v8.2.0 released on 28/06/2021

Replication of changes from versions 7.2.2 to 7.2.4 that were lost in version 8.0.0
Modification allowing to import New theme and New layout

master v8.1.0 released on 28/06/2021

Possibility to unassign image roles by leaving the value to null (empty)

master v8.0.1 released on 28/06/2021

Fix for a camel case error

master v8.0.0 released on 25/06/2021

Enhancement

The history of profile versions is managed

master v7.2.4 released on 22/06/2021

Fix for a bug that caused swatch images to be lost when importing the attribute

master v7.2.3 released on 18/06/2021

Enhancement

When importing a swatch type attribute, if the imported option already exists in the attribute and the swatch is not affected by the import (for example by the color property), then the swatch is kept if there is one in the attribute option

master v7.2.2 released on 15/06/2021

Fix for the import of the Layout attribute

master v7.2.1 released on 26/05/2021

Fix for the mapping when deleting categories
Fix when using product ids other than SKU or ID

master v7.2.0 released on 25/05/2021

Enhancements

Possibility to assign values by storeview for label, position, and disabled by suffixing the image parameters with the store code

master v7.1.0 released on 11/05/2021

Enhancements

Better management of images for Magento 2.4

master v7.0.3 released on 12/05/2021

Fix for Magento Commerce Edition on the assignation of the updated_in field for existing products

master v7.0.2 released on 11/05/2021

Compatibility

Compatibility with Magento Enterprise: the updated_in field is assigned with a fixed date to match Magento's default behavior

master v7.0.1 released on 27/04/2021

Special cases are taken into account when generating URL rewrites

master v7.0.0 released on 22/04/2021

Enhancement

JSON source files are supported

master v6.9.3 released on 19/04/2021

Fix for a bug when replacing tier prices in Magento Enterprise

master v6.9.2 released on 01/04/2021

Fix for the requests storage reset when updating products missing from the import file

master v6.9.1 released on 04/03/2021

Better management for the swatch attributes labels: the label is automatically filled in during the import

master v6.9.0 released on 08/02/2021

Enhancement

New feature allowing a dynamic mapping

master v6.8.4 released on 16/12/2020

Enhancement

Possibility to empty the products media gallery

master v6.8.3 released on 11/12/2020

Fix for the consecutive execution of profiles

master v6.8.2 released on 04/12/2020

Value automatically added to has_options for configurable products

master v6.8.1 released on 30/11/2020

Allowed mapping size increased for new module installations

master v6.8.0 released on 24/11/2020

Compatibility

Compatibility with Advanced Inventory: possibility to define the points of sale stocks on 0 for products that are not in the import file

master v6.7.9 released on 17/11/2020

Fix for a call to the WyomindMassStockUpdateModelResourceModelTypeStock class

master v6.7.8 released on 21/09/2020

Enhancements

Code quality improved

master v6.7.7 released on 24/08/2020

Fix for the import of the rules via CSV files

master v6.7.6 released on 18/08/2020

Fix for the creation of the link between simple and configurable products for Magento EE

master v6.7.4 released on 17/08/2020

Fix for Magento Enterprise and the scheduled update: a position is assigned automatically to the children of grouped products

master v6.7.3 released on 15/07/2020

Enhancement

Possibility to import products using other unique identifiers than the SKU

master v6.7.2 released on 13/07/2020

Fix on the upgrade script for the massproductimport_profiles table

master v6.7.1 released on 13/07/2020

Fix for the automatic action on missing products: products available in the file were not correctly identified

master v6.7.0 released on 13/07/2020

Enhancements

Possibility to enable/disable the profile
The profile is disabled by default when it results from a duplication
The mapping and the source file path cannot be saved when the path is invalid
Better management of the mapping of the csv file when it is modified externally

master v6.6.3 released on 06/07/2020

Fix for updating stocks for products missing in the import file

master v6.6.2 released on 03/07/2020

Fix when updating stocks for products that are missing from the import file

master v6.6.1 released on 03/07/2020

Fix in the way the module detects if MSI is enabled

master v6.6.0 released on 02/07/2020

Enhancements

Better management of automatic actions such as stock status update (out of stock) and/or qty=0 for missing products in the file

master v6.5.2 released on 27/06/2020

Fix for an undefined class property

master v6.5.1 released on 24/06/2020

Minor fix on file

master v6.5.0 released on 13/05/2020

Enhancement

Improved license management system (Clear code)

master v6.4.20 released on 08/06/2020

Fix for the categories identification: the name of the default store view is taken into account

master v6.4.19 released on 05/06/2020

Fix for removing categories linked to the product by ID

master v6.4.18 released on 05/06/2020

Minor fix on code

master v6.4.17 released on 03/06/2020

Fix for loading the options of the Google Merchant Center Category attribute

master v6.4.16 released on 03/06/2020

Enhancement

Tax classes can now be assigned by website via the store view configuration

master v6.4.15 released on 01/06/2020

Fix for managing has_options for configurable products

master v6.4.14 released on 29/05/2020

Enhancement

Better management of swatch attributes: the color parameter must be named

master v6.4.13 released on 26/05/2020

Enhancement

Dropdown attributes translations can be emptied using #empty# to use the default value instead

master v6.4.12 released on 19/05/2020

Fix for SKU or attributes values including double quotes

master v6.4.11 released on 12/05/2020

Fix for a class namespace

master v6.4.10 released on 06/05/2020

Fix for multiple WEEE TAX import

master v6.4.9 released on 05/05/2020

Enhancement

The destination parameter is taken into account for the galleries

master v6.4.8 released on 05/05/2020

Fix for Magento Enterprise on:

category creation
missing products disable

master v6.4.7 released on 28/04/2020

Fix for categories created after the import

master v6.4.6 released on 21/04/2020

Fix for removing empty translations when the base value contains double quotes

master v6.4.5 released on 17/04/2020

Fix for removing empty translations when the base value contains double quotes

master v6.4.4 released on 15/04/2020

Fix when the option to disable missing products from the import file is used

master v6.4.3 released on 07/04/2020

Enhancements

Fix for the translations of attributes options: empty translations won't be created anymore and old translations will be deleted if there is no translation in the import
Compatibility with MSI

master v6.4.2 released on 07/04/2020

Enhancement

Better management of translations of the values of dropdown attributes ignoring empty values

master v6.4.1 released on 02/04/2020

Fix for dropdown attributes translations

master v6.4.0 released on 31/03/2020

Enhancement

Possibility to translate the value of dropdown attributes for different storeview

master v6.3.1 released on 26/03/2020

Scenario added for the demo

master v6.3.0 released on 26/03/2020

Enhancement

Management of catalog_product_flat and catalog_category_flat indexers if the option is enabled in Stores > Settings > Configuration > Catalog > Catalog > Storefront

master v6.2.15 released on 16/03/2020

Bug Fix

Fix on permissions for the display of the library in the black box

master v6.2.14 released on 10/03/2020

Bug Fix

Fix for the video import

master v6.2.13 released on 04/03/2020

Bug Fix

Fix to avoid notices and warnings when the table is empty

master v6.2.12 released on 28/02/2020

Bug Fix

Merchandising for configurable products
BSS prefix for categories
Custom options for Magento Enterprise

master v6.2.11 released on 21/02/2020

Minor fix for cron tasks

master v6.2.10 released on 18/02/2020

Enhancement

Better import of tier prices: add imported tier prices to existing ones instead of replacing them

master v6.2.9 released on 18/02/2020

Enhancement

Better management of URL key generation for categories created dynamically

master v6.2.8 released on 17/02/2020

Fix for sample data

master v6.2.7 released on 05/02/2020

Compatibility fix for some PHP versions

master v6.2.6 released on 24/01/2020

Bug Fix

Fix when a mapping element is empty
No error is triggered if no warehouse is saved
Fix for sending emails to the warehouse

master v6.2.5 released on 21/01/2020

Minor fix on code

master v6.2.3 released on 23/12/2019

Enhancement of the scalability for the image processing

master v6.2.2 released on 02/12/2019

Management of backslashes in SKUs

master v6.2.1 released on 28/11/2019

Fix when deleting bundle options items

master v6.2.0 released on 25/11/2019

Possibility to add/delete the bundle products' options

master v6.1.3 released on 15/11/2019

Fix when saving the replacement rules

master v6.1.2 released on 14/11/2019

Fix for configurable products created on the fly

master v6.1.1 released on 13/11/2019

Fix on the "Test Connection" button from the Image settings

master v6.1.0 released on 04/11/2019

Better performance for the import of imagesToMove
Enhanced management of auto-increment for the categories import

master v6.0.4 released on 30/10/2019

Update on the sample data permissions

master v6.0.3 released on 18/10/2019

Update of the sample data for the demo

master v6.0.2 released on 16/10/2019

Fix on a PHP error when creating a replacement rule

master v6.0.1 released on 15/10/2019

Fix for a compilation issue caused by the PHP doc
Code clean

master v6.0.0 released on 01/10/2019

New feature

Management of replacement rules

Compatibility

Compatibility for Magento 2.3.3

master v5.1.2 released on 20/09/2019

Enhanced image import
Possibility to define tiers prices per website

master v5.1.1 released on 31/07/2019

Enhancements

New tooltip for the status bar
Code cleaning
Wording fixes

Patch v5.1.1.9

Fix for duplicated categories and attributes
Fix for the image gallery

Patch v5.1.1.8

Fix for the images import

Patch v5.1.1.7

Fix for duplicate attribute creation

Patch v5.1.1.6

Sample data available for the demo

Patch v5.1.1.5

Fix for creating categories on the fly when configurable products are not created on the fly

Patch v5.1.1.4

Fix for duplicated categories and attribute values

Patch v5.1.1.3

Fix for the cron task

Patch v5.1.1.2

Minor fix on code

Patch v5.1.1.10

Enhanced images import
DB clean

Patch v5.1.1.1

Useless files removed

master v5.1.0 released on 25/07/2019

Enhancement

Ability to run the index on demand or automatically at the end of the import process
Possibility to select the index to execute

master v5.0.0 released on 06/06/2019

Enhancements

Support for Magento MSI
Interface enhancements (dropdowns with pre-populated values)
New syntaxes and options for: categories, configurable attributes, swatch image, category mapping, images/videos, custom options
Better management of request errors
Improvement for Advanced Inventory

Patch v5.0.0.6

Fix on namespace

Patch v5.0.0.5

Fix for the video import

Patch v5.0.0.4

Fix for OPTIONS_CONTAINER
Enhancement for the image import

Patch v5.0.0.3

Fix on storeviews dependencies (price, visibility attributes)

Patch v5.0.0.2

Minor fix for the sample data and the configurable product
Fix for the images import

Patch v5.0.0.1

Minor fix in script

master v4.3.0 released on 15/03/2019

Enhancement

Better management of Magento export files

Patch v4.3.0.2

Fix for the import of boolean attribute value

Patch v4.3.0.1

Fix on a typo

master v4.2.2 released on 13/02/2019

Enhancements

White spaces in the images urls are stripped out
Improvement of the price import for Magento EE

Patch v4.2.2.1

Fix for the customer Group/Tier prices

master v4.2.1 released on 07/02/2019

Enhancement

Support of tier prices for Magento EE

master v4.2.0 released on 30/01/2019

Enhancement

New option for each mapping row that allows you to define if the value applies to the created and/or updated products

Bug Fix

Fix on the cron interval configuration

master v4.1.0 released on 28/01/2019

Enhancements

Possibility to change the cron task interval
Better management of XML files using namespaces

master v4.0.0 released on 23/11/2018

New feature

Profile import/export

Enhancements

New interface, easier and faster to configure
Better management of configurable products
New sample data

Patch v4.0.0.4

Minor code fix

Patch v4.0.0.3

Minor fix on code

Patch v4.0.0.2

Wording correction

Patch v4.0.0.1

Fix on a typo

master v3.2.2 released on 29/10/2018

Enhancement

Possibility to choose to run the indexers after the import

Patch v3.2.2.2

Fix for the update of products that are not in the source file

Patch v3.2.2.1

Fix on a PHP error

master v3.2.1 released on 16/10/2018

Enhancement

Improved images management (when imported through several mapping lines)

Bug Fix

Fix on the upgrade script

master v3.2.0 released on 21/08/2018

Enhancements

Possibility to add the product position in the category
ex: Default Category[0]/Women[10]/Shirt[10]
The import keeps the position of products that are already assigned
Urls re-indexation when updating the url key

Patch v3.2.0.2

Fix for the category mapping and the root category id management

Patch v3.2.0.1

Fix for configurable products

master v3.1.0 released on 11/07/2018

Enhancement:

Better management of configurable products
Improved management of the images import
Use of regular expressions in the files names

Patch v3.1.0.6

Fix for configurable products

Patch v3.1.0.5

Fix for the attributes

Patch v3.1.0.4

Fix for the tax class when there's no ID
Fix for merchandising (related, up-sell, cross-sell)

Patch v3.1.0.3

Patch for the "merchandising" group for Magento EE
Patch for the attributes with their own source_model

Patch v3.1.0.2

Fix for Magento EE: SQL error because of empty values

Patch v3.1.0.1

Fix when associating products to categories using the category ids

master v3.0.1 released on 11/06/2018

Enhancement

Support of the category creation with Magento Enterprise Edition

Patch v3.0.1.1

Better management of attribute (select type)
Creation of fixed categories for Magento Enterprise Edition
Website values are now case insensitive

master v3.0.0 released on 30/05/2018

Enhancement

New user interface
New PHP API

Compatibility

Compatibility with Mass Stock Update v7.0.0

Fix

Minor fix on file

Patch v3.0.0.3

Fix for empty values
Fix for the product relations in the merchandising section

Patch v3.0.0.2

Fix for the image gallery
Fix for empty attribute value

Patch v3.0.0.1

Fix for configurable products
Possibility to delete an attribute value

master v2.4.0 released on 02/05/2018

Improvement

Management of parents for bundle and grouped products

Patch v2.4.0.2

Fix on the storeview selected when creating group prices

Patch v2.4.0.1

Fix when bundle/grouped products are linked to simple ones

master v2.3.0 released on 17/04/2018

Improvements

Several possible actions after the execution

Patch v2.3.0.1

Cron task fix

master v2.2.1 released on 09/04/2018

Compatibility

Enterprise Edition

Improvements

Support images for EE

Bug Fix

Minor bug fix

master v2.2.0 released on 01/03/2018

New features

New categories management that allows to use category tree
Use of Touchscroll
Ability to filter product based on row ranges
Ability to exclude the header of the csv/txt file
Ability to import/update Cross Sell, Up sell, and related products
Ability to import data from a Dropbox location

Patch v2.2.0.3

Fix for the attribute management

Patch v2.2.0.2

Several bug fixes

Patch v2.2.0.1

Fix for the install script

master v2.1.0 released on 28/02/2018

New features

Downloadable products can be now imported
Fix for the visibility status for "Catalog, Search"

Patch v2.1.0.6

Fix for the ACL

Patch v2.1.0.5

Fix for the url key

Patch v2.1.0.4

Fix for a method name
Fix for the database using a prefix

Patch v2.1.0.3

Fix for the ACL

Patch v2.1.0.2

Enhancement

Ability to create configurable attributes even if the configurable products are not created on the fly

Patch v2.1.0.1

fix for the image import
fix for the database using a prefix
fix for the configurable products import

master v2.0.0 released on 20/02/2018

Refactoring

Code source enhancement
Dependency with Mass Stock Update implemented to avoid duplicating source code
Use of INSERT ... ON DUPLICATE UPDATE ... process

Enhancements

Fixed Product Tax is now supported
Group / Tiers prices is now supported

Bug Fix

Table prefix is now supported for all tables

Patch v2.0.0.4

Better management of the configurable product attributes

Patch v2.0.0.3

fix for the image import
fix for the database using a prefix
fix for the configurable products import

Patch v2.0.0.2

Fix for the image importation from HTTP

Patch v2.0.0.1

Fix the class names of the FieldDelimiter, FieldEnclosure classes for the csv files
Fix the ProductIdentifier class name

master v1.7.1 released on 28/12/2017

Enhancement

New management of the stock updates for Advanced Inventory users

Patch v1.7.1.3

Fix for the images import from HTTP

Patch v1.7.1.2

Fix for the url_key attribute

Patch v1.7.1.1

Fix for the multi-stock management

master v1.7.0 released on 19/12/2017

Enhancement

New categories management

Patch v1.7.0.2

Fix for the url_key attribute

Patch v1.7.0.1

Fix for the installation scripts

master v1.6.1 released on 18/12/2017

Enhancement

Better support for the attributes updates

master v1.6.0 released on 13/12/2017

Enhancements

New command lines to generate and execute the import profiles

master v1.5.0 released on 06/12/2017

Enhancements

Custom options are now supported in the mapping section

Patch v1.5.0.1

Fix for the attributes updates

master v1.4.0 released on 05/12/2017

Enhancements

XML file structure can now be preserved even if the file differs from one import process to another
Php scripts can be used in the value field of the additional columns

master v1.3.0 released on 04/12/2017

Enhancements

Relation with configurable products can now be defined in the mapping section
Configurable products can now be created on the fly from a group of simple products

master v1.2.0 released on 29/11/2017

Enhancements

Images can now be imported from a remote server by using HTTP
Products that are not included in the import file can now be deleted/disabled/marked as out of stock
New user interface
Minor code refactoring

master v1.1.0 released on 08/11/2017

Enhancements

Magento v2.2.1 compatibility
Support for the color swatch attributes
Support for configurable products
Better support of the XML sub-nodes
Better errors management and display

Patch v1.1.0.2

Javascript fix

Patch v1.1.0.1

Fix for the CSV file headers

master v1.0.1 released on 19/10/2017

Enhancement

Ability to use several category names in the same column
use strict mode in javascript files

Patch v1.0.1.4

Fix to avoid any issue when the import file mismatch with the mapping

Patch v1.0.1.3

Fix for an undeclared js variable in ftp.js

Patch v1.0.1.2

Fix for the FTP validation button

Patch v1.0.1.1

fix for images importation from a sftp connection

master v1.0.0 released on 13/09/2017

First public release

Patch v1.0.0.9

fix for profiles that don't use additional columns

Patch v1.0.0.8

Fix for the CSV file preview
Fix for the cron tasks
Fix for skipping empty image path
Update the number of children in the category

Patch v1.0.0.7

Category.phtml renamed to category.phtml
Js fixes on category.js

Patch v1.0.0.6

Fix for prefixed tables

Patch v1.0.0.5

Minor bug fixed for the creation of the profiles

Patch v1.0.0.4

Fix for the import AND update in the same profile

Patch v1.0.0.3

Fix for the sample data

Patch v1.0.0.2

Fix for the command lines

Patch v1.0.0.10

fix for images importation from a sftp connection

Patch v1.0.0.1

Lowercase fix for one model file

Demo store

Front-end

Url

https://msi.wyomind.com

Back-end

Url

https://msi.wyomind.com/admin

MassProductImport&Update

Password

MassProductImport&Update123

Mass Product Import & Update

Mass Product Import & Update allows you to update and import products massively in Magento in record time through CSV or XML files available from your website's server, or any remote server through FTP or HTTP.

How to configure Mass Product Import & Update

Configure Mass Product Import & Update in a general way

General Settings

Log file

M2E Pro update

Mapping preview

Cron job reporting

Cron interval

Create an import profile with Mass Product Import & Update

Black Box

Input Data

Library

Output Data

Settings

Profile settings

File Location

File Type

Post Process Action

Advanced Settings

System Settings

Stock Settings

Image Settings

Category Settings

Configurable Product Settings

Mapping & Rules

Column Mapping

Scheduled tasks

Action History

Export and import your profiles pattern

Export

Import

Run your Mass Product Import & Update profiles

From the profiles grid

From the profile page

With the cron tasks

With the Command Lines Interface

Use SQL option

Generate the SQL file

Execute the SQL file

Advanced use

Attribute specifications to import or to update

System attributes

Sku

Attribute set

Type

Website

Tax Class

Visibility

Status

Products attributes

Text or textarea attribute

Yes/no attribute

Dropdown attributes

Multi-select attributes

Date attributes

Prices attributes

Price

Special price

Special price from/to date

Tier price/Group price

Weee tax

Stock attributes

Boolean values

Numeric values

MSI attributes

Quantity

Notify Qty

Use default for notify Qty

Stock Status

MSI Backorders attributes

Backorders

Backorders date

Backordered qty

Dynamic attributes

Dynamic attribute

Media attributes

Media Gallery

Base Image, Small Image, Thumbnail