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.

Proposals 6 Rejected 1 Discussions 1

Danish M.

20 0

Budget: 50 EUR Deadline: 2 days

Hello Ivan, I can implement, contact me.
My stack: JS, TS, ReactJS, NextJS, SCSS...

Artur Lavrinovich

63 1

Projects 63
Rating -
Rating 8 057

Budget: 500 EUR Deadline: 1 day

Good 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.

Maksym Sokolskyi

24 0

Projects 24
Rating -
Rating 3 828

Budget: 400 EUR Deadline: 1 day

Good 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

Denis Hatsko

2 0

Projects -
Rating -
Rating 316

Budget: 250 EUR Deadline: 10 days

Good afternoon, it is definitely easier to get rid of Google Sheets and integrate directly through the website.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Taras Zubyk

0 0

Projects -
Rating -
Rating 109

Budget: 50 EUR Deadline: 3 days

Good day, ready to perform your task. Ready to start working on the task.

Ivan Vyacheslavovich
Latvia

Projects 3
Rating -
Rating 221

Reconnect supplier's product to Google Sheets using API

Client's review of cooperation with freelancer

Reconnect supplier's product to Google Sheets using API

5.0

Ivan Vyacheslavovich

Freelancer's review of cooperation with Ivan Vyacheslavovich

Reconnect supplier's product to Google Sheets using API

5.0

Danish M.

Artur Lavrinovich

Maksym Sokolskyi

Denis Hatsko

Proposals are currently absent

Taras Zubyk

Current freelance projects in the category Javascript and Typescript

Automation based on Google Sheets for signing up for trial classes (online language school)

Fix the opening of Trust Wallet when clicking the link in the TikTok profile header.

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.