Find Jobs
Hire Freelancers

API to integrate USPS, Ebay, Amazon and E-Junkie with MS Access

$30-250 USD

Dibatalkan
Dibuat hampir 11 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
Specs: The user is an online merchant, selling with ebay, Amazon and e-junkie. The user processes data with MS Access tables, forms, macros, queries, reports... 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 VBA MS Access developer to modify the attached mockup database and make 4 different Access macros: 1. Make an Access macro called "API_macro_import_from_order_source_data", that would run an API to import new customer-order data from the order sources Ebay, Amazon and e-junkie. The order data would be appended to the tables, "tbl_ebay", "tbl_E-junkie" and "tbl_amazon" (the user already runs a pre-developed macro to append the new order data to "tbl_ order" and "tbl_orderline" tables, so making such a macroto append to the order and order line tables is not be in your specs). the existing order source tables "tbl_ebay", "tbl_E-junkie" and "tbl_amazon" must be remade in order to include all available API fields, even if they are not currently included in the tables. Please click link for related info: [login to view URL] 2. Make a macro called "API_macro_validate_shipping_address_with_USPS", that would update the "yes/no" data-type field "tbl_order.hold_invalid_adrrs" to "True", only if customer's ship-to address is 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. Make an Access macro called "API_macro_export_to_order_source_data", that would run an API to export the shipping data from the Access table "tbl_order", to the online order sources Ebay, Amazon and e-junkie, 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 uses Amazon also as a fulfillment (distribution) center to warehouse and ship some of his product and needs to run an API to inform him of the "Qty-on-hand" in the Amazon Fullfilment Center, in order to monitor the stock level... Make a macro called "macro_API_Updt_tbl_product_ID_AMZ_API_OHQ", that uses an API to populate the field "tbl_product.AMZ_API_OHQ" . We are easy to work with and am hoping to find a reliable full time MS Access/VBA/Web developer for multiple projects.
ID Proyek: 4792850

Tentang proyek

3 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
3 freelancer menawar dengan rata-rata $241 USD untuk pekerjaan ini
Avatar Pengguna
Hi, I am interested in working with you on this project. I cannot see the attacked mockup database. Also, who are your end users? I feel MS Access is not the most friendly or most flexible approach to this problem. I am happy to discuss with you further. Regards, Taner
$250 USD dalam 7 hari
5,0 (1 ulasan)
2,5
2,5
Avatar Pengguna
Hello, with more than 10 years experience in a multinational company developing database and web platform driven by a database, I'm really keen to participate to your project and start a new business relationship. Please check my PM for further information. Kinds Regards
$222 USD dalam 3 hari
5,0 (1 ulasan)
1,0
1,0

Tentang klien

Bendera EGYPT
Cairo, Egypt
4,9
160
Anggota sejak Agu 6, 2008

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.