stockimportmarketplace_1_1_1_1_1_1_1_1_1_1_1.png

Stock Import
M2

by XTENTO
TOTAL:
$259.00

Compatibility

Magento Platform
Open Source (CE)
2.0, 2.1, 2.2, 2.3
Commerce using on prem (EE)
, 2.0, 2.1, 2.2, 2.3
Commerce on Cloud (ECE)
2.2, 2.3

Tech Specifications

Seller:
Current Version:
2.7.5
Type:
Stable Build
Updated:
17 September, 2019
Categories:
Extensions, Shipping & Fulfillment, Warehouse Management System (WMS)
License Type:
Policy:

Overview

Automate your inventory management today and don't spend hours a day updating stock levels manually.

Other Extensions by XTENTO

Overview

Back to top

Importing stock level, price & custom product attribute updates from CSV, Excel and XML files into Magento 2 (Magento 1 version available on Marketplace as well - use the search) has never been easier. Using the Magento Stock Import Module by XTENTO, importing stock and product information from third party systems into Magento is a breeze - and fully automated! Automate your inventory management and don't spend hours every day updating products and stock levels manually. Set up automated mass product updates today.

This extension provides the ability to import all fields related to the stock entity - fields include Quantity in stock, Is in stock and Manage stock, as well as custom product attributes such as name, weight or other product attributes you've set up. Just upload a file with SKU and quantity information, and your stock levels will get updated by the extension within seconds. The extension will process the imported file and import the stock information as configured. This will all happen automatically - you don't have to do any stock updates manually anymore.

Detailed import results will be returned (in manual mode) showing which products have been updated and which haven't. This can also be set up to run on a schedule, so full automatic periodical imports without any manual intervention are possible as well.

 

Features

  • Seamlessly integrated into Magento and into the Magento backend
  • CSV/XLS/XLSX/ODS/TXT/Tab/Fixed-Length/XML formats can be imported. The import format is completely flexible.
  • Any field names can be used. Set up using mapping function in the backend.
  • Supports an unlimited amount of import profiles. Import as many different import formats with different settings as required.
  • Import from an unlimited amount of different local/remote destinations. Supports local directories, FTP, FTPS, SFTPv3, HTTP Servers, Webservices/APIs
  • Very easy configuration - check out our demo installation
  • Very quick way to import your stock levels - 1000 stock updates/sec (0.001s per product) and more possible
  • Intelligent Import: Only modified stock items get imported - speeding up the import dramatically
  • Supports relative (+X or -X) and absolute (set stock level to X) stock level imports
  • Does not use slow Magento dataflow nor product model functions to update stock items
  • Ability to import files automatically from any local directory or from a remote (S)FTP server
  • Ability to upload files to import directly from the backend
  • Files can be deleted or archived after being processed
  • The built-in cronjob that runs the automatic import can be configured in the Magento backend
  • Compatible with almost all Magento versions (see compatibility chart below)
  • Supports download of import files from remote SFTPv3 servers (Secure FTP, uses SSH)
  • Update all product & stock related fields
  • New Feature: Update product attributes such as weight, product name or any other custom product attribute for existing products. Need to import the lead time from your supplier for your products along with the stock level? Not a problem at all.


This extension has been implemented in dozens of Magento installations already and has proven it is able to import stock levels automatically for months and years.

Attention: This extension does not import new products into Magento. You can only use it to update existing products. The purpose of this extension is to update stock levels (and custom product attributes) for existing products in a very quick way.

 

Order Export & Tracking Number Import

This module is compatible with our order export and tracking number import modules - these modules will help you to automate your order and inventory management entirely.

Demo

We've set up a demonstration section showing the configuration section of the extension in the backend. Please click this link to view the demo backend. Sample import formats we've used in the past can be downloaded here.

Questions?

Be sure to check out the excellent reviews as well! If you have any questions regarding this extension, please do not hesitate to contact us. We'll be happy to help!

Release Notes

Back to top

2.7.5:

  • Compatible with Open Source (CE) : 2.1 2.2 2.3
  • Compatible with Commerce using on prem (EE) : 2.1 2.2 2.3
  • Compatible with Commerce on Cloud (ECE) : 2.2 2.3
  • Stability: Stable Build
  • Description:

    ===== 2.6.8 =====
    * Fixed an issue where unnecessary entries where made in cataloginventory_stock_status table were made that could lead to issues with indexers
    * Fixed an issue where stock status ("In Stock" / "Out of Stock") was updated based on qty even though stock status wasn't mapped and 'Set "In Stock" / "Out of Stock"' was disabled

    ===== 2.6.9 =====
    * For configurable products, the "stock status" (in stock/out of stock) can now be updated, as well as other supported fields

    ===== 2.7.0 =====
    * Fixed an issue where in the frontend cache of configurable products wasn't cleared and old variations/stock status was still shown
    * Fixed an issue where SFTP connections failed (Error: "Could not connect to SFTP server [...]"). If SFTP connections still fail now, it's probably caused by an incompatible SFTP server or a firewall. This issue was most likely caused by Magento 2.3.x.

    ===== 2.7.1 =====
    * Module code updated to comply with Magento Coding Standard as of August 2019
    * Removed silenced errors ("@function") entirely. Improved logging in such cases so those errors are logged/reported.
    * Logging improvements

    ===== 2.7.2 =====
    + Added ability to import and process XLS/XLSX/ODS/Excel-XML files. Import stock levels & product information from Excel files directly!

    ===== 2.7.3 =====
    * Price imports check the price scope (global/website) now
    * Tier prices can be set on a per-website level now (M2.2+)
    * Fixed an issue for price imports: Price changes were not detected when only certain store views were to be updated
    * Fixed an issue for cost import: Set store view wasn't used, was set for all stores views instead
    * Fixed an issue for product updates; attribute changes were not detected when only certain store views were to be updated

    ===== 2.7.4 =====
    * Fixed an issue when updating non-global attributes with scope website/store view

    ===== 2.7.5 =====
    * Fixed issue "Invalid method ..:isScopeGlobal"

2.6.5:

  • Compatible with Open Source (CE) : 2.1 2.2 2.3
  • Compatible with Commerce using on prem (EE) : 2.1 2.2 2.3
  • Stability: Stable Build
  • Description:

    ===== 2.6.1 =====
    * If __EMPTY__ is imported for "cost" field, the cost is set to NULL

    ===== 2.6.2 =====
    * Improvements with regards to error logging and custom classes file archiving

    ===== 2.6.3 =====
    + Added ability to import NULL for product price (via __EMPTY__ as field value)
    * Fixed issue with custom product attribute updates - sometimes changes in values weren't detected
    * Fixed import sources; connection information such as port couldn't be saved under certain circumstances due to DB layout issues
    * For attribute updates of attributes with dropdown (source), the "store" value of the in the configuration selected "Store View (Attribute Update)" is now used to identify values of the dropdown
    * Updated Xtento_XtCore to version 2.5.0

    ===== 2.6.4 =====
    * Fixed issue for custom product attribute update: Warning: Illegal offset type in ... module-eav/Model/Entity/Attribute/Source/Table.php on line 81

    ===== 2.6.5 =====
    * [Performance Improvement] Improved handling of product attributes for fields with decimals - forced to 4 decimals just like in the database, leading to less "changed" products (that didn't actually change). Also applies to attributes with source tables, should make the import detect less false updates and thus faster.
    * Improved graceful die: Previous log messages (from current execution) are retained
    * Improved logging of update values to see which product values were updated from what to what exactly
    * Improved logging of reindexing situations for price/attribute updates
    * Fixed: "0 records" entries in execution log are not saved anymore

2.6.0:

  • Compatible with Open Source (CE) : 2.1 2.2 2.3
  • Compatible with Commerce using on prem (EE) : 2.1 2.2 2.3
  • Stability: Stable Build
  • Description:

    ===== 2.5.4 =====
    * Final fix for built-in editor (Ace.js) having issues with tabs/spaces/theme. Be sure to deploy static content after updating.

    ===== 2.5.5 =====
    + Added ability to update "Manage Stock (Use Config)" field using the extension
    * Fix for file mapper that could cause JS errors

    ===== 2.5.6 =====
    + Added "graceful die": If export crashes for some reason, error message should be logged in execution log

    ===== 2.5.7 =====
    * Improved multi-source inventory (MSI) compatibility

    ===== 2.5.8 =====
    + [M2.2+] Added ability to update tier prices: https://support.xtento.com/wiki/Magento_2_Extensions:Stock_Import_Module#Updating_tier_prices
    * Added sample code to set configurable products to in stock/out of stock based on child products (for Magento MSI stores)

    ===== 2.5.9 =====
    * Fix performance issue caused by tier price import routine

    ===== 2.6.0 =====
    * Updated graceful die and removed sigint/sigterm as these are not really that much required and could cause issues

2.5.3:

  • Compatible with Open Source (CE) : 2.1 2.2 2.3
  • Compatible with Commerce using on prem (EE) : 2.1 2.2 2.3
  • Stability: Stable Build
  • Description:

    ===== 2.4.4 =====
    + Added ability to invalidate products in FPC when stock/product attribute is updated
    * Fixed error "A non well formed numeric value encountered ..."

    ===== 2.4.5 =====
    * Fixed issue when using "attribute update scope" feature: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[...]))'"

    ===== 2.4.6 =====
    * Fixed an issue for attribute update where attributes weren't updated if no value had been set for this attribute in the DB before

    ===== 2.4.7 =====
    * Fixed issue when updating custom product attributes while importing

    ===== 2.4.8 =====
    * Fix for updating certain product attributes such as visibility

    ===== 2.4.9 =====
    + Prepared module for Magento 2.3 MSI (Multi-Source Inventory) feature, will be finalized once 2.3 has been released
    * Fixed a bug for relative stock level updates not summing up correctly
    * Added note to relative stock update setting in backend to clarify how it works

    ===== 2.5.0 =====
    + Added ability to run arithmetic operations such as + - / * on imported values. Increase imported price by 20%, for example.

    ===== 2.5.1 =====
    + Added ability to import "min_qty" (Out-of-Stock Threshold)

    ===== 2.5.2 =====
    + Established compatibility with Magento 2.3
    + Added support for Magento 2.3 MSI (Multi-Source Inventory) feature. Import stock levels per source!
    * Fixed notice about "debug" being undefined when importing
    * Fixed "cost" not being importable for products where cost is "empty" currently
    * [2.3] Fixed source not saveable due to encryption error
    * [2.3 MSI] Fixed: Exception: No linked stock found

    ===== 2.5.3 =====
    * Removed calls to deprecated function "create_function" and replaced code with compliant equivalent

2.3.8:

  • Compatible with Open Source (CE) : 2.0 2.1 2.2
  • Compatible with Commerce using on prem (EE) :
  • Stability: Stable Build
  • Description:

    ===== 2.3.2 =====
    + In addition to the "price", you can now import "special_price", "cost" and product "status". (Makes the import slower. 1 sec per changed product)

    ===== 2.3.3 =====
    + Added (sample) code to adjust stock level by pending/processing orders in Entity/Stock.php - just uncomment it. (May require customizations)

    ===== 2.3.4 =====
    + Added additional safe-guard against unwanted cronjob imports in case the module is disabled
    + Removed "is module properly installed" check, not required for Magento 2

    ===== 2.3.5 =====
    * Deleting a profile also deletes the profiles cronjobs now, to avoid "zombie" cronjobs that don't do anything.

    ===== 2.3.6 =====
    * [Improved Magento 2.2 Compatibility] Added a RecurringData setup script that checks if an upgrade to M2.2 was performed, if yes, data structure in the profile tables will be changed from serialized to JSON automatically

    ===== 2.3.7 =====
    * Updated Xtento_XtCore to version 2.3.0
    * Confirmed compatibility with Magento CE 2.2.5 / EE 2.2.5

    ===== 2.3.8 =====
    + Added ability to update product attributes such as product name, weight, as well as custom product attributes. Makes the import slower.

2.3.1:

  • Compatible with Open Source (CE) : 2.0 2.1 2.2
  • Compatible with Commerce using on prem (EE) : 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    ===== 2.2.7 =====
    * Fixed error email notification: From email is now retrieved from system configuration ("ident_general/email")

    ===== 2.2.8 =====
    + Added support for M2ePro: Stock level updates are communicated to M2ePro now

    ===== 2.2.9 =====
    * Fixed bug when importing profiles from Magento 1 or Magento 2.0/2.1 via the "Tools" functionality of the module

    ===== 2.3.0 =====
    * Fixed "xtento_stockimport_mapping_get_fields" event, fields can be customized via the event now.

    ===== 2.3.1 =====
    * Fixed issue for relative stock update (not accumulating multiple SKUs in one file properly)
    * Fixed issue for "Tools" import functionality that could lead to an error when importing profiles
    * Updated Xtento_XtCore to version 2.2.0

2.2.6:

  • Compatible with Open Source (CE) : 2.0 2.1 2.2
  • Compatible with Commerce using on prem (EE) : 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    ===== 2.2.6 =====
    * Fixed email sending for email destinations/error notification on Magento 2.2+ (Error: "Call to undefined method Magento\Email\Model\Transport\Interceptor::send()")

2.2.4:

  • Compatible with Open Source (CE) : 2.0 2.1 2.2
  • Compatible with Commerce using on prem (EE) : 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    ===== 2.2.4 =====
    * Updated Xtento_XtCore to version 2.1

2.2.1:

  • Compatible with Open Source (CE) : 2.0 2.1 2.2
  • Compatible with Commerce using on prem (EE) : 2.0 2.1 2.2
  • Stability: Stable Build
  • Description:

    ===== 2.2.1 =====
    + Compatibility with Magento 2.2 established

2.1.8:

  • Compatible with Open Source (CE) : 2.0 2.1
  • Compatible with Commerce using on prem (EE) : 2.0 2.1
  • Stability: Stable Build
  • Description:

    Xtento_StockImport

    -------------
    CHANGELOG
    -------------

    ===== 2.0.0 =====
    * Initial stable M2 release

    ===== 2.0.1 =====
    * Established compatibility with other email transports such as Ebizmarts/Mandrill for debug message mailing.

    ===== 2.0.2 =====
    * CSV Processor: If a product exists in multiple rows of the import file, the qty is summed up.

    ===== 2.0.3 =====
    * Compatibility with Magento 2.1.0 established
    * Fixed SFTP source type, Net_SFTP library using namespaced class names now
    * Cronjobs for profiles which have been deleted are automatically deleted as well

    ===== 2.0.4 =====
    * SFTP source type is now working for Magento 2.0 and Magento 2.1

    ===== 2.0.5 =====
    * Updated composer.json to require XTENTO "XtCore" base module

    ===== 2.0.6 =====
    * Fix for change in Magento core tables introduced in Magento Enterprise Edition 2.1 for staging functionality ("entity_id => row_id")

    ===== 2.0.7 =====
    + Added event "xtento_stockimport_files_load_after" which is called after files have been loaded from sources, so third party developers can retrieve/modify files

    ===== 2.0.8 =====
    + If a new profile is created, "Set In Stock / Out of Stock" is automatically set to Yes by default now
    + Set grid column type for various columns in "Execution Log" to "longtext" so long result messages are not truncated on the grid
    * Fixed a bug for the "Additional Configuration" popup where & was converted to & automatically upon saving the configuration

    ===== 2.0.9 =====
    + Added bin/magento "xtento:stockimport:import" CLI command
    * Fixed "Tools > Import" functionality: Sometimes source assigned to an imported profile were not automatically assigned to the imported profile again.

    ===== 2.1.0 =====
    * Bug fix for stock update routine when inserting a new stock item; sometimes other fields such as price would be attempted to insert into stock_item table as well.

    ===== 2.1.1 =====
    * Fixed issues for manual imports where sometimes (especially in Internet Explorer, but also Chrome/Firefox) the profile drop down didn't work and no manual import was possible.

    ===== 2.1.2 =====
    * Fixed issue with profile configuration/profiles failing to load with error "... expects parameter 1 to be string, array"

    ===== 2.1.3 =====
    * Fixed bug for profiles imported using "Tools > Import" functionality: Cronjob import never started until the profile was saved for the first time; now cronjobs are updated directly after the import via "Tools"
    * Fixed "Webservice.php.sample" sample source file that was broken

    ===== 2.1.4 =====
    + Added "xtento:stockimport:config:export" and "xtento:stockimport:config:import" commands that add "Stock Import > Tools" functionality for the Magento command line via php bin/magento.

    ===== 2.1.5 =====
    * Updated Xtento_XtCore to version 2.0.7 ("Added warning in module configuration at System > Configuration if module output is disabled via "Disable Module Output" at System > Configuration > Advanced > Advanced")

    ===== 2.1.6 =====
    * Important update that fixes a bug where, if multiple profiles are executed in the same execution (for example via the cronjob), sometimes stock (and especially price) updates were ignored

    ===== 2.1.7 =====
    * Fixed relative stock level import that sometimes failed to work for summed up negative/positive values

    ===== 2.1.8 =====
    * Updated Xtento_XtCore to version 2.0.8

2.1.4:

  • Compatible with Open Source (CE) : 2.0 2.1
  • Compatible with Commerce using on prem (EE) : 2.0 2.1
  • Stability: Stable Build
  • Description:

    Xtento_StockImport

    -------------
    CHANGELOG
    -------------

    ===== 2.0.0 =====
    * Initial stable M2 release

    ===== 2.0.1 =====
    * Established compatibility with other email transports such as Ebizmarts/Mandrill for debug message mailing.

    ===== 2.0.2 =====
    * CSV Processor: If a product exists in multiple rows of the import file, the qty is summed up.

    ===== 2.0.3 =====
    * Compatibility with Magento 2.1.0 established
    * Fixed SFTP source type, Net_SFTP library using namespaced class names now
    * Cronjobs for profiles which have been deleted are automatically deleted as well

    ===== 2.0.4 =====
    * SFTP source type is now working for Magento 2.0 and Magento 2.1

    ===== 2.0.5 =====
    * Updated composer.json to require XTENTO "XtCore" base module

    ===== 2.0.6 =====
    * Fix for change in Magento core tables introduced in Magento Enterprise Edition 2.1 for staging functionality ("entity_id => row_id")

    ===== 2.0.7 =====
    + Added event "xtento_stockimport_files_load_after" which is called after files have been loaded from sources, so third party developers can retrieve/modify files

    ===== 2.0.8 =====
    + If a new profile is created, "Set In Stock / Out of Stock" is automatically set to Yes by default now
    + Set grid column type for various columns in "Execution Log" to "longtext" so long result messages are not truncated on the grid
    * Fixed a bug for the "Additional Configuration" popup where & was converted to & automatically upon saving the configuration

    ===== 2.0.9 =====
    + Added bin/magento "xtento:stockimport:import" CLI command
    * Fixed "Tools > Import" functionality: Sometimes source assigned to an imported profile were not automatically assigned to the imported profile again.

    ===== 2.1.0 =====
    * Bug fix for stock update routine when inserting a new stock item; sometimes other fields such as price would be attempted to insert into stock_item table as well.

    ===== 2.1.1 =====
    * Fixed issues for manual imports where sometimes (especially in Internet Explorer, but also Chrome/Firefox) the profile drop down didn't work and no manual import was possible.

    ===== 2.1.2 =====
    * Fixed issue with profile configuration/profiles failing to load with error "... expects parameter 1 to be string, array"

    ===== 2.1.3 =====
    * Fixed bug for profiles imported using "Tools > Import" functionality: Cronjob import never started until the profile was saved for the first time; now cronjobs are updated directly after the import via "Tools"
    * Fixed "Webservice.php.sample" sample source file that was broken

    ===== 2.1.4 =====
    + Added "xtento:stockimport:config:export" and "xtento:stockimport:config:import" commands that add "Stock Import > Tools" functionality for the Magento command line via php bin/magento.

Support

Back to top
The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Q & A

Back to top

Reviews

Back to top