Pulling prices via API for the Khoroshop website and fixing errors from the previous freelancer.

Interesting simple job
Ready to take it on
Let's discuss the details in private

Show original

Translate

Hello! The situation where synchronization works partially or "hangs" on old data is one of the most critical for an online auto parts store. This leads to orders for products that are out of stock and lost profits due to an outdated assortment.

Judging by the description, the problem lies in the logic of the integration script or import module. I am ready to stabilize the system.

🔍 Why these errors occur (technical analysis):
New products are not being pulled: The script is likely operating in "Update Only" mode. It only checks those SKUs that are already in the database and ignores new items from the supplier's API. The logic needs to be changed to "Upsert" (Update + Insert).

Availability is not updated: Often scripts skip items with zero stock to save resources instead of explicitly passing a status of "0" or "Out of Stock". There may also be a problem with data caching on the server side.

… Ignoring brand settings: Most likely, the filters in the code are set statically, and changes in the API interface are not read by the script with each request.

Distribution by categories: Currently, products are falling into one "folder" as there is no mapping logic between the supplier's categories and your sections.

🛠 My plan to solve the task:
1. Audit and correct the update logic (Update/Sync)
Detection of new products: I will configure the script to compare the full list of products from the API with your database. If an SKU is not present, it will be automatically created in the import folder.

Synchronization of stocks: I will implement a strict check: if a product has disappeared from the API or has a stock of 0, it will immediately acquire the status of "Out of Stock" on the site, but the product card will not be deleted (to preserve SEO positions and links).

Processing new brands: I will check the connection between the settings in the API admin panel and the export function so that new brands automatically enter the processing queue.

2. Automatic categorization (Auto Parts / Filters)
I will implement filtering logic based on keywords or supplier categories.

Example: If the name or category from the supplier contains the word "filter", "фільтр", "фільтруючий" — the product will automatically be directed to the "Filters" section. All other items (or by specified groups) will go to "Auto Parts".

3. Stability and security
I will set up error logging: you will see if the supplier's API did not respond or if there was a failure.

I will optimize the script so that it does not overload the server during the update of large price lists.

Show original

Translate