Edit .xml file
Hello. There is a link to an .xml file, the structure of the offer is shown in the attached photo. In one offer, in the param name "Sizes", all product sizes are located. For updating the price and stock of the product, we need each size to be in a separate offer, an example based on the attached photo is in the file. This would be the ideal option. However, essentially the following solution would suffice. This solution was provided by the previous executor, but unfortunately, we have lost contact with him. It consisted of the following. An offer is taken and split into an excel table in the following form:
859393275-S 1135
859393275-M 1135
859393275-L 1135
That is, the offer 859393275 has three sizes S, M, L. The first column of the table takes the offer id and adds the size that this offer has, through a hyphen, in the second column, the price taken from this offer is added and duplicated for all sizes.
Next, if a size runs out and the supplier removes it from the .xml file, in the offer, one or more sizes disappear, it will be like this: <param name="Sizes">M, L</param> that is, the size S has disappeared. Therefore, it should also disappear from the table. So it should look like this:
859393275-M 1135
859393275-L 1135
That is, during the next update, the table is rewritten with the new values that are available at that moment, old values are deleted.
All of this was done in Google Sheets, updated once a day, we could download the excel file via the link, if needed, I will send this link.
Applications 2
-
1 day22 USD
1 day22 USD
Good day. I will do it in a day, I have already completed similar tasks multiple times. I will be happy to collaborate.
-
3 days22 USD
1490 28 0 3 days22 USD
I can do it, write for discussion, thank you,...................
-
1 day22 USD
3312 147 4 1 1 day22 USD
Good day.
I can complete your project. I will write the processing in node js.
If you have any questions, you can message me privately.
-
2 days22 USD
655 6 1 2 days22 USD
Good afternoon, Dmitry. I am ready to solve your problem in the form of an "ideal option." Please write to clarify the current data synchronization process.
-
3 days20 USD
1312 37 0 3 days20 USD
Good afternoon.
I have experience in creating Google Sheets and writing Google Apps Script.
Please show the link.
-
1 day45 USD
2622 427 9 1 1 day45 USD
I think I understood what you want to do, it won't be easy to accomplish, but maybe I already made a PHP script that adds available="true" to the offer. But here we need to break down the sizes and also change the offer id, and save the new XML format in which this will be broken down by new offers. So what should we do with the old offer where S, M, L are? Should we remove it from the XML document????
-
5 days25 USD
1770 20 0 5 days25 USD
I will write a script with deployment on my server and support for its operation. It will process XML and write to a Google Sheet at certain intervals. Maybe another option will suit you, we can discuss. Write to me, we will discuss the details and terms of cooperation.
-
3 days22 USD
3392 84 0 3 days22 USD
Ready to take it on.
But we need to clarify the order details, write!
I will implement it with a script in Python.
-
3 days34 USD
1322 13 1 3 days34 USD
Hello!
All of this can be done with formulas + Google Script.
I can help with the implementation of this task.
Write to me and we will work out the details.
-
Доброго дня. Тобто, вам потрібно синхронізовуватись з постачальником.
можна посилання або xml файл. маю досвід подібних завдань. -
Current freelance projects in the category Data Parsing
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 1 day 19 hours back ∙ 12 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 1 day 23 hours back ∙ 16 proposals |
Need to scrape data from LinkedIn
We need to scrape data from LinkedIn based on our list. For each entry, we need to find and collect available data if it exists on the LinkedIn profile, including the profile picture on the LinkedIn social network, email address, links to social media, company website, and… Data Parsing ∙ 2 days 5 hours back ∙ 27 proposals |
Parsing and classification of data
We are looking for a developer to implement a system for collecting and structuring data from open sources. We have a database of small business owners in the USA, which contains the person's name, company name, address, and state. It is necessary to build a process for… Web Programming, Data Parsing ∙ 2 days 6 hours back ∙ 41 proposals |
Svitlahata
17 USD
It is necessary to import 1819 products from the XML/YML feed of Prom.ua to OpenCart 3. A ready XML file is available, which contains product names, descriptions, prices, photos, specifications, manufacturers, and categories. Requirements: import all products to OpenCart… Content Management Systems, Data Parsing ∙ 3 days 9 hours back ∙ 34 proposals |
Kyiv