Online product inventory

Here is a counter question: how is the integration with this CRM actually carried out? You mentioned Excel (I would like to take a look), how do they work? If Excel files are processed, then Google Sheets can also be handled. I would do it.

Show original

Translate

This is a very nice task. I see that you need to link your online product stock in Sitniks CRM with the data you receive from the supplier in an Excel file.

The problem is that Excel is a static file, while the CRM system requires an automatic or semi-automatic import. Integrating through Google Sheets is a great idea, and I can implement it.

Integration Proposal (Excel → Google Sheets → Sitniks)
I will develop a solution that will allow you to update product stock in Sitniks with just a few clicks and have full control over the supplier's data.

Why Google Sheets is the best solution:

… Centralization: You simply upload the new Excel file from the supplier to Google Drive, and the data is automatically updated in Google Sheets.

Processing and Control: Google Sheets allows me to write formulas for normalizing and validating data (for example, converting SKUs or checking availability) before they enter the CRM.

Connection to API: Google Sheets has powerful tools for automatically running scripts (Google Apps Script) that can send data to Sitniks CRM via API.

Work Plan:

Setting up Google Sheets: Creating a working file where the supplier's data will be imported.

Developing the Script (Google Apps Script): I will write code that will run on the Google side.

The script will take processed data from Google Sheets.

The script will call the Sitniks API (using the supply and inventory methods mentioned in the instructions) to update the stock.

Update Scenario: The final workflow will look like this:

You receive an Excel file.

You upload it to Google Drive (or simply copy the data into Sheets).

You click one button "Update Sitniks" (or the script runs automatically on a schedule).

Price and Terms
Estimated Cost: For the development and setup of the integration script on Google Apps Script (including error handling), I expect between 8,000 to 14,000 UAH ($200 – 350 USD).

Timeline: The work will take 5−7 working days.

You can check my experience in web programming and automation here: https://aleksandergladchenko.github.io/portfolio/.

To give an accurate price, I need a sample Excel file from the supplier to assess the complexity of its structure. I look forward to the details!

Show original

Translate