Link Google tables with PRM and New Post.
51 USDNeeded to:
1.To upload the order information from the PRO to the Google table.
Create a new mail on the order data from the table.
2nd Analysis of sales data
Three Check the status of the shipment and draw them into a separate column.
4 . The line with the status of the shipment, stored for more than 3 days - distinguish by color.
and 5. Sendings that have begun with paid storage - make in a different color.
6.Send SMS by template with the number attached to the client through turbosms
Учет продаж и состояние заказов ведется в гугл таблице.
Необходимо:
1.Подгружать информацию о заказе из ПРОМа в гугл таблицу.
2.Создавать накладную Новой Почты по данным заказа из таблицы.
2. Вывести сводный анализ по данным продаж
3. Проверять статусы посылки и выводить их в отдельную колонку.
4. Строку со статусом посылки, хранящейся более 3 дней - выделять цветом.
5. Посылки, у которых началось платное хранение - выделать другим цветом.
6.Рассылать смс по шаблону с номером накладной клиенту через turbosms
The sales and order status are calculated in the Google Table.
Needed to:
1.To upload the order information from the PRO to the Google table.
Create a new mail on the order data from the table.
Three Check the status of the shipment and draw them into a separate column.
4 . The line with the status of the shipment, stored for more than 3 days - distinguish by color.
and 5. Sendings that have begun with paid storage - make in a different color.
6.Send SMS by template with the number attached to the client through turbosms
7 . Make a summary analysis of sales data daily: how many leads by sales sources closed,monthly:the amount of the sold goods in the art section( the data all in the Google table is available)
ИСПРАВЛЯЮ ОШИБКУ В ТЗ:
Учет продаж и состояние заказов ведется в гугл таблице.
Необходимо:
1.Подгружать информацию о заказе из ПРОМа в гугл таблицу.
2.Создавать накладную Новой Почты по данным заказа из таблицы.
3. Проверять статусы посылки и выводить их в отдельную колонку.
4. Строку со статусом посылки, хранящейся более 3 дней - выделять цветом.
5. Посылки, у которых началось платное хранение - выделать другим цветом.
6.Рассылать смс по шаблону с номером накладной клиенту через turbosms
7. Вывести сводный анализ по данным продаж-ежедневно: сколько лидов по источникам продаж закрылось,ежемесячно:количество проданного товара в разрезе арт( данные все в гугл табл есть)
Client's feedback on cooperation with Andrew Kr
Link Google tables with PRM and New Post.Google tables is a very cool, many underestimated tool.If you have complex business processes and there is no CRM system installed on them, then use this tool to quickly count and eliminate damage from the human factor.Andrei possesses this tool well.If he doesn’t know how to solve a task today – trust him, give time to find its solution and he will solve it in the best way and bring you a lot of very useful ideas to improve the results of the tasks.My project as a result of working with Andrew became more serious and a small account table in the Google account became a quality account system.What our "Sales" table knows, thanks to its creator:
All information from the Promo will be filled into the table automatically.(Errors + timewith the manager)
- not exceeding the table manager checks the order through a specially emerging window(realised offer of Andrey), checks during the call with the buyer, with confirmed order-this creates the TTN and "o,wonder" manager doesn't have to go to the Promo and change the status, transfer information from the Promo to the table and back, the scripts do everything themselves.(Errors + timewith the manager)
-All the plushes and the process of working the table itself in one review not to describe, just believe it works as it should.All the information is stored on the company’s Google disk with one large set, which allows you to better control sales and create any forms of reporting.As a result of the work on the project, we found a great employee.We continue cooperation.Advice to future customers – don’t rush the executive, take into account his proposals – he’s the case says)
Andrei, thank you for your cooperation.
Freelancer's feedback on cooperation with Anastasiya Sergeyeva
Link Google tables with PRM and New Post.It’s very easy and pleasant to work with Anastasia. It was an interesting task!
Always on contact, quick answers and correct details. It’s hard to work, but it’s good.
I will be glad to work again.
-
237 Good day, I have experience working with Google Table, I'm glad to take this work. I will be happy to cooperate!
Добрый день, есть опыт работы с Гугл таблицей, с радостью возьмусь за эту работу. Буду рада сотрудничеству!
-
1768 7 0 Good morning, I can do, I have experience working with various API including NP, turbosms, google sheets.
Доброго дня, можу зробити, маю досвід роботи з різними api в тому числі НП, turbosms, google sheets.
-
317 Good day . I don’t have a ready solution yet, but there’s an idea how all to realize, we can first discuss the details because you need to understand which tools with promotions you are still using and which are not. I am interested in more information on the last point.
Добрый день. Готового решения пока не имею, но есть представление как все реализовать, можем для начала обговорить детали тз так как нужно понимать какими инструментами с прома вы таки пользуетесь, а какими нет. И ещё интересует больше информации по последнему пункту
-
308 7 0 Welcome to! Immediately I will say I didn’t have to work with Prom and N.Posta, but the experience of working with API is, I hit both, as if nothing is not understood. I love to do my job.
Everything should be discussed in a detailed conversation.
Вітаю! Одразу скажу не доводилось працювати з Пром та Н.Поштою, але досвід роботи з АПІ є, погортав обидві, наче нічого не зрозумілого немає. Залюбки зроблю роботу.
Треба обговорити все при детальному спілкуванні.
-
3990 181 0 1 Good night, there’s a lot of experience working with API tables and API prom, but I can only do partly, not all tasks. Write to the page to discuss details if you are interested
Добрый вечер, есть большой опыт работы с API таблиц и API пром, но могу выполнить лишь отчасти, а не все задачи. Пишите в личку для обсуждения деталей, если заинтересует
-
94 Good day, there is the experience of working on the registration of the electronic mail in the personal office of New Post, the control of the mailing, the formulation of returns, re-addressing, the conduct of the claim work on the lost mailing and compensation by the carrier.
There is also experience with tables.
Everything needs to be detailed, time and cost. I think it’s not a job for a day.
Добрый день,есть опыт работы оформления электронных накладных в личном кабинете Новой почты, контроля за посылками,оформления возвратов, переадресаций, ведение претензионной работы по утерянным посылкам и компенсаций перевозчиком.
Также есть опыт работ с таблицами.
Нужно все детально оговаривать, сроки и стоимость. Судя по ТЗ это работа не на 1 день.
-
Есть готовый продукт api.in.ua
-
Current freelance projects in the category Data processing
[TM] BA Analyst - create 30 SQL queries for dataset
120 USD
Good day, there is a dataset consisting of 3 tables, need to create 30 SQL queries for it. Domain - ecommerce 5 simple queries for each table 2 complex queries with aggregations for each table 4 queries for table pairs with aggregation 5 queries for all tables at once I need… Databases, Data processing |
Automation needs to be done on make com (GPT + TG + Notion)Hello everyone, some automation needs to be done: 1. send a json file with the task to telegram (the file will have the same keys in json format) 2. Process the json in make com 3. Create the corresponding task in the respective teamspace in Notion Who has experience and… Machine learning, Data processing ∙ 1 proposal |
Add website names and contact emails to the table.
13 USD
There is a list of 278 media websites. It is necessary to add to the table the name of the media outlet to which each website belongs, as well as the contact email from the website. Simple task for 3 hours. Specify the price and time of completion. I will send the list of… Data processing ∙ 17 proposals |
Data table formatting and RFM analysis1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,… Databases, Data processing ∙ 6 proposals |
Restoring access to Google account
13 USD
Unable to log in to Google account. Google states a reason, as if there was some suspicious activity. I pass all checks, but when the field for entering the phone number appears, it says that this number cannot be used for login. And this happens with any number. Data processing, Customer support ∙ 3 proposals |