1b.app
Link copied -

Pick up goods from gestori pro

The client uses such software in the retail network - http://www.fit.ru/solutions/software/gestori/
It is necessary to take data on goods into the box
1. Will CRM OneBox be able to process the upload file with goods (is a CSV table file)??
This is a tar.gz archive weighing 6 megabytes.
The unzipped file is 67 megabytes.
Inside 23 columns and 330,000 product lines
A piece of the file, for example, in an attachment.
It is planned to do a daily full unloading and every hour to update the availability of goods, price and code of the cash agent.
2. Where can the client upload these files? Is it possible to send them via FTP in automatic mode, as it is now implemented for their site?
3. How long will it take to process such a file in CRM OneBox?
Original question is available on version: ru

Answers:


Zagatny Kirill wrote:
1. Will CRM OneBox be able to process the upload file with goods (is a CSV table file)??
This is a tar.gz archive weighing 6 megabytes.
The unzipped file is 67 megabytes.
Inside 23 columns and 330,000 product lines
A piece of the file, for example, in an attachment.
It is planned to do a daily full unloading and every hour to update the availability of goods, price and code of the cash agent.

The system does not have an action to import products from a CSV file.
If possible - upload in XLSX or XML format - there are import actions from such formats.
Development of an import action from CSV (line by line, with a separator) similar to other import actions - 12 hours.

2. Where can the client upload these files? Is it possible to send them via FTP in automatic mode, as it is now implemented for their site?

Actions can receive a file both from a local folder on the server, and via FTP | URL
If you can upload via FTP to the server - ok.

3. How long will it take to process such a file in CRM OneBox?

It is impossible to answer this question unambiguously - it all depends on the load on the server, the amount of imported data, the automation configured when editing the product, etc.
On vskidku - I do not think that it is faster than 2 hours, a lot of data. But this is just a guess.
19.11.2020, 14:20
Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment