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


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


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

Skills: API, BigCommerce, PHP, SQL, SSIS (SQL Server Integration Services)

See more: 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

About the Employer:
( 0 reviews ) Canada

Project ID: #18004690

Awarded to:


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 !

$88 USD in 1 day
(13 Reviews)

22 freelancers are bidding on average $180 for this job


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 More

$155 USD in 3 days
(642 Reviews)

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 More

$388 USD in 5 days
(83 Reviews)

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 More

$150 USD in 0 days
(116 Reviews)

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 More

$155 USD in 0 days
(59 Reviews)

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 More

$50 USD in 3 days
(39 Reviews)

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

$155 USD in 3 days
(39 Reviews)

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

$100 USD in 5 days
(61 Reviews)

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 More

$180 USD in 3 days
(39 Reviews)

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 More

$155 USD in 3 days
(17 Reviews)

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

$277 USD in 8 days
(34 Reviews)

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 More

$155 USD in 3 days
(26 Reviews)

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.

$244 USD in 3 days
(18 Reviews)

Please message me. Please review my profile. I have 8. 11 years experience in MS SQL Server and 6.2 years experience in SSRS, SSIS (Import / Export). Please let m More

$49 USD in 5 days
(22 Reviews)

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 More

$155 USD in 3 days
(5 Reviews)
$244 USD in 3 days
(11 Reviews)

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 More

$200 USD in 3 days
(5 Reviews)
$222 USD in 7 days
(9 Reviews)

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 More

$300 USD in 3 days
(4 Reviews)

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 More

$155 USD in 3 days
(3 Reviews)

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 More

$222 USD in 5 days
(0 Reviews)