No reviews found
Module "Import PRO: CSV with auto recognition of fields, creation of characteristics" for the CS-Cart online store
The module allows you to significantly simplify and automate the process of importing goods. The main functions of the module:
- Automatic matching of the fields from the file with the fields of the product card;
- Import moderation;
- Automatic creation of characteristics.
This module allows you to automate the configuration of the import of goods, simplify the verification of import settings, creates new characteristics, normalizes delivery parameters and much more. Thanks to him, the import of goods instead of several hours, is configured in just a few minutes.
Automatic field matching
You upload a vendor file with information about the products. The module automatically matches the fields from the import file with the fields of the product card, focusing on the previously gained experience. We have created a self-learning matching algorithm. It remembers exactly how you match the fields and creates a mapping directory.
After you upload a new import file, the algorithm looks at the fields in the file, compares them with the directory and substitutes the corresponding fields in the preset. A person can only visually double-check the comparisons and, if necessary, disable or correct the comparisons.
Restricted display of fields for the store
CS-Cart supports a huge number of different fields for the product card. So that you don't have to scroll through a huge list of fields every time when matching, we have taught our module to hide extra fields that are not used in the work of the store.
After your administrator downloads the file and clicks the "Import" button, the file gets checked by the store administrator. The administrator checks the file, makes sure that it contains all the necessary information, checks whether the fields are correctly matched, and so on.
After that, he approves or rejects the import. The responsible moderator must be notified about the results of moderation. The administrator selects the notification text from ready-made response templates. Example of the template for rejecting an import file: "Import rejected, there is no parameter in the file for calculating delivery."
If the administrator does not find a suitable one among the ready-made templates, he can enter his message with a free field.After that, he clicks the "Approve" or "Reject" button, and the moderator receives a notification about the results of moderation.
If the import is rejected, he will be able to understand what is missing in the file, correct it and upload it again.
Importing goods, updating balances, adding new goods
With each new import, the product card is completely overwritten, which greatly loads the system with meaningless actions. Therefore, we recommend creating separate imports for three different cases:
- Initial loading of goods: all fields required to create a product card are compared;
- Updating balances: only three fields are matched – article, price and quantity;
- Adding new products: in the import settings, in the "import strategy" item, select the option "Create only new products".
This will significantly reduce the load on the system with regular import of leftovers.
And in order to speed up the update process, we have shortened the chain of actions required for re-import. The administrator checks and moderates the import only during the initial download. In the future, if the file structure remains unchanged, the file does not go to moderation.
But if the provider changes the structure of the file for some reason, then it will be checked by the administrator again. This is necessary to ensure that the product information is loaded correctly.
Automatic creation of characteristics
In order for products to be displayed correctly in the site search, before uploading them to the site, it is necessary to create characteristics for them. Our module does this automatically after the field matching is completed.
If, when creating a characteristic, you do not specify the category in which it should be displayed, then it will be available for all categories in all products. Even for those in which it is absolutely not needed. For example, products from the category "Electronics" and from the category "Clothing" will have completely different characteristics. Such characteristics as "Size" with options "42, 44, 46" and so on, or material with options "Knitwear, cotton, silk" and so on are absolutely not important to the smartphone. Similarly, a T-shirt does not and cannot have a "Screen size" characteristic.
If all the characteristics are available for all categories, you will have to scroll through the entire list of characteristics when creating a product card until it finds the right one. And then the buyer will also have to scroll through filters with "Screen Size" characteristics when searching for a T-shirt.
In order to avoid these difficulties, our import module creates characteristics immediately for a given category. Assigning characteristics to specific categories makes it easier to work with characteristics. Ensures that each category has only relevant filters for it.
Types of characteristics
Select the correct type for each characteristic in the file:
- To search for products;
- Variation as one product;
- Variation as a multiple commodity;
- Free input field.
The first type of characteristics is used when creating filters to search for products on the site. The second and Third are for combining similar products into variations. The fourth is for the correct display of characteristics containing a large amount of information. For example, it can be a characteristic "Certificate of goods from the manufacturer".
Fields with different types of characteristics can also be disabled.
Filling in delivery parameters
The delivery parameters are very important information about the product, as it is necessary for the correct delivery of the order through transport companies. At the same time, it is very important to normalize this data.However, in practice it turns out that each supplier has its own units of measurement in the file: someone measures the weight in kilograms, someone in grams, someone writes down the dimensions in centimeters, someone in meters. And the store and transport companies have their own set units of measurement. As a rule, transport companies on their side make all measurements in centimeters and kilograms.
And it's good if the dimension of the supplier is indicated in the column, then the administrator, when comparing fields, immediately sees whether the dimension in the file corresponds to the dimension accepted in the store. Then, if the units of measurement do not match, it is enough for the administrator to specify a modifier that will allow you to bring the delivery parameters to the units of measurement accepted on the marketplace.
However, some suppliers specify the dimension directly in the cells for each product. And, often, they do it in different ways: abbreviated, completely, with a dot, without a dot, with errors, and so on.
For example, the store's default length is measured in centimeters (written cm), and weight in kilograms (kg). The new supplier also has a length in centimeters, but the dimension is indicated differently – SEE – in large letters and with a dot. And he writes down the weight in grams and also denotes G. – with a capital letter and with a dot.
Previously, I had to download a file, figure out in which units of measurement the delivery parameters are given, manually convert them and download the file again. Or return the file to the supplier, coordinate changes with him, wait for a new file. Both options are very long, it distances the seller from the start of sales and loads your employees with extra work.
We solved this issue at the import setup stage. You specify multipliers for converting some units of measurement to others and aliases for them. The algorithm scans the file and, if it finds any of the specified aliases of the unit of measurement, applies the specified multiplier to this cell. At the output, you get the weight or size of the product in your units of measurement.
Delivery parameters are specified in one cell
Sometimes the supplier indicates the dimensions of the goods in one cell separated by a separator: a multiplication sign, a semicolon or any other. For example: 10x40x35, or 10;40;35, or 10*40*35 and so on.
To recognize such a record and correctly transfer the data to the fields of the product card, you only need to tick the box with the appropriate separator: x, *, ; and so on.
Downloading large files
Often stores are forced to impose restrictions on the size of the import file. This is due to the fact that it is necessary to allocate server resources to download a really large file. And this can negatively affect the work of the entire store. But after all, the site is responsible for interacting with customers, and it should not suffer under any circumstances.
We have come up with a different solution that allows you to upload files of any size and not slow down the site. The module splits the import file into smaller files of 200-300 products and loads them one by one.Moreover, even if there is an error in one of the lines of the file, for example, some important information is missing, the algorithm will not stop the download. He will try to read the problematic line again, and if it still does not work, he will simply move on to the next product.
Interaction with other modules
The module actively interacts with the modules "Seller characteristics" and "Grouped characteristics". Read more about the operation of these modules in their descriptions.
Regular loading of leftovers
If the imports are downloaded not as a file, but with a link to a file on a third-party site, it is possible to configure regular downloads. This is necessary to keep up-to-date information about the remaining goods and prices for them.
You set up the desired information download period and keeps the file up to date. The module regularly checks the download schedule, and when the time is given, it accesses the file again by reference and updates the data.
The module "Import PRO: CSV with auto recognition of fields, creation of characteristics and moderation of the supplier preset" allows you to automate the process of importing goods as much as possible, speed it up, and also reduce the degree of human participation at all stages of the process. You will need several times less time to process the import files.
- WhatsApp +7-923-364-90-07
- Telegram t.me/mauriswebru
- Telegram +7-923-364-90-07
- E-mail: [email protected]
- Store Builder
- Store Builder Ultimate
- Multi-Vendor Ultimate
- Multi-Vendor Plus
Our Maurisweb web studio is engaged in the development of automated online stores and marketplaces, as well as individual modules. We have been working since 2014, and during this time we have created more than 300 modules for the CS-Cart and CS-Cart Multi-Vendor platform.
For you, we have developed packages of modules and services for the development of online stores and marketplaces in the all-inclusive format: MWP - DBS in 15 days, eCommerce DBS in 30 days and FBO, FBO+, DBS, FBS in 90 days.
Fast and powerful search tool for your webstore. It allows to filter search results by categories directly in the search window. Modern and intuitive interface, it will be the best assistant for your customers.
The fastest and the most feature-rich search a free-of-a-monthly-fee alternative to cloud search services.
This module can tell you order channel - paid channel, referall, search engine, social networks.