solutions for e-commerce

13 years of business 2555 reviews 4.9 average rating
Magento 2

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.

5/5 rated
112 Reviews
from €345
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

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:password@www.website.com/Inventory/AvailableInventory

    If you are using a specific port, you can use the below format:
    http://login:password@www.website.com: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:

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

  1. 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.
  2. DELETE a row easily.
  3. Change the order of each row using the drag and drop.
  4. Deactivate a line while conserving the settings by clicking on the LINK symbol.
  5. 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
  6. 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
  7. Apply the color of your choice to the row.
  8. Apply a label to the row.
  9. Define to which store view(s) you want to apply these settings by clicking APPLY TO DEFAULT VALUE.
  10. 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.
  11. 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.
  12. Preview your file by clicking INPUT DATA.
  13. Find all the attributes grouped by type in the LIBRARY.
  14. 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:

  1. Source file analysis: the data are collected and the SQL queries for the update/import are built. 
  2. 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

15

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

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

2

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.

  1. Not visible Individually
  2. Catalog
  3. Search
  4. Catalog & Search

Catalog,Search

4

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.

9

Notify Qty

Notify the quantity for the source.

1

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.


50

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

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.

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.

path/to/image_1.jpg[position=1|label=image 1]
path/to/image_2.jpg[position=2|label=image 2]
path/to/image_3.jpg[destination=new_image_3.jpg]
path/to/image_4.jpg[position=1|disabled=1|label=image 4]
path/to/image_5.jpg[disabled=0|label=red|disabled_de=1|label_de=rotte|disabled_fr=0|label_fr=rouge]

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.

Title of the downloadable resource.
Downloadable file

Samples title

Title of the downloadable resource.
Downloadable sample

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

Bundle items option title as below:
Bundle items option title [type=select|required=1|option_position=1
|sku=SKU ABC|selection_qty=1|is_default=0|selection_price_type=0|selection_price_value=0
|selection_can_change_qty=0|position=1]
[sku=SKU XYZ|selection_qty=2|is_default=1|selection_can_change_qty=0|position=2]

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.

Primary bag [type=select|required=1|option_position=1|sku=24-MB01|selection_qty=2|is_default=0|selection_can_change_qty=1|position=1][sku=24-MB05|selection_qty=1|is_default=1|selection_can_change_qty=0]

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.

Custom option title and option values in the following format: 
Custom option [title=title1|sku=sku1|price=10%|sort_order=1][title=title2|sku=sku2|price=10|sort_order=2]

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. 

Engraving [is_require=1|title=Gold engraving|sku=engraving01|price=20%|sort_order=1][title=Silver engraving|sku=engraving02|price=10%|sort_order=2]...

Engraving [title=Gold engraving|sku=engraving01|price=50|sort_order=1][title=Silver engraving|sku=engraving02|price=30|sort_order=2]...

Text Field / Textarea

Custom option title and option values in the following format: 
Custom option Text [is_require=1|title=text|sku=txt|price=10|sort_order=1|max_characters=100]

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

Custom option title and option values in the following format: 
Custom option Text [is_require=1|title=text|sku=txt|price=10|sort_order=1|file_extension=jpg]

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.

Freqently Asked Questions
Pre-sales informations

Magento offers three variations of its product.

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

  • Magento Open Sourcepreviously 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 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

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)

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: 

  1. Go to:
    mY accountLicenses & DOwnloads
  2. Click on the Settings icon next to the module you want your domain to pre-register on.
  3. 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?
  4. 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. 

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:

  1. Download Mass Product Import & Update.
    (see FAQ: Extensions download)
  2. Install Mass Product Import & Update on your environment.
    (see FAQ: Modules installation in Magento or in WooCommerce)
  3. 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

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

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

      A new window opens.

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

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:

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

Modules Installation/Uninstallation

You can install Mass Product Import & Update manually.

  1. Download Mass Product Import & Update (zip file) on:
    mY ACCOUNTLicenses & Downloads
     
    Refer to the FAQ: Extensions download
  2. Once Mass Product Import & Update is downloaded, open the folder and unzip it.
  3. Copy the content of the unzipped folder and paste all files and directories in your Magento 2 root directory.
  4. 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  

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
  1. Add to your composer configuration our repository:
    composer config repositories.wyomind composer https://repo.wyomind.com 

  2. Execute Composer command:
    composer require wyomind/massproductimport
  3. Then go in your Command Line Interface and execute:
    bin/magento setup:upgrade ​
  4. If you are using a production mode, also execute:
    bin/magento setup:static-content:deploy  ​
    bin/magento setup:di:compile​

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

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

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:

    1. 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'
       ),
       /* ... */
       )
      ?>​
    2. 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).


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

    4. Click on Save config .
    5. A message appears at the top of your admin panel. Click on that link: 
      Activate it now!
    6. Copy and paste the license code in the License code field from your admin or simply click on Activate now! 


    7. 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...):

  1. Once the extension is installed on the new domain, copy your activation key in:
    StoresConfigurationWyomind Your extension
  2. After having saved the configuration, a notification appears. Click on Add this domain to my license.

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

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
Modules use

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

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. 

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.

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

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.

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

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

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

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

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:

  1. In File location, select Dropbox

  2. Fill the Path to file field with the file path relative to the root directory of your Dropbox container.


    For example : /import/xml

  3. Configure your Dropbox app to allow the Full Dropbox.

    For example:

 

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

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

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

  1. Access your database via your control panel (Phpmyadmin for example).
  2. 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.
  3. Logout from your Magento 2 admin.
  4. Log into your Magento 2 admin.
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.

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.

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

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
User's reviews
Log into your account to leave your review and get up to 3 months of free Support & Upgrade.

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

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 5 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 2 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.

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

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.

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

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

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

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

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

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

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.

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.

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!

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

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.

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.

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 2 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 4 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

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 3 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

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.

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 3 years |Magento 2

29th January 2021

Excellent support

The code and support are excellent!

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

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 5 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 4 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 3 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 3 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!

22nd October 2020

Very usefull

Great extension . Very usefull.

Shadow - Developer - User for more than 4 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!

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!

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!

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

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.

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

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.

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

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 5 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!

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.

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. :-)

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.

20th November 2019

Great Extension - Everything is fast

It makes uploading products very fast and in a consistent way.

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.

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

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.

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

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.

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

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 5 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 4 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. :)

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

23rd May 2019

great module!

It works fine and have great support!

altravista - User for more than 5 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

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 :)

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

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

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.

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.

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

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.

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 5 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%

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 5 years |Magento 1

10th January 2019

Perfect service!

The guys know what they do and help you always!

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

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 5 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 6 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.

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.

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.

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.

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.

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

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

2nd May 2018

super import extension

This is de best magento 2 product import extension I found

19th April 2018

perfect importer

most versatile importer i have seen so far and superb support!

Danel - User for more than 5 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!

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.

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.

Changelog

Improvement

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

Compatibility

  • Magento 2.4+ compatibility for the cache purge feature

Initial release for the master version

Initial release for the legacy version

Bug fix

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

Compatibility

  • Compatibility with PHP v8.2

Compatibility

  • Compatibility with Magento v2.4.6 + PHP v8.2

Compatibility

  • Compatibility with Magento v2.4.6 + PHP v8.2

Compatibility with Magento v2.4.6

Compatibility with Php v8.1

Improvement

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

Improvement

  • Compatibility with PHP v8.1

Fixes

  • Fix the import of the bundle product options with identical label

Improvement

  • Execution time optimization for images import
  • Improvement of the dynamic attribute feature: dynamic attributes can now be mapped at storeview level 
  • Bug fix for the updates of created_at and updated_at product fields 
  • Improvement of the image import: the same image can be renamed as different destination images 
  • Bug fix that prevent gift cards from being overridden when the import process runs
  • Bug fix for label images in case of empty label 
  • Rollback patches for install/upgradeData that conflicts with some third-party modules (should be fixed in a coming version)
  • Replacement rules are executed by order of position
  • Fix the bundle import for Adobe Commerce edition
  • Fix the bundle import for Adobe Commerce edition
  • Ability to update any static attributes
  • Fix the bundle import for Adobe Commerce edition
  • Optimization in the image processing: size is only calculated if the "Download the image again if it has changed" option is activated
  • Minor fix on code
  • db_schema.xml and db_schema_whitelist.json
  • Use of db_schema
  • Fix for multiple dynamic attributes

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



Compatibility

  • Compatibility with PHP 8.1

Compatibility

  • Compatibility with PHP 8.1
  • Fix for the import of custom options by storeviews

Enhancement

  • Possibility to update custom options by storeviews
  • prototype.js added in the require call of rules.phtml to avoid execution before the full loading of JS dependencies

Enhancement

  • Possibility to define the position of the children of the grouped/bundle products with the position parameter: [position=x]
  • 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
  • Fix for a bug that prevented importing swatches with an apostrophe in their label
  • Fix for a bug preventing the module from working when the Magento instance contains unlabeled product relationship declarations
  • Fix for a bug when importing tier prices
  • Slightly optimized execution time
  • Fix for a bug that could occur when creating grouped products
  • Optimization of requests generation for import configurations by storeview
  • Possibility to import any relation type: cross-sell, upsell, and custom types
  • Control added to avoid execution errors with older versions of M2E Pro

Enhancements

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

Enhancements

  • Support of FTPS (SSL over FTP) for downloading the import file and importing images via FTP
  • Fix for the labels of configurable attributes
  • Fix for the labels of configurable attributes which name contains simple quotes
  • Fix for a bug that prevented keeping the existing position of products in categories when importing product/category associations
  • Fix for the image import: the path is prefixed with a slash
  • Fix for the attribute management with a source model
  • Fix for a JS error
  • Fix for a bug preventing the use of the module with attributes having non-standard source model
  • Deletion of url_rewrite when products are deleted following post-process deletion options
  • Fix for the image role deletion feature for Magento Enterprise
  • Fix for a bug preventing the creation of attribute options on the fly for select/multiselect/swatch attributes 
  • Fix for a missing table prefix
  • Fix for a bug that could prevent retrieving the list of product attributes

Enhancement

  • Management of all attributes with specific source_model

  • Fix for a bug introduced in 8.2.2 preventing the import of attribute options by value
  • Fix on the profile's history for cron tasks
  • Modification of select/multi-select attributes to allow an import by key of all the attributes with a source model
  • Increase in the maximum size dedicated to the profile mapping
  • 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
  • Possibility to unassign image roles by leaving the value to null (empty)
  • Fix for a camel case error

Enhancement

  • The history of profile versions is managed
  • Fix for a bug that caused swatch images to be lost when importing the attribute

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
  • Fix for the import of the Layout attribute
  • Fix for the mapping when deleting categories
  • Fix when using product ids other than SKU or ID

Enhancements

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

Enhancements

  • Better management of images for Magento 2.4
  • Fix for Magento Commerce Edition on the assignation of the updated_in field for existing products

Compatibility

  • Compatibility with Magento Enterprise: the updated_in field is assigned with a fixed date to match Magento's default behavior
  • Special cases are taken into account when generating URL rewrites

Enhancement

  • JSON source files are supported
  • Fix for a bug when replacing tier prices in Magento Enterprise
  • Fix for the requests storage reset when updating products missing from the import file
  • Better management for the swatch attributes labels: the label is automatically filled in during the import

Enhancement

  • New feature allowing a dynamic mapping

Enhancement

  • Possibility to empty the products media gallery
  • Fix for the consecutive execution of profiles
  • Value automatically added to has_options for configurable products
  • Allowed mapping size increased for new module installations

Compatibility

  • Compatibility with Advanced Inventory: possibility to define the points of sale stocks on 0 for products that are not in the import file
  • Fix for a call to the WyomindMassStockUpdateModelResourceModelTypeStock class

Enhancements

  • Code quality improved
  • Fix for the import of the rules via CSV files
  • Fix for the creation of the link between simple and configurable products for Magento EE
  • Fix for Magento Enterprise and the scheduled update: a position is assigned automatically to the children of grouped products

Enhancement

  • Possibility to import products using other unique identifiers than the SKU
  • Fix on the upgrade script for the massproductimport_profiles table
  • Fix for the automatic action on missing products: products available in the file were not correctly identified

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
  • Fix for updating stocks for products missing in the import file
  • Fix when updating stocks for products that are missing from the import file
  • Fix in the way the module detects if MSI is enabled

Enhancements

  • Better management of automatic actions such as stock status update (out of stock) and/or qty=0 for missing products in the file
  • Fix for an undefined class property
  • Minor fix on file

Enhancement

  • Improved license management system (Clear code)

 

  • Fix for the categories identification: the name of the default store view is taken into account
  • Fix for removing categories linked to the product by ID
  • Minor fix on code
  • Fix for loading the options of the Google Merchant Center Category attribute

Enhancement

  • Tax classes can now be assigned by website via the store view configuration
  • Fix for managing has_options for configurable products

Enhancement

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

Enhancement

  • Dropdown attributes translations can be emptied using #empty# to use the default value instead
  • Fix for SKU or attributes values including double quotes
  • Fix for a class namespace
  • Fix for multiple WEEE TAX import

Enhancement

  • The destination parameter is taken into account for the galleries

Fix for Magento Enterprise on:

  • category creation
  • missing products disable
  • Fix for categories created after the import
  • Fix for removing empty translations when the base value contains double quotes
  • Fix for removing empty translations when the base value contains double quotes
  • Fix when the option to disable missing products from the import file is used

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

Enhancement

  • Better management of translations of the values of dropdown attributes ignoring empty values
  • Fix for dropdown attributes translations

Enhancement

  • Possibility to translate the value of dropdown attributes for different storeview
  • Scenario added for the demo

Enhancement

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

Bug Fix

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

Bug Fix

  • Fix for the video import

Bug Fix

  • Fix to avoid notices and warnings when the table is empty

Bug Fix

  • Merchandising for configurable products
  • BSS prefix for categories
  • Custom options for Magento Enterprise
  • Minor fix for cron tasks

Enhancement

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

Enhancement

  • Better management of URL key generation for categories created dynamically
  • Fix for sample data
  • Compatibility fix for some PHP versions

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
  • Minor fix on code
  • Enhancement of the scalability for the image processing
  • Management of backslashes in SKUs
  • Fix when deleting bundle options items
  • Possibility to add/delete the bundle products' options
  • Fix when saving the replacement rules
  • Fix for configurable products created on the fly
  • Fix on the "Test Connection" button from the Image settings
  • Better performance for the import of imagesToMove 
  • Enhanced management of auto-increment for the categories import
  • Update on the sample data permissions
  • Update of the sample data for the demo
  • Fix on a PHP error when creating a replacement rule
  • Fix for a compilation issue caused by the PHP doc
  • Code clean

New feature

  • Management of replacement rules

Compatibility

  • Compatibility for Magento 2.3.3
  • Enhanced image import
  • Possibility to define tiers prices per website

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

Enhancement

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

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

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

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

Enhancement

  • Support of tier prices for Magento EE

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

Enhancements

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

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

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

Enhancement

  • Improved images management (when imported through several mapping lines)

Bug Fix

  • Fix on the upgrade script

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

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

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

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

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

Improvements

  • Several possible actions after the execution
Patch v2.3.0.1

  • Cron task fix

Compatibility

  • Enterprise Edition

Improvements

  • Support images for EE

Bug Fix

  • Minor bug fix

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

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

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

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

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

Enhancement

  • Better support for the attributes updates

Enhancements

  • New command lines to generate and execute the import profiles

Enhancements

  • Custom options are now supported in the mapping section
Patch v1.5.0.1

  • Fix for the attributes updates

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 

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

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

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

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

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
Back-end
Login
MassProductImport&Update
Password
MassProductImport&Update123

Recommended Magento 2 extensions

from €245
4.9/5 rated
558 Reviews

Export your products from your Magento website into CSV, TXT, and XML data feeds for any shopping engine or marketplace! This extension includes all Google Shopping features and 19 sample templates.

more details
from €245
4.8/5 rated
70 Reviews

Mass Order Export allows you to create xml, csv and txt order files from your Magento admin panel and export them to any CRM application or order management software/platform. Any kind of export file types can be easily customized.

more details
from €295
5/5 rated
1 Review

Optimize your order management and automate the orders' assignation to the appropriate sources by creating custom algorithms and keep your stocks up to date with MSI Order Management.

more details
from €690
4.5/5 rated
2 Reviews

Fully complete and enhance Magento 2 default workflow and perfect your inventory management as well as your selling process thanks to the MSI Suite to become a lot more productive.

more details

Stay tuned and get a coupon code of 10% off any purchase while creating your account!

Subscribe now for updates, promotions and products launch twice a month at most.

Please indicate a valid email