Terminé

Update products in Bigcommerce via API using sql server table in either php script or ssis

Summary:

PHP script or SSIS to update products on bigcommerce (api V3) using records in table on sql server

Details:

- fetch records from my table in sql server (over 20k records)

- use that data to update existing products in bigcommerce (e.g. updating categories, description, price, inventory or any other field)

- respect the bigcommerce api/hr limit (give me the option to set the limit in the script). Pause if the limit is reach and continue again next hr.

- automation : script will loop through sql server table and will post each record automatically to bigcommerce (update each product respectively) without me having to do anything in between manually

- You may create this script in php or SSIS. Just fyi I am using xampp as our local server for running php. For both php and SSIS provide screen shots or video (and C# codes if required for SSIS). I have basic knowledge of ssis and very little of php (with no coding skills on neither SSIS nor php)

- Lastly error handling : skip to the next record in sql server upon error and create a log for any errors (log should contain atleast 2 fields “sku number” and “what caused the error”

Full automation is the goal here. Hence PHP or SSIS should be able to loop through the records from sql server and perform actions on bigcommerce automatically.

I am told this is not a hard job. Make an offer.

Compétences : API, BigCommerce, PHP, SQL, SSIS (SQL Server Integration Services)

en voir plus : website project aspnet using using sql server, import csv data sql server table, sample pos system project using sql server, create sql server table csv file, inserting xml file sql server table, net sql server table write excel pivot, using sql server jsp dreamweaver, payroll software using sql server, save image sql server table, hotel management system using sql server 2000, save image sql server table using java, wwwgeotv using sql server access, rdbms experience using sql server 2005, using sql server 2005 crystal report aspnet, vbnet update sql server table xml file, update records sql server table using vba odbc, update sql server table ado access form, sql server table script generator using, sms api using sql server 2008

Concernant l'employeur :
( 0 commentaires ) Canada

Nº du projet : #18004690

Décerné à:

julienmoutier

Hi, i'm expert in this kind of development (using PHP) and available for your project. I can get it done by tommorow. Feel free to contact me to discuss it further !

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(13 Commentaires)
4.4

22 freelance font une offre moyenne de $180 pour ce travail

Yknox

Hello~!! I am Yin and I read your post. But I have something to ask you. Your idea is amazing and it will change the world! I am a magic talented developer in your skill. If you wanna be the success, hire me I am Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(642 Commentaires)
8.9
VirasatSolutions

Hello, Greetings for the Day! Very clearly, We are a team of developers, working since last 8 years, highly skilled and well experienced, served numerous of clients before. You may have a look on few of our Bi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(83 Commentaires)
7.6
denizb16

Hello, My name is Deniz, I am a senior web developer. I can complete your tasks with Bigcommerce API within 12 hours. I have 10+ years of experience with PHP, CSS/HTML, JavaScript and MySQL. I am also very exper Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(116 Commentaires)
7.3
bengalTIGER1106

Hello i am kashirin in Vladivostok in Russia I read your proposal carefully and extremely Very interesting... as you can see my profile, i am a super and fast dev here i have rich experiences in php,javascript, ht Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(59 Commentaires)
6.2
an1566706

I read your project description ………..and we are very exited to work on it We are an group and we have an expert & qualified to accomplish your project in professional & unique We are working all section of int Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(39 Commentaires)
5.8
sun0815

Hi I can make the script using php for your project I have full experiences in php api works And the database handling So can deliver the result in the short time We can discuss more via chat Kind regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(39 Commentaires)
6.1
websolutioner

Hey, I'm interested in your project. Please send me a message so that we can discuss more thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(61 Commentaires)
5.6
schoudhary1553

Hello! Welcome to vibrant webtech and I was glad to see that you're looking for help for project Update products in Bigcommerce via API using sql server table in either php script or ssis. Please let me know whe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(39 Commentaires)
5.8
tangramua

Hello, I can update products in Bigcommerce via API. I’m a professional web developer with more than 17 years experience co can carry out all your requirements. My main specialization is LAMP stack of technologi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(17 Commentaires)
5.5
expertteamindia

Hello Employer, I hope you're doing well. I checked your requirements and understand you want fully automated scripts for Your bigcommerce website. I can do that in php please contact me. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(34 Commentaires)
5.1
justdotweaks

Hello, I have genuine skills in *PHP MVC frameworks such as Wordpress, Laravel, Magento*. *Ruby and Ruby on Rails *Angular, React JS, Node JS. Don't wo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(26 Commentaires)
5.4
surendramuduli

We are highly expertise and experienced to developed custom eCommerce website and CMS website using WordPress, Woo commerce, Big commerce and Shopify. Please talk to us, we will start work on it straight away.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(18 Commentaires)
4.6
vw7590795vw

Please message me. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8. 11 years experience in MS SQL Server and 6.2 years experience in SSRS, SSIS (Import / Export). Please let m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(22 Commentaires)
4.1
ashishcompwiz

I hold  a  good 3+ yrs experienced developer, specialized of php, laravel, HTML5, CSS3. I have been making  several live projects, out of which [login to view URL]  and [login to view URL] are the "best" ones.  “I possess good kn Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
3.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(11 Commentaires)
3.9
amaanwas

Hello Yes this is not difficult job.. The logic is simple 1- Create SSIS or .aspx page to get data from sql server table 2- Create php script to call bigcommerce api to update product using that data There ar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
3.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
3.6
pmegeniuszone

You are right this not the hard job but still the time taking. I am experienced developer and able to complete the job within 2 days so I wish to get $270 for the quality work. I have 10 years plus experience and I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
2.4
coriandercode

Welcome to my profile. I'm rich experienced with the developments of Desktop & Mobile App and Website . Your satisfaction is a duty for me, so I'll do our best on your project. ? 8+ years of experience in dev Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
3.3
sbansal62

Hi, I have worked in BigCommerce v2 API and I use PHP. If possible, please send me a sample of your sql table (the different columns and maybe a couple of rows of data), so that I have a better idea about what ki Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0