nulledaddons
Member
Demo link:
https://shop.ocext.com/anycsv-xls-import --eksport-v-csv--dsv--xls--xlsx--yml/predzakaz-tolko-dlya-50-klientov-anycsv-xls-yml-import-csv--xls--yml-i-fajlov- eksel-v-opencart-2--3-pro-edition
AnyCSV/XLS/YML module for importing CSV, XLS, YML, exporting CSV, XLS on OpenCart all versions. 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 of orders, products and related data to XLS / XLSX format (excel) and excel-compatible CSV
- Column editor (insert own columns for export and import, with text, parsing result, php, prefabricated text from other columns of the file)
- Creating orders to the supplier from store orders and sending such orders to the mail automatically
- When exporting, the standard selection of what needs to be exported, selection of data by any value in the product table. For example, you can specify only with a non-empty SKU, and / or with a model, which contains a certain prefix on the left/right, and/or with a count 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 own 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 the values in adjacent columns of the import line (for example, to create categories by nesting or to get prices, etc.)
- Inserting your own php code at the start of the import
- Inserting your own php when processing the line, with the possibility of any data transformation in the 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)
- When importing YML, the following are also available: 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, in including 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
https://shop.ocext.com/anycsv-xls-import --eksport-v-csv--dsv--xls--xlsx--yml/predzakaz-tolko-dlya-50-klientov-anycsv-xls-yml-import-csv--xls--yml-i-fajlov- eksel-v-opencart-2--3-pro-edition
AnyCSV/XLS/YML module for importing CSV, XLS, YML, exporting CSV, XLS on OpenCart all versions. 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 of orders, products and related data to XLS / XLSX format (excel) and excel-compatible CSV
- Column editor (insert own columns for export and import, with text, parsing result, php, prefabricated text from other columns of the file)
- Creating orders to the supplier from store orders and sending such orders to the mail automatically
- When exporting, the standard selection of what needs to be exported, selection of data by any value in the product table. For example, you can specify only with a non-empty SKU, and / or with a model, which contains a certain prefix on the left/right, and/or with a count 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 own 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 the values in adjacent columns of the import line (for example, to create categories by nesting or to get prices, etc.)
- Inserting your own php code at the start of the import
- Inserting your own php when processing the line, with the possibility of any data transformation in the 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)
- When importing YML, the following are also available: 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, in including 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