Reconnect supplier's product to Google Sheets using API
Hello,
I own an online auto parts store based on PretsaShop and, with the help of various files, I connect suppliers.
Background:
Half a year ago, a programmer friend connected a supplier using an API to a Google spreadsheet, set this file to update. Then, I connected this file from Google spreadsheet to the online store on PrestaShop. All the products were connected more or less correctly, the only issue was with the stock (on the PestaShop side, the product that disappeared from the Google file was not turned off).
Issue:
- Currently, the file in the Google spreadsheet, to which the supplier's products are connected via API, is not working stably (a lot of products are not added to the file).
- Issue with the supplier's product stock on my website (Prestashop). When updating the file, the product that is not in the Google spreadsheet remains unchanged (it should be turned off).
Task:
- Set up the Google file update so that the current information appears at least once a day.
- Set up the update of products from the Google file on the Prestashop side so that when updating, all products take all the current information from the file and, if necessary, are turned off.
!Important
If you have any ideas or experience to make it easier to load supplier products using API on the PrestaShop side (for example, without using the step with Google spreadsheet), then I will be happy.
P.S. I often connect different suppliers and plan to find someone who can do this. If you have experience in such work, I will be happy to continue our collaboration in the future.
Client's review of cooperation with freelancer
Reconnect supplier's product to Google Sheets using APIEverything was done quickly, on time! Oleksandr explained everything, answered all questions promptly, without delay.
Freelancer's review of cooperation with Ivan Vyacheslavovich
Reconnect supplier's product to Google Sheets using APIEverything is great, was glad to cooperate
![]()
-
2 days57 USD2 days57 USD
Hello Ivan, I can implement, contact me.
My stack: JS, TS, ReactJS, NextJS, SCSS...
-
1 day573 USD
8193 63 1 1 day573 USDGood day,
Ready to help with setting up the update of the Google file and products on PrestaShop. I will be glad to clarify the details and start working!
Looking forward to your reply.
-
1 day458 USD
3853 24 0 1 day458 USDGood day,
I specialize in automating business processes and developing online stores. I am ready to take on your project to set up updating the Google file and products on PrestaShop. I will solve the problem of the file's unstable operation in Google Sheets, ensure daily updating of current information. I will configure the updating of products on the website so that all products take current data from the file and can be disabled if necessary.
My rate is $16 per hour.
Sincerely,
Maxim
-
10 days287 USD
316 2 0 10 days287 USDGood afternoon, it is definitely easier to get rid of Google Sheets and integrate directly through the website.
-
3 days57 USD
109 3 days57 USDGood day, ready to perform your task. Ready to start working on the task.
-
Здравствуйте.
Откуда идут данные поставщика? Какой-то сайт, с которого грузится гугл таблица? Или у них своя таблица? Как это выглядит?
-
Current freelance projects in the category Javascript and Typescript
Support and development of the cleaning company's website
20 USD
I'm looking for a web developer/webmaster for long-term support and development of a cleaning company's website. Website: https://donely.ca About the project DoneLy Home Services is a cleaning service company in Canada that is actively growing and expanding its geographical… Javascript and Typescript, Web Programming ∙ 20 hours 43 minutes back ∙ 55 proposals |
Development of a website according to the specifications on FramerYou need to create a website based on the parameters in the technical specification. https://docs.google.com/document/d/1ODO2C9Krb4AaMiJz9wfbNzWlAyA2FwCCHL8r0biajUY/edit?usp=sharing Please provide your actual rate based on this design. HTML & CSS, Javascript and Typescript ∙ 1 day 21 hours back ∙ 26 proposals |
Development of an interactive Palworld map for the websiteWe need to develop an interactive map for Palworld based on the example: https://palworld.gg/map We need not just a static image, but a full-fledged interactive map where users can view locations, toggle object categories on/off, search for specific points, and interact with… HTML & CSS, Javascript and Typescript ∙ 3 days 12 hours back ∙ 32 proposals |
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5731 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 8 days 19 hours back ∙ 119 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 9 days back ∙ 21 proposals |