Automated Stock Update from Google Sheet to JShop MySQL Database

£20-250 GBP

Imefungwa

Imechapishwa

almost 6 years ago

£20-250 GBP

Kulipwa wakati wa kufikishwa

We've got a Google sheet that amalgamates stock from a variety of sources and have a summary sheet which displays a column of SKU's and the next column displays the available stock. Our e-commerce platform (JShop v2.4.0) utilises a MySQL database and we would like a script writing that takes the stock levels, matches the SKU's in the Google sheet to the ones in JShop and updates the stock on a periodic basis - say every hour. The Google sheet can be accessed as a tab separated file from a link like this: [login to view URL]

Software Architecture

Kitambulisho cha mradi: 17175630

Kuhusu mradi

11 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

11 wafanyakazi huru wana zabuni kwa wastani £162 GBP kwa kazi hii

@gangabass

I can provide you simple PHP script that will read tab separated file (from your last link), match SKUs from it with information in your MySQL database and next update stock level.

£90 GBP ndani ya siku 1

5.0

(393 hakiki)

7.2

@raisdhaka

Hello, I will write a php script and setup as corn job which will read data from google sheet and update MySQL Table. Corn job will run once in every hour. I am ready to start immediately. Regards Rais U

£80 GBP ndani ya siku 2

4.8

(205 hakiki)

6.9

@elbruninh

Hi, i'm interested, could you give me more details please? what MySql version are you using? can you send me the database structure (with data)? i can do a PHP script let me know if you are interested regards

£50 GBP ndani ya siku 1

5.0

(88 hakiki)

6.4

@sunilexpert

I am an expert in PHP, MySQL, script writing, JavaScript , web server etc. I have vast 15+ years of experience and understood what you are looking for, I will be able to do this job for you.

£200 GBP ndani ya siku 7

5.0

(74 hakiki)

6.0

@softcoats

Hi, I Read Through Your Requirement Regarding " Automated Stock Update from Google Sheet to JShop MySQL Database " Project and Understood what you need Exactly.. So Ping me Now and Let's Start working on your Project.. Best Regards Softcoats

£250 GBP ndani ya siku 3

5.0

(13 hakiki)

5.2

@camper2020

Hi there, I have quite a bit of experience with various ecommerce frameworks and have written several stock update feeds that use a variety of sources & formats. I believe I can help with your uodates Relevant Skills and Experience Over 10 years experience in web development and have built numerous sites and systems using various frameworks and from scratch. Have built several stock and price update feeds for online stores.

£150 GBP ndani ya siku 4

5.0

(16 hakiki)

5.1

@ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. All your requirements are achievable. Your MySQL system should be configured to accept JDBC requests from Google docs IP's. Thank you for your time ! John

£200 GBP ndani ya siku 7

4.9

(54 hakiki)

5.3

@danielkaye

I could code this for you and you could either call the script with a cron job or the script could run in the background. Let me know if you are interested and I'll get right on it!

£111 GBP ndani ya siku 2