1 review
Availability:
In Stock
275 грн
Compatibility
2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2, 3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8
Localization
Russian, Ukrainian, English
All the features
Do not contain malicious code

The module allows you to import from almost any CSV, DSV, XLSX, XLS, YML files to all OpenCart 2 (all versions) and OpenCart 3 (all versions) builds

Key differences from other options

  • Export to XLS/XLSX format and Excel compatible CSV
  • When exporting, a standard selection of what to export, data selection by any value in the product table. For example, you can specify only with a non-empty SKU, and / or with a model that contains a certain prefix on the left / right, and / or with a quantity greater than or equal to 10 etc.
  • Parsing from remote sites using php, and / or xPath (inserting a handler when importing strings) and importing the result into any field of the product when processing a string (if you need parsing by description links, parsing pictures, etc.)
  • Adding your columns directly in the module, with logical conditions for the appearance of a particular text, depending on a particular content of adjacent columns. For example, you can create tags, meta tags, meta titles according to the scheme MANUFACTURER BUY PRODUCT NAME, etc.
  • Creating text from values ​​in adjacent columns of the import line (for example, to create categories by nesting or to get prices, etc.)
  • Inserting your php code at the start of the import
  • Inserting your php when processing a line, with the possibility of any data transformation in a line in each column
  • Import from YML formats, incl. extended with their tags, as well as any size due to a special application (for 10 thousand products, you need about +25 seconds of file preprocessing and 10MB of RAM)
  • Also available when importing YML: matching categories, creating any type of options from certain values ​​in the param tag, creating attributes from any param tags
  • When importing YML, all tags are visible, so they can also be imported into any product field
  • Deep logging, incl. with email notifications
  • Automation based on the smartExchange application - the application allows you to do processing on any hosting, with a convenient configuration interface right in the module. It is enough to put the application link on CRON, which will launch the application, for example, every minute. All the rest - order, loading schedule, and priorities of actions, consistent work, and adjustment to available hosting resources will be done by smartExchange. smartExchange - does not create a load on the hosting (does not use the connection and the database when it is not needed (no exchange tasks)). Tested already for YML update 800 thousand products, with 2GB RAM

How can a file be submitted?

  • Link to a remote server,
  • File
  • Zipped file

Acceptable file size and performance issues

The module uses special methods of working with files that do not require extra physical and RAM memory. However, if the files are much larger (hundreds of megabytes and hundreds of thousands of lines), you may need additional hosting resources. The highest costs arise when working with Excel files. Being a PC-format, this format, even in the XLSX version, requires additional resources, if we compare this format with text formats CSV, DSV

File requirements and formats

  • Any file encoding, any file feed (by link calling file or feed by module load)
  • Any file formats CSV, DSV with columns that have at least some names
  • Any Excel files , with the placement of data from the first line, with columns that have at least some names
  • Any YML , including some of their extensions. And also, if there are extensions in the form of tags in the offer, direct import of such data into any product data

Resource costs when working with YML

  • The module does not use standard parsing tools, so the performance is quite high, and the attitude to resources is as careful as possible. In particular, to prepare a file before import, with 10200 positions, the module needs about 22-26 seconds, and about 10MB of RAM. How to import files with a large number of products, and not go beyond the limits, is described in the instructions for the module

How many files can be at the same time

Any number of files at the same time, by saving settings profiles for each file

Basic capabilities

  1. Import of goods of certain categories, manufacturers
  2. Creating options from specific parameters (param) YML
  3. Creating attributes from specific YML parameters (param).
  4. Dozens more functions as part of working with their XML, YML data
  5. Import with preview data in tabular form in CSV format
  6. The module solves all popular tasks


Automation

  1. Automatic export via link
  2. Automatic import via link
  3. Automatic import and export through the built-in OCext smartExchange system with task launch schedule right in the module


Adaptation to hosting performance

  1. Normalization of the exchange by the number of processing lines to adapt to the hosting capabilities
  2. Caching of the results of functional requests to the database
  3. Removal of temporary data, during operation - increase in speed during import


Actions with a group of goods before import

  1. Flexible search for the desired products, even those that are not in the file (search for products that need to be pre-processed by keywords, prefixes on the left, on the right in certain fields of the product)
  2. Group actions with the product (conditional balance reset, conditional product exclusion, etc.)


Additional settings

  1. SEO alias generator (categories, products, manufacturers)
  2. Arbitrary (any) name of the columns of the file
  3. Clearing similar values ​​before importing (for example, clearing additional images or option values ​​or product categories before importing those values)


Identification of goods during import

  1. Identification by any custom field in the product, as well as by article number, model or product_id
  2. Identification by product name, image name
  3. Automatic creation of a prefix in the identifier during import and checking during import according to this prefix


Import attributes

  1. Separate import of attributes


Importing attributes into products

  1. Import of attributes by values, through an arbitrary separator, with the creation of an attribute and a group of columns, or with binding to attributes that are on the site.
  2. Importing attributes by attribute values ​​and names, through an arbitrary separator, groups from column names, or with binding to groups available on the site
  3. Import attributes by values, attribute names, group names through an arbitrary separator


Import categories

  1. Separate import of categories


Import of manufacturers

  1. Separate import of manufacturers


Import of manufacturers into goods

  1. Import of manufacturers by manufacturer name during product import
  2. Import manufacturer by manufacturer_id


Import options

  1. Separate import of options


Import options into products

  1. Import options Micromarkup 1: checkbox | Size | XXL | 0 | 57 | 1|+|10| -|20|+|0| http://site.com/img/sizexxl.jpg|sizecolor001299 |SKU-112998
  2. Import Options Micro Layout 2: Size | XXL | + | 10 | 251 | http://site.com/img/ sizexxl.jpg | sizecolor001299 | SKU-112998
  3. Import options Micromarking 3: XXL-5; XL-1-255-1; M-5-1-0; L-4;
  4. Import Price-Quantity options via an arbitrary separator: 300.5|150.12|250.27
  5. Identification of options by arbitrary option code and article number in the product option value
  6. Importing options The name of the options, indicating the rest of the parameters from the existing options on the site or other columns of the file


Import reviews

  1. Separate import of reviews


Import of product categories

  1. Import categories with nesting via an arbitrary delimiter
  2. Import categories with placement of nesting levels by columns


Data source

  1. Authorization when receiving a file (Basic Access Authentication, RFC 7617)
  2. Unzipping from a ZIP archive
  3. Import by remote link
  4. Import from file


Logging and reporting

  1. log mail
  2. The log is detailed
  3. simple log
  4. Notice to mail about completion


Logical import of other product data

  1. Import of related goods by articles
  2. Import into custom fields of product tables, product options, product attributes


Work with images

  1. Import images by links/paths using an arbitrary separator, with the formation of the main image from the first link
  2. Processing of images with Cyrillic names, spaces and other non-standard elements in the names
  3. Import images by link using CURL (increases the speed of working with images when importing)
  4. Cropping images during import
  5. Import images by link using file_get_contents


Working with leftovers

  1. Residual formation by statuses
  2. Direct import of quantities into products, into product options


Work with the price

  1. Pricing by coefficients
  2. Pricing by ranges of price values ​​in input data, by intervals
  3. Currency converter


Working with language and coding

  1. Choice of content language
  2. Encoding and conversion to/from UTF-8, Windows 1251, Windows 1252
  3. Import modes
  4. Import mode — update and insert new, update only, new only
  5. An additional mode of import is the insertion of novelties


Comparison of data

  1. Category mapping (comparison of site and file categories)


Save settings

  1. Save settings to a file to transfer settings between sites (version 7 and above only)
  2. Types of exported data
  3. Export of orders, with a selection of columns


Import formats

  1. CSV import
  2. Excel import
  3. Import from YML format, with additional settings and adaptation of the YML file


Export formats

  1. CSV export (including compatible with Excel)
  2. Excel export


Selection of data for export by value in the product table

  1. Creating your own columns with the import of arbitrary text
  2. Creating text to import from adjacent columns
  3. Parsing xPath
  4. Insert php that is executed before import
  5. Insertion of php, which is performed when importing each row, with the ability to override values ​​in columns, create conditions, etc.


Characteristics

Compatibility
2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.3.0.0, 2.3.0.1, 2.3.0.2, 3.0.0.0, 3.0.1.1, 3.0.1.2, 3.0.2.0, 3.0.3.0, 3.0.3.1, 3.0.3.2, 3.0.3.3, 3.0.3.5, 3.0.3.6, 3.0.3.7, 3.0.3.8
Localization
Russian, Ukrainian, English
Ocmod
Yes
Reviews: 1
Ілона Микуляк
11/10/2023
Працює, Опенкарт 3.0.3.8, встановили легко
Questions: 0

No questions about this product.

Instructions for installing the module:

  1. Before performing any actions related to the installation of the add-on in Opencart, we recommend creating a backup copy of all site files and store database;
  2. Install the localcopy fix (if you haven't installed it yet)
  3. Download the module file for the desired version of Opencart from our site (Follow the installation instructions if there is one in the archive with the module);
  4. Then go to the "Installing applications/extensions" section and click on the "Download" button;
  5. Select the downloaded file and wait for the complete installation of the module and the appearance of the text "Application successfully installed";
  6. After that, go to the "Application Manager" and update the modifiers by pressing the "Update" button;
  7. Before these actions, you need to add rights to view and manage the module in the "User groups" section for the administrator, or other users of your choice, by clicking "Select all"
After completing these steps, your module will be installed and ready to use, and you can start configuring it!

Similar products
Module Stickers for products for OpenCart
The module adds the ability to display stickers in all standard modules, pages, product cards. Sticker types: New - disp..
  2 reviews
420 грн
Module Additional tabs in the product card for Opencart
The module allows you to add as many new tabs (tabs) as you like in the product card on Opencart 3. Additional tabs ar..
195 грн
Ocmod Editor module for Opencart
This extension was developed without OCMOD format, and has the objective of enabling the administration of OpenCart fu..
  1 review
0 грн
Module Notify When Available for Opencart
Opencart 3.0 module for automatic product receipt notifications for subscribed customers. When a product is out of stock..
420 грн
Your discount: -39%
Module Logging actions of admin panel users for OpenCart
Module Logging actions of admin panel users for OpenCart
The module allows you to log user actions in the store admin panel. Due to the presence of settings, the action log c..
245 грн 150 грн
Easy checkout module for Opencart
The standard processing of an opencard order is very inconvenient for the buyer!This problem will no longer be relevan..
120 грн
Search module - search with autocompletion PRO for Opencart
What does this module do? The module adds the functionality of autocomplete results to the standard search..
380 грн
Module Search system with morphology and relevance PRO for OpenCart
This is a search module  for stores that need high-quality and fast search.  That is, for almost all stores, b..
570 грн
Form Builder module for Opencart
The module for creating Opencart 3.0 forms is a powerful tool for communication with customers. You can create as many d..
320 грн
Module multicurrency products for Opencart
The module allows you to set the prices of goods in different currencies. In the product editing form on Opencart, a cur..
235 грн
Categories
Latest reviews
Module Payment by banking applications to an IBAN account
Module Payment by banking applications to an IBAN account
Саме те що я шукала! Тепер немає потреби вручну клієнтам вводити рахунки, всіх відлякували реквізити..
16/02/2024 Тетяна Завадська
Modifier Installation of arbitrary codes
Modifier Installation of arbitrary codes
Модуль врятував ситуацію, коли в шаблоні треба було внизу сторінки розмістити інформацію про магазин..
14/02/2024 ОлежкаКом
Nova Poshta - city autofill and branch selection for OpenCart 3
Nova Poshta - city autofill and branch selection for OpenCart 3
Супер! Давно хотів щоб в корзині підтягувалися відділення! Модуль перевірив на своєму магазині, все ..
06/02/2024 Мирон Русланович
Nice Template for OpenCart 3 (Free)
Nice Template for OpenCart 3 (Free)
Отличный шаблон, намного лучше дефолтного, установил на последний опенкарт 3.0.3.9..
02/02/2024 Руслан Скоропадський
Blog
OpenCart 3.0.3.9
Blog 23/12/2023 174
OpenCart 3.0.3.9
OpenCart 3.0.3.9 was released on October 16, 2023. Unexpectedly, two years after the last release ..
Website optimization moving to FastCGI (Nginx + PHP-FPM) Opencart, WordPress
Blog 07/11/2023 264
Website optimization moving to FastCGI (Nginx + PHP-FPM) Opencart, WordPress
If you want to optimize your site's speed, switching to FastCGI (nginx + php-fpm) can be an effe..
PHPExcel library for Opencart and OCStore
Blog 23/09/2023 302
PHPExcel library for Opencart and OCStore
The PHPExcel library is used for processing table files in Excel format: .xls, .xlsx. In general, th..
SQL queries for cleaning data in OpenCart - useful tips
Blog 20/09/2023 236
SQL queries for cleaning data in OpenCart - useful tips
When creating a new store or restarting in OpenCart, sometimes it is necessary to clear data such as..
Why does the module for Opencart not work and how to fix it?
Blog 28/08/2023 317
Why does the module for Opencart not work and how to fix it?
If a module is not functioning properly or an error occurs after installation, it is important to co..