Budget: 3500 UAH Deadline: 2 days
Hello! Working with OpenCart and importing data from Excel is a classic task where the devil is in the details (category matching, photo uploads, and stock updates). I specialize in e-commerce automation and database management, so I will help set up this process so you don't spend hours on manual uploads. Since you mentioned the Excel feed, the most important thing is to correctly "marry" your columns with the fields in the OpenCart database.
🛠 How I will implement the product import:
* Analyzing the structure of Excel:
* I will check your columns (SKU, Name, Price, Description, Availability, Photo).
* Important: If the photos in Excel are indicated by links, I will set up their automatic upload to your server.
* Choosing the tool:
* If this is a one-time task — I will use a professional Export/Import Tool module or Universal Import/Export.
* If the feed needs to be updated regularly (for example, daily from the supplier) — I will write a Python script or set up a Cron job that will automatically synchronize stock and prices.
* Preserving SEO structure:
* During the import, I will automatically generate SEO URLs (pretty URLs) so that the links to the products are understandable for Google.
* I will set up category matching so that products do not end up in "Main" but are distributed across their sections.
📋 Plan and cost (grounded in the market):
* Setting up mapping (field matching) and test import: 1 working day.
* Full database upload with photo and category verification: 1 working day.
* Total timeframe: 1–2 working days.
* Fixed cost: 3,500 – 5,500 UAH (depending on the number of products and the complexity of the category structure).
Why me:
As an automation specialist, I pay special attention to duplicates. I will set up the import by SKU: if the product already exists on the site — only the price and availability will be updated, if not — a new card will be created. This will allow you to update the site with one click in the future.
Bonus: I will set up an automatic database backup before the import for free, so in case of any error, we can instantly restore the site to working condition.
Please attach your Excel file or a screenshot of its structure. I will check the data and be able to provide an exact cost. When is it convenient for you to start the upload?
