Table / Software / Utility for analyzing competitors' price lists

Hello! I have experience in data processing and standardizing disparate information. I am ready to develop an algorithm for matching product names, taking into account possible variations from different suppliers. I can also offer a convenient format for outputting data for price analysis and help automate the update process. I would be happy to discuss the details and propose an optimal solution!

Show original

Translate

Task Execution Plan
1️⃣ Data Collection (parsing Google Sheets)
🔹 I receive links to price lists and check the availability of the Google Sheets API.
🔹 I use gspread + google-auth to read data into a Pandas DataFrame.
🔹 I analyze the structure of the tables (number of columns, order of data, possible discrepancies).

2️⃣ Normalization of nomenclature
🔹 I create a unified list of standard product names.
🔹 I use methods:
…
Fuzzy matching (fuzzywuzzy, RapidFuzz) to find similar names.
Preprocessing (lower(), removal of special characters, lemmatization).
Possible manual adjustments (if the client provides a standardized list).
3️⃣ Formation of a comparative table
🔹 I define the main parameters for analysis (name, price, brand, supplier, etc.).
🔹 I collect all obtained data into a single DataFrame.
🔹 I create a pivot table:

Products – in rows,
Suppliers – in columns,
Prices – in corresponding cells.
🔹 I add highlighting for the cheapest/most expensive offers (if needed).
4️⃣ Export of results
🔹 I export the final table to:

Google Sheets (API)
Excel (openpyxl)
CSV (for quick viewing).
5️⃣ Additional features (optional)
✅ Automatic updates (task scheduler).
✅ Visualization of price changes over time (matplotlib, seaborn).
✅ Analysis of average prices, deviations, anomaly detection.

Show original

Translate

Good afternoon
I offer my candidacy to solve this task
I plan to involve AI for the analysis of the nomenclature
For a more accurate assessment, additional data is needed:
✅Number of price lists
✅Average volume of nomenclature
✅Examples of differences in names

Show original

Translate

Good day!
I am ready to start collaborating!
Experience in similar projects - yes.
*details in private*

Attention!
If I indicated "1111" or "555" in the total bid, it means that I need more information to assess the project (also, deadlines may vary depending on the scope).

Show original

Translate

Hello! I have reviewed your project and am ready to start working. I guarantee high quality and prompt execution.

Show original

Translate

Good afternoon. I am ready to complete the task.
I have extensive experience in writing parsers and solutions for data analysis.
I code in Python and hold 2nd place on the platform.

I will develop a system for analyzing price lists. I will set up the logic for identifying products under different names. If necessary, I will integrate AI.
I will implement all the necessary functionality. I will create a user-friendly interface. I will optimize.
I will provide the necessary documentation.

My portfolio: Freelancehunt
… Write to me, we will discuss the details and I will start working.

Show original

Translate

Good day
I think this can be implemented in Google Sheets.
We need to take a look at the data you are using.

Show original

Translate

Good afternoon.

I am ready to help with your project. I already have ready-made solutions that partially meet your requirements and can be adapted to specific tasks. This will significantly reduce development time, although some adjustments will still be needed for full compliance with your expectations.

Important: without a detailed technical specification, it is difficult to accurately name the cost of the project. Many things can be done in a way that they simply work, but they can also be done with quality, taking all nuances into account. Therefore, it is worth first understanding your business requirements to select the optimal solution and calculate the budget.

If the project requires urgency, a team of developers can be involved to speed up the process. Personally, I can work alone as well — this will take more time, but it will help optimize costs.

Show original

Translate

Hello! I am Oleksandr, an experienced .NET developer with over three years of commercial experience, specializing in automating data collection and processing, as well as web scraping. I am ready to develop a solution for you that will allow automatic extraction of data from Google Sheets, normalize it to a single format, and create a summary comparison table for price analysis. I will take into account different variations of nomenclature and implement a flexible product matching system based on keywords, articles, or other parameters. I can offer my version of the structure or adapt to your requirements. I would be happy to collaborate and am ready to discuss the details!

Show original

Translate

Hello.
It's hard to assert anything without data - please share a sample of prices for analysis.

Show original

Translate

Hello.
Please write to me in private messages with examples of different suppliers' price lists, preferably with the items that overlap among them, for preliminary analysis.

Show original

Translate