Need a specialist for integrating Google Sheets with OpenCart

Good day.

I will set up the import considering duplicates.
There are modules and developments for integrating Google Sheets, OpenCart, and Google Apps Script.
Show me the table and I will suggest the right solution.

Show original

Translate

Hello.

I can handle the table, formulas, and import in OpenCart.

I have experience with OpenCart, PHP, MySQL, Google Sheets, product processing, data import, duplicate searching, and automating product updates.

What I will do:
- check the formulas in the table and the reason for the duplicates;
- organize the logic so that each product is unique;
… - check the current import mechanism in OpenCart;
- set up the upload of only new products, not the entire table;
- test the import on a small portion of data to avoid breaking existing products.

For an accurate estimate, I will need to see the structure of the table and how the import currently works in OpenCart.

I am ready to complete this in 3 days.

Show original

Translate

Good day! I have experience in completing such tasks. I have also worked with Google Apps Script and integration with OpenCart.

Show original

Translate

Good day! I will help you solve your problem, I have experience with complex formulas and Apps Script.

Show original

Translate

Hello, Andrey!

Our IT company creates and improves websites that operate stably, quickly, and solve specific business tasks for clients. We engage in developing websites "from scratch" as well as enhancing existing solutions, increasing their performance and user experience for your users.

We have experience in:
- developing responsive and fast websites on various platforms (WordPress, OpenCart, Shopify, WIX);
- integrations with payment systems, CRM systems, external services, and internal systems;
- optimizing website performance and security;
- setting up analytics and basic SEO tools;
… - software development and business process automation: managing customer databases, resource accounting, automating repetitive tasks, integrating with third-party systems;

After completing the project, we provide 14 days of technical support, during which we help adapt the system to your final business processes and consult on any questions regarding the completed work area. Thanks to the free support of the completed project, this allows you to be confident that the developed solution operates stably from the moment of launch and does not require any additional adjustments.

We work in a structured and responsible manner - focused on results that meet your business goals.

Show original

Translate

Hello. I have experience with OpenCart and Google Apps Scripts. I am ready to collaborate.

Show original

Translate

Вітаю! Готова виконати інтеграцію таблиць

Роботи:
🔗 elenis.com.ua
🔗 kontur-sb.com.ua
🔗 www.dosvit.com.ua
🔗 berberis.agency
🔗 avic.ua
🔗 ald.com.ua
… 🔗 diy-ceiling.com.ua/

🔹 Дизайн сайтів з нуля/редизайн
🔹 Верстка: HTML, CSS, JS, SQL, Sass
🔹 Розробка мобільних додатків та Telegram-ботів

Працюю з:
🔹 WordPress — Elementor — WooCommerce
🔹 OpenCart
🔹 Shopify
🔹 Webflow
🔸 Laravel • React Native JS • Vue

Hello. I have thoroughly reviewed your task regarding the optimization of the table and the setup of the import in OpenCart. The issue with formulas that generate duplicates is well known to me, and it is usually resolved by correctly applying arrays so that each product has a unique identifier without the need for manual editing. Regarding the speed of import, loading the entire price list each time is indeed very bad practice that overloads the site's database. I will address this by writing a custom Google Apps Script. The script will automatically filter the table and send only those products that have not yet been uploaded, marking them after successful export. This will speed up the database update process by tens of times and relieve unnecessary load from your server. I have extensive experience in automating similar processes and will be able to set everything up turnkey. Could you let me know if you are currently importing products into OpenCart through any ready-made import module or if you have a direct integration set up via the site's API?

Show original

Translate