Closed

Automated Stock Update from Google Sheet to JShop MySQL Database

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]

技能: 数据库编程, Javascript, MySQL, PHP, 软件构架

查看更多: https://docs.google.com/drawings/, https://docs.google.com/, https://docs.google.com/document/d/1P91pjDiYz7TYLyZkYvKG2BLrKux4-BY8uJ8DA6MpOQI/mobilebasic, export google sheet to mysql, google spreadsheet to mysql database, google sheets database query, import google spreadsheet into mysql, connect google spreadsheet to sql server, convert google sheet to mysql, google sheets to database, jdbc google sheets, php, mysql, data processing, https://docs.google.com/spreadsheets/d/1BoluYWe-QeEmRDwp1nHYwzJw5AZwmHxdjsMlLuv8Lns/edit?usp=sharing, google org chart mysql database, insert excel sheet data mysql database using jsp, insert excel sheet data mysql database jsp, google calendar sync mysql database, google maps mashup mysql database

关于此雇主:
( 0个评论 ) Wrexham, United Kingdom

项目ID: #17175630

13 威客就此工作平均出价 £163

A2Design

Hello! We're a full-cycle team of 30+ web developers. Our team is interested in developing your project. Having the required skills, we will be glad to help you. We have some questions regarding your project, so p 更多

£350 GBP 在3天内
(109条评论)
8.6
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 在2天内
(183条评论)
10.0
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.

£90GBP 在1天里
(376条评论)
7.1
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 在7天内
(74条评论)
6.8
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 regard 更多

£50GBP 在1天里
(79条评论)
6.3
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 Projec 更多

£250 GBP 在3天内
(8条评论)
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 sys 更多

£200 GBP 在7天内
(47条评论)
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 更多

£150 GBP 在4天内
(13条评论)
4.8
redincorpindia

Dear client I saw your requirements regarding the stock update from Google sheet to mysql table using PHP. I can develop this application within a day maximum based on your requirements. I developed many applications 更多

£180GBP 在1天里
(13条评论)
4.4
£55 GBP 在3天内
(7条评论)
3.4
itspark01

Greetings! With well Experineced developer i am here to work with you. Our skill sets include:- Language:- PHP,Android,IOS,Python,ROR,Java Frameworks: CI, Laravel CMS:- Wordpress, Magento Database: MySQL 更多

£150 GBP 在3天内
(1条评论)
0.6
£250 GBP 在5天内
(0条评论)
0.0
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 在2天内
(0条评论)
0.0