Find Jobs
Hire Freelancers

API to integrate USPS, Ebay and Amazon with MS Access - repost 3

$30-250 USD

Diberikan
Dibuat lebih dari 10 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
Specs: The user is an online merchant, selling with ebay, Amazon. The user will process data with MS Access desktop apps that runs, forms, macros, queries, reports, that link to MySQL tables on his hosted web server... The user ships most product with USPS (USA Postal), integrating with [login to view URL] as the portal to batch export/import the shipping data i.e. shipping address, tracking# and to also print postage stamps and shipping labels. I need a developer to modify the attached mockup database and replace the MS Access tables and empty macros with MYSQL tables/API code that would be hosted on our web server. 1. there would be two API’s called: • "API_import_from_order_source_data_amazon", • "API_import_from_order_source_data_ebay" would run an API to import new customer-order data from the order sources Ebay and Amazon . The order data would be appended to the tables, "tbl_ebay", and "tbl_amazon" (the user already runs a pre-developed MS Access macro to append the new order data to "tbl_ order" and "tbl_orderline" tables, so making such a macro to append to the order and order line tables is NOT in your specs). the existing order source tables "tbl_ebay", and "tbl_amazon" must be modified in order to include all available API fields that are provided by the order source API, even if they are not currently included in the mockup tables. [login to view URL] a n API called "API_ _validate_shipping_address_with_USPS", that would update the Boolean "yes/no" data-type field "tbl_order.hold_invalid_adrs" to "True", only if ship-to address fields in "tbl_order" are identified as invalid by [login to view URL]'s address validation API. This is required because very often the customers don't supply a correct shipping address and [login to view URL] rejects the shipment if the address is invalid.... Please click link for related info: [login to view URL] 3. there would be two API’s called:: • " API_export_to_order_source_data_amazon and "API_export_to_order_source_data_ebay " that would run an API to export the shipping data from the MYSQL table "tbl_order" and export to the online order sources Ebay and Amazon, only if the field "tbl_order.tracking_nmbr_ID" is not null and the field "tbl_order.time_stamp_exported_to _order_source" is null. 4. The user also sometimes uses Amazon's "Fulfilled By Amazon" ("FBA" service) as a distribution center to warehouse and ship some of his product ( FYI [login to view URL]) and needs to run an API to inform him of FBA related data e.g. "Quantity-on-hand" in the Amazon Fulfillment Center, in order to monitor the stock level... Make an API called "API_fulfilled_by_amazon", that uses an API to populate the table " tbl_fulfilled_by_amazon" with all of the available fields available in Amazon's FBA API . I am easy to work with and am hoping to find a reliable full time MS Access/VBA/Web developer for multiple projects.
ID Proyek: 4888672

Tentang proyek

6 proposal
Proyek remot
Aktif 11 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
6 freelancer menawar dengan rata-rata $259 USD untuk pekerjaan ini
Avatar Pengguna
not able to open the attached db thanks
$277 USD dalam 3 hari
4,9 (275 ulasan)
6,6
6,6
Avatar Pengguna
Hoping is here.
$526 USD dalam 8 hari
4,9 (57 ulasan)
5,9
5,9
Avatar Pengguna
I can offer my high quality php programming services to you. phpXpertbd ready to start immediately. More details in PM. Thanks
$277 USD dalam 3 hari
4,7 (19 ulasan)
5,6
5,6
Avatar Pengguna
i'm 14+ years experienced with payment API(JSON/REST) integration knowledge, ready to start work
$210 USD dalam 8 hari
4,8 (26 ulasan)
5,1
5,1
Avatar Pengguna
Did something similar in the past
$155 USD dalam 3 hari
5,0 (3 ulasan)
2,2
2,2
Avatar Pengguna
hi sir, i can help you!
$111 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
bronx, United States
5,0
1
Memverifikasi Metode pembayaran
Anggota sejak Mei 2, 2012

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.