Spain
Portugal
anyCSV/XLS/YML module for importing CSV, XLS, YML, exporting CSV, XLS to 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) assemblies
Key differences from other options
- Export of orders, goods and related data to XLS/XLSX (excel) format and compatible with Excel CSV
- Column editor (inserting your own columns for export and import, with text, parsing result, php, combined text from other columns of the file)
- Creating orders to the supplier from the store's orders and sending such orders to the mail in automatic mode
- When exporting, the standard selection of what needs to be exported, the selection of data for 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 number 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 text depending on from one or another content of neighboring columns. For example, you can create tags, meta tags, meta tags according to the MANUFACTURER BUY PRODUCT NAME scheme, etc.
- Creating text from the values in the adjacent columns of the import line (for example, to create nested categories or to get prices, etc.)
- Inserting your php code at the beginning of the import
- Insert your php when processing a row, with the possibility of any data conversion in a row in each column
- Import from YML formats, including those expanded with their own tags, as well as of any size due to a special application (for 10 thousand products, it takes about +25 seconds. file preprocessing and 10MB of RAM)
- When importing YML, the following are also available: category mapping, creation of any types of options from certain values in the param tag, creation of attributes from any param tags
- When importing YML, all tags are visible, so they can also be imported into any field of the product
- Deep logging, 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. Everything else - the order, the loading schedule, and the priorities of actions, consistent work, and configuration for available hosting resources will be done by smartExchange. smartExchange - does not create a load on hosting (does not use the connection and database when it is not needed (there are no exchange tasks)). Tested already for the YML 800k update. products with 2GB RAM
Demo:
