Ditutup

Update products in Bigcommerce via API using sql server table and ssis

Summary:

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

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

Kemahiran: API, BigCommerce, SQL, SSIS (SQL Server Integration Services)

Lihat lagi: 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, save image sql server table using java, 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, insert update delete in vb.net using sql server 2008, insert update delete in asp.net using sql server, python update sql server table, how to load xml file into sql server table using ssis, update sql server table from excel spreadsheet, how to monitor sql server table changes by using c#?, how to monitor sql server table changes by using c#

Tentang Majikan:
( 0 ulasan )

ID Projek: #19868549

11 pekerja bebas membida secara purata $200 untuk pekerjaan ini

seemasit

Hi, I read your project requirement carefully and I understand your project but I want to ask a few questions before mover further so that I can deliver you exact work with one shoot. I always deliver quality with on Lagi

$155 USD dalam 7 hari
(3 Ulasan)
5.0
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. I have good skills in php, html, css, ajax with custom CMS. So I can help you if you want. Hope to work with Lagi

$140 USD dalam 7 hari
(8 Ulasan)
4.4
sreenivas2903

HI I am expertise in etl processing using ssis , i am interested to work on this project and also give you the accurate package required for your project. ping me if you would like to work with me. i am expert in ssis Lagi

$140 USD dalam 3 hari
(14 Ulasan)
4.2
markninja

Hello, I will update products in Bigcommerce via API using sql server table and ssis but I have questions which I want you to answer. Recent bigcommerce sites developed by me: [login to view URL] [login to view URL] Lagi

$220 USD dalam 7 hari
(2 Ulasan)
3.9
jayantavkumar

Let me tell you the reason why I am charging 350$...I need to use for each loop to process each and every record one by one. One by one record is needed only why you need to continue for next record to be process and f Lagi

$350 USD dalam 7 hari
(6 Ulasan)
3.4
khanicha

You are correct, it is an easy job, just need to have an error counter in case the api reach the limit, and then reschedule for next request

$111 USD dalam sehari
(2 Ulasan)
2.8
Mdware

Hi I am very competent and experienced SQL server and SSIS Developer. I have designed, written and implemented hundreds of data/SSIS/ETL BI solutions, data models, data marts and data warehouse (please have look at Lagi

$233 USD dalam 5 hari
(1 Ulasan)
1.0
gurramsunitha

 Over 7 years of IT experience in various domains as Developer that includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server Lagi

$222 USD dalam 3 hari
(1 Ulasan)
0.6
vyasabhaksar

hi I have 8 years of experience in ssis if you are interested we can discuss further. I will make sure the work will be completed on-time.

$222 USD dalam 10 hari
(0 Ulasan)
0.0
dhawansaahiljobs

Certified MSBI -Data Warehousing expert, active on Power BI and working in BI tools from last 9 years. Have already worked on the script as source excel files to various destinations. Relevant Skills and Experience Lagi

$250 USD dalam 10 hari
(0 Ulasan)
0.0
cianala

I am having 6 years of experience with ETL-SSIS and I have delivered 200+ SSIS packages along with automation.

$155 USD dalam 3 hari
(0 Ulasan)
0.0