Find Jobs
Hire Freelancers

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

$90-150 USD

キャンセル
投稿日: 11年近く前

$90-150 USD

完了時にお支払い
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 make 4 different Access macros: 1. Make an Access macro called "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 runs a pre-developed macro to append the new order data to "tbl_ order" and "tbl_orderline" tables). 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 "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 "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_Updt_tbl_product_ID_AMZ_API_OHQ", that uses an API to populate the field "tbl_product.AMZ_API_OHQ" . I am easy to work with and am hoping to find a reliable full time MS Access/VBA/Web developer for multiple projects. please see the attached mockup sample database I would like this project completed by July/22/13
プロジェクト ID: 4740131

プロジェクトについて

2個の提案
リモートプロジェクト
アクティブ 11年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に2人のフリーランサーが、平均$412 USDで入札しています
ユーザーアバター
I'm Microsoft certified with 15 years of experience. Can do this
$547 USD 30日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
bronx, United States
5.0
1
お支払い方法確認済み
メンバー登録日:5月 2, 2012

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。