CSV, XML, CommerceML import queue (My Warehouse, 1C, Class365) for an online store

Module CSV, XML, YML, CommerceML import queue (1C, MoySklad, Klass365 company programs)

The module builds a queue of created imports uploaded by the administrator, reducing the likelihood of errors when writing information to the database, as well as reducing the load on the site, as well as reducing the risk of errors during parallel operation of several import modules.

Import of goods from different suppliers

There are several options for mass downloading information about new products from suppliers:

• Uploading a file in CSV format - (A text format designed to represent tabular data);
• File download in XML format - (files are written in a special markup language similar to HTML of web pages);
• File download in the format YML - (Standard YML(YandexMarket Language) developed by Yandex and based on the standard XML);
• Downloading a file from warehouse accounting programs in the format CommerceML – (Unified standard for the exchange of commercial information in XML format. The standard provides for the use of XML schemas, in particular, for the exchange of: product catalogs in catalog management systems.)

But the more suppliers you have, the more questions you have about how to streamline the import process.

If you run all the available imports at once, they will all access the database at the same time and make changes to it. This greatly increases the risk of recording errors. In addition, at this point, customers may have difficulty downloading product information. The database with the goods will be occupied by imports. But it is much more important that customers can place an order and bring you profit.

It turns out that you will have to make a download schedule, calculate the time of the least load on the online store and run imports in turn. However, this is too troublesome, besides, the least load on the site is most likely at night.

Module functionality "CSV, XML, YML, CommerceML import queue (My Warehouse, 1C, Class365)

The Ministry of Defense created the "Import Queue" module precisely in order to simplify the solution of this task for you. It builds all import processes into a chain, and loads one at a time, thereby minimizing both the load on the online store and the number of simultaneous accesses to the database, which means the risk of errors.

You can also use this module to adjust the file download time. You can set up automatic file downloads at a time when, according to statistics, there are fewer views from buyers. And if there is an urgent need to upload a file, you can initiate the import manually by clicking on the "Import" button.

Detailed instructions for working with the module

The instructions are current at the time of publication. The module is regularly updated and improved. There may be minor differences in the control of the module.

CSV, XML, CommerceML import queue (MySklad, 1C, Class365)

The module arranges the order of imports to reduce the load on the database.

SCOPE OF APPLICATION

It is suitable for marketplaces with a large number of vendors who independently upload products to the site via 1C or using intelligent import.

APPLICATION EXAMPLE

In the case when a large number of sellers load a large number of goods, the module automatically queues imports and conducts it gradually, thereby not loading the system.

TECHNICAL SPECIFICATIONS

• Organizes the import queue;
• Allows you to import out of turn;
• Allows you to clear the import queue;
• Configures CRON queues and deletes imports.

COMMUNICATION WITH OTHER MODULES

Interacts with the modules "Import with moderation and auto-creation of characteristics" and "1C exchange".

MODULE SETTINGS

1. To configure the module, go to the "Modules" tab, select the "Module Management" item in the pop-up menu and the "MAURISWEB" section.

2. In the list that opens, select the module you are interested in and click on its name, highlighted in blue or black.

3. On the page that opens, select the "Basic" tab.In case the license key is not set automatically and the module settings are blocked, log in to your account at www.maurisweb.ru copy the license key and paste it into the appropriate item. The key has also been sent to your email address.

4. In the "Available domains" and "Test domains" sections, check the validity of the specified domains. You can add additional domains by clicking on the white "Add Domain" button on the right side of the page. The total number of domains should not exceed three.

5. Go down below, select the "Basic settings" section and check the box "Save data when deleting the module" so as not to lose them when reinstalling the module.

6. Go to the "CRON" tab and in the "Period for deleting completed imports" item expand the list and select the desired period when already completed imports will be deleted: "Day", "3 days", "Week", "2 weeks", "Month", "Six Months", "Year".

7. To set up import from the CRON queue, enter the appropriate command in the scheduler.

8. To set up queue cleanup, enter the appropriate command in the scheduler.

9. Save the module settings by clicking on the blue "Save" button in the upper right part of the panel.

MODULE FUNCTIONALITY

1. To set up an import queue, go to the "Administration" tab, select "Import data" and "Import Queue".

2. On the page that appears, a table will open listing all imports that were carried out through 1C or uploaded in CSV format (through the modules "1C Exchange" or "Import with moderation and auto-creation of characteristics"). The "Name" column displays the names of imports, "Queued" - the date of import processing by the module, "Started work" - the beginning of work with the import, "Finished work" - the end of work with the import.

3. To delete a specific import, click the blue gear-shaped button on the right side of the line and select the Delete function.

4. To delete several imports, select them by ticks in the leftmost column, click on the blue gear-shaped button in the upper-right corner of the panel and select the "Delete selected" function. To select everything, check the box next to the "Name" column.

5. To import out of turn, click on the white Import button in the upper-right corner of the panel. In all other cases, the import queue will run on CRON.