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.
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 !
22 freelancers are bidding on average $180 for this job
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
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
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.