Freelance projects

Freelance projects

Automation of price updates in the CSV table

— incorrectly specified categories?

31 USD

Client's review of cooperation with Andrey Karn

Automation of price updates in the CSV table

31 USD

First, he did earlier than he said in time. Second, he was constantly in contact. Thirdly, I did a lot of glory and more than I asked in the task - accumulated all kinds of check forms, a beautiful interface, even a couple of additional settings (configuration of columns numbers in the case if the supplier’s prizes will change). Again, everything is comfortable and in beautiful forms of interface. In general, good faithful and quality. I am very pleased with the job, the task is done at 200%.

5.0

Profile deleted

Reciprocal Feedback

20 February 2015

Freelancer's review of cooperation with client

Automation of price updates in the CSV table

31 USD

The most important thing - when the customer clearly knows what he wants, and knows how to formulate it) With this everything was great, as, however, and with all the others)) The task was clearly placed, constantly in contact to clarify the working moments, paid the work before the project was delivered, in a quick and convenient way. Everything is great! I recommend cooperation)

5.0

Andrey Karn

Reciprocal Feedback

20 February 2015

Project translated automatically. Log in or register, to view the original The task is to automatize the price update in our product table (.csv) according to certain rules, while these prices must be picked up from 7 different tables (supplier prices).So, the site on the bitrix loads the csv file with the product positions.There are both the fields of a unique identifier for each product assigned by a bitrix in the system and the fields with the item for this product from the price of the supplier.What's the problem: the items of different suppliers when charging in bitrix behave differently.More precisely, the problem is only with the items of only two suppliers, one starts at '0000 or 000, etc., these nols together with the tild are removed, and when the CSV is loaded the next time the items will be without these appendices.The other supplier has three nols after the item, they are also missing in the loading, because.Bitrix is removing them.This makes the process of updating prices a little more complicated by the VPR function.Yes and in general, it is tired every time to perform such a sculptural algorithm: 1) to sort the sculptural price by the supplier (this is a field in the supply), then the items of each supplier in the received sequence to be drawn into a separate book, 2) to be drawn the reduced price by the supplier (of each of them the sculptural price is required to be drawn up by the new fields of conformity with the "Articles of the price"), 3) to be drawn up by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by the sculptural price by sculptural price by the sculptural price by sculptural price by sculpturalBut this should be done in the earlier stage, when the spots are not yet replaced by points.All this process needs to be automated.Suppliers 7 and get out of a series of those 2 prizes, preventing making a fast VPR, where the supplier in the item adds a single coat with nules before the number of his item and the supplier that adds three gap after the item.They are also removed by the bitrix system when the goods are loaded into the csv file.If you can’t automatize the whole process, please inform you that at least you can.

Proposals 5

Andrey Karn

Winning proposal

5 0

Projects -
Rating -
Rating 67

Budget: 3000 RUB Deadline: 7 days

It would be interesting to try. I think you can organize automation with Access here. I would like to look at the templates of the prizes and the CSV file, and in what case - more detailed discuss possible options, deadlines and amounts. My email: [email protected]

Nikita Serafimovich

2 0

Projects -
Rating -
Rating 138

Budget: 5000 RUB Deadline: 7 days

Good day
I have an active experience in Excel with VBA macros for more than 4 years. He faced various tasks related to the prizes, the options of decisions vary depending on the situation.
If you’re interested in my services, you’ve come TZ and examples of files to mail [email protected] or write off here on the site.
with respect
Seraphimovich Nikita

Alex Kai

1 0

Projects -
Rating -
Rating 131

Budget: 5000 RUB Deadline: 5 days

I think all of this can be realised. He has done several tasks with the comparison/”squeeze” of prizes and orders. For more subjective conversation, I would like to see the samples of files.

Email - [email protected]

Didim Gersamiya
Moscow, Russia

Projects 3
Rating -
Rating 75

Automation of price updates in the CSV table

Client's review of cooperation with Andrey Karn

Automation of price updates in the CSV table

5.0

Freelancer's review of cooperation with client

Automation of price updates in the CSV table

5.0

Andrey Karn

Andrey Karn

Nikita Serafimovich

Alex Kai

Proposals concealed

Proposals are currently absent