Budget: 1800 UAH Deadline: 1 day
Good day!!! I have a very large experience in working with spreadsheets, so I will complete the task you set quickly and efficiently!!! I am ready for discussion!!
Task: unify the structure of price lists from 10 suppliers and combine the result into a single file for further import/update of product items in ocStore (OpenCart).
Proposed tool: Microsoft Excel (Power Query, Macros, VBA).
Source description:
We will discuss in more detail with the performer.
Budget: 1800 UAH Deadline: 1 day
Good day!!! I have a very large experience in working with spreadsheets, so I will complete the task you set quickly and efficiently!!! I am ready for discussion!!
Budget: 5000 UAH Deadline: 5 days
Good day! Write in private messages, we will discuss the details, access, etc... Thank you...
Budget: 1234 UAH Deadline: 1 day
Hello.
I am ready to take on the task and bring it to a stable result.
I have experience in bringing heterogeneous price lists to a unified structure for OpenCart, including:
- normalization of different formats (xlsx, xml, json, Google Sheets)
- merging data from several files of one supplier
- working with large volumes (50k+ items)
- cleaning and standardizing fields (names, SKU, prices, stocks, languages RU/UA)
- preparing the final file for import and further updates
An optimal, simple, and flexible solution would be to do this in Python.
I can offer a structure that can then be easily expanded and maintained. I would like to see the sources. I am happy to discuss the details, thank you.
Budget: 2500 UAH Deadline: 3 days
Hello, I am ready to quickly and efficiently complete the task. I have experience in performing similar tasks. I suggest discussing the details in private messages.
Budget: 2000 UAH Deadline: 3 days
Hello)
Can I review the files? The execution time depends on the complexity.
Budget: 999 UAH Deadline: 3 days
Good day, how will their further updates (prices, stock, new products) be handled? Will you constantly be merging them? Perhaps it is worth setting up the import for each supplier separately, for example, through this module? https://opencartforum.com/en/files/file/811-automatic-processing-of-price-lists/ Write to me, we will discuss the details, I work with OpenCart constantly.
Budget: 2000 UAH Deadline: 3 days
Hello, Marina!
I am interested in your task. I specialize in data processing using Python.
Why I suggest Python instead of Excel/VBA:
You mentioned XML and JSON formats - Excel works with them slowly and often with errors, while Python processes them perfectly.
A volume of 50,000+ products - this is difficult for Excel (it may freeze), a script will do it in seconds.
My proposal:
I will write a script that reads all 10 of your price lists (in any formats) and generates a perfect, clean file for import into OpenCart.
Clarification: Do you need a ready-made consolidated file or a tool so you can do this yourself every day? (I can also create a convenient bot/program for this).
I am ready to look at sample files and get started.
Budget: 4500 UAH Deadline: 7 days
Good day, I am ready to help solve the task. Professional skills. I will propose an optimal solution, but I am interested in looking at the data sources first. Feel free to reach out.
Budget: 5000 UAH Deadline: 5 days
Ready to implement the task in Excel using macros. After preliminary familiarization with the forms and structure of the files, I will be able to provide a final answer regarding the completion of this task. I have experience in implementing a similar project for furniture suppliers.
Budget: 5000 UAH Deadline: 7 days
Hello! I have extensive experience working with Power Query and complex data structures (JSON, XML, API).
Since I have 3.5 years of experience in logistics and inventory management, I understand the criticality of data accuracy for product items (SKU, articles, stock). I will build a system in Excel that will automatically consolidate the price lists of all 10 suppliers into a single format for ocStore.
My approach: Using Power Query for automation, so you can update all 50,000+ items with the push of a button.
Estimated cost — 5000 UAH. Deadline — 5-7 days (considering the setup for each supplier).
Information Gathering 7 proposals 4 August
AI & Machine Learning 20 proposals 4 August
Online Stores & E-commerce 23 proposals 4 August
Information Gathering 7 proposals 4 August
Information Gathering 16 proposals 2 August